Discussions

Hello,

Trying to add two sources to IQA and get 500 error (see windows event viewer details below).

Add 1 source (either one of two) and OK.
When add 2nd source get the 500 error.
Other sources and IQAs are OK.

Looking for suggestions and ideas to resolve the issue.

Thanks Nick

Product iMIS EMS On-premise
Software version 20.3.192.228
Last upgraded on 2025-02-07
Database version 20.3.192.228
.NET framework version 4.0.30319.42000

Event code: 3005
Event message: An unhandled exception has occurred.
Event time: 9/4/2025 3:16:54 AM
Event time (UTC): 9/4/2025 10:16:54 AM
Event ID: 096eadeef4ab4439bffb06d2f13ba13a
Event sequence: 41486
Event occurrence: 29
Event detail code: 0

Application information:
Application domain: /LM/W3SVC/2/ROOT-1-133995968480492127
Trust level: Full
Application Virtual Path: /
Application Path: C:\Program Files (x86)\ASI\iMIS\net

Process information:
Process ID: 4164
Process name: w3wp.exe
Account name: IIS APPPOOL\iMISApp2

Exception information:
Exception type: InvalidConstraintException
Exception message: Parent Columns and Child Columns don't have type-matching columns.
at System.Data.DataRelation.CheckState()
at System.Data.DataRelation.Create(String relationName, DataColumn[] parentColumns, DataColumn[] childColumns, Boolean createConstraints)
at System.Data.DataRelationCollection.Add(String name, DataColumn[] parentColumns, DataColumn[] childColumns, Boolean createConstraints)
at Asi.Business.BusinessContainer.AddObjectRelationships(String objectName)
at Asi.Business.BusinessController.MergeController(BusinessContainer bc, String objectName, DataSet schemaSource)
at Asi.Business.BusinessController.g__CreateController|151_0(BusinessContainer container2, String name, DataSet ds)
at Asi.Business.BusinessController.NewBusinessController(BusinessContainer container, String objectName, DataSet schemaSource)
at Asi.QueryBuilder.QueryRelation.get_RelationDisplayName()
at Asi.Web.UI.Common.QueryBuilder.DesignClassicSources.CreateChildControls() in D:\a\1\s\src\web\Asi.WebAppRoot.V10\AsiCommon\Controls\QueryBuilder\DesignClassicSources.ascx.cs:line 389
at System.Web.UI.Control.EnsureChildControls()
at Asi.Web.UI.Common.QueryBuilder.DesignClassicSources.PageLoad(Object sender, EventArgs e) in D:\a\1\s\src\web\Asi.WebAppRoot.V10\AsiCommon\Controls\QueryBuilder\DesignClassicSources.ascx.cs:line 923
at System.Web.UI.Control.OnLoad(EventArgs e)
at System.Web.UI.Control.LoadRecursive()
at System.Web.UI.Control.LoadRecursive()
at System.Web.UI.Control.LoadRecursive()
at System.Web.UI.Control.LoadRecursive()
at System.Web.UI.Control.LoadRecursive()
at System.Web.UI.Control.LoadRecursive()
at System.Web.UI.Control.LoadRecursive()
at System.Web.UI.Control.LoadRecursive()
at System.Web.UI.Control.LoadRecursive()
at System.Web.UI.Control.LoadRecursive()
at System.Web.UI.Control.LoadRecursive()
at System.Web.UI.Control.LoadRecursive()
at System.Web.UI.Control.LoadRecursive()
at System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)

Request information:
Request URL: https://xxxx:443/iMIS/QueryBuilder/Design.aspx?&iSession=d71bef82-a06e-4503-84c4-2019fda2d2e9&TemplateType=E
Request path: /iMIS/QueryBuilder/Design.aspx
User host address: 10.50.1.7
User: NSRDAREV
Is authenticated: True
Authentication Type: iMIS
Thread account name: IIS APPPOOL\iMISApp2

Thread information:
Thread ID: 119
Thread account name: IIS APPPOOL\iMISApp2
Is impersonating: False
Stack trace: at System.Data.DataRelation.CheckState()
at System.Data.DataRelation.Create(String relationName, DataColumn[] parentColumns, DataColumn[] childColumns, Boolean createConstraints)
at System.Data.DataRelationCollection.Add(String name, DataColumn[] parentColumns, DataColumn[] childColumns, Boolean createConstraints)
at Asi.Business.BusinessContainer.AddObjectRelationships(String objectName)
at Asi.Business.BusinessController.MergeController(BusinessContainer bc, String objectName, DataSet schemaSource)
at Asi.Business.BusinessController.g__CreateController|151_0(BusinessContainer container2, String name, DataSet ds)
at Asi.Business.BusinessController.NewBusinessController(BusinessContainer container, String objectName, DataSet schemaSource)
at Asi.QueryBuilder.QueryRelation.get_RelationDisplayName()
at Asi.Web.UI.Common.QueryBuilder.DesignClassicSources.CreateChildControls() in D:\a\1\s\src\web\Asi.WebAppRoot.V10\AsiCommon\Controls\QueryBuilder\DesignClassicSources.ascx.cs:line 389
at System.Web.UI.Control.EnsureChildControls()
at Asi.Web.UI.Common.QueryBuilder.DesignClassicSources.PageLoad(Object sender, EventArgs e) in D:\a\1\s\src\web\Asi.WebAppRoot.V10\AsiCommon\Controls\QueryBuilder\DesignClassicSources.ascx.cs:line 923
at System.Web.UI.Control.OnLoad(EventArgs e)
at System.Web.UI.Control.LoadRecursive()
at System.Web.UI.Control.LoadRecursive()
at System.Web.UI.Control.LoadRecursive()
at System.Web.UI.Control.LoadRecursive()
at System.Web.UI.Control.LoadRecursive()
at System.Web.UI.Control.LoadRecursive()
at System.Web.UI.Control.LoadRecursive()
at System.Web.UI.Control.LoadRecursive()
at System.Web.UI.Control.LoadRecursive()
at System.Web.UI.Control.LoadRecursive()
at System.Web.UI.Control.LoadRecursive()
at System.Web.UI.Control.LoadRecursive()
at System.Web.UI.Control.LoadRecursive()
at System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)

Custom event details: