ORA-00932 SQL exception on Jira DVCS connector

お困りですか?

アトラシアン コミュニティをご利用ください。

コミュニティに質問

プラットフォームについて: Server と 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.