AnsweredAssumed Answered

Repeated instances of duplicated auto-enter serial values

Question asked by RyanM. on Apr 28, 2015
Latest reply on Jan 12, 2016 by jdxxs

Summary

Repeated instances of duplicated auto-enter serial values

Product

FileMaker Server

Version

13.0.5.520

Operating system version

OSX 10.9.5

Description of the issue

Since we upgraded form FMS 11 to FMS 13 in January, we've seen a sharp increase of duplicated auto-enter serial values. Two concurrent users create a record in the same table simultaneously, and both records are assigned the same serial value. We don't want to set the field to require unique values because we don't want users to have to handle that error when it occurs, and we don't want to interrupt the complicated scripts surrounding creation of records in these tables. There is another serial field on this same table, also not requiring unique values, that never has this issue.

Steps to reproduce the problem

Two records are created simultaneously in a table with auto-enter serial values for a field.

Expected result

Two records created in this table concurrently will have different values for this field.

Actual result

Two records end up with the same value.

Workaround

One of the records must be created again, and one of the duplicates must be deleted.

Outcomes