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

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

1 answer

This widget could not be displayed.
Gary Sackett Atlassian Team Jan 09, 2013

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

Suggest an answer

Log in or Sign up to answer
Community showcase
Posted Thursday in United States

Local Atlassian Research Workshop opportunity on Sep. 28th

We're looking for participants for another workshop at Atlassian! We need Jira admins who have interesting custom workflows, issue views, or boards. Think you have a story to sh...

72 views 0 0
View post

Atlassian User Groups

Connect with like-minded Atlassian users at free events near you!

Find a group

Connect with like-minded Atlassian users at free events near you!

Find my local user group

Unfortunately there are no AUG chapters near you at the moment.

Start an AUG

You're one step closer to meeting fellow Atlassian users at your local meet up. Learn more about AUGs

Groups near you