Error in copying table from Enterprise GDB

1807
3
02-14-2016 11:00 PM
Highlighted
Occasional Contributor II

I have a table registered with an enterprise GDB, and I can open it and explore its records, when I copy this table to a file GDB, it starts copying but an error that says "a row with this OID already exists"

What might be the issue here?

Clip_1495.jpg

Thank you in advance,

Hani

Reply
0 Kudos
3 Replies
Highlighted
Esri Esteemed Contributor

It appears that a a duplicate row is the issue.  How is the TAX_FLAT_OWNERS_VIEW view structured?  Does it violate the rowid uniqueness constraint?

Reply
0 Kudos
Highlighted
Occasional Contributor II

No, it was registered with the Geodatabase, and this should insure non-duplicates

Reply
0 Kudos
Highlighted
Esri Esteemed Contributor

And yet the error asserts otherwise.  View registration is a point-in-time validation process.  There's no way to be sure the view wasn't updated or the data in the viewed table wasn't changed to violate rowid integrity.