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

0 votes
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 Tuesday in United States

Topic Tuesday: What's your favorite topic?

Good morning All, Our goal is to get you into the habit of while enjoying your favorite morning drink you are checking the NOVA "space" for topics and comments. Your input is really needed and...

62 views 4 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