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

Duplicate entry for key 'IX_A21FC9A8' during Staging, after upgrade from 6.2

    Details

      Description

      Description:
      After upgrading 6.2 do 7.1 the Staging is broken due to the new table: AssetDisplayPageEntry
      Exception is thrown:

      com.liferay.journal.internal.exportimport.data.handler.JournalArticleStagedModelDataHandler._importAssetDisplayPage(JournalArticleStagedModelDataHandler.java:1323)
      at com.liferay.journal.internal.exportimport.data.handler.JournalArticleStagedModelDataHandler.doImportStagedModel(JournalArticleStagedModelDataHandler.java:973)
      at com.liferay.journal.internal.exportimport.data.handler.JournalArticleStagedModelDataHandler.doImportStagedModel(JournalArticleStagedModelDataHandler.java:105)
      at com.liferay.exportimport.kernel.lar.BaseStagedModelDataHandler.importStagedModel(BaseStagedModelDataHandler.java:392)
      ... 67 more
      Caused by: java.sql.BatchUpdateException: Duplicate entry '10216373-20109-10530705' for key 'IX_A21FC9A8'
      

      Reproduction steps:
      1) Start 6.2
      2) Add an Asset Publisher to a page, open its Configuration and set Set as the Default Asset Publisher for This Page
      3) Add a journal article and set its display page to the page where the Asset Publisher is
      4) Switch on Local Staging
      5) Upgrade to 7.1
      6) Try to do a full publication
      Actual result: The above exception

        Attachments

          Issue Links

            Activity

              People

              Assignee:
              yang.cao Yang Cao
              Reporter:
              vendel.toreki Vendel Töreki
              Participants of an Issue:
              Recent user:
              John Park
              Engineering Assignee:
              Vendel Töreki
              Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

                Dates

                Created:
                Updated:
                Resolved:
                Days since last comment:
                2 years, 33 weeks, 5 days ago

                  Packages

                  Version Package
                  7.1.10 DXP FP15
                  7.1.X
                  7.2.10 DXP FP2
                  7.2.10.1 DXP SP1
                  7.2.1 CE GA2
                  7.2.X
                  7.3.10 DXP GA1
                  Master