SiteMinder Access Gateway : Slow Response with : Exception java.io.IOException: Broken pipe

Products

• SITEMINDER

Issue/Introduction

Below error were observed in the webagent.log file of Access Gateway and response in reaching backend application has drastically reduced.

[3304957/139959204775680][Wed May 21 2025 10:48:03.857][Noodle.java][ERROR][sm-ProxyAgent-00100] Exception caught. Message is: Exception writing to response output stream : org.apache.catalina.connector.ClientAbortException java.io.IOException: Broken pipe

Environment

R12.8.x

MS SQL : Session Store

 

Cause

As per the investigation it was observed that SiteMinder Session store  MS SQL has been reaching the deadlock situation and unable to create new session for the new authentication requests by the users , until the Session store can accommodate in creating the new sessions ultimately causing the response delays from the access gateway in reaching the backend application.

Here is the smtracedefault.log snippet for reference.

[06/09/2025][10:19:48.103][10:19:48][4424][6500][CSmDbODBC.cpp:1472][CSmDbConnectionODBC::CheckForError][][][][][][][][][][][][40001][-1][[CA SSO][ODBC SQL Server Wire Protocol driver][Microsoft SQL Server]Transaction (Process ID 63) was deadlocked on lock resources with another process and has been chosen as the deadlock victim. Rerun the transaction.][][][][][][][SQL Error.]

Resolution

The issue is caused because of the deadlocks identified at MS SQL session store and need to be fixed at ODBC side.

Involve the DBA to  identify the deadloacks and fix them accordingly to resolve the slow response of application accessibly via SiteMinder Access Gateway.