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; } } }

arcpy.CalculateField_management Error

DanielJimenez2

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).

Encontre mais publicações marcadas com

Accepted answers

DanielJimenez2

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

All comments

DanielJimenez2

JoshuaChisholm

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.

IanMurray

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.

JoshuaChisholm

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")

DanielJimenez2

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

mvolz47

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?

DanielJimenez2

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.

mvolz47

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.

DanielJimenez2

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]

error_p.jpg

IanMurray

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.

JoshuaChisholm

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?

DanielJimenez2

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.

DanielJimenez2

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

mvolz47

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?

DanielJimenez2

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.

error.jpg

IanMurray

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.

JoshuaChisholm

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?

DanielJimenez2

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

IanMurray

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.

Participe da Conversa

Membros conectados podem postar, seguir atualizações e mais. Novo aqui? Registre uma conta gratuita.

Links Rápidos

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