Problem Note 67043: You see the error "...This ResultSet is closed" in SAS® Business Data Network 3.3 after an upgrade to Postgres version 12
 |  |  |  |
After you upgrade to Postgres version 12 along with an upgrade to the SAS® 9.4M7 (TS1M7) release, you see the following error message while logging on to SAS Business Data Network 3.3:
This error occurs because the postgresql.jar file was not properly updated to support Postgres 12.
The workaround is to replace the file manually. Copy the properly upgraded and newer file from this location:
SAS-configuration-directory\Web\WebAppServer\SASServer1_1\lib\
Paste the file in the following location, in order to replace the incorrect file:
SAS-configuration-directory\Web\WebAppServer\SASServer13_1\lib\
Operating System and Release Information
| Product Family | Product | System | Product Release | SAS Release | ||
| Reported | Fixed* | Reported | Fixed* | |||
| SAS System | SAS Business Data Network | Microsoft® Windows® for x64 | 3.3 | 9.4 TS1M7 | ||
The full error message is "Could not open JDBC Connection for transaction; nested exception is org.postgresql.util.PSQLException: This ResultSet is closed."
| Type: | Problem Note |
| Priority: | high |
| Date Modified: | 2020-12-07 10:53:24 |
| Date Created: | 2020-12-04 06:11:06 |