Failed to connect to datasource and Unexpected error in database interface. Error code -1063
book
Article ID: 190432
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
Customer completed a parallel upgrade from Release 12.5x or later to Release 12.8.03.
They pointed the 12.8 SP3 Policy Server to the Existing Policy Store Instance (" Oracle Database ").
" TEST Connection " was successful from SMCONSOLE.
Before upgrading the " POLICY STORE " to 12.8 SP3 version, customer tried " XPSSweeper " and observed below errors.
------ XPSSweeper log from 12.8 SP3 Policy Server:
[990/139858397873920][Fri May 01 2020 09:17:08][CSmDbUtilities.cpp:465][ERROR][sm-Odbc-00060] Failed to connect to datasource 'CA SiteMinder DSN'. [990/139858811557664][Fri May 01 2020 09:17:08][SmObjProvider.cpp:188][ERROR][sm-Server-03090] Policy store failed operation 'Save' for object type 'RootConfig' . Unexpected error in database interface. Error code -1063 [990/139858811557664][Fri May 01 2020 09:17:08][SmObjCache.cpp:404][INFO][sm-Server-02800] Preloading policy store cache [990/139858811557664][Fri May 01 2020 09:17:08][SmObjCache.cpp:417][INFO][sm-Server-02860] BulkFetch policy store [990/139858811557664][Fri May 01 2020 09:17:08][SmObjProvider.cpp:181][ERROR][sm-Server-03090] Policy store failed operation 'BulkFetch' for object type 'Policy store provider' . DoBulkFetch Failed [990/139858811557664][Fri May 01 2020 09:17:08][SmAdapterStore.cpp:370][Init][ERROR][sm-xadobj-00010] Object store initialization failed. [990/139858811557664][Fri May 01 2020 09:17:08][Database.cpp:483][InitSmStore][FATAL][sm-xpsxps-03570] SiteMinder interface initialization failed. [990/139858811557664][Fri May 01 2020 09:17:08][Database.cpp:662][InitDB][WARN][Assert] Assert failed: pSmStore [990/139858811557664][Fri May 01 2020 09:17:08][XPSTools.cpp:161][CXPSTools][FATAL][sm-xpsxps-04120] Unable to initialize the XPS library.
------- FROM 12.8 SP3 Policy Server SMPS.log:
[822/139909767624448][Fri May 01 2020 08:47:07][CSmDbUtilities.cpp:465][ERROR][sm-Odbc-00060] Failed to connect to datasource 'CA SiteMinder DSN'.
[822/139911669896992][Fri May 01 2020 08:47:07][SmObjProvider.cpp:188][ERROR][sm-Server-03090] Policy store failed operation 'Save' for object type 'RootConfig' . Unexpected error in database interface. Error code -1063
[822/139911669896992][Fri May 01 2020 08:47:07][SmObjStore.cpp:1534][INFO][sm-Server-00060] Object store released
[822/139911669896992][Fri May 01 2020 08:47:07][SmPolicyServer.cpp:734][ERROR][sm-Server-00450] Failed to initialize policy store
Environment
Component : SITEMINDER -POLICY SERVER
Release: Any supported CA/Broadcom SSO (AKA CA Siteminder) versions.
Cause
Usually we observe these errors for various reasons but sometimes customers don't use the valid User name and Password account who has the full access rights to the database instance in the respective fields.
Resolution
We have to use the user who has " FULL DATABASE ACCESS " in smconsole.
Customer was using a valid user so therefore the ODBC " Test Connection " from SMCONSOLE was successful but it was not the primary user for the full DATABASE.
After updating the user Who has FULL DATABASE ACCESS resulted in the XPSSweeper running with out any errors and connecting OK.
Additional Information
As per the document, Enter and confirm the user name and password of the database account that has full access rights to the database instance in the respective fields.