I am currently running 3.4.0.1.09340120, and we are not able to upgrade at the moment.

I think the sample workflow in this thread from Prakash, would be a good solution to receive the call events. In theory at least...

I guess due to the unhandled exception, the call event for add-party-failed is never triggered.

I had a previous SR/discussion with Karthik about this, but at that time, it seemed more an issue with ForwardCall being an synchronous task. Workaround would be to make a custom (async) ForwardCall dynamic task which handles the call events.
But I am not sure this would work for 3.4, considering the new insight on the exception.

I'll contact Karthik about this and see what we can do.

I did some more tracing in Breeze.

After the ForwardCall I receive:
SIP/2.0 404 Not Found
which triggers this error: EngagementDesigner-3.4.0.1.00049 - errorResponseReceived caught exception.

See attachment Exception.txt for more details...

Prakash,

I am still using 3.4, so I had to re-create your example workflow, but that was no problem.

Whenever I use ForwardCall to an invalid destination, the ReceiveTask for Add ParticipantFailed is never triggered.

So this example WF does not seem to work (in 3.4?).

From another response I learned ForwardCall is an synchronous task, so will never return an error. This is supposedly fixed in 3.6.

Any ideas?

Joel,

I have the same issue but never got a reply:
https://www.devconnectprogram.com/forums/posts/list/22494.page


I'm trying to add some error handling for a ForwardCall to an invalid VDN on CM. This way I could try an alternate destination in case of a ForwardCall error.

In my workflow, the ForwardCall returns SUCCESS, but the Call is ended.

Next, I tried to use SetCallPolicy with Drop_Call_When_No_Participant_Remains, to keep the call active and try an alternate destination. But no events seem to be triggered.

Using AllowCall after the ForwardCall returns: java.lang.IllegalStateException: cannot invoke allow in current state

Do you know a way to check for the result of the ForwardCall, and try an alternate destination?



So, would I need to use SetCallPolicy with Drop_Call_When_No_Participant_Remains and use AddParticipant instead of ForwardCall?

Would adding an invalid Participant number (a CM VDN destination), return an error this way if unsuccessful?

Anyone got any ideas how to do this?

I'm trying to add some error handling for a ForwardCall to an invalid VDN on CM. This way I could try an alternate destination in case of a ForwardCall error.

In my workflow, the ForwardCall returns SUCCESS, but the Call is ended.

Next, I tried to use SetCallPolicy with Drop_Call_When_No_Participant_Remains, to keep the call active and try an alternate destination. But no events seem to be triggered.

Using AllowCall after the ForwardCall returns: java.lang.IllegalStateException: cannot invoke allow in current state


Do you know a way to check for the result of the ForwardCall, and try an alternate destination?

You returned data is probably just plain text, and not table output.

Search for "Oracle Pipelined Table Functions" to get an idea on how to generate table data.

Oops, I was thinking about MS SQL.

Don't know how this works in Oracle. Perhaps Rajesh can help you.

Did you test your function/procedure in Oracle directly and does it return row data?
I think the metadata parser in Breeze needs a returned row of data to be able to parse it.

Perhaps this will help you to translate the MS T-SQL example into Oracle SQL:
https://stackoverflow.com/questions/2059299/table-valued-functions-in-oracle-11g-parameterized-views

Ah yes, you need that query. :P

After you have entered the query (and perhaps substituting parameter values with ? in your query), you have to generate your input and output schema and continue with input and output mapping.

I think Rajesh describes the easiest way to do this and does not require writing a Dynamic Task.

You can find more info if you google for: Table-Valued Function.

Good Example: http://www.sommarskog.se/share_data.html#UDF

You can call your stored procedure from within the TVF and trigger it by quering the TVF from the "Read from DB" task.

Hi 1buckeyefan

Are you sure your query returns data?

You can test the output resultset with something like this:
ReadDbTaskOutputSchema["resultSet"].length > 0

You have to fill in the Validation Query, in order to test the connection.

Just enter: SELECT 1

and try again.

See PDF: Administering Avaya Breeze, table: Sample configuration for database providers

OK great!

To elaborate a bit on this request...

A separate import/export would be great, but perhaps another option might be useful as well.

I am trying to make a bundle of workflows, for easy deployment. The deployed workflows work fine, until you want to edit them on the deployed environment. Then, you miss the Event Catalog definitions and you cannot Deploy an edited workflow.

You can fix this of course, by manually creating all the Event Catalog definitions (or importing them when that option becomes available), but perhaps it's an idea to add the event catalog in the Bundle, together with the workflows?

Just my 2 cents... ;)

Right, that's why I post this as a feature request.

Could this somehow be put on a Breeze sprint backlog as a nice to have feature?

Hi,

Not sure if this is the right place to ask, but here goes...

We make extensive use of custom Event Catalog definitions in our workflows.

When deploying our workflows from test to production environment it is a bit tedious to create each Event Catalog one by one.

It would be great if an import/export function would be available, just like the ED workflows.