Home > Sharepoint Designer > Sharepoint Designer Data Source Non-specific Error

Sharepoint Designer Data Source Non-specific Error

I checked with Logs, but i could not understand what is the main issue. I figured out it was related to a calculated colum that I was using. This can be configured immediatly during the SQL Server installation or after in the Server Authentication section in the Server properties … MS SQL Server MS SQL Server 2005 MS SQL The way to recover is to change back ListName to ListID and assign it the GUID value of the list. check over here

But it didn't and it was (after some painful/long troubleshooting) because the SSL certificate used for the site (our site is behind an HTTPS URL) was not part of the SharePoint Thanks & Regards MD Liakath Ali Edited by Liakath Thursday, June 20, 2013 11:16 AM Tuesday, June 18, 2013 11:54 AM Reply | Quote Answers 0 Sign in to vote Hi If you already are using an unattended data access account for say, PerformancePoint or Excel Services, you might consider that account here as well. Recently Security team made some changes. http://www.iotap.com/blog/entryid/69/getting-rid-of-ldquo-the-server-returned-a-non-specific-error-rdquo-in-sharepoint-designer

Again after 2minutes data were displaying.) i am getting the below error in site home publishing page. asked 5 years ago viewed 1074 times Related 4Why do SharePoint Designer workflows, when edited, seem not to update on the SharePoint site?0Howto I get the user domain\username and Display name If the problem persists, contact the server administrator.” There are several solutions out there in the web for this error like the ones listed below but none of them are

Share it and empower the world. Approximation of the Gamma function for small value Did I participate in the recent DDOS attacks? asked 4 years ago viewed 433 times active 3 years ago Related 1Problem with DataView web part and Server-side script datasource from RSS0How do I get sorting to work in the But this is a quick way to recover the page.

The field in question's data type was "Number". Subscribe to our monthly newsletter for tech news and trends Membership How it Works Gigs Live Careers Plans and Pricing For Business Become an Expert Resource Center About Us Who We I was receiving the same error in a DataViewWebPart, and I was able to narrow it down to a calculated field. https://social.technet.microsoft.com/Forums/en-US/a5f1d850-0b33-4028-9555-834449f381c2/error-the-server-returned-a-nonspecific-error-when-trying-to-get-data-from-the-data-source?forum=sharepointadminprevious Passing complex structured data type from Lightning to Apex Controller causes Internal Error with Gack Id 263119078 How to explain the concept of test automation to a team that only knows

I thought the error was in my WCF Web Service (its web.config or something) but it just works fine when I debug it in SOAP tests like: http://wsdlbrowser.com Then I thought Looking in the IIS logs for the offending web applications when attempting to access the data source, we get a bit of a hint to what is going on. So, the non-specific error that was causing failure for me, was that I hadn't included the schema in the sql statement. A couple final things… When I was playing around with this, I wondered how classic mode authentication behaved.

Join our community for more solutions or to ask questions. http://itgroove.net/brainlitter/2010/08/02/resolution-for-sharepoint-designer-2010-data-source-non-specific-error/ Finally, the fix… Ok, get on with it, everyone is likely saying at this point… First, you need to acquire the root cert (DER encoded library) so that you can plug The answer is twofold. From your description, it is maybe your data connection not working.

What is a EH-Number™ What is way to eat rice with hands in front of westerners such that it doesn't appear to be yucky? check my blog Of course, if you've created special filtering, this would have to be redone. So instead of deploying it to the GAC, you opt to deploy it to bin folder of the web application and give it a partial trust level instead. Hope it helps someone else out there.

Thanks & Regards MD Liakath AliMD.Liakath ali Marked as answer by Liakath Monday, July 22, 2013 3:20 PM Monday, July 22, 2013 3:20 PM Reply | Quote Microsoft is conducting an Your Answer draft saved draft discarded Sign up or log in Sign up using Google Sign up using Facebook Sign up using Email and Password Post as a guest Name From your description, it is maybe your data connection not working. this content I wanted to display the latest blog posts that existed in a blog site, in the root site.

Alphabet Diamond How to explain the use of high-tech bows instead of guns How to find the distance between 2 regions? I had a test SharePoint 2010 farm with SP2 and I was working with SharePoint Designer on the server itself. Join the community of 500,000 technology professionals and ask your questions.

Both are the same version/same patch level.The next thing I looked at was the login roles that the logins were using.

  1. I ended up moving the database to our other SQL server and I was then able to pull data using SharePoint designer. 0 Message Author Closing Comment by:DxtrLws2011-08-22 The solution
  2. Fairly quickly I found that the culprit was the SPRequestModule which “provides most of the additional configuration and processing needed for SharePoint pages” (thanks Josh).
  3. 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

Execution Time=20.5576407057322 Error while executing web part: System.Net.WebException: The underlying connection was closed: An unexpected error occurred on a send. ---> InnerException 1: System.IO.IOException: The handshake failed due to an unexpected more hot questions question feed default about us tour help blog chat data legal privacy policy work here advertising info mobile contact us feedback Technology Life / Arts Culture / Recreation This in turn has caused SharePoint Designer’s attempt to add the web part to fail also (note line 4 with an internal server error code of 500). So it looked something like this: =IF(condition, value if true, "") I figured out that the only time I got the "The server returned a non-specific error..." message was when the

Copy the datasource element from the dataview in new page 5. Is the ritual of killing an animal as offering to Maa Kali correct? Microsoft Customer Support Microsoft Community Forums Dev Center Explore Why Office? have a peek at these guys Replace the datasource element of the erroneous dataview with the copied datasource element TAGS: Sharepoint Designer Share this post « Productizing Add-ons and Solutions for Dynamics CRM.

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 When I try to connect it via SPD, it shows connection successful. Please enter a comment.Allowed tags: blockquote, a, strong, em, p, u, strike, super, sub, code Verification: Copyright © shehan | Powered by: GeeksWithBlogs.net | Join free Popular Posts on Geeks with Tuesday, October 13, 2009 4:58 PM 0 Sign in to vote Tim,Were you ever able to locate a solution to this issue you have regarding SPD and showing data from a

I did an IISRESET but only out of habit and I'm too lazy to pull everything out to see if it was actually necessary. 😉 But now my dataviews display properly… It's not an ideal solution, as hardcoding usernames and passwords is never best practice, but it is a solution.Regards,Tomas Tuesday, November 29, 2011 10:18 AM 0 Sign in to vote You are my hero! As stated in the above article “This issue occurs because of an error in the ASP.NET 2.0 authentication component.

It is critical that you understand why that entry was added to IIS and don’t just go and change it because it gets you out of a pickle. Thanks & Regards MD Liakath AliMD.Liakath ali Friday, July 12, 2013 4:32 PM Reply | Quote 0 Sign in to vote My issue got resolved. Create a new page in SharePoint designer. 2. Here is a similar case.

In this case, creating a DVWP based on a SOAP datasource will work fine. What does "Game of the Year" actually mean? Once I removed that portion of the statement as you mentioned in your post, IT WORKED!! First Name Please enter a first name Last Name Please enter a last name Email We will never share this with anyone.

The field in question's data type was "Number".