ODBC User Store not connecting for container siteminder

Products

• CA Single Sign On Federation (SiteMinder)

Issue/Introduction

Cintainer siteminder is installed, when try to configure odbc user store on MS SQL, and click "View Contents" on adminUI, it shows "Error: [General] Could not contact the user directory."

The adminUI trace log shows,

[305/139959386220096][Mon Jun 17 2024 23:49:31.058][SmDsOdbcProvider.cpp:644][SMPSLOG][ERROR][sm-Server-02740] Unexpected error in database interface. Error code -1063
[06/17/2024][23:49:31.058][23:49:31][305][139959386220096][SmDsOdbcProvider.cpp:644][][SMTRACELOG][][][][][][][][][][][][][][][][][][][][][LogMessage:ERROR:[sm-Server-02740] Unexpected error in database interface. Error code -1063]
[305/139959386220096][Mon Jun 17 2024 23:49:31.058][SmDsOdbcProvider.cpp:645][SMPSLOG][ERROR][sm-Odbc-00210] Failed to connect to any of the following data sources: '<odbc dsn>'.
[06/17/2024][23:49:31.058][23:49:31][305][139959386220096][SmDsOdbcProvider.cpp:645][][SMTRACELOG][][][][][][][][][][][][][][][][][][][][][LogMessage:ERROR:[sm-Odbc-00210] Failed to connect to any of the following data sources: '<odbc dsn>'.]

Cause

We worked with customer and identified customer was using old images and new values.yaml.

Resolution

Redeploy the latest helm chart of server-components (version 12.8.801+3037).

Deployment was successful and connection to MSSQL user directory was successful.