Installing add-on fails with ORA-01400: cannot insert NULL into AO_6384AB_FEATURE_METADATA_AO
プラットフォームについて: 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 は除く
問題
Add-on fails to install via UPM.
The following appears in the atlassian-confluence.log
2016-04-12 13:02:50,389 ERROR [UpmAsynchronousTaskManager:thread-1] [atlassian.event.internal.AsynchronousAbleEventDispatcher] run There was an exception thrown trying to dispatch event [com.atlassian.plugin.event.events.PluginModuleEnabledEvent for com.comalatech.workflow:overview (null)] from the invoker [com.atlassian.confluence.event.ConfluenceListenerHandlersConfiguration$TimingListenerHandler$1$1@3cc9928d]
-- url: /rest/plugins/1.0/ | referer: http://confluence.example.com/plugins/servlet/upm | userName: jiraadmin
java.lang.RuntimeException: There was a SQL exception thrown by the Active Objects library:
Database:
- name:Oracle
- version:Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production
With the Partitioning, Real Application Clusters, Automatic Storage Management, OLAP,
Advanced Analytics and Real Application Testing options
- minor version:1
- major version:12
Driver:
- name:Oracle JDBC driver
- version:12.1.0.2.0
java.sql.SQLIntegrityConstraintViolationException: ORA-01400: cannot insert NULL into ("CONFLUENCE"."AO_6384AB_FEATURE_METADATA_AO"."ID")
at com.atlassian.event.internal.SingleParameterMethodListenerInvoker.invoke(SingleParameterMethodListenerInvoker.java:54)診断
環境
- Oracle データベース
Diagnostic Steps
- Check the sequences of the database user
- Compare the last number for the 'AO_6384AB_FEATURE_M675681913' sequence with the latest ID of the 'AO_6384AB_FEATURE_METADATA_AO' table
原因
The sequence is out of sync with the latest ID in the 'AO_6384AB_FEATURE' table.
回避策
The sequence and table can be dropped and recreated to get back in sync.
データベースの変更を行う場合は必ず事前にバックアップを取得してください。可能な場合は、まずステージング サーバーで SQL コマンドの変更、挿入、更新、または削除を行うようにします。
- Confluence を停止します。
- Back up the database.
Drop Sequence AO_6384AB_FEATURE_M675681913 and table
DROP SEQUENCE AO_6384AB_FEATURE_M675681913; DROP TABLE AO_6384AB_FEATURE_METADATA_AO;- Confluence を起動します。
- Install add-on.
最終更新日 2016 年 4 月 22 日
Powered by Confluence and Scroll Viewport.