How to resolve Saleforce plug-in timeout error

How to resolve Saleforce plug-in timeout error

book

Article ID: KB0081490

calendar_today

Updated On:

Products Versions
TIBCO ActiveMatrix BusinessWorks Plug-in for Salesforce.com 6.3.0

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.