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

          Form Name

            [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
            Katherine Yabut made changes -
            Workflow Original: JAC Bug Workflow v3 [ 2897154 ] New: CONFSERVER Bug Workflow v4 [ 2990941 ]
            Owen made changes -
            Workflow Original: JAC Bug Workflow v2 [ 2788785 ] New: JAC Bug Workflow v3 [ 2897154 ]
            Status Original: Resolved [ 5 ] New: Closed [ 6 ]
            Owen made changes -
            Workflow Original: JAC Bug Workflow [ 2736053 ] New: JAC Bug Workflow v2 [ 2788785 ]
            Owen made changes -
            Workflow Original: Confluence Workflow - Public Facing - Restricted v5 - TEMP [ 2401342 ] New: JAC Bug Workflow [ 2736053 ]
            Alex Yakovlev (Inactive) made changes -
            Labels Original: admin-console affects-cloud affects-server bugfix loyalty ondemand New: admin-console affects-cloud affects-server loyalty ondemand
            Alex Yakovlev (Inactive) made changes -
            Labels Original: admin-console affects-cloud affects-server bugfix ondemand New: admin-console affects-cloud affects-server bugfix loyalty ondemand
            Katherine Yabut made changes -
            Workflow Original: Confluence Workflow - Public Facing - Restricted v5 [ 2301471 ] New: Confluence Workflow - Public Facing - Restricted v5 - TEMP [ 2401342 ]
            Katherine Yabut made changes -
            Workflow Original: Confluence Workflow - Public Facing - Restricted v5.1 - TEMP [ 2235241 ] New: Confluence Workflow - Public Facing - Restricted v5 [ 2301471 ]
            Katherine Yabut made changes -
            Workflow Original: Confluence Workflow - Public Facing - Restricted v5 - TEMP [ 2198509 ] New: Confluence Workflow - Public Facing - Restricted v5.1 - TEMP [ 2235241 ]

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

                Created:
                Updated:
                Resolved: