Just a few hours ago, we started getting an error that is "impossible" as far as I can tell. Error is
Violation of PRIMARY KEY constraint 'PK_RntlApp'. Cannot insert duplicate key in object 'Rental_Application'.
The reason I think this is impossible is that the primary key of the Rental_Application table is called "File_ID" and it is an autonumber integer. The code that is causing this has been working for literally 12 years straight.
This has to be related -- we used to replicate this database. The 2 databases both would reserve a range of identity values that they could insert so that data could be inserted in both databases, and merged together without incident.
We broke this replication a couple of months ago. All has been working fine until just recently.
Any help or pointers would be greatly appreciated.