PL error codes (ODPS-02CCCCX)

Updated at:

This topic lists PL error codes, describes their trigger conditions, and provides solutions.

The format for this type of error code is as follows.
ODPS-02CCCCX:General description - Context-specific information
PL faults from the CLIENT, LEXER, and PARSER modules have a CCCC segment in the range of 1000 to 1999. PL faults from the SEMANTIC module have a CCCC segment in the range of 2000 to 2999. The following table lists the error codes.
Error codeModuleSeverity levelTrigger conditionSolution
ODPS-0210001:Unable to open input fileCLIENT1The PL file does not exist.Verify that the PL file exists.
ODPS-0210011:Unable to use UTF8 to encodingCLIENT1The input file is not UTF-8 encoded.Change the encoding format of the input file.
ODPS-0220025:Invalid datetime or format, expected format is 'yyyy-mm-dd hh:mi:ss'SEMANTIC5The DATETIME format is invalid or the DATE value does not exist.Change the DATETIME format or the DATE value.
ODPS-0220035:Illegal implicit type castSEMANTIC5An implicit type conversion is not allowed.Change the type conversion.
ODPS-0220045:Variable has declared previouslySEMANTIC5The variable is defined more than once.Change the definition syntax.
ODPS-0220055:Variable was not declaredSEMANTIC5A variable that was not defined is referenced.Change the reference to a defined variable.
ODPS-0220065:Illegal argument typeSEMANTIC5The parameter type is not supported.Change the parameter to a supported type.
ODPS-0220075:Illegal variable nameSEMANTIC5The variable name is longer than 30 characters.Change the variable name.
ODPS-0220095:Invalid bigintSEMANTIC5The BIGINT value is invalid or out of range.Make sure the BIGINT value is valid and within the allowed range.
ODPS-0220105:Invalid doubleSEMANTIC5The DOUBLE value is invalid or out of range.Make sure the DOUBLE value is valid and within the allowed range.
ODPS-0220115:DEPLException from SQL statementSEMANTIC5An exception occurred during SQL execution.Check that the SQL syntax is correct.
ODPS-0220125:Illegal assignmentSEMANTIC5Invalid variable assignment.Make sure the variable assignment is valid.
ODPS-0220135:Illegal argument valueSEMANTIC5Invalid parameter value.Make sure the parameter value is valid.
ODPS-0220145:Illegal variable referenceSEMANTIC5Invalid variable reference.Make sure the variable reference is valid.