Importing a Backup to while installing JIra

Aniruddh Rawat February 20, 2018

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

1 comment

Danyal Iqbal
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
February 20, 2018

Which version are these?

Post the detatiled log snippet.

Aniruddh Rawat February 20, 2018

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
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
February 21, 2018
  • 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

Comment

Log in or Sign up to comment
TAGS
AUG Leaders

Atlassian Community Events