Ask Questions and Find Answers

Hi, I am trying to upgrade the Liferay Database from 6.2 to 7.4 using the DB Upgrade Client. However, on running the upgrade script, I am getting the following errors. What could be the error and what could be the solution to rectify this error? 

2022-12-21 05:10:46.674 INFO  [ForkJoinPool-1-worker-7][BaseCompanyIdUpgradeProcess:45] Adding column companyId to table UserGroupGroupRole
2022-12-21 05:10:46.713 INFO  [ForkJoinPool-1-worker-1][BaseCompanyIdUpgradeProcess:45] Adding column companyId to table UserGroupRole
2022-12-21 05:10:46.758 INFO  [ForkJoinPool-1-worker-5][LoggingTimer:44] Completed com.liferay.portal.kernel.upgrade.BaseCompanyIdUpgradeProcess#lambda$doUpgrade$0#PortletPreferences in 442 ms
2022-12-21 05:10:46.758 INFO  [ForkJoinPool-1-worker-5][LoggingTimer:83] Starting com.liferay.portal.kernel.upgrade.BaseCompanyIdUpgradeProcess#lambda$doUpgrade$0#UserGroups_Teams
2022-12-21 05:10:46.836 INFO  [ForkJoinPool-1-worker-7][LoggingTimer:44] Completed com.liferay.portal.kernel.upgrade.BaseCompanyIdUpgradeProcess#lambda$doUpgrade$0#UserGroupGroupRole in 243 ms
2022-12-21 05:10:46.836 INFO  [ForkJoinPool-1-worker-7][LoggingTimer:83] Starting com.liferay.portal.kernel.upgrade.BaseCompanyIdUpgradeProcess#lambda$doUpgrade$0#UserIdMapper
2022-12-21 05:10:46.878 INFO  [ForkJoinPool-1-worker-1][LoggingTimer:44] Completed com.liferay.portal.kernel.upgrade.BaseCompanyIdUpgradeProcess#lambda$doUpgrade$0#UserGroupRole in 243 ms
2022-12-21 05:10:46.878 INFO  [ForkJoinPool-1-worker-1][LoggingTimer:83] Starting com.liferay.portal.kernel.upgrade.BaseCompanyIdUpgradeProcess#lambda$doUpgrade$0#Users_Groups
2022-12-21 05:10:46.917 INFO  [ForkJoinPool-1-worker-7][BaseCompanyIdUpgradeProcess:45] Adding column companyId to table UserIdMapper
2022-12-21 05:10:46.935 INFO  [ForkJoinPool-1-worker-5][BaseCompanyIdUpgradeProcess:45] Adding column companyId to table UserGroups_Teams
2022-12-21 05:10:46.965 INFO  [ForkJoinPool-1-worker-1][BaseCompanyIdUpgradeProcess:45] Adding column companyId to table Users_Groups
2022-12-21 05:10:47.052 INFO  [ForkJoinPool-1-worker-7][LoggingTimer:44] Completed com.liferay.portal.kernel.upgrade.BaseCompanyIdUpgradeProcess#lambda$doUpgrade$0#UserIdMapper in 216 ms
2022-12-21 05:10:47.052 INFO  [ForkJoinPool-1-worker-7][LoggingTimer:83] Starting com.liferay.portal.kernel.upgrade.BaseCompanyIdUpgradeProcess#lambda$doUpgrade$0#Users_Orgs
2022-12-21 05:10:47.142 INFO  [ForkJoinPool-1-worker-7][BaseCompanyIdUpgradeProcess:45] Adding column companyId to table Users_Orgs
2022-12-21 05:10:47.452 INFO  [ForkJoinPool-1-worker-1][LoggingTimer:44] Completed com.liferay.portal.kernel.upgrade.BaseCompanyIdUpgradeProcess#lambda$doUpgrade$0#Users_Groups in 574 ms
2022-12-21 05:10:47.455 INFO  [ForkJoinPool-1-worker-1][LoggingTimer:83] Starting com.liferay.portal.kernel.upgrade.BaseCompanyIdUpgradeProcess#lambda$doUpgrade$0#Users_Roles
2022-12-21 05:10:47.491 INFO  [ForkJoinPool-1-worker-7][LoggingTimer:44] Completed com.liferay.portal.kernel.upgrade.BaseCompanyIdUpgradeProcess#lambda$doUpgrade$0#Users_Orgs in 439 ms
2022-12-21 05:10:47.491 INFO  [ForkJoinPool-1-worker-7][LoggingTimer:83] Starting com.liferay.portal.kernel.upgrade.BaseCompanyIdUpgradeProcess#lambda$doUpgrade$0#Users_Teams
2022-12-21 05:10:47.545 INFO  [ForkJoinPool-1-worker-1][BaseCompanyIdUpgradeProcess:45] Adding column companyId to table Users_Roles
2022-12-21 05:10:47.608 INFO  [ForkJoinPool-1-worker-7][BaseCompanyIdUpgradeProcess:45] Adding column companyId to table Users_Teams
2022-12-21 05:10:47.869 INFO  [ForkJoinPool-1-worker-5][LoggingTimer:44] Completed com.liferay.portal.kernel.upgrade.BaseCompanyIdUpgradeProcess#lambda$doUpgrade$0#UserGroups_Teams in 1111 ms
2022-12-21 05:10:47.873 INFO  [ForkJoinPool-1-worker-5][LoggingTimer:83] Starting com.liferay.portal.kernel.upgrade.BaseCompanyIdUpgradeProcess#lambda$doUpgrade$0#Users_UserGroups
2022-12-21 05:10:47.930 INFO  [ForkJoinPool-1-worker-1][LoggingTimer:44] Completed com.liferay.portal.kernel.upgrade.BaseCompanyIdUpgradeProcess#lambda$doUpgrade$0#Users_Roles in 475 ms
2022-12-21 05:10:47.930 INFO  [ForkJoinPool-1-worker-1][LoggingTimer:83] Starting com.liferay.portal.kernel.upgrade.BaseCompanyIdUpgradeProcess#lambda$doUpgrade$0#UserTrackerPath
2022-12-21 05:10:48.006 INFO  [ForkJoinPool-1-worker-1][BaseCompanyIdUpgradeProcess:45] Adding column companyId to table UserTrackerPath
2022-12-21 05:10:48.033 INFO  [ForkJoinPool-1-worker-5][BaseCompanyIdUpgradeProcess:45] Adding column companyId to table Users_UserGroups
2022-12-21 05:10:48.111 INFO  [ForkJoinPool-1-worker-7][LoggingTimer:44] Completed com.liferay.portal.kernel.upgrade.BaseCompanyIdUpgradeProcess#lambda$doUpgrade$0#Users_Teams in 620 ms
2022-12-21 05:10:48.150 INFO  [ForkJoinPool-1-worker-1][LoggingTimer:44] Completed com.liferay.portal.kernel.upgrade.BaseCompanyIdUpgradeProcess#lambda$doUpgrade$0#UserTrackerPath in 220 ms
2022-12-21 05:10:48.328 INFO  [ForkJoinPool-1-worker-3][LoggingTimer:44] Completed com.liferay.portal.kernel.upgrade.BaseCompanyIdUpgradeProcess#lambda$doUpgrade$0#RatingsStats in 1973 ms
2022-12-21 05:10:48.397 INFO  [ForkJoinPool-1-worker-5][LoggingTimer:44] Completed com.liferay.portal.kernel.upgrade.BaseCompanyIdUpgradeProcess#lambda$doUpgrade$0#Users_UserGroups in 524 ms
2022-12-21 05:10:48.400 INFO  [main][UpgradeProcess:129] Failed upgrade process com.liferay.portal.upgrade.v7_0_0.UpgradeCompanyId in 4745 ms
2022-12-21 05:10:48.400 INFO  [main][UpgradeProcess:129] Failed upgrade process com.liferay.portal.upgrade.UpgradeProcess_7_0_0 in 17245 ms
2022-12-21 05:10:48.424 ERROR [main][DBUpgrader:79] null
com.liferay.portal.kernel.upgrade.UpgradeException: com.liferay.portal.kernel.upgrade.UpgradeException: com.microsoft.sqlserver.jdbc.SQLServerException: The result set is closed.
        at com.liferay.portal.kernel.upgrade.UpgradeProcess.upgrade(UpgradeProcess.java:123) ~[portal-kernel.jar:?]
        at com.liferay.portal.kernel.upgrade.util.UpgradeProcessUtil._upgradeProcess(UpgradeProcessUtil.java:173) ~[portal-kernel.jar:?]
        at com.liferay.portal.kernel.upgrade.util.UpgradeProcessUtil.upgradeProcess(UpgradeProcessUtil.java:136) ~[portal-kernel.jar:?]
        at com.liferay.portal.events.StartupHelperUtil.upgradeProcess(StartupHelperUtil.java:154) ~[portal-impl.jar:?]
        at com.liferay.portal.tools.DBUpgrader._upgradePortal(DBUpgrader.java:386) ~[portal-impl.jar:?]
        at com.liferay.portal.tools.DBUpgrader.upgrade(DBUpgrader.java:162) ~[portal-impl.jar:?]
        at com.liferay.portal.tools.DBUpgrader.upgrade(DBUpgrader.java:154) ~[portal-impl.jar:?]
        at com.liferay.portal.tools.DBUpgrader.main(DBUpgrader.java:130) [portal-impl.jar:?]
        at jdk.internal.reflect.NativeMethodAccessorImpl.invoke0(Native Method) ~[?:?]
        at jdk.internal.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62) ~[?:?]
        at jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) ~[?:?]
        at java.lang.reflect.Method.invoke(Method.java:566) ~[?:?]
        at com.liferay.portal.tools.db.upgrade.client.DBUpgraderLauncher.main(DBUpgraderLauncher.java:54) [com.liferay.portal.tools.db.upgrade.client.jar:?]
Caused by: com.liferay.portal.kernel.upgrade.UpgradeException: com.microsoft.sqlserver.jdbc.SQLServerException: The result set is closed.
        at com.liferay.portal.kernel.upgrade.UpgradeProcess.upgrade(UpgradeProcess.java:123) ~[portal-kernel.jar:?]
        at com.liferay.portal.kernel.upgrade.UpgradeProcess.upgrade(UpgradeProcess.java:145) ~[portal-kernel.jar:?]
        at com.liferay.portal.upgrade.UpgradeProcess_7_0_0.doUpgrade(UpgradeProcess_7_0_0.java:86) ~[portal-impl.jar:?]
        at com.liferay.portal.kernel.upgrade.UpgradeProcess.lambda$upgrade$0(UpgradeProcess.java:117) ~[portal-kernel.jar:?]
        at com.liferay.portal.db.partition.DBPartitionUtil.forEachCompanyId(DBPartitionUtil.java:118) ~[portal-impl.jar:?]
        at com.liferay.portal.dao.db.BaseDB.process(BaseDB.java:356) ~[portal-impl.jar:?]
        at com.liferay.portal.kernel.dao.db.BaseDBProcess.process(BaseDBProcess.java:293) ~[portal-kernel.jar:?]
        at com.liferay.portal.kernel.upgrade.UpgradeProcess.upgrade(UpgradeProcess.java:104) ~[portal-kernel.jar:?]
        ... 12 more
Caused by: com.microsoft.sqlserver.jdbc.SQLServerException: The result set is closed.
        at com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDriverError(SQLServerException.java:237) ~[mssql-jdbc-10.2.0.jre11.jar:?]
        at com.microsoft.sqlserver.jdbc.SQLServerResultSet.checkClosed(SQLServerResultSet.java:472) ~[mssql-jdbc-10.2.0.jre11.jar:?]
        at com.microsoft.sqlserver.jdbc.SQLServerResultSet.next(SQLServerResultSet.java:1019) ~[mssql-jdbc-10.2.0.jre11.jar:?]
        at com.liferay.portal.dao.db.BaseDB.getIndexes(BaseDB.java:836) ~[portal-impl.jar:?]
        at com.liferay.portal.dao.db.BaseDB.dropIndexes(BaseDB.java:206) ~[portal-impl.jar:?]
        at com.liferay.portal.dao.db.SQLServerDB.alterColumnType(SQLServerDB.java:57) ~[com.liferay.portal.dao.db.jar:?]
        at com.liferay.portal.kernel.dao.db.BaseDBProcess.alterColumnType(BaseDBProcess.java:203) ~[portal-kernel.jar:?]
        at com.liferay.portal.upgrade.v7_0_0.UpgradeCompanyId.access$100(UpgradeCompanyId.java:35) ~[portal-impl.jar:?]
        at com.liferay.portal.upgrade.v7_0_0.UpgradeCompanyId$CompanyIdNotNullTableUpdater.update(UpgradeCompanyId.java:120) ~[portal-impl.jar:?]
        at com.liferay.portal.kernel.upgrade.BaseCompanyIdUpgradeProcess.lambda$doUpgrade$0(BaseCompanyIdUpgradeProcess.java:62) ~[portal-kernel.jar:?]
        at com.liferay.portal.kernel.dao.db.BaseDBProcess.lambda$_processConcurrently$2(BaseDBProcess.java:379) ~[portal-kernel.jar:?]
        at java.util.concurrent.ForkJoinTask$AdaptedCallable.exec(ForkJoinTask.java:1448) ~[?:?]
        at java.util.concurrent.ForkJoinTask.doExec(ForkJoinTask.java:290) ~[?:?]
        at java.util.concurrent.ForkJoinPool$WorkQueue.topLevelExec(ForkJoinPool.java:1020) ~[?:?]
        at java.util.concurrent.ForkJoinPool.scan(ForkJoinPool.java:1656) ~[?:?]
        at java.util.concurrent.ForkJoinPool.runWorker(ForkJoinPool.java:1594) ~[?:?]
        at java.util.concurrent.ForkJoinWorkerThread.run(ForkJoinWorkerThread.java:183) ~[?:?]
        Suppressed: com.microsoft.sqlserver.jdbc.SQLServerException: The result set is closed.
                at com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDriverError(SQLServerException.java:237) ~[mssql-jdbc-10.2.0.jre11.jar:?]
                at com.microsoft.sqlserver.jdbc.SQLServerResultSet.checkClosed(SQLServerResultSet.java:472) ~[mssql-jdbc-10.2.0.jre11.jar:?]
                at com.microsoft.sqlserver.jdbc.SQLServerResultSet.next(SQLServerResultSet.java:1019) ~[mssql-jdbc-10.2.0.jre11.jar:?]
                at com.liferay.portal.dao.db.BaseDB.getIndexes(BaseDB.java:836) ~[portal-impl.jar:?]
                at com.liferay.portal.dao.db.BaseDB.dropIndexes(BaseDB.java:206) ~[portal-impl.jar:?]
                at com.liferay.portal.dao.db.SQLServerDB.alterColumnType(SQLServerDB.java:57) ~[com.liferay.portal.dao.db.jar:?]
                at com.liferay.portal.kernel.dao.db.BaseDBProcess.alterColumnType(BaseDBProcess.java:203) ~[portal-kernel.jar:?]
                at com.liferay.portal.upgrade.v7_0_0.UpgradeCompanyId.access$100(UpgradeCompanyId.java:35) ~[portal-impl.jar:?]
                at com.liferay.portal.upgrade.v7_0_0.UpgradeCompanyId$CompanyIdNotNullTableUpdater.update(UpgradeCompanyId.java:120) ~[portal-impl.jar:?]
                at com.liferay.portal.kernel.upgrade.BaseCompanyIdUpgradeProcess.lambda$doUpgrade$0(BaseCompanyIdUpgradeProcess.java:62) ~[portal-kernel.jar:?]
                at com.liferay.portal.kernel.dao.db.BaseDBProcess.lambda$_processConcurrently$2(BaseDBProcess.java:379) ~[portal-kernel.jar:?]
                at java.util.concurrent.ForkJoinTask$AdaptedCallable.exec(ForkJoinTask.java:1448) ~[?:?]
                at java.util.concurrent.ForkJoinTask.doExec(ForkJoinTask.java:290) ~[?:?]
                at java.util.concurrent.ForkJoinPool$WorkQueue.topLevelExec(ForkJoinPool.java:1020) ~[?:?]
                at java.util.concurrent.ForkJoinPool.scan(ForkJoinPool.java:1656) ~[?:?]
                at java.util.concurrent.ForkJoinPool.runWorker(ForkJoinPool.java:1594) ~[?:?]
                at java.util.concurrent.ForkJoinWorkerThread.run(ForkJoinWorkerThread.java:183) ~[?:?]
        Suppressed: com.microsoft.sqlserver.jdbc.SQLServerException: The result set is closed.
                at com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDriverError(SQLServerException.java:237) ~[mssql-jdbc-10.2.0.jre11.jar:?]
                at com.microsoft.sqlserver.jdbc.SQLServerResultSet.checkClosed(SQLServerResultSet.java:472) ~[mssql-jdbc-10.2.0.jre11.jar:?]
                at com.microsoft.sqlserver.jdbc.SQLServerResultSet.next(SQLServerResultSet.java:1019) ~[mssql-jdbc-10.2.0.jre11.jar:?]
                at com.liferay.portal.dao.db.BaseDB.getIndexes(BaseDB.java:836) ~[portal-impl.jar:?]
                at com.liferay.portal.dao.db.BaseDB.dropIndexes(BaseDB.java:206) ~[portal-impl.jar:?]
                at com.liferay.portal.dao.db.SQLServerDB.alterColumnType(SQLServerDB.java:57) ~[com.liferay.portal.dao.db.jar:?]
                at com.liferay.portal.kernel.dao.db.BaseDBProcess.alterColumnType(BaseDBProcess.java:203) ~[portal-kernel.jar:?]
                at com.liferay.portal.upgrade.v7_0_0.UpgradeCompanyId.access$100(UpgradeCompanyId.java:35) ~[portal-impl.jar:?]
                at com.liferay.portal.upgrade.v7_0_0.UpgradeCompanyId$CompanyIdNotNullTableUpdater.update(UpgradeCompanyId.java:120) ~[portal-impl.jar:?]
                at com.liferay.portal.kernel.upgrade.BaseCompanyIdUpgradeProcess.lambda$doUpgrade$0(BaseCompanyIdUpgradeProcess.java:62) ~[portal-kernel.jar:?]
                at com.liferay.portal.kernel.dao.db.BaseDBProcess.lambda$_processConcurrently$2(BaseDBProcess.java:379) ~[portal-kernel.jar:?]
                at java.util.concurrent.ForkJoinTask$AdaptedCallable.exec(ForkJoinTask.java:1448) ~[?:?]
                at java.util.concurrent.ForkJoinTask.doExec(ForkJoinTask.java:290) ~[?:?]
                at java.util.concurrent.ForkJoinPool$WorkQueue.topLevelExec(ForkJoinPool.java:1020) ~[?:?]
                at java.util.concurrent.ForkJoinPool.scan(ForkJoinPool.java:1656) ~[?:?]
                at java.util.concurrent.ForkJoinPool.runWorker(ForkJoinPool.java:1594) ~[?:?]
                at java.util.concurrent.ForkJoinWorkerThread.run(ForkJoinWorkerThread.java:183) ~[?:?]
        Suppressed: java.lang.NullPointerException
                at com.microsoft.sqlserver.jdbc.SQLServerResultSet.next(SQLServerResultSet.java:1099) ~[mssql-jdbc-10.2.0.jre11.jar:?]
                at com.liferay.portal.dao.db.BaseDB.getIndexes(BaseDB.java:836) ~[portal-impl.jar:?]
                at com.liferay.portal.dao.db.BaseDB.dropIndexes(BaseDB.java:206) ~[portal-impl.jar:?]
                at com.liferay.portal.dao.db.SQLServerDB.alterColumnType(SQLServerDB.java:57) ~[com.liferay.portal.dao.db.jar:?]
                at com.liferay.portal.kernel.dao.db.BaseDBProcess.alterColumnType(BaseDBProcess.java:203) ~[portal-kernel.jar:?]
                at com.liferay.portal.upgrade.v7_0_0.UpgradeCompanyId.access$100(UpgradeCompanyId.java:35) ~[portal-impl.jar:?]
                at com.liferay.portal.upgrade.v7_0_0.UpgradeCompanyId$CompanyIdNotNullTableUpdater.update(UpgradeCompanyId.java:120) ~[portal-impl.jar:?]
                at com.liferay.portal.kernel.upgrade.BaseCompanyIdUpgradeProcess.lambda$doUpgrade$0(BaseCompanyIdUpgradeProcess.java:62) ~[portal-kernel.jar:?]
                at com.liferay.portal.kernel.dao.db.BaseDBProcess.lambda$_processConcurrently$2(BaseDBProcess.java:379) ~[portal-kernel.jar:?]
                at java.util.concurrent.ForkJoinTask$AdaptedCallable.exec(ForkJoinTask.java:1448) ~[?:?]
                at java.util.concurrent.ForkJoinTask.doExec(ForkJoinTask.java:290) ~[?:?]
                at java.util.concurrent.ForkJoinPool$WorkQueue.topLevelExec(ForkJoinPool.java:1020) ~[?:?]
                at java.util.concurrent.ForkJoinPool.scan(ForkJoinPool.java:1656) ~[?:?]
                at java.util.concurrent.ForkJoinPool.runWorker(ForkJoinPool.java:1594) ~[?:?]
                at java.util.concurrent.ForkJoinWorkerThread.run(ForkJoinWorkerThread.java:183) ~[?:?]

I am unable to debug what is causing this issue and what would be the root cause.