AnsweredAssumed Answered

Multi-User Related Record Simultaneous Locking Not Working

Question asked by emory_brown on Jun 19, 2014
Latest reply on Jul 7, 2014 by disabled_ntaylor

Summary

Multi-User Related Record Simultaneous Locking Not Working

Product

FileMaker Pro

Version

13.0v3

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.

Expected result

Whichever script tries to update the inventory record second should run into record-locking and return an error.

Actual result

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.

Workaround

No good work-arounds so far.

Outcomes