Unable to connect to the Database in SiteMinder Policy Server due to extra line "QEWSD" in the DSN configuration.

Document ID : KB000053713
Last Modified Date : 14/02/2018
Show Technical Document Details

Description:

I'm trying to configure the Audit Store, but when the Policy Server starts up the smps log shows a message reporting a problem with the connection to the Audit Store:

[27759/1][Thu Jan 24 2008 13:17:42][SmReportsODBCLog.cpp:265][INFO] Possible network or configuration problem connecting to Audit Log Database

I have configured the Data Source Name (DSN) as described in the installation guide and I pretty sure all the information is correct.

My configuration is as follows:

[SiteMinder Logs Data Source]QEWSD=38931Driver=/apps/siteminder/odbc/lib/NSora21.soDescription=DataDirect 5.1 Oracle Wire ProtocolHostName=oracle-smaudit.ca.comPortNumber=1521SID=smauditCatalogOptions=0ProcedureRetResults=0EnableDescribeParam=0EnableStaticCursorsForLongData=0ApplicationUsingThreads=1

Solution:

This error is related to license problem with the Data Direct Driver. If no serial number is present or is corrupted in the license file then the driver will go into evaluation mode and add QEWSD line to the data source being initialized.

When the evaluation period has expired the driver will not allow connections to the database.

Please remove the QEWSD line from your system_odbc.ini file and verify that the license file (IVNS.LIC) exists under the $NETE_PS_ROOT/odbc directory. If the line shows up again that would suggest a problem with the license file and you may need to open a case with Siteminder Support.