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

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

1 answer

This widget could not be displayed.

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.

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

Suggest an answer

Log in or Sign up to answer
Atlassian Summit 2018

Meet the community IRL

Atlassian Summit is an excellent opportunity for in-person support, training, and networking.

Learn more
Community showcase
Posted Wednesday in Teamwork

What teamwork quotes inspire you?

Hey everyone! My name is Natalie and I'm an editor of the Atlassian Blog and I've got a question for you: What's your favorite quote about teamwork?  We've compiled a list here, along with...

161 views 16 7
Join discussion

Atlassian User Groups

Connect with like-minded Atlassian users at free events near you!

Find a group

Connect with like-minded Atlassian users at free events near you!

Find my local user group

Unfortunately there are no AUG chapters near you at the moment.

Start an AUG

You're one step closer to meeting fellow Atlassian users at your local meet up. Learn more about AUGs

Groups near you