How to get database constraint violation error using EditOperation

BarbaraSchneider2 — Sun, 12 Dec 2021 08:55:13 GMT

I am writing a feature to an Oracle Enterprise Geodatabase using an edit operation:

var editOperation = new EditOperation();

// Assign shape and attributes
var attributes = new Dictionary<string, object>();
attributes.Add(shapeFieldName, shape);
attributes.Add("myField", row["myField"]);

// Create new feature                
editOperation.Create(featClass, attributes);
bool succeeded = editOperation.Execute();‍‍‍‍‍‍‍‍‍‍

When executing the editOperation fails, I have no information what went wrong, i.e. if I violated a unique key constraint. Is there a possibilty to get the error? Or is there a better way to write features to an Enterprise Geodatabase?

Thanks, Barbara

Re: How to get database constraint violation error using EditOperation

Anonymous User — Fri, 13 Mar 2020 16:40:02 GMT

Hi Barbara,

If the EditOperation fails, the property EditOperation.ErrorMessage may contain the cause if known.

Otherwise you can enable an Oracle TRACE in the database to get detailed information from that side.

topic How to get database constraint violation error using EditOperation in ArcGIS Pro SDK Questions

How to get database constraint violation error using EditOperation

Re: How to get database constraint violation error using EditOperation