We're having an issue where it seems intermittent data is not being written to SQL Server from the MES module. Most of the records are present, but we're continually missing records here and there. The only corresponding thing I can see is that something is incrementing the identity field in SQL on the table that data is written to, so we have gaps in the identity values. We put SQL traces on the table and there doesn't appear to anything in SQL that is modifying it, and there is nothing in the SQL log. So I'm left with the idea that it is somehow attempting to write a record from the MES module, but is failing in some manner that causes the identity counter to be incremented without actually inserting a record. Has anyone seen a behavior similar to this, or know what the cause might be?
