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



      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



      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


      • 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


        Issue Links



              brian.lee Brian Lee
              tibor.lipusz Tibor Lipusz
              Bryan Engler Bryan Engler
              Brian Lee Brian Lee
              0 Vote for this issue
              1 Start watching this issue


                Development End Date:
                Development Start Date:


                  Version Package
                  7.4.13 DXP GA1