Uploaded image for project: 'Confluence Data Center'
  1. Confluence Data Center
  2. CONFSERVER-26715

upgrading to 4.3.1 on oracle gives contraint error

XMLWordPrintable

    • Icon: Bug Bug
    • Resolution: Won't Fix
    • Icon: Medium Medium
    • None
    • 4.3.1
    • None

    • upgrade from 4.2.11 to 4.3.1 on Oracle 11G

      When upgrading to 4.3.1 to following SQL query fails on Oracle 11G:

      create index attch_data_idx on ATTACHMENTDATA (ATTACHMENTID)

      This happens because there is already an constraint and index generated by oracle on this field. The create fails because the same index already exists.

      Solution is to remove the constraint and index manually. Then the SQL query works, and the upgrade process will continue.

          Form Name

            [CONFSERVER-26715] upgrading to 4.3.1 on oracle gives contraint error

            Katherine Yabut made changes -
            Workflow Original: JAC Bug Workflow v3 [ 2893271 ] New: CONFSERVER Bug Workflow v4 [ 2985261 ]
            Owen made changes -
            Workflow Original: JAC Bug Workflow v2 [ 2793094 ] New: JAC Bug Workflow v3 [ 2893271 ]
            Status Original: Resolved [ 5 ] New: Closed [ 6 ]
            Owen made changes -
            Workflow Original: JAC Bug Workflow [ 2726446 ] New: JAC Bug Workflow v2 [ 2793094 ]
            Owen made changes -
            Workflow Original: Confluence Workflow - Public Facing - Restricted v5 - TEMP [ 2390565 ] New: JAC Bug Workflow [ 2726446 ]
            Katherine Yabut made changes -
            Workflow Original: Confluence Workflow - Public Facing - Restricted v5 [ 2286771 ] New: Confluence Workflow - Public Facing - Restricted v5 - TEMP [ 2390565 ]
            Katherine Yabut made changes -
            Workflow Original: Confluence Workflow - Public Facing - Restricted v5.1 - TEMP [ 2226287 ] New: Confluence Workflow - Public Facing - Restricted v5 [ 2286771 ]
            Katherine Yabut made changes -
            Workflow Original: Confluence Workflow - Public Facing - Restricted v5 - TEMP [ 2180883 ] New: Confluence Workflow - Public Facing - Restricted v5.1 - TEMP [ 2226287 ]
            Katherine Yabut made changes -
            Workflow Original: Confluence Workflow - Public Facing - Restricted v5 [ 1947961 ] New: Confluence Workflow - Public Facing - Restricted v5 - TEMP [ 2180883 ]
            Katherine Yabut made changes -
            Workflow Original: Confluence Workflow - Public Facing - Restricted v3 [ 1743055 ] New: Confluence Workflow - Public Facing - Restricted v5 [ 1947961 ]
            Katherine Yabut made changes -
            Workflow Original: CONF Bug Subtask WF (TEMP) [ 1704060 ] New: Confluence Workflow - Public Facing - Restricted v3 [ 1743055 ]

              shaffenden Steve Haffenden (Inactive)
              24386343cf32 Christoph Kempen
              Affected customers:
              0 This affects my team
              Watchers:
              1 Start watching this issue

                Created:
                Updated:
                Resolved: