ICS Database Agent Time out error while querying 7000 records
Summary
ICS Database Agent Time out error while querying 7000 recordsContent
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: {{