function readOnly(count){ }
Starting November 20, the site will be set to read-only. On December 4, 2023,
forum discussions will move to the Trailblazer Community.
+ Start a Discussion
JuiceJuice 

Did sforce.com go down today between 5-7pm today?

I can login and get a valid session id but my other requests stopped working today after 5pm.  I get a SOAP error saying that an invalid XML character (UnicodeL 0x0) was found in the document.

Was there a change to the web services APIs or was the system down?

Message Edited by Juice on 07-31-2003 07:25 PM

DevAngelDevAngel

Hi Juice,

Nope, no outage, no change in the API.  Do you still have the problem, or did it go away around 7:00?

JuiceJuice

I still have the problem.  Here's the error message from our toolset:

8/1/2003 1:13:06 AM: [Contact Retrieval.xls]: {EC023968-C0A5-4E9B-9674-D2B65374ADE4}[Query]: Reply Error[20041]: Soap faultcode: "-"  ["-"  [SOAP Fault: ÑR; select list not specified in query; ]] '/servlet/servlet.SoapApi<soap:Envelope xmlns:soap="http://schemas.xmlsoap.org/soap/envelope/"    xmlns:soapenc="http://schemas.xmlsoap.org/soap/encoding/"    xmlns:tns="salesforce" xmlns:types="salesforce/encodedTypes"    xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"    xmlns:xsd="http://www.w3.org/2001/XMLSchema"><soap:Header>  <tns:headerStruct id="id1">    <session_id xsi:type="xsd:string">JVtP__WRA2DdXJwehrL8sHzXMfLk9N5X04UvUxor4OM3aRueh.LcTz3CK7jNV0UQA9eMaBSefAUrqw3nyGp71fbtzKggVlhL</session_id>    <version xsi:type="xsd:string">2.0</version>  </tns:headerStruct></soap:Header><soap:Body soap:encodingStyle="http://schemas.xmlsoap.org/soap/encoding/">  <q1:query xmlns:q1="sfconnector:SalesforceConnector">    <type xsi:type="xsd:string">contact</type>    <maxRows xsi:type="xsd:int">20</maxRows> <scope xsi:type="xsd:string">filter</scope>    <select href="#id1" />    <filter href="#id2" />  </q1:query>  <soapenc:Array id="id1" soapenc:arrayType="xsd:string[4]">    <Item>lastName</Item>    <Item>firstName</Item>    <Item>id</Item>    <Item>email</Item>  </soapenc:Array>  <soapenc:Array id="id2" soapenc:arrayType="xsd:anyType[1]">    <Item href="#id3" />  </soapenc:Array>  <soapenc:Array id="id3" soapenc:arrayType="tns:mapEntry[3]">    <Item href="#id4" />    <Item href="#id5" />    <Item href="#id6" />  </soapenc:Array>  <tns:mapEntry id="id4" xsi:type="tns:mapEntry">    <key xsi:type="xsd:string">field</key>    <value xsi:type="xsd:string">createdDate</value>  </tns:mapEntry>  <tns:mapEntry id="id5" xsi:type="tns:mapEntry">    <key xsi:type="xsd:string">value</key>    <value xsi:type="xsd:dateTime">2003-04-01T00:00:00.0000000-08:00</value>  </tns:mapEntry>  <tns:mapEntry id="id6" xsi:type="tns:mapEntry">    <key xsi:type="xsd:string">operator</key>    <value xsi:type="xsd:string">greater than</value>  </tns:mapEntry></soap:Body></soap:Envelope>' []
8/1/2003 1:13:06 AM: [Contact Retrieval.xls]: \Query\QueryComponent[22]: Reply Error[1]: Soap faultcode: "-"  ["-"  [SOAP Fault: ÑR; select list not specified in query; ]] '/servlet/servlet.SoapApi<soap:Envelope xmlns:soap="http://schemas.xmlsoap.org/soap/envelope/"    xmlns:soapenc="http://schemas.xmlsoap.org/soap/encoding/"    xmlns:tns="salesforce" xmlns:types="salesforce/encodedTypes"    xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"    xmlns:xsd="http://www.w3.org/2001/XMLSchema"><soap:Header>  <tns:headerStruct id="id1">    <session_id xsi:type="xsd:string">JVtP__WRA2DdXJwehrL8sHzXMfLk9N5X04UvUxor4OM3aRueh.LcTz3CK7jNV0UQA9eMaBSefAUrqw3nyGp71fbtzKggVlhL</session_id>    <version xsi:type="xsd:string">2.0</version>  </tns:headerStruct></soap:Header><soap:Body soap:encodingStyle="http://schemas.xmlsoap.org/soap/encoding/">  <q1:query xmlns:q1="sfconnector:SalesforceConnector">    <type xsi:type="xsd:string">contact</type>    <maxRows xsi:type="xsd:int">20</maxRows> <scope xsi:type="xsd:string">filter</scope>    <select href="#id1" />    <filter href="#id2" />  </q1:query>  <soapenc:Array id="id1" soapenc:arrayType="xsd:string[4]">    <Item>lastName</Item>    <Item>firstName</Item>    <Item>id</Item>    <Item>email</Item>  </soapenc:Array>  <soapenc:Array id="id2" soapenc:arrayType="xsd:anyType[1]">    <Item href="#id3" />  </soapenc:Array>  <soapenc:Array id="id3" soapenc:arrayType="tns:mapEntry[3]">    <Item href="#id4" />    <Item href="#id5" />    <Item href="#id6" />  </soapenc:Array>  <tns:mapEntry id="id4" xsi:type="tns:mapEntry">    <key xsi:type="xsd:string">field</key>    <value xsi:type="xsd:string">createdDate</value>  </tns:mapEntry>  <tns:mapEntry id="id5" xsi:type="tns:mapEntry">    <key xsi:type="xsd:string">value</key>    <value xsi:type="xsd:dateTime">2003-04-01T00:00:00.0000000-08:00</value>  </tns:mapEntry>  <tns:mapEntry id="id6" xsi:type="tns:mapEntry">    <key xsi:type="xsd:string">operator</key>    <value xsi:type="xsd:string">greater than</value>  </tns:mapEntry></soap:Body></soap:Envelope>' [20041]

The strange thing is that this was working flawlessly around 5pm today.  Is there a limit on how many connections you can have open or some other resource constraints that I'm running into?

JuiceJuice

I get the error for even a simple request like the server timestamp.  The error message is:

8/1/2003 1:24:26 AM: [Book1]: \Server Timestamp\QueryComponent[13]: Reply Error[1]: Soap faultcode: "Error parsing xml [An invalid XML character (Unicode: 0x0) was found in the element content of the document.]" '/servlet/servlet.SoapApi<soapenv:Envelope soapenv:encodingStyle="http://schemas.xmlsoap.org/soap/encoding/" xmlns:soapenv="http://schemas.xmlsoap.org/soap/envelope/" xmlns:soapenc="http://schemas.xmlsoap.org/soap/encoding/" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:tns="sfconnector:SalesforceConnector"><soapenv:Header><tns:get_server_timestamp><commonRequest><session_id>oC48MU8aIC_95OltACCbcryCHHECqr012rghdiGxAnSjil6g3tXk.gWPBZAfq4qn7z9j8DuEHkWvL9fUAsd8NfbtzKggVlhL</session_id><version>2.0</version></commonRequest></tns:get_server_timestamp></soapenv:Header><soapenv:Body><tns:get_server_timestamp/></soapenv:Body></soapenv:Envelope>' [20041]

The SOAP request is as follows:

<soapenv:Envelope soapenv:encodingStyle="http://schemas.xmlsoap.org/soap/encoding/" xmlns:soapenv="http://schemas.xmlsoap.org/soap/envelope/" xmlns:soapenc="http://schemas.xmlsoap.org/soap/encoding/" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:tns="sfconnector:SalesforceConnector"><soapenv:Header><tns:get_server_timestamp><commonRequest><session_id>{session_id}</session_id><version>2.0</version></commonRequest></tns:get_server_timestamp></soapenv:Header><soapenv:Body><tns:get_server_timestamp/></soapenv:Body></soapenv:Envelope>

DevAngelDevAngel

Hi Juice,

sforce did not go down.  However, during a weekly patch a bug was introduced causing query by idList to always fail.  We are working on the fix right now and will post a notice on http://forums.sforce.com/sforce/board/message?board.id=JAVA_development&message.id=174 when the fix has been put in place.

JuiceJuice

In my case, the get_server_timestamp, describe, and query all stopped working after last night.  These were all working before last night.  The only thing working for me is login.

For some reason, I keep getting an invalid XML document back from the sforce.com.  The error I get indicates that there is a Unicode 0x0 value in the returned document.