Appointments Disappeared - not recorded in Audit Log

For users or potential users.
Post Reply
User avatar
Rickliftig
Posts: 764
Joined: Thu Jul 10, 2008 4:50 pm
Location: West Hartford, CT
Contact:

Appointments Disappeared - not recorded in Audit Log

Post by Rickliftig » Thu Mar 17, 2016 5:48 am

Jason, Arna et al:

Over the last month, we have had four incidents where an appointment was made and then later on, disappeared from the appointment view.

I would generally blame this on operator error, but here is the evidence:

1) in the audit log, the appointment was listed as created. It was never moved or deleted after that. Still, it didn't show on the appointment view.
2) My staff still uses a paper appointment book as a backup (it may be redundant, but it worked this time) and the appointment has been physically recorded in there.
3) The appointments did not show up in the "View Patient's Appointments" window either

I have run a database check and fix - nothing there. Have you ever seen this behavior before? (We are keeping a close track on this for the future)

Thanks in advance.
Another Happy Open Dental User!

Rick Liftig, DMD FAGD
University of CT 1979
West Hartford, CT 06110
srick@snet.net

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

Re: Appointments Disappeared - not recorded in Audit Log

Post by jsalmon » Thu Mar 17, 2016 12:34 pm

We've actually had this complaint recently and are actively looking into if there are any places in the program that could possibly delete the appointment without making a log entry.
What is the exact version of Open Dental that you are currently using?
Do you have any 3rd party programs that "reverse bridge" to Open Dental (not trying to place blame elsewhere, just informational)?
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
Rickliftig
Posts: 764
Joined: Thu Jul 10, 2008 4:50 pm
Location: West Hartford, CT
Contact:

Re: Appointments Disappeared - not recorded in Audit Log

Post by Rickliftig » Thu Mar 17, 2016 12:41 pm

Jason - Version 15.4.24. - I'm not sure what a reverse bridge is - we are using a VIXWIN bridge.

Rick
Another Happy Open Dental User!

Rick Liftig, DMD FAGD
University of CT 1979
West Hartford, CT 06110
srick@snet.net

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

Re: Appointments Disappeared - not recorded in Audit Log

Post by jsalmon » Thu Mar 17, 2016 12:48 pm

Reverse bridges are companies that directly access the Open Dental database without Open Dental's "knowledge" that they were ever accessing the database. Typically this is with software that does things like Lighthouse 360 would.
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

spsheffield
Posts: 19
Joined: Sat Feb 11, 2012 6:30 pm

Re: Appointments Disappeared - not recorded in Audit Log

Post by spsheffield » Thu Mar 17, 2016 2:24 pm

I just had this happen to me today. Had a patient show up for a hygiene appointment that wasn't in the schedule, but he had his appointment card that we had printed when we made the appointment, and sure enough, it was scheduled for today. I ended up doing his prophy since the hygienist had gone home thinking there was no one in the schedule :evil: Couldn't find anywhere in the audit trail where the appointment had been moved/deleted/etc. It just simply was gone.

User avatar
Rickliftig
Posts: 764
Joined: Thu Jul 10, 2008 4:50 pm
Location: West Hartford, CT
Contact:

Re: Appointments Disappeared - not recorded in Audit Log

Post by Rickliftig » Thu Mar 17, 2016 2:59 pm

Ruh-roh.... All hands on deck.
Another Happy Open Dental User!

Rick Liftig, DMD FAGD
University of CT 1979
West Hartford, CT 06110
srick@snet.net

allends
Posts: 235
Joined: Fri Aug 23, 2013 11:29 am

Re: Appointments Disappeared - not recorded in Audit Log

Post by allends » Thu Mar 17, 2016 3:07 pm

The problem has been found and will be fixed with the next release.
Allen
Open Dental Software
http://www.opendental.com

User avatar
Rickliftig
Posts: 764
Joined: Thu Jul 10, 2008 4:50 pm
Location: West Hartford, CT
Contact:

Re: Appointments Disappeared - not recorded in Audit Log

Post by Rickliftig » Thu Mar 17, 2016 4:12 pm

Allen - that's great news! I know of other dental software companies that would have ignored the problem or delayed taking action until many docs had lost data. This is one of the many reasons that I have so much confidence in the OD team.FWIW, this is the first time in eight years that our office has ever experienced data loss with the program.

Many thanks!
Another Happy Open Dental User!

Rick Liftig, DMD FAGD
University of CT 1979
West Hartford, CT 06110
srick@snet.net

spsheffield
Posts: 19
Joined: Sat Feb 11, 2012 6:30 pm

Re: Appointments Disappeared - not recorded in Audit Log

Post by spsheffield » Fri Mar 18, 2016 5:43 am

I have a question about this. Even if the problem is fixed for the future, can I expect that maybe there were other appointments that have already been deleted without our knowledge, and that we may end up with another patient showing up when we aren't expecting them? Does the "fix" include restoring the appointments that were deleted? Is there any way for us to know what was deleted?

allends
Posts: 235
Joined: Fri Aug 23, 2013 11:29 am

Re: Appointments Disappeared - not recorded in Audit Log

Post by allends » Fri Mar 18, 2016 7:45 am

The problem really only occurred when two different workstations were adding or editing and appointment at the same time, for the same patient. I hope it isn't happening too often.

Since the appointment is deleted, there is no real way for us to bring it back. We wouldn't know what it looked like before it was deleted.
Allen
Open Dental Software
http://www.opendental.com

tgriswold
Posts: 122
Joined: Fri Jun 07, 2013 8:52 am

Re: Appointments Disappeared - not recorded in Audit Log

Post by tgriswold » Fri Mar 18, 2016 3:13 pm

"Appointments were being deleted when multiple users were concurrently modifying appointments for the same patient sometimes." fixed in version 15.4.40 and 16.1.11. As Allen mentioned, we can't recover what was already lost sadly. But in this case this was happening because user1 had the appt edit window open when user2 added an appointment. Then when user1 clicked OK (they could have it open for a very long time, and not even change anything) it undid that appointment that what just added. This was an unforeseen concurrency issue and after those versions mentioned above there should be no issues with multiple people looking and editing appointments at the same time, as long as they are not editing the same things.
Travis Griswold
Open Dental Software
http://www.opendental.com

User avatar
Rickliftig
Posts: 764
Joined: Thu Jul 10, 2008 4:50 pm
Location: West Hartford, CT
Contact:

Re: Appointments Disappeared - not recorded in Audit Log

Post by Rickliftig » Fri Mar 18, 2016 3:37 pm

Travis - out of curiousity, how many versions has this affected? The reason I ask is that this behavior has only been seen in our office over the last month (out of eight years)
Another Happy Open Dental User!

Rick Liftig, DMD FAGD
University of CT 1979
West Hartford, CT 06110
srick@snet.net

tgriswold
Posts: 122
Joined: Fri Jun 07, 2013 8:52 am

Re: Appointments Disappeared - not recorded in Audit Log

Post by tgriswold » Fri Mar 18, 2016 4:42 pm

The code with the bug was first introduced in 15.4 with the appointment reminders feature. Though I could easily see an office not having run into the bug through normal use for an extended period of time.
Last edited by tgriswold on Fri Mar 18, 2016 4:45 pm, edited 1 time in total.
Travis Griswold
Open Dental Software
http://www.opendental.com

allends
Posts: 235
Joined: Fri Aug 23, 2013 11:29 am

Re: Appointments Disappeared - not recorded in Audit Log

Post by allends » Fri Mar 18, 2016 4:44 pm

I was able to track the issue back to 15.4. Most likely, why this hasn't been a huge issue is because two workstations would need to be on the same patient, editing/adding an appointment, at the same time. Or, as Travis stated, they would need to leave an Edit Appointment window open for a long enough on a patient that an appointment had been added or edited in the meantime.
Allen
Open Dental Software
http://www.opendental.com

Post Reply