ORA-00932 SQL exception on Jira DVCS connector
プラットフォームについて: サーバーと Data Center のみ。この記事は、サーバーおよび Data Center プラットフォームのアトラシアン製品にのみ適用されます。
要約
When trying to connect Jira using Oracle database with a self-managed Gitlab or Github through DVCS connector the test connection fails with ORA-00932: inconsistent datatypes: expected - got CLOB on "AO_E8B6CC_REPOSITORY_MAPPING" table.
環境
Jira version <8.19 running Oracle 19c database
診断
The following message will be displayed on the atlassian-jira.log:
2021-09-02 14:35:25,071-0600 DVCSConnector.MessageExecutor:thread-3 ERROR tib2tib 875x2036x1 aaaaa x.x.x.x /rest/bitbucket/1.0/repository/10/softsync [c.a.j.p.d.service.message.MessageConsumer] Synchronization failed: There was a SQL exception thrown by the Active Objects library:
Database:
- name:Oracle
- version:Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production
- minor version:0
- major version:19
[...]
java.sql.SQLSyntaxErrorException: ORA-00932: inconsistent datatypes: expected - got CLOB
[...]
Caused by: Error : 932, Position : 333, Sql = SELECT "FORK_OF_SLUG","FORK_OF_OWNER","SMARTCOMMITS_ENABLED","DELETED","LOGO","SLUG","ACTIVITY_LAST_SYNC","NAME","FORK_OF_NAME","LINKED","LAST_CHANGESET_NODE","REMOTE_ID","REPOSITORY_URL","UPDATE_LINK_AUTHORISED","ID","ORGANIZATION_ID","LAST_COMMIT_DATE","FORK" FROM "AO_E8B6CC_REPOSITORY_MAPPING" WHERE "ORGANIZATION_ID" = :1 AND "REPOSITORY_URL" = :2 AND "DELETED" = :3 , OriginalSql = SELECT "FORK_OF_SLUG","FORK_OF_OWNER","SMARTCOMMITS_ENABLED","DELETED","LOGO","SLUG","ACTIVITY_LAST_SYNC","NAME","FORK_OF_NAME","LINKED","LAST_CHANGESET_NODE","REMOTE_ID","REPOSITORY_URL","UPDATE_LINK_AUTHORISED","ID","ORGANIZATION_ID","LAST_COMMIT_DATE","FORK" FROM "AO_E8B6CC_REPOSITORY_MAPPING" WHERE "ORGANIZATION_ID" = ? AND "REPOSITORY_URL" = ? AND "DELETED" = ? , Error Msg = ORA-00932: inconsistent datatypes: expected - got CLOB
原因
Known bug, no workarounds available.
ソリューション
Bug fixed in Jira 8.19.1 and later releases.
最終更新日 2021 年 11 月 26 日
Powered by Confluence and Scroll Viewport.