Uploaded image for project: 'Confluence Data Center'
  1. Confluence Data Center
  2. CONFSERVER-35969

XML space import failed from the latest OD for Oracle Database

      NOTE: This bug report is for Confluence Server. Using Confluence Cloud? See the corresponding bug report.

      Steps to replicate
      1. Install Confluence 5.6-OD-39-039 with Oracle database
      2. Take XML space backup from Confluence OD
      3. Restore the XML backup into Confluence 5.6-OD-39-039
      Observed Behavior

      Expected Behavior

      The restoration complete successfully without any error.

      Note:

      The import works on Embeded HSQL, MySQL, Postegres and MSSQL, in case you are hitting this you could use one of the other supported databases as a workaround.

      Workaround

      1. Delete any previously failed, half-imported space
      2. Run the following query in database:
        alter table
        CONTENT_PERM
        DISABLE constraint
        CP_UNIQUE_USER_GROUPS;
        
      3. Import Space
      4. Run the following query in database:
        alter table
        CONTENT_PERM
        ENABLE constraint
        CP_UNIQUE_USER_GROUPS;
        

        Please backup your database before running the above query.

        1. Confluence-space-export-EDIT_PERMISSIONS-2.xml.zip
          3.66 MB
        2. oracle.jpg
          oracle.jpg
          112 kB
        3. screenshot-1.png
          screenshot-1.png
          24 kB

            [CONFSERVER-35969] XML space import failed from the latest OD for Oracle Database

            Tomas added a comment -

            Same Problem in Version 7.4.8 from Cloud Export
            https://jira.atlassian.com/secure/AddComment!default.jspa?id=401192

            Tomas added a comment - Same Problem in Version 7.4.8 from Cloud Export https://jira.atlassian.com/secure/AddComment!default.jspa?id=401192

            Brian added a comment -

            Hi asgher.mohiuddin ~ If you're inquiring about purchasing Confluence and/or a Gliffy Plugin, please contact our Customer Advocates (Sales) at the following:

            • 415-701-1110, option 1
            • sales@atlassian.com

            Brian added a comment - Hi asgher.mohiuddin ~ If you're inquiring about purchasing Confluence and/or a Gliffy Plugin, please contact our Customer Advocates (Sales) at the following: 415-701-1110, option 1 sales@atlassian.com

            I would like to purchase. we already purchase the Jira from you. I am unable purchase it from your site. Any help is appreciated.

            https://www.atlassian.com/software/confluence
            https://marketplace.atlassian.com/plugins/com.gliffy.integration.confluence

            Thanks
            Asgher

            Asgher Mohiuddin added a comment - I would like to purchase. we already purchase the Jira from you. I am unable purchase it from your site. Any help is appreciated. https://www.atlassian.com/software/confluence https://marketplace.atlassian.com/plugins/com.gliffy.integration.confluence Thanks Asgher

            Nikita added a comment -


            The same problem with import the whole site from cloud to cloud.

            Nikita added a comment - The same problem with import the whole site from cloud to cloud.

            Any updates?
            for resolve?

            Gonchik Tsymzhitov added a comment - Any updates? for resolve?

            I have some issue.

            Gonchik Tsymzhitov added a comment - I have some issue.

            i'm getting the same issue.

            Mandeep Bal added a comment - i'm getting the same issue.

            We are facing this issue as well (running on 5.6.3 server-version importing spaces from cloud-instance). Do I understand it right, that we have to wait until server-version 5.7 is released in order to import spaces from our cloud-instance? When do you plan to release version 5.7? Thanks for your answer! Kevin

            Kevin Oehme added a comment - We are facing this issue as well (running on 5.6.3 server-version importing spaces from cloud-instance). Do I understand it right, that we have to wait until server-version 5.7 is released in order to import spaces from our cloud-instance? When do you plan to release version 5.7? Thanks for your answer! Kevin

            Brian added a comment -

            Hey there root3 ~

            You won't be able to import an OD backup straight into Confluence Server. Cloud releases are ahead of Server releases, and so may include schema changes that are not yet present in Server releases. You'll have to migrate to an intermediate OD release as described in Migrating from Confluence Cloud to Confluence Server, and then upgrade that to Confluence 5.7 when it's available.

            Brian added a comment - Hey there root3 ~ You won't be able to import an OD backup straight into Confluence Server. Cloud releases are ahead of Server releases, and so may include schema changes that are not yet present in Server releases. You'll have to migrate to an intermediate OD release as described in Migrating from Confluence Cloud to Confluence Server , and then upgrade that to Confluence 5.7 when it's available.

            btan-g2g added a comment -

            When I import an XML backup from OnDemand confluence to the confluence server hosted by myself, I got an error, From the log, seems something wrong with ID=41648133. And not sure if I am going to have some more issues with the backup. Error message as below:
            – referer: http://localhost:8090/admin/restore-local-file.action | url: /longrunningtaskxml.action | userName: admin | action: longrunningtaskxml
            2014-12-19 13:02:56,753 ERROR [Long running task: Importing data] [confluence.importexport.xmlimport.DefaultImportProcessor] persist Error while saving object: Imported[com.atlassian.confluence.pages.Attachment] [Id[id]=41648133, Property[title]=IT_0613_Move_Info.xlsx,
            Property[contentProperties]=, Property[version]=4, Property[creator]=com.atlassian.confluence.user.ConfluenceUserImpl[Id[key]=ff8080813fbbcbe9013fbbcc94370014], Property[creationDate]=2014-06-04 16:26:57.502, Property[lastModifier]=com.atlassian.confluence.user.Confluen
            ceUserImpl[Id[key]=ff8080813fbbcbe9013fbbcc94370014], Property[lastModificationDate]=2014-06-04 16:26:57.502, Property[versionComment]=, Property[originalVersion]=com.atlassian.confluence.pages.Attachment[Id[id]=41648129], Property[contentStatus]=, Property[containerCon
            tent]=com.atlassian.confluence.pages.Page[Id[id]=39584043]]
            – referer: http://localhost:8090/admin/restore-local-file.action | url: /longrunningtaskxml.action | userName: admin | action: longrunningtaskxml
            2014-12-19 13:02:56,754 ERROR [Long running task: Importing data] [confluence.importexport.xmlimport.BackupImporter] importEntities Cannot import the entities:
            – referer: http://localhost:8090/admin/restore-local-file.action | url: /longrunningtaskxml.action | userName: admin | action: longrunningtaskxml
            com.atlassian.confluence.importexport.ImportExportException: Unable to complete import: Error while importing backup: not-null property references a null or transient value: com.atlassian.confluence.pages.Attachment.contentType
            at com.atlassian.confluence.importexport.xmlimport.DefaultXmlImporter.doImport(DefaultXmlImporter.java:77)
            at com.atlassian.confluence.importexport.xmlimport.BackupImporter.importEntities(BackupImporter.java:420)
            at com.atlassian.confluence.importexport.xmlimport.BackupImporter.importEverything(BackupImporter.java:388)
            at com.atlassian.confluence.importexport.xmlimport.FileBackupImporter.importEverything(FileBackupImporter.java:150)
            at com.atlassian.confluence.importexport.xmlimport.BackupImporter$1.doInTransactionWithoutResult(BackupImporter.java:259)
            at org.springframework.transaction.support.TransactionCallbackWithoutResult.doInTransaction(TransactionCallbackWithoutResult.java:33)
            at com.atlassian.confluence.importexport.xmlimport.RestorePluginStateStoreTransactionCallbackDecorator.doInTransaction(RestorePluginStateStoreTransactionCallbackDecorator.java:50)
            at com.atlassian.confluence.importexport.xmlimport.RestoreBandanaValuesTransactionCallbackDecorator.doInTransaction(RestoreBandanaValuesTransactionCallbackDecorator.java:50)
            at org.springframework.transaction.support.TransactionTemplate.execute(TransactionTemplate.java:128)
            at com.atlassian.confluence.importexport.xmlimport.BackupImporter.doImportInternal(BackupImporter.java:211)
            at com.atlassian.confluence.importexport.Importer.doImport(Importer.java:77)
            at com.atlassian.confluence.importexport.DefaultImportExportManager.performImportInternal(DefaultImportExportManager.java:83)
            at com.atlassian.confluence.importexport.DefaultImportExportManager.performImport(DefaultImportExportManager.java:73)
            at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
            at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
            at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
            at java.lang.reflect.Method.invoke(Unknown Source)
            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 com.sun.proxy.$Proxy105.performImport(Unknown Source)
            at com.atlassian.confluence.importexport.actions.ImportLongRunningTask.runInternal(ImportLongRunningTask.java:95)
            at com.atlassian.confluence.util.longrunning.ConfluenceAbstractLongRunningTask.run(ConfluenceAbstractLongRunningTask.java:27)
            at com.atlassian.confluence.util.longrunning.ManagedTask.run(ManagedTask.java:35)
            at java.util.concurrent.Executors$RunnableAdapter.call(Unknown Source)
            at java.util.concurrent.FutureTask.run(Unknown Source)
            at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source)
            at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)
            at java.lang.Thread.run(Unknown Source)
            Caused by: org.xml.sax.SAXException: Error while importing backup: not-null property references a null or transient value: com.atlassian.confluence.pages.Attachment.contentType
            net.sf.hibernate.PropertyValueException: not-null property references a null or transient value: com.atlassian.confluence.pages.Attachment.contentType
            at com.atlassian.confluence.importexport.xmlimport.parser.BackupParser.endElement(BackupParser.java:55)

            btan-g2g added a comment - When I import an XML backup from OnDemand confluence to the confluence server hosted by myself, I got an error, From the log, seems something wrong with ID=41648133. And not sure if I am going to have some more issues with the backup. Error message as below: – referer: http://localhost:8090/admin/restore-local-file.action | url: /longrunningtaskxml.action | userName: admin | action: longrunningtaskxml 2014-12-19 13:02:56,753 ERROR [Long running task: Importing data] [confluence.importexport.xmlimport.DefaultImportProcessor] persist Error while saving object: Imported [com.atlassian.confluence.pages.Attachment] [Id [id] =41648133, Property [title] =IT_0613_Move_Info.xlsx, Property [contentProperties] =, Property [version] =4, Property [creator] =com.atlassian.confluence.user.ConfluenceUserImpl[Id [key] =ff8080813fbbcbe9013fbbcc94370014], Property [creationDate] =2014-06-04 16:26:57.502, Property [lastModifier] =com.atlassian.confluence.user.Confluen ceUserImpl[Id [key] =ff8080813fbbcbe9013fbbcc94370014], Property [lastModificationDate] =2014-06-04 16:26:57.502, Property [versionComment] =, Property [originalVersion] =com.atlassian.confluence.pages.Attachment[Id [id] =41648129], Property [contentStatus] =, Property[containerCon tent]=com.atlassian.confluence.pages.Page[Id [id] =39584043]] – referer: http://localhost:8090/admin/restore-local-file.action | url: /longrunningtaskxml.action | userName: admin | action: longrunningtaskxml 2014-12-19 13:02:56,754 ERROR [Long running task: Importing data] [confluence.importexport.xmlimport.BackupImporter] importEntities Cannot import the entities: – referer: http://localhost:8090/admin/restore-local-file.action | url: /longrunningtaskxml.action | userName: admin | action: longrunningtaskxml com.atlassian.confluence.importexport.ImportExportException: Unable to complete import: Error while importing backup: not-null property references a null or transient value: com.atlassian.confluence.pages.Attachment.contentType at com.atlassian.confluence.importexport.xmlimport.DefaultXmlImporter.doImport(DefaultXmlImporter.java:77) at com.atlassian.confluence.importexport.xmlimport.BackupImporter.importEntities(BackupImporter.java:420) at com.atlassian.confluence.importexport.xmlimport.BackupImporter.importEverything(BackupImporter.java:388) at com.atlassian.confluence.importexport.xmlimport.FileBackupImporter.importEverything(FileBackupImporter.java:150) at com.atlassian.confluence.importexport.xmlimport.BackupImporter$1.doInTransactionWithoutResult(BackupImporter.java:259) at org.springframework.transaction.support.TransactionCallbackWithoutResult.doInTransaction(TransactionCallbackWithoutResult.java:33) at com.atlassian.confluence.importexport.xmlimport.RestorePluginStateStoreTransactionCallbackDecorator.doInTransaction(RestorePluginStateStoreTransactionCallbackDecorator.java:50) at com.atlassian.confluence.importexport.xmlimport.RestoreBandanaValuesTransactionCallbackDecorator.doInTransaction(RestoreBandanaValuesTransactionCallbackDecorator.java:50) at org.springframework.transaction.support.TransactionTemplate.execute(TransactionTemplate.java:128) at com.atlassian.confluence.importexport.xmlimport.BackupImporter.doImportInternal(BackupImporter.java:211) at com.atlassian.confluence.importexport.Importer.doImport(Importer.java:77) at com.atlassian.confluence.importexport.DefaultImportExportManager.performImportInternal(DefaultImportExportManager.java:83) at com.atlassian.confluence.importexport.DefaultImportExportManager.performImport(DefaultImportExportManager.java:73) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source) at java.lang.reflect.Method.invoke(Unknown Source) 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 com.sun.proxy.$Proxy105.performImport(Unknown Source) at com.atlassian.confluence.importexport.actions.ImportLongRunningTask.runInternal(ImportLongRunningTask.java:95) at com.atlassian.confluence.util.longrunning.ConfluenceAbstractLongRunningTask.run(ConfluenceAbstractLongRunningTask.java:27) at com.atlassian.confluence.util.longrunning.ManagedTask.run(ManagedTask.java:35) at java.util.concurrent.Executors$RunnableAdapter.call(Unknown Source) at java.util.concurrent.FutureTask.run(Unknown Source) at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source) at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source) at java.lang.Thread.run(Unknown Source) Caused by: org.xml.sax.SAXException: Error while importing backup: not-null property references a null or transient value: com.atlassian.confluence.pages.Attachment.contentType net.sf.hibernate.PropertyValueException: not-null property references a null or transient value: com.atlassian.confluence.pages.Attachment.contentType at com.atlassian.confluence.importexport.xmlimport.parser.BackupParser.endElement(BackupParser.java:55)

              vvo Vu Truong Vo (Inactive)
              sraj Suren Raj
              Affected customers:
              11 This affects my team
              Watchers:
              23 Start watching this issue

                Created:
                Updated:
                Resolved: