search cancel

Failed to connect to datasource - Single Sign on

book

Article ID: 189062

calendar_today

Updated On:

Products

CA Single Sign On Secure Proxy Server (SiteMinder) CA Single Sign On Agents (SiteMinder) CA Single Sign On Federation (SiteMinder) CA Single Sign On SOA Security Manager (SiteMinder) SITEMINDER

Issue/Introduction

Newly installed policy server 12.8 64 bit windows 2016 getting failed to connect datasource. Find below error logs.

===================================================================================

[6964/6620][Sun Apr 05 2020 08:04:24][CServer.cpp:4288][INFO][sm-Server-03930] ThreadPool using priority thread count : 5

[6964/6620][Sun Apr 05 2020 08:04:24][CServer.cpp:4335][INFO][sm-Server-01810] Initialized Monitoring API

[6964/6620][Sun Apr 05 2020 08:04:25][CServer.cpp:4370][INFO][sm-Server-03640] Initialized Monitoring Agent Proxy

[6964/6620][Sun Apr 05 2020 08:04:25][CServer.cpp:4405][INFO][sm-Server-01820] Starting thread pool. Thread pool size is 128

[6964/6620][Sun Apr 05 2020 08:04:25][CServer.cpp:4409][INFO][sm-Server-01830] Starting main reactor thread (Network IO dispatcher)

[6964/6620][Sun Apr 05 2020 08:04:25][CServer.cpp:395][INFO][sm-Server-01680] Loaded Transact

[6964/6620][Sun Apr 05 2020 08:04:25][CServer.cpp:346][INFO][sm-Server-03580] ************************************************************

[6964/6620][Sun Apr 05 2020 08:04:25][CServer.cpp:346][INFO][sm-Server-03580] *****        SmTransact Version 12.8.0000.1761         *****

[6964/6620][Sun Apr 05 2020 08:04:25][CServer.cpp:346][INFO][sm-Server-03580] ************************************************************

[6964/6620][Sun Apr 05 2020 08:04:25][CServer.cpp:4433][INFO][sm-Server-01840] Initializing smpolicysrv

[6964/6620][Sun Apr 05 2020 08:04:25][SmAuthDsCache.cpp:241][INFO][sm-Directory-00450] UserAz cache is enabled for all policy resolutions

[6964/6620][Sun Apr 05 2020 08:04:25][SmAuthDsCache.cpp:137][INFO][sm-Directory-00420] Initializing user directory cache

[6964/6620][Sun Apr 05 2020 08:04:25][SmObjProvider.cpp:244][INFO][sm-Server-02830] Initializing policy store provider 'ODBC:'

[6964/6620][Sun Apr 05 2020 08:04:25][SmObjProvider.cpp:283][INFO][sm-Server-02840] Loading of policy store provider extension DLL: 'smobjodbcims' succeeded.

[6964/1508][Sun Apr 05 2020 08:04:25][CServer.cpp:3887][INFO][sm-Server-01780] Starting main Reactor thread

[6964/7104][Sun Apr 05 2020 08:04:25][CSmDbUtilities.cpp:465][ERROR][sm-Odbc-00060] Failed to connect to datasource 'SITEMINDER_PRIMARY'.

[6964/6620][Sun Apr 05 2020 08:04:26][SmObjProvider.cpp:188][ERROR][sm-Server-03090] Policy store failed operation 'Save'  for object type 'RootConfig' . Unexpected error in database interface. Error code -1063

[6964/6620][Sun Apr 05 2020 08:04:26][SmObjStore.cpp:1517][INFO][sm-Server-00060] Object store released

[6964/6620][Sun Apr 05 2020 08:04:26][SmPolicyServer.cpp:734][ERROR][sm-Server-00450] Failed to initialize policy store 

[6964/6620][Sun Apr 05 2020 08:04:26][CServer.cpp:4127][INFO][sm-Server-04230] The suspend timeout is 3600 seconds.

[6964/6620][Sun Apr 05 2020 08:04:26][CServer.cpp:4552][INFO][sm-Server-01880] smpolicysrv shutting down

[6964/6620][Sun Apr 05 2020 08:04:26][CServer.cpp:4571][INFO][sm-Server-01890] Unregistering from the Monitor

[6964/6620][Sun Apr 05 2020 08:04:26][CServer.cpp:4582][INFO][sm-Server-01900] Releasing Monitor API

[6964/6620][Sun Apr 05 2020 08:04:26][CServer.cpp:4599][INFO][sm-Server-01920] Stopping thread pool; waiting for threads to terminate.

[6964/6620][Sun Apr 05 2020 08:04:26][CServer.cpp:4606][INFO][sm-Server-04770] Stopping reactor thread ; waiting for threads to terminate.

[6964/1508][Sun Apr 05 2020 08:04:26][CServer.cpp:3896][INFO][sm-Server-01790] Ending main Reactor thread

[6964/6620][Sun Apr 05 2020 08:04:26][CServer.cpp:4655][INFO][sm-Server-01910] Thread pool stopped; proceeding with shutdown

[6964/6620][Sun Apr 05 2020 08:04:26][CServer.cpp:4667][INFO][sm-Server-01950] Stopped main reactor.

Environment

Release : 12.8

Component : SITEMINDER -WEB AGENT FOR APACHE

Resolution

check the "ODBC connection" 

In-order to check, go to location c:/system32 Odbcad32.exe and check the connection,