OD cannot log on - Duplicate entry '13683' for key 'PRIMARY'

For users or potential users.
Post Reply
VDS
Posts: 2
Joined: Sat Jun 03, 2023 6:26 am

OD cannot log on - Duplicate entry '13683' for key 'PRIMARY'

Post by VDS » Sat Jun 03, 2023 6:36 am

Hi and Good day OD Team,

Yesterday i just had my OD working fine, then suddenly today i can't log on. The system replied with this message:
Critical Error : Duplicate entry '13683' for key 'PRIMARY'
followed by Stack Trace :
Error Encountered - 03/06/2023 18:05:58
Unhandled exception : Duplicate entry '13683' for key 'PRIMARY'
MySql.Data.MySqlClient.MySqlException
at OpenDentBusiness.DataCore.ExecuteQueryFunc[T](Func`1 f) in C:\Development\Versioned\OpenDental\OpenDentBusiness\Db\DataCore.cs:line 79
at OpenDentBusiness.DataCore.NonQ(String command, Boolean getInsertID, String columnNamePK, String tableName, OdSqlParameter[] parameters) in C:\Development\Versioned\OpenDental\OpenDentBusiness\Db\DataCore.cs:line 42
at OpenDentBusiness.Db.NonQ(String command, Boolean getInsertID, String columnNamePK, String tableName, OdSqlParameter[] parameters) in C:\Development\Versioned\OpenDental\OpenDentBusiness\Db\Db.cs:line 325
at OpenDentBusiness.Crud.SecurityLogCrud.Insert(SecurityLog securityLog, Boolean useExistingPK) in C:\Development\Versioned\OpenDental\OpenDentBusiness\Crud\SecurityLogCrud.cs:line 142
at OpenDentBusiness.Crud.SecurityLogCrud.Insert(SecurityLog securityLog) in C:\Development\Versioned\OpenDental\OpenDentBusiness\Crud\SecurityLogCrud.cs:line 106
at OpenDentBusiness.SecurityLogs.Insert(SecurityLog log) in C:\Development\Versioned\OpenDental\OpenDentBusiness\Data Interface\SecurityLogs.cs:line 144
at OpenDentBusiness.SecurityLogs.MakeLogEntry(SecurityLog secLog) in C:\Development\Versioned\OpenDental\OpenDentBusiness\Data Interface\SecurityLogs.cs:line 287
at OpenDentBusiness.SecurityLogs.MakeLogEntry(Permissions permType, Int64 patNum, String logText) in C:\Development\Versioned\OpenDental\OpenDentBusiness\Data Interface\SecurityLogs.cs:line 221
at OpenDental.FormLogOn.butOK_Click(Object sender, EventArgs e) in C:\Development\Versioned\OpenDental\OpenDental\Forms\FormLogOn.cs:line 183
at System.Windows.Forms.Control.OnClick(EventArgs e)
at System.Windows.Forms.Button.OnClick(EventArgs e)
at OpenDental.UI.Button.OnClick(EventArgs ea) in C:\Development\Versioned\OpenDental\OpenDental\UI\Button.cs:line 177
at System.Windows.Forms.Button.PerformClick()
at System.Windows.Forms.Form.ProcessDialogKey(Keys keyData)
at System.Windows.Forms.Control.ProcessDialogKey(Keys keyData)
at System.Windows.Forms.TextBoxBase.ProcessDialogKey(Keys keyData)
at System.Windows.Forms.Control.PreProcessMessage(Message& msg)
at System.Windows.Forms.Control.PreProcessControlMessageInternal(Control target, Message& msg)
at System.Windows.Forms.Application.ThreadContext.PreTranslateMessage(MSG& msg)


I searched the forum and found that some solved the problem by optimizing tables, but i cannot try the solution since I cannot log on to reach the DB maintenance tool (of my main database). I'm not great at computer so i hope someone can help me getting access back to OD explained for a tech noob like me.
Any help will be much appreciated!

Warm Regards,
VDS

VDS
Posts: 2
Joined: Sat Jun 03, 2023 6:26 am

Re: OD cannot log on - Duplicate entry '13683' for key 'PRIMARY'

Post by VDS » Sat Jun 03, 2023 7:22 am

Problem solved by repairing the tables, helped by Support team AlyssaG, Great job OD Team!

Tom Zaccaria
Posts: 353
Joined: Mon Feb 25, 2008 3:09 am

Re: OD cannot log on - Duplicate entry '13683' for key 'PRIMARY'

Post by Tom Zaccaria » Mon Jun 05, 2023 6:36 am

Did they direct you to a script in images to correct this?
We get this error from time to time and have go back to the server to repair the files.

drtmz

Post Reply