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?

Good afternoon, all!
We’re experiencing a recurring problem with the Jitterbit Data Loader (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.  Nothing more.  Just 300,000 records of two fields, each. Of course, the query then 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. An query this small should not be subject to query time out, right?

A further wrinkle is this:  the query only fails intermittently.  The query is set to run on a schedule at 0400 (a slow time for our network) and fails to execute about 70% of the time.  When the query is manually run during the more busy times of regular business hours, it usually fails the first time and sometimes a second time, but it usually goes through with no difficulty after that.  It puzzles me. 

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 way to resolve this issue?

Thanks,
Stephen D. Cox