Page 1 of 1
Unhandled exception error
Posted: Wed Jul 31, 2013 6:44 pm
by Tom Zaccaria
Got this message after restoring backup to home computer.Tried to go to patient chart.
Unhandled exception
'Duplicate Entry '344498' for key 'PRIMARY''
Been restoring successfully for days. Any ideas?
drtmz
Re: Unhandled exception error
Posted: Wed Jul 31, 2013 9:20 pm
by Manny Ramirez
Stop the database manually (Windows Services) Rename your database to something like OpenDentalBK and OpendentImagesBK. Copy and paste the Opendental and OpendentImages folders from your latest backup to their default location ( or wherever you installed them) and start the data base again. Give that a try and keep us posted
Re: Unhandled exception error
Posted: Thu Aug 01, 2013 2:43 am
by Tom Zaccaria
Tried it. No luck.
I can access all the modules except the chart module.
drtmz
Re: Unhandled exception error
Posted: Thu Aug 01, 2013 7:38 am
by Manny Ramirez
Sounds like .net framework. If this is machine specific, try re-installing the .net framework. Use the .net framework cleanup utility available from MS downloads page. Enable .netframwork 3.5 install 4.0 and give it a try. Keep us posted.
Re: Unhandled exception error
Posted: Thu Aug 01, 2013 9:00 am
by jsalmon
It's a database problem. Might just be a bad backup. You could try to run database maintenance tool called Optimize and then after that click the fix button to actually run DBM. Otherwise discard that backup as corrupt and get a new one. If the problem happens on your live db, give us a call and we'll play doctor with your db.
http://opendental.com/manual/databasemaintenance.html
Re: Unhandled exception error
Posted: Thu Aug 01, 2013 4:06 pm
by Tom Zaccaria
Database tools found three corrupt files.
Fixed them and now home backup is happy as a clam.
Thanks,
drtmz