We see that there is a connection failure through adminui to the userstore configured in system_odbc.ini file, errors attached below from smps.log.
[10600/140087840978688][Tue Jul 21 2020 22:53:19][CSmDbUtilities.cpp:465][ERROR][sm-Odbc-00060] Failed to connect to datasource 'XXXXXXX'.
[10600/140089434806016][Tue Jul 21 2020 22:53:19][SmDsOdbcProvider.cpp:644][ERROR][sm-Server-02740] Unexpected error in database interface. Error code -1063
[10600/140089434806016][Tue Jul 21 2020 22:53:19][SmDsOdbcProvider.cpp:645][ERROR][sm-Odbc-00210] Failed to connect to any of the following data sources: 'XXXXXXX'.
But the user store connection was successful when we add a failover in adminui with no errors.
Unknown. This seems to be a coincidence in timing as the problem could not be reproduced.
Release : ALL
Component : SITEMINDER - POLICY SERVER