XML space import failed from the latest OD for Oracle Database

XMLWordPrintable

      NOTE: This bug report is for Confluence Cloud. Using Confluence Server? 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

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

              Created:
              Updated:
              Resolved: