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

Upgrading to 3.5.2 fails with Oracle 11

    XMLWordPrintable

Details

    Description

      When upgrading to 3.5.2 with Oracle 11, the upgrade fails with:

      com.atlassian.confluence.upgrade.UpgradeException: Schema upgrade task [ com.atlassian.confluence.upgrade.upgradetask.ContentPermissionConstraintsUpgradeTask@1b9d14c ] failed due to : StatementCallback; bad SQL grammar [SELECT DISTINCT cp1.* FROM CONTENT_PERM cp1, CONTENT_PERM_SET cps1, CONTENT_PERM cp2, CONTENT_PERM_SET cps2 WHERE cp1.cps_id = cps1.id AND cp2.cps_id = cps2.id AND cp1.id <> cp2.id AND cps1.content_id = cps2.content_id AND cp1.cp_type = cp2.cp_type AND cp1.username = cp2.username ORDER BY cp1.cps_id, cp1.cp_type, cp1.username, creationdate]; nested exception is java.sql.SQLSyntaxErrorException: ORA-00918: column ambiguously defined
      

      Attachments

        Issue Links

          Activity

            People

              akdominguez Katrina Walser (Inactive)
              akdominguez Katrina Walser (Inactive)
              Votes:
              1 Vote for this issue
              Watchers:
              4 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved: