DBTrim execution affecting Risk Evaluation requests in Risk Authentication

Products

• CA Risk Authentication
• CA Advanced Authentication
• CA Advanced Authentication - Risk Authentication (RiskMinder / RiskFort)

Issue/Introduction

Risk Evaluation requests are unsuccessful for a specific period while the DBTrim utility is running. Once the DBTrim batch operation completes, all Risk Evaluation requests start receiving successful responses.

Environment

Symantec Risk Authentication 9.1.5.1

Resolution

The Symantec Advanced Authentication product team has released the patch Symantec-AdvAuth-9.1.5.1-DE660677-HotFix to add the required index on the ARRFSYSAUDITLOG and ARRFSYSAUDITLOG_3DSECURE tables before the trimming operation, and to remove the index once trimming is complete. The patch can be downloaded from the KB article as well.

Follow these steps to resolve the issue:

1. Apply the patch Symantec-AdvAuth-9.1.5.1-DE660677-HotFix.
2. Update dbtrim.properties by adding the DeleteBatchSize attribute after Enabled_Audit_Trim and CronValue_Audit_Trim:
   Enabled_Audit_Trim= true
   CronValue_Audit_Trim=0 10 11 ? * *
   DeleteBatchSize=100000
3. Restart the Application server.