AnsweredAssumed Answered

Duplicate OID between states

Question asked by clm42 on Dec 21, 2015
Latest reply on Dec 21, 2015 by clm42

I have a database I am trying to compress but when I do it throws an error that there is a duplicate primary key. The OID is given and when I select it in SSMS I only get one row and when I count rows returned it is only 1. If I search for it in ArcMap I get one row selected but the selection count is 2. Deleting  the row from ArcMap didn't help because the error is in an older state than the default which is what I edited and it still shows up in SSMS some how. There are 3500 states right now. Which is odd in itself because there were only 1558 on Friday and no one was working over the weekend. Is it database safe for me to kill that record from SSMS?

 

Capture.JPG

Outcomes