Skip to main content
We’re experiencing a recurring problem with our Jitterbit (the free version) completing transactions with SalesForce and were wondering if you could point us in the right direction to figuring it out. The job that fails is a query that is designed to call on SalesForce and return a list of about 300,000 records (well, actually, it returns 300,000 records of two fields, each). The query them dumps these records into a *.csv file and saves it to our computer. Later, another process uses that file to determine which records to delete before wiping it out. A query this small should not be subject to query time out, right?

 

Here is the error from Jitterbit:

 

Message:

 

The operation "02:00 AM PFA SF Labor to Delete Daily" failed.

 

Fatal Error:

 

Transformation failed.

 

Error:

 

Call to webservice at https://na5.salesforce.com/services/Soap/u/33.0/00D700000008pkL failed. Reported error:

 

The webservice call failed. The web service returned a SOAP Fault:

 

Code: sf:QUERY_TIMEOUT

 

Message: QUERY_TIMEOUT: Your query request was running for too long.

 

Detail: QUERY_TIMEOUTYour query request was running for too long.

 

Additional details:

 

Failed to call the web service at "https://na5.salesforce.com/services/Soap/u/33.0/00D700000008pkL".

 

Reason: The last (and probably most relevant) error was:

 

The server returned HTTP Status Code : 500 Server Error

 

Error is: The server encountered an unexpected condition that prevented it from fulfilling the request.

 

Headers sent by the server:

 

HTTP/1.1 500 Server Error

 

Date: Sun, 24 Jan 2016 08:00:11 GMT

 

Set-Cookie: BrowserId=X-jKMkB4R9WaDbJGUkp8QQ;Path=/;Domain=.salesforce.com;Expires=Thu, 24-Mar-2016 08:00:11 GMT

 

Expires: Thu, 01 Jan 1970 00:00:00 GMT

 

Content-Type: text/xml;charset=UTF-8

 

Transfer-Encoding: chunked

 

(The posted soap envelope was: 'C:/Windows/Temp/jitterbit_dl6/OpId_664036_3d643f48-b011-466d-970b-72565749b349/_t755836_target_req.xml'.) [CODE:10721] file: WebServiceHandler.cpp, line 997 [CODE:10104] file: TreeMapperWebService.cpp, line 142

 

Is there any help that you can point us to?
4 respuestas
  1. 8 feb 2016, 5:08 a.m.
    Hi ,

     

    You might get an answer here - there are tons of really smart admins in this community - however, this Answers Community is focused on configuration and design questions. Programmatic questions are best submitted to the developer forums at

     

     https://developer.salesforce.com

     

    http://salesforce.stackexchange.com/

     

    where the forums and participants are geared toward programming troubleshooting and support and the users there focus on code so you may get quicker answers as well as a wider variety of options.

     

    PS: Mark a best answer as well so that thread is closed and help us to keep community clean.

     

    Hi , You might get an answer here - there are tons of really smart admins in this community - however, this Answers Community is focused on configuration and design questions.