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:
                Jason Pince
              • Votes:
                0 Vote for this issue
                Watchers:
                1 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved:
                  Days since last comment:
                  1 year, 2 weeks, 2 days ago

                  Packages

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