Issue Connecting to User Store

book

Article ID: 197289

calendar_today

Updated On:

Products

SITEMINDER

Issue/Introduction

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.

Cause

Unknown.  This seems to be a coincidence in timing as the problem could not be reproduced.

Environment

Release : ALL

Component : SITEMINDER - POLICY SERVER

Resolution

Problem occurred once and could not be reproduced.