Error Messages
This document provides a complete list of all error messages generated by the VTL engine. Each entry includes the error code, the corresponding message, and a brief description to help users to understand the cause of the issue.
The following legend explains the error code patterns used in the VTL engine:
Category |
Pattern |
|---|---|
INPUT ERRORS |
0-1-X-X = Input Validation Errors 0-2-X-X = JSON Schema Errors 0-3-X-X = DataLoad Errors |
SEMANTIC ERRORS |
1-1-X-X = Operators Semantic Errors 1-2-X-X = Semantic Analyzer Errors 1-3-X-X = AST Errors |
RUNTIME ERRORS |
2-X-X-X = RunTime Operator Errors |
The following table contains all available error codes:
Code |
Message |
Description |
|---|---|---|
0-1-0-1 |
Trying to redefine input Datasets {dataset}. |
Raised when the user attempts to redefine an input Dataset that already exists. |
0-1-1-1 |
invalid script format type: |
Occurs when the script input type is not valid. It must be a string, TransformationScheme, or Path object. |
0-1-1-2 |
The provided input {input} can not be used in this instance. |
Raised when an input Dataset or value cannot be used in the current context. |
0-1-1-3 |
Invalid file extension: expected {expected_ext}, got {ext} |
Occurs when a file has an incorrect extension compared to the expected one. |
0-1-1-6 |
Duplicated records. Combination of Identifiers are repeated. |
Raised when duplicate rows are detected based on the Identifiers combination. |
0-1-1-7 |
G1 - The provided CSV file is empty. |
Occurs when the input CSV file does not contain any data. |
0-1-1-8 |
The following Identifiers {ids} were not found , review file {file}. |
Raised when certain expected Identifiers are missing in the input Dataset. |
0-1-1-9 |
You have a problem related with commas, review rfc4180 standard, review file {file}. |
Occurs when CSV formatting issues are detected, particularly with commas, violating RFC4180. |
0-1-1-11 |
Wrong data in the file for this Scalar/Dataset {name}. |
Raised when a Scalar or Dataset contains invalid or inconsistent data. |
0-1-1-13 |
Invalid key on {field} field: {key}{closest_key}. |
Occurs when a key provided in the Dataset does not exist in the field. |
0-1-1-14 |
Empty Datasets {dataset1} and {dataset2} shape missmatch. |
Raised when two Datasets are empty or have incompatible shapes. |
0-1-2-3 |
{element_type} ‘{element}’ is/are duplicated. |
Occurs when an element (e.g., Identifier or component) appears more than once. |
0-1-2-5 |
File {file} must be encoded in utf-8 (without BOM). |
Raised when the file encoding is not UTF-8 without BOM. |
0-1-2-7 |
Invalid value ‘ |
Occurs when a value does not match the expected type or operation constraints. |
0-1-2-8 |
Cannot pass as inputs Datasets/Scalars defined as outputs of transformations in the script, please check: {names} |
Raised when an output of a transformation is incorrectly used as an input. |
0-1-3-1 |
Expected exactly one input Dataset in the whole script, found: {number_Datasets} |
Raised when the script expects exactly one input Dataset but finds more than one. |
0-1-3-2 |
SDMX Dataset {schema} requires to have a Schema object defined as structure |
Occurs when an SDMX Dataset is missing its required schema definition. |
0-1-3-3 |
If no mappings are provided, only one Dataset is allowed. |
Raised when multiple Datasets are provided without mappings, but only one is allowed. |
0-1-3-4 |
Dataset {short_urn} not found in mapping dictionary. |
Occurs when the Datasets short URN is does not exists in the mapping dictionary. |
0-1-3-5 |
Dataset {dataset_name} not found in the input Datasets. |
Raised when a Dataset expected as input is missing from the provided Datasets. |
0-1-3-6 |
Input name {missing} not found in the input Datasets. |
Occurs when a named input Dataset cannot be found among the available inputs. |
0-1-3-7 |
Invalid input Datasets type: |
Raised when the type of input Datasets is incorrect; a sequence of PandasDataset is expected. |
0-2-1-1 |
The provided JSON does not follow the required JSON Schema |
Occurs when a JSON input does not comply with the expected schema. |
0-2-1-2 |
Dataset {dataset} is not valid according to JSON schema |
Raised when the Dataset does not conform to the expected JSON schema. |
0-3-1-1 |
{file} file not found. Please verify that the file exists and the provided path is correct. |
Occurs when the specified file cannot be located at the given path. |
0-3-1-2 |
Output folder {folder} not found or invalid. Must be a valid Path or S3 directory. |
Raised when the output folder path is missing or not valid for saving results. |
0-3-1-3 |
On Dataset {name} loading: An Identifier cannot have null values, found null values on {null_identifier}. |
Occurs when a Dataset Identifier contains null values, which is not allowed. |
0-3-1-4 |
On Dataset {name} loading: Datasets without Identifiers must have 0 or 1 datapoints. |
Raised when a Dataset without Identifiers has more than one datapoint. |
0-3-1-5 |
On Dataset {name} loading: Component {comp_name} is missing in Datapoints. |
Occurs when a required component is missing from the Dataset datapoints. |
0-3-1-6 |
On Dataset {name} loading: not possible to cast column {column} to |
Raised when a Dataset column cannot be cast to the expected data type. |
0-3-1-7 |
On Dataset {name} loading: Duplicated Identifiers are not allowed, found on row {row_index} |
Occurs when a Dataset contains duplicated Identifiers, which is not allowed. |
1-1-1-1 |
Invalid implicit cast from {type_1} to {type_2}. |
Raised when an implicit type conversion from {type_1} to {type_2} is not allowed. |
1-1-1-2 |
Invalid implicit cast from {type_1} and {type_2} to {type_check}. |
Occurs when the combination of types {type_1} and {type_2} cannot be implicitly cast to {type_check}. |
1-1-1-3 |
At op |
Raised when a Dataset or Scalar cannot be promoted to the required target type in the operation |
1-1-1-4 |
At op |
Occurs when an operation is attempted on a Dataset with multiple Measures, which is not permitted. |
1-1-1-5 |
At op |
Raised when an operand or component has an invalid type for the operation |
1-1-1-8 |
At op |
Occurs when a Dataset is expected to have Measures but none are defined. |
1-1-1-9 |
At op |
Raised when Measures in a Dataset have different types each other. |
1-1-1-10 |
Component {comp_name} not found in Dataset {dataset_name}. |
Occurs when a referenced component is missing from the Dataset. |
1-1-1-13 |
At op |
Raised when a Dataset component has an unexpected role for the operation. |
1-1-1-15 |
At op |
Occurs when two Datasets expected to have the same number of a specific type of components do not match. |
1-1-1-16 |
Found structure not nullable and null values. |
Raised when null values are found in a structure that is defined as non-nullable. |
1-1-1-20 |
At op |
Occurs when a Scalar is provided to an operation that only supports Datasets. |
1-1-2-2 |
At op |
Raised when a non-Identifier component is used in a grouping operation. |
1-1-2-3 |
Having component output type must be boolean, found |
Occurs when the output of a component in a HAVING clause is not boolean as required. |
1-1-3-2 |
At op |
Raised when a non-Identifier component is used as a partitioning key in an analytic operation. |
1-1-5-1 |
Type {type_1}, cannot be cast to {type_2}. |
Occurs when an explicit or implicit cast between incompatible types is attempted. |
1-1-5-3 |
Impossible to cast from type {type_1} to {type_2}, without providing a mask. |
Raised when a cast requires a mask to resolve ambiguities, but none is provided. |
1-1-5-4 |
Invalid mask to cast from type {type_1} to {type_2}. |
Occurs when the mask provided for casting is invalid or incompatible with the types. |
1-1-5-5 |
A mask can’t be provided to cast from type {type_1} to {type_2}. Mask provided: {mask_value}. |
Raised when a mask is provided in a context where it should not be used for the cast. |
1-1-6-2 |
At op |
Raised when an Identifier cannot be included in the specified operation. |
1-1-6-4 |
At op |
Occurs when an alias uses a name that conflicts with an existing component symbol. |
1-1-6-5 |
At op |
Raised when a Scalar is used where only Dataset components are allowed. |
1-1-6-6 |
Membership is not allowed inside a clause, found {dataset_name}#{comp_name}. |
Occurs when a membership operation is attempted inside a clause, which is invalid. |
1-1-6-7 |
Cannot use component {comp_name} as it was generated in another calc expression. |
Raised when trying to reuse a component generated in a different calculation expression. |
1-1-6-8 |
Cannot use component {comp_name} for rename, it is already in the Dataset {dataset_name}. |
Occurs when attempting to rename a component that already exists in the Dataset. |
1-1-6-9 |
At op |
Raised when duplicate components are detected in the operation. |
1-1-6-10 |
At op |
Occurs when a component expected to be an Identifier is not. |
1-1-6-11 |
Ambiguity for this variable {comp_name}, exists as a Scalar and component. |
Raised when a variable name exists both as a Scalar and component, creating ambiguity. |
1-1-6-12 |
At op |
Occurs when attempting to remove the last element, which is not permitted. |
1-1-6-13 |
At op |
Raised when an operation attempts to overwrite an existing Identifier. |
1-1-7-1 |
At op |
Occurs when attempting to compare values of incompatible types. |
1-1-9-1 |
At op |
Raised when the condition in a conditional operation does not evaluate to Boolean. |
1-1-9-3 |
At op |
Occurs when then/else clauses are not both Scalars, which it is required. |
1-1-9-4 |
At op |
Raised when the condition Dataset has multiple Measures instead of a single one. |
1-1-9-5 |
At op |
Occurs when the Measure in the condition Dataset is not Boolean. |
1-1-9-6 |
At op |
Raised when the then-else Datasets do not match the Identifier count of the condition Dataset. |
1-1-9-9 |
At op |
Occurs when a component in a clause has an incorrect role type. |
1-1-9-10 |
At op |
Raised when a Dataset in a clause has mismatched Identifier count. |
1-1-9-11 |
At op |
Occurs when a condition component is not Boolean. |
1-1-9-12 |
At op |
Raised when then/else clauses do not meet required type rules (Dataset/Scalar). |
1-1-9-13 |
At op |
Occurs when then and else Datasets have differing numbers of components. |
1-1-10-1 |
At op |
Raised when an operand does not have exactly one Measure of the required type. |
1-1-10-2 |
At op |
Occurs when the number of variables in the call does not match the function signature. |
1-1-10-3 |
At op |
Raised when a variable name in the call differs from the expected signature. |
1-1-10-4 |
At op |
Occurs when a hierarchical ruleset defined for value domain,requires a component but it is missing in the call. |
1-1-10-5 |
No rules to analyze on Hierarchy Roll-up as rules have no = operator. |
Raised when there are no applicable rules in a Hierarchy Roll-up due to missing ‘=’ operators. |
1-1-10-6 |
At op |
Occurs when a variable name in the call does not match the expected condition in the signature. |
1-1-10-7 |
Not found component {comp_name} on signature. |
Raised when a component referenced in the call is not found in the signature. |
1-1-10-8 |
At op |
Occurs when operands involve non-numerical Measures where numerical are required. |
1-1-10-9 |
Invalid signature for the ruleset {ruleset}. On variables, condComp and ruleComp must be the same |
Raised when condComp and ruleComp in a ruleset signature do not match as required. |
1-1-13-1 |
At op |
Raised when an alias is used more than once in the same operation. |
1-1-13-2 |
At op |
Occurs when a required alias for an operation is not provided. |
1-1-13-3 |
At op |
Raised when a Join operation encounters column name conflicts across input Datasets. |
1-1-13-4 |
At op |
Occurs when a ‘using’ clause in a join does not cover all Identifiers of a non-reference Dataset. |
1-1-13-5 |
At op |
Raised when not all Datasets in subcase B1 share the declared ‘using’ Identifiers. |
1-1-13-6 |
At op |
Occurs when components declared in ‘using’ are missing from the reference Dataset in subcase B2. |
1-1-13-7 |
At op |
Raised when non-reference Datasets in subcase B2 do not share the declared ‘using’ Identifiers. |
1-1-13-8 |
At op |
Occurs when a join operation requires a ‘using’ clause but none is provided. |
1-1-13-9 |
Ambiguity for this variable {comp_name} inside a Join clause. |
Raised when a component name is ambiguous in a Join operation. |
1-1-13-10 |
The join operator does not perform Scalar/component operations. |
Occurs when attempting Scalar or component operations directly with a Join operator. |
1-1-13-11 |
At op |
Raised when a subcase A join expects a superset but a required component is missing. |
1-1-13-12 |
At op |
Occurs when Datasets involved in subcase A have differing Identifiers. |
1-1-13-13 |
At op |
Raised when Datasets in subcase A do not have the same number of Identifiers. |
1-1-13-14 |
Cannot perform a join over a Dataset Without Identifiers: {name}. |
Occurs when attempting to join a Dataset that lacks Identifiers. |
1-1-13-15 |
At op |
Raised when a component is not a Measure in all Datasets required for the Join clause. |
1-1-13-16 |
At op |
Occurs for general invalid use cases in join operations. |
1-1-13-17 |
At op |
Raised when a component is missing from the join result Dataset when it is referenced. |
1-1-14-1 |
At op |
Occurs when Measure names do not match across Datasets in an operation. |
1-1-14-3 |
At op |
Raised when the Dataset has an unexpected number or type of Identifiers. |
1-1-14-5 |
At op |
Occurs when the specified components/types are incompatible with the operation. |
1-1-14-6 |
At op |
Raised when a component and a Scalar set have incompatible types for an operation. |
1-1-14-9 |
At op |
Occurs when components/types across multiple Datasets are incompatible with the operation. |
1-1-15-8 |
At op |
Raised when an operator receives a component type that is not allowed as a parameter. |
1-1-17-1 |
At op |
Raised when set operations are performed on Datasets with differing numbers of components. |
1-1-18-1 |
At op |
Raised when a string operation expects a Dataset with exactly one Measure. |
1-1-18-2 |
At op |
Occurs when attempting to combine a Dataset and a component in an unsupported way. |
1-1-18-3 |
At op |
Raised when a parameter is supplied at an invalid position. |
1-1-18-4 |
At op |
Occurs when a parameter type does not match the expected type. |
1-1-18-6 |
At op |
Raised when Datasets involved in a string operation do not have matching Measures. |
1-1-18-7 |
At op |
Occurs when the number of parameters supplied is incorrect. |
1-1-18-8 |
At op |
Raised when a string pattern or regex fails at a specific position. |
1-1-18-10 |
At op |
Occurs when a Dataset is incorrectly used as a parameter in a string operation. |
1-1-19-1 |
At op |
Raised when a Time operator is applied to a component with an incorrect data type. |
1-1-19-2 |
At op |
Occurs when the Date type of a component is unknown or unsupported for the operation. |
1-1-19-3 |
At op |
Raised when a parameter value for a Time operator is invalid. |
1-1-19-4 |
At op |
Occurs when periodIndTo is not greater than periodIndFrom in a Time aggregation. |
1-1-19-5 |
At op |
Raised when the periodIndTo parameter is too short compared with the values to aggregate. |
1-1-19-6 |
At op |
Occurs when a component has a time type that is unsupported for the operation. |
1-1-19-7 |
At op |
Raised when a time operation is applied to an unsupported type; only Time series Datasets are allowed. |
1-1-19-8 |
At op |
Occurs when the time operator is applied to a component of the wrong type. |
1-1-19-9 |
At op |
Raised when a time operator requires a component with a specific additional parameter type. |
1-1-19-10 |
|
Occurs when operands of a time operator are not of type Date or Time Period. |
1-1-19-11 |
At op time_agg: If used over a Date, first/last parameter must be declared. |
Raised when the first/last parameter is missing in a time aggregation over a Date type. |
1-2-1 |
Please don’t use twice {alias} like var_to. |
Raised when the same alias is used more than once in a variable assignment. |
1-2-2 |
Overwriting a Dataset/variable is not allowed, trying it with {varId_value}. |
Occurs when an attempt is made to overwrite an existing Dataset or variable. |
1-2-3 |
{node_op} not found or not valid for {op_type}. |
Occurs when an operator node is not recognized or incompatible with the operation type. |
1-2-4 |
Defined Operator {node_value} not previously defined. |
Raised when a user-defined operator is used before being defined. |
1-2-5 |
Operations without output assigned are not available. |
Occurs when attempting to execute operations that require an assigned output but none is provided. |
1-2-6 |
No {node_type} {node_value} found. |
Raised when a required node of a specific type is missing. |
1-2-7 |
RuleComp of Hierarchical Ruleset can only be an Identifier, {name} is a {role}. |
Occurs when a rule component in a hierarchical ruleset is not an Identifier. |
1-2-8 |
Missing value domain ‘{name}’ definition, please provide an structure. |
Raised when a required value domain is missing its definition. |
1-2-9 |
Value domain {name} not found. |
Raised when a specified value domain cannot be found. |
1-2-10 |
Dataset without Identifiers are not allowed in |
Occurs when an operator is applied to a Dataset lacking Identifiers. |
1-2-11 |
At op |
Raised when the number of parameters provided to an operation is less than expected. |
1-2-12 |
At op |
Occurs when a user-defined operator returning a component is used outside an allowed context. |
1-2-13 |
Having clause is not permitted if group by clause is not present. |
Occurs when a HAVING clause is used without a corresponding GROUP BY clause. |
1-2-14 |
At op |
Occurs when an aggregation operation is attempted inside a Calc expression. |
1-3-1-1 |
At op |
Occurs when a user-defined option has a type mismatch in its declaration. |
1-3-1-2 |
Using variable |
Raised when a variable is used without being defined in the operation’s context. |
1-3-1-3 |
At op |
Occurs when a variable is referenced but not declared as an argument. |
1-3-1-4 |
Found duplicates at arguments naming, please review |
Raised when duplicate argument names are found in a definition. |
1-3-1-5 |
Found duplicates at rule naming: {names}. Please review |
Occurs when multiple rules share the same name in a ruleset. |
1-3-1-6 |
At op |
Raised when the number of defined arguments and passed arguments do not match. |
1-3-1-7 |
All rules must be named or not named, but found mixed criteria at |
Occurs when some rules are named and others are not in the same ruleset. |
1-3-1-8 |
All rules must have different code items in the left side of ‘=’ in hierarchy operator at hierachical ruleset definition {name}. |
Raised when duplicate left-hand side code items are found in hierarchical ruleset definitions. |
1-3-1-9 |
At op check_datapoint: {name} has an invalid datatype expected Dataset, found Scalar. |
Occurs when a datapoint has an invalid datatype; a Dataset is expected but a Scalar was found. |
1-3-2-0 |
Error creating DAG. |
Raised when the DAG (Directed Acyclic Graph) creation fails. |
1-3-2-1 |
Eval could not be called without a {option} type definition. |
Occurs when an evaluation is attempted without a necessary type definition. |
1-3-2-2 |
At op |
Occurs when a user-defined operator lacks a return definition. |
1-3-2-3 |
At op |
Raised when cyclic dependencies are detected in a VTL script, preventing DAG creation. |
1-3-2-4 |
The Time aggregation operand has to be defined if not used inside an aggregation. |
Raised when a Time aggregation operator is missing the operand definition outside an aggregation context. |
1-3-5 |
{node_op} not found or not valid for {op_type}. |
Occurs when an operator is undefined or incompatible with the given operation type. |
1-3-6 |
Language {language} not supported on Eval operator. Only SQL language is supported. |
Raised when an unsupported language is specified in an Eval operation. |
1-3-12 |
Default arguments cannot be followed by non-default arguments. |
Occurs when a function definition places non-default parameters after default ones. |
2-1-5-1 |
Impossible to cast |
Occurs when a value cannot be converted between the specified types. |
2-1-5-2 |
Value |
Raised when attempting to cast a decimal value to an integer, which is not allowed. |
2-1-9-1 |
At op |
Raised when condition operators differ in type, which is invalid. |
2-1-9-2 |
At op |
Occurs when a condition variable is not Boolean. |
2-1-9-3 |
At op |
Raised when then/else operands are not all Scalars. |
2-1-9-4 |
At op |
Occurs when the condition variable is not of Boolean type. |
2-1-9-5 |
At op |
Raised when the Measure in a condition Dataset is not Boolean. |
2-1-9-6 |
At op |
Occurs when neither then nor else operands are Datasets. |
2-1-9-7 |
At op |
Raised when Dataset operands have mismatched components. |
2-1-12-1 |
At op |
Raised when attempting to create a null Measure without specifying a Scalar type; a Cast operator must be used. |
2-1-15-1 |
At op |
Runtime error raised when a Dataset component contains negative values that are not allowed. |
2-1-15-2 |
At op |
Runtime error when a value is negative but must be non-negative. |
2-1-15-3 |
At op |
Runtime error when a base value is less than or equal to zero, which is not allowed. |
2-1-15-4 |
At op |
Runtime error when a component contains invalid values. |
2-1-15-5 |
At op |
Runtime error when two components contain invalid values. |
2-1-15-6 |
At op |
Runtime error when attempting to divide a Scalar by zero. |
2-1-15-7 |
At op |
Runtime error when an operator is incorrectly applied to a Dataset instead of allowed types. |
2-1-19-1 |
At op time_agg: Invalid value |
Raised when the periodIndTo parameter is smaller than the values being aggregated. |
2-1-19-2 |
Invalid period indicator {period}. |
Occurs when the specified period indicator is not recognized or valid. |
2-1-19-3 |
Only same period indicator allowed for both parameters ({period1} != {period2}). |
Raised when two parameters have different period indicators where the same indicator is required. |
2-1-19-4 |
Date setter, ( |
Occurs when date1 is set to a value greater than date2, which is invalid. |
2-1-19-5 |
Date setter, ( |
Occurs when date2 is set to a value less than date1, which is invalid. |
2-1-19-6 |
Invalid period format, must be YYYY-(L)NNN: {period_format} |
Raised when a period string does not match the expected format. |
2-1-19-7 |
Period Number must be between 1 and {periods} for period indicator {period_indicator}. |
Occurs when the period number is outside the valid range for the given period indicator. |
2-1-19-8 |
Invalid date format, must be YYYY-MM-DD: {date} |
Raised when a date does not follow the required YYYY-MM-DD format. |
2-1-19-9 |
Invalid day {day} for year {year}. |
Occurs when the day value is invalid for the given year. |
2-1-19-10 |
Invalid year {year}, must be between 1900 and 9999. |
Raised when the year is outside the allowed range. |
2-1-19-11 |
|
Occurs when a time operator is applied to incompatible values. |
2-1-19-12 |
At op |
Raised when a parameter has a type different from what is expected. |
2-1-19-13 |
At op |
Occurs when a parameter has an invalid data type for the operation. |
2-1-19-14 |
At op |
Raised when a Dataset lacks required Date/Time_Period Measures. |
2-1-19-15 |
|
Occurs when the operator is applied to values not conforming to ISO 8601 format. |
2-1-19-16 |
|
Raised when the operator is applied to non-positive numbers. |
2-1-19-17 |
At op |
Occurs when a time operator comparison uses unsupported operators like < or >. |
2-1-19-18 |
At op |
Raised when attempting to compute max or min using unsupported Time operator comparisons. |
2-1-19-19 |
Time Period comparison (>, <, >=, <=) with different period indicator is not supported, found {value1} |
Occurs when comparing two time periods with different indicators using unsupported Comparison operators. |
2-1-19-20 |
Time Period operands with different period indicators do not support < and > Comparison operations, unable to get the |
Raised when < or > comparisons are attempted between operands with different period indicators. |
2-3-4 |
|
Occurs when a required component is missing for the operator. |
2-3-5 |
Expected {param_type}, got {type_name} on UDO |
Raised when a user-defined operator receives a parameter of an unexpected type. |
2-3-6 |
Dataset or Scalar {dataset_name} not found, please check input datastructures. |
Occurs when an input Dataset or Scalar is missing. |
2-3-9 |
{comp_type} {comp_name} not found in |
Raised when a component is not found within a specified parameter. |
2-3-10 |
No {comp_type} have been defined. |
Occurs when no components of the required type have been defined. |
2-3-11 |
{pos} operand must be a Dataset. |
Raised when an operand expected to be a Dataset is not a Dataset. |