SiteMinder Policy Server 12.8.06 error "Check if the InstallDir parameter in system_odbc.ini is set correctly"

Products

• SITEMINDER

Issue/Introduction

When SiteMinder 12.8.06 is started we are seeing the following error messages:

[30215/139721420384000][Wed Feb 09 2022 12:10:24.250][CSmDbUtilities.cpp:392][ERROR][sm-Odbc-00070] Error Code is 0 message is 'State =    51 Internal Code = 6822435 - s'.
[30215/139721420384000][Wed Feb 09 2022 12:10:24.510][CSmDbODBC.cpp:1025][ERROR][sm-Server-07027] Check if the InstallDir parameter in system_odbc.ini is set correctly.  Please make sure that it contains the full path of the odbc directory within policy server home directory.

Environment

Release : 12.8.06

Component : SITEMINDER -POLICY SERVER

Cause

This happen only when PostgreSQL database server is used as a SiteMinder store

The Error is observed when PostgeSQL DataDirect driver is upgrated from 08.01.0079 (SiteMinder 12.8.05) to 8.08.01.0496 (SiteMinder 12.8.06)

The error is benign and does not affect Policy Server functionality.

Resolution

To get rid of the error messages:

1. Stop Policy Server
2. Take backup of  "ddpsql28.mo" file under locale folder: <PS_Installed_Path>/odbc/locale/en_US/LC_MESSAGES and rename/delete this file (ddpsql28.mo) from this location
3. Copy "NSpsql28.mo" file to the above mentioned location
4. Start Policy Server

Contact Broadcom support to get the NSpsql28.mo file