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

Atlassian JIRA | Boris Berenberg | 4 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

    XML restore for certain DBs seems to fail. It works without issue on PostgreSQL. {code}2013-10-16 14:53:39,794 JiraImportTaskExecutionThread-1 ERROR admin 893x1747x1 14hteje fe80:0:0:0:8249:71ff:fe12:a58f%5 /secure/admin/XmlRestore.jspa [jira.bc.dataimport.DefaultDataImportService] Error during ActiveObjects restore 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) ... 20 more{code}

    Atlassian JIRA | 4 years ago | Boris Berenberg [Atlassian]
    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) )'
  2. 0

    XML restore for certain DBs seems to fail. It works without issue on PostgreSQL. {code}2013-10-16 14:53:39,794 JiraImportTaskExecutionThread-1 ERROR admin 893x1747x1 14hteje fe80:0:0:0:8249:71ff:fe12:a58f%5 /secure/admin/XmlRestore.jspa [jira.bc.dataimport.DefaultDataImportService] Error during ActiveObjects restore 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) ... 20 more{code}

    Atlassian JIRA | 4 years ago | Boris Berenberg
    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) )'
  3. 0

    [SCO-20] java.sql.SQLException: Unexpected token: COUNT in statement - Sakai

    sakaiproject.org | 2 years ago
    java.sql.SQLException: Unexpected token: COUNT in statement
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

  5. 0

    Riot-skeleton 9.1: import.sql?

    Google Groups | 6 years ago | Jan Weinschenker
    java.sql.SQLException: Table not found: RIOT_CONTENT_CONTAINERS in statement [alter table riot_content_containers]
  6. 0

    Loading data into Essbase with ODI

    Oracle Community | 9 years ago | 632076
    java.sql.SQLException: Unexpected token: HSP_RATES in statement [select 'HSP_InputValue' ""HSP_Rates]

    Not finding the right solution?
    Take a tour to get the most out of Samebug.

    Tired of useless tips?

    Automated exception search integrated into your IDE

    Root Cause Analysis

    1. 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()
    2. HSQLDB
      jdbcStatement.fetchResult
      1. org.hsqldb.jdbc.Util.sqlException(Unknown Source)
      2. org.hsqldb.jdbc.jdbcStatement.fetchResult(Unknown Source)
      2 frames
    3. org.apache.tomcat
      DelegatingStatement.executeUpdate
      1. org.apache.tomcat.dbcp.dbcp.DelegatingStatement.executeUpdate(DelegatingStatement.java:228)
      2. org.apache.tomcat.dbcp.dbcp.DelegatingStatement.executeUpdate(DelegatingStatement.java:228)
      2 frames
    4. com.atlassian.activeobjects
      SqlUtils.executeUpdate
      1. com.atlassian.activeobjects.backup.SqlUtils.executeUpdate(SqlUtils.java:37)
      1 frame