Error when connecting to Middle Tier

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:

Error when connecting to Middle Tier

Post by wjstarck » Tue Jul 27, 2021 9:17 pm

I have a Middle Tier server setup. OD version is 21.2.22.

I get this error when I try to connect to the server from a workstation:

Code: Select all

Error Encountered - 07/27/2021 11:14:27 PM
Unhandled exception :  Column 'WaitingRmName' does not belong to table ApptView.
System.ArgumentException
   at System.Data.DataRow.GetDataColumn(String columnName)
   at System.Data.DataRow.get_Item(String columnName)
   at OpenDentBusiness.Crud.ApptViewCrud.TableToList(DataTable table) in C:\Development\OPEN DENTAL SUBVERSION\opendental21.2\OpenDentBusiness\Crud\ApptViewCrud.cs:line 64
   at OpenDentBusiness.ApptViews.ApptViewCache.TableToList(DataTable table) in C:\Development\OPEN DENTAL SUBVERSION\opendental21.2\OpenDentBusiness\Data Interface\ApptViews.cs:line 81
   at OpenDentBusiness.CacheAbs`1.FillCache(FillCacheSource source, DataTable table) in C:\Development\OPEN DENTAL SUBVERSION\opendental21.2\OpenDentBusiness\Cache\CacheAbs.cs:line 39
   at OpenDentBusiness.ApptViews.FillCacheFromTable(DataTable table) in C:\Development\OPEN DENTAL SUBVERSION\opendental21.2\OpenDentBusiness\Data Interface\ApptViews.cs:line 116
   at OpenDentBusiness.Cache.FillCache(DataSet ds, InvalidType[] arrayITypes) in C:\Development\OPEN DENTAL SUBVERSION\opendental21.2\OpenDentBusiness\Cache\Cache.cs:line 718
   at OpenDentBusiness.Cache.Refresh(Boolean doRefreshServerCache, InvalidType[] arrayITypes) in C:\Development\OPEN DENTAL SUBVERSION\opendental21.2\OpenDentBusiness\Cache\Cache.cs:line 31
   at OpenDental.FormOpenDental.RefreshLocalData(Boolean doRefreshServerCache, InvalidType[] arrayITypes) in C:\Development\OPEN DENTAL SUBVERSION\opendental21.2\OpenDental\Main Modules\FormOpenDental.cs:line 1367
   at OpenDental.FormOpenDental.RefreshLocalData(InvalidType[] arrayITypes) in C:\Development\OPEN DENTAL SUBVERSION\opendental21.2\OpenDental\Main Modules\FormOpenDental.cs:line 1359
   at OpenDental.FormOpenDental.RefreshMenuClinics() in C:\Development\OPEN DENTAL SUBVERSION\opendental21.2\OpenDental\Main Modules\FormOpenDental.cs:line 2875
   at OpenDental.FormOpenDental.FormOpenDentalShown() in C:\Development\OPEN DENTAL SUBVERSION\opendental21.2\OpenDental\Main Modules\FormOpenDental.cs:line 668
   at OpenDental.FormOpenDental.FormOpenDental_Shown(Object sender, EventArgs e) in C:\Development\OPEN DENTAL SUBVERSION\opendental21.2\OpenDental\Main Modules\FormOpenDental.cs:line 362
   at System.EventHandler.Invoke(Object sender, EventArgs e)
   at System.Windows.Forms.Form.OnShown(EventArgs e)
   at System.Windows.Forms.Form.CallShownEvent()
   at System.Windows.Forms.Control.InvokeMarshaledCallbackDo(ThreadMethodEntry tme)
   at System.Windows.Forms.Control.InvokeMarshaledCallbackHelper(Object obj)
   at System.Threading.ExecutionContext.RunInternal(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx)
   at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx)
   at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state)
   at System.Windows.Forms.Control.InvokeMarshaledCallback(ThreadMethodEntry tme)
   at System.Windows.Forms.Control.InvokeMarshaledCallbacks()
But that field *does* exist in opendental.apptview on the server.

The server is currently built in Debug mode.

MySQL on this server is 5.6

:?:
Cheers,

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

User avatar
wjstarck
Posts: 935
Joined: Tue Jul 31, 2007 7:18 am
Location: Keller, TX
Contact:

Re: Error when connecting to Middle Tier

Post by wjstarck » Thu Jul 29, 2021 5:52 am

NVM, found it.
Cheers,

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

Post Reply