Troubleshooting
Problem
The EXPR_00 error indicates that the Data Collector has encountered an invalid expression due to incorrect syntax or usage of an unsupported function within the context of a given property. Common issues include incorrect spellings, improper use of quotes, misplacement of parentheses or curly brackets, or the invocation of functions not supported by the property in question. Notably, if an expression error arises, it is often followed by a CTRCMN_0101 error, which further specifies parsing issues related to the expression syntax.
When troubleshooting, it can be helpful to use the expression completion feature available in StreamSets Data Collector, which helps ensure that the syntax is correct and the functions used are supported for the given property.
Symptom
When validating or starting a pipeline in StreamSets Data Collector, you encounter an error in the UI or logs indicating an invalid expression. The error code EXPR_00 appears alongside a detailed message highlighting an issue with the expression syntax or function usage within a stage of the pipeline.
Example error messages (In this case, the ${credential:get()} function was used from the Expression Evaluator Stage, which does not support it for security reasons):
Example error message from the UI (after trying validation from Platform):
Example error from the logs (sdc.log file after trying to run the pipeline):
EXPR_00 - Invalid expression '${credential:get("vault", "all", “test-mount-path&secret-key")}': com.streamsets.pipeline.api.el.ELEvalException: CTRCMN_0101 - Error parsing expression...
Resolving The Problem
To resolve the EXPR_00 error, perform the following steps:
Check Spelling: Confirm that all fields and functions in the expression are spelled correctly.
Correct Quotes: Ensure that the expression uses the correct quotation marks. Only straight quotes (" or ') are accepted. Curly quotes (“ or ”), often introduced through copy-pasting from word processors, are invalid.
Validate Brackets: Check that all parentheses
()and curly brackets{}are correctly paired and placed.Confirm Function Support: Make sure that the functions you are trying to use are supported by the property. Not all functions are available for all properties.
Document Location
Worldwide
Was this topic helpful?
Document Information
Modified date:
15 March 2025
UID
ibm17186124