DVWP, The server returned a non-specific error when trying to get data from the data source.

Question

Dear guys,

This morning, my DVWP of a Document library throw an error "The server returned a non-specific error when trying to get data from the data source...."
In the SPD, I clicked the Show Data of that Data Source and I got the error.

I tried duplicated that Document Library to an empty one, then I can import the empty one. So any thoughts? Maybe the current Document library got a lot of data (32000 records, about 250MB)?

Thanks for any inputs!!!

---

Chong

Answer 1

Finally I used ListView instead of the DVWP, and made some index on the fields. Lot of faster now.

For the error, i believe the DVWP has low performance on loading a huge Document Library.

So, when you do sth, make sure you have a perfect solution.

---

Chong