Blue Ink
Blue InkHomeBlue Ink SolutionsArticlesBlue Ink Net CommunityBlue Ink Demo ApplicationAbout Automated Architecture
My Profile

Column X does not belong to table Y

View Blue Ink Issues Forum | Post Response | New Topic

Author Message
Dec 15 2005
3:53 PM
Thanks for your response. I have set the recursive relationship up and I am receiving an error. Have any ideas what could cause this error?

Server Error in '/RTM_BEA' Application.

Column 'RequirementSourceType_Requirement_FK1_RequirementSourceType' does not belong to table Requirement.
Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.

Exception Details: System.ArgumentException: Column 'RequirementSourceType_Requirement_FK1_RequirementSourceType' does not belong to table Requirement.

Source Error:

Line 47: // or strFormat can be a .net format specifier such as "c" for currency
Line 48: public static void PopulateLabel(Label lbl, DataRow row, string strLogicalColumnName, string strFormat) {
Line 49: if (row.IsNull(strLogicalColumnName)) {
Line 50: lbl.Text = "";
Line 51: } else {

Source File: c:\inetpub\wwwroot\RTM_BEA\UiCommon\UiHelper.cs Line: 49

Stack Trace:

[ArgumentException: Column 'RequirementSourceType_Requirement_FK1_RequirementSourceType' does not belong to table Requirement.]
System.Data.DataRow.IsNull(String columnName) +125
TH.rtm_bea.UiCommon.UiHelper.PopulateLabel(Label lbl, DataRow row, String strLogicalColumnName, String strFormat) in c:\inetpub\wwwroot\RTM_BEA\UiCommon\UiHelper.cs:49
TH.rtm_bea.UiCommon.UiHelper.PopulateLabel(Label lbl, DataRow row, String strLogicalColumnName) in c:\inetpub\wwwroot\RTM_BEA\UiCommon\UiHelper.cs:42
TH.rtm_bea.WebUserControls.Base.Requirement_Identify_Base.Page_Load_Base(Object sender, EventArgs e) in c:\inetpub\wwwroot\RTM_BEA\WebUserControls\Base\Requirement_Identify_Base.cs:46
System.EventHandler.Invoke(Object sender, EventArgs e) +0
System.Web.UI.Control.OnLoad(EventArgs e) +67
System.Web.UI.Control.LoadRecursive() +35
System.Web.UI.Control.LoadRecursive() +98
System.Web.UI.Control.LoadRecursive() +98
System.Web.UI.Control.LoadRecursive() +98
System.Web.UI.Page.ProcessRequestMain() +750
Lee Richardson

Dec 15 2005
4:21 PM
Off the top of my head I suspect that you may need to recompile the strongly typed datasets using the file "CompileDataSets.bat".

The error is occuring in Requirement_Identify_Base.cs on line 46. You need to first confirm if there is a column called "RequirementSourceType_Requirement_FK1_RequirementSourceType" in the Requirement table of what I am guessing is the Common\Entities\BaseXsd\Requirement_ViewDetail_BaseXsd.xsd file. If there is then running the CompileDataSets.bat should resolve the problem.

If the strongly typed dataset is indeed out of sync with the identify web user control I will need more information about your schema to try to recreate.

View Blue Ink Issues Forum | Post Response | New Topic


What is Rapid Application Development?


Call us toll free:
(877) 756-3595

Or Visit Forums


Copyright © 2021 Automated Architecture, Inc. All rights reserved.