I have a feature layer that i am trying to populate a field from another layer using a Dictionary/spatial join. I am getting "The field is not nullable" on line 38. Some feature are not within the polygonLayer = 'Soils", so i can see why it's not populating the Class_ID field but how do I by pass this "The field is not nullable" and keep going regardless if the point layer field is blank? # Import arcpy module import arcpy import sys import traceback # scratch spatial join feature sjpoints = "In_memory\SpJoin" # define the field list from the spatial join to transfer # you can add more field names such as: ["TARGET_FID", "Field", "AnoterField"] sourceFieldsList = ["TARGET_FID", "Class_ID"] # point feature that will be updated pointLayer = "Bld_Class" # polygon feature that will be used polygonLayer = "Soils" # define the field list to the original points updateFieldsList = ["OID@", "Class"] # Allow overwrite of join results arcpy.env.overwriteOutput = True #Run the Spatial Join tool, using the defaults for the join operation and join type arcpy.SpatialJoin_analysis(pointLayer, polygonLayer, sjpoints) # populate the dictionary from the polygon valueDict = {r[0]:(r[1:]) for r in arcpy.da.SearchCursor(sjpoints, sourceFieldsList)} with arcpy.da.UpdateCursor(pointLayer, updateFieldsList) as cursor: for Row in cursor: keyValue = Row[0] if keyValue in valueDict: print keyValue for n in range (1,len(sourceFieldsList)): Row = valueDict[keyValue][n-1] cursor.updateRow(Row) del valueDict arcpy.Delete_management("In_memory\SpJoin")

nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

The field is not nullable

Tonyalmeida

I have a feature layer that i am trying to populate a field from another layer using a Dictionary/spatial join. I am getting "The field is not nullable" on line 38. Some feature are not within the polygonLayer = 'Soils", so i can see why it's not populating the Class_ID field but how do I by pass this "The field is not nullable" and keep going regardless if the point layer field is blank?

# Import arcpy module&nbsp; 
import arcpy
import sys
import traceback
&nbsp; 
# scratch spatial join feature&nbsp; 
sjpoints = "In_memory\SpJoin"&nbsp; 
&nbsp; 
# define the field list from the spatial join to transfer&nbsp; 
# you can add more field names such as: ["TARGET_FID", "Field", "AnoterField"]&nbsp; 
sourceFieldsList = ["TARGET_FID", "Class_ID"]&nbsp; 
&nbsp; 
# point feature that will be updated&nbsp; 
pointLayer = "Bld_Class"&nbsp; 
&nbsp; 
# polygon feature that will be used&nbsp; 
polygonLayer = "Soils"&nbsp; 
&nbsp; 
# define the field list to the original points&nbsp; 
updateFieldsList = ["OID@", "Class"]&nbsp; 
&nbsp; 
# Allow overwrite of join results&nbsp; 
arcpy.env.overwriteOutput = True&nbsp; 

#Run the Spatial Join tool, using the defaults for the join operation and join type&nbsp; 
arcpy.SpatialJoin_analysis(pointLayer, polygonLayer, sjpoints)&nbsp; 
&nbsp; 
# populate the dictionary from the polygon&nbsp; 
valueDict = {r[0]:(r[1:]) for r in arcpy.da.SearchCursor(sjpoints, sourceFieldsList)}&nbsp; 

with arcpy.da.UpdateCursor(pointLayer, updateFieldsList) as cursor:&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 
&nbsp;&nbsp;&nbsp; for Row in cursor:&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; keyValue = Row[0]
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; if keyValue in valueDict:
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; print keyValue
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; for n in range (1,len(sourceFieldsList)):&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Row<N> = valueDict[keyValue][n-1]&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; cursor.updateRow(Row)

del valueDict 


arcpy.Delete_management("In_memory\SpJoin")<SPAN class="line-numbers-rows"><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN></SPAN></N>

Find more posts tagged with

Accepted answers

All comments

RandyBurton

The lines would be inserted in this section:

<SPAN class="keyword token">with</SPAN> arcpy<SPAN class="punctuation token">.</SPAN>da<SPAN class="punctuation token">.</SPAN>UpdateCursor<SPAN class="punctuation token">(</SPAN>pointLayer<SPAN class="punctuation token">,</SPAN> updateFieldsList<SPAN class="punctuation token">)</SPAN> <SPAN class="keyword token">as</SPAN> cursor<SPAN class="punctuation token">:</SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 
&nbsp;&nbsp;&nbsp; <SPAN class="keyword token">for</SPAN> Row <SPAN class="keyword token">in</SPAN> cursor<SPAN class="punctuation token">:</SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; keyValue <SPAN class="operator token">=</SPAN> Row<SPAN class="punctuation token">[</SPAN><SPAN class="number token">0</SPAN><SPAN class="punctuation token">]</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN class="keyword token">if</SPAN> keyValue <SPAN class="keyword token">in</SPAN> valueDict<SPAN class="punctuation token">:</SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN class="keyword token">for</SPAN> n <SPAN class="keyword token">in</SPAN> range <SPAN class="punctuation token">(</SPAN><SPAN class="number token">1</SPAN><SPAN class="punctuation token">,</SPAN>len<SPAN class="punctuation token">(</SPAN>sourceFieldsList<SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">:</SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN class="keyword token">if</SPAN> valueDict<SPAN class="punctuation token">[</SPAN>keyValue<SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">[</SPAN>n<SPAN class="number token">-1</SPAN><SPAN class="punctuation token">]</SPAN> <SPAN class="keyword token">is</SPAN> <SPAN class="operator token">not</SPAN> None<SPAN class="punctuation token">:</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Row<SPAN class="punctuation token">[</SPAN>n<SPAN class="punctuation token">]</SPAN> <SPAN class="operator token">=</SPAN> valueDict<SPAN class="punctuation token">[</SPAN>keyValue<SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">[</SPAN>n<SPAN class="number token">-1</SPAN><SPAN class="punctuation token">]</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN class="keyword token">else</SPAN><SPAN class="punctuation token">:</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Row<SPAN class="punctuation token">[</SPAN>n<SPAN class="punctuation token">]</SPAN> <SPAN class="operator token">=</SPAN> <SPAN class="string token">'n/a'</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; cursor<SPAN class="punctuation token">.</SPAN>updateRow<SPAN class="punctuation token">(</SPAN>Row<SPAN class="punctuation token">)</SPAN>‍‍‍‍<SPAN class="line-numbers-rows"><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN></SPAN>

But I'm not sure this will give you the results you want. Normally, the dictionary technique that Richard describes in his blog is used to avoid creating joins. And since you are doing a spatial join anyway, I would probably use the field calculator to copy the contents of the polygon's field that you want into the point's field. The join should only join points to polygons if the point is inside the polygon, so the calculation will only make the update where there is a match.

If you do want to use the dictionary, I suspect that your dictionary key needs to be the OID from the point feature and the value needs to be the Class_ID from the polygon feature. You may want to look at the field names that the join uses as it might be something like pointLayer.OID and polyLayer.Class_ID.

Hope this helps.

Tonyalmeida

Where exactly would in try this at? Sorry python is not my expertise's

JoeBorgione

That's not telling us much, since we don't know what you result you are printing. The idea of using print() to trouble shoot is to plug them in along the way to see what has succeeded before the failure.

RandyBurton

In your dictionary, the last 3 dictionary keys contain null values:

<SPAN class="punctuation token">{</SPAN><SPAN class="punctuation token">.</SPAN><SPAN class="punctuation token">.</SPAN><SPAN class="punctuation token">.</SPAN><SPAN class="punctuation token">.</SPAN>&nbsp; <SPAN class="number token">16</SPAN><SPAN class="punctuation token">:</SPAN> <SPAN class="punctuation token">(</SPAN>None<SPAN class="punctuation token">,</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="number token">17</SPAN><SPAN class="punctuation token">:</SPAN> <SPAN class="punctuation token">(</SPAN>None<SPAN class="punctuation token">,</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="number token">18</SPAN><SPAN class="punctuation token">:</SPAN> <SPAN class="punctuation token">(</SPAN>None<SPAN class="punctuation token">,</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">}</SPAN><SPAN class="line-numbers-rows"><SPAN>‍</SPAN></SPAN>

You can try something like this to test for null/None:

if valueDict[keyValue][n-1] is not None:
&nbsp;&nbsp;&nbsp; Row<N> = valueDict[keyValue][n-1]
else:
&nbsp;&nbsp; # use substitute value or pass<SPAN class="line-numbers-rows"><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN></SPAN></N>

Tonyalmeida

Yes i am doing a spatial join, yes the join is working I checked various times.

You are correct that i am trying to capture some attributes of the polygons features and save it as an attribute with all the points that fall inside the polygon. Not sure how to add a test in the update block that you mentioned.

Tonyalmeida

I have set my work space and changed sjpoints to

arcpy.Delete_management(sjpoints)<SPAN class="line-numbers-rows"><SPAN>‍</SPAN></SPAN>

I have added a print statement.

{0: (u'C_ID3889701100',), 1: (u'C_ID3890500000',), 2: (u'C_ID3890200000',), 3: (u'C_ID3890001000',), 4: (u'C_ID3889900000',), 5: (u'C_ID3889301100',), 6: (u'C_ID3889400000',), 7: (u'C_ID3889600000',), 8: (u'C_ID3889500000',), 9: (u'C_ID3889800000',), 10: (u'C_ID3889801000',), 11: (u'C_ID3889701000',), 12: (u'C_ID3888500000',), 13: (u'C_ID3888601000',), 14: (u'C_ID3825200000',), 15: (u'C_ID3825100000',),&nbsp; 16: (None,), 17: (None,), 18: (None,)}

Runtime error 
Traceback (most recent call last):
&nbsp; File "<string>", line 44, in <module>
RuntimeError: The field is not nullable. [Class_ID]<SPAN class="line-numbers-rows"><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN></SPAN>

RandyBurton

You reference Richard Fairhurst‌'s article which describes a process using a dictionary to avoid using a join. I notice in your code you are using a join before creating a dictionary:

<SPAN class="comment token">#Run the Spatial Join tool, using the defaults for the join operation and join type&nbsp; </SPAN>
arcpy<SPAN class="punctuation token">.</SPAN>SpatialJoin_analysis<SPAN class="punctuation token">(</SPAN>pointLayer<SPAN class="punctuation token">,</SPAN> polygonLayer<SPAN class="punctuation token">,</SPAN> sjpoints<SPAN class="punctuation token">)</SPAN>&nbsp; 
&nbsp; 
<SPAN class="comment token"># populate the dictionary from the polygon&nbsp; </SPAN>
valueDict <SPAN class="operator token">=</SPAN> <SPAN class="punctuation token">{</SPAN>r<SPAN class="punctuation token">[</SPAN><SPAN class="number token">0</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">:</SPAN><SPAN class="punctuation token">(</SPAN>r<SPAN class="punctuation token">[</SPAN><SPAN class="number token">1</SPAN><SPAN class="punctuation token">:</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">)</SPAN> <SPAN class="keyword token">for</SPAN> r <SPAN class="keyword token">in</SPAN> arcpy<SPAN class="punctuation token">.</SPAN>da<SPAN class="punctuation token">.</SPAN>SearchCursor<SPAN class="punctuation token">(</SPAN>sjpoints<SPAN class="punctuation token">,</SPAN> sourceFieldsList<SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">}</SPAN>‍‍‍‍‍‍<SPAN class="line-numbers-rows"><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN></SPAN>

First, can you verify the join works as expected. I'm not sure the TARGET_FID and OID@ are providing the link you need to make the dictionary technique work. I am making the assumption that you want to capture some attribute of the polygon feature and save it as an attribute with all the points that fall inside the polygon. Perhaps you can clarify if this is not the case.

As an additional test, you can print some or all of the valueDict to see if there are null/None values associated with the various dictionary keys. You could add a test in the update block, that if the dictionary key's value is None/null, then skip the update or substitute a default value. As written, the block is skipping any updates if the keyValue is not in the valueDict.

Hope this helps.

JoeBorgione

You may want to put some print statements in your code and see where it's failing. You mention 'blank': blank is not null. Blank is blank. I also notice the lack of setting a workspace although you set feature class variables as if you have; perhaps you have set the workspace in your working script? Line 7 has a little problem too:you should either escape that slash or use 'r' to do it for you:

<SPAN class="comment token"># yours:</SPAN>

sjpoints <SPAN class="operator token">=</SPAN> <SPAN class="string token">"In_memory\SpJoin"</SPAN> 

sjpoints <SPAN class="operator token">=</SPAN> <SPAN class="string token">"In_memory\\SpJoin"</SPAN> 
<SPAN class="comment token">#or</SPAN>
sjpoints <SPAN class="operator token">=</SPAN> r<SPAN class="string token">"In_memory\SpJoin"</SPAN> <SPAN class="line-numbers-rows"><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN></SPAN>

Tonyalmeida

I made some changes. Thanks for pointing that out. I grab the code from

Richard Fairhurst Turbo Charging Data Manipulation with Python Cursors and Dictionaries

with arcpy.da.UpdateCursor(pointLayer, updateFieldsList) as cursor:&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; for Row in cursor:&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; keyValue = Row[0]
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; if keyValue in valueDict:&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; for n in range (1,len(sourceFieldsList)):&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Row<N> = valueDict[keyValue][n-1]&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; cursor.updateRow(Row)

&nbsp;&nbsp;&nbsp; del valueDict <SPAN class="line-numbers-rows"><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN></SPAN></N>

Tonyalmeida

I did try, try and except.

IT looks like it once it gets to a records that is blank it doesn't continue. There is not error.

# Import arcpy module&nbsp; 
import arcpy
import sys
import traceback
&nbsp; 
# scratch spatial join feature&nbsp; 
sjpoints = "In_memory\SpJoin"&nbsp; 
&nbsp; 
# define the field list from the spatial join to transfer&nbsp; 
# you can add more field names such as: ["TARGET_FID", "Field", "AnoterField"]&nbsp; 
sourceFieldsList = ["TARGET_FID", "Class_ID"]&nbsp; 
&nbsp; 
# point feature that will be updated&nbsp; 
pointLayer = "Bld_Class"&nbsp; 
&nbsp; 
# polygon feature that will be used&nbsp; 
polygonLayer = "Soils"&nbsp; 
&nbsp; 
# define the field list to the original points&nbsp; 
updateFieldsList = ["OID@", "Class"]&nbsp; 
&nbsp; 
# Allow overwrite of join results&nbsp; 
arcpy.env.overwriteOutput = True&nbsp; 
&nbsp; 
#Run the Spatial Join tool, using the defaults for the join operation and join type&nbsp; 
arcpy.SpatialJoin_analysis(pointLayer, polygonLayer, sjpoints)&nbsp; 
&nbsp; 
# populate the dictionary from the polygon&nbsp; 
valueDict = {r[0]:(r[1:]) for r in arcpy.da.SearchCursor(sjpoints, sourceFieldsList)}&nbsp; 

try:
&nbsp;&nbsp;&nbsp; with arcpy.da.UpdateCursor(pointLayer, updateFieldsList) as updateRows:&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; for updateRow in updateRows:&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; keyValue = updateRow[0]
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; if keyValue in valueDict:&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; for n in range (1,len(sourceFieldsList)):&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; updateRow<N> = valueDict[keyValue][n-1]&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; updateRows.updateRow(updateRow)

&nbsp;&nbsp;&nbsp; del valueDict 
except Exception:
&nbsp;&nbsp;&nbsp; pass

arcpy.Delete_management("In_memory\SpJoin")<SPAN class="line-numbers-rows"><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN></SPAN></N>

DanPatterson_Retired

updateRows.updateRow(updateRow)<SPAN class="line-numbers-rows"><SPAN>‍</SPAN></SPAN>

careful... you have a method and an object with the same name, may not be the issue now

JoeBorgione

Take a look at the python try/except block. It will allow you to 'try' and do something, but in the event of an exception, let's you keep going. Here are few resources to check out:

Try and Except in Python

Python Try Except

8. Errors and Exceptions — Python 3.7.1 documentation

8. Errors and Exceptions — Python 2.7.15 documentation

Here is a simple example from a script I've run:

<SPAN class="keyword token">try</SPAN><SPAN class="punctuation token">:</SPAN>
&nbsp;&nbsp;&nbsp; arcpy<SPAN class="punctuation token">.</SPAN>MetadataImporter_conversion<SPAN class="punctuation token">(</SPAN>SourceFeatureClass<SPAN class="punctuation token">,</SPAN>TargetFeatureClass<SPAN class="punctuation token">)</SPAN>
&nbsp;&nbsp;&nbsp; <SPAN class="keyword token">print</SPAN> <SPAN class="string token">'Successfully Imported Metadata From {} To {}'</SPAN><SPAN class="punctuation token">.</SPAN>format<SPAN class="punctuation token">(</SPAN>SourceFeatureClass<SPAN class="punctuation token">,</SPAN>TargetFeatureClass<SPAN class="punctuation token">)</SPAN>
<SPAN class="keyword token">except</SPAN> Exception <SPAN class="keyword token">as</SPAN> err<SPAN class="punctuation token">:</SPAN>
&nbsp;&nbsp;&nbsp; <SPAN class="keyword token">print</SPAN> err<SPAN class="line-numbers-rows"><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN></SPAN>

Join the Conversation

Signed in members can post, follow updates, and more. New here? Register a free account.

Quick Links

Community Help
Find useful guides, FAQs, and documents to help you navigate and make the most of Esri Community.