topic Re: Error using insert cursor (da) with featureclass in a geometric network in Python Questions

Error using insert cursor (da) with featureclass in a geometric network

CallumSmith — Tue, 13 Oct 2015 19:46:36 GMT

I am got an issue where I am trying to insert features into a feature class that participates in a geometric network.

Firstly I guess the question is "Is this even possible?"

When I try to insert a record into the featureclass I am getting this error: SystemError('error return without exception set',)

If I remove the geometric network or use the code on another feature class that does not participate in a geometric network it works fine. I cannot however remove the geometric network from the production database.

If anybody has any ideas on this issue that would be appreciated.

cheers

Callum

Re: Error using insert cursor (da) with featureclass in a geometric network

DanPatterson_Retired — Tue, 13 Oct 2015 19:50:44 GMT

From here...

This statement

The following includes some dataset types that can only be edited within an edit session:

Feature classes participating in a topology
Feature classes participating in a geometric network
Versioned datasets in enterprise geodatabases
Some object and feature classes with class extensions

But I have not clue if it applies to your situation.

Re: Error using insert cursor (da) with featureclass in a geometric network

ModyBuchbinder — Wed, 14 Oct 2015 04:51:48 GMT

I did not tried it but you can start edit in ArcMap and run your script in the python window.

Maybe it will work...

Have Fun

Re: Error using insert cursor (da) with featureclass in a geometric network

NeilAyres — Wed, 14 Oct 2015 06:57:05 GMT

Recently completed a tool to update / insert into a Network Dataset. I can confirm that you need a edit session open.

Re: Error using insert cursor (da) with featureclass in a geometric network

DanPatterson_Retired — Wed, 14 Oct 2015 10:23:30 GMT

Good to know...I wish you could make notes in the margins of the online help

Re: Error using insert cursor (da) with featureclass in a geometric network

CallumSmith — Wed, 14 Oct 2015 20:41:35 GMT

Thanks Neil

I do have an edit session open as the featureclass is also in a versioned enterprise geodatabase.

In my testing I have copied the data to a file gdb and it still does not work. If I remove the geometric network the it does work???

cheers

Callum

Re: Error using insert cursor (da) with featureclass in a geometric network

CallumSmith — Wed, 14 Oct 2015 20:47:40 GMT

Yes I have tried running the script from a tool within arcmap and it still gives me the same issue.

cheers

Callum

Re: Error using insert cursor (da) with featureclass in a geometric network

CallumSmith — Wed, 14 Oct 2015 20:49:13 GMT

Thanks Dan

Yes I do have an edit session open as the featureclass participates in a geometric network and is also versioned.

Not sure why it is failing as the error message is not very helpful!!

cheers

Callum

Re: Error using insert cursor (da) with featureclass in a geometric network

JohnPlunkett — Thu, 15 Oct 2015 02:31:13 GMT

As Callum pointed out to me in a separate email it looks like its a bug.

Bug NIM-102778

Synopsis

The insertRow method of arcpy.da.InsertCursor fails when working with data in a geometric network.

Additional Information

N/A

Alternate Solution

The Append tool works fine for features participating in a geometric network.

1. Fill an empty feature class outside the geometric network with records using an insert cursor.
2. Use the Append tool to add the records to the feature class in the geometric network.

http://support.esri.com/en/bugs/nimbus/TklNMTAyNzc4