search cancel

UDS error Unable to process the database query, usermgmt.userAuditLog,ORA-00001: unique constraint (ARCOTUSER.PK_ARUDS_USERAUDITLOG) violated

book

Article ID: 215055

calendar_today

Updated On:

Products

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

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;