“The server returned a non-specific error” when Grouping in a DataView

Question

I am getting a "The server returned a non-specific error" with a DataView in SPD with SP2010.
The DataView is working fine up to that, i.e. I have added and removed cols, Filtered and Sorted and added Inline editing and all this works corectly in the browser after I save changes. When I then go back into "Sort & Group" and select the Show Group Header option and select OK, The data table collapses down and gives that error ?? The Data Source is a View in SQL server. Any suggestions gratefully received. JK

Answer 1

I've found it easy to recover the page by creating a new form in SPD, then taking the <DataSources> section from the new page and replacing the <DataSources> in the corrupted page. Of course, if you've created special filtering, this would have to be redone. But this is a quick way to recover the page.