topic Re: error return without exception set in Python Questions

error return without exception set

TonyAlmeida — Mon, 14 Apr 2014 17:35:25 GMT

I have the following code.
The code works great on a shapefile but as soon as i change the workspace to a SDE sqlexpress datatbase i get the following error.

Traceback (most recent call last):
  File "C:\GIS\Python Scripts\AddressPoints\Point_2_Ca.py", line 125, in <module>
    edit.stopOperation()
SystemError: error return without exception set

The error is not specific on where the problem is, I've searched but i am unable to find the problem. where is the problem and how can i fix it to run with out errors?
As i mentioned before the code runs great against a shapefile and running against a shapefile takes about 4-6 seconds.
When i switch it to a SDE sqlexpress datatbase it takes 4 minutes then runs into the error. There is only 48 features in the SDE sqlexpress datatbase so the database is not very big. Why is this?

import arcpy
from arcpy import env
import time
import datetime
import pythonaddins
import os

fc = "TonyTwoWay.DBO.TT"
workspace = r"Database Servers\DSD15_SQLEXPRESS.gds\TonyTwoWay (VERSION:dbo.DEFAULT)"
arcpy.env.overwriteOutput = True
arcpy.env.qualifiedFieldNames = False

# Start an edit session. Must provide the worksapce.
edit = arcpy.da.Editor(workspace)

# Edit session is started without an undo/redo stack for versioned data
#  (for second argument, use False for unversioned data)
edit.startEditing(True)

# Start an edit operation
edit.startOperation()

input = arcpy.GetParameterAsText(0)

rows = arcpy.SearchCursor(input)
for row in rows:
    geom = row.Shape
    X = geom.centroid.X
    Y = geom.centroid.Y
del rows, row
   
row_values = (X, Y, (X, Y))
cursor = arcpy.da.InsertCursor(fc, ["X_Coord", "Y_Coord", "SHAPE@XY"])
cursor.insertRow(row_values)
del cursor

####Select by location on parcels with created point
Parcellyr = "Taxparcels"

arcpy.MakeFeatureLayer_management(Parcellyr, "in_memory\Parcel layer")
entries = int(arcpy.GetCount_management(fc).getOutput(0))

for i in xrange(entries):
    arcpy.MakeFeatureLayer_management(fc, "in_memory\point layer", "\"OBJECTID\"={}".format(str(i) + ""))
    arcpy.SelectLayerByLocation_management("in_memory\Parcel layer", "INTERSECT", "in_memory\point layer", "", "NEW_SELECTION")
    #if arcpy.Exists(pt_lyr): arcpy.Delete_management(pt_lyr) 

arcpy.CopyFeatures_management("in_memory\Parcel layer", "in_memory\Sel_Par")
table = "Vector.DBO.PARCELADMIN"
try:
    arcpy.AddJoin_management("in_memory\Sel_Par", "ACCOUNT", table, "Acct", "KEEP_COMMON")
except BaseException as e:
    pass

arcpy.CopyFeatures_management("in_memory\Sel_Par","in_memory\ParLYR")
arcpy.MakeFeatureLayer_management("in_memory\ParLYR", "in_memory\Par")


#### populates fields

add_fields = ["ACCOUNT","SiteNum","OwnerName","SiteAddres","SiteNumSfx","SiteStreet","Predir","StreetType","Postdir", "SubName", "SiteCity", "SiteZip", "SubName"]

# fix args
if not isinstance(add_fields, list):
    # from script tool
    add_fields = add_fields.split(';')

# do not need this scratch file
fcOutput = r'C:\Temp\Default.gdb\temp_join' #'temp_join' when using workspace = r"C:\Temp\default.gdb"
arcpy.SpatialJoin_analysis("in_memory\Par", "in_memory\point layer", fcOutput, 'JOIN_ONE_TO_MANY', 'KEEP_COMMON')

# grab oid field from points
oid_t = arcpy.Describe(fc).OIDFieldName

Field4 = "SubNum" #Field from spaital Join
Field4a = "SiteSubNum"
#Field5 = "City" #Field from spaital Join
#Field5a = "BusinsName"

# init rowW and rowR
curR = arcpy.SearchCursor(fcOutput)
join_dict = dict([(r.JOIN_FID,[r.getValue(f) for f in add_fields]) for r in curR])
del curR

Fields = ["SubNum","City",]

rows = arcpy.da.SearchCursor(fcOutput, Fields)
for row in rows:
    Num1 = rows[0]
    #Num2 = rows[1]
    
# Now update the new target
curW = arcpy.UpdateCursor(fc)
for row in curW:
    t_oid = row.getValue(oid_t)
    if t_oid in join_dict:
        for f in add_fields:
            row.setValue(f, join_dict[t_oid][add_fields.index(f)])
            row.setValue('GIS_STEW', "Canyon Co")
            row.setValue('IssuedBy', "TA")
            row.setValue('Status', "Active")
            row.setValue('StartDate', datetime.datetime.now().strftime('%m/%d/%Y'))
            row.setValue('SiteState', "ID")
            row.setValue('SiteCounty', "Canyon")
            row.setValue('StreetName', row.SiteStreet + " " + row.StreetType)
            row.setValue('Verified', "Yes,TA")
            row.setValue(Field4a, Num1)
            #row.setValue(Field5a, Num2)
        #else:
            #row.StreetName = curR.SiteStreet
    curW.updateRow(row)
del row, curW, rows


#arcpy.SelectLayerByAttribute_management(Parcellyr, "CLEAR_SELECTION")
arcpy.Delete_management("in_memory\Parcel layer")
arcpy.Delete_management("in_memory\point layer")
arcpy.Delete_management("in_memory\Sel_Par")
arcpy.Delete_management("in_memory\ParLYR")
arcpy.Delete_management("in_memory\Par")
#arcpy.Delete_management(r'in_memory\temp_join')

# Stop the edit operation.
edit.stopOperation()

# Stop the edit session and save the changes
edit.stopEditing(True)

Re: error return without exception set

WilliamCraft — Tue, 15 Apr 2014 00:22:13 GMT

You may be seeing this error because the dataset is not registered as versioned within the SQL Server geodatabase. Can you try ONE of the following?

1. Change the edit.startEditing(True) line to edit.startEditing(True,False)

or

2. Register the data you are trying to edit as versioned (either manually from ArcGIS Desktop or via Python before opening the edit session)

The syntax for the startEditing tool is startEditing ({with_undo}, {multiuser_mode}), which is explained here. I think the issue is that you aren't specifying the right boolean for the multiuser mode. "When False, you have full control of editing a nonversioned, or versioned dataset. If your data is nonversioned and you use stopEditing(False), your edit will not be committed (otherwise, if set to True, your edits will be committed). The default value is True."

Re: error return without exception set

TonyAlmeida — Tue, 15 Apr 2014 13:17:49 GMT

crafty762 thanks for the reply.

The data is registered as versioned. That was one of the things i saw come up when i searched for the error.

I changed the edit.startEditing(True) line to edit.startEditing(True,False) and got pasted the error.
Code seems to run fine, but i get this error now.

Traceback (most recent call last):
File "C:\GIS\Python Scripts\AddressPoints\Create_Point_2_Ca.py", line 34, in <module>
cursor.insertRow(row_values)
RuntimeError: workspace already in transaction mode

Re: error return without exception set

TonyAlmeida — Sun, 12 Dec 2021 03:15:30 GMT

The error"RuntimeError: workspace already in transaction mode" happens when i have my data as versioned and set the line to edit.startEditing(True,False).

I have unversioned the data and change the edit.startEditing(True) line to edit.startEditing(True,False). I get the same error.

    edit.stopOperation()
SystemError: error return without exception set

i have registered as versioned and changed the line back to edit.startEditing(True) now i get this error,

edit.stopOperation()
SystemError: error return without exception set

So no matter which way i change the code i get the same error. Anyone have any other ideas what's going on and how can i fix this?

Re: error return without exception set

BryanPrice3 — Sun, 12 Dec 2021 03:15:33 GMT

The error"RuntimeError: workspace already in transaction mode" happens when i have my data as versioned and set the line to edit.startEditing(True,False).

I have unversioned the data and change the edit.startEditing(True) line to edit.startEditing(True,False). I get the same error.
    edit.stopOperation()
SystemError: error return without exception set
i have registered as versioned and changed the line back to edit.startEditing(True) now i get this error,
edit.stopOperation()
SystemError: error return without exception set
So no matter which way i change the code i get the same error. Anyone have any other ideas what's going on and how can i fix this?

Did you ever get an answer to this? We are having a similar issue. It doesn't always fail either. On some environments it fails with this error sometimes, and on others it never fails.

Re: error return without exception set

TonyAlmeida — Thu, 17 Jul 2014 16:32:10 GMT

I have not, i am still messing around with it.

Re: error return without exception set

AllenCousins — Tue, 16 Sep 2014 21:52:26 GMT

I'm also experiencing the same problem. Did anyone ever get an answer to this?

Re: error return without exception set

MathiasKP — Sun, 19 Oct 2014 15:22:27 GMT

With versioned SDE data in an Oracle database I use:

edit.startEditing(False, True)

with unversioned SDE data in an Oracle database I use

edit.startEditing(False, False)

these settings work for me

Re: error return without exception set

LangDeng — Fri, 06 Mar 2015 05:23:05 GMT

I had the same issue:

edit.stopOperation()
SystemError: error return without exception set

My problem and solution: I forgot edit.startOperation()!

Workspace already in transaction mode: my problem and solution:

Check to make sure the field that need to be updated, surely exist. Add an If to check the filed, then

the problem is gone,

lang

Re: error return without exception set

JulianInskip — Sun, 26 Jul 2015 05:53:21 GMT

I am also having an issue with this, but for me it is when I run my script as a GP Service (no problems when running it in ArcMap). My error comes when I edit.startEditing(False, True) - and yes, my data is versioned (in a feature dataset if that makes a difference).

I am not 100% sure, but it might be something to do with the numpy version. I have not tried this yet so I am not sure if upgrading to a more recent version of numpy will either break my ArcMap, python or if it will actually make a difference with this error. I will try and test this on a VM first and will post back here.

Might also be a thing between running the script using python 32bit and python 64bit.

"SystemError: error return without exception set" when indexing with -1 · Issue #4285 · scipy/scipy · GitHub

Re: error return without exception set

ShannonPorter — Thu, 17 Sep 2015 20:42:37 GMT

Is the user already in an edit session in Arcmap before your script starts editing? If so then I would check with tech support and look into

[BUG-000089820: The Editor class from ArcPy returns an error message when the 'stopEditing()' command is executed when an existing edit session is open on the same workspace. "RuntimeError: Start edit session."]

I had a situation where the user is already in an edit session so I didn't think I had to start editing in python script but the tech support person had me start editing. However when I went to stopEditing it failed with the error you received and they pointed out the bug. In my case I just removed the stopediting from my script and it seems to be functioning.

Re: error return without exception set

CallumSmith2 — Wed, 23 Aug 2017 20:28:57 GMT

Hi Just a note on this that may help others. I had this error exactly as explained in the original post writing to a SDE featureclass and it turned out the issue was a length of a field. I had a text field length 10 and was trying to write some text to it that was longer than 10. The cursor ran through without a problem but when I tried to commit the edits with editor.StopOperation I got the error "SystemError: error return without exception set". To resolve the issue all I had to do was make the text field larger.

cheers

Callum

Re: error return without exception set

South_JordanCity_of — Thu, 24 Aug 2017 14:48:51 GMT

Callum,

you nailed it! After truncating some values to the max field length, the edit operation was successful.

Cheers!

Marc

Re: error return without exception set

deleted-user-st4HsVxccxgs — Wed, 10 Jan 2018 21:32:11 GMT

Callum,

This was also the problem for me. One sneaky field in the midst of dozens that was just a little short in field length. Very difficult to diagnose without trying to edit values in each field.

Thanks!

Re: error return without exception set

ChaimSchwartz3 — Mon, 26 Feb 2018 16:03:36 GMT

Helped me too, thanks!

Re: error return without exception set

CarlosRibeiro — Sun, 01 Jul 2018 00:07:25 GMT

For me it happend when I ran my script for populating a turntable which made part of a network dataset, by copying the features from another feature class not belonging to the netowrk. After some tests, I finally found out the cause of getting the useless message SystemError: error return without exception set: eventhough I had added the turntable to the network before it being populated, I didn't rebuilt it .

So, I ran Build Network GP and the script worked like a charm!

Re: error return without exception set

CynthiaRoush2 — Fri, 15 Oct 2021 22:40:08 GMT

Thank you so much, Callum! I was getting this error ("SystemError: error return without exception set") while simply calculating centroid coordinates using CalculateGeometry (through arcpy). Your entry here helped me realize I needed to change the field type from FLOAT to DOUBLE.

Re: error return without exception set

RogerDunnGIS — Fri, 18 Aug 2023 18:55:04 GMT

I am working with arcpy in Python 3.7.11 and ArcGIS Pro 2.9.5. I was getting this error: "SystemError: <method 'stopOperation' of 'Workspace Editor' objects> returned NULL without setting an error" The problem was that I was putting a string value into a text field which was too long. The field was 15 characters, but the value was 19 characters. Since the error message doesn't mention anything about that, I only found the problem when I decided to print the values of the row! I hope this helps someone else.