You need to sign in to do that
Don't have an account?
Stephen Cox 15
Jitterbit Query Timeout
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?
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?