I was working on my report this morning with no issues and Toad Data Point suddenly froze up me. I was forced to end the application with the task manager. Upon reopening, I tried opening my report back up and received the error pasted below. Opened the .tdr file within Notepad++ located the query supplying data to Table1.Relation11 and proceeded to run in a new SQL Editor in TDP to check for any possible issues. The query ran just fine.
Original Toad Error:
System.ArgumentException The type of the “Table1.Relation11.Incidents” value data member isn’t compatible with the numeric scale. Stack Trace: at DevExpress.XtraCharts.SeriesBase.CheckDataMember(Object dataSource, String dataMember, Nullable`1 scaleType) at DevExpress.XtraCharts.SeriesBase.CheckBindingRuntime(Object dataSource) at DevExpress.XtraCharts.Native.DataContainer.CheckBindingRuntime(Object source) at DevExpress.XtraReports.UI.XRChart.ValidateDataSource(Object newSource, Object oldSource, String dataMember) at DevExpress.XtraReports.UI.XtraReportBase.OnDataSourceChanged(Object oldValue) at DevExpress.XtraReports.UI.XtraReportBase.set_DataSource(Object value) at Quest.Toad.DataReport.ReportForm.DoFileOpen(String file) at Quest.Toad.Gui.MainForm.OpenFile(String file, PredefinedParameterCollection predefinedParameters) at Quest.Toad.Gui.MainForm.openFileButton_ItemClick(Object sender, ItemClickEventArgs e) at DevExpress.XtraBars.BarItem.OnClick(BarItemLink link) at DevExpress.XtraBars.BarBaseButtonItem.OnClick(BarItemLink link) at DevExpress.XtraBars.BarButtonItem.OnClick(BarItemLink link) at DevExpress.XtraBars.BarItemLink.OnLinkClick() at DevExpress.XtraBars.BarButtonItemLink.OnLinkClick() at DevExpress.XtraBars.BarItemLink.OnLinkAction(BarLinkAction action, Object actionArgs) at DevExpress.XtraBars.BarButtonItemLink.OnLinkAction(BarLinkAction action, Object actionArgs) at DevExpress.XtraBars.BarItemLink.OnLinkActionCore(BarLinkAction action, Object actionArgs) at DevExpress.XtraBars.ViewInfo.BarSelectionInfo.ClickLink(BarItemLink link) at DevExpress.XtraBars.ViewInfo.BarSelectionInfo.UnPressLink(BarItemLink link) at DevExpress.XtraBars.Controls.CustomLinksControl.OnMouseUp(MouseEventArgs e) at System.Windows.Forms.Control.WmMouseUp(Message& m, MouseButtons button, Int32 clicks) at System.Windows.Forms.Control.WndProc(Message& m) at DevExpress.XtraBars.Controls.DockedBarControl.WndProc(Message& msg) at System.Windows.Forms.Control.ControlNativeWindow.OnMessage(Message& m) at System.Windows.Forms.Control.ControlNativeWindow.WndProc(Message& m) at System.Windows.Forms.NativeWindow.Callback(IntPtr hWnd, Int32 msg, IntPtr wparam, IntPtr lparam)
While trying to troubleshoot, after successfully running the query from Table1.Relation11 in a new SQL editor, I right clicked on the results and sent this data to a new Data Report Designer. Once the wizard finished, I saved it, closed it, and opened it back up to see if it would replicate the error I was receiving on my other report. My test report opened with no issue. So this has me wondering if the dataset is even the culprit or is there some other underlying issue that’s causing my report to crash. I’m thinking it may be the latter, but I can’t seem to identify any correlative info to support that within the context of this error message.
Any thoughts or suggestions would be greatly appreciated. I have more than a dozen relationships in this report and would really like to avoid starting from scratch if possible.