Failed to connect to datasource and Unexpected error in database interface. Error code -1063

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.

https://techdocs.broadcom.com/content/broadcom/techdocs/us/en/ca-enterprise-software/layer7-identity-and-access-management/single-sign-on/12-8-03/installing/install-a-policy-server/configure-odbc-databases-as-policy-session-key-and-audit-stores/configure-an-odbc-database-as-a-policy-store/how-to-configure-an-oracle-policy-store.html#concept.dita_7fbd108f717d2657575afcfe3e8a24db579749c4_PointthePolicyServertotheDatabase