Upgrade fails with com.liferay.document.library.kernel.exception.FileExtensionException when dl.file.extensions is to a non-default value

• Type: Bug
• Status: Closed
• Resolution: Fixed
• Affects Version/s: 7.0.0 DXP FP32, 7.0.X, Master
• Fix Version/s: 7.0.0 DXP FP39, 7.0.0 DXP SP7, 7.0.5 CE GA6, 7.0.X, 7.1.0 M1, 7.1.X, Master
• Component/s: DM > Upgrade, Documents & Media
• Labels:
  • backend_test
  • ee-ts
  • liferay-digital-enterprise-70-sp7
  • liferay-fixpack-de-39-7010
• Branch Version/s:
  7.0.x
• Backported to Branch:
  Committed
• Fix Priority: 4
• Git Pull Request: https://github.com/brianchandotcom/liferay-portal/pull/53791
• Bug Type: Database Upgrade

Reproduction steps Version 1
without the database dump

1. Start portal 6.2
2. Upload a file with a different extension than .jpg
3. Go to Control Panel - Server Administration - File Uploads
4. Set a valid extension as "File Extensions", for example .jpg
5. Stop the portal
6. Take the ID for the DLFileVersion you created before and execute the following groovy script to remove it:

   com.liferay.portlet.documentlibrary.service.DLFileVersionLocalServiceUtil.deleteDLFileVersion(ID);

7. Upgrade to 7.0: start the upgrade tool: java -jar com.liferay.portal.tools.db.upgrade.client.jar

Reproduction steps Version 2
with the database dump

1. Import the attached database dump and use this in the upgrade process (add the database location to portal-upgrade-database.properties)
2. Upgrade to 7.0: start the upgrade tool: java -jar com.liferay.portal.tools.db.upgrade.client.jar

The upgrade (verify process) fails with this error:

INFO - Completed verification process com.liferay.document.library.internal.verify.DLServiceVerifyProcess in 4ms
17:39:26,435 ERROR [main][VerifyProcessTrackerOSGiCommands:297] com.liferay.portal.verify.VerifyException: com.liferay.document.library.kernel.exception.FileExtensionException: 2
com.liferay.portal.verify.VerifyException: com.liferay.document.library.kernel.exception.FileExtensionException: 2
	at com.liferay.portal.verify.VerifyProcess.verify(VerifyProcess.java:75)

Alternatively, one can use the portal-ext.properties and the portal-upgrade-ext.properties to configure dl.file.extensions which results the same error.