+ Start a Discussion
jontkjontk 

Invalid date message for a querymore

Would anyone know why I would get an invalid date error for a querymore request?


Code:
Mar 14, 2008 02:50:14,045 PM [main] DEBUG org.apache.axis.transport.http.HTTPSender - Uncompressed message:
Mar 14, 2008 02:50:14,045 PM [main] DEBUG org.apache.axis.transport.http.HTTPSender - ---------------------------------------------------
Mar 14, 2008 02:50:14,048 PM [main] DEBUG org.apache.axis.transport.http.HTTPSender - 
<—xml version="1.0" encoding="UTF-8"–>
 <soapenv:Envelope xmlns:soapenv="http://schemas.xmlsoap.org/soap/envelope/" xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance">
 <soapenv:Header><ns1:SessionHeader soapenv:actor="http://schemas.xmlsoap.org/soap/actor/next" soapenv:mustUnderstand="0" xmlns:ns1="SforceService">
 <ns2:sessionId xmlns:ns2="urn:partner.soap.sforce.com">...</ns2:sessionId>
 </ns1:SessionHeader>
 <ns3:QueryOptions soapenv:actor="http://schemas.xmlsoap.org/soap/actor/next" soapenv:mustUnderstand="0" xmlns:ns3="SoapService">
 <ns4:batchSize xmlns:ns4="urn:partner.soap.sforce.com">200</ns4:batchSize>
 </ns3:QueryOptions></soapenv:Header>
 <soapenv:Body>
 <queryMore xmlns="urn:partner.soap.sforce.com">
 <queryLocator>01gT0000000ZkgBIAS-33000</queryLocator>
 </queryMore></soapenv:Body>
 </soapenv:Envelope>
Mar 14, 2008 02:50:14,202 PM [main] DEBUG org.apache.axis.components.net.DefaultSocketFactory - Created an SSL connection
Mar 14, 2008 02:50:14,203 PM [main] DEBUG org.apache.axis.transport.http.HTTPSender - XML sent:
Mar 14, 2008 02:50:14,203 PM [main] DEBUG org.apache.axis.transport.http.HTTPSender - ---------------------------------------------------
Mar 14, 2008 02:50:14,203 PM [main] DEBUG org.apache.axis.transport.http.HTTPSender - POST /services/Soap/u/9.0/191300DT0000000EExb HTTP/1.0
Content-Type: text/xml; charset=utf-8
Accept: application/soap+xml, application/dime, multipart/related, text/*
User-Agent: Axis/1.2.1
Host: tapp0-api.salesforce.com
Cache-Control: no-cache
Pragma: no-cache
SOAPAction: ""
Content-Length: 460
Accept-Encoding: gzip
Content-Encoding: gzip


Mar 14, 2008 02:50:14,844 PM [main] DEBUG org.apache.axis.transport.http.HTTPSender - HTTP/1.0 500 Internal Server Error
Mar 14, 2008 02:50:14,844 PM [main] DEBUG org.apache.axis.transport.http.HTTPSender - Server 
Mar 14, 2008 02:50:14,844 PM [main] DEBUG org.apache.axis.transport.http.HTTPSender - Cache-Control private
Mar 14, 2008 02:50:14,844 PM [main] DEBUG org.apache.axis.transport.http.HTTPSender - Cache-Control private
Mar 14, 2008 02:50:14,844 PM [main] DEBUG org.apache.axis.transport.http.HTTPSender - Content-Type text/xml; charset=utf-8
Mar 14, 2008 02:50:14,845 PM [main] DEBUG org.apache.axis.transport.http.HTTPSender - Date Fri, 14 Mar 2008 18:38:21 GMT
Mar 14, 2008 02:50:14,845 PM [main] DEBUG org.apache.axis.transport.http.HTTPSender - 
no Content-Length
Mar 14, 2008 02:50:14,845 PM [main] DEBUG org.apache.axis.transport.http.HTTPSender - 
XML received:
Mar 14, 2008 02:50:14,845 PM [main] DEBUG org.apache.axis.transport.http.HTTPSender - -----------------------------------------------
Mar 14, 2008 02:50:14,880 PM [main] DEBUG org.apache.axis.transport.http.HTTPSender - 
<˜xml version="1.0" encoding="UTF-8"™>
<soapenv:Envelope xmlns:soapenv="http://schemas.xmlsoap.org/soap/envelope/" xmlns:sf="urn:fault.partner.soap.sforce.com" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance">
<soapenv:Body><soapenv:Fault><faultcode>sf:UNKNOWN_EXCEPTION</faultcode>
<faultstring>UNKNOWN_EXCEPTION: Invalid Date</faultstring><detail>
<sf:fault xsi:type="sf:UnexpectedErrorFault"><sf:exceptionCode>UNKNOWN_EXCEPTION</sf:exceptionCode>
<sf:exceptionMessage>Invalid Date</sf:exceptionMessage></sf:fault></detail></soapenv:Fault>
</soapenv:Body>
</soapenv:Envelope>

 Thanks,
Jon

dkadordkador
Couple questions:

1.) What instance are you on?

2.) Do you have an example of the query you're using to generate the queryLocators used in the offending queryMore calls?

Thanks,
Dan
jontkjontk
1) Instance? Host: tapp0-api.salesforce.com

2) Query: select Id,OwnerId,  ....  ,tocHardwareTotalInstallCost__c,tocLegacyAgreement__c,tocTemplateName__c from APTTUS__APTS_AGREEMENT__C where CreatedDate &lt; 2008-03-14T17:54:39.409Z

Thanks,
Jon