Uploaded image for project: 'PUBLIC - Liferay Portal Community Edition'
  1. PUBLIC - Liferay Portal Community Edition
  2. LPS-26438

index IX_8D83D0CE in 5.2 is unique, but in 6.1 is not unique - causes upgrade issues

    Details

      Description

      the index IX_8D83D0CE in a 5.2 SP3 DB has a unique constraint, and when upgrading to 6.1 throws and error (see below) but the sql scripts for 6.1 create this index as non unique. So it appears the index should be dropped and recreated during the upgrade.

      14:23:23,575 ERROR [MainServlet:201] com.liferay.portal.kernel.events.ActionException: com.liferay.portal.kernel.upgrade.UpgradeException: com.liferay.portal.kernel.upgrade.UpgradeException: java.sql.SQLException: ORA-00001: unique constraint (WBC_LIFERAY.IX_8D83D0CE) violated

      com.liferay.portal.kernel.events.ActionException: com.liferay.portal.kernel.upgrade.UpgradeException: com.liferay.portal.kernel.upgrade.UpgradeException: java.sql.SQLException: ORA-00001: unique constraint (WBC_LIFERAY.IX_8D83D0CE) violated

        Attachments

          Issue Links

            Activity

              People

              Assignee:
              michael.saechang Michael Saechang
              Reporter:
              barrie.selack Barrie Selack (Inactive)
              Participants of an Issue:
              Recent user:
              Marta Elicegui
              Votes:
              0 Vote for this issue
              Watchers:
              3 Start watching this issue

                Dates

                Created:
                Updated:
                Resolved:
                Days since last comment:
                9 years, 14 weeks, 5 days ago

                  Packages

                  Version Package
                  6.1.1 CE GA2
                  6.1.20 EE GA2
                  --Sprint 11/12
                  6.2.0 CE M2