Failed to Import the Policy Store Data Definitions

Article Id: 107913

Status: Published

Updated On: 26-07-2018 00:59

Products:

CA Single Sign On Secure Proxy Server (SiteMinder) , AXIOMATICS POLICY SERVER , CA Single Sign On SOA Security Manager (SiteMinder) , CA Single Sign-On , CA Single Sign-On

Issue/Introduction:

Below error is reported in policy server trace when running XPSDDInstall SmMaster.dll after configuring Oracle 12c as Policy Store on Siteminder 12.7 Policy Server.

[07/23/2018][16:14][16:14:15][3728][2804][CSmDbODBC.cpp:946][CSmDbConnectionODBC::Connect][][][][][][][][][][][][][-4017][][][][][][][][Leave function CSmDbConnectionODBC::Connect][][][][][][][][][][][][][][][][][][][][][][][][][][][][][][][][][][][][][00:00:01.062579][]
[07/23/2018][16:14][16:14:15][3728][2804][CSmDbUtilities.cpp:465][][][][][][][][][][][][][][][][][][][][][][LogMessage:ERROR:[sm-Odbc-00060] Failed to connect to datasource 'CA SiteMinder DSN'.][][][][][][][][][][][][][][][][][][][][][][][][][][][][][][][][][][][][][][]

How can we resolve this error?

Cause:

We have created the DSN manually(This manual DSN was having the wrong password and locking the account - we had to delete it)

Environment:

SiteMinder 12.7 using Oracle 12c Database as Policy store

Resolution:

We configured the CA Siteminder Policy Server Configuration Wizard to configure the Policy Store and it ran successfully