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

Existing Result Ranking entries are imported to the database during upgrade automatically

    Details

      Description

      Add upgrade step which does the import during upgrade when the ES server is available and there are RR entries to add.

      Even if we assume that some customers will set-up a new ES cluster and back-up and restore the indexes manually (after the DB upgrade, so the RR entries may not be present during the upgrade process), other customers will just re-use the existing ES 7.x cluster (especially when upgrading from 7.3) so this upgrade step will eliminate the need for running the Groovy-script and also simplify the Search upgrade docs. In addition, this would also help QA in adding an upgrade test.

      Acceptance Criteria

      1. Upgrade successfully from 7.2/7.3 search index storage to database storage

      Verification

      Environment:

      1. Install & configure remote ES7
      2. Configure DXP to connect to remote ES7
      3. Start DXP
      4. Create a few Web Content articles and other asset entries
      5. Create a RR entry, pin, order ec.
      6. Create another RR entry
      7. Create a new Virtual Instance
      8. Repeat steps 4-6 on the new Virtual Instance
      9. Stop DXP
      10. Stop ES7

      Case: Upgrade

      1. Set-up the environment using DXP 7.3 and follow the steps above to create data
      2. Stop DXP 7.3 and upgrade to Master/7.4
      3. Perform a full reindex
      4. Verify that RR entries are present on both Virtual Instances on the UI
      5. Verify that RR entries are present in the database
      6. Verify that the RR indexes (liferay-<companyId>-search-tuning-rankings) contain the RR documents

      UPGRADE NOTES

      • After upgrading from 7.3, if the ES server was not available during the upgrade or it did not contain the existing entries for whatever reason, the groovy script attached must be ran (while portal is connected to the elastic server that contains the RR indexes) in order to populate the database
      • Storage: JSONStorageEntry table

        Attachments

          Issue Links

            Activity

              People

              Assignee:
              brian.lee Brian Lee
              Reporter:
              tibor.lipusz Tibor Lipusz
              Engineering Assignee:
              Bryan Engler
              Recent user:
              Tibor Lipusz
              Participants of an Issue:
              Votes:
              0 Vote for this issue
              Watchers:
              1 Start watching this issue

                Dates

                Created:
                Updated:
                Resolved:
                Development End Date:
                Development Start Date:

                  Packages

                  Version Package
                  7.4.13 DXP GA1