Symantec Access Management

  • Private Community
 View Only

  • 1.  SIteMinder 12.9: Failed to initilize SiteMinder Policy Store

    Posted 21 days ago

    Hi Everyone,

    I am doing a fresh installation of SiteMinder 12.9 Policy Server on a RHEL 9.x and connecting to brand new policy store of Oracle 19c RAC.

    Installation and configuration is successful. when i start the SiteMinder Policy Server process, it is failing to start because of this error:

    smps.log:

    [2272732/140653189433152][Thu Nov 13 2025 14:14:33.965][SmObjProvider.cpp:251][INFO][sm-Server-02830] Initializing policy store provider 'ODBC:'

    [2272732/140653189433152][Thu Nov 13 2025 14:14:33.967][SmObjProvider.cpp:325][INFO][sm-Server-02840] Loading of policy store provider extension DLL: 'smobjodbcims' succeeded.

    [2272732/140652276872768][Thu Nov 13 2025 14:14:34.148][CSmDbSessionManager.cpp:553][INFO][sm-Server-04350] Using ODBC 'Policy Store' data source 'CA SiteMinder DSN'.

    [2272732/140653189433152][Thu Nov 13 2025 14:14:34.259][SmObjStore.cpp:1544][INFO][sm-Server-00060] Object store released

    [2272732/140653189433152][Thu Nov 13 2025 14:14:34.259][SmPolicyServer.cpp:871][ERROR][sm-Server-00450] Failed to initialize policy store

    smtracedefault.log:

    [11/13/2025][14:14:34.259][14:14:34][2272732][140653189433152][SmPolicyServer.cpp:871][][][][][][][][][][][][][][][][][][][][][][LogMessage:ERROR:[sm-Server-00450] Failed to initialize policy store ]

    I checked the DB connection to policy store from smconsole, It is successful.

    Also, when i ran this command (smreg -tu) - I am seeing this error:

    [11/14/2025][10:28:29.264][10:28:29][819268][139647747009792][CDb.cpp:265][CSmRecordset::DoSelect][][][][][][][][][][][][][][][][][][][][][Start processing SQL statement.]

    [11/14/2025][10:28:29.264][10:28:29][819268][139647747009792][CDb.cpp:356][CSmRecordset::Execute][][][][][][][][][][][][][][][][][][][][][Start processing SQL statement.]

    [11/14/2025][10:28:29.265][10:28:29][819268][139647747009792][CSmDbODBC.cpp:1542][CSmDbConnectionODBC::CheckForError][][][][][][][][][][][][42S02][-1][[CA SSO][ODBC Oracle Wire Protocol driver][Oracle]ORA-00942: table or view does not exist

    ][][][][][][][SQL Error.]

    [11/14/2025][10:28:29.265][10:28:29][819268][139647747009792][CSmDbODBC.cpp:375][CSmDbConnectionODBC::MapResult][][][][][][][][][][][][-1][][[CA SSO][ODBC Oracle Wire Protocol driver][Oracle]ORA-00942: table or view does not exist

    ][][][][][][][ODBC Error: State = 42S02 Internal Code = 942 - s - MappedResult:-1056]

    [11/14/2025][10:28:29.266][10:28:29][819268][139647747009792][CDb.cpp:329][CSmRecordset::DoSelect][][][][][][][][][][][][][Exception][Table or view not found.  Code is -1056 (DBMSG: <<<State = 42S02 Internal Code = 942 - s>>>)][][][][][][][Finish processing SQL statement.]

    [11/14/2025][10:28:29.266][10:28:29][819268][139647747009792][CSmDbConnection.cpp:241][CSmDbConnection::ReleaseReference][][][][][][][][][][][][][][][][][][][][][Release connection reference. ReferenceCount = '6']

    [11/14/2025][10:28:29.267][10:28:29][819268][139647747009792][CSmDbConnection.cpp:200][CSmDbConnection::MakeInactive][][][][][][][][][][][][][][][][][][][][][Inactivate connection.]

    [11/14/2025][10:28:29.267][10:28:29][819268][139647747009792][CSmDbUtilities.cpp:818][CSmDbMonitoredClass::SetState][][][][][][][][][][][][][][][][][][][][][Connection CA SiteMinder DSN: Changing object state 'Active' to state 'Available'.]

    [11/14/2025][10:28:29.267][10:28:29][819268][139647747009792][CSmDbConnection.cpp:241][CSmDbConnection::ReleaseReference][][][][][][][][][][][][][][][][][][][][][Release connection reference. ReferenceCount = '5']

    [11/14/2025][10:28:29.267][10:28:29][819268][139647747009792][CSmDbConnection.cpp:241][CSmDbConnection::ReleaseReference][][][][][][][][][][][][][][][][][][][][][Release connection reference. ReferenceCount = '4']

    [11/14/2025][10:28:29.267][10:28:29][819268][139647747009792][CSmDbConnection.cpp:241][CSmDbConnection::ReleaseReference][][][][][][][][][][][][][][][][][][][][][Release connection reference. ReferenceCount = '3']

    [11/14/2025][10:28:29.267][10:28:29][819268][139647747009792][CSmDbConnection.cpp:241][CSmDbConnection::ReleaseReference][][][][][][][][][][][][][][][][][][][][][Release connection reference. ReferenceCount = '2']

    [11/14/2025][10:28:29.267][10:28:29][819268][139647747009792][SmObjProvider.cpp:186][][][][][][][][][][][][][][][][][][][][][][LogMessage:ERROR:[sm-Server-03090] Policy store failed operation 'BulkFetch'  for object type 'Policy store provider' . Table or view not found.  Code is -1056 (DBMSG: <<<State = 42S02 Internal Code = 942 - s>>>)]

    The policy store could not be initialized.

    [11/14/2025][10:28:29.268][10:28:29][819268][139647103530560][SmReports.cpp:415][Audit log Poll Thread][][][][][][][][][][][][][][][][][][][][][Polling thread stopped]

    [11/14/2025][10:28:30.768][10:28:30][819268][139647747009792][CSmDbUtilities.cpp:818][CSmDbMonitoredClass::SetState][][][][][][][][][][][][][][][][][][][][][Session CA SiteMinder DSN: Changing object state 'Available' to state 'Dead'.]

    So, How to fix the policy store initilization error?

     



    -------------------------------------------


  • 2.  RE: SIteMinder 12.9: Failed to initilize SiteMinder Policy Store

    Broadcom Employee
    Posted 19 days ago

    Hi,

    just a usual question... did you create the Oracle Schema executing the creation query sql script as reported at this link:

    https://techdocs.broadcom.com/us/en/symantec-security-software/identity-security/siteminder/12-9/installing/install-a-policy-server/configure-odbc-databases-as-policy-session-key-and-audit-stores/configure-an-odbc-database-as-a-policy-store/how-to-configure-an-oracle-policy-store.html#concept.dita_7fbd108f717d2657575afcfe3e8a24db579749c4_CreatetheSchema

    regards

    Franco

    -------------------------------------------

    Original Message