Post reply

Upgrade in place error (2017 to 2019) - invalid name space.

  • November 29, 2021 at 8:56 pm

    #3958418

    Upgrade stops with an invalid namespace error (that was it, no error codes of any kind).  Retry fails.  then hit the Cancel button and the upgrade continued and finished.  This was in the SqEngineCongigAction_upgrade_config_Cpu64 phase.  This was a warning and the finish was all green.  I had uninstalled SSMS and rebooted before the upgrade.

    I looked in the error log but could find no messages about namespace.

    This was on a clone, not the production machine.  Clone is stand alone as is the production server.

    This was given a warning symbol only, not actually failing the installation.  Trying to find out what it's complaining about to know if this can be ignored or there will be some ramifications down the road.

    Has anyone run into this?

     

     

  • November 30, 2021 at 12:57 pm

    #3958646

    is SQLServer Configuration Manager working OK ?

    ref: configuration-manager-is-corrupt

    Johan

    Learn to play, play to learn !

    Dont drive faster than your guardian angel can fly ...
    but keeping both feet on the ground wont get you anywhere :w00t:

    - How to post Performance Problems
    - How to post data/code to get the best help[/url]

    - How to prevent a sore throat after hours of presenting ppt

    press F1 for solution, press shift+F1 for urgent solution 😀

    Need a bit of Powershell? How about this

    Who am I ? Sometimes this is me but most of the time this is me

  • December 10, 2021 at 3:58 pm

    #3962430

    Yes, SQL Server Configuration Manager still works.

  • December 10, 2021 at 5:17 pm

    #3962466

    I found the namespace errors.  Seem to be tied to reporting services.  Reporting Services was installed with SQL 2012 but was never set up and utilized.

    SQL Configuration Manager works.  Got all green at the end of the install.  I'm counting this as good.  Thanks for looking at it.

  • March 12, 2024 at 8:53 pm

    #4394180

     

    "before upgrade attempt”

    Go to

    C:\Program Files\Microsoft SQL Server\MSSQL12.MSSQLSERVER\MSSQL\Binn and run the command (cmd ad administrator)

    Mofcomp sqlwep-uni.mof.transformed

    This adds the ServerEvents\MSSQLSERVER under WMI    that was missing

    the in-place upgrade will now work without stopping on that part

     

    Attachments:
    You must be logged in to view attached files.

  • March 25, 2024 at 2:03 pm

    #4401655

    Thanks for sharing this thumathd. We hit the same issue recently when upgrading and this resolved the issue - good to have a clean install..

    • This reply was modified 1 month ago by  K.

Viewing 6 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic. Login to reply