Multi-User Related Record Simultaneous Locking Not Working
Operating system version
OSX 10.9.3 and Windows Server 2008 R2 64bit
Description of the issue
This is a recurring issue on high traffic systems when two different salespeople submit separate orders at the same second. Both orders have items that reference the same inventory record.
The orders will not see each other's updates or lock the inventory record correctly, resulting in one transaction writing over the other and causing an inventory discrepancy.
I have both video documentation and a test file that the issue can be reproduced in.
Steps to reproduce the problem
1 - Host file on server 13.
2 - Connect to file on client A
3 - Go to layout "Order - Data Entry"
4 - Click Records > New Record
5 - Fill in order date, line item name (Product1), quantity (2)
6 - Connect to file on client B
7 - Repeat steps 4-6. Enter a line with the same product, quantity (3)
8 - Submit both orders simultaneously. I programmed the submit button to delay until a certain second of every minute, to ensure that they run at the same time.
Whichever script tries to update the inventory record second should run into record-locking and return an error.
Inventory is either updated by one script or the other, but not both. Both transactions run without locking, but one overwrites the other.
Exact text of any error message(s) that appear
No error is returned.
No good work-arounds so far.