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

Model Builder Calculate Value Tool ERROR 000354: The name contains invalid characters

TimBarker

ArcMap Desktop 10.1

I'm trying to build a simple Calculate Value Tool entry in a model to concatenate some variables together into an output shapefile name. Cannot get it to work even though the expression evaluates correctly. I have simplified and simplified it trying to find source of error. I now have the simplest of entries. I put a simple text string into the expression and it still will not get past the tool.

Executing (Calculate Value): CalculateValue "calcname1" # String
Start Time: Wed Jul 05 12:35:54 2017
Value = calcname1
ERROR 000354: The name contains invalid characters
Failed to execute (Calculate Value).
Failed at Wed Jul 05 12:35:54 2017 (Elapsed Time: 0.00 seconds)

I have tried arcpy.ValidateTableName() - no difference.

What 'name' has invalid characters?

I chopped everything out of the model to where there is just the Calculate Value tool trying to evaluate the one input text string. It will not successfully finish.

Help?

Find more posts tagged with

Accepted answers

All comments

JayantaPoddar

Could you attach the screenshot of the model/expression?

Ensure that the result of the expression (name) doesn't have any special characters (except underscore) and it doesn't start with a numeric value.

DanPatterson_Retired

was the ... # string... portion in the original? I know it is ok as a comment for python, but not otherwise

IanMurray

I think the # was the placeholder for a blank expression for the second parameter of Calculate Value. Arc uses them all the time for optional parameters left blank in geoprocessing operations.

DanPatterson_Retired

ahh, I didn't know it gave the data type as well, I knew about the # bit

curtvprice

This is strange, this works for me:

Calculate Value screenshot

Executing (Calculate Value): CalculateValue "calcvalue1" # String
Start Time: Wed Jul 05 15:16:57 2017
Value = calcvalue1
Succeeded at Wed Jul 05 15:16:57 2017 (Elapsed Time: 0.06 seconds)‍‍‍‍<SPAN class="line-numbers-rows"><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN></SPAN>

to get back to your need:

I'm trying to build a simple Calculate Value Tool entry in a model to concatenate some variables together into an output shapefile name.

You don't need to use Calculate Value, you can just enter them your output path:

C:\output_folder\%element1%%element2%%element3%<SPAN class="line-numbers-rows"><SPAN>‍</SPAN></SPAN>

curtvprice

Dan, this is a very helpful parameter! The Data Type parameter of Calculate Value allows you to use code to construct a string representation of an object (say for extent), if you set the data type it allows model builder to recognize that data type to allow you to connect the Calculate Value output to a tool that requires that particular data type (like Extent, Cell Size, Coordinate System, etc).

MalcolmMeyer2

Similar problem -

Start Time: Mon Sep 30 10:56:14 2019
Succeeded at Mon Sep 30 10:56:14 2019 (Elapsed Time: 0.35 seconds)
Executing (Calculate Value): CalculateValue validate(r"coz.DBO.utl_stormwater_impervious") "def validate(string):\n return (string).replace(".", "_")" "Any value"
Start Time: Mon Sep 30 10:56:14 2019
Value = coz_DBO_utl_stormwater_impervious
ERROR 000354: The name contains invalid characters
Failed to execute (Calculate Value).
Failed at Mon Sep 30 10:56:14 2019 (Elapsed Time: 0.00 seconds)

The tool runs, gives me the needed value, but then errors out...why? I have seen this referenced here as well - Model builder: iterative Excel-file import and Shapefile output. I also tried with ValidateTableName with the same error. I just need a valid table name from an SDE database, without the dots.

MalcolmMeyer2

A computer restart fixed this and is now working as expected...that is weird.

Join the Conversation

Signed in members can post, follow updates, and more. New here? Register a free account.

Quick Links

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