This discussion has been locked. The information referenced herein may be inaccurate due to age, software updates, or external references.
You can no longer post new replies to this discussion. If you have a similar question you can start a new discussion in this forum.

NPM 2023.1.0 Upgrade Feedback Thread

I pulled the trigger and updated to 2023.1.0. from 2022.4 last week.

Updated a single polling engine with NPM & NTA that monitors 400 nodes.

Install went smooth using the My Deployment - Updates Wizard.

haven't seen any issues over the last week I believe that is related to update.

how did you install go, did you get an issues you logged with support, if so what are the ticket numbers?

Parents
  • Tried the install via the My Deployments - Updates Wizard. Got to 95% and things slowed down progress bar got to 97% after 15mins and then the installation failed with the error...

    "Database configuration failed: Error while executing script- Cannot insert the value NULL into column 'Id', table 'NetPerfMon.dbo.CLM_CloudJobSettings'; column does not allow nulls. INSERT fails. The statement has been terminated."

    I was upgrading from 2022.4.0

Reply
  • Tried the install via the My Deployments - Updates Wizard. Got to 95% and things slowed down progress bar got to 97% after 15mins and then the installation failed with the error...

    "Database configuration failed: Error while executing script- Cannot insert the value NULL into column 'Id', table 'NetPerfMon.dbo.CLM_CloudJobSettings'; column does not allow nulls. INSERT fails. The statement has been terminated."

    I was upgrading from 2022.4.0

Children
  • Found the SQL commands failing in the ConfigurationWizard.Log file and ran them manually in SQL Management Studio. They worked fine so not sure why they failed during the above install. Deleted the CLM_CloudJobSettings table and ran the Configuration Wizard manually. This time the database configuration completed fine. The Configuration Wizard went on to finish fine on my primary polling engine.

  • The installation then failed on my Additional Poller: 

    "Error 1303. The installer has insufficient privileges to access this directory: C:\Program Files (x86)\SolarWinds\Orion\Erlang\24.3.4.4\erts-12.3.2.4\bin. The installation cannot continue. Log on as administrator or contact your system administrator.
    MSI (s) (9C:44) [05:29:58:666]: Product: SolarWinds Platform -- Error 1303. The installer has insufficient privileges to access this directory: C:\Program Files (x86)\SolarWinds\Orion\Erlang\24.3.4.4\erts-12.3.2.4\bin. The installation cannot continue. Log on as administrator or contact your system administrator."

  • My Deployment now shows additional poller as unreachable so won't allow me to attempt to download the offline installer for 2023.1. No download available via Customer Portal so have had to log a support ticket.

  • Can you share the ticket number on the inability to upgrade your poller? 

    Note the previous error you saw about inserting NULL into column "id" was fixed in the GA release of 2023.1 (GA now). 

  • Ran into similar issue with unable to access folder to delete files. I checked and the folders were already empty. Turns out I had to reboot and rerun the installer. Since the uninstall already completed, I was concerned, but the installer picked up right where it needed to be and complete the install.  I did call support and they also suggested that the reboot was the only method around that. 

  • I had similar issues moving from 2020.2.6 to 2023.1.1. First error in the wizard was with the FlowEngines table (I think it tried to recreate a default that already existed or something). Then because it failed after partially applying the DP updates, subsequent Config Wizard runs cause various errors. I was able to easily find all the SQL errors that led me to drop these objects by searching the various Config Wizard logs (C:\ProgramData\SolarWinds\Logs\Orion\ConfigurationWizard.log) for the following string: Failing Sql command:

    I eventually dropped the following objects to get the config wizard to move past the DB update and finish the upgrade.

    ALTER TABLE [dbo].[Accounts] DROP CONSTRAINT [DF_Accounts_ToolsetIntegration]
    go
    drop view dbo.IPAM_CloudAccountSettings
    go
    DROP TABLE [dbo].[CLM_CloudJobSettings]
    go