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 | 3 years ago
  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 | 3 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 | 3 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 | 1 year 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