Hi

I have a process that is intermittently throwing the following error...


ISC ERROR CODE:335544382

ISC ERROR MESSAGE:
cannot update erased record


The code is processing in a small number of records, usually between 1
and 300. There is no deletion code in the process and as far as I can
tell there is no deletion code anywhere that deletes from the related
tables. The source data is filled from another application but the
loading of the 3 tables is done as part of a transaction so the data
shouldn't be picked up before it is completely loaded.

I have checked for triggers on the related tables but there are few and
I can't see any that are likely to be an issue (No cascading deletes,
only triggers loading timestamps, primary keys or inserting into logging
tables).

The error is happening in the wild with our users. I have received a
backup created before the failed processing was initiated and can
process it fine here. So it is not replicable.

Does anyone have any suggestions of where else to look?

p.s. My Logging is insufficient to track it to a specific line. That
will have to wait until our next release!

Cheers
Rob