Upgrade Error BANDANACONTEXT

Question

Hello there,

i try to upgrade our confluence from 3.2 to 3.5.17. i followed the instructions given by atlassian.  unfortunatly confluence does not start after upgrade and i get this error in atlassian-log:

2019-09-18 15:49:34,376 ERROR [main] [atlassian.confluence.upgrade.UpgradeLauncherServletContextListener] contextInitialized 1 errors were encountered during upgrade:

2019-09-18 15:49:34,376 ERROR [main] [atlassian.confluence.upgrade.UpgradeLauncherServletContextListener] contextInitialized 1: StatementCallback; uncategorized SQLException for SQL [alter table BANDANA alter column BANDANACONTEXT varchar(255) not null]; SQL state [S1000]; error code [5074]; The index 'BANDANA_band_context_idx' is dependent on column 'BANDANACONTEXT'.; nested exception is java.sql.SQLException: The index 'BANDANA_band_context_idx' is dependent on column 'BANDANACONTEXT'.

2019-09-18 15:49:35,047 INFO [main] [com.atlassian.confluence.lifecycle] init Confluence is ready to serve

2019-09-18 15:50:42,986 INFO [Thread-20] [atlassian.plugin.manager.DefaultPluginManager] shutdown Shutting down the plugin system

2019-09-18 15:50:43,065 INFO [Thread-20] [com.atlassian.confluence.lifecycle] contextDestroyed Stopping Confluence

Does anyone has a good idea?

Database is on an seperate SQL Database-server

Thanks for your help

Phillipp

Phillipp Speth · Answer

now confluence asks for changing a lot of DB-entries from bigint to numeric (0,19)

Phillipp Speth · Answer

Update:

we found out to drop indexes for the following entries.

DROP INDEX [BANDANA_band_context_idx] ON [dbo].[BANDANA]

GO

/****** Object:  Index [BANDANA_band_key_idx]    Script Date: 19.09.2019 13:25:53 ******/

DROP INDEX [BANDANA_band_key_idx] ON [dbo].[BANDANA]

then the confluence setup continues and stops with new error.

It seems to be a lot of entries where we have to change.

was there a change on sheme for mssql database?

exicsts maybe a script for changing the necassary items?

Best regards

phillipp