Is there any example flow that uses the Error Boundary Event task? I am having issues using this event task to catch any exception that may occur to simply 'allow' the call. Right now if any exception occurs (ie; db task fails with db down condition), the caller will get disconnected. I reviewed all example flows and nothing appears to be using this block.

Ok I am getting this in a repeatable manner now. My flow uses a number of different custom tasks that I developed so I don't think it will help. The issue appears when intercepting a call and engaging AMS (via prompting or just playing an announcement) and disconnecting the call. If you disconnect the call and your flow has a error boundary event to 'allow' the call, the infinite loop will occur every time.

Some additional detail. It looks like the infinite loop occurs often when the caller/remote party disconnects during a play and collect task:

.
.
.
.
at com.roobroo.bpm.exec.Engine.completeTask(Engine.java:847)
at com.roobroo.bpm.im.InstanceManager.resumeInstance(InstanceManager.java:379)
at com.avaya.workflow.events.WorkFlowRuntimeEventListener.processRuntimeEvents(WorkFlowRuntimeEventListener.java:660)
at com.avaya.workflow.events.WorkFlowRuntimeEventListener.access$100(WorkFlowRuntimeEventListener.java:62)
at com.avaya.workflow.events.WorkFlowRuntimeEventListener$1.execute(WorkFlowRuntimeEventListener.java:109)
at com.avaya.workflow.events.WorkFlowRuntimeEventListener$1.execute(WorkFlowRuntimeEventListener.java:98)
at com.roobroo.bpm.db.TransactionAwareContext.execute(TransactionAwareContext.java:121)
at com.roobroo.bpm.db.TransactionAwareContext.execute(TransactionAwareContext.java:112)
at com.avaya.workflow.events.WorkFlowRuntimeEventListener.eventReceived(WorkFlowRuntimeEventListener.java:126)
at com.avaya.workflow.eventing.WFEventDao$1.call(WFEventDao.java:47)
at com.avaya.workflow.eventing.WFEventDao$1.call(WFEventDao.java:41)
at java.util.concurrent.FutureTask.run(FutureTask.java:277)
at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:522)
at java.util.concurrent.FutureTask.run(FutureTask.java:277)
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1153)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:628)
at java.lang.Thread.run(Thread.java:785)
Caused by: java.lang.StackOverflowError
at com.ibm.rmi.iiop.CDROutputStream.writeBoolean(CDROutputStream.java:369)
at com.ibm.rmi.iiop.CDRWriter.write_boolean(CDRWriter.java:374)
at com.ibm.rmi.iiop.EncoderOutputStream.write_boolean(EncoderOutputStream.java:559)
at com.ibm.rmi.io.IIOPOutputStream.defaultWriteObjectDelegate(IIOPOutputStream.java:792)
at com.ibm.rmi.io.OutputStreamHook.defaultWriteObject(OutputStreamHook.java:145)
at java.lang.Throwable.writeObject(Throwable.java:383)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:95)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:55)
at java.lang.reflect.Method.invoke(Method.java:508)
at com.ibm.rmi.io.IIOPOutputStream.invokeObjectWriter(IIOPOutputStream.java:1186)
at com.ibm.rmi.io.IIOPOutputStream.outputObject(IIOPOutputStream.java:1220)
at com.ibm.rmi.io.IIOPOutputStream.writeSerializable(IIOPOutputStream.java:1309)
at com.ibm.rmi.io.IIOPOutputStream.simpleWriteObjectInternal(IIOPOutputStream.java:641)
at com.ibm.rmi.io.IIOPOutputStream.simpleWriteObjectLoop(IIOPOutputStream.java:669)
at com.ibm.rmi.io.IIOPOutputStream.simpleWriteObject(IIOPOutputStream.java:751)
at com.ibm.rmi.io.FastPathForCollocated.copyUsingORBSerialization(FastPathForCollocated.java:1650)
at com.ibm.rmi.io.FastPathForCollocated.doCopy(FastPathForCollocated.java:541)
at com.ibm.rmi.io.FastPathForCollocated.deepCopy(FastPathForCollocated.java:284)
at com.ibm.rmi.iiop.ObjectCopierFactory$DeepObjectCopier.doWork(ObjectCopierFactory.java:332)
at com.ibm.rmi.iiop.ObjectCopierFactory$AbstractCopier.waitForCompletion(ObjectCopierFactory.java:171)
at com.ibm.rmi.iiop.ObjectCopierFactory$AbstractCopier.getCopy(ObjectCopierFactory.java:189)
at com.ibm.rmi.util.ProxyUtil.copyObject(ProxyUtil.java:371)
at com.ibm.CORBA.iiop.ClientDelegate.invoke0(ClientDelegate.java:1327)
at com.ibm.CORBA.iiop.ClientDelegate$ClientDelegate0.invoke(ClientDelegate.java:1531)
at com.sun.proxy.$Proxy231.readCallByUcid(Unknown Source)
... 4885 more
2018-08-17 14:40:21,500 [pool-44-thread-47] EngagementDesigner ERROR - EngagementDesigner-3.4.0.0.32008 - Error getting call object...
2018-08-17 14:40:21,501 [pool-44-thread-47] EngagementDesigner ERROR - EngagementDesigner-3.4.0.0.32008 - Error while executing instance for id: 344
java.lang.IllegalArgumentException: Call object not found...
at com.avaya.designer.task.communication.PlayCollectExecution.execute(PlayCollectExecution.java:203)
at com.roobroo.bpm.exec.Engine.executeNode(Engine.java:314)
at com.roobroo.bpm.exec.Engine.putTokens(Engine.java:1139)
at com.roobroo.bpm.exec.Engine.completeTask(Engine.java:847)

The ed logs roll over with the volume of entries and what I have above shows the last few entries (everything else is repeating in the log). I am going to have to see how to increase the logs to collect this volume or monitor and trap the initial entries to the log.

Bringing this thread back to the top. I have pinpointed the issue and it appears that the task does not like the date value found in the standard timeOfEvent field in the call object. Breeze, or the task, throws an unparsable date exception and doesn't attempt to invoke the jdbc connection.

You need to install the cert, from the api/https service that you are calling, on the breeze cluster. Open the https url in a browser and then download the cert to your hard drive. Take that cert and install it on the Breeze cluster (breeze cluster administration - certificate management drop down).

I have the same problem and it is difficult to pinpoint as there appears to be some race condition that doesn't happen on a specific event. I doesn't occur often but one in about 15 calls create this loop exception. The logs quickly overflow but you can see the exception below.

at com.roobroo.bpm.exec.Engine.executeNode(Engine.java:424)
at com.roobroo.bpm.exec.Engine.putTokens(Engine.java:1139)
at com.roobroo.bpm.exec.Engine.completeTask(Engine.java:847)
at com.roobroo.bpm.im.InstanceManager.resumeInstance(InstanceManager.java:379)
at com.avaya.workflow.events.WorkFlowRuntimeEventListener.processRuntimeEvents(WorkFlowRuntimeEventListener.java:660)
at com.avaya.workflow.events.WorkFlowRuntimeEventListener.access$100(WorkFlowRuntimeEventListener.java:62)
at com.avaya.workflow.events.WorkFlowRuntimeEventListener$1.execute(WorkFlowRuntimeEventListener.java:109)
at com.avaya.workflow.events.WorkFlowRuntimeEventListener$1.execute(WorkFlowRuntimeEventListener.java:98)
at com.roobroo.bpm.db.TransactionAwareContext.execute(TransactionAwareContext.java:121)
at com.roobroo.bpm.db.TransactionAwareContext.execute(TransactionAwareContext.java:112)
at com.avaya.workflow.events.WorkFlowRuntimeEventListener.eventReceived(WorkFlowRuntimeEventListener.java:126)
at com.avaya.workflow.eventing.WFEventDao$1.call(WFEventDao.java:47)
at com.avaya.workflow.eventing.WFEventDao$1.call(WFEventDao.java:41)
at java.util.concurrent.FutureTask.run(FutureTask.java:277)
at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:522)
at java.util.concurrent.FutureTask.run(FutureTask.java:277)
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1153)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:628)
at java.lang.Thread.run(Thread.java:785)
2018-08-10 10:53:59,287 [pool-129-thread-3] EngagementDesigner ERROR - EngagementDesigner-3.4.0.0.32008 - Error in getting the call object. Invalid callID:00002004291533912797
java.rmi.ServerError: Error occurred in server thread; nested exception is:
java.lang.StackOverflowError
at com.ibm.CORBA.iiop.UtilDelegateImpl.wrapException(UtilDelegateImpl.java:783)
at javax.rmi.CORBA.Util.wrapException(Util.java:290)
2018-08-10 10:53:59,312 [pool-129-thread-3] EngagementDesigner INFO - EngagementDesigner-3.4.0.0.32008 - Removing 266
2018-08-10 10:53:59,322 [pool-129-thread-3] EngagementDesigner INFO - EngagementDesigner-3.4.0.0.32008 - Adding 266 com.avaya.app.entity.Instance@630b3be3
2018-08-10 10:53:59,322 [pool-129-thread-3] EngagementDesigner INFO - EngagementDesigner-3.4.0.0.32008 - Removing 266
2018-08-10 10:53:59,322 [pool-129-thread-3] EngagementDesigner ERROR - EngagementDesigner-3.4.0.0.32008 - Error in processing
java.lang.RuntimeException: com.roobroo.bpm.exceptions.WorkflowException: Workflow problem is : There is infinite loop, please check the flow and the conditionsDataAccessException is: java.lang.Exception in method executeNode()
at com.roobroo.bpm.im.InstanceManager.resumeInstance(InstanceManager.java:396)
at com.avaya.workflow.events.WorkFlowRuntimeEventListener.processRuntimeEvents(WorkFlowRuntimeEventListener.java:660)
at com.avaya.workflow.events.WorkFlowRuntimeEventListener.access$100(WorkFlowRuntimeEventListener.java:62)
at com.avaya.workflow.events.WorkFlowRuntimeEventListener$1.execute(WorkFlowRuntimeEventListener.java:109)
at com.avaya.workflow.events.WorkFlowRuntimeEventListener$1.execute(WorkFlowRuntimeEventListener.java:98)
at com.roobroo.bpm.db.TransactionAwareContext.execute(TransactionAwareContext.java:121)
at com.roobroo.bpm.db.TransactionAwareContext.execute(TransactionAwareContext.java:112)
at com.avaya.workflow.events.WorkFlowRuntimeEventListener.eventReceived(WorkFlowRuntimeEventListener.java:126)
at com.avaya.workflow.eventing.WFEventDao$1.call(WFEventDao.java:47)
at com.avaya.workflow.eventing.WFEventDao$1.call(WFEventDao.java:41)
at java.util.concurrent.FutureTask.run(FutureTask.java:277)
at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:522)
at java.util.concurrent.FutureTask.run(FutureTask.java:277)
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1153)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:628)
at java.lang.Thread.run(Thread.java:785)
Caused by: com.roobroo.bpm.exceptions.WorkflowException: Workflow problem is : There is infinite loop, please check the flow and the conditionsDataAccessException is: java.lang.Exception in method executeNode()
at com.roobroo.bpm.exceptions.WorkflowExceptionFactory.getWorkflowException(WorkflowExceptionFactory.java:111)
at com.roobroo.bpm.im.InstanceManager.handleWorkflowException(InstanceManager.java:769)
... 16 more

Hi Bill,
Any thoughts on this?

Bill,
Thanks. I hope I am overlooking something or have the syntax off. I attached the wfd.
You can see the error that comes back from the GET request is complaining that the custom header value is not present yet I do have it set in the custom header field:

2018-08-05 12:38:20,037 [pool-129-thread-1] EngagementDesigner ERROR - EngagementDesigner-3.4.0.0.32008 - Received HTTP error response: HTTP/1.1 401 Unauthorized - Content: {

  "error":"appagent_missing",

  "error_description":"Missing appagent header/parameter"

}

I need to set a custom header in my REST Task (and also use oAuth2 for authentication). I appear to be able to get the oAuth process to work but the 'custom header' property in the Task only appears to apply to the oAuth REST call and not the actual REST service. Can you confirm if it is possible to set a custom header in the REST Task (not the oAuth query)? I would also love to see an example REST Task that uses oAuth if there is anything available.

I have tried just about everything and the issue appears to be due to the insert with a date/time. The Oracle EVENTTIME field is defined in the database as a TIMESTAMP (6) data type and in ED when I retrieve schema it shows this field as a string.

Some of the SQL I have tried is shown below:

INSERT INTO breezeroutinglog (EVENTTIME, EVENT, CALLINGPARTY, CALLEDPARTY, UCID) VALUES (TO_TIMESTAMP('?','YYYY-MM-DD hh24:mi:ss z'), ?, ?, ?, ?)

INSERT INTO breezeroutinglog (EVENTTIME, EVENT, CALLINGPARTY, CALLEDPARTY, UCID) VALUES (TO_TIMESTAMP(?,'YYYY-MM-DD hh24:mi:ss z'), ?, ?, ?, ?)

INSERT INTO breezeroutinglog (EVENTTIME, EVENT, CALLINGPARTY, CALLEDPARTY, UCID) VALUES (TO_TIMESTAMP(?,'YYYY-MM-DD hh24:mi:ss'), ?, ?, ?, ?)

INSERT INTO breezeroutinglog (EVENTTIME, EVENT, CALLINGPARTY, CALLEDPARTY, UCID) VALUES (?, ?, ?, ?, ?)

Hi Prakash,
The except that is occurring from the simple db insert is ORA-00933: SQL command not properly ended. I can pull the schema from the db but for whatever reason a simple insert is failing with this error. I have dumbed the insert down to a simple table with string columns and a single oracle identity (auto increment) column but the inserts will still fail with this exception.
Any insight would be greatly appreciated.
Thanks,
Brent

Re-posting from the Breeze forum:
Where can we see the SQL that is generated by the 'update db' or 'read from db' tasks? No matter the logging level I set for Engagement Designer, there is not logging of the SQL. If we monitor the running instance in ED, we only see the json payload and not the actual sql statements.

Where can we see the SQL that is generated by the 'update db' or 'read from db' tasks? No matter the logging level I set for Engagement Designer, there is not logging of the SQL.

Oracle JDBC 6 and 7 work now with Breeze 3.4 so long as you use oracle.jdbc.pool.OracleConnectionPoolDataSource as the class instead of oracle.jdbc.OracleDriver. This is apparently due to the JDNI based service providers that Breeze is now using. Hope this saves someone some headache.