Hi ,
I am querying E-Business Suite package under APPS schema through APPS adapter in OSB. After monitoring SOA 12c logs ,EBS logs and OSB message reports we found the Business service of OSB had invoked APPS package multiple times .SOA logs clearly shows there was an SQL time out Connection broken error after 120 sec.We checked the timeouts in the domain ( FYI, SOA and OSB hosted in same domain but different clusters ).
The Non XA datasource used by the OSB BS has "Statement Timeout" property set to 120 sec . We are planning to override this timeout to "300" sec for this OSB application .This is an temporary change in OSB till the underlying EBS process tune their package.
I was going through " Doc ID 2002067.1 " .
syncMaxWaitTime < BPEL EJB's transaction timeout > Global Transaction Timeout (JTA timeout) <= XA transaction timeout < distributed lock timeout
a. Does the rule mentioned in the above doc id applicable even to OSB service though it doesn't involve BPEL process and also transactions
are not checked in OSB ?
b. I am using Non XA datasource.Does the above rule apply ?