Cases get stuck in work basket after moving to broken queque
Cases move to a broken queue and get stuck in the work basket. Error occurs in the broken queue. However, the user is unable to identify which entry causes the error.
ORA-00001: unique constraint (ABC_DATA.PC_HISTORY_WORK_PK) violated
Steps to Reproduce
Service Level Agreement (SLA) rule is configured with the activity running, upon reaching the dead line. The deadline is set to three minutes.
The issue is caused in multinode environments due to getCurrentTimeStampUnique.
The issue is fixed in 7.4.1 with Rule Utility Function (RUF) getCurrentTimeStampThreadUnique.
Published October 8, 2020
0% found this useful
Have a question? Get answers now.
Visit the Collaboration Center to ask questions, engage in discussions, share ideas, and help others.