KBI 311764 Issue Addressed: All Compliance Reports Showed No Data When Using SQL Authentication

Version

Argent Advanced Technology 5.1A-1907-C and below

Date

Tuesday, 16 July 2019

Summary

This a specific scenario to customers who,

  1. See all Compliance reports showed “No Data Is Available Matching The Specified Criteria For The Specified Period”; AND
  2. Archive compliance data using SQL Authentication in Argent for Compliance Rule level; AND
  3. Confirmed no data saved into compliance data



    Click For Full Size

Technical Background

Argent for Compliance by default saves compliance data into same database that Argent AT is running on

The product uses ‘Trusted Connection’, also known as ‘Windows Authentication’ for database connectivity for compliance data archiving

For customers who want to save compliance data into specific database(s) AND particularly can only work with SQL Authentication, they will need to configure the E19 screen as shown above

The symptom likely only surfaces when customer see all compliance reports showed “No Data Is Available Matching The Specified Criteria For The Specified Period”

Or noticed no data was saved into compliance database during health check

For this instance, Relator Trace Log will look completely healthy, however SVC Log will show error like below

10 Jul 2019 02:20:12.827 RADVWARG01 AG-0208-W10\svc_argent ***** ERROR ***** An error condition has been detected by ODBCResHandle.cpp (RODBCHANDLE::InitODBC) at line 359:

DAL could not open the ODBC backend database using connection string ‘Driver={SQL Server};Server=AG-0208-W10;Database=ARGENT_COMPLIANCE_DATA;Uid=SQLAdmin_TesT;Pwd=*********************

(Encrypted)’. (Called from ProcessAuditLog.cpp – 1684).

Microsoft Error Code = Login failed for user ‘SQLAdmin_TesT’. State:28000,Native:18456,Origin:[Microsoft][ODBC SQL Server Driver][SQL Server]

10 Jul 2019 02:20:12.827 AG-0208-W10 AG-0208-W10\svc_argent SQLDALConnect::Connect: ODBC backend (DSN: Driver={SQL Server};Server=AG-0208-W10;Database=ARGENT_COMPLIANCE_DATA;Uid=SQLAdmin_TesT;Pwd=**********************************************************************************************)

is not available

10 Jul 2019 02:20:12.827 AG-0208-W10 AG-0208-W10\svc_argent Failed to process audit log archive

The issue does not impact other Argent AT products that are running on MS SQL Server using SQL authentication

Reporting on SLA and performance data are fine

It is caused by coding error

Resolution

Upgrade to Argent Advanced Technology 5.1A-1907-D3 or above