Forums

Articles
Create
cancel
Showing results for 
Search instead for 
Did you mean: 
  • Community
  • Products
  • Confluence
  • Questions
  • Exported space from OnDemand and cannot import into local instance -- Database exception encountered while trying to update identifier table

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

Larry Talley
Contributor
June 13, 2012

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
Atlassian Team
Atlassian Team members are employees working across the company in a wide variety of roles.
January 9, 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
TAGS
atlassian, loom, loom for training, loom for teaching, video training, async learning, online education, screen recording, loom tutorials, loom use cases, atlassian learning, team training tools, instructional video, virtual training tools

🛗 Elevate Your Training and Enablement with Loom

Join us June 26, 11am PT for a webinar with Atlassian Champion Robert Hean & Loom’s Brittany Soinski. Hear tips, stories, and get your burning questions answered. Learn how Loom makes training and enablement easier. Don’t miss it!

Register today
AUG Leaders

Atlassian Community Events