Actions menu duplicated in Documents and Media portlet after migration from 7.0 to 7.4

Issue

• After an upgrade from 7.0 to 7.4 actions menu (three vertical dots) in Documents and Media portlet is duplicated.

Environment

• Liferay DXP 7.4

Resolution

• Before the upgrade, in 7.0 some entries in the portletpreferences table have the following duplicated value:

  <preference>
  <name>entryColumns</name>(...)
  <value>action</value>
  <value>action</value>
  </preference>

• After migration to 7.4, existing records from 7.0 with the value "action" in the SMALLVALUE column appear twice in the portletpreferencevalue table.
• This issue has been fixed in LPS-196242. Our recommendation would be to request the Support Department for a hotfix. Please note that, once the hotfix is installed it's necessary to repeat the upgrade. 
• If in your case it is not possible to repeat the upgrade, you can consider the following option:

Read before taking any action

The proposed solution makes direct changes to the database, so it is important to follow these steps before executing it:

1. Backup the database.
2. Execute the Script in readOnly mode. This action will not make any modification in the database, it will only show on the screen the records that would be deleted.
   • To execute in readOnly mode, the readOnly variable must be set to true.
3. Check the script output. The records must match the portlets that have duplicates.
4. Once you are sure that the output is correct, you can execute the script in real mode and remove duplicate records.
   • To execute in real mode, the readOnly variable must be set to false.

• In order to remove these duplicate rows in 7.4, the attached script cleanDuplicatedActions.groovy has been created.

• To execute the Script
  1. Go to Control Panel -> Server Administration -> Script.
  2. Copy the entire script content and paste it into the textbox.
  3. Click on the Execute button.

Additional Information

• Make sure you have read the warning at the beginning of the resolution section before using the attached script.