Announcements portlet not upgraded correctly

• Type: Bug
• Status: Closed
• Resolution: Fixed
• Affects Version/s: Master
• Fix Version/s: 7.0.0 DXP FP10, 7.0.0 DXP SP2, 7.0.3 CE GA4, 7.1.X, Master
• Component/s: Announcements & Alerts widgets, Collaboration
• Labels:
  • liferay-digital-enterprise-70-sp2
  • liferay-fixpack-de-10-7010
• Branch Version/s:
  7.0.x
• Backported to Branch:
  Committed
• Story Points: 1.25
• Fix Priority: 5
• Sprint: Tetraferriphlogopite 12/20-1/3, Wadsleyite, Xanthochroite
• Git Pull Request: https://github.com/brianchandotcom/liferay-portal/pull/45662
• QA Test Name:
  • dont-test-again

Steps to reproduce:

1. Import the MySQL database attached to this issue.
2. Run the upgrade process using latest master.

Expected: The Announcements upgrade finishes successfully.
Actual: Either the upgrade fails or a duplicate index error shows for announcements (search for IX_C7057FF7 in the upgrade logs)

Test scenarios

Each scenario represents one of the upgrade paths. 0.0.0 means "component was never installed before" (i.e. fresh startup), 0.0.1 means "component was installed and needs upgrade" (i.e. coming fro 6.2); the other numbers are the official revisions of the Announcements portlet (1.0.3 will be the next one released).

Some intermediate versions have been elided (1.0.0 and 1.0.1) as the steps and expected outcome are basically be the same as in the 0.0.1 → 1.0.2 → 1.0.3 case.

0.0.0 → 1.0.3

This path is executed when starting a clean install for the first time. Already covered by the CI, so no need to do anything.

0.0.1 → 1.0.3

• Install the latest 6.2 CE bundle
• Start the portal
• Deploy the so-announcements-portlet plugin
• Create a page with the Announcements, Alerts and SO Announcements portlets in it.
• Shutdown the server.
• Install the latest master
• Execute the upgrade
• Start the portal
• Go to the announcements page and assert that:

1. The SO portlet has disappeared.
2. The Announcements and Alerts portlets are on the page.

0.0.1 → 1.0.2 → 1.0.3

• Install the latest 6.2 CE bundle
• Start the portal
• Deploy the so-announcements-portlet plugin
• Create a page with the Announcements, Alerts and SO Announcements portlets in it.
• Shutdown the server.
• Install the 7.0 GA2 bundle
• Execute the upgrade
• Start the portal
• Go to the announcements page and assert that no portlets are displayed (the SO portlet may or may not show depending on whether you have deployed the plugin again or not).
• Shutdown the portal
• Install the latest master
• Execute the upgrade
• Start the portal
• Go to the announcements page and assert that:

1. The SO portlet has disappeared.
2. The Announcements and Alerts portlets are on the page.