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