AnsweredAssumed Answered

Avoiding errors when adding rows to blank table using ArcPy?

Question asked by south2012 on Apr 20, 2017
Latest reply on Apr 24, 2017 by south2012

I am having problems when using ArcPy with ArcGIS Desktop to add in a set number of rows into a .dbf table.

What should I do to prevent these errors?

Here is a sample code that gives me errors:

##########setup###########
import arcpy, os
from arcpy import env


##########parameters##########

ws = r'C:\Users\ddsouth\Documents\Python_tests'
env.workspace = ws

newFile = "adding_table_rows_test_5"
newFileFull = os.path.join(ws, newFile) + ".dbf"

###########code###############

#create the table
arcpy.CreateTable_management(ws, newFile)
arcpy.AddField_management(newFileFull, "RouteName", "TEXT", "", "", 15)
arcpy.AddField_management(newFileFull, "DepotName", "TEXT", "", "", 15)

#edit the table
cursor = arcpy.da.InsertCursor(newFile, ["ROUTENAME"])

for q in range (0,10):
cursor.insertRow((str(1),))
del cursor

print "Completed."

The creation of the table goes fine the first time, then when it comes to the edit portion I get the following error message:

Runtime error Traceback (most recent call last): 
File "<string>", line 26, in <module>SystemError: error return without exception set

Then if I run the program again, I get a different error, this time during the creation of the table, even if I have the "Overwrite the outputs of geoprocessing operations" option selected:

Runtime error  Traceback (most recent call last):  
File "<string>", line 18, in <module>  
File "c:\program files (x86)\arcgis\desktop10.4\arcpy\arcpy\management.py",
line
15715, in CreateTable    
raise e ExecuteError: ERROR 001143: Background server threw an exception.

I also noticed that while the tables I created appear in ArcCatalog, they do not appear in Windows Explorer, there is only a LOCK file while ArcMap is open.

What should be done? Thank you!

Outcomes