v19.2.18 Graphic Report Error

For complex topics that regular users would not be interested in. For power users and database administrators.
Post Reply
User avatar
drtech
Posts: 1647
Joined: Wed Jun 20, 2007 8:44 am
Location: Springfield, MO
Contact:

v19.2.18 Graphic Report Error

Post by drtech » Fri Sep 06, 2019 5:03 am

trying to open graphical reports

Unhandled exception: InvalidArgument=Value of '0' is not valid for 'SelectedIndex'.
Parameter name: SelectedIndex
System.ArgumentOutOfRangeException
at System.Windows.Forms.ComboBox.set_SelectedIndex(Int32 value)
at OpenDentalGraph.BrokenApptGraphOptionsCtrl.FillComboBrokenProc() in C:\SVN\beta\OpenDentalGraph\Concrete\BrokenApptGraphOptionsCtrl.cs:line 169
at OpenDentalGraph.BrokenApptGraphOptionsCtrl..ctor() in C:\SVN\beta\OpenDentalGraph\Concrete\BrokenApptGraphOptionsCtrl.cs:line 121
at OpenDentalGraph.GraphQuantityOverTimeFilter..ctor(DashboardCellType cellType, String jsonSettings, OnGetColorFromSeriesGraphTypeArgs onGetSeriesColor, GetGraphPointsForHQArgs onGetODGraphPointsArgs) in C:\SVN\beta\OpenDentalGraph\Concrete\GraphQuantityOverTimeFilter.cs:line 19
at OpenDentalGraph.DashboardPanelCtrl.SetCellLayout(Int32 rows, Int32 columns, List`1 cells, OnGetColorFromSeriesGraphTypeArgs onGetSeriesColor, GetGraphPointsForHQArgs onGetODGraphPointsArgs) in C:\SVN\beta\OpenDentalGraph\Dashboard\DashboardPanelCtrl.cs:line 227
at OpenDentalGraph.DashboardTabCtrl.<>c__DisplayClass14_0.<SetDashboardLayout>b__1(DashboardLayout x) in C:\SVN\beta\OpenDentalGraph\Dashboard\DashboardTabCtrl.cs:line 162
at System.Collections.Generic.List`1.ForEach(Action`1 action)
at OpenDentalGraph.DashboardTabCtrl.SetDashboardLayout(List`1 layouts, Boolean invalidateFirst, OnGetColorFromSeriesGraphTypeArgs onGetSeriesColor, GetGraphPointsForHQArgs onGetODGraphPointsArgs) in C:\SVN\beta\OpenDentalGraph\Dashboard\DashboardTabCtrl.cs:line 160
at OpenDentalGraph.FormDashboardEditTab.RefreshData(Boolean invalidateFirst) in C:\SVN\beta\OpenDentalGraph\Dashboard\FormDashboardEditTab.cs:line 83
at OpenDentalGraph.FormDashboardEditTab..ctor(Int64 provNum, Boolean useProvFilter, EventHandler onSetDb) in C:\SVN\beta\OpenDentalGraph\Dashboard\FormDashboardEditTab.cs:line 72
at OpenDental.FormOpenDental.menuItemReportsGraphic_Click(Object sender, EventArgs e) in C:\SVN\beta\OpenDental\Main Modules\FormOpenDental.cs:line 7438
at System.Windows.Forms.MenuItem.OnClick(EventArgs e)
at System.Windows.Forms.MenuItem.MenuItemData.Execute()
at System.Windows.Forms.Command.Invoke()
at System.Windows.Forms.Command.DispatchID(Int32 id)
at System.Windows.Forms.Control.WmCommand(Message& m)
at System.Windows.Forms.Control.WndProc(Message& m)
at System.Windows.Forms.ScrollableControl.WndProc(Message& m)
at System.Windows.Forms.Form.WndProc(Message& m)
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)
David Fuchs
Dentist - Springfield, MO
Smile Dental http://www.887-smile.com

PatrickC
Posts: 56
Joined: Thu Jun 06, 2019 11:37 am

Re: v19.2.18 Graphic Report Error

Post by PatrickC » Fri Sep 06, 2019 9:48 am

Check what the BrokenApptProcedure preference is set to by running this query.

Code: Select all

SELECT ValueString FROM preference WHERE prefname LIKE '%BrokenApptProcedure%'
If it is any value other than 0 through 3, or non-existent, then that may be the problem.

https://www.opendental.com/manual192/mo ... appts.html
Go to Setup->Appointments->Appts Preferences
In the box at the top of the Behavior tab titled "Broken Appointment Automation", are you able to click the dropdown next to "Broken Appointment Procedure Types"?
If you're not able to click it, then it indicates that you don't have procedures set up for Missed and Cancelled appointments. Which should be fine, and it would default you to a value of 0 in the preference we queried above.

That leaves the following question. Do you have procedures set up for Cancelled and Missed appointments?

I'll keep looking and see if there's any changes that would be affecting that preference as well.
Patrick Carlson
Open Dental Software
http://www.opendental.com

User avatar
drtech
Posts: 1647
Joined: Wed Jun 20, 2007 8:44 am
Location: Springfield, MO
Contact:

Re: v19.2.18 Graphic Report Error

Post by drtech » Mon Sep 09, 2019 2:18 pm

It has a value of 0....and yes I did have it setup for broken app procedure types...no that is an adjustment type and that is still setup.
David Fuchs
Dentist - Springfield, MO
Smile Dental http://www.887-smile.com

User avatar
drtech
Posts: 1647
Joined: Wed Jun 20, 2007 8:44 am
Location: Springfield, MO
Contact:

Re: v19.2.18 Graphic Report Error

Post by drtech » Mon Sep 09, 2019 2:24 pm

I added those two procedure codes, then the combo box let me choose missed, cancelled, or both. I chose both.

I ran the above query and got the expected value of 3 now that it is changed,


I then tried the graphical reports and got the same error:

Error Encountered - 09/09/2019 4:24:07 PM
Unhandled exception: InvalidArgument=Value of '0' is not valid for 'SelectedIndex'.
Parameter name: SelectedIndex
System.ArgumentOutOfRangeException
at System.Windows.Forms.ComboBox.set_SelectedIndex(Int32 value)
at OpenDentalGraph.BrokenApptGraphOptionsCtrl.FillComboBrokenProc() in C:\SVN\beta\OpenDentalGraph\Concrete\BrokenApptGraphOptionsCtrl.cs:line 169
at OpenDentalGraph.BrokenApptGraphOptionsCtrl..ctor() in C:\SVN\beta\OpenDentalGraph\Concrete\BrokenApptGraphOptionsCtrl.cs:line 121
at OpenDentalGraph.GraphQuantityOverTimeFilter..ctor(DashboardCellType cellType, String jsonSettings, OnGetColorFromSeriesGraphTypeArgs onGetSeriesColor, GetGraphPointsForHQArgs onGetODGraphPointsArgs) in C:\SVN\beta\OpenDentalGraph\Concrete\GraphQuantityOverTimeFilter.cs:line 19
at OpenDentalGraph.DashboardPanelCtrl.SetCellLayout(Int32 rows, Int32 columns, List`1 cells, OnGetColorFromSeriesGraphTypeArgs onGetSeriesColor, GetGraphPointsForHQArgs onGetODGraphPointsArgs) in C:\SVN\beta\OpenDentalGraph\Dashboard\DashboardPanelCtrl.cs:line 227
at OpenDentalGraph.DashboardTabCtrl.<>c__DisplayClass14_0.<SetDashboardLayout>b__1(DashboardLayout x) in C:\SVN\beta\OpenDentalGraph\Dashboard\DashboardTabCtrl.cs:line 162
at System.Collections.Generic.List`1.ForEach(Action`1 action)
at OpenDentalGraph.DashboardTabCtrl.SetDashboardLayout(List`1 layouts, Boolean invalidateFirst, OnGetColorFromSeriesGraphTypeArgs onGetSeriesColor, GetGraphPointsForHQArgs onGetODGraphPointsArgs) in C:\SVN\beta\OpenDentalGraph\Dashboard\DashboardTabCtrl.cs:line 160
at OpenDentalGraph.FormDashboardEditTab.RefreshData(Boolean invalidateFirst) in C:\SVN\beta\OpenDentalGraph\Dashboard\FormDashboardEditTab.cs:line 83
at OpenDentalGraph.FormDashboardEditTab..ctor(Int64 provNum, Boolean useProvFilter, EventHandler onSetDb) in C:\SVN\beta\OpenDentalGraph\Dashboard\FormDashboardEditTab.cs:line 72
at OpenDental.FormOpenDental.menuItemReportsGraphic_Click(Object sender, EventArgs e) in C:\SVN\beta\OpenDental\Main Modules\FormOpenDental.cs:line 7438
at System.Windows.Forms.MenuItem.OnClick(EventArgs e)
at System.Windows.Forms.MenuItem.MenuItemData.Execute()
at System.Windows.Forms.Command.Invoke()
at System.Windows.Forms.Command.DispatchID(Int32 id)
at System.Windows.Forms.Control.WmCommand(Message& m)
at System.Windows.Forms.Control.WndProc(Message& m)
at System.Windows.Forms.ScrollableControl.WndProc(Message& m)
at System.Windows.Forms.Form.WndProc(Message& m)
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)
David Fuchs
Dentist - Springfield, MO
Smile Dental http://www.887-smile.com

User avatar
cmcgehee
Posts: 711
Joined: Tue Aug 25, 2015 5:06 pm
Location: Salem, Oregon

Re: v19.2.18 Graphic Report Error

Post by cmcgehee » Mon Sep 09, 2019 3:27 pm

If the issue isn't caused by anything Patrick mentioned, I would suspect compiler shenanigans. The code where you're getting the error is in a different dll, OpenDentalGraph.dll, so if that didn't get recompiled when OpenDentBusiness got recompiled, then the PrefName enum could be pointing to a different value for PrefName.BrokenApptProcedure.
Chris McGehee
Open Dental Software
http://www.opendental.com

User avatar
drtech
Posts: 1647
Joined: Wed Jun 20, 2007 8:44 am
Location: Springfield, MO
Contact:

Re: v19.2.18 Graphic Report Error

Post by drtech » Tue Sep 10, 2019 12:35 pm

I will try to recompile everything and try again. Thanks!
David Fuchs
Dentist - Springfield, MO
Smile Dental http://www.887-smile.com

User avatar
drtech
Posts: 1647
Joined: Wed Jun 20, 2007 8:44 am
Location: Springfield, MO
Contact:

Re: v19.2.18 Graphic Report Error

Post by drtech » Fri Sep 13, 2019 1:52 pm

Rebuilt all and it works again. Thanks for pointing me in the right direction.
David Fuchs
Dentist - Springfield, MO
Smile Dental http://www.887-smile.com

Post Reply