OD beta runtime errors

This forum is for programmers who have questions about the source code.
Post Reply
User avatar
wjstarck
Posts: 935
Joined: Tue Jul 31, 2007 7:18 am
Location: Keller, TX
Contact:

OD beta runtime errors

Post by wjstarck » Fri Jul 14, 2017 9:18 pm

I'm getting the following runtime error running the latest 17.2.x beta:

Code: Select all

System.ArgumentException was unhandled
  HResult=-2147024809
  Message=Column 'BypassGlobalLock' does not belong to table sheetdef.
  Source=System.Data
  StackTrace:
       at System.Data.DataRow.GetDataColumn(String columnName)
       at System.Data.DataRow.get_Item(String columnName)
       at OpenDentBusiness.Crud.SheetDefCrud.TableToList(DataTable table) in C:\Users\wjs\Desktop\ODVersions\opendental17.2\opendental17.2\OpenDentBusiness\Crud\SheetDefCrud.cs:line 59
       at OpenDentBusiness.SheetDefs.FillCache(DataTable table) in C:\Users\wjs\Desktop\ODVersions\opendental17.2\opendental17.2\OpenDentBusiness\Data Interface\SheetDefs.cs:line 54
       at OpenDentBusiness.SheetDefs.RefreshCache() in C:\Users\wjs\Desktop\ODVersions\opendental17.2\opendental17.2\OpenDentBusiness\Data Interface\SheetDefs.cs:line 48
       at OpenDentBusiness.SheetDefC.get_Listt() in C:\Users\wjs\Desktop\ODVersions\opendental17.2\opendental17.2\OpenDentBusiness\Cache\SheetDefC.cs:line 14
       at OpenDentBusiness.SheetDefs.GetCustomForType(SheetTypeEnum sheettype) in C:\Users\wjs\Desktop\ODVersions\opendental17.2\opendental17.2\OpenDentBusiness\Data Interface\SheetDefs.cs:line 168
       at OpenDental.ContrChart.LayoutToolBar() in C:\Users\wjs\Desktop\ODVersions\opendental17.2\opendental17.2\OpenDental\Main Modules\ContrChart.cs:line 3507
       at OpenDental.ContrChart.InitializeLocalData() in C:\Users\wjs\Desktop\ODVersions\opendental17.2\opendental17.2\OpenDental\Main Modules\ContrChart.cs:line 3403
       at OpenDental.FormOpenDental.RefreshLocalDataPostCleanup(Boolean isAll, InvalidType[] arrayITypes) in C:\Users\wjs\Desktop\ODVersions\opendental17.2\opendental17.2\OpenDental\Main Modules\FormOpenDental.cs:line 3334
       at OpenDental.FormOpenDental.RefreshLocalData(Boolean doRefreshServerCache, InvalidType[] arrayITypes) in C:\Users\wjs\Desktop\ODVersions\opendental17.2\opendental17.2\OpenDental\Main Modules\FormOpenDental.cs:line 3265
       at OpenDental.FormOpenDental.RefreshLocalData(InvalidType[] arrayITypes) in C:\Users\wjs\Desktop\ODVersions\opendental17.2\opendental17.2\OpenDental\Main Modules\FormOpenDental.cs:line 3255
       at OpenDental.FormOpenDental.FormOpenDental_Load(Object sender, EventArgs e) in C:\Users\wjs\Desktop\ODVersions\opendental17.2\opendental17.2\OpenDental\Main Modules\FormOpenDental.cs:line 2619
       at System.Windows.Forms.Form.OnLoad(EventArgs e)
       at System.Windows.Forms.Form.OnCreateControl()
       at System.Windows.Forms.Control.CreateControl(Boolean fIgnoreVisible)
       at System.Windows.Forms.Control.CreateControl()
       at System.Windows.Forms.Control.WmShowWindow(Message& m)
       at System.Windows.Forms.Control.WndProc(Message& m)
       at System.Windows.Forms.ScrollableControl.WndProc(Message& m)
       at System.Windows.Forms.Form.WmShowWindow(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.DebuggableCallback(IntPtr hWnd, Int32 msg, IntPtr wparam, IntPtr lparam)
  InnerException: 
But ByPassGlobalLock is a column in table sheetdef

???
Cheers,

Bill Starck, DDS
Big Idea Software, LLC
Developer, EASy(Electronic Anesthesia System) for Open Dental
817-807-1709
TX, USA

User avatar
jsalmon
Posts: 1551
Joined: Tue Nov 30, 2010 12:33 pm
Contact:

Re: OD beta runtime errors

Post by jsalmon » Mon Jul 17, 2017 9:03 am

Maybe you're connected to a different database than the one you are querying? Put a breakpoint at the top of SheetDefCrud.TableToList() and inspect the DataTable that was passed in to see if it has the column or not.
The best thing about a boolean is even if you are wrong, you are only off by a bit.

Jason Salmon
Open Dental Software
http://www.opendental.com

Post Reply