Failed to connect to datasource - Single Sign on
Article ID: 189062
Updated On:
Products
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,
Feedback
