topic cannot use VB expressions for services in Geoprocessing Questions

cannot use VB expressions for services

KevinGooss — Tue, 06 Nov 2012 17:57:54 GMT

10.1 geoprocessing tool.
I'm getting an error during the analysis phase in ArcCatalog while trying to publish my gp service. It says I can't use VB expressions in the Calculate Field Tool. The severity is High but i am still able to publish.
Here is the only line in my py script that uses the CalculateField tool:

arcpy.CalculateField_management("in_memory/buffer", "GP_ID", "x", "PYTHON", "x = '" + uniqueid + "'")

Am i missing something? Because I don't think there is any VB in there.

Re: cannot use VB expressions for services

AnthonyGiles — Tue, 06 Nov 2012 18:08:27 GMT

Kevin,

Using Server 9.3.1 you have to change the Expression Type parameter to 'PYTHON_9.3'. For the calculate field to work.

http://support.esri.com/en/knowledgebase/techarticles/detail/36571

Not sure if this is still the case with 10.1, but worth looking at

Regards

Anthony

Re: cannot use VB expressions for services

KevinGooss — Tue, 06 Nov 2012 18:19:52 GMT

no dice. but thank you for the suggestion.

Re: cannot use VB expressions for services

KevinHibma — Tue, 06 Nov 2012 18:25:49 GMT

Its not an error, just a high-warning.
Check the help here:
http://resources.arcgis.com/en/help/main/10.1/index.html#//005700000093000000

Specific to your case:

Solution
If your tool is not using a VB expression, you can ignore this warning.

Per Anthony's response, the KB article still holds true...we now have the ability (in 10.1) to let you know about it and offer suggestions.

Re: cannot use VB expressions for services

KevinGooss — Tue, 06 Nov 2012 18:27:26 GMT

Cool. Thank you.

Re: cannot use VB expressions for services

AnthonyGiles — Tue, 06 Nov 2012 18:37:59 GMT

Kevin,

Not that I am an expert in python but looking at the help file for Calculate Field the syntax is:

CalculateField_management (in_table, field, expression, {expression_type}, {code_block})

so if uniqueid is a variable have you tried:

arcpy.CalculateField_management("in_memory/buffer", "GP_ID",uniqueid,"PYTHON")

or if uniqueid is a field name

arcpy.CalculateField_management("in_memory/buffer", "GP_ID", "!uniqueid!","PYTHON")

Regards

Anthony