Skip to main content
Solved

unique constraint error coming from an index

  • November 8, 2017
  • 4 replies
  • 135 views
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!!!

This post is closed to further activity.
It may be an old question, an answered question, an implemented idea, or a notification-only post.
Please check post dates before relying on any information in a question or answer.
For follow-up or related questions, please post a new question or idea.
If there is a genuine update to be made, please contact us and request that the post is reopened.

4 replies

fmelizard
Safer
Forum|alt.badge.img+21
  • fmelizardSafer
  • Safer
  • 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
  • dbklingdomContributor
  • Author
  • Contributor
  • November 8, 2017

performing an update

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

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

david_r
Celebrity
  • david_rCelebrity
  • November 9, 2017

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.

Community Stats

32,154
Posts
122,048
Replies
39,812
Members

Latest FME

Terms & ConditionsCookie settingsAccessibility statement
A product of
Safe Software respectfully acknowledges that we live, learn and work on the traditional and unceded territories of the Kwantlen, Katzie, and Semiahmoo First Nations.