Thank you for supporting the Cloud Customer Connect Community in 2024. It's a gift to work with you!

Look back
You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

Getting Timeout with Database adapter in OIC while executing view in EBS database

in Integration 2 comments

Summary:

We created an Oracle Database Adapter to connect Oracle Ebusiness Suite Database with an agent and query Views with a simple select query with one where condition. It's throwing a Timeout error intermittently for some views. Below is the complete error from OIC.


{

"type" : "http://www.w3.org/Protocols/rfc2616/rfc2616-sec10.html#sec10.5.1",

"title" : "Internal Server Error",

"detail" : "Internal server error. Please contact oracle support for details.",

"o:errorCode" : "500",

"o:errorDetails" : [ {

"type" : "UnMappedFault:XXXXXX",

"instance" : "NA",

"title" : "oracle.tip.adapter.sa.api.JCABindingException: DBReadInteractionSpec Execute Failed Exception.\nQuery name: [GetUserInvoiceListSelect], Descriptor name: [InvoiceList.XXXInvView].\nCaused by java.sql.SQLTimeoutException: ORA-01013: user requested cancel of current operation\n.\nSee root exception for the specific exception. This exception is considered not retriable, likely due to a modelling mistake. To classify it as retriable instead add property nonRetriableErrorCodes with value \"-1013\" to your deployment descriptor (i.e. weblogic-ra.xml).\nORA-01013: user requested cancel of current operation\n

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!