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.

Policy Server Configuration Warning


Article ID: 105828


Updated On:


CA Single Sign On Secure Proxy Server (SiteMinder) CA Single Sign On SOA Security Manager (SiteMinder) CA Single Sign-On


The following is seen in the smps.log during startup. How do we resolve this?

[SmSSInDBStore.cpp:152][WARNING][sm-Server-07038] Policy Server is not configured correctly. The recommended value for the Maximum Session DB connections size should exceed the number of policy server worker threads by at least 2. (16, 32)

As each of the Policy Server's threads are capable of making a Session Store connection, it's important to allocate a sufficient number of ODBC data connections such that a connection is always available when needed.  Due to this, we recommend configuring at least twice as many connections as threads.  For example, if 16 threads are allocated to the Policy Server, at least 32 connections are recommended for the Session Store.


All supported Policy Server environments using ODBC Session Stores.  Does not apply to CA Directory Session Stores.


In the Policy Server Management Console, click on the Settings tab to confirm the Maximum Threads.  Next click the Data tab and then switch to the Session Store in the Database drop-down list where Maximum Connections can be configured.  Please note that any changes to these settings in the Management Console require a Policy Server restart before they will take effect.