Print Page - Update from 2.08 to 2.1 with sqlite

Title: Update from 2.08 to 2.1 with sqlite
Post by: johan_t on July 10, 2017, 02:02:05 PM

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

Title: Re: Update from 2.08 to 2.1 with sqlite
Post by: 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/ (https://www.netxms.org/forum/installation/upgrade-to-v2-1-withembedded-sqlite/)

Title: Re: Update from 2.08 to 2.1 with sqlite
Post by: johan_t on July 11, 2017, 11:22:19 AM

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/ (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/upgrade-to-2-1-m-3-failed/)
https://www.netxms.org/forum/installation/v2-1-m1-upgrade-problem/ (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/profile/?area=showposts;sa=messages;u=54860)
https://www.netxms.org/forum/installation/2-1-db-upgrade-fails-ms-sql-server/ (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/ (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

Title: Re: Update from 2.08 to 2.1 with sqlite
Post by: lindeamon on July 11, 2017, 12:33:09 PM

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

Title: Re: Update from 2.08 to 2.1 with sqlite
Post by: johan_t on July 11, 2017, 02:27:39 PM

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

Title: Re: Update from 2.08 to 2.1 with sqlite
Post by: Victor Kirhenshtein on July 12, 2017, 11:07:50 AM

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

NetXMS Support Forum

English Support => General Support => Topic started by: johan_t on July 10, 2017, 02:02:05 PM