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

An error is thrown when enable staging on My Dashboard.

    Details

      Description

      Description
      An error is thrown when enable staging on My Dashboard.

       Steps to reproduce

      1. Setup liferay 7.0
      2. Login as default user
      3. Navigate to My Dashboard > Publishing > Staging
      4. Enable Local Live staging

      Actual result
      The following is thrown and an error message is displayed.

      Error: An unexpected error occurred with the initial staging publication. org.springframework.dao.DataIntegrityViolationException: Could not execute JDBC batch update; SQL [insert into Group_ (mvccVersion, uuid_, companyId, creatorUserId, classNameId, classPK, parentGroupId, liveGroupId, treePath, groupKey, name, description, type_, typeSettings, manualMembership, membershipRestriction, friendlyURL, site, remoteStagingGroupCount, inheritContent, active_, groupId) values (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)]; constraint [null]; nested exception is org.hibernate.exception.ConstraintViolationException: Could not execute JDBC batch update
      
      2019-07-04 02:36:18.038 ERROR [http-nio-8080-exec-3][JDBCExceptionReporter:234] Duplicate entry '20115-20087-20155' for key 'IX_D0D5E397'

      Expected result
      Staging feature should not be enabled on My Dashboard.

      Reproduced in
      7.0.x Commit: f32bb75b0f08e42417997d62c799861a4d5cc214
      Master Commit: 79f9d28848bb635cb4effee85618164314c283a5

      Not Reproducible in 6.2 as Staging menu is not available for My Dashboard.

        Attachments

          Issue Links

            Activity

              People

              Assignee:
              joyce.wang Joyce Wang
              Reporter:
              matthew.chan Matthew Chan
              Participants of an Issue:
              Recent user:
              Joel Garman
              Votes:
              0 Vote for this issue
              Watchers:
              1 Start watching this issue

                Dates

                Created:
                Updated:
                Resolved:
                Days since last comment:
                1 year, 31 weeks ago

                  Packages

                  Version Package
                  7.0.0 DXP FP85
                  7.0.10.12 DXP SP12
                  7.0.X
                  7.1.10 DXP FP13
                  7.1.X
                  7.2.10 DXP FP1
                  7.2.X
                  7.2.1 CE GA2
                  7.3.10 DXP GA1
                  Master