We are experiencing the error ORA-00001: unique constraint (SA.IRS_2_UX) violated in the Action Processor.
Currently, we are using the following script as a workaround, executing it directly in the assyst database:
DELETE FROM ext_linkage
WHERE external_id = 'ACT_REG_ID'
AND external_owner = 'Action_Processor';
DELETE FROM integrations_record_status
WHERE owner = 'Action_Processor';
However, this error has been occurring more and more frequently. When it is not identified and addressed in time, executing this procedure ends up removing the Action Processor backlog, which may result in rules not being executed.
We would like to know whether there is a definitive solution for this issue or if it has already been fixed in more recent versions of the Action Processor.
Any assistance would be greatly appreciated.