Issue
- We have received a recent report where a BatchUpdateException was identified while upgrading from an earlier Liferay DXP 7.4 update to Liferay Quarterly Release while using SQL Server
You may see an error such as the following:
ERROR [main][UpgradeStepRegistratorTracker:178] Failed upgrade process for module com.liferay.object.service com.liferay.portal.kernel.upgrade.UpgradeException: java.sql.BatchUpdateException: Unable to retrieve data from the source.
Environment
- Liferay Quarterly Release 2023
- SQL Server 2019
Resolution
- To avoid this behavior, please upgrade using the 7.4.1 version of the SQL Server JDBC JAR file found in the Microsoft JDBC Driver For SQL Server Maven Repository. Please choose the appropriate JAR file for the Java version that is in use on your application server and include it in your Liferay bundle.
- If the error still persists, please visit this official SQLServer documentation of frequent errors and its causes.
Additional Information