Error when attempting to upgrade Refined for Confluence | Sites & Themes plug-in
Platform Notice: Data Center Only - This article only applies to Atlassian products on the Data Center platform.
Note that this KB was created for the Data Center version of the product. Data Center KBs for non-Data-Center-specific features may also work for Server versions of the product, however they have not been tested. Support for Server* products ended on February 15th 2024. If you are running a Server product, you can visit the Atlassian Server end of support announcement to review your migration options.
*Except Fisheye and Crucible
Summary
Upgrading Refined for Confluence | Sites & Themes plug-in fails, preventing plug-in operation and sometimes resulting in Confluence startup issues. Plug-in failures and startup issues will be followed by handleUpdateError Exception executing SQL update <ALTER TABLE AO_A3F2EF_LAYOUT_VERSION ALTER COLUMN VERSION_NUMBER INTEGER NOT NULL> error.
Environment
MS SQL DB
Diagnosis
The following error is thrown in the application logs
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
INFO [UpmAsynchronousTaskManager:thread-1] [atlassian.plugin.manager.DefaultPluginManager] updatePlugin Updating plugin 'com.refinedwiki.confluence.plugins.theme.original' from version '6.1.16' to version '6.1.17'
INFO [UpmAsynchronousTaskManager:thread-1] [atlassian.plugin.manager.DefaultPluginManager] broadcastPluginDisabling Disabling com.refinedwiki.confluence.plugins.theme.original
ERROR [active-objects-init-system tenant-0] [net.java.ao.sql] handleUpdateError Exception executing SQL update <ALTER TABLE AO_A3F2EF_LAYOUT_VERSION ALTER COLUMN VERSION_NUMBER INTEGER NOT NULL>
com.microsoft.sqlserver.jdbc.SQLServerException: Cannot insert the value NULL into column 'VERSION_NUMBER', table 'GKN_Confluence_wiki_test.dbo.AO_A3F2EF_LAYOUT_VERSION'; column does not allow nulls. UPDATE fails.
at com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDatabaseError(SQLServerException.java:260)
at com.microsoft.sqlserver.jdbc.SQLServerStatement.getNextResult(SQLServerStatement.java:1547)
at com.microsoft.sqlserver.jdbc.SQLServerStatement.doExecuteStatement(SQLServerStatement.java:857)
at com.microsoft.sqlserver.jdbc.SQLServerStatement$StmtExecCmd.doExecute(SQLServerStatement.java:757)
at com.microsoft.sqlserver.jdbc.TDSCommand.execute(IOBuffer.java:7342)
at com.microsoft.sqlserver.jdbc.SQLServerConnection.executeCommand(SQLServerConnection.java:2688)
at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeCommand(SQLServerStatement.java:224)
at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeStatement(SQLServerStatement.java:204)
at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeUpdate(SQLServerStatement.java:685)
at com.mchange.v2.c3p0.impl.NewProxyStatement.executeUpdate(NewProxyStatement.java:410)
at net.java.ao.DatabaseProvider.executeUpdate(DatabaseProvider.java:2246)
at net.java.ao.DatabaseProvider.executeUpdateForAction(DatabaseProvider.java:2302)
at net.java.ao.DatabaseProvider.executeUpdatesForActions(DatabaseProvider.java:2274)
at net.java.ao.schema.SchemaGenerator.migrate(SchemaGenerator.java:91)
at net.java.ao.EntityManager.migrate(EntityManager.java:128)Cause
The upgrade process is attempting to insert NULL value into 'VERSION_NUMBER' column in plug-ins 'GKN_Confluence_wiki_test.dbo.AO_A3F2EF_LAYOUT_VERSION' table which does not allow such values. This action breaks plug-in on systems running MS SQL DB.
Solution
Uninstalling and then re-installing plug-in will resolve the problem.
No data will be lost as a result of plug-in re-install as it's stored on DB.
Was this helpful?