We are observing following error message in the arcotuds.log:
2021-04-30 10:27:27,761 EDT : [http-nio-8080-exec-10] : ERROR : common.api.UDSAuditLogUtil : [N/A] : [2efe77c1-ce0b-4cde-ac31-58fb3f3e40e3] : [35108] : Error while audit logging
com.arcot.euds.common.api.DataStoreException: Unable to process the database query, usermgmt.userAuditLog.
at com.arcot.euds.repositorymgmt.impl.rdb.usermgmt.db.UserService.userAuditLog(UserService.java:2570) ~[arcot-euds-2.0.jar:?]
at com.arcot.euds.common.api.UDSAuditLogger.logUserRecord(UDSAuditLogger.java:88) ~[arcot-euds-2.0.jar:?]
at com.arcot.euds.common.api.UDSAuditLogUtil.userAuditLog(UDSAuditLogUtil.java:59) ~[arcot-euds-2.0.jar:?]
at com.arcot.euds.common.api.UDSAuditLogUtil.callTxtnEndAPI(UDSAuditLogUtil.java:210) [arcot-euds-2.0.jar:?]
at com.arcot.euds.usermgmt.impl.UserManagerImpl.retreiveUser(UserManagerImpl.java:2588) [arcot-euds-2.0.jar:?]
at com.arcot.euds.usermgmt.ws.ArcotUserRegistrySvcSkeleton.retrieveUser(ArcotUserRegistrySvcSkeleton.java:232) [axis2416566002440804693usr-mgmt-2.0.aar:?]
at com.arcot.euds.usermgmt.ws.ArcotUserRegistrySvcMessageReceiverInOut.invokeBusinessLogic(ArcotUserRegistrySvcMessageReceiverInOut.java:337) [axis2416566002440804693usr-mgmt-2.0.aar:?]
at org.apache.axis2.receivers.AbstractInOutMessageReceiver.invokeBusinessLogic(AbstractInOutMessageReceiver.java:40) [axis2-kernel-1.7.7.jar:1.7.7]
at org.apache.axis2.receivers.AbstractMessageReceiver.receive(AbstractMessageReceiver.java:106) [axis2-kernel-1.7.7.jar:1.7.7]
at org.apache.axis2.engine.AxisEngine.receive(AxisEngine.java:169) [axis2-kernel-1.7.7.jar:1.7.7]
at org.apache.axis2.transport.http.HTTPTransportUtils.processHTTPPostRequest(HTTPTransportUtils.java:178) [axis2-transport-http-1.7.7.jar:1.7.7]
at org.apache.axis2.transport.http.AxisServlet.doPost(AxisServlet.java:163) [axis2-transport-http-1.7.7.jar:1.7.7]
at javax.servlet.http.HttpServlet.service(HttpServlet.java:661) [servlet-api.jar:?]
at javax.servlet.http.HttpServlet.service(HttpServlet.java:742) [servlet-api.jar:?]
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:231) [catalina.jar:8.5.23]
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) [catalina.jar:8.5.23]
at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52) [tomcat-websocket.jar:8.5.23]
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) [catalina.jar:8.5.23]
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) [catalina.jar:8.5.23]
at com.arcot.euds.web.UDSFilter.doFilter(UDSFilter.java:61) [classes/:?]
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) [catalina.jar:8.5.23]
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) [catalina.jar:8.5.23]
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:199) [catalina.jar:8.5.23]
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:96) [catalina.jar:8.5.23]
at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:478) [catalina.jar:8.5.23]
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:140) [catalina.jar:8.5.23]
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:81) [catalina.jar:8.5.23]
at org.apache.catalina.valves.AbstractAccessLogValve.invoke(AbstractAccessLogValve.java:650) [catalina.jar:8.5.23]
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:87) [catalina.jar:8.5.23]
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:342) [catalina.jar:8.5.23]
at org.apache.coyote.http11.Http11Processor.service(Http11Processor.java:803) [tomcat-coyote.jar:8.5.23]
at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:66) [tomcat-coyote.jar:8.5.23]
at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:868) [tomcat-coyote.jar:8.5.23]
at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1459) [tomcat-coyote.jar:8.5.23]
at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:49) [tomcat-coyote.jar:8.5.23]
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149) [?:1.8.0_151]
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624) [?:1.8.0_151]
at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61) [tomcat-util.jar:8.5.23]
at java.lang.Thread.run(Thread.java:748) [?:1.8.0_151]
Caused by: com.ibatis.common.jdbc.exception.NestedSQLException:
--- The error occurred while applying a parameter map.
--- Check the usermgmt.userAuditLog-InlineParameterMap.
--- Check the statement (update failed).
--- Cause: java.sql.SQLIntegrityConstraintViolationException: ORA-00001: unique constraint (ARCOTUSER.PK_ARUDS_USERAUDITLOG) violated
Release : 9.x
Component : AuthMinder(Arcot WebFort)/ Strong AUthentication
RiskMinder(Arcot Riskfort)/ Risk Authentication
As part of the upgrade process we are dropping the Primary key constraint from the ARUDSUSERAUDITLOG table, This process is also supposed to drop the index but that is not happening and because the Index exists the issue is observed. Please drop the index on the ARUDSUSERAUDITLOG table to resolve the issue.
ALTER TABLE ARUDSUSERAUDITLOG
DROP CONSTRAINT PK_ARUDS_USERAUDITLOG;
Once the Constraint is dropped the index can be dropped after that.
DROP INDEX PK_ARUDS_USERAUDITLOG;