12.8SP7 server repeatedly shows error like below in smps.log, and sometimes it says the connection recovered.
The error appears in interval timing between 5 minutes, 30 minutes, 2 hours, etc.
[1204347/139751097894656][Thu MM dd yyyy 11:04:21.515][HSTMT.cpp:245][Error][ERROR][sm-xpsxps-00800] While calling "SQLConnect(Example SiteMinder Data Source)", the following error occurred:
[1204347/139751097894656][Thu MM dd yyyy 11:04:21.515][HSTMT.cpp:259][Error][ERROR][sm-xpsxps-00810] Native Diagnostic: 08S01:0 [CA SSO][ODBC 20101 driver]7503
[1204347/139751097894656][Thu MM dd yyyy 11:04:21.515][HSTMT.cpp:259][Error][ERROR][sm-xpsxps-00810] Native Diagnostic: 21:-4 [CA SSO][ODBC 20101 driver][20101]10703
[1204347/139751097894656][Thu MM dd yyyy 11:04:21.515][XPSODBC.cpp:839][CXPSIOODBC][ERROR][sm-xpsxps-00960] Error obtaining ODBC handle.
[1204347/139751097894656][Thu MM dd yyyy 11:09:21.542][HSTMT.cpp:245][Error][ERROR][sm-xpsxps-00800] While calling "SQLConnect(Example SiteMinder Data Source)", the following error occurred:
[1204347/139751097894656][Thu MM dd yyyy 11:09:21.542][XPSODBC.cpp:839][CXPSIOODBC][ERROR][sm-xpsxps-00960] Error obtaining ODBC handle.
[1204347/139751097894656][Thu MM dd yyyy 11:14:21.991][Housekeeping.cpp:800][HouseKeeping][INFO][sm-xpsxps-00660] Recovered server connection.
....
[177240/139625020450560][Thu MM dd yyyy 18:07:33.003][XPSODBC.cpp:839][CXPSIOODBC][ERROR][sm-xpsxps-00960] Error obtaining ODBC handle.
[177240/139625020450560][Thu MM dd yyyy 18:07:33.002][HSTMT.cpp:259][Error][ERROR][sm-xpsxps-00810] Native Diagnostic: 21:-1 [CA SSO][ODBC 20101 driver][20101]13116
[177240/139625020450560][Thu MM dd yyyy 18:07:33.003][XPSODBC.cpp:839][CXPSIOODBC][ERROR][sm-xpsxps-00960] Error obtaining ODBC handle.
....
[177240/139625020450560][Thu MM dd yyyy 18:48:18.184][HSTMT.cpp:259][Error][ERROR][sm-xpsxps-00810] Native Diagnostic: 08001:0 [CA SSO][ODBC 20101 driver]7505
[177240/139625020450560][Thu MM dd yyyy 18:48:18.184][HSTMT.cpp:259][Error][ERROR][sm-xpsxps-00810] Native Diagnostic: 21:-1 [CA SSO][ODBC 20101 driver][20101]11603
[177240/139625020450560][Thu MM dd yyyy 18:48:18.185][XPSODBC.cpp:839][CXPSIOODBC][ERROR][sm-xpsxps-00960] Error obtaining ODBC handle.
Policy server: 12.8SP7
Policy Store: Oracle Database 19c
Several possible causes:
DB connection interval timing between 5 minutes, 30 minutes, 2 hours is by design. These DB connections will sleep for a while and then wake up.
/proc/sys/net/ipv4/tcp_keepalive_time=7200
Ask network team to check router performance and increase firewall idle timeout value settings.
Ask DBA to check Database performance or increase the max process limit on Oracle DB. This resolved the issue in the end.
Snoop or SnoopOracle packet logging tool, which is diagnosis tool provided by Progress DataDirect.
This Java-based utility is used to log network packets between a database and driver.
https://community.progress.com/s/article/3368