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

              joyce.wang Joyce Wang
              matthew.chan Matthew Chan (Inactive)
              Kiyoshi Lee Kiyoshi Lee
              Votes:
              0 Vote for this issue
              Watchers:
              1 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved:
                3 years, 35 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.1 CE GA2
                  7.2.X
                  7.3.10 DXP GA1
                  Master