book
Article ID: KB0081490
calendar_today
Updated On:
Description
Sometimes TIBCO ActiveMatrix BusinessWorks Plug-in for Salesforce.com runs into below timeout error with queryAll activity. The timeout error usually happens when the query takes longer time than the timeout value ( default is 15 seconds). This happens either because there's lot of data in the query result, or network delay.
2018-Jun-28 10:00:36:082 WARN [pool-7-thread-1] c.t.b.p.s.r.SalesforceQueryActivity - TIBCO-BW-PALETTE-SALESFORCE-400007: The [ Salesforce Query All ] activity ends up with the error(s).
2018-Jun-28 10:00:36:097 ERROR [bwEngThread:In-Memory Process Worker-3] com.tibco.bw.core - <Data> <ns0:SalesforceExecuteSOAPMethodException xmlns:ns0="http://schemas.tibco.com/bw/plugins/salesforce/2.0/salesforceExceptions"> <msg>Error occurred while executing the Salesforce SOAP method: The method is query, details - ; nested exception is: java.net.SocketTimeoutException: Read timed out.-{ActivityName=SalesforceQueryAll, ProcessName=dw.module.Process, ModuleName=dw.module}</msg> <msgCode>TIBCO-BW-PALETTE-SALESFORCE-500026</msgCode> <methodName>query</methodName> <details>; nested exception is: java.net.SocketTimeoutException: Read timed out</details> </ns0:SalesforceExecuteSOAPMethodException> </Data> TIBCO-BW-CORE-500050: The BW process [dw.module.Process] instance faulted, JobId [bw0a100], ProcessInstanceId [bw0a100], ParentProcessInstanceId [-], Module [dw.module:1.0.0.20180628095654], Application [dw:1.0]. <CausedBy> TIBCO-BW-CORE-500051: Activity [SalesforceQueryAll] fault. <CausedBy> com.tibco.bw.palette.salesforce.runtime.exceptions.SalesforceExecuteSOAPMethodException: Error occurred while executing the Salesforce SOAP method: The method is query, details - ; nested exception is: java.net.SocketTimeoutException: Read timed out.-{ActivityName=SalesforceQueryAll, ProcessName=dw.module.Process, ModuleName=dw.module} <CausedBy> org.apache.axis.AxisFault: ; nested exception is: java.net.SocketTimeoutException: Read timed out <CausedBy> java.net.SocketTimeoutException: Read timed out
Issue/Introduction
How to resolve Saleforce plug-in timeout error
Resolution
This error can be resolved with one of the options below.
* increase the the timeout value by setting a longer timeout value in query input, _configData, timeout.
* Refine your query to limit the number of records in the result.
* If there's network latency, please involve the network team to fix the problem and make sure the connection is fast enough.