Failed to Import the Policy Store Data Definitions

Document ID : KB000107913
Last Modified Date : 26/07/2018
Show Technical Document Details
Issue:
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?
Environment:
SiteMinder 12.7 using Oracle 12c Database as Policy store
Cause:
We have created the DSN manually(This manual DSN was having the wrong password and locking the account - we had to delete it)
Resolution:
We configured the CA Siteminder Policy Server Configuration Wizard to configure the Policy Store and it ran successfully