topic Re: arcpy.CalculateField_management Error in Python Questions

arcpy.CalculateField_management Error

DanielJimenez2 — Mon, 14 Apr 2014 15:16:38 GMT

I'm using the arcpy lib in arcgis 10.1 and to work on a script. When i use the arcpy.CalculateField_management i'm getting an error . Could someone help me identify whats wrong with the expression below. I'm using VB because when i use the python calculator, python crashes at the end of the calculation so VB is the only option i have. Notice that this expression work good when using python but like i mentioned, when the python option is used. python crashes at the end of the script.

arcpy.CalculateField_management("TAZ_un_Buffer_Dissolve.shp", "totalArea","[shape.area]", "VB", "")

Traceback (most recent call last):   File "D:\CubeAlbuquerque\AlbuquerqueNewTAZ\02_Applications\02_Transit_walk_Acc ess\ptaccess_SM.py", line 55, in <module>     arcpy.CalculateField_management("TAZ_un_Buffer_Dissolve.shp", "totalArea","[ shape.area]", "VB", "")   File "C:\Program Files (x86)\ArcGIS\Desktop10.1\arcpy\arcpy\management.py", li ne 3128, in CalculateField     raise e arcgisscripting.ExecuteError: ERROR 999999: Error executing function. Failed to execute (CalculateField).

Re: arcpy.CalculateField_management Error

IanMurray — Mon, 14 Apr 2014 15:33:03 GMT

I couldn't get it working with VB, but here is a valid python expression

arcpy.CalculateField_management("TAZ_un_Buffer_Dissolve.shp", "totalArea" , "!shape.area!", "PYTHON")

I tested it on an existing file I had, and it calculated the same area that already existed for that shapefile.

Re: arcpy.CalculateField_management Error

DanielJimenez2 — Mon, 14 Apr 2014 15:34:53 GMT

I couldn't get it working with VB, but here is a valid python expression

arcpy.CalculateField_management("us_eco_l4_no_st selection", "Test" , "!shape.area!", "PYTHON")

When i use the python option, python crashes at the end of the script. I dont know why but i can only use VB expressions

Re: arcpy.CalculateField_management Error

JoshuaChisholm — Mon, 14 Apr 2014 15:39:27 GMT

Hello Daniel,

I don't think you can calculate area with VB. It might be better to use Python and try to figure out why it's crashing (what error are you getting?).

I would use something like:

arcpy.CalculateField_management("TAZ_un_Buffer_Dissolve.shp","TotalArea","!Shape.area!","PYTHON","#")

Also, one quick question, the field "TotalArea" exists before you calculate field right?

Re: arcpy.CalculateField_management Error

IanMurray — Mon, 14 Apr 2014 15:42:19 GMT

Hello Daniel,

I don't think you can calculate area with VB. It might be better to use Python and try to figure out why it's crashing (what error are you getting?).

I would use something like:
arcpy.CalculateField_management("TAZ_un_Buffer_Dissolve.shp","TotalArea","!Shape.area!","PYTHON","#")
Also, one quick question, the field "TotalArea" exists before you calculate field right?

I was thinking the same thing, I'd rather know why my code is not working then try to find a run around for it. Also, make sure the field names match up, it is case sensitive.

Re: arcpy.CalculateField_management Error

DanielJimenez2 — Mon, 14 Apr 2014 15:46:45 GMT

I was thinking the same thing, I'd rather know why my code is not working then try to find a run around for it. Also, make sure the field names match up, it is case sensitive.

This is what happens when i use the python expression.[ATTACH=CONFIG]33074[/ATTACH]

The script works fine but when it finish, it gives me the error in the pic. I dont know how to debug when python crashes, i just know that when i use the VB expression, i dont get this problem.

Re: arcpy.CalculateField_management Error

MichaelVolz — Mon, 14 Apr 2014 15:52:28 GMT

What is your datasource (e.g. sde feature class, file gdb feature class, personal gdb feature class, shapefile)?

What is your version of ArcGIS Desktop?

What is your operating system?

Re: arcpy.CalculateField_management Error

DanielJimenez2 — Mon, 14 Apr 2014 15:54:47 GMT

What is your datasource (e.g. sde feature class, file gdb feature class, personal gdb feature class, shapefile)?

What is your version of ArcGIS Desktop?

What is your operating system?

The data source is just a shapefile. I'm using Arcgis 10.1(build 3035) basic license in a windows 8 machine.

I'm using this link as reference, if it is of any help

http://resources.arcgis.com/en/help/main/10.1/index.html#//00170000004m000000

Re: arcpy.CalculateField_management Error

DanielJimenez2 — Mon, 14 Apr 2014 15:58:49 GMT

I was thinking the same thing, I'd rather know why my code is not working then try to find a run around for it. Also, make sure the field names match up, it is case sensitive.

Yes, like i said when i used the caluclate filed python expression the script works, but it crashes when it finish working. I can open the shapefile and see all the fields and their values. Now i dont know why python crashes when i do this and i dont know how to debug something like this.

Re: arcpy.CalculateField_management Error

JoshuaChisholm — Mon, 14 Apr 2014 16:03:48 GMT

Hello Daniel,

Very tricky indeed. I couldn't see much from your screenshot (the resolution was too low), but I see how that is a hard problem to solve. If you comment out the arcpy.CalculateField_management line, does it run successfully without crashing at the end?

Re: arcpy.CalculateField_management Error

IanMurray — Mon, 14 Apr 2014 16:07:39 GMT

Yes, like i said when i used the caluclate filed python expression the script works, but it crashes when it finish working. I can open the shapefile and see all the fields and their values. Now i dont know why python crashes when i do this and i dont know how to debug something like this.

Yea, that's significantly uglier than I was expected, I didn't realize when you said "crash" you meant crash like that. Reminds me of the time I had a script that would just stop in different places, it would process between 30-40 files (out of like 600) and then just stop, no error codes, no nothing, just would stop, and in a different place each time. First time 25 files, next 40, next 32. Finally got a computer with a better processer and more memory and it managed to do all of the files in one go.

Re: arcpy.CalculateField_management Error

DanielJimenez2 — Mon, 14 Apr 2014 16:15:55 GMT

Hello Daniel,

Very tricky indeed. I couldn't see much from your screenshot (the resolution was too low), but I see how that is a hard problem to solve. If you comment out the arcpy.CalculateField_management line, does it run successfully without crashing at the end?

No, line 65 will also present a problem, but it also is related to the same topic. Im attaching a better pic just in case.

[ATTACH=CONFIG]33075[/ATTACH]

Re: arcpy.CalculateField_management Error

MichaelVolz — Mon, 14 Apr 2014 16:18:17 GMT

Can you check to see if Background Geoprocessing is enabled (default value)? If Background Geoprocessing is enabled, can you disable it and run your script with Python again.

Re: arcpy.CalculateField_management Error

DanielJimenez2 — Mon, 14 Apr 2014 16:20:30 GMT

Can you check to see if Background Geoprocessing is enabled (default value)? If Background Geoprocessing is enabled, can you disable it and run your script with Python again.

It was enabled. I disable it but im getting the same issue.

Re: arcpy.CalculateField_management Error

MichaelVolz — Mon, 14 Apr 2014 16:31:17 GMT

Can you make a backup of your shapefile and then delete almost all records leaving just 2 or 3 and then run the script on that shapefile to see if it runs correctly with python?

Re: arcpy.CalculateField_management Error

DanielJimenez2 — Mon, 14 Apr 2014 16:38:41 GMT

Can you make a backup of your shapefile and then delete almost all records leaving just 2 or 3 and then run the script on that shapefile to see if it runs correctly with python?

Same problem. For some reason i dont know why, the version of python that i have is not good. Seems like everyone can calculate fields using a python expression, but i cant and i dont know how to fix it

Re: arcpy.CalculateField_management Error

JoshuaChisholm — Mon, 14 Apr 2014 16:56:50 GMT

So just to confirm,

Will the script will work if you take out all the arcpy.CalculateField_management lines?

Will the script will work if you use VB on all the arcpy.CalculateField_management lines? (even if you are just filling the field with 1's)

Also, can you try getting rid of the "#" at the end of the arcpy.CalculateField_management lines?
In other words, change this:

arcpy.CalculateField_management("TAZ_un_Buffer_Dissolve.shp","TotalArea","!Shape.area!","PYTHON","#")

To this:

arcpy.CalculateField_management("TAZ_un_Buffer_Dissolve.shp","TotalArea","!Shape.area!","PYTHON")

Re: arcpy.CalculateField_management Error

IanMurray — Mon, 14 Apr 2014 17:03:35 GMT

So just to confirm,

arcpy.CalculateField_management("TAZ_un_Buffer_Dissolve.shp","TotalArea","!Shape.area!","PYTHON","#")

To this:

arcpy.CalculateField_management("TAZ_un_Buffer_Dissolve.shp","TotalArea","!Shape.area!","PYTHON")

I had him do that in the code I wrote him, so I don't think that's the issue.

Re: arcpy.CalculateField_management Error

JoshuaChisholm — Mon, 14 Apr 2014 17:16:18 GMT

Maybe try setting "field_precision" and "field_scale" in the arcpy.AddField_management lines?
Something like:

arcpy.AddField_management("TAZ_un_Buffer_Dissolve.shp", "TotalArea", "DOUBLE", 10, 10)

I think some of the other parameters are for geodatabases only.

Re: arcpy.CalculateField_management Error

DanielJimenez2 — Tue, 22 Apr 2014 20:58:47 GMT

Thanks for all the help but I think I fixed the problem. The computer had two versions of python 27 installed and seems that that is the reason behind python crashing when using the CalcFiled method. I removed the version Arcgis does not use and it is not crashing anymore so its working normal now. Thanks for the help