2.1 DB upgrade fails, MS SQL Server

Started by par.abrahamsson, July 10, 2017, 03:16:09 PM

Previous topic - Next topic

par.abrahamsson

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


par.abrahamsson

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.

lindeamon

cheers,

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

Best,
Lindeamon

Victor Kirhenshtein

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

Best regards,
Victor