Print Page - 2.1 DB upgrade fails, MS SQL Server

Title: 2.1 DB upgrade fails, MS SQL Server
Post by: par.abrahamsson on July 10, 2017, 03:16:09 PM

Hi! After upgrade from 2.0 to 2.1 (Windows Server 2008 R2 with SQL Server 2008 R2) the services wont start and when reading logs it's because the DB is in wrong version.

Trying to rung dbmbgr upgrade ends in this:

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

Title: Re: 2.1 DB upgrade fails, MS SQL Server
Post by: par.abrahamsson on July 10, 2017, 06:46:09 PM

Solved or, at least we came through the problem. We deleted the data in the tables reporting the errors and then the db-upgrade worked.

Title: Re: 2.1 DB upgrade fails, MS SQL Server
Post by: lindeamon on July 10, 2017, 09:48:40 PM

cheers,

victor, as you can see, the upgrade happens in several tables.
defiantly needs to be checked...

Best,
Lindeamon

Title: Re: 2.1 DB upgrade fails, MS SQL Server
Post by: Victor Kirhenshtein on July 12, 2017, 11:08:59 AM

Can somebody please run upgrade with -t option and post output? Also, content of failed table before upgrade could be helpful.

Best regards,
Victor

NetXMS Support Forum

English Support => General Support => Topic started by: par.abrahamsson on July 10, 2017, 03:16:09 PM