NetXMS Support Forum

Hi,

after upgrade netxms-2.0.8-x64 on Windows server 2012 R2 to version 2.1 (X64) the core-service won't start. I didn't recognize any errors at the installation. After the installation was done and the Service netXMS Core did not came up the eventviewer says

"Protokollname: System
Quelle:        NetXMSCore
Datum:         10.07.2017 12:15:33
Ereignis-ID:   63
Aufgabenkategorie:Keine
Ebene:         Fehler
Schlüsselwörter:Klassisch
Beschreibung:
Your database has format version 410, but server is compiled for version 456

if i try to upgrade the database via commandshell i get


C:\NetXMS\bin>nxdbmgr.exe upgrade
NetXMS Database Manager Version 2.1 Build 9012 (2.1-RELEASE) (UNICODE)

Upgrading database...
Upgrading from version 410 to 411
Converting table tdata_111: failed
Rolling back last stage due to upgrade errors...
Database upgrade failed

what can i Do? Are there more debugging options?

Best regards,

Johan

hi victor,

this is the same error i got.
https://www.netxms.org/forum/installation/upgrade-to-v2-1-withembedded-sqlite/

Quote from: lindeamon on July 10, 2017, 02:05:29 PM
hi victor,

this is the same error i got.
https://www.netxms.org/forum/installation/upgrade-to-v2-1-withembedded-sqlite/

there are more with an error converting DB-Version 410 to 411:

https://www.netxms.org/forum/installation/upgrade-to-2-1-m-3-failed/
https://www.netxms.org/forum/installation/v2-1-m1-upgrade-problem/
https://www.netxms.org/forum/profile/?area=showposts;sa=messages;u=54860
https://www.netxms.org/forum/installation/2-1-db-upgrade-fails-ms-sql-server/

other DB-Versions:
https://www.netxms.org/forum/installation/upgrade-to-2-0-8/
and so on

but i could not find any working solution.

is that db-thing a pending issue?

Best Regards

Johan

i have used "nxdbmgr upgrade -X" and it worked.
the only thing that bothers me about it, is what data i am missing in the process.

i suggest, backing up the db before the upgrade, running the upgrade with -X and check for data corruption.

Best,
Lindeamon

thank you lindeamon!

Converting faild for tdata_111, 115, 187,.... to 942.

But the Core-Service starts.

It looks okay to me.

I tell if i find missing data

best regards,

Johan

Hi,

tdata tables holds table DCI values, so you should check your table DCIs. If you don't use them then everything should be fine.

Best regards,
Victor