Error importing data: com.atlassian.activeobjects.spi.ActiveObjectsImportExportException

[Larry Talley]

I am migrating from a JIRA 4.4.5 instance to OnDemand.

I have an XML backup of the instance I am coming from, and I need to restore it on my PC instance of JIRA, then upgrade my PC instance, then make an XML backup to copy to webdav so you can import it.

When I try to restore the XML file on my PC instance of JIRA I get an error. I think possibly that the evaluation database doesn't support what the import process is trying to do, but that is just speculation.

Here is more of the error:

ortService Importing data is 90% complete...

2012-05-25 12:38:47,661 JiraImportTaskExecutionThread-1 INFO ltalley 758x324x1 4

lqp47 127.0.0.1 /secure/admin/XmlRestore.jspa jira.bc.dataimport.DefaultDataImp

ortService Finished storing Generic Values.

2012-05-25 12:38:47,661 JiraImportTaskExecutionThread-1 ERROR ltalley 758x324x1

4lqp47 127.0.0.1 /secure/admin/XmlRestore.jspa jira.bc.dataimport.DefaultDataIm

portService Error importing data: com.atlassian.activeobjects.spi.ActiveObjects

ImportExportException: There was an error during import/export with <unknown plu="" <="" p="">

gin>:The following sql caused an error:

CREATE TABLE PUBLIC.AO_60DB71_COLUMN (

ID BIGINT GENERATED BY DEFAULT AS IDENTITY (START WITH 1),

MAXIM DECIMAL(32,16),

MINIM DECIMAL(32,16),

NAME VARCHAR(255),

POS INTEGER,

RAPID_VIEW_ID BIGINT,

)

---

com.atlassian.activeobjects.spi.ActiveObjectsImportExportException: There was an

error during import/export with <unknown plugin="">:The following sql caused an er

ror:

CREATE TABLE PUBLIC.AO_60DB71_COLUMN (

ID BIGINT GENERATED BY DEFAULT AS IDENTITY (START WITH 1),

MAXIM DECIMAL(32,16),

MINIM DECIMAL(32,16),

NAME VARCHAR(255),

POS INTEGER,

RAPID_VIEW_ID BIGINT,

)

---

at com.atlassian.activeobjects.backup.ImportExportErrorServiceImpl.newIm

portExportSqlException(ImportExportErrorServiceImpl.java:32)

at com.atlassian.activeobjects.backup.ActiveObjectsTableCreator.create(A

ctiveObjectsTableCreator.java:90)

at com.atlassian.activeobjects.backup.ActiveObjectsTableCreator.create(A

ctiveObjectsTableCreator.java:61)

at com.atlassian.dbexporter.importer.TableDefinitionImporter.doImportNod

e(TableDefinitionImporter.java:48)

at com.atlassian.dbexporter.importer.AbstractImporter.importNode(Abstrac

tImporter.java:49)

at com.atlassian.dbexporter.DbImporter.importData(DbImporter.java:73)

at com.atlassian.activeobjects.backup.ActiveObjectsBackup.restore(Active

ObjectsBackup.java:158)

at com.atlassian.jira.bc.dataimport.DefaultDataImportService.restoreActi

[Larry Talley]

The SQL statement that the importer attempts to execute is flawed:

CREATE TABLE PUBLIC.AO_60DB71_COLUMN (ID BIGINT GENERATED BY DEFAULT AS IDENTITY (START WITH 1),MAXIM DECIMAL(32,16),MINIM DECIMAL(32,16),NAME VARCHAR(255),POS INTEGER,RAPID_VIEW_ID BIGINT,)

should be:

CREATE TABLE PUBLIC.AO_60DB71_COLUMN (ID BIGINT GENERATED BY DEFAULT AS IDENTITY (START WITH 1),MAXIM DECIMAL(32,16),MINIM DECIMAL(32,16),NAME VARCHAR(255),POS INTEGER,RAPID_VIEW_ID BIGINT)

but knowing that doesn't help. I executed the correct SQL statement and tried the import again but same result, so, it apparently drops the table before it tries to create it.

[G Karthikeyan]

Hi Larry, May I know how you corrected the SQL statement? Could you please provide the steps to do this?