The policy store could not be initialized manual Policy Store config

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

 

When configuring the Policy Store manually, and running the command

  smreg -su password

the command reports the error:

    The policy store could not be initialized.
    Failed to create the super user account.

and seen in the Policy Server logs:

smps.log :

  [6840/2692][Thu Nov 28 2019 17:56:00][CServer.cpp:3887][INFO][sm-Server-01780] Starting main Reactor thread

  [6840/7084][Thu Nov 28 2019 17:56:00][CSmDbUtilities.cpp:465][ERROR][sm-Odbc-00060] Failed to connect to datasource 'myPStore128SP03'.

  [6840/4416][Thu Nov 28 2019 17:56:00][SmObjProvider.cpp:188][ERROR][sm-Server-03090] Policy store failed operation 'Save' for object type 'RootConfig'. Unexpected error in database interface. Error code -1063

XPSDDInstall.2019-11-25_160645.log :

  [3716/3652][Mon Nov 25 2019 16:06:47][CSmDbUtilities.cpp:465][ERROR][sm-Odbc-00060] Failed to connect to datasource 'myPStore128SP03'.

smtracedefault.log :

  [11/28/2019][17:56:00.494][17:56:00][6840][7084][CSmDbODBC.cpp:1411][CSmDbConnectionODBC::ProcessConnectError][][][][][][][][][][][][][][][][][][][][][Connection myPStore128SP03: Bad connection status on SQL call.][][][][][][][][][][][][][][][][][][][][][][][][][][][][][][][][][][][][][][]

  [11/28/2019][17:56:00.494][17:56:00][6840][7084][CSmDbUtilities.cpp:806][CSmDbMonitoredClass::SetState][][][][][][][][][][][][][][][][][][][][][Connection myPStore128SP03: Changing object state 'Initia
lized' to state 'Hung'.][][][][][][][][][][][][][][][][][][][][][][][][][][][][][][][][][][][][][][]

  [11/28/2019][17:56:00.494][17:56:00][6840][7084][CSmDbODBC.cpp:1553][CSmDbConnectionODBC::Disconnect][][][][][][][][][][][][][][][][][][][][][Connection myPStore128SP03: Disconnecting the connection.][][][][][][][][][][][][][][][][][][][][][][][][][][][][][][][][][][][][][][]

  [11/28/2019][17:56:00.494][17:56:00][6840][4416][CDb.cpp:729][CSmRecordset::Update][][][][][][][][][][][][][][Unexpected error in database interface. Error code -1063][][][][][][][Caught an exception 'Unexpected error in database interface. Error code -1063'][][][][][][][][][][][][][][][][][][][][][][][][][][][][][][][][][][][][][][]

As such the Policy Store initialization can't continue.

 

Environment

 

Policy Server 12.8SP3;

 

Resolution

 

Run command: 

  "siteminder_home\siteminder\install_config_info\ca-ps-config.exe" 

and select the option to initialize the Policy Store to solve the error when running the "smreg -su password" command.