Active Objects tables created without Indexes or Identity Columns
プラットフォームについて: Server および Data Center のみ。この記事は、Server および Data Center プラットフォームのアトラシアン製品にのみ適用されます。
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.
*Fisheye および Crucible は除く
問題
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.
診断
環境
- MS SQL Server database
- jTDS driver
原因
Root cause is currently undefined, but the tables were not created with primary key columns.
ソリューション
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_ENTRY
AO_7A45FB_AOTRACKING_RESULT
AO_7A45FB_AOTRACKING_USER
- Start Bamboo
最終更新日 2017 年 5 月 11 日
Powered by Confluence and Scroll Viewport.