Call WebService GetListItems - 500 Internal Error

Nov 29, 2010 at 12:20 AM

Hi,

I'm trying to get the Call WebService action to run, but am having trouble. I have been able to create a list like you do in the example, however i cannot use the GetListItems function.

The workflow i'm testing with is a simple one, all it does is calls the web service, saves the response to a variable, and then logs that variable to the History list.

The Soap Envelope is:

<soap12:Envelope xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:soap12="http://www.w3.org/2003/05/soap-envelope">
  <soap12:Body>
    <GetListItems xmlns="http://schemas.microsoft.com/sharepoint/soap/">
      <listName>TestLookupList</listName>
      <viewName />
      <query>
        <Where><Eq><FieldRef Name="Title" /><Value Type="Text">Yes</Value></Eq></Where>
      </query>
      <viewFields>
        <FieldRef Name="ID" />
     </viewFields>
      <rowLimit>1</rowLimit>
      <queryOptions />
      <webID />
    </GetListItems>
  </soap12:Body>
</soap12:Envelope>

 

When I run this workflow i get the following error: "Error calling Web Service. The remote server returned an error: (500) Internal Server Error."

 

The ULS Logs have the following (i've removed most of the Call Stack for these, let me know if i should include them):

11/29/2010 11:05:56.11    w3wp.exe (0x06B0)    0x0F94    Windows SharePoint Services    Workflow Infrastructure    88xr    Unexpected    WinWF Internal Error, terminating workflow Id# 0341b7b0-9c8d-4a63-91e0-01167c9a435e   


11/29/2010 11:05:56.11    w3wp.exe (0x06B0)    0x0F94    Windows SharePoint Services    Workflow Infrastructure    98d4    Unexpected    System.Net.WebException: The remote server returned an error: (500) Internal Server Error.     at System.Net.WebClient.UploadDataInternal(Uri address, String method, Byte[] data, WebRequest& request)     at System.Net.WebClient.UploadString(Uri address, String method, String data)     at iLoveSharePoint.Activities.CallWebServiceActivity.<>c__DisplayClass1.<Execute>b__0() ....


11/29/2010 11:05:56.44    w3wp.exe (0x06B0)    0x06C8    Windows SharePoint Services    General    0    Unexpected    ERROR: request not found in the TrackedRequests. We might be creating and closing webs on different threads. ThreadId = 18, Free call stack =    at Microsoft.SharePoint.SPRequestManager.Release(SPRequest request)     at Microsoft.SharePoint.SPSite.Close()     at Microsoft.SharePoint.SPSite.Dispose() ....

 

Any help you could give me would be great, i'd love to be able to use this in a project i'm currently working on.


Thanks in Advance,

Glen.

Dec 16, 2010 at 1:14 AM

Anyone? I could really use some help with this.

 

Cheers,

Glen.

Coordinator
Dec 16, 2010 at 2:34 PM

Take a look in the SharePoint trace file. Seems the SOAP message isn't okay.

Bye, Christian