Error : Policy Server is not configured correctly with Session Store

Products

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

Issue/Introduction

 

The following is seen in the smps.log during startup. 

  [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 is 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, it's recommended to configure 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.

 

Environment

 

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

 

Resolution

 

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.