Error: Object store initialization failed from XPSSweeper and Policy Store after upgrading to 12.8.8

Products

• SITEMINDER

Issue/Introduction

Running XPSSweeper command on the Policy Server, this command reports the errors:

[INFO][sm-Server-02830] Initializing policy store provider 'ODBC:'
[INFO][sm-Server-02500] Loading event handler '/{home_policy_server}/lib/libXPSAudit.so'
[ERROR][sm-Odbc-00060] Failed to connect to datasource '<dsn_name>'.
[ERROR][sm-Server-03090] Policy store failed operation 'Save'  for object type 'RootConfig' . Unexpected error in database interface. Error code -1063
[ERROR][sm-Server-03090] Policy store failed operation 'BulkFetch'  for object type 'Policy store provider' . DoBulkFetch Failed

Resolution

Setting the ODBC traces in the system_odbc.ini with the following line:

TraceOpts=1

fixed the issue.

The XPSSweeper command works completely fine.

The test connection button from the smconsole returned a success message.