Slowness in generating Risk Authentication reports after upgrade to CA advance Authentication 9.1.x also observing errors in Admin console,

Products

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

Issue/Introduction

After upgrading CA AA to 9.1 CP1 getting error while generating the Risk Authentication reports. The reports runs very slow as well, It was working fine before the upgrade to CA AA to 9.1 CP1.

2020-11-09 15:17:44,021 CET : [http-nio-8080-exec-37] : ERROR : web.controller.ErrorsController : [N/A] : [N/A] : [N/A] : [Arcot Admin Console] : [Admin Console] : [N/A] : javax.servlet.error.status_code::500
2020-11-09 15:17:44,021 CET : [http-nio-8080-exec-37] : ERROR : web.controller.ErrorsController : [N/A] : [N/A] : [N/A] : [Arcot Admin Console] : [Admin Console] : [N/A] : javax.servlet.error.message::Request processing failed; nested exception is java.lang.NullPointerException
2020-11-09 15:17:44,021 CET : [http-nio-8080-exec-37] : ERROR : web.controller.ErrorsController : [N/A] : [N/A] : [N/A] : [Arcot Admin Console] : [Admin Console] : [N/A] : javax.servlet.error.request_uri::/arcotadmin/Rf_ViewDetailActivityReport/view.htm
2020-11-09 15:17:44,021 CET : [http-nio-8080-exec-37] : ERROR : web.controller.ErrorsController : [N/A] : [N/A] : [N/A] : [Arcot Admin Console] : [Admin Console] : [N/A] : javax.servlet.error.servlet_name::arcotadmin
2020-11-09 15:17:44,021 CET : [http-nio-8080-exec-37] : ERROR : web.controller.ErrorsController : [N/A] : [N/A] : [N/A] : [Arcot Admin Console] : [Admin Console] : [N/A] : javax.servlet.error.exception_type::class java.lang.NullPointerException
2020-11-09 15:17:44,021 CET : [http-nio-8080-exec-37] : ERROR : web.controller.ErrorsController : [N/A] : [N/A] : [N/A] : [Arcot Admin Console] : [Admin Console] : [N/A] : javax.servlet.error.exception_class::null
2020-11-09 15:17:44,021 CET : [http-nio-8080-exec-37] : ERROR : web.controller.ErrorsController : [N/A] : [N/A] : [N/A] : [Arcot Admin Console] : [Admin Console] : [N/A] : N/A
java.lang.NullPointerException: null
 at com.arcot.admin.framework.web.init.ArcotAdminInitServlet.doDispatch(ArcotAdminInitServlet.java:79) ~[classes/:?]
 .............
 at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) ~[catalina.jar:9.0.37]
 at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) ~[catalina.jar:9.0.37]
 at com.arcot.admin.framework.web.utils.FrameworkSessionFilter.doFilter(FrameworkSessionFilter.java:87) ~[classes/:?]
 .............
2020-11-09 15:18:16,819 CET : [http-nio-8080-exec-20] : INFO  : paf.util.AdminAuthUtil : [N/A] : [N/A] : [N/A] : [Arcot Admin Console] : [Admin Console] : [N/A] : Bypassing the localhost check

 

Environment

Release : 9.1.x

Component : RiskMinder(Arcot RiskFort) Risk Authentication

Cause

With AA version 9.1.x we run the Analyze Transaction Report with UNION ALL between the two tables ARRFSYSAUDITLOG and ARRFSYSAUDITLOG_AR. The table ARRFSYSAUDITLOG_AR does not have indexes which makes the reports very slow and eventually return the error message or do not return expected results.

Resolution

Please work with your DBA and replicate the Indexes of ARRFSYSAUDITLOG table for ARRFSYSAUDITLOG_AR table.  This action should make the reports faster and resolve this issue. The reports are slow because the archive table (ARRFSYSAUDITLOG_AR) does not have the required  indexes as ARRFSYSAUDITLOG table does.

With 9.1 SP1 release the report is runs as UNION ALL between the ARRFSYSAUDITLOG and ARRFSYSAUDITLOG_AR table, the latter table (ARRFSYSAUDITLOG_AR) does not have same indexes as ARRFSYSAUDITLOG table so it takes time to display the results or even fails to complete the searches as these tables grow very large.

Additional Information

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