Upgrade NTA 3.5 SL2000 to SLX - Database configuration failed

Question

When trying to upgrade NTA 3.5 from SL2000 to SLX I receive the error

"Database configuration failed:
• Error while executing script- There is already an object named 'swsp_GetCBQoSConfigurationDetails' in the database."

Now I'm getting the error event "A license check failed. Orion version does not match NetFlow Traffic Analyzer version. Please contact SolarWinds to purchase an upgrade of NetFlow Traffic Analyzer" Any idea why or what I should do?

aLTeReGo · Accepted Answer

The issue is caused by the stored procedure getting created under a different schema than dbo, for example SolarWindsNPM if this is the user account used to connect to the database.  To resolve this, you need to open the database in SQL Management Studio and run the following query:   Alter SCHEMA dbo transfer SolarWindsNPM.swsp_GetCBQoSConfigurationDetails   Just make sure to sub out SolarwindsNPM with the schema the procedure is associated with.  To see this, go to Programmability > Stored procedures.  This procedure will be at the end of the list.  If there are others as well that do not have dbo as the schema, then run the above query and sub out for the schema to change.  Once done, you can rerun the configuration wizard without error.