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
tip
Your exception is missing from the Samebug knowledge base.
Here are the best solutions we found on the Internet.
Click on the to mark the helpful solution and get rewards for you help.
  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