Project Does not Exist Error When Trying to Use the Jira Cloud Migration Assistant
プラットフォームについて: Data Center のみ。 - This article only applies to Atlassian apps on the Data Center プラットフォーム。
この KB は Data Center バージョンの製品用に作成されています。Data Center 固有ではない機能の Data Center KB は、製品のサーバー バージョンでも動作する可能性はありますが、テストは行われていません。 Server* 製品のサポートは 2024 年 2 月 15 日に終了しました。Server 製品を実行している場合は、 アトラシアン Server サポート終了 のお知らせにアクセスして、移行オプションを確認してください。
*Fisheye および Crucible は除く
要約
My Jira environment uses a postgres database. When I try to migrate from on-prem to Jira Cloud, I encounter an error indicating that the table "PROJECT" does not exist.
環境
>=Jira 7.6.0 with a Postgres database。
診断
You will see an error similar to this appear on the Jira Cloud Migration App screen, and also in the atlassian-jira.log file.
com.querydsl.core.QueryException:
Caught PSQLException for select "PROJECT"."ID", "PROJECT"."PKEY", "PROJECT"."PNAME", "PROJECT"."PROJECTTYPE", "PROJECT"."LEAD", "issuecount", "lastactive", "totalattachmentsize", "totalattachmentcount", (select "PROJECTCATEGORY"."CNAME" from "PROJECTCATEGORY" "PROJECTCATEGORY" inner join "NODEASSOCIATION" "NODEASSOCIATION" on "PROJECTCATEGORY"."ID" = "NODEASSOCIATION"."SINK_NODE_ID"
where "NODEASSOCIATION"."SOURCE_NODE_ID" = "PROJECT"."ID" and "NODEASSOCIATION"."ASSOCIATION_TYPE" = ?) as "pcategory",
(select count(distinct "PROPERTYENTRY"."propertytype") from "PROPERTYENTRY" "PROPERTYENTRY" where "PROPERTYENTRY"."ENTITY_ID" = "PROJECT"."ID" and "PROPERTYENTRY"."PROPERTY_KEY" = ?) as "parchived"
from "PROJECT" "PROJECT"
left join (select "JIRAISSUE"."PROJECT", count(distinct "JIRAISSUE"."ID") as "issuecount", max("JIRAISSUE"."UPDATED") as "lastactive", sum("FILEATTACHMENT"."FILESIZE") as "totalattachmentsize", count("FILEATTACHMENT"."ID") as "totalattachmentcount" from "JIRAISSUE" "JIRAISSUE"
left join "FILEATTACHMENT" "FILEATTACHMENT" on "JIRAISSUE"."ID" = "FILEATTACHMENT"."ISSUEID" group by "JIRAISSUE"."PROJECT") as "ia" on "ia"."PROJECT" = "PROJECT"."ID"
where "PROJECT"."PROJECTTYPE" in (?, ?)
...
...
...
Caused by: org.postgresql.util.PSQLException: ERROR: relation "PROJECT" does not exist 原因
The query that Jira is trying to use while looking for Project related data is written with differing syntax and the table names, and parameters. The error occurs because the postgres database settings from the dbconfig.xml is missing the <schema-name> clause which effectively puts the database into "case sensitive" mode, invalidating the query from the JCMA plugin.
<?xml version="1.0" encoding="UTF-8"?>
<jira-database-config>
<name>defaultDS</name>
<delegator-name>default</delegator-name>
<database-type>postgres72</database-type>
<jdbc-datasource>
<url>jdbc:postgresql://[removed-by-support]/jira</url>
<driver-class>org.postgresql.Driver</driver-class>
<username>[removed-by-support]</username>
<password>[removed-by-support]</password>
<pool-min-size>30</pool-min-size>
<pool-max-size>30</pool-max-size>
<pool-max-wait>30000</pool-max-wait>
<validation-query>select 1</validation-query>
<min-evictable-idle-time-millis>60000</min-evictable-idle-time-millis>
<time-between-eviction-runs-millis>300000</time-between-eviction-runs-millis>
<pool-max-idle>30</pool-max-idle>
<pool-prepared-statements>true</pool-prepared-statements>
<pool-remove-abandoned>true</pool-remove-abandoned>
<pool-remove-abandoned-timeout>300</pool-remove-abandoned-timeout>
<pool-test-on-borrow>false</pool-test-on-borrow>
<pool-test-while-idle>true</pool-test-while-idle>
<connection-properties>tcpKeepAlive=true;socketTimeout=240</connection-properties>
</jdbc-datasource>
</jira-database-config>
ソリューション
Update your dbconfig.xml to include <schema-name>public</schema-name>
<?xml version="1.0" encoding="UTF-8"?>
<jira-database-config>
<name>defaultDS</name>
<delegator-name>default</delegator-name>
<database-type>postgres72</database-type>
<schema-name>public</schema-name>
<jdbc-datasource>
<url>jdbc:postgresql://[removed-by-support]/jira</url>
<driver-class>org.postgresql.Driver</driver-class>
<username>[removed-by-support]</username>
<password>[removed-by-support]</password>
<pool-min-size>30</pool-min-size>
<pool-max-size>30</pool-max-size>
<pool-max-wait>30000</pool-max-wait>
<validation-query>select 1</validation-query>
<min-evictable-idle-time-millis>60000</min-evictable-idle-time-millis>
<time-between-eviction-runs-millis>300000</time-between-eviction-runs-millis>
<pool-max-idle>30</pool-max-idle>
<pool-prepared-statements>true</pool-prepared-statements>
<pool-remove-abandoned>true</pool-remove-abandoned>
<pool-remove-abandoned-timeout>300</pool-remove-abandoned-timeout>
<pool-test-on-borrow>false</pool-test-on-borrow>
<pool-test-while-idle>true</pool-test-while-idle>
<connection-properties>tcpKeepAlive=true;socketTimeout=240</connection-properties>
</jdbc-datasource>
</jira-database-config>この内容はお役に立ちましたか?