ALERT: Some images may not load properly within the Knowledge Base Article. If you see a broken image, please right-click and select 'Open image in a new tab'. We apologize for this inconvenience.

The policy store could not be initialized manual Policy Store config

book

Article ID: 141275

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

 

When configuring the Policy Store manually, and running the
command

  smreg -su password

the command reports 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][CSmRec
  ordset::Update][][][][][][][][][][][][][][Unexpected error in databa
  se interface. Error code -1063][][][][][][][Caught an exception 'Une
  xpected error in database interface. Error code -1063'][][][][][][][
  ][][][][][][][][][][][][][][][][][][][][][][][][][][][][][][][]

and 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 you run "smreg -su password" command.