SiteMinder connection timeout to Audit DB

Idea created by tc.ip on Mar 23, 2015
    Not planned
    • peragren
    • Josh Perlmutter
    • Ujwol Shrestha

    We encounter an issue that when the audit database performing DB re-indexing or the DB somehow busy and no response, All SiteMinder thread will being hang and SSO is out of service.


    SiteMinder should implement a ODBC timeout mechanism to drop the connection if it is waiting too long from DB. Although one said audit data is important and we need to wait for DB to commit the insertion action. Can we implement the timeout mechanism one the DB no response, return the error and insert statement to smps.log such that administrator can follow up on the failure record?