Monthly Archives: March 2013

Duplicate instances when using DB adapter in high availability environment.

Many a times I have noticed that when you use DB Adapters (SOA Suite 11g) for integrating with applications like the E Business Suite in a clustered high availability environment, at times there will be multiple instances for the same request. The number of instances each entry in the DB would generate would directly correlate […]

read more

SOA 11g – Useful SOA Infra DB Queries [Advanced users]

Sometimes you want to identify all the faults for the messages that were sitting in BPEL Engine Level recovery as undelivered Invokes. We can run this SQL on the SOA Infra Schema to obtain this info. select wif.* FROM WI_FAULT WIF WHERE wif.cikey IN (SELECT ci.cikey FROM Dlv_Message dlv, cube_instance ci WHERE dlv.State = 0 AND […]

read more