Carrier Appointments Are Duplicating In The Database When Saved From Dock and Yard Manager Causing Application Instability (Doc ID 2211888.1)

Note: This issue only exists if you are using Internet Explorer 11 browser version compatible with Windows 10 operating system.  If you are not using IE 11 or if your computer is not on a Windows 10 platform, then this issue does not apply.

Note:  Once duplicate appointments are created, the following application instability is observed:

a. Trying to block or unblock an appointment slot AFTER the duplicated appointment and saving the change will not persist the change to the database. The issue is magnified if this is attempted more than once on the same time slot (as each time this is tried, a new record is created in the APPOINTMENT table with IS_BLOCKED=Y. However, the change is not seen on the screen.

b. When an issue of duplicated appointments happens, you can run a delete statement from the back end to remove one of the duplicate rows. Here is the behavior observed if you delete duplicate rows manually from the database:
b1. If for example, the user tried to block an appointment slot AFTER the duplicated appointment MORE than once (issue described in b), then the issue will still exist for that time slot as there are duplicated rows in APPOINTMENT table.

b2. If for example, the user tried to block an appointment slot AFTER the duplicated appointment ONLY once, then the issue (described in b) will no longer occur once the duplicated appointment is deleted, since only one unique row will remain for the time slot.

c. Trying to block or unblock an appointment BEFORE the duplicated appointment will work fine with no issues