[gatec77]

Hi,

We are experiencing a lot of connection break between OTM and Oracle EBS. Everytime we have to bounce the BPEL instance to re-establish the connection. This is causing lot of pain. Is there any way to monitor the connection break?

For example: can we monitor some table in Oracle EBS like PO_OTM_OUT to see if there are any failures in that and then notify admin if there are any failures. Is this an option?
Has anybody done to resolve this ?

Any help will be much appreciated.

[jeff.depaul]

Hi,
We experienced some similar issues with connection failures with BPEL, but would be helpful to know more about your environment - can you publish what version of Fusion, relevant log file entries and maybe some of your settings related to connection factory or timeout values, using JNDI, domain.xml timeout value settings, etc. Also, what do you mean by "connection break" - these systems do not necessarily always maintain a constant connection but refer to connection string information at time of execution based on end-points. Specifically, are you loosing connection during a transmission?

Just from what you describe it sounds like your loosing connection on timeout response or acknowledgement. I assume these are asynch processes?

There isn't really a table in EBS you can monitor, if these are outbound transmissions which run Shipping Outbound concurrent process - make sure they are scheduled in the manager and check the log file there.

Have you checked the Recovery queue in BPEL Console?

Jeff