topic CalculateField_management generates ERROR 000539 depending on values in Data Management Questions

CalculateField_management generates ERROR 000539 depending on values

YasunariMorita — Mon, 15 Jan 2018 06:26:19 GMT

Hi!

I tried copy values from COUNT attribute to test attribute.

(expression ="!COUNT!")

I used CalculateField_management, but CalculateField_management generates ERROR 000539 depending on values.

TEST1:I tried CalculateField using this table.

OID	Value	COUNT	SUM	test
-1	6	5E+08	1.61E+09

I got the error below.

ExecuteError: ERROR 000539: <type 'exceptions.SyntaxError'>: unexpected EOF while parsing (<expression>, line 1)
Failed to execute (CalculateField).

TEST2:I tried CalculateField using this table whose value in COUNT attribute changed .

OID	Value	COUNT	SUM	test
-1	6	5.1E+08	1.61E+09

This time, CalculateField worked well.

Why value"5.1E+08" worked well and did not work value"5E+08" ?

How should I avoid this problem?

my arcGIS version is 10.5

Thanks in advance.

Re: CalculateField_management generates ERROR 000539 depending on values

JayantaPoddar — Mon, 15 Jan 2018 07:45:50 GMT

Could you attach the whole python script? Ensure there is no indentation error.

Re: CalculateField_management generates ERROR 000539 depending on values

YasunariMorita — Fri, 10 Dec 2021 22:06:23 GMT

Hi Jayanta,

Here is my script. In addition, I got the same error when using ArcMap toolbox.

# Replace a layer/table view name with a path to a dataset (which can be a layer file) or create the layer/table view within the script
# The following inputs are layers or table views: "tmp_table"
arcpy.CalculateField_management(in_table="tmp_table", field="test", expression="!COUNT!", expression_type="PYTHON_9.3", code_block="")‍‍‍‍‍‍

Re: CalculateField_management generates ERROR 000539 depending on values

JayantaPoddar — Mon, 15 Jan 2018 09:11:04 GMT

What happens if you replace "tmp_table" with the full path of the Feature Class?

Re: CalculateField_management generates ERROR 000539 depending on values

DanPatterson_Retired — Mon, 15 Jan 2018 11:49:02 GMT

Do it manually using the tool as per usual, then go to the 'Results' window and copy the python expression to get the correct syntax. That will solve the debate as to whether full paths or something in your expression is the issue.

Re: CalculateField_management generates ERROR 000539 depending on values

XanderBakker — Mon, 15 Jan 2018 12:01:55 GMT

Also check the definition of both fields. If they do not have the same numeric definition, you may run into problem of trying to fit a value into a reduced range of allowed values. I assume both fields are numeric, right?

Re: CalculateField_management generates ERROR 000539 depending on values

YasunariMorita — Fri, 10 Dec 2021 22:06:26 GMT

Sorry for my poor info.

table info

tmp_table:table class

tmp_table:C:\Work01\scratch_00.gdb\tmp_table

the definition of both fields

COUNT:Float
test:Float

Result window

original

メッセージ
実行: CalculateField tmp_table test !COUNT! PYTHON_9.3 #
開始時間: Mon Jan 15 15:01:42 2018
ERROR 000539: SyntaxError: unexpected EOF while parsing (<expression>, line 1)
(CalculateField) を実行できませんでした。
失敗 (Mon Jan 15 15:01:42 2018) (経過時間: 0.01 秒)

translation

message

execute: CalculateField tmp_table test !COUNT! PYTHON_9.3 #
start: Mon Jan 15 15:01:42 2018
ERROR 000539: SyntaxError: unexpected EOF while parsing (<expression>, line 1)
Failed to execute(CalculateField)
Failure (Mon Jan 15 15:01:42 2018) (elapsed time: 0.01 sec)

I checked two scripts below,but I got the same error.

arcpy.env.workspace = ur"C:\Work01\scratch_00.gdb"
arcpy.CalculateField_management(in_table="tmp_table", field="test", expression="!COUNT!", expression_type="PYTHON_9.3", code_block="")

arcpy.CalculateField_management(in_table="C:\\Work01\\scratch_00.gdb\\tmp_table", field="test", expression="!COUNT!", expression_type="PYTHON_9.3", code_block="")‍‍‍‍

Re: CalculateField_management generates ERROR 000539 depending on values

DanPatterson_Retired — Tue, 16 Jan 2018 00:34:22 GMT

ur as a prefix fails on my system

try just u or "C:/Work01/scratch_00.gdb"

since I assume you have a Unicode issue

Re: CalculateField_management generates ERROR 000539 depending on values

YasunariMorita — Tue, 16 Jan 2018 00:53:44 GMT

Thanks Dan

I tried again according to your advice.

arcpy.CalculateField_management(in_table=u"C:\Work01\scratch_00.gdb\tmp_table", field="test", expression="!COUNT!", expression_type="PYTHON_9.3", code_block="")‍

I got parameter error.This is due to prefix of path(ur).

Runtime error
Traceback (most recent call last): File "<string>", line 1, in <module>
File "c:\program files (x86)\arcgis\desktop10.5\arcpy\arcpy\management.py", line 3663, in CalculateField
raise e ExecuteError: 実行できません。パラメーターが不正です。
ERROR 000732: 入力テーブル: データセット C:\Work01\scratch_00.gdb mp_table が存在しないか、サポートされていません
(CalculateField) を実行できませんでした。

arcpy.CalculateField_management(in_table=ur"C:\Work01\scratch_00.gdb\tmp_table", field="test", expression="!COUNT!", expression_type="PYTHON_9.3", code_block="")‍

I got the same error.

Runtime error
Traceback (most recent call last):
File "<string>", line 1, in <module> File "c:\program files (x86)\arcgis\desktop10.5\arcpy\arcpy\management.py", line 3663, in CalculateField
raise e ExecuteError:
ERROR 000539: SyntaxError: unexpected EOF while parsing (<expression>, line 1)
(CalculateField) を実行できませんでした。

I think this may not be the Unicode issue....

Re: CalculateField_management generates ERROR 000539 depending on values

DanPatterson_Retired — Tue, 16 Jan 2018 01:01:05 GMT

you didn't try both... use this

"C:/Work01/scratch_00.gdb/tmp_table"

Note that the straight Unicode incarnation doesn't work either... so it is either 'r' (not 'u') or skip fiddling with windows notation and go straight to the forward slashes

'C: \\ Work01 \\ scratch_00.gdb \ tmp_table' note... \\ folder \\ gdb then a single \

Re: CalculateField_management generates ERROR 000539 depending on values

YasunariMorita — Tue, 16 Jan 2018 02:07:25 GMT

Oh...sorry

I use "C:/Work01/scratch_00.gdb/tmp_table" and try again.

The result is ....

ERROR 000539: SyntaxError: unexpected EOF while parsing (<expression>, line 1)

same error...

I think this may not be the Unicode issue....

Re: CalculateField_management generates ERROR 000539 depending on values

DanPatterson_Retired — Fri, 10 Dec 2021 22:06:29 GMT

Again, as I suggested before, go and do it manually for the one that worked and copy the python snippet from the results window... If that doesn't work and you have the right field type and this doesn't work either, then I am out of ideas.

arcpy.CalculateField_management(in_table="C:/Work01/scratch_00.gdb/tmp_table",
                                field="test",
                                expression="!COUNT!",
                                expression_type="PYTHON_9.3)
# note... I dumped the code block which is optionaly anyway
# and I parsed them so they were readable
‍‍‍‍‍‍

Re: CalculateField_management generates ERROR 000539 depending on values

XanderBakker — Fri, 10 Dec 2021 22:06:32 GMT

If, it the very unlikely situation that the snippet provided by Dan, does not work you could consider to forget about the field calculator and implement a cursor like this:

import arcpy

fc = r'C:\Work01\scratch_00.gdb\tmp_table'
fld_from = 'COUNT'
fld_to = 'test'

with arcpy.da.UpdateCursor(fc, (fld_from, fld_to)) as curs:
    for row in curs:
        row[1] = row[0]
        curs.updateRow(row)
‍‍‍‍‍‍‍‍‍‍

Re: CalculateField_management generates ERROR 000539 depending on values

YasunariMorita — Fri, 10 Dec 2021 22:06:34 GMT

Thanks Dan and Xander

Sorry for my impolite > Dan

Xander's code worked well and the code below also worked ...

arcpy.CalculateField_management(in_table="C:/Work01/scratch_00.gdb/tmp_table",
    field="test",
    expression="[COUNT]",
    expression_type="VB")‍‍‍‍‍‍‍‍

But, only this code doesn't work. Of course, it works well for other tables.

(I done it manually for the one that worked(Only changed table name) and copied the python snippet from the results window.)

arcpy.CalculateField_management(in_table="C:/Work01/scratch_00.gdb/tmp_table",
 field="test",
 expression="!COUNT!",
 expression_type="PYTHON_9.3")‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍

tmp_table:

OID	Value	COUNT	SUM	test
-1	6	5E+08	1.61E+09

For example, this code works well (copied the python snippet from the results window).

arcpy.CalculateField_management(in_table="C:/Work01/scratch_00.gdb/tmp_table2",
 field="test",
 expression="!COUNT!",
 expression_type="PYTHON_9.3")‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍

tmp_table2:

OID	Value	COUNT	SUM	test
-1	6	5.1E+08	1.61E+09

Thanks again Dan and Xander

Re: CalculateField_management generates ERROR 000539 depending on values

YasunariMorita — Tue, 16 Jan 2018 07:41:21 GMT

I have reported this problem to ESRI Japan and sent data(tmp_table).

They confirmed that they reproduced this phenmenon in their environment.

Re: CalculateField_management generates ERROR 000539 depending on values

camilogarcia — Tue, 13 Dec 2022 15:06:05 GMT

hello there

lest try changing this

expression="!COUNT!"

for this "\!COUNT!\"

and

expression_type="PYTHON"

works for me