SiteMinder Policy Server R12-SP3-CR02 fails to accept agent requests when started

Document ID : KB000050479
Last Modified Date : 14/02/2018
Show Technical Document Details

Description:

When a 6.x Policy Server is upgraded to version R12.x ,Then on starting the Policy server it fails to become ready and accept any new requests.

The SMPS.LOG will show the following Errors after startup

==============================================
[10572/27][Mon Feb 07 2011 11:10:12][CA.XPS:INIT0015][INFO] Initializing XPS Version 12.0.0302.316
[10572/27][Mon Feb 07 2011 11:10:14][CA.XPS:XPSIO039][INFO] Database Transactions are ON.
[10572/27][Mon Feb 07 2011 11:10:14][CA.XPS:ODBC0012][ERROR] An error occurred when calling "SQLExecDirect" for "Read Parameters" query
[10572/27][Mon Feb 07 2011 11:10:14][CA.XPS:ODBC0002][ERROR] 42S02:942 [DataDirect][ODBC Oracle Wire Protocol driver][Oracle]ORA-00942: table or view does not exist
[10572/27][Mon Feb 07 2011 11:10:14][CA.XPS:XPSIO007][INFO] 0 Parameter(s) loaded from Policy Store, 0 total.
[10572/27][Mon Feb 07 2011 11:10:14][CA.XPS:ODBC0012][ERROR] An error occurred when calling "SQLExecDirect" for "Initial Policy Data Read" query
[10572/27][Mon Feb 07 2011 11:10:14][CA.XPS:ODBC0002][ERROR] 42S02:942 [DataDirect][ODBC Oracle Wire Protocol driver][Oracle]ORA-00942: table or view does not exist
[10572/27][Mon Feb 07 2011 11:10:14][CA.XPS:XPSIO008][INFO] 0 object(s) loaded from the Policy Store.
[10572/27][Mon Feb 07 2011 11:10:14][CA.XPS:ODBC0012][ERROR] An error occurred when calling "SQLExecDirect" for "Update Parameter Setting" query
[10572/27][Mon Feb 07 2011 11:10:14][CA.XPS:ODBC0002][ERROR] 42S02:942 [DataDirect][ODBC Oracle Wire Protocol driver][Oracle]ORA-00942: table or view does not exist
[10572/27][Mon Feb 07 2011 11:10:14][CA.XPS:XPSIO024][ERROR] Save Policy Store ID failed.
=================================================

Solution:

When a 6.x Policy Server is upgraded to R12.x without upgrading the policy store then these errors occur because the 6.x policy store does not have the required additional objects(XPS schema) which is needed for R12.x Policy server to start up correctly.

To resolve this issue you would need to extend the R6.0 Policy Store so that it has the XPS schema extensions. More information on this is found in the R12 Policy Server upgrade guide PDF file in the section titled "Upgrade a 6.x Policy Store".

You can also rename the LIBXPS.SO or LIBXPS.DLL file that is located in the <siteminder_home>/lib directory. When this option is used, the Policy Server will not load the XPS components and therefore not load the XPS store. However, using this option you will not be able to register the webagents.

The fix for this issue would be available in R12-SP3-CR05 release.