Share all details related to your problem, including any error messages you may have received.
We are observing below mentioned error from few days and it’s been 2 months since we upgraded SailPoint from v8.0p2 to v8.4. We are also observing this error for few other access requests as well.
“An unexpected error occurred: org.hibernate.exception.JDBCConnectionException: could not extract ResultSet”
Kindly provide suggestions if anyone has faced similar issue. Thanks in advance.
Can you provide some context? Is this happening when you are attempting to request access? When you are trying to view an access request? Surely it’s not some random log file entry. This particular error is most common in custom code that someone has written to query the database, without catching that particular error. That error is thrown normally when a SQL query returns no records and you try to access the ResultSet anyway.
Hi and Hello,
I agree with @mercury, you need to provide more information.
The error you are encountering, org.hibernate.exception.JDBCConnectionException: could not extract ResultSet, is usually related to connectivity or database configuration issues.
A little hint:
Check for any time limits or maximum connection settings that may cause disconnection.
Is there any specific application that is causing this failure or there is any other customization that is causing this?
Can you follow log trail to check and isolate some user for which it is throwing this error. As there can be multiple sources for which this error may come.
For our case after upgrading, it was one custom connector which was having some dependency issue which was causing this error.