Exported space from OnDemand and cannot import into local instance -- Database exception encountered while trying to update identifier table

[Larry Talley]

I had a space hosted in OnDemand for a week or so, and now would like to re-locate that space to our inside-the-firewall instance. The inside version of Confluence is 4.2.

I exported the space as XML and downloaded the file, then tried to import a space in my local instance, and get this exception:

2012-06-13 11:35:17,552 INFO read-only-transaction:thread-1 atlassian.confluence.user.DefaultUserAccessor getUserNamesWithConfluenceAccess Could not find group configured with USE permission: null

2012-06-13 11:35:38,565 INFO Long running task: Importing data confluence.importexport.actions.ImportLongRunningTask runInternal Beginning import by user ltalley

2012-06-13 11:35:40,952 ERROR Long running task: Importing data confluence.importexport.actions.ImportLongRunningTask runInternal Failure during import

-- url: /confluence/admin/restore.action | userName: ltalley | referer: https://internal.fakr.noaa.gov/confluence/admin/backup.action | action: restore

com.atlassian.confluence.importexport.ImportExportException: Database exception encountered while trying to update identifier table: java.sql.SQLSyntaxErrorException: ORA-00942: table or view does not exist

at com.atlassian.confluence.importexport.xmlimport.HibernateHiLoIdFixer.fixHiLoTable(HibernateHiLoIdFixer.java:133)

at com.atlassian.confluence.importexport.xmlimport.BackupImporter.resetIdentifierGenerators(BackupImporter.java:316)

at com.atlassian.confluence.importexport.xmlimport.BackupImporter.importEverything(BackupImporter.java:304)

at com.atlassian.confluence.importexport.xmlimport.FileBackupImporter.importEverything(FileBackupImporter.java:106)

at com.atlassian.confluence.importexport.xmlimport.BackupImporter$1.doInTransactionWithoutResult(BackupImporter.java:151)

at org.springframework.transaction.support.TransactionCallbackWithoutResult.doInTransaction(TransactionCallbackWithoutResult.java:33)

at org.springframework.transaction.support.TransactionTemplate.execute(TransactionTemplate.java:128)

at com.atlassian.confluence.importexport.xmlimport.BackupImporter.doImportInternal(BackupImporter.java:143)

at com.atlassian.confluence.importexport.Importer.doImport(Importer.java:75)

at com.atlassian.confluence.importexport.DefaultImportExportManager.doImport(DefaultImportExportManager.java:67)

at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)

at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)

at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)

at java.lang.reflect.Method.invoke(Method.java:597)

at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:307)

at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:182)

at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:149)

at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:106)

at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171)

at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:204)

at $Proxy80.doImport(Unknown Source)

at com.atlassian.confluence.importexport.actions.ImportLongRunningTask.runInternal(ImportLongRunningTask.java:81)

at com.atlassian.confluence.util.longrunning.ConfluenceAbstractLongRunningTask.run(ConfluenceAbstractLongRunningTask.java:21)

at com.atlassian.confluence.util.longrunning.ManagedTask.run(ManagedTask.java:35)

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

Caused by: java.sql.SQLSyntaxErrorException: ORA-00942: table or view does not exist

at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:445)

at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:396)

at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:879)

at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:450)

at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:192)

at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:531)

at oracle.jdbc.driver.T4CStatement.doOall8(T4CStatement.java:193)

at oracle.jdbc.driver.T4CStatement.executeForDescribe(T4CStatement.java:873)

at oracle.jdbc.driver.OracleStatement.executeMaybeDescribe(OracleStatement.java:1167)

at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1289)

at oracle.jdbc.driver.OracleStatement.executeQuery(OracleStatement.java:1491)

at oracle.jdbc.driver.OracleStatementWrapper.executeQuery(OracleStatementWrapper.java:406)

at com.mchange.v2.c3p0.impl.NewProxyStatement.executeQuery(NewProxyStatement.java:35)

at com.atlassian.confluence.importexport.xmlimport.HibernateHiLoIdFixer.fixHiLoTable(HibernateHiLoIdFixer.java:93)

... 29 more

[Gary]

Hi Larry,

You will want to make sure your standalone local version is running the OD version of Confluence - you can download it here:

http://www.atlassian.com/software/confluence/download-od

OnDemand is running a 5.x version of Confluence, so the base version needs to match before you try importing again.

Cheers,

Gary