Home > Sharepoint 2010 > Sharepoint 2010 Soap Data Source Non Specific Error

Sharepoint 2010 Soap Data Source Non Specific Error

I came from a distant land Where did I find these numbers? Below are 4 entries in the IIS logs. 1: POST /_vti_bin/lists.asmx - 82 - fe80::416a:c7c4:4b41:d558%10 - 401 0 0 0 2: POST /_vti_bin/lists.asmx - 82 - fe80::416a:c7c4:4b41:d558%10 - 401 1 2148074254 This blog is protected by Dave's Spam Karma 2: 107735 Spams eaten and counting... Among other things, being able to specify a particular view on a list when calling the GetListItems method is really handy. http://internetmairie.com/sharepoint-2010/sharepoint-2010-soap-the-server-returned-a-non-specific-error.html

One of the operations it supports is called “GetListItems,” which returns information about items in the list based on the specified query. Can be usefull to specify the IncludeAttachmentURL options on List Items. It says "The Root Certificate that was just selected is invalid. Impersonation enables this request to be serviced by a different account – in this case being the NT AUTHORITY\IUSR account. http://www.iotap.com/blog/entryid/69/getting-rid-of-ldquo-the-server-returned-a-non-specific-error-rdquo-in-sharepoint-designer

Well, almost anyway. As a sample, I was trying to add a data source from an AdventureWorks sample database Employee table onto a web part page. Cheers Tim Sunday, November 15, 2009 11:30 PM 0 Sign in to vote Hi Tim I feel your pain brother !!I too have been wrestling with exactly the same issue for I am successfully able to configure the soap service but cant showing the data.

I have a question. The second part to the answer is an ASP.NET configuration setting in IIS… The fixes… So what can we do about it? After all, SharePoint by default does not have anonymous access enabled, and I am performing the above steps logged in as an administrative account. Check the format and content of your query and try again.

Did I participate in the recent DDOS attacks? Another thing that  bugged me was the error code of 401.0.0 from the IIS logs. This sort of entry is actually very common in IIS logs because of the way windows authentication works in IIS. https://social.msdn.microsoft.com/Forums/sharepoint/en-US/48e9e1e0-433f-42e0-a072-1c6eeedbb7c6/the-server-returned-a-nonspecific-error-when-trying-to-get-data-from-the-data-source?forum=sharepointcustomizationlegacy Is the ritual of killing an animal as offering to Maa Kali correct?

A browser will first attempt an anonymous request before reattempting the request using other authentication methods. please respond MVP's and geeks. So what gives with these two claims authentication web applications? based on that i will try to clarify you Monday, March 29, 2010 2:43 PM 1 Sign in to vote Hi folks, I know this is an old thread but I

This may be because the selected certificate requires a password and we do not support certificates that require a password. Read More Here Thanks in advance Tim Edited by Timbo879 Tuesday, August 26, 2008 2:30 AM Refine the question removing ambiguity Friday, August 22, 2008 4:36 AM Answers 1 Sign in to vote Hi I may re-blog this, but I will definitely link back to this post. Is it unethical of me and can I get in trouble if a professor passes me based on an oral exam without attending class?

Also, if I go to the Data Source properties for this list there is no Login tab for me to work with, just the General tab. check my blog There’s more information on SQL SOAP services at http://msdn.microsoft.com/en-us/library/ms191310.aspx. Therefore, the Web parts have full permission to access the SharePoint site”. Thanks, Tim Thursday, November 10, 2011 2:50 PM 0 Sign in to vote I've solved the error by adding a SharePoint Service Account credentials to Data Source.

In this situation, SharePoint has to make use of impersonation to service the request since it has no credentials to access this data source. Notify me of new posts by email. So I changed the formula to this: =IF(condition, value if true,) And suddenly the error disappeared. http://internetmairie.com/sharepoint-2010/sharepoint-2010-external-list-soap-error.html Start real time logging with the ULS Viewer on the server (archive.msdn.microsoft.com/ULSViewer).

If you already are using an unattended data access account for say, PerformancePoint or Excel Services, you might consider that account here as well. I was not using a Proxy nor was I behind a firewall. I was able to add a Data View in SPD after that.

Resolution: 1.

Anytime impersonation is required, the app pool account will be used which has the potential to make requests and execute code with greater privilege than the currently logged in user. I have even tried with the sharepoint support link: http://support.microsoft.com/kb/923173 but has no luck any suggestions or help is much much appreciated…. Glyma is now open source! Click on the On Object UI box to bring up the Common Data View Tasks, then select Filter, Sort or Paging.

Please select another certificate." I didn't create a password when I exported it, I just exported it and named it just like you did. In claims mode they are not – and in fact in claims mode you might have users who do not use Windows authentication at all (such a forms auth user who Join me on Google+ Join me on FaceBook! have a peek at these guys I changed the Select SQL Statement from: Select * from Employee to Select * from HumanResources.Employee and it worked.

In SharePoint 2010 this is easy, but in MOSS it is undocumented! So is that the answer then? I ran into the exact same problem and the instructions above solved it. I used to do this all the time, with a couple of clicks.

Now, add single quotes before and after the double quotes, so the SelectAction attribute looks like this: SelectAction='"http://…"‘. can somebody please help me. GO Home+About UsOur Partners+Solutions+Customer Relationship ManagementSalesServiceMarketingSocialMicrosoft SharePointWork 365Microsoft Office 365Microsoft Azure+ServicesSharepoint ServicesConsulting ServicesCloud ServicesApplication DevelopmentCRM-ServicesMicrosoft Dynamics CRM+Add-ons+Microsoft Dynamics CRMAll Dynamics CRM Add OnsReport SchedulerDynamics CRM Record CloneEmail to CaseAdvanced Auto NumberBirthday That way when requests are made to access the webservice, these credentials will be used.

SQL Server takes care of all of the SOAP implementation details, so all you have to worry about is getting the queries correct! I had a test SharePoint 2010 farm with SP2 and I was working with SharePoint Designer on the server itself. Leave a Reply Cancel reply Your email address will not be published. Thanks for posting!

Add, Remove, System created List Columns in ShareP... template.