Open Dental Forum

Posted: **Fri Jul 14, 2017 9:18 pm**

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

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

???

Posted: **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.

Open Dental Forum

OD beta runtime errors

OD beta runtime errors

Re: OD beta runtime errors