Slowness when generating CA Risk Authentication Reports

Products

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

Issue/Introduction

Risk Authentication Report called Analyze Transaction Report runs very slow. It used to run fast but after upgrade it became very slow.

Environment

Release : 9.1.x

RiskMinder(Arcot RiskFort) Risk Authentication

Cause

The root cause of the delay in queries is that the query gets serialized behind any parallel purge operation already in progress on ARRFSYSAUDITLOG table. The purge operation inserts records into the archive table ARRFSYSAUDITLOG_AR before it can complete the purge on ARRFSYSAUDITLOG. 

Resolution

Please work with your DBA team to create the same index available on the ARRFSYSAUDITLOG table also on the ARRFSYSAUDITLOG_AR table. 

With 9.1SP1 release the report is runs as UNION ALL between the ARRFSYSAUDITLOG and ARRFSYSAUDITLOG_AR table, the later does not have same indexes so it takes time to display the results.

Additional Information

Note these indexes can be matched without any action on the Primary key.