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

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 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.1.x

Component : CA Strong Authentication

CA Risk Risk Authentication

Resolution

As part of the upgrade process the Primary Key constraint is dropped for the ARUDSUSERAUDITLOG table, This process should also drop the associated index but that this index is not dropped and hence the issue is observed. Please drop the index on the ARUDSUSERAUDITLOG table to resolve the issue.

Command #1 - Drop the Primary Key Constraint

ALTER TABLE ARUDSUSERAUDITLOG
DROP CONSTRAINT PK_ARUDS_USERAUDITLOG;

Command #2 -  Drop the index.

DROP INDEX PK_ARUDS_USERAUDITLOG;