ICS Database Agent Time out error while querying 7000 records

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: {{