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

deleteChangesetEntries can exceed SQL Server parameter limit

    Details

      Description

      Reproduction steps

      1. Start the bundle with a SQL Server
      2. Create a site
      3. Turn on Local Live Staging for your site
      4. Create 3000 Web Content articles
      5. Navigate to Control Panel > your site > Content > Web Content
      6. From the 3 dots menu on the upper right corner choose Staging
      7. Select All option to publish and try to publish it.

      Expected behaviour: Publication is successful

      Actual behaviour: After a long waiting the publication fails and the following appears in the log:

      Caused by: com.microsoft.sqlserver.jdbc.SQLServerException: The incoming request has too many parameters. The server supports a maximum of 2100 parameters. Reduce the number of parameters and resend the request.
      

        Attachments

          Activity

            People

            Assignee:
            joyce.wang Joyce Wang
            Reporter:
            balazs.safrany-kovalik Balázs Sáfrány-Kovalik
            Participants of an Issue:
            Recent user:
            Yunlin "Steven" Sun
            Engineering Assignee:
            Balázs Sáfrány-Kovalik
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

              Dates

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

                Packages

                Version Package
                7.1.10 DXP FP19
                7.1.10.5 SP5
                7.1.X
                7.2.10 DXP FP8
                7.2.10.3 DXP SP3
                7.2.X
                7.3.4 CE GA5
                7.3.10 DXP GA1
                Master