Could not determine the proper mapping from Oracle export, for column:DEFAULT

お困りですか?

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

コミュニティに質問

プラットフォームについて: Server と Data Center のみ - この記事は、サーバーおよびデータセンター プラットフォームのアトラシアン製品にのみ適用されます。

問題

When trying to restore JIRA XML Backup on another instance, the stack trace below shown on the UI and atlassian-jira.log:

2015-08-17 22:37:19,306 JiraImportTaskExecutionThread-1 ERROR admin 1351x886x1 pb6o 127.0.0.1 /secure/admin/XmlRestore.jspa [jira.bc.dataimport.DefaultDataImportService] Error importing data: java.lang.IllegalStateException: Could not determine the proper mapping from Oracle export, for column:DEFAULT
java.lang.IllegalStateException: Could not determine the proper mapping from Oracle export, for column:DEFAULT
    at com.atlassian.activeobjects.backup.ActiveObjectsTableCreator.getSqlType(ActiveObjectsTableCreator.java:158)
    at com.atlassian.activeobjects.backup.ActiveObjectsTableCreator.isString(ActiveObjectsTableCreator.java:176)
    at com.atlassian.activeobjects.backup.ActiveObjectsTableCreator.getQualifiers(ActiveObjectsTableCreator.java:167)

診断

診断ステップ

  1. Extract the XML Backup using any archive program and open the activeobject.xml file.
  2. Search for the "Column" called DEFAULT.
  3. The following information should be found.

      <table name="AO_AEFED0_TEAM_ROLE">
        <column name="DEFAULT" primaryKey="false" autoIncrement="false" sqlType="2"/>
        <column name="I18N_KEY" primaryKey="false" autoIncrement="false" sqlType="12" precision="255"/>
        <column name="ID" primaryKey="true" autoIncrement="true" sqlType="2" precision="11"/>
        <column name="NAME" primaryKey="false" autoIncrement="false" sqlType="12" precision="255"/>
      </table>
    ...
      <data tableName="AO_AEFED0_TEAM_ROLE">
        <column name="I18N_KEY"/>
        <column name="ID"/>
        <column name="NAME"/>
        <column name="DEFAULT"/>
        <row>
          <string>tempo-teams.role.member</string>
          <integer>1</integer>
          <string>Member</string>
          <integer>1</integer>
        </row>

    (warning) The Mapping may vary to the version of the plugin. To create a new instance with the same version for JIRA and the plugin is advisable.

原因

The mapping and declaration of the Column is incorrect making the Import is not possible. The correct Column mapping and declaration for the Active Object above is:

  <table name="AO_AEFED0_TEAM_ROLE">
    <column name="DEFAULT" primaryKey="false" autoIncrement="false" sqlType="2" precision="1"/>
    <column name="I18N_KEY" primaryKey="false" autoIncrement="false" sqlType="12" precision="255"/>
    <column name="ID" primaryKey="true" autoIncrement="true" sqlType="2" precision="11"/>
    <column name="NAME" primaryKey="false" autoIncrement="false" sqlType="12" precision="255"/>
  </table>
...
  <data tableName="AO_AEFED0_TEAM_ROLE">
    <column name="DEFAULT"/>
    <column name="I18N_KEY"/>
    <column name="ID"/>
    <column name="NAME"/>
    <row>
      <boolean>true</boolean>
      <string>tempo-teams.role.member</string>
      <integer>1</integer>
      <string>Member</string>
    </row>

ソリューション

  1. Extract the XML Backup if it is not extracted yet and open the activeobject.xml file.
  2. Search for the "Column" called DEFAULT and you should find the table declaration.
  3. Replace it with:

      <table name="AO_AEFED0_TEAM_ROLE">
        <column name="DEFAULT" primaryKey="false" autoIncrement="false" sqlType="2" precision="1"/>
        <column name="I18N_KEY" primaryKey="false" autoIncrement="false" sqlType="12" precision="255"/>
        <column name="ID" primaryKey="true" autoIncrement="true" sqlType="2" precision="11"/>
        <column name="NAME" primaryKey="false" autoIncrement="false" sqlType="12" precision="255"/>
      </table>
  4. Search for the "Column" called DEFAULT again and there should be data mapping.
  5. Replace it with:

      <data tableName="AO_AEFED0_TEAM_ROLE">
        <column name="DEFAULT"/>
        <column name="I18N_KEY"/>
        <column name="ID"/>
        <column name="NAME"/>
        <row>
          <boolean>true</boolean>
          <string>tempo-teams.role.member</string>
          <integer>1</integer>
          <string>Member</string>
        </row>
        <row>
          <boolean>false</boolean>
          <string>tempo-teams.role.product.owner</string>
          <integer>2</integer>
          <string>Product Owner</string>
        </row>
        <row>
          <boolean>false</boolean>
          <string>tempo-teams.role.scrum.master</string>
          <integer>3</integer>
          <string>Scrum Master</string>
        </row>
        <row>
          <boolean>false</boolean>
          <string>tempo-teams.role.developer</string>
          <integer>4</integer>
          <string>Developer</string>
        </row>
        <row>
          <boolean>false</boolean>
          <string>tempo-teams.role.designer</string>
          <integer>5</integer>
          <string>Designer</string>
        </row>
        <row>
          <boolean>false</boolean>
          <string>tempo-teams.role.tester</string>
          <integer>6</integer>
          <string>Tester</string>
        </row>
        <row>
          <boolean>false</boolean>
          <string>tempo-teams.role.technical.writer</string>
          <integer>7</integer>
          <string>Technical Writer</string>
        </row>
        <row>
          <boolean>false</boolean>
          <string>tempo-teams.role.business.analyst</string>
          <integer>8</integer>
          <string>Business Analyst</string>
        </row>
      </data>
  6. Save the file and compressed the file again.
  7. Import the edited XML Backup again to check for effect.
Last modified on Mar 30, 2016

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

はい
いいえ
この記事についてのフィードバックを送信する
Powered by Confluence and Scroll Viewport.