You need to sign in to do that
Don't have an account?
jontk
Invalid date message for a querymore
Would anyone know why I would get an invalid date error for a querymore request?
Thanks,
Jon
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
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
2) Query: select Id,OwnerId, .... ,tocHardwareTotalInstallCost__c,tocLegacyAgreement__c,tocTemplateName__c from APTTUS__APTS_AGREEMENT__C where CreatedDate < 2008-03-14T17:54:39.409Z
Thanks,
Jon