com.atlassian.activeobjects.spi.ActiveObjectsImportExportException

There was an error during import/export with plugin Atlassian JIRA - Plugins - Invite User(com.atlassian.jira.jira-invite-user-plugin) #1.13 (table AO_97EDAB_USERINVITATION):Error executing update for SQL statement 'CREATE TABLE PUBLIC.AO_97EDAB_USERINVITATION ( EXPIRY DATETIME, ID INTEGER GENERATED BY DEFAULT AS IDENTITY (START WITH 1), NVARCHAR(255) VARCHAR(255), REDEEMED BOOLEAN, SENDER_USERNAME VARCHAR(255), TOKEN VARCHAR(255), PRIMARY KEY(ID) )'

Samebug tips0

There are no available Samebug tips for this exception. If you know how to solve this issue, help other users by writing a short tip.

Don't give up yet. Paste your full stack trace to get a solution.

Solutions on the web29

  • via Atlassian JIRA by Boris Berenberg, 10 months ago
    There was an error during import/export with plugin Atlassian JIRA - Plugins - Invite User(com.atlassian.jira.jira-invite-user-plugin) #1.13 (table AO_97EDAB_USERINVITATION):Error executing update for SQL statement 'CREATE TABLE
  • via Atlassian JIRA by Boris Berenberg [Atlassian], 1 year ago
    There was an error during import/export with plugin Atlassian JIRA - Plugins - Invite User(com.atlassian.jira.jira-invite-user-plugin) #1.13 (table AO_97EDAB_USERINVITATION):Error executing update for SQL statement 'CREATE TABLE
  • via Atlassian JIRA by Jason Hinch [Atlassian], 1 year ago
    There was an error during import/export with plugin Atlassian Stash SSH Plugin(com.atlassian.stash.ssh-plugin) #2.0.4-SNAPSHOT (table AO_FB71B4_PUBLIC_KEY):Error executing update for SQL statement 'CREATE TABLE AO_FB71B4_PUBLIC_KEY ( ID INTEGER AUTO_INCREMENT, KEY_MD5 VARCHAR(255), KEY_TEXT TEXT, USER_ID INTEGER, PRIMARY KEY(ID) ) ENGINE=InnoDB'
  • Stack trace

    • com.atlassian.activeobjects.spi.ActiveObjectsImportExportException: There was an error during import/export with plugin Atlassian JIRA - Plugins - Invite User(com.atlassian.jira.jira-invite-user-plugin) #1.13 (table AO_97EDAB_USERINVITATION):Error executing update for SQL statement 'CREATE TABLE PUBLIC.AO_97EDAB_USERINVITATION ( EXPIRY DATETIME, ID INTEGER GENERATED BY DEFAULT AS IDENTITY (START WITH 1), NVARCHAR(255) VARCHAR(255), REDEEMED BOOLEAN, SENDER_USERNAME VARCHAR(255), TOKEN VARCHAR(255), PRIMARY KEY(ID) )' at com.atlassian.activeobjects.backup.ImportExportErrorServiceImpl.newImportExportSqlException(ImportExportErrorServiceImpl.java:30) at com.atlassian.activeobjects.backup.SqlUtils.onSqlException(SqlUtils.java:53) at com.atlassian.activeobjects.backup.SqlUtils.executeUpdate(SqlUtils.java:42) at com.atlassian.activeobjects.backup.ActiveObjectsTableCreator.create(ActiveObjectsTableCreator.java:84) at com.atlassian.activeobjects.backup.ActiveObjectsTableCreator.create(ActiveObjectsTableCreator.java:62) at com.atlassian.dbexporter.importer.TableDefinitionImporter.doImportNode(TableDefinitionImporter.java:50) 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:482) at com.atlassian.jira.bc.dataimport.DefaultDataImportService.performImport(DefaultDataImportService.java:688) at com.atlassian.jira.bc.dataimport.DefaultDataImportService.doImport(DefaultDataImportService.java:278) 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 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:439) at java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:303) at java.util.concurrent.FutureTask.run(FutureTask.java:138) at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:895) at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:918) at java.lang.Thread.run(Thread.java:695) Caused by: java.sql.SQLException: Wrong data type: ( in statement [CREATE TABLE PUBLIC.AO_97EDAB_USERINVITATION ( EXPIRY DATETIME, ID INTEGER GENERATED BY DEFAULT AS IDENTITY (START WITH 1), NVARCHAR(] at org.hsqldb.jdbc.Util.sqlException(Unknown Source) at org.hsqldb.jdbc.jdbcStatement.fetchResult(Unknown Source) at org.apache.tomcat.dbcp.dbcp.DelegatingStatement.executeUpdate(DelegatingStatement.java:228) at org.apache.tomcat.dbcp.dbcp.DelegatingStatement.executeUpdate(DelegatingStatement.java:228) at com.atlassian.activeobjects.backup.SqlUtils.executeUpdate(SqlUtils.java:37)

    Write tip

    You have a different solution? A short tip here would help you and many other users who saw this issue last week.

    Users with the same issue

    Unknown user
    Once, 11 months ago
    Unknown user
    Once, 1 year ago
    Unknown user
    Once, 1 year ago
    Unknown user
    Once, 1 year ago
    Unknown user
    Once, 1 year ago
    11 more bugmates