Hi All,
I am trying to call a Stored Procedure in BPM.
I have a scenario in which after JDBC receiver step i want to call a stored procedure which does some manipulation.(Plz note that SP doesn't need any parameters as Input and returns nothing).
Now i have done following steps:
1) Created a datatype with SP name as element and action as attribute having value "Execute".
2) Created Message Type
3) Created Abs Asynch interface
4)Mapping( same message is mapped to itself)
5)In Integration Process created a send step
6)Created a container with abstract interface
7) In Directory created service and channel
8) Reciver determination with sender service as IP and receiver service
9) Interface determination with sender service as IP n receiver service with receiver channel
10) Receiver agreement with sender service as IP n receiver service with receiver channel.
But Outbound status of my message is sent to be scheduled.
and in message monitoring i can find
"<Trace level="1" type="T">no interface found</Trace> "
Can anybody suggest me is anything wrong in steps?
How should i monitor BPM to know what exactly is going wrong?
Thanks,
Rohan