Geeks With Blogs

News These postings are provided "AS IS" with no warranties, and confers no rights.
Locations of visitors to this page virtusa corp sharepoint virtusa.com shehan peruma
Shehan Peruma

When I updated the ‘Filter Criteria’ of a fully functioning DVWP through SharePoint designer I was presented with the following error:

The server returned a non-specific error when trying to get data from the data source. Check the format and content of your query and try again. If the problem persists, contact the server administrator.

Took me a while to figure it out. This is what caused it and how to fix it:

When you create a DWVP, SPDesigner adds a parameter called ListID and assigns it the GUID value of the list. I’m sure that you know that in order to make a DVWP ‘portable’ you need to replace ‘ListID’ with ‘ListName’ and the GUID value with the name of the list. This doesn’t break the DVWP’s functionality and lets you use in on any site that has a list with the same name and columns.

However, if you try to edit the filter condition of this ‘portable’ DVWP from the DVWP’s common task pane you’re bound to encounter the above error. The way to recover is to change back ListName to ListID and assign it the GUID value of the list. Once this is done you can make the filter changes and SPDesigner will automatically refresh the DVWP with the correct items. Once you’re satisfied  with the query make the DVWP ‘portable’ like you initially did and add it to your site.

 

Posted on Tuesday, October 13, 2009 9:08 PM SharePoint Designer , Troubleshooting | Back to top


Comments on this post: Data View Web Part error in SharePoint Designer

# re: Data View Web Part error in SharePoint Designer
Requesting Gravatar...
I didnt know that - thanks for clarifying
Left by Cotswolds B&B on Nov 29, 2009 10:13 PM

# re: Data View Web Part error in SharePoint Designer
Requesting Gravatar...
I have read in different articles to change ListId to ListName to avoid any problem in deployng DVWP to any other system. My problem is that i am using a list of another site in my DVWP. Basically the list in on root site while the page on which it is using via DVWP is on a subsite 2 levels below from root site. So i think only changing ListID to ListName will not be enough.

Can you tell me how to configure my new DVWP so that it can be deployed on other system where there will be list of same name on root site?

Left by mohsin on Dec 25, 2009 7:25 PM

Your comment:
 (will show your gravatar)


Copyright © shehan | Powered by: GeeksWithBlogs.net