UDS error Unable to process the database query, usermgmt.userAuditLog,ORA-00001: unique constraint (ARCOTUSER.PK_ARUDS_USERAUDITLOG) violated
Article ID: 215055
Updated On:
Products
Issue/Introduction
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
Environment
Release : 9.x
Component : AuthMinder(Arcot WebFort)/ Strong AUthentication
RiskMinder(Arcot Riskfort)/ Risk Authentication
Resolution
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;
Feedback
