search cancel

Slowness in reports after upgrade to CA advance Authentication 9.1.x also getting errors in Admin console

book

Article ID: 203406

calendar_today

Updated On:

Products

CA Advanced Authentication - Strong Authentication (AuthMinder / WebFort) CA Strong Authentication CA Risk Authentication CA Advanced Authentication

Issue/Introduction

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

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.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:827) ~[spring-webmvc-3.1.0.RELEASE.jar:3.1.0.RELEASE]
 at org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:882) ~[spring-webmvc-3.1.0.RELEASE.jar:3.1.0.RELEASE]
 at org.springframework.web.servlet.FrameworkServlet.doPost(FrameworkServlet.java:789) ~[spring-webmvc-3.1.0.RELEASE.jar:3.1.0.RELEASE]
 at javax.servlet.http.HttpServlet.service(HttpServlet.java:652) ~[servlet-api.jar:4.0.FR]
 at javax.servlet.http.HttpServlet.service(HttpServlet.java:733) ~[servlet-api.jar:4.0.FR]
 at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:231) ~[catalina.jar:9.0.37]
 at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) ~[catalina.jar:9.0.37]
 at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:53) ~[tomcat-websocket.jar:9.0.37]
 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/:?]
 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 org.springframework.web.filter.CharacterEncodingFilter.doFilterInternal(CharacterEncodingFilter.java:88) ~[spring-web-3.1.0.RELEASE.jar:3.1.0.RELEASE]
 at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:76) ~[spring-web-3.1.0.RELEASE.jar:3.1.0.RELEASE]
 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 org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:202) ~[catalina.jar:9.0.37]
 at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:96) ~[catalina.jar:9.0.37]
 at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:541) ~[catalina.jar:9.0.37]
 at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:139) [catalina.jar:9.0.37]
 at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:92) [catalina.jar:9.0.37]
 at org.apache.catalina.valves.AbstractAccessLogValve.invoke(AbstractAccessLogValve.java:690) [catalina.jar:9.0.37]
 at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:74) [catalina.jar:9.0.37]
 at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:343) [catalina.jar:9.0.37]
 at org.apache.coyote.http11.Http11Processor.service(Http11Processor.java:373) [tomcat-coyote.jar:9.0.37]
 at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:65) [tomcat-coyote.jar:9.0.37]
 at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:868) [tomcat-coyote.jar:9.0.37]
 at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1589) [tomcat-coyote.jar:9.0.37]
 at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:49) [tomcat-coyote.jar:9.0.37]
 at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source) [?:1.8.0_261]
 at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source) [?:1.8.0_261]
 at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61) [tomcat-util.jar:9.0.37]
 at java.lang.Thread.run(Unknown Source) [?:1.8.0_261]
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

Component : AuthMinder(Arcot WebFort)

RiskMinder(Arcot RiskFort)

Cause

With 9.1 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.

Resolution

Please work with your DBA and replicate the Indexes of ARRFSYSAUDITLOG table for ARRFSYSAUDITLOG_AR and that should make the reports faster and resolve this issue. The reports are slow because the Archive table does not have the indexes.

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.