Policy Store connection issue

book

Article ID: 141275

calendar_today

Updated On:

Products

CA Single Sign On Secure Proxy Server (SiteMinder) AXIOMATICS POLICY SERVER CA Single Sign On Agents (SiteMinder) CA Single Sign On Federation (SiteMinder) CA Single Sign On SOA Security Manager (SiteMinder) SITEMINDER

Issue/Introduction

 

We're configuring the Policy Store manually, and when we run the command

  smreg -su password

the command reports error :

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

as 

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 we can't continue the Policy Store initialization.

How can we solve this ?

 

Environment

 

Release : 12.8.03

Component : SITEMINDER -POLICY SERVER

 

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.