topic Re: Tool Calculate Field cannot use VB expression for service in Geoprocessing Questions

Tool Calculate Field cannot use VB expression for service

JustinGleeson1 — Mon, 12 Sep 2016 10:05:49 GMT

Hi,

I have a model working in ArcGIS 10.3 that uses a .py script to run through a series of routines. One of them is Calculate Field and I have use Python_9.3 in the code. However, when I try and publish the service on my server I get an error: "Tool Calculate Field cannot use VB expression for service"

This is the code in the .py script. Any ideas where the problem is? I don't have VB anywhere.

arcpy.CalculateField_management("PopSummary", "PcPop014", '(!Sum_Pop_014T11! / !Sum_Pop_T11! )*100', "PYTHON_9.3")

Thanks

Justin

Re: Tool Calculate Field cannot use VB expression for service

FC_Basson — Mon, 12 Sep 2016 10:33:10 GMT

Try wrapping your calculate expression in double quotes

Re: Tool Calculate Field cannot use VB expression for service

JustinGleeson1 — Mon, 12 Sep 2016 12:20:04 GMT

HI FC,

I tried that. The model itself ran on ArcGIS but once I tried to publish the service the same error came up.

Code with double quotes below. Perhaps this is not what you meant?

arcpy.CalculateField_management("PopSummary", "PcPop65p", "'(!Sum_Pop_65pT11! / !Sum_Pop_T11! )*100'", "PYTHON_9.3")

Thanks

Justin

Re: Tool Calculate Field cannot use VB expression for service

FC_Basson — Mon, 12 Sep 2016 12:21:50 GMT

Hi Justin, yes I meant replace the single quotes with double quotes.

Re: Tool Calculate Field cannot use VB expression for service

JustinGleeson1 — Mon, 12 Sep 2016 21:07:35 GMT

FC, that worked out well for me

Thanks