Database Maint. Error

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

Database Maint. Error

Post by drtech » Tue Mar 26, 2024 11:20 am

Was running Database Maint. today and was stopped with this error:

Index was outside the bounds of the array.
System.IndexOutOfRangeException
at OpenDental.FormDatabaseMaintenance.RunMethod(MethodInfo methodInfo, List`1 listObjectsParameters, DbmMode dbmModeCur) in C:\Users\drtec\source\git\opendental\OpenDental\Forms\FormDatabaseMaintenance.cs:line 894
at OpenDental.FormDatabaseMaintenance.RunMethod(MethodInfo methodInfo, DbmMode dbmModeCur) in C:\Users\drtec\source\git\opendental\OpenDental\Forms\FormDatabaseMaintenance.cs:line 864
at OpenDental.FormDatabaseMaintenance.<>c__DisplayClass103_0.<Run>b__1(ODThread o) in C:\Users\drtec\source\git\opendental\OpenDental\Forms\FormDatabaseMaintenance.cs:line 817
at CodeBase.ODThread.SetupRunTeardown() in C:\Users\drtec\source\git\opendental\CodeBase\Utilities\ODThread.cs:line 194

Looks like it occurred when running MySQL ServerOptionsValidate.

Running Mysql 5.7 on Ubuntu
David Fuchs
Dentist - Springfield, MO
Smile Dental http://www.887-smile.com

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

Re: Database Maint. Error

Post by drtech » Tue Apr 23, 2024 11:59 am

any update on this? I ran DB maint again today and got this same error


Index was outside the bounds of the array.
System.IndexOutOfRangeException
at OpenDental.FormDatabaseMaintenance.RunMethod(MethodInfo methodInfo, List`1 listObjectsParameters, DbmMode dbmModeCur) in C:\Users\drtec\source\git\opendental\OpenDental\Forms\FormDatabaseMaintenance.cs:line 894
at OpenDental.FormDatabaseMaintenance.RunMethod(MethodInfo methodInfo, DbmMode dbmModeCur) in C:\Users\drtec\source\git\opendental\OpenDental\Forms\FormDatabaseMaintenance.cs:line 864
at OpenDental.FormDatabaseMaintenance.<>c__DisplayClass103_0.<Run>b__1(ODThread o) in C:\Users\drtec\source\git\opendental\OpenDental\Forms\FormDatabaseMaintenance.cs:line 817
at CodeBase.ODThread.SetupRunTeardown() in C:\Users\drtec\source\git\opendental\CodeBase\Utilities\ODThread.cs:line 194
David Fuchs
Dentist - Springfield, MO
Smile Dental http://www.887-smile.com

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

Re: Database Maint. Error

Post by jsalmon » Wed Apr 24, 2024 3:33 pm

What version of Open Dental are you using?
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

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

Re: Database Maint. Error

Post by jsalmon » Wed Apr 24, 2024 4:17 pm

Apparently this has already been addressed. You need to be at or above the following versions: v23.1.60, v23.2.30, or v23.3.5
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