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

XMLWordPrintable

      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. screenshot-1.png
          screenshot-1.png
          24 kB
        2. oracle.jpg
          oracle.jpg
          112 kB
        3. Confluence-space-export-EDIT_PERMISSIONS-2.xml.zip
          3.66 MB

              vvo Vu Truong Vo (Inactive)
              sraj Suren Raj (Inactive)
              Votes:
              11 Vote for this issue
              Watchers:
              23 Start watching this issue

                Created:
                Updated:
                Resolved: