1. Home
  2. Portal
  3. RE: Liferay 6.2 to 7.4 DB Upgrade Exception : The result set is closed.

RE: Liferay 6.2 to 7.4 DB Upgrade Exception : The result set is closed.

thumbnail
Jamie Sammons, modified 2 Years ago.
Liferay 6.2 to 7.4 DB Upgrade Exception : The result set is closed.
New Member Posts: 12 Join Date: 10/28/19 Recent Posts

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.

 

upgrade
thumbnail
Olaf Kock, modified 2 Years ago.
RE: Liferay 6.2 to 7.4 DB Upgrade Exception : The result set is closed.
Liferay Legend Posts: 6441 Join Date: 9/23/08 Recent Posts

From 7.0, Liferay CE only supports the Open Source databases, no longer SqlServer. If you're using CE: Please migrate to a supported database first. If you need SqlServer, consider Liferay DXP. There once was a community plugin (by Antonio Musarra) that added commercial database support to Liferay CE, but I lost track of it and his website seems no longer to exist.

thumbnail
Jamie Sammons, modified 2 Years ago.
RE: RE: Liferay 6.2 to 7.4 DB Upgrade Exception : The result set is closed.
New Member Posts: 12 Join Date: 10/28/19 Recent Posts

Hi Olaf, thanks for your reply! 
We are using 7.4 DXP in our project not the community edition. Also, we're getting this issue while using the direct upgrade path of database from 6.2 to 7.4. Should we go for a two phase upgrade approach like from 6.2 to 7.1 and then 7.1 to 7.4?

thumbnail
Olaf Kock, modified 2 Years ago.
RE: RE: Liferay 6.2 to 7.4 DB Upgrade Exception : The result set is closed.
Liferay Legend Posts: 6441 Join Date: 9/23/08 Recent Posts

As you're using DXP, you're right: The database itself should not be an issue (though its version might be). Best is to open a ticket - Upgrades are supported, and the Support staff might have seen this issue already, thus they might be able to help you without much guesswork.

They can also provide a recommended way through steps.

My personal rule of thumb is: When a large jump on versions fails, (at least) consider to go step by step (but ignore look&feel, aka your theme, on the way)

Dave has collected some helpful steps for contacting support that you might want to take into account

thumbnail
Alberto Chaparro, modified 2 Years ago.
RE: Liferay 6.2 to 7.4 DB Upgrade Exception : The result set is closed.
Liferay Master Posts: 560 Join Date: 4/25/11 Recent Posts

Hi Kaustabh,

This issue was solved in the GA22:
https://issues.liferay.com/browse/LPS-151414

​​​​​​​Can you use the latest Liferay 7.4 version?

thumbnail
Jamie Sammons, modified 2 Years ago.
RE: RE: Liferay 6.2 to 7.4 DB Upgrade Exception : The result set is closed.
New Member Posts: 12 Join Date: 10/28/19 Recent Posts

Hi Alberto,

Since I'm using DXP 7.4 Update 20, will updating the bundle to latest one resolve this issue (I mean DXP 7.4 Update 57? )