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") ) ---

Searched on Google with the first line of a JAVA stack trace?

We can recommend more relevant solutions and speed up debugging when you paste your entire stack trace with the exception message. Try a sample exception.

Recommended solutions based on your search

Solutions on the web

via Atlassian JIRA by Jeff Turner (Unused account), 1 year ago
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") ) ---
via Atlassian JIRA by Jeff Turner, 1 year ago
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)

Users with the same issue

You are the first who have seen this exception. Write a tip to help other users and build your expert profile.

Know the solutions? Share your knowledge to help other developers to debug faster.