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

Details

    Description

      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.

      Attachments

        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

        Issue Links

          causes

          Bug - A problem which impairs or prevents the functions of the product. CONFSERVER-39862 importing a site backup made from pre-5.0 (pre user-rename) into 5.7 or later fails when there are content restriction set on any page

          • Medium - Medium priority issues
          • Closed
          details

          Bug - A problem which impairs or prevents the functions of the product. CONFSERVER-36588 XML Space import failed in Oracle databases

          • High - High priority issues
          • Closed
          is related to

          Suggestion - CONFSERVER-36705 Confluence Import Version

          • Closed
          relates to

          Bug - A problem which impairs or prevents the functions of the product. CONFCLOUD-35969 XML space import failed from the latest OD for Oracle Database

          • High - High priority issues
          • Closed

          Suggestion - CONFSERVER-36062 Add a warning or Description in Confluence OD space and page export

          • Closed
          mentioned in

          Page Loading...

          Page Loading...

          Page Loading...

          Activity

            People

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

              Dates

                Created:
                Updated:
                Resolved: