Upgrading from 5.3.1 to 5.4.1 failed on an Oracle database when trying to create the c_ancestorid_idx on CONFANCESTORS.

      Update
      Upgrading to 5.4.3 will also throw a similar error, when trying to create the c_extentityid_idx on external_members.

      Workaround
      Follow the instruction at this KB to resolve the issue

          Form Name

            [CONFSERVER-32139] Upgrade task fails with Oracle during index creation

            Katherine Yabut made changes -
            Workflow Original: JAC Bug Workflow v3 [ 2885661 ] New: CONFSERVER Bug Workflow v4 [ 2978904 ]
            Owen made changes -
            Workflow Original: JAC Bug Workflow v2 [ 2791756 ] New: JAC Bug Workflow v3 [ 2885661 ]
            Status Original: Resolved [ 5 ] New: Closed [ 6 ]
            Owen made changes -
            Workflow Original: JAC Bug Workflow [ 2727469 ] New: JAC Bug Workflow v2 [ 2791756 ]
            Owen made changes -
            Workflow Original: Confluence Workflow - Public Facing - Restricted v5 - TEMP [ 2392050 ] New: JAC Bug Workflow [ 2727469 ]
            Alex Yakovlev (Inactive) made changes -
            Labels Original: affects-server bugfix database/hibernate loyalty oracle upgrade New: affects-server database/hibernate loyalty oracle upgrade
            Alex Yakovlev (Inactive) made changes -
            Labels Original: affects-server bugfix database/hibernate oracle upgrade New: affects-server bugfix database/hibernate loyalty oracle upgrade
            Katherine Yabut made changes -
            Workflow Original: Confluence Workflow - Public Facing - Restricted v5 [ 2288180 ] New: Confluence Workflow - Public Facing - Restricted v5 - TEMP [ 2392050 ]
            Katherine Yabut made changes -
            Workflow Original: Confluence Workflow - Public Facing - Restricted v5.1 - TEMP [ 2227116 ] New: Confluence Workflow - Public Facing - Restricted v5 [ 2288180 ]
            Katherine Yabut made changes -
            Workflow Original: Confluence Workflow - Public Facing - Restricted v5 - TEMP [ 2182368 ] New: Confluence Workflow - Public Facing - Restricted v5.1 - TEMP [ 2227116 ]
            Katherine Yabut made changes -
            Workflow Original: Confluence Workflow - Public Facing - Restricted v5 [ 1950475 ] New: Confluence Workflow - Public Facing - Restricted v5 - TEMP [ 2182368 ]

              tquanghua Thinh Quang Hua (Inactive)
              btom1 Brian
              Affected customers:
              3 This affects my team
              Watchers:
              10 Start watching this issue

                Created:
                Updated:
                Resolved: