Database upgrade fails due to missing Kaleo tables

Issue

• Would like to upgrade the Liferay environment to a later version
• The upgrade tool is logging the following error:

ERROR [main][UpgradeStepRegistratorTracker:193] Failed upgrade process for module com.liferay.portal.workflow.kaleo.service
com.liferay.portal.kernel.upgrade.UpgradeException: java.sql.SQLSyntaxErrorException: Table '<databaseName>.KaleoInstance' doesn't exist

Environment

• Liferay Portal EE 6.2

Resolution

• Open the pre-upgraded environment
• Navigate to Admin > Control Panel > (Apps) Store > Sign in > (Update Marketplace if it is necessary) > Search for "Liferay Kaleo Workflow" > Download > Install the module
• Check your database and see that the database "Kaleo" related tables.

Additional Information

• In case you are using a different version of Liferay, but missing the same table or receiving an almost identical log message, this approach should be still valid.