Importing a Backup to while installing JIra

[Aniruddh Rawat]

facing a problem with importing to last backup data while re-installing jira....

the backup file is not installing properly and m getting some database column length error problem ....need ans ASAP

[Danyal Iqbal]

Which version are these?

Post the detatiled log snippet.

[Aniruddh Rawat]

here is logged bug...what i do is solve is "i unzip the file and set the specified column size as -1 and then zip it again" but after  there appears same bug but with a different table name...

pls help 

com.atlassian.activeobjects.spi.ActiveObjectsImportExportException: There was an error during import/export with <unknown plugin> (table AO_60DB71_SWIMLANE):Could not import data in table 'AO_60DB71_SWIMLANE' column #6, value is too big for column which size limit is 191, value is:
issuetype in (Requirement, Bug) AND status in (Assigned, Fixed,Reopened, Exit) OR issuetype in (Task, Sub-task, "Technical task") AND status not in (Done, Deferred, "Done & checked") AND assignee in (membersOf(jira-developers))

at com.atlassian.activeobjects.backup.ImportExportErrorServiceImpl.newImportExportException(ImportExportErrorServiceImpl.java:24)
at com.atlassian.dbexporter.importer.DataImporter$BaseInserter.setString(DataImporter.java:388)
at com.atlassian.dbexporter.importer.DataImporter$BaseInserter.setValue(DataImporter.java:436)
at com.atlassian.dbexporter.importer.DataImporter.importTable(DataImporter.java:125)
at com.atlassian.dbexporter.importer.DataImporter.access$000(DataImporter.java:35)
at com.atlassian.dbexporter.importer.DataImporter$1.call(DataImporter.java:75)
at com.atlassian.dbexporter.importer.DataImporter$1.call(DataImporter.java:64)
at com.atlassian.dbexporter.jdbc.JdbcUtils.withConnection(JdbcUtils.java:31)
at com.atlassian.dbexporter.importer.DataImporter.doImportNode(DataImporter.java:63)
at com.atlassian.dbexporter.importer.AbstractImporter.importNode(AbstractImporter.java:49)
at com.atlassian.dbexporter.DbImporter.importData(DbImporter.java:73)
at com.atlassian.activeobjects.backup.ActiveObjectsBackup.restore(ActiveObjectsBackup.java:158)
at com.atlassian.jira.bc.dataimport.DefaultDataImportService.restoreActiveObjects(DefaultDataImportService.java:504)
at com.atlassian.jira.bc.dataimport.DefaultDataImportService.performImport(DefaultDataImportService.java:691)
at com.atlassian.jira.bc.dataimport.DefaultDataImportService.doImport(DefaultDataImportService.java:300)
at com.atlassian.jira.web.action.setup.DataImportAsyncCommand.call(DataImportAsyncCommand.java:66)
at com.atlassian.jira.web.action.setup.DataImportAsyncCommand.call(DataImportAsyncCommand.java:29)
at com.atlassian.jira.task.ImportTaskManagerImpl$TaskCallableDecorator.call(ImportTaskManagerImpl.java:179)
at com.atlassian.jira.task.ImportTaskManagerImpl$TaskCallableDecorator.call(ImportTaskManagerImpl.java:150)
at java.util.concurrent.FutureTask.run(FutureTask.java:266)
at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:511)
at java.util.concurrent.FutureTask.run(FutureTask.java:266)
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)
at java.lang.Thread.run(Thread.java:745)

[Danyal Iqbal]

• Unzip your backup set

• Locate the activeobjects.xml 

• Identify the column causing the issue
  

  • <column name="CONTENT" primaryKey="false" autoIncrement="false" sqlType="12" precision="255"/>

• Change the Precision to -1, as so:
  
  • <column name="CONTENT" primaryKey="false" autoIncrement="false" sqlType="12" precision="-1"/>
• Re-zip both activeobjects.xml and entities.xml files
• Retry operation