Well in my case it was a known issue, data throttling. Challenge was not to fix the issue but was to figure out what the issue is .
Generic error like "Webpart error" doesn't help.
1) First issue was to figure out the issue.
Solution :
Use ULS Viewer, it's very handy in such situation :
http://ulsviewer.codeplex.com/releases/view/19835
2) How to throttle the data. This one was a quick one. Pretty good article in this team blog.
http://blogs.msdn.com/b/bcs/archive/2010/02/16/bcs-powershell-introduction-and-throttle-management.aspx
-Raghu Iyer
Generic error like "Webpart error" doesn't help.
1) First issue was to figure out the issue.
Solution :
Use ULS Viewer, it's very handy in such situation :
http://ulsviewer.codeplex.com/releases/view/19835
2) How to throttle the data. This one was a quick one. Pretty good article in this team blog.
http://blogs.msdn.com/b/bcs/archive/2010/02/16/bcs-powershell-introduction-and-throttle-management.aspx
-Raghu Iyer