Integration

Get Involved. Join the Conversation.

Topic

    Santosh K Jagtap
    ICS Agent- Message not received within 240 seconds of wait...
    Topic posted February 8, 2018 by Santosh K JagtapRed Ribbon: 250+ Points, last edited February 19, 2018 by Arijit ChakrabortyBronze Trophy: 5,000+ Points, tagged Agent, Integration 
    283 Views, 3 Comments
    Title:
    ICS Agent- Message not received within 240 seconds of wait interval
    Summary:
    ICS Agent- Message not received within 240 seconds of wait interval
    Content:

    Hi,

    Using ICS DB Adapter i query a onpremise oracle database table via  an ics agent.I am successful (more than 15000 records) if my table column count less than 10 but for a table where i have 60 columns where i need all field values when queried for 250 records things work out fine with no issue but when query more than 250 records it fails with following message. I understand ICS Agent default timeout property is 240sec.Is there a way to increase this limit.Otherwise only left out option is read records in chunks which actually makes my integration complex because downstream i need to build a xml file to be placed in a ftp location.

     

    I am using db adapter execute sql query (select * from table) for this....

     

    ==============

    _Rlt1id0001Gw0000J2> <1518106187890> <BEA-000000> <servicebus:/SYNCHEBSCUSTOMERTO3RDPARTYAPP_01/Resources/resources/application_15/inbound_16/resourcegroup_17/GetCustomerDATA_REQUEST.wsdl [ GetCustomerDATA_REQUEST_ptt::GetCustomerDATA_REQUEST(parameters,parameters) ] - Could not invoke operation 'GetCustomerDATA_REQUEST' against the 'database' due to:

    oracle.cloud.cpi.agent.transport.aq.CpiAQException: Message not received within 240 seconds of wait interval.>

    ####<Feb 8, 2018 4:09:47 PM UTC> <Error> <oracle.osb.transports.jca.jcatransport> <us2z32-ics-ics9003-ics-ms2.opcics.z32.usdc2.oraclecloud.com> <ics_server2> <[ACTIVE] ExecuteThread: '33' for queue: 'weblogic.kernel.Default (self-tuning)'> <tapas.banerjee@in.ibm.com> <> <005PBMLMr9xA9T3_Rlt1id0001Gw0000J2> <1518106187893> <OSB-381967> <Invoke JCA outbound service failed with application error, exception: com.bea.wli.sb.transports.jca.JCATransportException: oracle.cloud.cpi.agent.transport.aq.CpiAQException: Message not received within 240 seconds of wait interval.; nested exception is:

        javax.resource.ResourceException: oracle.cloud.cpi.agent.transport.aq.CpiAQException: Message not received within 240 seconds of wait interval.

    com.bea.wli.sb.transports.jca.JCATransportException: oracle.cloud.cpi.agent.transport.aq.CpiAQException: Message not received within 240 seconds of wait interval.; nested exception

     

    ============

     

    Santosh

    Comment

     

    • Amandeep Mahajan

      Regarding below, the recommended solution is to read the records in chunks. There is a limit to the size of the payload per message in ICS. So for your solution to scale to any given number of records, I would expect your solution to have some kind of batching in place. 

      "....

      when queried for 250 records things work out fine with no issue but when query more than 250 records it fails with following message. I understand ICS Agent default timeout property is 240sec.Is there a way to increase this limit.Otherwise only left out option is read records in chunks which actually makes my integration complex because downstream i need to build a xml file to be placed in a ftp location.

      "

    • Santosh K Jagtap

      but this solution makes me to make 60000/250= 240 calls to my database which is expensive.Any better option....

    • Kunal Sonje

      Hi,

      You can add below properties in startWeblogic.sh file

      -Dweblogic.http.client.defaultReadTimeout=10000

      -Dweblogic.http.client.defaultConnectTimeout=2000

      Refer https://docs.oracle.com/en/cloud/paas/integration-cloud-service/icski/new-properties-premises-agent-version-17.3.3.html for more details.

      This might help.

      Thanks,

      Kunal