Problem Note 61641: When you try to view all terms in SAS® Business Data Network, the "Could not roll back JDBC transaction...connection has been closed" error occurs
When you use SAS® Business Data Network 3.1 or 3.2, you might see the following error when trying to view all terms:
Could not roll back JDBC transaction; nested exception is org.postgresql.util.PSQLException: This connection has been closed.
This problem happens when more than 32,000 terms have the same parent.
A workaround is to parent the terms to other terms so that fewer than 32,000 terms exist at any level.
Click the Hot Fix tab in this note to access the hot fix for this issue.
Operating System and Release Information
SAS System | SAS Business Data Network | Solaris for x64 | 3.2 | | 9.4 TS1M4 | |
Linux for x64 | 3.2 | | 9.4 TS1M4 | |
HP-UX IPF | 3.2 | | 9.4 TS1M4 | |
64-bit Enabled Solaris | 3.2 | | 9.4 TS1M4 | |
64-bit Enabled AIX | 3.2 | | 9.4 TS1M4 | |
Microsoft® Windows® for x64 | 3.2 | | 9.4 TS1M4 | |
*
For software releases that are not yet generally available, the Fixed
Release is the software release in which the problem is planned to be
fixed.
Type: | Problem Note |
Priority: | high |
Date Modified: | 2018-02-12 11:06:33 |
Date Created: | 2018-01-02 04:23:54 |