Resolution:
Description:
===========
Exception thrown in PostRtc action- ORA-00001: unique constraint (beuser.I_WORKITEMSU) violated.


Environment:
==========
BusinessEvents 3.0.1

Symptoms:
=========
Exception in Inference Agent log file.

[WorkPool.Thread.2] - [runtime.service] Post RTC error
java.lang.RuntimeException: Action failed even after 10 attempts. Giving up. at com.tibco.cep.runtime.service.om.coherence.cluster.agents.RtcTransactionManager.runActions(RtcTransactionManager.java:425)
at com.tibco.cep.runtime.service.om.coherence.cluster.agents.RtcTransactionManager.applyTransactionToActions(RtcTransactionManager.java:573)
at com.tibco.cep.runtime.service.om.coherence.cluster.agents.RtcTransactionManager$TxnTask_Actions.run(RtcTransactionManager.java:751)
at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:886)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:908)
at com.tibco.cep.runtime.util.CustomBEManagedThread.run(CustomBEManagedThread.java:23)
Caused by: java.sql.SQLException: ORA-00001: unique constraint (beuser.I_WORKITEMSU) violated
at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:111)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:330)

Cause:
======
The workkey you use in Cluster.scheduleEvent() must be unique (primary unique key in the database).

NOTE:
The Event will be scheduled each time intervall till the scheduled Event will be removed using Cluster.removeSchedule(&ltscheduler>,&ltworkKey>);

Resolution:
========
Use a Unique workKey or remove the old scheduled Event before scheduling the Event again .

example:
String sWorkKey= "testsupport";
Cluster.removeSchedule("schedulerTest",sWorkKey);
Cluster.scheduleEvent ("schedulerPOC", sWorkKey, eventTest, DateTime.getTimeInMillis(DateTime.addMinute(DateTime.now(), 1)));