com.atlassian.dbexporter.jdbc.ImportExportSqlException: The following sql caused an error: CREATE TABLE "AO_7A05D7_USER_ACHIEVEMENT" ( "ACHIEVEMENT_ID" INTEGER, "CREATED_ON" TIMESTAMP(29,6), "ID" SERIAL, "NOTIFIED" BOOLEAN, "USER_WRAPPER_ID" INTEGER, PRIMARY KEY("ID") ) ---

Atlassian JIRA | Jeff Turner (Unused account) | 5 years ago
  1. 0

    Importing an XML backup into JIRA 4.4.1, the import fails with the error: !jira_importerror_ao.png! and in the logs: {noformat} 2012-02-28 10:21:22,022 JiraImportTaskExecutionThread-1 ERROR anonymous 619x6x1 p4yysk 0:0:0:0:0:0:0:1 /secure/SetupImport.jspa [jira.bc.dataimport.DefaultDataImportService] Error importing data: com.atlassian.dbexporter.jdbc.ImportExportSqlException: The following sql caused an error: CREATE TABLE "AO_7A05D7_USER_ACHIEVEMENT" ( "ACHIEVEMENT_ID" INTEGER, "CREATED_ON" TIMESTAMP(29,6), "ID" SERIAL, "NOTIFIED" BOOLEAN, "USER_WRAPPER_ID" INTEGER, PRIMARY KEY("ID") ) --- com.atlassian.dbexporter.jdbc.ImportExportSqlException: The following sql caused an error: CREATE TABLE "AO_7A05D7_USER_ACHIEVEMENT" ( "ACHIEVEMENT_ID" INTEGER, "CREATED_ON" TIMESTAMP(29,6), "ID" SERIAL, "NOTIFIED" BOOLEAN, "USER_WRAPPER_ID" INTEGER, PRIMARY KEY("ID") ) --- at com.atlassian.activeobjects.backup.ActiveObjectsTableCreator.create(ActiveObjectsTableCreator.java:83) at com.atlassian.activeobjects.backup.ActiveObjectsTableCreator.create(ActiveObjectsTableCreator.java:55) at com.atlassian.dbexporter.importer.TableDefinitionImporter.doImportNode(TableDefinitionImporter.java:47) at com.atlassian.dbexporter.importer.AbstractImporter.importNode(AbstractImporter.java:45) at com.atlassian.dbexporter.DbImporter.importData(DbImporter.java:74) at com.atlassian.activeobjects.backup.ActiveObjectsBackup.restore(ActiveObjectsBackup.java:152) at com.atlassian.jira.bc.dataimport.DefaultDataImportService.restoreActiveObjects(DefaultDataImportService.java:347) at com.atlassian.jira.bc.dataimport.DefaultDataImportService.performImport(DefaultDataImportService.java:479) at com.atlassian.jira.bc.dataimport.DefaultDataImportService.doImport(DefaultDataImportService.java:209) at com.atlassian.jira.web.action.setup.DataImportAsyncCommand.call(DataImportAsyncCommand.java:65) at com.atlassian.jira.web.action.setup.DataImportAsyncCommand.call(DataImportAsyncCommand.java:28) at com.atlassian.jira.task.ImportTaskManagerImpl$TaskCallableDecorator.call(ImportTaskManagerImpl.java:147) at java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:303) at java.util.concurrent.FutureTask.run(FutureTask.java:138) at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:441) at java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:303) at java.util.concurrent.FutureTask.run(FutureTask.java:138) at com.atlassian.multitenant.impl.DefaultMultiTenantManager.runForTenant(DefaultMultiTenantManager.java:61) at com.atlassian.multitenant.juc.MultiTenantExecutors$WrappedRunnable.run(MultiTenantExecutors.java:160) at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:886) at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:908) at java.lang.Thread.run(Thread.java:662) Caused by: org.postgresql.util.PSQLException: ERROR: syntax error at or near "," ?Error importing {noformat}

    Atlassian JIRA | 5 years ago | Jeff Turner
    com.atlassian.dbexporter.jdbc.ImportExportSqlException: The following sql caused an error: CREATE TABLE "AO_7A05D7_USER_ACHIEVEMENT" ( "ACHIEVEMENT_ID" INTEGER, "CREATED_ON" TIMESTAMP(29,6), "ID" SERIAL, "NOTIFIED" BOOLEAN, "USER_WRAPPER_ID" INTEGER, PRIMARY KEY("ID") ) ---
  2. 0

    Importing an XML backup into JIRA 4.4.1, the import fails with the error: !jira_importerror_ao.png! and in the logs: {noformat} 2012-02-28 10:21:22,022 JiraImportTaskExecutionThread-1 ERROR anonymous 619x6x1 p4yysk 0:0:0:0:0:0:0:1 /secure/SetupImport.jspa [jira.bc.dataimport.DefaultDataImportService] Error importing data: com.atlassian.dbexporter.jdbc.ImportExportSqlException: The following sql caused an error: CREATE TABLE "AO_7A05D7_USER_ACHIEVEMENT" ( "ACHIEVEMENT_ID" INTEGER, "CREATED_ON" TIMESTAMP(29,6), "ID" SERIAL, "NOTIFIED" BOOLEAN, "USER_WRAPPER_ID" INTEGER, PRIMARY KEY("ID") ) --- com.atlassian.dbexporter.jdbc.ImportExportSqlException: The following sql caused an error: CREATE TABLE "AO_7A05D7_USER_ACHIEVEMENT" ( "ACHIEVEMENT_ID" INTEGER, "CREATED_ON" TIMESTAMP(29,6), "ID" SERIAL, "NOTIFIED" BOOLEAN, "USER_WRAPPER_ID" INTEGER, PRIMARY KEY("ID") ) --- at com.atlassian.activeobjects.backup.ActiveObjectsTableCreator.create(ActiveObjectsTableCreator.java:83) at com.atlassian.activeobjects.backup.ActiveObjectsTableCreator.create(ActiveObjectsTableCreator.java:55) at com.atlassian.dbexporter.importer.TableDefinitionImporter.doImportNode(TableDefinitionImporter.java:47) at com.atlassian.dbexporter.importer.AbstractImporter.importNode(AbstractImporter.java:45) at com.atlassian.dbexporter.DbImporter.importData(DbImporter.java:74) at com.atlassian.activeobjects.backup.ActiveObjectsBackup.restore(ActiveObjectsBackup.java:152) at com.atlassian.jira.bc.dataimport.DefaultDataImportService.restoreActiveObjects(DefaultDataImportService.java:347) at com.atlassian.jira.bc.dataimport.DefaultDataImportService.performImport(DefaultDataImportService.java:479) at com.atlassian.jira.bc.dataimport.DefaultDataImportService.doImport(DefaultDataImportService.java:209) at com.atlassian.jira.web.action.setup.DataImportAsyncCommand.call(DataImportAsyncCommand.java:65) at com.atlassian.jira.web.action.setup.DataImportAsyncCommand.call(DataImportAsyncCommand.java:28) at com.atlassian.jira.task.ImportTaskManagerImpl$TaskCallableDecorator.call(ImportTaskManagerImpl.java:147) at java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:303) at java.util.concurrent.FutureTask.run(FutureTask.java:138) at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:441) at java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:303) at java.util.concurrent.FutureTask.run(FutureTask.java:138) at com.atlassian.multitenant.impl.DefaultMultiTenantManager.runForTenant(DefaultMultiTenantManager.java:61) at com.atlassian.multitenant.juc.MultiTenantExecutors$WrappedRunnable.run(MultiTenantExecutors.java:160) at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:886) at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:908) at java.lang.Thread.run(Thread.java:662) Caused by: org.postgresql.util.PSQLException: ERROR: syntax error at or near "," ?Error importing {noformat}

    Atlassian JIRA | 5 years ago | Jeff Turner (Unused account)
    com.atlassian.dbexporter.jdbc.ImportExportSqlException: The following sql caused an error: CREATE TABLE "AO_7A05D7_USER_ACHIEVEMENT" ( "ACHIEVEMENT_ID" INTEGER, "CREATED_ON" TIMESTAMP(29,6), "ID" SERIAL, "NOTIFIED" BOOLEAN, "USER_WRAPPER_ID" INTEGER, PRIMARY KEY("ID") ) ---

    Root Cause Analysis

    1. com.atlassian.dbexporter.jdbc.ImportExportSqlException

      The following sql caused an error: CREATE TABLE "AO_7A05D7_USER_ACHIEVEMENT" ( "ACHIEVEMENT_ID" INTEGER, "CREATED_ON" TIMESTAMP(29,6), "ID" SERIAL, "NOTIFIED" BOOLEAN, "USER_WRAPPER_ID" INTEGER, PRIMARY KEY("ID") ) ---

      at com.atlassian.activeobjects.backup.ActiveObjectsTableCreator.create()
    2. com.atlassian.activeobjects
      ActiveObjectsTableCreator.create
      1. com.atlassian.activeobjects.backup.ActiveObjectsTableCreator.create(ActiveObjectsTableCreator.java:83)
      2. com.atlassian.activeobjects.backup.ActiveObjectsTableCreator.create(ActiveObjectsTableCreator.java:55)
      2 frames
    3. com.atlassian.dbexporter
      DbImporter.importData
      1. com.atlassian.dbexporter.importer.TableDefinitionImporter.doImportNode(TableDefinitionImporter.java:47)
      2. com.atlassian.dbexporter.importer.AbstractImporter.importNode(AbstractImporter.java:45)
      3. com.atlassian.dbexporter.DbImporter.importData(DbImporter.java:74)
      3 frames
    4. com.atlassian.activeobjects
      ActiveObjectsBackup.restore
      1. com.atlassian.activeobjects.backup.ActiveObjectsBackup.restore(ActiveObjectsBackup.java:152)
      1 frame
    5. com.atlassian.jira
      ImportTaskManagerImpl$TaskCallableDecorator.call
      1. com.atlassian.jira.bc.dataimport.DefaultDataImportService.restoreActiveObjects(DefaultDataImportService.java:347)
      2. com.atlassian.jira.bc.dataimport.DefaultDataImportService.performImport(DefaultDataImportService.java:479)
      3. com.atlassian.jira.bc.dataimport.DefaultDataImportService.doImport(DefaultDataImportService.java:209)
      4. com.atlassian.jira.web.action.setup.DataImportAsyncCommand.call(DataImportAsyncCommand.java:65)
      5. com.atlassian.jira.web.action.setup.DataImportAsyncCommand.call(DataImportAsyncCommand.java:28)
      6. com.atlassian.jira.task.ImportTaskManagerImpl$TaskCallableDecorator.call(ImportTaskManagerImpl.java:147)
      6 frames
    6. Java RT
      FutureTask.run
      1. java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:303)
      2. java.util.concurrent.FutureTask.run(FutureTask.java:138)
      3. java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:441)
      4. java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:303)
      5. java.util.concurrent.FutureTask.run(FutureTask.java:138)
      5 frames
    7. com.atlassian.multitenant
      MultiTenantExecutors$WrappedRunnable.run
      1. com.atlassian.multitenant.impl.DefaultMultiTenantManager.runForTenant(DefaultMultiTenantManager.java:61)
      2. com.atlassian.multitenant.juc.MultiTenantExecutors$WrappedRunnable.run(MultiTenantExecutors.java:160)
      2 frames
    8. Java RT
      Thread.run
      1. java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:886)
      2. java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:908)
      3. java.lang.Thread.run(Thread.java:662)
      3 frames