Project import fails with ParseException error for missing fields in Jira server

関連コンテンツ

  • 関連コンテンツがありません

お困りですか?

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

コミュニティに質問

症状

Project import fails complaining about some customfieldvalues not mapped to any issue

atlassian-jira.log に次のエラーが返される。

2012-06-20 21:36:32,487 JiraTaskExectionThread-3 WARN admin 1296x491x1 1dqndhd 10.60.1.160 /secure/admin/ProjectImportSelectProject.jspa [imports.project.handler.ChainedSaxHandler] Encountered a parsing exception.
com.atlassian.jira.exception.ParseException: No 'issue' field for CustomFieldValue '474431'.
    at com.atlassian.jira.imports.project.parser.CustomFieldValueParserImpl.parse(CustomFieldValueParserImpl.java:46)
    at com.atlassian.jira.imports.project.handler.CustomFieldMapperHandler.handleEntity(CustomFieldMapperHandler.java:34)
    at com.atlassian.jira.imports.project.handler.ChainedSaxHandler.endTopLevelElement(ChainedSaxHandler.java:239)
    at com.atlassian.jira.imports.project.handler.ChainedSaxHandler.endElement(ChainedSaxHandler.java:184)
    at com.atlassian.jira.imports.project.handler.ChainedSaxHandler.endElement(ChainedSaxHandler.java:139)
    at org.apache.xerces.parsers.AbstractSAXParser.endElement(Unknown Source)
    at org.apache.xerces.parsers.AbstractXMLDocumentParser.emptyElement(Unknown Source)
    at org.apache.xerces.impl.XMLDocumentFragmentScannerImpl.scanStartElement(Unknown Source)
    at org.apache.xerces.impl.XMLDocumentFragmentScannerImpl$FragmentContentDispatcher.dispatch(Unknown Source)
    at org.apache.xerces.impl.XMLDocumentFragmentScannerImpl.scanDocument(Unknown Source)
    at org.apache.xerces.parsers.XML11Configuration.parse(Unknown Source)
    at org.apache.xerces.parsers.XML11Configuration.parse(Unknown Source)
    at org.apache.xerces.parsers.XMLParser.parse(Unknown Source)
    at org.apache.xerces.parsers.AbstractSAXParser.parse(Unknown Source)
    at org.apache.xerces.jaxp.SAXParserImpl$JAXPSAXParser.parse(Unknown Source)
    at org.apache.xerces.jaxp.SAXParserImpl.parse(Unknown Source)
    at com.atlassian.jira.imports.xml.DefaultBackupXmlParser.parseBackupXml(DefaultBackupXmlParser.java:51)
    at com.atlassian.jira.imports.project.DefaultProjectImportManager.getProjectImportData(DefaultProjectImportManager.java:292)
    at com.atlassian.jira.bc.imports.project.DefaultProjectImportService.getProjectImportData(DefaultProjectImportService.java:610)
    at com.atlassian.jira.web.action.admin.importer.project.ProjectImportSelectProject$MappingResultCallable.call(ProjectImportSelectProject.java:244)

診断

Run the below SQL query to retrieve those customfield values:

SELECT * FROM customfieldvalue WHERE issue IS NULL;

原因

One or more custom fields has a null value in a field where an issue ID is expected.

ソリューション

  1. Complete a full restore to a temporary JIRA instance.

  2. Run this SQL in the temporary JIRA instance to delete the rows with null issue references:

    DELETE FROM customfieldvalue WHERE issue IS NULL;
  3. Create a new XML backup from the temporary instance and use it to complete your project import.

Alternate method (on source instance):

  1. Jira を停止します。
  2. Make a clone of the Jira database.
  3. Modify the dbconfig.xml file to point to the cloned database.
  4. Remove the null values from the cloned database.
  5. Jira を起動します。
  6. Create a new backup.
  7. Jira を停止します。
  8. Point it back to the original database in the dbconfig.xml file.
  9. Jira を起動します。


JRASERVER-34373 - 課題詳細を取得中... ステータス

最終更新日: 2021 年 2 月 25 日

この内容はお役に立ちましたか?

はい
いいえ
この記事についてのフィードバックを送信する

関連コンテンツ

  • 関連コンテンツがありません
Powered by Confluence and Scroll Viewport.