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, atlassian community, job interviews, interview tips, career advice, interview preparation, job search, interview experiences, hiring process, atlassian careers, community discussion, interview best practices

Interview Tips & Pet Peeves ✍️

Join the discussion on interview best practices and common pitfalls. Share your experiences and learn from others in the Atlassian Community.

Share you experiences!
AUG Leaders

Atlassian Community Events