DB error while updating the password
search cancel

DB error while updating the password


Article ID: 204367


Updated On:


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



We're running a Policy Server and when this one tries to update a user
password in the ODBC Oracle User Directory, the User Directory returns
error :

  [10278/140280258844416][Mon Nov 30 2020 06:48:44][SmDsOdbcProvider.cpp:2355]
  [ERROR][sm-Odbc-00170] Database Error executing query ( 'Call Password_Update
  ****,myuser'). Error: Internal Error: Database error. Code is -4007 
  (DBMSG: <<<State = HY000 Internal Code = -6 - s>>>) .

How can we fixt this ?




Policy Server 12.8SP3 on RedHat 6




The issue looks like with the package on application side. SiteMinder
DB error has been resolved after our DB team re-run a specific package
which is responsible for password update on the DB side.