Unhandled exception error

For users or potential users.
Post Reply
drpeteryee
Posts: 15
Joined: Mon Jan 30, 2012 2:19 pm

Unhandled exception error

Post by drpeteryee » Tue Apr 28, 2020 2:46 pm

I got this error today... Can any one help? I get past the log in but then it gives me this error and I can not even see the schedule.

Unhandled exception: Incorrect key file for table '.\srca\procedurelog.MYI'; try to repair it
MySql.Data.MySqlClient.MySqlException
at DataConnectionBase.DataConnection.GetTable(String command, Boolean doAutoRetry)
at OpenDentBusiness.Appointments.GetPeriodApptsTable(DateTime dateStart, DateTime dateEnd, Int64 aptNum, Boolean isPlanned, List`1 listPinApptNums, List`1 listOpNums, List`1 listProvNums, Boolean doRunQueryOnNoOps) in C:\Development\OPEN DENTAL SUBVERSION\opendental19.1\OpenDentBusiness\Data Interface\Appointments.cs:line 781
at OpenDental.ContrAppt.RefreshAppointmentsIfNeeded(DateTime dateStart, DateTime dateEnd, List`1 listPinApptNums, List`1 listOpNums, List`1 listProvNums, Boolean isRefreshNeeded) in C:\Development\OPEN DENTAL SUBVERSION\opendental19.1\OpenDental\Main Modules\ContrAppt.cs:line 1636
at OpenDental.ContrAppt.RefreshModuleDataPeriod(List`1 listPinApptNums, List`1 listOpNums, List`1 listProvNums, Boolean isRefreshAppointments, Boolean isRefreshSchedules) in C:\Development\OPEN DENTAL SUBVERSION\opendental19.1\OpenDental\Main Modules\ContrAppt.cs:line 1693
at OpenDental.ContrAppt.ModuleSelected(Int64 patNum, List`1 listPinApptNums, List`1 listOpNums, List`1 listProvNums) in C:\Development\OPEN DENTAL SUBVERSION\opendental19.1\OpenDental\Main Modules\ContrAppt.cs:line 1543
at OpenDental.FormOpenDental.SetModuleSelected(Boolean menuBarClicked) in C:\Development\OPEN DENTAL SUBVERSION\opendental19.1\OpenDental\Main Modules\FormOpenDental.cs:line 5741
at OpenDental.FormOpenDental.SetModuleSelected() in C:\Development\OPEN DENTAL SUBVERSION\opendental19.1\OpenDental\Main Modules\FormOpenDental.cs:line 5731
at OpenDental.FormOpenDental.ProcessCommandLine(String[] args) in C:\Development\OPEN DENTAL SUBVERSION\opendental19.1\OpenDental\Main Modules\FormOpenDental.cs:line 8500
at OpenDental.FormOpenDental.FormOpenDental_Load(Object sender, EventArgs e) in C:\Development\OPEN DENTAL SUBVERSION\opendental19.1\OpenDental\Main Modules\FormOpenDental.cs:line 2968
at System.EventHandler.Invoke(Object sender, EventArgs e)
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.Callback(IntPtr hWnd, Int32 msg, IntPtr wparam, IntPtr lparam)

joes
Posts: 239
Joined: Tue Aug 13, 2019 12:41 pm

Re: Unhandled exception error

Post by joes » Wed Apr 29, 2020 8:29 am

Hello drpeteryee. This error indicates that the procedurelog table of your database is most likely corrupted and will need to be repaired. Our manual page, https://www.opendental.com/manual/corruption.html, outlines some steps that you can take to resolve this issue.
Joe Sullivan
Open Dental Software
http://www.opendental.com

Post Reply