My workbench reads Ids from an SQL Server database using an SQL Creator. Records with these Ids are deleted via an SDE writer that connects to another database. I use an Attribute creator to add the fme_db_operation DELETE to the feature. I also synchronize INSERTS and UPDATES in a similar way with the same writer. I use the SDE writer because I want to utilize the ArcGIS Archiving functionality.
This process has always worked as intended until recently I have been getting the following error when doing deletes (inserts and updates still work):
Error while deleting feature in the table/feature class 'schema.table'. The error number from ArcObjects is: '-2147216104'. The error message from ArcObjects is: {Shape or row not found}
As far as I know the workbench has not changed at all. I have tried adding a new sde writer but to no effect.
I have confirmed that the Id I am trying to delete definitely exists, and the record is not archived (I can see it in ArcMap etc.) 'Id' is also set as the Update/Delete Key Field.
My suspicion is that the error code doesn't in fact reflect the problem, or i'm not understanding it properly. Does anyone have an idea how to fix this?
Thank you very much!
