com.atlassian.activeobjects.spi.ActiveObjectsImportExportException: There was an error during import/export with plugin JIRA Service Desk(com.atlassian.servicedesk) #1.0.1-SNAPSHOT (table AO_54307E_SERVICEDESK):There has been a SQL exception importing row #0 for table 'AO_54307E_SERVICEDESK' see the cause of this exception for more detail about it.

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 Edward Zhang [Atlassian], 1 year ago
There was an error during import/export with plugin JIRA Service Desk(com.atlassian.servicedesk) #1.0.1-SNAPSHOT (table AO_54307E_SERVICEDESK):There has been a SQL exception importing row #0 for table 'AO_54307E_SERVICEDESK' see the cause of this exception for more detail about it.
via Atlassian JIRA by Edward Zhang [Atlassian], 1 year ago
There was an error during import/export with plugin JIRA Service Desk(com.atlassian.servicedesk) #1.0.1-SNAPSHOT (table AO_54307E_SERVICEDESK):There has been a SQL exception importing row #0 for table 'AO_54307E_SERVICEDESK' see the cause of this exception for more detail about it.
via atlassian.com by Unknown author, 2 years ago
There was an error during /export with plugin JIRA Service Desk(com.atlassian.servicedesk) #1.0.1-SNAPSHOT (table AO_54307E_SERVICEDESK):There has been a SQL exception importing row #0 table 'AO_54307E_SERVICEDESK' see the cause of exception more detail about it.
via Atlassian JIRA by Ivana Kojovic, 1 year ago
There was an error during import/export with plugin Confluence Space IA (Left Sidebar)(com.atlassian.confluence.plugins.confluence-space-ia) #5.1 (table AO_187CCC_SIDEBAR_LINK):There has been a SQL exception importing row #0 for table 'AO_187CCC_SIDEBAR_LINK' see the cause of this exception for more detail about it.
via Atlassian JIRA by Ivana Kojovic, 1 year ago
There was an error during import/export with plugin Confluence Space IA (Left Sidebar)(com.atlassian.confluence.plugins.confluence-space-ia) #5.1 (table AO_187CCC_SIDEBAR_LINK):There has been a SQL exception importing row #0 for table 'AO_187CCC_SIDEBAR_LINK' see the cause of this exception for more detail about it.
java.sql.SQLException: Invalid column type: 16
at oracle.jdbc.driver.OracleStatement.getInternalType(OracleStatement.java:3879)
at oracle.jdbc.driver.OraclePreparedStatement.setNullCritical(OraclePreparedStatement.java:4406)
at oracle.jdbc.driver.OraclePreparedStatement.setNull(OraclePreparedStatement.java:4388)
at oracle.jdbc.driver.OraclePreparedStatementWrapper.setNull(OraclePreparedStatementWrapper.java:993)
at org.apache.commons.dbcp.DelegatingPreparedStatement.setNull(DelegatingPreparedStatement.java:108)
at org.apache.commons.dbcp.DelegatingPreparedStatement.setNull(DelegatingPreparedStatement.java:108)
at com.atlassian.dbexporter.importer.DataImporter$BaseInserter.setBoolean(DataImporter.java:344)
at com.atlassian.dbexporter.importer.DataImporter$BaseInserter.setValue(DataImporter.java:413)
at com.atlassian.dbexporter.importer.DataImporter.importTable(DataImporter.java:123)
at com.atlassian.dbexporter.importer.DataImporter.access$000(DataImporter.java:33)
at com.atlassian.dbexporter.importer.DataImporter$1.call(DataImporter.java:73)
at com.atlassian.dbexporter.importer.DataImporter$1.call(DataImporter.java:62)
at com.atlassian.dbexporter.jdbc.JdbcUtils.withConnection(JdbcUtils.java:31)
at com.atlassian.dbexporter.importer.DataImporter.doImportNode(DataImporter.java:61)
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:439)
at com.atlassian.jira.bc.dataimport.DefaultDataImportService.performImport(DefaultDataImportService.java:627)
at com.atlassian.jira.bc.dataimport.DefaultDataImportService.doImport(DefaultDataImportService.java:251)
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:439)
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:895)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:918)
at java.lang.Thread.run(Thread.java:680)

Users with the same issue

535 times, 1 month ago
Samebug visitor profile picture
Unknown user
Once, 1 year ago
Samebug visitor profile picture
Unknown user
Once, 1 year ago

Write tip

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