System.Data.EvaluateException: Unbound reference in the aggregate expression 'System.Data.AggregateNode'

Unbound reference in the aggregate expression 'System.Data.AggregateNode'

(2010.12.15) -Sai Gon- Today I am happy to share with you serious way to solve exception "System.Data.EvaluateException" when running SitePage, Application Page or Webpart with WSS3.0, MOSS2007, SharePoint Foundation 2010 or SharePoint Server 2010.

First at all we see what is the System.Data.EvaluateException look like

Then we go to code and see what is wrong at line 422 at ProcessTask.cs on Turkish SharePoint site but  run well with SharePoint English site

What is wrong when add column ddc1 to a datatable? We look at line 403, ddc1 column have an "Expression" with "workitems" is an DataRelation. We see what is "workitems" data relation declare look like

So the problem is the name of data relation must use exactly for each character so we must replace "workitems" by "WorkItems" at line 403 of code before.
The new code of line 403 like

Not only with data relation name, we must use exactly to each character of  Column Name, TableName and so on if we want our product run well on any SharePoint language pack sites

God bless us!

Thanks God and Thanks all!

Only 10$/h or 10% market price I provide full Business Software Solution: mobile app (iOS and Android), Intranet Portal by SharePoint Online or On-Premise, Business Web App, Business Workflow, Power Bi, E-Office, Document Management, Chat system, Customer Interaction Center, Dynamics AX, Dynamics 365.

Or very happy to join your team to develop Mobile App or Business Web App.

Thank you!


Phone: +60 115 199 2689
Email or Skype: ThomasTrungVo@Hotmail.com
Gmail: SharePointTaskMaster@Gmail.com
LinkedIn: https://www.linkedin.com/in/abc365/

Thomas Trung Vo