Failed to find required [ODBC] block system_odbc.ini in Policy Server

Products

• SITEMINDER

Issue/Introduction

On the Policy Server machine, running the following command:

  /{home_policy_server}/bin/odbctest -dsn '/{home_policy_server}/db/system_odbc.ini' -table 'SMAGENT5' -uid '<user>' -pwd '<password>' -v

The command returns the error:

    CA, Inc.      ODBC Test Tool. (/{home_policy_server}/bin/odbctest)
     dsn = '/{home_policy_server}/db/system_odbc.ini'
     user id = '<user>'
     table = 'SMAGENT5'
    Failed to find required [ODBC] block within /{home_policy_server}/db/system_odbc.ini

 

Cause

The parameter "-dsn" should reflect a block name, not the path leading to the configuration file.

From this sample system_odbc.ini, one of the block names is "SiteMinder Data Source:

  [SiteMinder Data Source]
  Driver=/{home_policy_server}/odbc/lib/NSora28.so
  Description=DataDirect 8.0 Oracle Wire Protocol
  HostName=<hostname>
  PortNumber=1521

  [...omitted for brevity...]

 

Resolution

Run the command with the following options to solve this issue:

  # /{home_policy_server}/bin/odbctest -dsn '<blockname>' -table 'SMAGENT5' -uid '<user>' -pwd '<password>' -v