• jontk
  • NEWBIE
  • 0 Points
  • Member since 2004

  • Chatter
    Feed
  • 0
    Best Answers
  • 0
    Likes Received
  • 0
    Likes Given
  • 21
    Questions
  • 12
    Replies
I am calling getDeleted on two different History object which is returning the SAME salesforce id.
Is this a bug?

Thanks
Jon

Soap log:

Jun 23, 2008 05:04:06,843 PM [main] DEBUG org.apache.axis.transport.http.HTTPSender -
    ...
    <soapenv:Body>
    <getDeleted xmlns="urn:partner.soap.sforce.com">
        <sObjectType>Sprint_Item__History</sObjectType>
            <startDate xsi:type="xsd:dateTime">2008-06-23T20:44:33.000Z</startDate>
            <endDate xsi:type="xsd:dateTime">2008-06-23T21:02:58.000Z</endDate>
        </getDeleted>
    </soapenv:Body>
   
Jun 23, 2008 05:04:07,468 PM [main] DEBUG org.apache.axis.transport.http.HTTPSender -
    ...
    <soapenv:Body>
        <getDeletedResponse>
            <result>
                <deletedRecords>
                    <deletedDate>2008-06-23T20:44:08.000Z</deletedDate>
                    <id>0170000000ACI4HAAX</id>
                    </deletedRecords>
                <earliestDateAvailable>2008-05-16T19:45:00.000Z</earliestDateAvailable>
                <latestDateCovered>2008-06-23T21:02:00.000Z</latestDateCovered>
            </result>
        </getDeletedResponse>
    </soapenv:Body>



Jun 23, 2008 05:05:00,187 PM [main] DEBUG org.apache.axis.transport.http.HTTPSender -
    ...
    <soapenv:Body>
        <getDeleted xmlns="urn:partner.soap.sforce.com">
            <sObjectType>Sprint__History</sObjectType>
            <startDate xsi:type="xsd:dateTime">2008-06-23T20:44:33.000Z</startDate>
            <endDate xsi:type="xsd:dateTime">2008-06-23T21:02:58.000Z</endDate>
        </getDeleted>
    </soapenv:Body>

Jun 23, 2008 05:05:00,781 PM [main] DEBUG org.apache.axis.transport.http.HTTPSender -
    ...
    <soapenv:Body>
        <getDeletedResponse>
            <result>
                <deletedRecords>
                    <deletedDate>2008-06-23T20:44:08.000Z</deletedDate>
                    <id>0170000000ACI4HAAX</id>
                </deletedRecords>
                <earliestDateAvailable>2008-05-16T19:45:00.000Z</earliestDateAvailable>
                <latestDateCovered>    2008-06-23T21:02:00.000Z</latestDateCovered>
            </result>
        </getDeletedResponse>
    </soapenv:Body>

  • June 23, 2008
  • Like
  • 0
Has anyone seen this soap response before and might now what it means?

<?xml version="1.0" encoding="UTF-8"?><soapenv:Envelope xmlns:soapenv="http://schemas.xmlsoap.org/soap/envelope/">
<soapenv:Body>
<soapenv:Fault>
<faultcode>soapenv:Server</faultcode><faultstring/>
</soapenv:Fault>
</soapenv:Body>
</soapenv:Envelope>

This occurred during an extract of attachments and a querymore call which was running for an extended amount of time.

Thanks,
Jon
  • April 18, 2008
  • Like
  • 0
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

  • March 14, 2008
  • Like
  • 0
I may be asking something simple but could someone explain the error message that I've included below.
Does this mean that the background process that purges a company's recycle bin was executed after my specified start date?

I've checked the api doc but am still a litttle unclear as to what the error below is and how to resolve it.

Thanks in advance,
Jon

INVALID_REPLICATION_DATE: The specified startDate, Mon Apr 23 20:55:00 GMT 2007, is before the last retained delete event date, Tue Apr 24 05:07:00 GMT 2007, for entity Attachment

  • May 10, 2007
  • Like
  • 0
Can someone confirm that modifying any fields on an OpportunityLineItem or OpportunityLineItemSchedule will automatically update the related Opportunity's LastModifiedDate or SystemModstamp?

Thanks in advance.
Jon
  • March 07, 2007
  • Like
  • 0
Is there a time limit as to how long a querymore locator/cursor will live even if I'm actively calling it to get additional records?

I am trying to retrieve about a million records which takes 5+ hours and am getting the error below around 5 hours in:

UNKNOWN_EXCEPTION: An unexpected error occured. Please include this ErrorId if you contact support: 1266558833-34

Thanks,
Jon
  • October 30, 2006
  • Like
  • 0
I am getting a connection reset error consistently when attempting to pass in 200 records for a create with 37 text fields and 2  text area long fields.

Could this be due to passing too much data?
If so, is there a recommended limit on how many fields I should send with each batch?

Thanks,
Jon
  • August 23, 2006
  • Like
  • 0
Is the AppExchange suppose to recoginize deltas between different versions of applications that I register?
Such as new custom fields or new objects from the previous version I submitted?

Thanks in advance,
Jon
  • April 17, 2006
  • Like
  • 0
Hi,

I can't seem to change the batch size on my select calls.  Could someone make a sanity check here to make sure I haven't made a silly mistake.

I'm trying to set the batch to 25 and I keep getting back 113 records.

I'm also using compression which I doubt is the cause of anything,

Thanks!
Jon

Java code:

        QueryOptions qo = new QueryOptions();
        qo.setBatchSize(new Integer(25));
        binding.setHeader(new SforceServiceLocator().getServiceName().getNamespaceURI(), "QueryOptions", qo);
        QueryResult selectResult = null;
        try {
            selectResult = binding.query(sql);


SOAP message:

<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">left out of posting</ns2:sessionId>
        </ns1:SessionHeader>
        <ns3:QueryOptions soapenv:actor="http://schemas.xmlsoap.org/soap/actor/next" soapenv:mustUnderstand="0" xmlns:ns3="urn:partner.soap.sforce.com">
            <ns3:batchSize>25</ns3:batchSize>
        </ns3:QueryOptions>
    </soapenv:Header>
    <soapenv:Body><query xmlns="urn:partner.soap.sforce.com">
        <queryString>Select Id, Name, ParentId from Account </queryString></query>
    </soapenv:Body>
</soapenv:Envelope>


  • March 30, 2006
  • Like
  • 0
Hi,

I have a data replication application that uses the last modified date and time to get a delta of changed records since the last run of the application.
I've noticed that when I update a formula on a calculated field, the last modified date and time and the system modified stamp does not get updated when the records have been recalculated with the new value.

Can someone from Salesforce confirm this for me and if so what a suggested solution might be to get these records?

Thanks in advnace!
Jon
  • February 01, 2006
  • Like
  • 0
Has anyone had any luck getting the Axis 1.3 version with compression to work?
I followed the note's on the pocketsoap website and in addition I had to get the commons-httpclient-3.0 release candidate version and commons-codec-1.3 version.

I seem to have it partially working but am getting the error below...

org.apache.commons.httpclient.MultiThreadedHttpConnectionManager - Unable to get a connection, waiting..., hostConfig=HostConfiguration[host=https://na1-api.salesforce.com]

...when it tries to do a decribe call on an entity after it's already done a couple of successful describe calls before hand. From there it seems to hang indefinitely.

Anyone else experience this?

Thanks,
Jon
  • December 06, 2005
  • Like
  • 0
Within the last week or two I've been noticing a lot connection resets.
This is happening it some integration applications that have been running for a while now without any previous issues.

I was just wondering if any one else is noticing an unusual increases in these errors also?

Thanks in advance,
Jon.

AxisFault
faultCode: {http://schemas.xmlsoap.org/soap/envelope/}Server.userException
faultSubcode:
faultString: java.net.SocketException: Connection reset
faultActor:
faultNode:
faultDetail:
{http://xml.apache.org/axis/}stackTrace:java.net.SocketException: Connection reset
at java.net.SocketInputStream.read(Unknown Source)
at com.sun.net.ssl.internal.ssl.InputRecord.readFully(Unknown Source)
  • November 18, 2005
  • Like
  • 0
Has anyone seen this error before?
I saw some older postings eluding to an old JRE version but I am runnning 1.5.0_02.
This only seems to occur after an extended period of connection.

Thanks,
Jon

AxisFault
faultCode: {http://schemas.xmlsoap.org/soap/envelope/}Server.userException
faultSubcode:
faultString: javax.net.ssl.SSLHandshakeException: sun.security.validator.ValidatorException: PKIX path building failed: sun.security.provider.certpath.SunCertPathBuilderException: unable to find valid certification path to requested target
faultActor:
faultNode:
faultDetail:
{http://xml.apache.org/axis/}stackTrace:javax.net.ssl.SSLHandshakeException: sun.security.validator.ValidatorException: PKIX path building failed: sun.security.provider.certpath.SunCertPathBuilderException: unable to find valid certification path to requested target
at com.sun.net.ssl.internal.ssl.Alerts.getSSLException(Unknown Source)
at com.sun.net.ssl.internal.ssl.SSLSocketImpl.fatal(Unknown Source)
at com.sun.net.ssl.internal.ssl.Handshaker.fatalSE(Unknown Source)
at com.sun.net.ssl.internal.ssl.Handshaker.fatalSE(Unknown Source)
at com.sun.net.ssl.internal.ssl.ClientHandshaker.serverCertificate(Unknown Source)
at com.sun.net.ssl.internal.ssl.ClientHandshaker.processMessage(Unknown Source)
...
...

Message Edited by jontk on 09-28-2005 01:04 PM

  • September 28, 2005
  • Like
  • 0
Page 32 of the 6.0 API doc says that 2005-05-05T12:00:00 should be a valid date and time format but I get a malformed query error when I try this. Am I missing something obvious?

Thanks in advance.
Jon

select id,date__c from Contact where date__c = 2005-05-05T12:00:00ng>





ns1:MALFORMED_QUERY
MALFORMED_QUERY:
where date__c = 2005-05-05T12:00:00
^
ERROR at Row:1:Column:67
unexpected char: 0x?F


MALFORMED_QUERY

where date__c = 2005-05-05T12:00:00
^
ERROR at Row:1:Column:67
unexpected char: 0x?F
1
67



  • July 21, 2005
  • Like
  • 0
Has anyone experienced this INVALID_QUERY_LOCATOR error before?

I am running a simple select statement using the API query call and queryMore to retrieve records in batches and I am getting an INVALID_QUERY_LOCATOR error sporatically. The retrieval for the next set is well under 10 minutes and there are about 67,000 records that should be returned. I am using a batch size of 1000.

Thanks.
Jon
  • June 29, 2005
  • Like
  • 0
Hi,

I'm noticing a behavior where I'm calling the getUpdated() API call on the User entity table and I see that the user I am logging in with get's it's LastLoginDate updated but I don't see this user record being brought back as an upated record.

These are the start and end date and times I'm passing in:
2005-06-27T15:08:20.000+00:00
2005-06-27T15:29:33.000+00:00

The user record has the values below:
LastLoginDate 2005-06-27T15:28:45.000Z
SystemModstamp 2005-06-27T15:28:45.000Z

Thanks,
Jon
  • June 27, 2005
  • Like
  • 0
I'm trying to set an empty string value into a text field and the soap message returns a success but I don't see the field getting updated.

Has anyone else experienced this?

Thanks,
Jon
  • June 20, 2005
  • Like
  • 0
Hi,

I am attempting to fetch a campaign record from salesforce and noticied that the value for the Total Value Opportunities (Name:AmountAllOpportunities) field is returning a value that is not consistent with the data type.

I believe this is a standard field that is of a currency type and the offending value that I seem to be getting is 5398230.02928630437660959613006935366265 .

If I do a describe on the object, it tells me that the precision is 18 and scale is 0.

Can anyone help?

Thanks,
Jon
  • May 18, 2005
  • Like
  • 0
I'm trying to do a simple select statement, "Select Id from Note" and I get the error "local part cannot be "null" when creating a QName".

I'm not sure why this is happening when I can run the same select statement in any other saleforce org and works fine. The only difference i can see is that one is on a different server, https://eu0-api.salesforce.com/services/Soap/u/5.0 where the error occurs and the others are on https://na1-api.salesforce.com/services/Soap/u/5.0 which works fine.

I can't see why that could be the cause of anything but other than the instances being with different clients, the code is the same.

Has anyone seen this behavior before?

Thanks!
Jon

Message Edited by jontk on 05-16-2005 01:11 PM

Message Edited by jontk on 05-16-2005 01:11 PM

  • May 16, 2005
  • Like
  • 0
In the 2.0 API doc, there use to be a table listing the entity type that a salesforce id was in reference to by some characters in the alpha numeric value. In the 4.0 doc, this seems to have been removed.

Is there a way I can still get this?

Thanks.
Jon
  • October 27, 2004
  • Like
  • 0
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

  • March 14, 2008
  • Like
  • 0
Can someone confirm that modifying any fields on an OpportunityLineItem or OpportunityLineItemSchedule will automatically update the related Opportunity's LastModifiedDate or SystemModstamp?

Thanks in advance.
Jon
  • March 07, 2007
  • Like
  • 0
I am getting a connection reset error consistently when attempting to pass in 200 records for a create with 37 text fields and 2  text area long fields.

Could this be due to passing too much data?
If so, is there a recommended limit on how many fields I should send with each batch?

Thanks,
Jon
  • August 23, 2006
  • Like
  • 0
Hi,

I can't seem to change the batch size on my select calls.  Could someone make a sanity check here to make sure I haven't made a silly mistake.

I'm trying to set the batch to 25 and I keep getting back 113 records.

I'm also using compression which I doubt is the cause of anything,

Thanks!
Jon

Java code:

        QueryOptions qo = new QueryOptions();
        qo.setBatchSize(new Integer(25));
        binding.setHeader(new SforceServiceLocator().getServiceName().getNamespaceURI(), "QueryOptions", qo);
        QueryResult selectResult = null;
        try {
            selectResult = binding.query(sql);


SOAP message:

<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">left out of posting</ns2:sessionId>
        </ns1:SessionHeader>
        <ns3:QueryOptions soapenv:actor="http://schemas.xmlsoap.org/soap/actor/next" soapenv:mustUnderstand="0" xmlns:ns3="urn:partner.soap.sforce.com">
            <ns3:batchSize>25</ns3:batchSize>
        </ns3:QueryOptions>
    </soapenv:Header>
    <soapenv:Body><query xmlns="urn:partner.soap.sforce.com">
        <queryString>Select Id, Name, ParentId from Account </queryString></query>
    </soapenv:Body>
</soapenv:Envelope>


  • March 30, 2006
  • Like
  • 0
Has anyone seen this error before?
I saw some older postings eluding to an old JRE version but I am runnning 1.5.0_02.
This only seems to occur after an extended period of connection.

Thanks,
Jon

AxisFault
faultCode: {http://schemas.xmlsoap.org/soap/envelope/}Server.userException
faultSubcode:
faultString: javax.net.ssl.SSLHandshakeException: sun.security.validator.ValidatorException: PKIX path building failed: sun.security.provider.certpath.SunCertPathBuilderException: unable to find valid certification path to requested target
faultActor:
faultNode:
faultDetail:
{http://xml.apache.org/axis/}stackTrace:javax.net.ssl.SSLHandshakeException: sun.security.validator.ValidatorException: PKIX path building failed: sun.security.provider.certpath.SunCertPathBuilderException: unable to find valid certification path to requested target
at com.sun.net.ssl.internal.ssl.Alerts.getSSLException(Unknown Source)
at com.sun.net.ssl.internal.ssl.SSLSocketImpl.fatal(Unknown Source)
at com.sun.net.ssl.internal.ssl.Handshaker.fatalSE(Unknown Source)
at com.sun.net.ssl.internal.ssl.Handshaker.fatalSE(Unknown Source)
at com.sun.net.ssl.internal.ssl.ClientHandshaker.serverCertificate(Unknown Source)
at com.sun.net.ssl.internal.ssl.ClientHandshaker.processMessage(Unknown Source)
...
...

Message Edited by jontk on 09-28-2005 01:04 PM

  • September 28, 2005
  • Like
  • 0
Has anyone experienced this INVALID_QUERY_LOCATOR error before?

I am running a simple select statement using the API query call and queryMore to retrieve records in batches and I am getting an INVALID_QUERY_LOCATOR error sporatically. The retrieval for the next set is well under 10 minutes and there are about 67,000 records that should be returned. I am using a batch size of 1000.

Thanks.
Jon
  • June 29, 2005
  • Like
  • 0
I'm trying to set an empty string value into a text field and the soap message returns a success but I don't see the field getting updated.

Has anyone else experienced this?

Thanks,
Jon
  • June 20, 2005
  • Like
  • 0
I'm trying to do a simple select statement, "Select Id from Note" and I get the error "local part cannot be "null" when creating a QName".

I'm not sure why this is happening when I can run the same select statement in any other saleforce org and works fine. The only difference i can see is that one is on a different server, https://eu0-api.salesforce.com/services/Soap/u/5.0 where the error occurs and the others are on https://na1-api.salesforce.com/services/Soap/u/5.0 which works fine.

I can't see why that could be the cause of anything but other than the instances being with different clients, the code is the same.

Has anyone seen this behavior before?

Thanks!
Jon

Message Edited by jontk on 05-16-2005 01:11 PM

Message Edited by jontk on 05-16-2005 01:11 PM

  • May 16, 2005
  • Like
  • 0
We'll be using this thread to discuss any possible regressions/issues with the 5.0 release.

    • One thing not mentioned in the release notes, but a change that was made: All IDs should now be returned as 18-character IDs. This was previously not the case, which was a bug as the WSDL defined ID to be 18 characters. If this has affected your integration, please post. Also, if you are doing any special handling for ID fields because their not 18-character you should post this info as well.


      Note that we will be rolling back this behavior for 4.0 and below, and 5.0 will always return 18 character ids. This is only the case for organization_id on the getUserInfo call. Rolled back on 11/15 for 4.0 and below apis


    • Running a query that returns more than batchSize records on OpportunityLineItem is failing. Fixed on 11/15

    • Address Label changes are causing problems for customers using Data Junction and XML/RPC. Please log a case if this issue is affecting you. These labels will be left with their new values.

    • The Web Integration Link URL for the API servers now returns the API pool. For example, this merge field: {!API_Enterprise_Server_URL_25} now returns na1-api.salesforce.com and not na1.salesforce.com. If you have a WIL that needs to return back to the detail page when it's done, you should use the detail page merge field. For example, on Opportunity this would be: {!Opportunity_Link}.


      There are also some scontrols that have stopped working because security settings only allows code to talk with the originating server. We are reverting this change, and a short-term fix is to hardcode the originating server url, such as na1.salesforce.com
      Patched 11/18


    • Calling retrieve when setting the batchSize header and the number of elements retrieved is larger than batchSize is causing unexpected_error faults for some entities. Patched on 11/18. However, there is still an issue if you are selecting a long binary column on an entity such as Attachment or Document. Patch pending

    • Retrieve used to always return id. Now it is only returning id if you request it. Short term workaround: adding id to your select list. Patched 11/18

    • Querying user on firstName or lastName will not return any rows. Patch release on 11/16 to api servers, on 11/18 to all servers.

    • A SOSL call on User that selects division will return an error. Example: FIND {Steve} RETURNING User(Division, Email). Workaround is to not select divison. Patched on 11/18

    • New fields: SystemModstamp was added to AssignmentRule, and SortOrder was added to OpportunityLineItem. New fields can appear in older versions of the API.

    • The WSDL generation page now respects field level security. Note that you must be an admin to even view this page, so you can always make fields hidden via FLS visibile. No change will be made here

    • Dates are now validated such that the year is between 1700 and 4000. This will be rolled back for 4.0 and below, and kept for 5.0. If you are requesting a date field using .NET, and the field is null, .NET turns that into 1/1/1. When sent back up, this is causing problems. This does not seem to be a problem for any other client. Patched on 11/18

    Message Edited by benjasik on 11-18-2004 07:45 PM