DBTRIM fails with Unique Constraint violation ORA-00001 (Oracle Database Error) on Advanced Authentication's ARWFGENERICCRED table

Products

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

Issue/Introduction

As a part of DBTRIM operation when the records of ARWFGENERICCRED are moved into ARWFGENERICCRED_AR table a unique constraint violation is detected. 

DB trim job fails with SQL Error - ORA-00001 - unique constraint violation

Error StackTrace::

Error processing table: ARWFGENERICCRED::java.sql.SQLIntegrityConstraintViolationException: ORA-00001: unique constraint violation (TACPIPY01_AA.SYS_C0027824)
oracle.jdbc.driver.T4CTTIoer11.processError(T4CTTIoer11.java:509)
oracle.jdbc.driver.T4CTTIoer11.processError(T4CTTIoer11.java:461)
oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:1104)

Environment

Release : 9.1.xx (Applicable to all the supported releases)

Component : AuthMinder(Arcot WebFort)

Cause

Collision on USEREFID and CREDNAME combination that makes the Primary Key of the ARWFGENERICCRED table

 

Resolution

====================================  Fix via change in arcotcommon.ini ==============================================

Please check the instance ID value in all the multi instance setup.

If the InstanceId value configuration is 1 or same in arcotcommon.ini for all the instances
<ARCOT_HOME>/arcotcommon.ini
[arcot/system]

InstanceId=1

Modify the InstanceId configuration value in arcotcommon.ini to some unique values for all the instances.
eg: Instanceid as  1 for the first instance and  Instanceid as 2 for second instance and so on.

<ARCOT_HOME>/arcotcommon.ini
[arcot/system]

InstanceId=1

Instance 2:
<ARCOT_HOME>/arcotcommon.ini
[arcot/system]

InstanceId=2

respectively for all the instances

============================================================ ===========================================================

Additional Information

None.