Update from 2.08 to 2.1 with sqlite

[johan_t]

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

[lindeamon]

hi victor,

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

[johan_t]

@lindeamon said in Update from 2.08 to 2.1 with sqlite:

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

[lindeamon]

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

[johan_t]

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

[victor]

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