topic InsertCursor throwing "error return without exception set" in Python Questions

InsertCursor throwing "error return without exception set"

JD_1609 — Wed, 20 Oct 2021 13:09:02 GMT

Hi,

I'm trying write data to an Enterprise geodatabase but it still throws error return without exception set (for clarification - error throws row cursor.insertRow(data).

I have method:

def __insertDataInternal(self, table, cols, data):
    with arcpy.da.InsertCursor(table, cols) as cursor:
        cursor.insertRow(data)

which I'm using for write to local gdb and remote (sde). For local gdb is everything alright and data are inserted. But when I use this method for write to Oracle it throws error.

Code for calling to write to EGDB looks this:

db = r"C:\Temp\file.sde"

edit = arcpy.da.Editor(db)
edit.startEditing(False, True)

edit.startOperation()

self.__insertDataInternal(table_path, cols, data)

edit.stopOperation()

edit.stopEditing(True)

I'm using versioned DB (Oracle) and the connection is set looking to version I need. All input data and cols are correct.

When I was googling so I found only solutions with errors from startOperation() or startEditing() but nowhere is error straight from insertRow().

Re: InsertCursor throwing "error return without exception set"

Anonymous User — Wed, 20 Oct 2021 14:27:24 GMT

It's saying there is an unhandled error occurring. Wrap the process in a try/ except block to capture it and see what it is.

try: edit = arcpy.da.Editor(db) edit.startEditing(False, True) edit.startOperation() self.__insertDataInternal(table_path, cols, data) edit.stopOperation() edit.stopEditing(True) except Exception as ex: print(f'Failed: {ex}')

Re: InsertCursor throwing "error return without exception set"

JD_1609 — Wed, 20 Oct 2021 15:02:28 GMT

yes, I have it in try/except block and from that is "error return without exception set"... 😕

Re: InsertCursor throwing "error return without exception set"

Anonymous User — Wed, 20 Oct 2021 15:36:22 GMT

Paste the full error message/code.

Re: InsertCursor throwing "error return without exception set"

JD_1609 — Wed, 20 Oct 2021 16:21:27 GMT

That's the **bleep**... This - "error return without exception set" - is full message what I get... NOTHING else 😄

Re: InsertCursor throwing "error return without exception set"

Anonymous User — Wed, 20 Oct 2021 17:53:21 GMT

Is the length of your fields in your 'data' longer than the length allowed in any of the fields?

add a print statement to your insert cursor and watch what values are being inserted and if it fails on one.