Skip to main content
Solved

unique constraint error coming from an index


dbklingdom
Contributor
Forum|alt.badge.img+7

Hey, I'm getting a unique constraint error coming from an index

The error number from ArcObjects is: '-2147216072'. The error message from ArcObjects is: {Underlying DBMS error [ORA-00001: unique constraint (FACILITY.A17846_IX1) violated]}

Is there a switch in the writer I can set?? I have tried GRID 1 = Nothing and GRID 1 = 0 and both fail.

Thx Brian

Best answer by dbklingdom

OK got it. The Coordinate system for the Write most be set!!!

View original
Did this help you find an answer to your question?

4 replies

fmelizard
Contributor
Forum|alt.badge.img+17
  • Contributor
  • November 8, 2017
Hi @dbklingdom, are you writing to adding records to an existing table or performing an update?

 


dbklingdom
Contributor
Forum|alt.badge.img+7
  • Author
  • Contributor
  • November 8, 2017

performing an update


dbklingdom
Contributor
Forum|alt.badge.img+7
  • Author
  • Contributor
  • Best Answer
  • November 8, 2017

OK got it. The Coordinate system for the Write most be set!!!


david_r
Evangelist
  • November 9, 2017
dbklingdom wrote:

OK got it. The Coordinate system for the Write most be set!!!

Good to hear you found the culprit. For those stumbling upon this later, my recommendation would be to look up the definition of the constraint "FACILITY.A17846_IX1" in the Oracle database and see exactly what it concerns, without the defintion it's almost impossible to tell.

 

 

Applications like SQLDeveloper and TOAD are very useful for this. If you don't have the necessary access, ask your DBA, they should be able to help you out.

Reply


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings