InvalidConstraintException

Rodrigo · Post by **Rodrigo** » Sun Oct 30, 2011 6:54 am

Hello!

I have two DataSources with a relationship through an ID. "StiWebViewerFx1.Report = report" shows the error:

[InvalidConstraintException: Columns primary and secondary columns do not have columns that match.]
Stimulsoft.Report.Dictionary.StiDictionary.RegRelation(StiDataRelation relation, Boolean virtualSources) +3223
Stimulsoft.Report.Dictionary.StiDictionary.RegRelations(Boolean virtualSources) +169
Stimulsoft.Report.Dictionary.StiDictionary.RegRelations() +31
Stimulsoft.Report.Dictionary.StiDictionary.Connect(Boolean loadData) +207
Stimulsoft.Report.Dictionary.StiDictionary.Connect() +34
Stimulsoft.Report.Engine.StiRenderProviderV2.ConnectToData(StiReport report) +129
Stimulsoft.Report.Engine.StiRenderProviderV2.Render(StiReport report, StiRenderState state) +2890
Stimulsoft.Report.Engine.StiReportV2Builder.RenderSingleReport(StiReport masterReport, StiRenderState renderState) +1176
Stimulsoft.Report.StiReport.RenderReport(StiRenderState renderState) +247
Stimulsoft.Report.StiReport.Render(StiRenderState renderState, StiGuiMode guiMode) +1046
Stimulsoft.Report.StiReport.Render(StiRenderState renderState) +38
Stimulsoft.Report.StiReport.Render(Boolean showProgress, Int32 fromPage, Int32 toPage) +69
Stimulsoft.Report.StiReport.Render(Boolean showProgress) +41
Stimulsoft.Report.WebFx.StiWebViewerFx.set_Report(StiReport value) +245
Informes.Page_Load(Object sender, EventArgs e) in C:\Proyectos\09_2002_GERIGES_SAAS\Diseño_2_0\Fuentes\Codigo\GeriGes\Informes.aspx.vb:2843
System.Web.UI.Control.OnLoad(EventArgs e) +99
System.Web.UI.Control.LoadRecursive() +50
System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +627
--------------------------------------------------------------------------------
Información de versión: Versión de Microsoft .NET Framework:2.0.50727.5448; Versión ASP.NET:2.0.50727.5420

I have created other relationships and had no problems. The two IDs are the same type (int) and have the same name. A table is primary key and another is foreign key.
I checked the relationship several times and seems to be ok.

Can you help me?

Thanks.

Rodrigo · Post by **Rodrigo** » Sun Oct 30, 2011 12:32 pm

I discovered that was happening. Although the types of the columns of DataSources (in report) were "Int", in datasets where the data loaded, one was "System.Int32" and another "System.String" that produced the error.

Thanks to all.

Post by **Andrew** » Mon Oct 31, 2011 12:37 am

Hello,

Do I understand you correct the issue is solved?

Thank you.

Rodrigo · Post by **Rodrigo** » Mon Oct 31, 2011 2:37 am

Yes, I solved the problem.

Post by **Andrew** » Mon Oct 31, 2011 6:12 am

Great!

Have a nice day.
Thank you.