Upgrade 2020.2.6 to 2022.4.1 Configuration Wizard db Error

kendali

I have ticket 01255641 open with Solarwinds now, but coming to the collective in case you have a resolution faster then they can get back to me. Upgrading offline server for NPM and NTA. Everything seemed to run smooth and get to Configuration Wizard and receive the following error:

Orion Database FAILED

Database configuration failed:

  * Error while executing script - Invalid column name 'LastDateRunUtc'.

Invalid column name 'LastDateRunUtc'.

Invalid column name 'NextDateRunUtc'

.I've seen some references to the invalid column name, but I'm not able to find any info on what table this column may be associated with or what I need to do to clear this and allow the wizard to continue.

I have a snapshot I can roll back too, but hoping to just straight up resolve.

kendali

UPDATE - The support tech was very efficient and attentive, I was just horribly impatient. I was provided with a script that dropped the NCM tables and recreated them. Thinking hard about this now I believe at one time we had NCM installed as a trial for a dev environment we had, but it is no longer used anymore. I tried very hard to self resolve this and do some research to find out what table those columns belonged to, but honestly - just open a ticket. I have a much larger environment I'll be updating shortly that I will begin a dialogue with support before actually doing the upgrade so hopefully any issues can be resolved quickly.