Active Objects tables created without Indexes or Identity Columns
Platform notice: Server and Data Center only. This article only applies to Atlassian products on the Server and Data Center platforms.
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
Problem
After a new installation or database restore, you may receive errors such as the following in the atlassian-bamboo.log
java.sql.SQLException: 'pk_AO_7A45FB_AOTRACKING_ENTRY_TRACKING_ID' is not a constraint.
java.sql.SQLException: 'pk_AO_F36021_SONAR_SERVER_ENTITY_ID' is not a constraint.
java.sql.SQLException: 'pk_AO_88263F_HEALTH_CHECK_STATUS_ID' is not a constraint.Diagnosis
Environment
- MS SQL Server database
- jTDS driver
Cause
Root cause is currently undefined, but the tables were not created with primary key columns.
Resolution
Since these tables are created on Bamboo startup, please:
- Stop Bamboo
- Backup your Bamboo database
- Drop all Active Objects tables, which start with
AO_, eg:AO_7A45FB_AOTRACKING_ENTRYAO_7A45FB_AOTRACKING_RESULTAO_7A45FB_AOTRACKING_USER
- Start Bamboo
Last modified on May 11, 2017
Powered by Confluence and Scroll Viewport.