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

ICS Database Agent Time out error while querying 7000 records

Received Response
37
Views
6
Comments
edited Nov 16, 2017 8:00AM in Integration 6 comments

Summary

ICS Database Agent Time out error while querying 7000 records

Content

Hi

We are using ICS connectivity agent to communicate with On Premise database. We have a use case where we need to query the database table on the basis

of a group id. We can get more than 100K records at one point of time for a Group Id. But we have observed while querying around 7000 records itself, ICS is throwing an error

Below is the stack trace from ICS managed server

[2017-11-14T07:37:00.142+00:00] [ics_server1] [ERROR] [ESS-07004] [oracle.as.ess] [tid: ESS Execute Thread [RequestId:3165]] [userId: <anonymous>] [ecid: 005NUl^N6kjA9T3_Rld9id0004VZ0000Ip,0:3:229:1:100002400] [APP: ESSAPP] [ESS_JobMetadataID: JobDefinition://oracle/apps/ess/seeded/ics/IcsFlowJob] [ESS_RequestID: 3165] [ESS_Module: Processor] [FlowId: 0000LytSSa8ADShLpAp2iY1PzLhT00005F] Execution error for request 3165. Reason: ESS-07033 Job logic indicated a system error occurred while executing an asynchronous java job for request 3165. Job error is: com.oracle.bpel.client.BPELFault: faultName: {{

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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