Issue
- While upgrading from DXP 7.2 to DXP 7.4, the below errors were encountered:
-
ERROR [main][DBUpgrader:70] null
com.liferay.portal.kernel.log.LogSanitizerException: com.liferay.portal.kernel.upgrade.Upg radeException: com.liferay.portal.kernel.upgrade.UpgradeException: java.sql.SQLException:ORA-38029: object statistics are locked_ [Sanitized] - If the statistics for a given table are locked, then the upgrade process won’t be complete and will fail.
-
Steps to reproduce:
1. Start up an Oracle database with Liferay DXP 7.2 SP8.
2. Allow the portal to populate and fill tables.
3. Execute the below command:
exec dbms_stats.lock_table_stats(SCHEMA_NAME, 'ASSETENTRY');
4. Run the upgrade using U108.
Expected Behavior: Upgrade Completes Successfully
Actual Behavior: Below error is encountered when fetching indexes:
Caused by: Error : 38029, Position : 0, Sql = analyze table SYSTEM.ASSETENTRY compute statistics, OriginalSql = analyze table SYSTEM.ASSETENTRY compute statistics, Error Msg = ORA-38029: object statistics are locked
Environment
- Liferay DXP 7.2
- Liferay DXP 7.4
- Oracle database
Resolution
- The observed behavior is a regression bug that has been addressed by: LPD-1589.
- If a hotfix is required for this issue, please create a support ticket requesting a hotfix by attaching patch details.
- Installing Fix Packs and Hotfixes on Liferay DXP will guide you to install this hotfix in the respective environment.
Additional Information
- The hotfix should be added before the upgrade.