Appendix A - List of Error Messages

Messages by ID number This table shows the ID number, brief name, and actual message (In actual error messages, tokens like {n} are replaced by specific information.)

Id Brief Name Actual Message
1 Internal Internal error: {0}
3 ErrorParsingSql Error while parsing SQL statement {0}; at line {1,number}, column {2,number}
4 IndexOutOfRange Column index {0} is out of range.
5 WrongColumnType Wrong value type for column {0]. Expected {1}, but received {2}.
6 NotNullable Column {0} is not nullable.
7 ErrorCallingNativeFunction Error occurred while calling native function {0}. Library path is {1}.
8 InvalidSqlIdentifier {0} is not a valid SQL identifier.
9 RowSizeExceedSdpMtu Maximum row size {0} exceeds SDP maximum transmission unit ({1}).
16 ServerNotAvailable SQLstream s-Server not available.
21 ExecutionAborted Execution aborted.
22 ExecutionInterrupted Execution interrupted.
23 StatementClosed Statement closed.
24 RowCountNotAvailable Row count not available.
25 InvalidTimeout Invalid timeout.
26 NoStatementID Query type has no statementId.
27 InvalidDynamicParams Statement not prepared. Dynamic params not allowed.
28 ParamsErr Value is missing for parameter.
29 StreamErr Failed to write to SDP stream.
31 NotExpedited Not an expedited insert.
32 AlreadyPrepared Statement already prepared.
33 ResultSetClosed Result set closed.
34 ErrorExecutingStatement Error executing statement.
35 ConnectionClosed Connection closed.
36 InvalidRSType ResultSet is TYPE_FORWARD_ONLY.
2010 LogFileLogToolUnknownParam Error: Unknown command line parameter {0}.
2012 LogFileLogToolMissingCommand Error: You must specify a command ({0}, {1}, {2}, {3}, or {4}).
2012 LogFileLogToolMissingConfigFile Error: You must specify the name of a configuration file. Configuration files are normally generated by the discover command.
2013 LogFileLogToolMissingLogName Error: You must specify the name of a log file or use {0} to specify all log files.
2014 LogFileLogToolRemoveRegisterBadParams Error: You must specify either the name of a log file or use {0} to specify all log files, but not both.
2017 LogFileLogToolNoLogs Error: The configuration file {0} has no log data.
2018 LogFileLogToolUnknownUserLogName Error: The configuration file {0} does not contain a log named {1}.
2019 LogFileLogToolUnknownLogName Error: The configuration file does not contain a log named {0}.
2020 LogFileLogToolDuplicateLogName Error: The log named {0} is already configured.
2022 LogFileLogToolNothingToDiscover Error: Use of {0} parameter and absence of {1} parameter prevents log file discovery.
2023 LogFileLogToolMissingSchemaName Error: You must specify a schema name for discovered log files.
2024 LogFileLogToolBadSchemaName Error: The schema name {0} is not a legal SQL identifier.
2025 LogFileLogToolConnectionError Error: Could not connect to the control node.
2025 LogFileLogToolSqlError Error: SQL error while querying the control node.
2026 LogFileLogToolRegistrationError Error: The log file {1} is already defined for schema {0}.
2030 LogFileCannotWriteToFile Error: Log file discovery cannot write to the file {0}.
2031 LogFileWriteSecurityError Error: Write access to the file {0} has been blocked by the Java security framework.
2032 LogFileReadError Error: Cannot read the log file {0}. Check file permissions.
2033 LogFileReadIOError Error: I/O error while reading the log file {0}.
2034 LogFileReadWarning Warning: Cannot read the log file {0}. Check file permissions.
2035 LogFileContentError Error: The content of the log file {0} is binary. Check encoding.
2036 LogFileContentWarning Warning: The content of the log file {0} is binary. Check encoding.
2037 LogFileIllegalCharsetName Error: The character set name {0} is not legal. Consult your Java Virual Machine’s documentation for a list of legal character set names.
2038 LogFileUnsupportedCharset Error: The character set {0} is not supported by your Java Virtual Machine. Consult your JVM’s documentation for a list of supported character sets.
2039 LogFileDefaultCharsetNameIllegal Error: The default character set name {0} is not legal.
2040 LogFileDefaultCharsetUnsupported Error: The default character set name {0} is not supported by your Java Virtual Machine.
2041 LogFileSizeWarning Warning: The log file {0} is empty. Log file format and encoding cannot be detected or verified.
2042 LogFileDirReadWarning Warning: Cannot read the directory {0}. Check permissions.
2043 LogFileConfigReadError Error: Cannot read the configuration file {0}. Check file permissions.
2044 LogFileConfigSecurityError Error: Read access to the configuration file {0} has been blocked by the Java security framework.
2046 LogFileLogToolHostnameError Error: Cannot determine this machine’s host name for use in generating a foreign server name. Use the {0} parameter to specify a foreign server name.
2047 LogFileLogTypeSqlMismatchedDataError Error: The log file {0} contains content that does not match its detected type. Cannot determine the SQL necessary to parse the log file.
2048 LogFileLogTypeSqlMissingDataError Error: The log file {0} is empty. Cannot determine the SQL necessary to parse the log file.
2049 LogFileLogToolNoJdbcDriver Error: cannot load the JDBC driver {0}.
2050 LogFileLogToolNoLogFiles Error: None of the log files indicated on the command line can be automatically detected.
2051 LogFileLogToolNoSecurityManager Error: The log tool requires a security manager to be configured for the Java Virtual Machine.
2100 LogrotateConfigReadError Error reading logrotate configuration file {0}.
2101 LogrotateConfigReadSecurity Error Read access to the logrotate configuration file {0} has been blocked by the Java security framework.
2102 LogrotateConfigReadDirSecurity Error Read access to the logrotate configuration directory {0} has been blocked by the Java security framework.
2103 LogrotateConfigParseError Error parsing the logrotate configuration file {0}.
2104 LogrotateConfigNestError Logrotate configuration file {0} is invalid because it nests log configurations.
2105 LogrotateMalformedGlobError The logrotate configuration file {0} contains a malformed file pattern {1}.
2106 LogrotateUnknownRotationCriterion Internal Error: The rotation criteria value {0} is unknown.
2107 LogrotateInvalidRotationThreshold Internal Error: The rotation threshold value {0} is invalid. It must be positive.
2108 LogrotateInvalidRotationCount Internal Error: The rotation count value {0} is invalid. It must be non-negative.
2109 LogrotateInvalidRotationStart Internal Error: The rotation start value {0} is invalid. It must be non-negative.
2200 LogFileXMLInitError Unable to initialize JAXB context for the context path {0}.
2201 LogFileXMLElementError Unable to create element {0} for the Log File Plug-in configuration file.
2202 LogFileXMLFileError Error writing to the Log File Plug-in configuration file {0}.
2203 LogFileXMLFileMarshalError Error marshalling the Log File Plug-in configuration to the file {0}.
2204 LogFileXMLMarshalError Error marshalling the Log File Plug-in configuration.
2205 LogFileXMLFileUnmarshalError Error unmarshalling a Log File Plug-in configuration from the file {0}.
2310 LogFilePluginIllegalCharset The character set encoding {0} is illegal. Legal character set encodings are comprised of the letters A-Z and a-z, the digits 0-9, dashes (-), periods (.), colons (:) and underscores (_) and must start with a letter or digit.
2311 LogFilePluginUnknownCharset The character set encoding {0} is unknown. Consult the documentation for your Java Virtual Machine for a list of available encodings.
2312 LogFilePluginTooManyColumns The stream definition for a streaming log file must contain exactly one column.
2313 LogFilePluginNotStringColumn The stream definition for a streaming log file must contain exactly one text column.
2314 LogFilePluginIllegalSleepInterval The sleep interval {0} is illegal. The minimum allowable value is 1.
2315 LogFilePluginIllegalMaxUnchStats The maximum unchanged stats value {0} is illegal. The minimum allowable value is 1.
2316 LogFilePluginMissingLogPath A log path must be specified.
2317 LogFilePluginIllegalRowtimeGrouping The rowtime grouping {0} is illegal. The minimum allowable value is 1.
2318 LogFilePluginInvalidPath The directory {0} cannot be converted into a canonical path name.
2320 LogFilePluginRootDirectorySecurityException Access to the root directory {0} has been blocked by the Java security framework.
2321 LogFilePluginRootIsNotDirectory The specified root {0} must be a directory.
2322 LogFilePluginLogFileNotUnderRoot The log file path {0} must be a child of the root directory {1}.
2323 LogFilePluginRootNotAbsolute The specified root {0} must be an absolute path name.
2324 LogFilePluginInvalidRowType The given column set does not match the output of the configured parser.
2330 LogFileFilePatternRequired FILE_PATTERN option required when log_path is a directory.
2335 LogFilePluginFilenameColumnCount {0} can only have 1 column specification.
2340 LogFilePluginFilenameType {0} must be data type VARCHAR.
2900 LogSecurityException Access to the log file {0} has been blocked by the Java security framework.
2901 LogDirSecurityException Access to the log directory “{0}” has been blocked by the Java security framework.
2902 LogFileHomeDir Error: Unable to obtain Log File Plug-in home directory.
3000 PluginStreamStartFailed Failed to start plugin stream.
3010 PluginStreamStopFailed Failed to stop plugin stream.
3020 PluginStreamInitializeFailed Failed to initialize plugin stream.
4000 RmpStartFailed Failed to start relational message processor.
4001 RmpInitInMemoryFailed Failed to initialize RMP”s in-memory catalog.
4002 RmpCannotCreateLockFile Unable to create RMP lock file {0}.
4003 RmpLoadModelFailed Error loading XMI metamodel.
4004 RmpNetworkNotFound Could not find IP address for RMP host.
4005 RmpInvalidControlNodeUrl The control node URL “{0}” is not valid.
4006 RmpMissingControlNodeUrl Control node URL is not configured.
5010 CannotJoinStreamWindowToTable Cannot join stream (over window) to table.
5020 CannotAggregateInfiniteStream Cannot aggregate an infinite stream: GROUP BY clause is not specified or does not contain any monotonically increasing expressions.
5030 CannotSelectDistinctInfiniteStream Cannot SELECT DISTINCT from infinite stream: select list does not contain any monotonically increasing expressions.
5031 DistinctInAggrNotImplemented Distinct processing for aggregation function parameters is not implemented for streaming queries.
5034 CannotApplySetOpToStream Cannot apply UNION, INTERSECT, or EXCEPT to stream without ALL modifier.
5036 CannotApplyUnionToStreamRelation Cannot combine relation and stream using UNION.
5038 CannotApplyOverToRelation Cannot apply OVER to relation. Operand must be a stream.
5048 InvalidUuid Invalid UUID {0}. (UUID must be of the form “xxxxxxxx-xxxx-xxxx-xxxx-xxxxxxxxxxxx”, where each “x” is a hexadecimal digit.)
5049 InvalidIpAddress Invalid IP address {0}.
5070 PumpMayNotBeExpedited Pumps may not use expedited inserts.
5071 PumpMustHaveStreamingSelect Pumps must contain at least one streaming select statement.
5072 PumptMayNotHaveDynamicParams Pumps may not use dynamic parameters.
5100 RowtimeIsReservedColName {0} is a reserved column name. Encountered near {1}.
5102 RowtimeAliasNotAllowedForJoinNode Alias “ROWTIME” (implicit or explicit) is allowed only for ROWTIME function in the Select list if the FROM clause has a join.
6011 MailPluginStreamError Specifies whether the stream will be an error stream
6013 MailPluginStreamKey Column used to identify the row linked to an error.
6021 MailPluginErrorColumnField Error field to bind this column to
6051 MailPluginInvalidErrorProp The ERROR property {0} is invalid. It must be ‘ASYNC’, ‘SYNC’ or ‘NONE’
6052 MailPluginInvalidErrorColumn {0} is not a recognized error column
6101 SmtpPluginErrorAccessingMultipartBody Error adding body to email: Unable to access multipart body.
9024 RowParserParseFailed Error parsing string {0}, on column {1}: {2}
10005 Log4JPluginErrorLogger Log4J logger to use for errors
10111 Log4JPluginConfigFileError Error processing Log4J configuration file {0}. See log for details.
11100 HttpGetMalformedUrl Error: The url {0} is malformed.
11101 HttpGetUnsupportedProtocol Error: The protocol {0} is unsupported.
11102 HttpGetUnsupportedMaxByteSize Error: The maximum byte size {0} is unsupported.
11103 HttpGetUnsupportedSleepInterval Error: The sleep interval {0} is unsupported.
11104 HttpGetUnsupportedSleepMultiplicand Error: The sleep multiplicand {0} is unsupported. Value must be >= 1.0.
11607 DatabaseAdapterStreamValidationConnError Unable to validate stream columns due to a database connection error. Check SQL/MED server configuration
100040 BetweenWithoutAnd BETWEEN operator has no terminating AND
100050 IllegalIntervalLiteral Illegal INTERVAL literal {0}; at {1}
100060 IllegalMinusDate Illegal expression. Was expecting “(DATETIME - DATETIME) INTERVALQUALIFIER”
100070 IllegalOverlaps Illegal overlaps expression. Was expecting an expression on the form “(DATETIME, EXPRESSION) OVERLAPS (DATETIME, EXPRESSION)”
100080 IllegalNonQueryExpression Non-query expression encountered in illegal context
100090 IllegalQueryExpression Query expression encountered in illegal context
100095 IllegalCursorExpression CURSOR expression encountered in illegal context
100095 IllegalCursorExpression CURSOR expression encountered in illegal context
100100 IllegalOrderBy ORDER BY unexpected
100100 IllegalOrderBy ORDER BY unexpected
100110 IllegalBinaryString Illegal binary string {0}
100110 IllegalBinaryString Illegal binary string {0}
100120 IllegalFromEmpty “FROM” without operands preceding it is illegal
100120 IllegalFromEmpty “FROM” without operands preceding it is illegal
100130 IllegalRowExpression ROW expression encountered in illegal context
100130 IllegalRowExpression ROW expression encountered in illegal context
100140 InvalidSampleSize TABLESAMPLE percentage must be between 0 and 100, inclusive
100140 InvalidSampleSize TABLESAMPLE percentage must be between 0 and 100, inclusive
100150 UnknownCharacterSet Unknown character set “{0}”
100150 UnknownCharacterSet Unknown character set “{0}”
100160 CharsetEncoding Failed to encode “{0}” in character set “{1}”
100160 CharsetEncoding Failed to encode “{0}” in character set “{1}”
100170 UnicodeEscapeCharLength UESCAPE “{0}” must be exactly one character
100170 UnicodeEscapeCharLength UESCAPE “{0}” must be exactly one character
100180 UnicodeEscapeCharIllegal UESCAPE “{0}” may not be hex digit, whitespace, plus sign, or double quote
100180 UnicodeEscapeCharIllegal UESCAPE “{0}” may not be hex digit, whitespace, plus sign, or double quote
100190 UnicodeEscapeUnexpected UESCAPE cannot be specified without Unicode literal introducer
100190 UnicodeEscapeUnexpected UESCAPE cannot be specified without Unicode literal introducer
100200 UnicodeEscapeMalformed Unicode escape sequence starting at character {0,number,#} is not exactly four hex digits
100200 UnicodeEscapeMalformed Unicode escape sequence starting at character {0,number,#} is not exactly four hex digits
120000 ValidatorUnknownFunction No match found for function signature {0}
120000 ValidatorUnknownFunction No match found for function signature {0}
120002 InvalidArgCount Invalid number of arguments to function “{0}”. Was expecting {1,number,#} arguments
120002 InvalidArgCount Invalid number of arguments to function “{0}”. Was expecting {1,number,#} arguments
120003 ValidatorContextPoint At line {0,number,#}, column {1,number,#}
120004 ValidatorContext From line {0,number,#}, column {1,number,#} to line {2,number,#}, column {3,number,#}
120010 CannotCastValue Cast function cannot convert value of type {0} to type {1}
120010 CannotCastValue Cast function cannot convert value of type {0} to type {1}
120011 UnknownDatatypeName Unknown datatype name “{0}”
120011 UnknownDatatypeName Unknown datatype name “{0}”
120020 IncompatibleValueType Values passed to {0} operator must have compatible types
120020 IncompatibleValueType Values passed to {0} operator must have compatible types
120025 IncompatibleTypesInList Values in expression list must have compatible types
120025 IncompatibleTypesInList Values in expression list must have compatible types
120030 IncompatibleCharset Cannot apply {0} to the two different charsets {1} and {2}
120030 IncompatibleCharset Cannot apply {0} to the two different charsets {1} and {2}
120040 InvalidOrderByPos ORDER BY is only allowed on top-level SELECT
120040 InvalidOrderByPos ORDER BY is only allowed on a top-level SELECT
120050 UnknownIdentifier Unknown identifier “{0}”
120050 UnknownIdentifier Unknown identifier “{0}”
120055 UnknownField Unknown field “{0}”
120055 UnknownField Unknown field “{0}”
120060 UnknownTargetColumn Unknown target column “{0}”
120060 UnknownTargetColumn Unknown target column “{0}”
120065 DuplicateTargetColumn Target column “{0}” is assigned more than once
120065 DuplicateTargetColumn Target column “{0}” is assigned more than once
120070 UnmatchInsertColumn Number of INSERT target columns ({0,number}) does not equal number of source items ({1,number})
120070 UnmatchInsertColumn Number of INSERT target columns ({0,number}) does not equal number of source items ({1,number})
120075 TypeNotAssignable Cannot assign to target field “{0}” of type {1} from source field “{2}” of type {3}
120075 TypeNotAssignable Cannot assign to target field “{0}” of type {1} from source field “{2}” of type {3}
120080 TableNameNotFound Table “{0}” not found
120080 TableNameNotFound Table “{0}” not found
120085 ColumnNotFound Column “{0}” not found in any table
120085 ColumnNotFound Column “{0}” not found in any table
120090 ColumnNotFoundInTable Column “{0}” not found in table “{1}”
120090 ColumnNotFoundInTable Column “{0}” not found in table “{1}”
120100 ColumnAmbiguous Column “{0}” is ambiguous
120100 ColumnAmbiguous Column “{0}” is ambiguous
120110 NeedQueryOp Operand {0} must be a query
120110 NeedQueryOp Operand {0} must be a query
120120 NeedSameTypeParameter Parameters must be of the same type
120120 NeedSameTypeParameter Parameters must be of the same type
120130 CanNotApplyOp2Type Cannot apply “{0}” to arguments of type {1}. Supported form(s): {2}
120130 CanNotApplyOp2Type Cannot apply “{0}” to arguments of type {1}. Supported form(s): {2}
120140 ExpectedBoolean Expected a boolean type
120140 ExpectedBoolean Expected a boolean type
120150 MustNotNullInElse ELSE clause or at least one THEN clause must be non-NULL
120150 MustNotNullInElse ELSE clause or at least one THEN clause must be non-NULL
120160 FunctionUndefined Function “{0}” is not defined
120160 FunctionUndefined Function “{0}” is not defined
120170 WrongNumberOfParam Encountered {0} with {1,number} parameter(s); was expecting {2}
120170 WrongNumberOfParam Encountered {0} with {1,number} parameter(s); was expecting {2}
120180 IllegalMixingOfTypes Illegal mixing of types in CASE or COALESCE statement
120180 IllegalMixingOfTypes Illegal mixing of types in CASE or COALESCE statement
120200 InvalidCompare Invalid compare. Comparing (collation, coercibility): ({0}, {1} with ({2}, {3}) is illegal
120200 InvalidCompare Invalid compare. Comparing (collation, coercibility): ({0}, {1} with ({2}, {3}) is illegal
120210 DifferentCollations Invalid syntax. Two explicit different collations ({0}, {1}) are illegal
120210 DifferentCollations Invalid syntax. Two explicit, different collations ({0}, {1}) are illegal
120220 TypeNotComparable {0} is not comparable to {1}
120220 TypeNotComparable {0} is not comparable to {1}
120225 TypeNotComparableNear Cannot compare values of types “{0}”, “{1}”
120225 TypeNotComparableNear Cannot compare values of types “{0}”, “{1}”
120230 WrongNumOfArguments Wrong number of arguments to expression
120230 WrongNumOfArguments Wrong number of arguments passed to expression
120240 OperandNotComparable Operands {0} not comparable to each other
120240 OperandNotComparable Operands {0} are not comparable to each other
120250 TypeNotComparableEachOther Types {0} not comparable to each other
120250 TypeNotComparableEachOther Types {0} are not comparable to each other
120260 NumberLiteralOutOfRange Numeric literal “{0}” out of range
120260 NumberLiteralOutOfRange Numeric literal “{0}” out of range
120265 DateLiteralOutOfRange Date literal “{0}” out of range
120265 DateLiteralOutOfRange Date literal “{0}” out of range
120270 StringFragsOnSameLine String literal continued on same line
120270 StringFragsOnSameLine String literal continued on same line
120280 AliasMustBeSimpleIdentifier Table or column alias must be a simple identifier
120280 AliasMustBeSimpleIdentifier Table or column alias must be a simple identifier
120285 AliasListDegree List of column aliases must have same degree as table; table has {0,number,#} columns {1}, whereas alias list has {2,number,#} columns
120285 AliasListDegree List of column aliases must have the same degree as those of their table. Table has {0,number,#} columns {1}, whereas aliaslist has {2,number,#} columns
120287 AliasListDuplicate Duplicate name “{0}” in column alias list
120287 AliasListDuplicate Duplicate name “{0}” in column alias list
120290 JoinRequiresCondition INNER, LEFT, RIGHT or FULL join requires a condition (NATURAL keyword or ON or USING clause)
120290 JoinRequiresCondition INNER, LEFT, RIGHT or FULL join requires a condition (NATURAL keyword or ON or USING clause)
120300 CrossJoinDisallowsCondition Cannot specify condition (NATURAL keyword, or ON or USING clause) following CROSS JOIN
120300 CrossJoinDisallowsCondition Cannot specify condition (NATURAL keyword, or ON or USING clause) following CROSS JOIN
120310 NaturalDisallowsOnOrUsing Cannot specify NATURAL keyword with ON or USING clause
120310 NaturalDisallowsOnOrUsing Cannot specify NATURAL keyword with ON or USING clause
120312 ColumnInUsingNotUnique Column name “{0}” in USING clause is not unique on one side of join
120312 ColumnInUsingNotUnique Column name “{0}” in USING clause is not unique on one side of join
120314 NaturalOrUsingColumnNotCompatible Column “{0}” matched using NATURAL keyword or USING clause has incompatible types: cannot compare “{1}” to “{2}”
120314 NaturalOrUsingColumnNotCompatible Column “{0}” matched using NATURAL keyword or USING clause has incompatible types: cannot compare “{1}” to “{2}”
120320 WindowNotFound Window “{0}” not found
120320 WindowNotFound Window “{0}” not found
120330 NotGroupExpr Expression “{0}” is not being grouped
120330 NotGroupExpr Expression “{0}” is not being grouped
120335 NotSelectDistinctExpr Expression “{0}” is not in the select clause
120335 NotSelectDistinctExpr Expression “{0}” is not in the select clause
120340 AggregateIllegalInClause Aggregate expression is illegal in {0} clause
120340 AggregateIllegalInClause Aggregate expression is illegal in {0} clause
120341 NonDeterministicIllegalInClause Nondeterministic function call is illegal in {0} clause
120342 AggregateIllegalInGroupBy Aggregate expression is illegal in GROUP BY clause
120342 AggregateIllegalInGroupBy Aggregate expression is illegal in GROUP BY clause
120345 WindowedAggregateIllegalInClause Windowed aggregate expression is illegal in {0} clause
120345 NestedAggIllegal Aggregate expressions cannot be nested
120345 WindowedAggregateIllegalInClause Windowed aggregate expression is illegal in {0} clause
120345 NestedAggIllegal Aggregate expressions cannot be nested
120348 AggregateIllegalInOrderBy Aggregate expression is illegal in ORDER BY clause of non-aggregating SELECT
120348 AggregateIllegalInOrderBy Aggregate expression is illegal in ORDER BY clause of non-aggregating SELECT
120350 CondMustBeBoolean {0} clause must be a condition
120350 CondMustBeBoolean {0} clause must be a condition
120360 HavingMustBeBoolean HAVING clause must be a condition
120360 HavingMustBeBoolean HAVING clause must be a condition
120370 OverNonAggregate OVER must be applied to aggregate function
120370 OverNonAggregate OVER must be applied to aggregate function
120380 CannotOverrideWindowAttribute Cannot override window attribute
120380 CannotOverrideWindowAttribute Cannot override window attribute
120390 ColumnCountMismatchInSetop Column count mismatch in {0}
120390 ColumnCountMismatchInSetop Column count mismatch in {0}
120400 ColumnTypeMismatchInSetop Type mismatch in column {0,number} of {1}
120400 ColumnTypeMismatchInSetop Type mismatch in column {0,number} of {1}
120410 BinaryLiteralOdd Binary literal string must contain an even number of hexits
120410 BinaryLiteralOdd Binary literal string must contain an even number of hexits
120415 BinaryLiteralInvalid Binary literal string must contain only characters “0” - “9”, “A” - “F”
120415 BinaryLiteralInvalid Binary literal string must contain only characters “0” - “9”, “A” - “F”
120420 UnsupportedIntervalLiteral Interval literal {0} for {1} should be in form “{2}”
120420 UnsupportedIntervalLiteral Illegal interval literal format {0} for {1}
120422 IntervalFieldExceedsPrecision Interval field value {0,number} exceeds precision of {1} field
120422 IntervalFieldExceedsPrecision Interval field value {0,number} exceeds precision of {1} field
120425 CompoundOrderByProhibitsRange RANGE clause cannot be used with compound ORDER BY clause
120425 CompoundOrderByProhibitsRange RANGE clause cannot be used with compound ORDER BY clause
120430 OrderByDataTypeProhibitsRange Data type of ORDER BY prohibits use of RANGE clause
120430 OrderByDataTypeProhibitsRange Data type of ORDER BY prohibits use of RANGE clause
120435 OrderByRangeMismatch Data Type mismatch between ORDER BY and RANGE clause
120435 OrderByRangeMismatch Data type mismatch between ORDER BY and RANGE clause
120440 DateRequiresInterval Window ORDER BY expression of type DATE requires range of type INTERVAL
120440 DateRequiresInterval Window ORDER BY expression of type DATE requires range of type INTERVAL
120450 RangeOrRowMustBeConstant Window boundary must be constant
120450 RangeOrRowMustBeConstant Window boundary must be constant
120460 RowMustBeNonNegativeIntegral ROWS value must be a non-negative integral constant
120460 RowMustBeNonNegativeIntegral ROWS value must be a non-negative integral constant
120470 OverMissingOrderBy Window specification must contain an ORDER BY clause
120470 OverMissingOrderBy Window specification must contain an ORDER BY clause
120480 BadLowerBoundary UNBOUNDED FOLLOWING cannot be specified for the lower frame boundary
120480 BadLowerBoundary UNBOUNDED FOLLOWING cannot be specified for the lower frame boundary
120485 BadUpperBoundary UNBOUNDED PRECEDING cannot be specified for the upper frame boundary
120485 BadUpperBoundary UNBOUNDED PRECEDING cannot be specified for the upper frame boundary
120490 CurrentRowPrecedingError Upper frame boundary cannot be PRECEDING when lower boundary is CURRENT ROW
120490 CurrentRowPrecedingError Upper frame boundary cannot be PRECEDING when lower boundary is CURRENT ROW
120500 CurrentRowFollowingError Upper frame boundary cannot be CURRENT ROW when lower boundary is FOLLOWING
120500 CurrentRowFollowingError Upper frame boundary cannot be CURRENT ROW when lower boundary is FOLLOWING
120500 CurrentRowFollowingError Upper frame boundary cannot be CURRENT ROW when lower boundary is FOLLOWING
120510 FollowingBeforePrecedingError Upper frame boundary cannot be PRECEDING when lower boundary is FOLLOWING
120510 FollowingBeforePrecedingError Upper frame boundary cannot be PRECEDING when lower boundary is FOLLOWING
120520 WindowNameMustBeSimple Window name must be a simple identifier
120520 WindowNameMustBeSimple Window name must be a simple identifier
120530 DuplicateWindowName Duplicate window names not allowed
120530 DuplicateWindowName Duplicate window names not allowed
120540 EmptyWindowSpec Empty window specification not allowed
120540 EmptyWindowSpec Empty window specification not allowed
120550 DupWindowSpec Duplicate window specification not allowed in the same window clause
120550 DupWindowSpec Duplicate window specification not allowed in the same WINDOW clause
120560 RankWithFrame ROW/RANGE not allowed with RANK or DENSE_RANK functions
120560 RankWithFrame ROW/RANGE not allowed with RANK or DENSE_RANK functions
120570 FuncNeedsOrderBy RANK or DENSE_RANK functions require ORDER BY clause in window specification
120570 FuncNeedsOrderBy RANK or DENSE_RANK functions require ORDER BY clause in window specification
120580 PartitionNotAllowed PARTITION BY not allowed with existing window reference
120580 PartitionNotAllowed PARTITION BY not allowed with existing window reference
120590 OrderByOverlap ORDER BY not allowed in both base and referenced windows
120590 OrderByOverlap ORDER BY not allowed in both base and referenced windows
120600 RefWindowWithFrame Referenced window cannot have framing declarations
120600 RefWindowWithFrame Referenced window cannot have framing declarations
120610 TypeNotSupported Type “{0}” is not supported
120610 TypeNotSupported Type “{0}” is not supported
120620 FunctionQuantifierNotAllowed DISTINCT/ALL not allowed with {0} function
120620 FunctionQuantifierNotAllowed DISTINCT/ALL not allowed with {0} function
120630 AccessNotAllowed Not allowed to perform {0} on {1}
120630 AccessNotAllowed Not allowed to perform {0} on {1}
120640 MinMaxBadType The {0} function does not support the {1} data type.
120640 MinMaxBadType The {0} function does not support the {1} data type.
120650 OnlyScalarSubqueryAllowed Only scalar subqueries allowed in select list.
120650 OnlyScalarSubqueryAllowed Only scalar subqueries allowed in select list.
120660 OrderByOrdinalOutOfRange Ordinal out of range
120660 OrderByOrdinalOutOfRange Ordinal out of range
120670 WindowHasNegativeSize Window has negative size
120670 WindowHasNegativeSize Window has negative size
120675 UnboundedFollowingWindowNotSupported UNBOUNDED FOLLOWING window not supported
120675 UnboundedFollowingWindowNotSupported UNBOUNDED FOLLOWING window not supported
120677 NotSupportedInRowsBasedWindow {0} in ROWS based window not supported
120680 CannotUseDisallowPartialWithRange Cannot use DISALLOW PARTIAL with window based on RANGE
120680 CannotUseDisallowPartialWithRange Cannot use DISALLOW PARTIAL with window based on RANGE
120690 IntervalStartPrecisionOutOfRange Interval leading field precision “{0}” out of range for {1}
120690 IntervalStartPrecisionOutOfRange Interval leading field precision “{0}” out of range for {1}
120695 IntervalFractionalSecondPrecisionOutOfRange Interval fractional second precision “{0}” out of range for {1}
120695 IntervalFractionalSecondPrecisionOutOfRange Interval fractional second precision “{0}” out of range for {1}
120700 FromAliasDuplicate Duplicate relation name “{0}” in FROM clause
120700 FromAliasDuplicate Duplicate relation name “{0}” in FROM clause
120710 DuplicateColumnName Duplicate column name “{0}” in output
120710 DuplicateColumnName Duplicate column name “{0}” in output
130000 Internal Internal error: {0}
130000 Internal Internal error: {0}
130000 Internal Internal error: {0}
130020 ArgumentMustBeLiteral Argument to function “{0}” must be a literal
130020 ArgumentMustBeLiteral Argument to function “{0}” must be a literal
130030 ArgumentMustBePositiveInteger Argument to function “{0}” must be a positive integer literal
130030 ArgumentMustBePositiveInteger Argument to function “{0}” must be a positive integer literal
130040 ValidationError Validation Error: {0}
130040 ValidationError Validation Error: {0}
130050 ParserError Parser Error: {0}
130050 ParserError Parser Error: {0}
130050 ParserError Parser Error: {0}
130060 ArgumentMustNotBeNull Argument to function “{0}” must not be NULL
130060 ArgumentMustNotBeNull Argument to function “{0}” must not be NULL
130070 NullIllegal Illegal use of “NULL”
130070 NullIllegal Illegal use of “NULL”
130080 DynamicParamIllegal Illegal use of dynamic parameter
130080 DynamicParamIllegal Illegal use of dynamic parameter
130090 InvalidBoolean ”{0}” is not a valid boolean value
130090 InvalidBoolean ”{0}” is not a valid boolean value
130100 ArgumentMustBeValidPrecision Argument to function “{0}” must be a valid precision between “{1}” and “{2}”
130100 ArgumentMustBeValidPrecision Argument to function “{0}” must be a valid precision between “{1}” and “{2}”
130110 InvalidDatetimeFormat ”{0}” is not a valid datetime format
130110 InvalidDatetimeFormat ”{0}” is not a valid datetime format
130120 InsertIntoAlwaysGenerated Cannot explicitly insert value into IDENTITY column “{0}” which is ALWAYS GENERATED
130120 InsertIntoAlwaysGenerated Cannot explicitly insert value into IDENTITY column “{0}” which is ALWAYS GENERATED
130130 ArgumentMustHaveScaleZero Argument to function “{0}” must have a scale of 0
130130 ArgumentMustHaveScaleZero Argument to function “{0}” must have a scale of 0
130140 PreparationAborted Statement preparation aborted
130140 PreparationAborted Statement preparation aborted
400000 MissingHomeProperty Installation error: required Java property {0} not set
400010 CatalogUninitialized Installation error: catalog package not found in repository
400020 CatalogFileLockFailed Failed to lock catalog file {0}
400030 CatalogInitTransientFailed Failed to initialize transient portion of catalog
400040 CatalogExternalLoadFailed Failed to access external repository
400050 CatalogExternalInitFailed Failed to initialize external repository
400060 CatalogPropsAccessFailed Failed to access repository storage properties file {0}
400070 CatalogModelImportFailed Failed to import model from {0}
400080 CatalogModelAlreadyImported Model already imported from {0}
400090 CatalogDumpFailed Failed to dump catalog
400100 CatalogReloadFailed Failed to reload catalog
400110 CatalogBootUrlReadFailed Failed reading boot URL list
400120 CatalogBootUrlUpdateFailed Failed to modify boot URL list
400130 CatalogModelTimestampCheckFailed Stored catalog model timestamp “{0}” does not match compiled catalog timestamp “{1}”
400140 PartialRestore Data is not accessible. A partial restore has been executed.
400150 CatalogReadOnly Catalog data is readonly.
410000 JdbcInvalidTxnState JDBC: invalid transaction state
410010 JdbcInvalidUrl JDBC: invalid URL: {0}
410020 JdbcConnSessionKilled JDBC session killed
410021 JdbcConnSessionClosed JDBC session closed
420000 ValidatorDuplicateNames Duplicate definition for {0} within {1; earlier definition was near {2}
420005 ValidatorPositionContext DDL validation error near {0}
420008 ValidatorNoPositionContext DDL validation error, no information about context
420009 ValidatorDefinitionError {0} in definition of {1}
420010 ValidatorNameInUse {0} already exists within {1} duplicate name encountered near {2}
420040 ValidatorCharsetUnexpected {0} does not accept a CHARACTER SET specification. Encountered in definition of {1} near {2}
420050 ValidatorPrecRequired {0} requires a precision specification. Encountered in definition of {1} near {2}
420060 ValidatorPrecUnexpected {0} does not accept a precision specification encountered in definition of {1} near {2}
420070 ValidatorScaleUnexpected {0} does not accept a scale specification encountered in definition of {1} near {2}
420080 ValidatorCharsetUnsupported Character set {0} unsupported encountered in definition of {1} near {2}
420090 ValidatorLengthExceeded Character length {0,number,#} exceeds maximum of {1,number,#} encountered in definition of {2} near {3}
420100 ValidatorPrecisionExceeded Precision {0,number,#} exceeds maximum of {1,number,#} encountered in definition of {2} near {3}
420110 ValidatorScaleExceeded Scale {0,number,#} exceeds maximum of {1,number,#} encountered in definition of {2} near {3}
420111 ValidatorScaleMustBeZero Scale must be zero in definition of {0}
420120 ValidatorUnknownObject Reference to unknown object {0} encountered near {1}
420130 ValidatorUnknownColumn Column {0} not defined in table {1} encountered near {2}
420150 ValidatorDuplicateClusteredIndex Table {0} already has a clustered index
420170 ValidatorDropRestrict {0} can only be dropped with CASCADE because other objects still reference it
420180 ValidatorDropClusteredIndex Clustered index {0} cannot be dropped; encountered at {1}
420181 ValidatorDropPrimaryKeyIndex Cannot drop primary key {0}
420182 ValidatorDropDeletionIndex Cannot drop deletion {0}
420183 ValidatorDropUniqueConstraintIndex Cannot drop unique constraint {0
420190 ValidatorNoDefaultSchema No default schema specified; execute SET SCHEMA or use fully qualified names
420200 ValidatorNoPrimaryKey PRIMARY KEY constraint required for {0}
420210 ValidatorMultiplePrimaryKeys Multiple PRIMARY KEY constraints not allowed on {0}
420220 ValidatorIndexBadTable Cannot create index on table other than the one being defined
420230 ValidatorBadDefaultClause Invalid DEFAULT clause for column {0} encountered near {1}
420240 ValidatorBadDefaultType Type mismatch in DEFAULT clause for column {0}; column type family is {1} but default value type family is {2} encountered near {3}
420250 ValidatorUnknownSysParam Reference to unknown system parameter {0}
420260 ValidatorSysParamTypeMismatch Type mismatch in value {0} for system parameter {1}
420270 ValidatorImmutableSysParam Cannot change immutable system parameter {0}
420280 ValidatorIndexOnExistingTempTable Cannot create or drop index {0} on existing temporary table {1}
420285 ValidatorIndexLocalTableOnly Cannot create {0} on {1}; only local tables can be indexed
420290 ValidatorBadDefaultParam Cannot reference dynamic parameter in DEFAULT clause for column {0}; encountered near {1}
420300 ValidatorUntranslated {0}
420310 ValidatorViewColumnCountMismatch Column name count does not match query
420320 ValidatorInvalidViewDefinition Invalid definition for view {0}
420321 ValidatorInvalidObjectAttributeDefinition Cannot create {0} because attribute “{1}” exceeds {2,number,#} characters in length
420330 ValidatorInvalidViewDynamicParam Dynamic parameters are illegal in views
420340 ValidatorSchemaDependencyCycle Schema definition contains view cycle
420350 ValidatorInvalidViewOrderBy ORDER BY is illegal in views
420360 ValidatorDataWrapperInvalid Failed to validate definition for {0}
420361 ValidatorDataServerTableInvalid Failed to validate data server definition for {0}
420370 ValidatorForeignTableLookupFailed Failed to look up foreign table name {0}
420380 ValidatorForeignTableButLocalWrapper Cannot create foreign table {0} using local data wrapper {1}
420390 ValidatorLocalTableButForeignWrapper Cannot create local table {0} using foreign data wrapper {1}
420400 ValidatorForeignWrapperHasLocalImpl Cannot create foreign data wrapper {0} because its library implements local storage
420410 ValidatorLocalWrapperHasForeignImpl Cannot create local data wrapper {0} because its library implements foreign storage
420420 ValidatorCalcUnavailable Requested calculator implementation is unavailable
420430 ValidatorNoConstrainAllow Constraint definition not allowed on {0}
420440 ValidatorRoutineSchemaMismatch Schema {0} for specific name does not match {1} for invocation name
420450 ValidatorRoutineDataAccessUnspecified SQL data access must be specified in definition of {0}
420460 ValidatorInvalidRoutineDynamicParam Dynamic parameters are illegal in routine bodies
420465 ValidatorRoutineIllegalCursorParam Non-table {0} cannot take {1} of type CURSOR
420470 ValidatorFunctionOutputParam Parameter mode to {0} may not be declared because it is a function
420480 ValidatorRoutineNoSql NO SQL cannot be specified for {0} because it has SQL definition
420490 ValidatorFunctionReturnType Result expression type {0} from {1} does not match declared return type {2}
420495 ValidatorConstructorAssignmentType Result expression type {0} cannot be assigned to declared type {1} of {2}
420500 ValidatorPathBadCatalog Search path {0} does not match {1} of schema being defined
420510 ValidatorSetStmtNonString SET statement requires character string value expression
420520 ValidatorSetCatalogInvalidExpr Invalid catalog name {0} in SET CATALOG statement
420525 ValidatorSetRoleInvalidExpr Invalid or inaccessible role name {0} in SET ROLE statement
420526 ValidatorRoleCycle Cycle in grant of {0} to {1}
420530 ValidatorSetSchemaInvalidExpr Invalid schema name {0} in SET SCHEMA statement
420540 ValidatorSetPathInvalidExpr Invalid schema name list specification {0} in SET PATH statement
420550 ValidatorSetStmtInvalid Unable to evaluate expression in SET statement
420560 ValidatorRoutineBodyMissing Body required for {0} with language SQL
420570 ValidatorRoutineExternalJavaOnly External {0} cannot specify non-JAVA language
420575 ValidatorRoutineExternalNoBody External {0} cannot specify a body
420580 ValidatorRoutineJavaParamStyleOnly External JAVA {0} cannot specify non-JAVA parameter style
420590 ValidatorRoutineNoParamStyle Parameter style cannot be specified for {0} with language SQL
420600 ValidatorRoutineInvalidJavaMethod Invalid external Java method specification {1} specified for {0}
420610 ValidatorRoutineJavaMethodNotFound Unknown external Java method {1} referenced by {0}
420620 ValidatorRoutineJavaReturnMismatch Return type of {0} is {1} but external Java method {2} has return type {3}
420625 ValidatorRoutineReturnTableUnsupported RETURNS TABLE is illegal for {0}; can only be used with language JAVA and parameter style SYSTEM DEFINED JAVA
420630 ValidatorRoutineJavaMethodNotPublicStatic External Java method {1} referenced by {0} is not both public and static
420640 ValidatorRoutineJavaParamMismatch Type of {0} in {1} is {2} but external Java method {3} takes type {4} for corresponding parameter
420650 ValidatorRoutineJavaProcReturnVoid No return value is produced by {0} but external Java method {1} has non-void return type {2}
420660 ValidatorRoutineInvalidJarName Invalid JAR name {0}
420670 ValidatorRoutineConflict Invocation name and parameter type signature for {0} conflicts with another routine
420680 ValidatorFinalAbstractType Cannot define {0} as both FINAL and NOT INSTANTIABLE
420690 ValidatorNonFinalType Must define {0} as FINAL
420700 ValidatorNonInstantiableType Must define {0} as INSTANTIABLE
420710 ValidatorDistinctTypePredefined Must define representation for {0} as a predefined type
420720 ValidatorConstructorName Name of constructor {0} must match name of {1}
420730 ValidatorConstructorType Return type of constructor {0} must be of type being constructed
420740 ValidatorConstructorAssignmentUnknown Unknown target field {0} in constructor assignment
420750 ValidatorConstructorUndefined Method {0} has been declared but not yet defined
420760 ValidatorMultipleOrderings User-defined ordering already declared for {0}
420770 ValidatorNoOrdering No user-defined ordering declared for {0}
420780 ValidatorOrderingDeterministic DETERMINISTIC must be specified for {0} when used as ordering for {1}
420790 ValidatorOrderingReadOnly MODIFIES SQL DATA may not be specified for {0} when used as ordering for {1}
420800 ValidatorRelativeOrderingDyadic Exactly two parameters required for {0} when used as RELATIVE ordering for {1}
420810 ValidatorOrderingParamType Parameter type {1} required for {0} when used as ordering on that type
420820 ValidatorRelativeOrderingResult INTEGER required for result of {0} when used as RELATIVE ordering for {1}
420830 ValidatorMapOrderingMonadic Exactly one parameter required for {0} when used as RELATIVE ordering for {1}
420840 ValidatorMapOrderingResult Predefined type required for result of {0} when used as MAP ordering for {1}
420850 ValidatorOrderingFunction Cannot use {0} as ordering for {1} because it is not a function
420860 ValidatorJarExtensionModelDrop Cannot drop {0} because it is a catalog model extension
420870 ValidatorInvalidJarUrl Failed to access URL {0} for {1}
420880 ValidatorInvalidGrant Privilege {0} is not applicable to {1}
420885 ValidatorInvalidGrantee Unknown grantee {0}
420887 ValidatorInvalidRole Unknown role {0}
420889 ValidatorInvalidGrantor Invalid grantor
420890 ValidatorImportMustBeForeign Cannot import from local {0}
420900 ValidatorImportUnsupported Support for foreign schema import not available in {0}
420910 ValidatorImportUnknown Unknown foreign schema {0}
420920 ValidatorImportFailed Failed importing foreign schema {0} from {1}
420930 ValidatorImportMissing One or more tables not found while importing foreign schema {0}: {1}
420940 ValidatorAccessDenied Privilege {0} required for access to {1}
420945 ValidatorNoGrantOption Privilege {0} WITH GRANT OPTION required for access to {1}
420946 ValidatorNoAdminOption Role membership WITH ADMIN OPTION required for granting {0}
420950 ValidatorMultipleClusterForColumn Multiple clustered indexes contain {0}
420960 ValidatorNotReplaceable Cannot replace {0} because it does not support replacement
420970 ValidatorReplacedObjectInUse Cannot replace {0} because it is currently in use by a statement
420980 ValidatorDropObjectInUse Cannot drop {0} because it is currently in use by a statement
420981 ValidatorDropObjectInUseBySession Cannot drop {0} because it is currently in use by a session
420990 ValidatorAnalyzeFailed Unable to execute ANALZYE statement
420991 ValidatorAnalyzeNotSupported Cannot analyze {0} because analysis is not supported for objects of that type
420992 ValidatorAnalyzeInvalidRowCount Cannot analyze {0} because its row count metadata is incorrect
421000 ValidatorDuplicateSequenceOption Sequence option {0} cannot be assigned multiple times in definition of {1}
421010 ValidatorInexactSequenceType Exact numeric type required for sequence in definition of {0}
421020 ValidatorZeroSequenceIncrement Increment is required to be nonzero in definition of {0}
421030 ValidatorMultipleTableSequences Cannot specify more than one identity column in definition of {0}
421040 ValidatorInvalidSequenceStart Sequence start {0,number,#} is required to be between min value {1,number,#} and max value {2,number,#}
421050 ValidatorInvalidSequenceMin Sequence min value {0,number,#} cannot be greater than max value {1,number,#}
421060 ValidatorAlterFailed Unable to execute ALTER statement
421065 ValidatorAlterForeignTable ALTER TABLE cannot be used on a foreign table
421066 ValidatorAlterTempTable ALTER TABLE cannot be used on a temporary table
421068 ValidatorAlterTableDataServer ALTER TABLE is not supported by local {0}
421070 ValidatorAlterIdentityFailed Cannot alter sequence for {0} because it was not defined as an identity column
421080 ValidatorUniqueKeyUpdate Cannot update unique key column ({0})
421090 ValidatorNoMatchingSourceCursor Cannot locate source cursor {0} for COLUMN_LIST {1}
421100 ValidatorInvalidColumnListParam COLUMN_LIST parameters for {0} must be declared as java.util.List in the external Java method {1}
421110 ValidatorIndexedColumnsNotDistinct Cannot create {0} because columns must be distinct.
421120 ValidatorAccessObjectNonVisibleToLabel Cannot access {0}, because it is not visible to the current session label setting.
421130 ValidatorSetLabelInUdr A label cannot be set inside a UDR.
421140 ValidatorCircularLabelChain Cannot create a circular label chain.
421150 NonExistentCursorParam Cursor parameter {0} does not exist.
421160 CannotDoDeploymentOnClass Url parameter {0} is a class. Cannot do deployment on a class.
421161 DeploymentActionFailed Failed while executing deployment action for {0}: [{1}]
450000 NullNotAllowed Target {0} cannot be assigned a null value
450010 AssignFromFailed Cannot assign “{0}” to a {1} value: {2}
450020 ParameterValueTooLong Value “{0}” is too long for parameter of type {1}
450021 ParameterValueIncompatible Cannot assign a value of Java class {0} to parameter of type {1}
450022 ParameterValueOutOfRange Value “{0}” is out of range for parameter of type {1}
450023 ParameterValueInvalidFormat Value “{0}” cannot be converted to parameter of type {1}
450024 ParameterValueNotNullable Cannot assign NULL to non-nullable parameter of type {0}
450025 ParameterNotSet Value is missing for parameter {0}
450030 NoDefaultConnection Default connection not available
450040 RoutineInvocationException Invocation of user-defined external Java method {0} failed
450050 NegativeLengthForSubstring The length for a substring can not be negative
450060 InvalidFunctionArgument Invalid argument(s) for “{0}” function
450070 InvalidEscapeCharacter Invalid escape character of {0}
450080 InvalidEscapeSequence Invalid escape sequence: {0} at {1,number,#}
450090 InvalidRegularExpression Invalid regular expression: {0} at {1,number,#}
450100 Overflow Overflow during calculation or cast.
450110 DmlFailure DML statement execution failed.
450120 ExecutionAborted Execution aborted
450130 SequenceLimitExceeded Sequence generator limit exceeded for {0}
450140 LockDenied Failed to acquire lock on {0}
450150 JavaCalcError Could not calculate result column {0} for the following row:
450151 JavaCalcDetailedError Could not calculate result column {0} of {1} for input: {2} Messages: {3}
450151 JavaCalcDetailedError Could not calculate result column {0} of {1} for input:
450152 JavaRowError Could not process input: {0} Messages: {1}
450152 JavaCalcConditionError Could not calculate condition for input:
450152 JavaRowError Could not process input:
450160 ErrorLimitExceeded Exceeded limit of {0,number,#} errors. Last error was: {1}
450160 ErrorLimitExceeded Exceeded limit of {0,number,#} errors. Last error was:
450170 RecoverableErrorWarning Statement execution encountered recoverable exceptions;errors: {0,number,#}; warnings: {1,number,#}; see {2} for details
450170 RecoverableErrorWarning Statement execution encountered recoverable exceptions;errors: {0,number,#}; warnings: {1,number,#}; see {2} for details
450180 JavaRowTooLong Row size exceeds maximum ({0,number,#} bytes); row data: {1}
450190 QueryAccessNewColumn Cannot query new column (via {0}) currently being added by ALTER TABLE
460020 DataServerInitFailed Failed to initialize data server
460030 ForeignTableAccessFailed Failed to access foreign table {0}
460040 JdbcDriverLoadFailed Could not load JDBC driver class {0}
460050 JdbcDriverTypeInfoFailed Could not obtain type information from JDBC driver
460060 DataServerRuntimeFailed Failed to access data server for execution
460080 DataServerIndexCreateFailed Failed to create storage for {0}
460090 DataServerIndexDropFailed Failed to drop storage for {0}
460095 DataServerIndexVerifyFailed Failed to compute statistics for {0}
460100 MockForeignObjectNotFound Mock foreign object {0} not found
460110 JdbcDriverTypeUnsupported Cannot support JDBC type {2} (ordinal {3,number,#}, precision {4,number,#}, scale {5,number,#}) found in column {1} of table {0}
460120 MedInvalidUdxId Invalid specific name for UDX loaded via SQL/MED or optimizer: {0}
460130 MedUnknownUdx Unknown specific name {0} for UDX loaded via SQL/MED or optimizer
460140 MedPropertyMismatch Values (“{0}”, “{1}”) for property {2} do not match
460150 RetryableFailure Retryable communication failure
460160 DeletedFieldWarning {0} field {1} does not exist in external data source. It will be filled in with nulls.
460160 DeletedFieldWarning ”{0}” field “{1}” does not exist in external data source. It will be filled in with nulls.
460170 TypeChangeWarning {0} field {1} has datatype {2} in external data source; it will be cast to datatype {3}.
460170 TypeChangeWarning ”{0}” field “{1}” has datatype “{2}” in external data source. It will be cast to datatype “{3}”.
460180 IncompatibleTypeChangeWarning {0} field {1} has datatype {2} in external data source which cannot be cast to datatype {3}. It will be filled in with nulls.
460180 IncompatibleTypeChangeWarning” ”{0}” field “{1}” has datatype “{2}” in external data source, which cannot be cast to datatype “{3}”. It will be filled in with nulls.
460190 AddedFieldWarning {0} has field {1} added in external data source.
460190 AddedFieldWarning” ”{0}” has field “{1}” added in external data source.
460200 NumberOfColumnsMismatch Number of fields in foreign table: “{0}”. Number of fields in external data source: {1}“.
460210 TypesOfColumnsMismatch External data source field “{0}” has datatype “{1}” which cannot be cast to datatype “{2}” of foreign table field “{3}”.
460220 DataServerIndexVersionFailed Failed to version index root page for {0}
460230 MedJdbc_InvalidTableSchemaMapping Cannot specify more than one of SCHEMA_MAPPING, TABLE_MAPPING, or TABLE_PREFIX_MAPPING
460240 MedJdbc_InvalidTableMapping ”{0}.{1}” and “{2}.{3}” cannot both map to “{4}.{5}”.
460245 MedJdbc_InvalidTablePrefixMapping ”{0}.{1}” and “{2}.{3}” cannot both map to “{4}.{5}”.
460250 MedJdbc_InvalidDataSource Cannot find JNDI resource “{0}”
469000 InvalidDirectory Directory {0} does not exist
469010 FileWriteFailed Cannot open {0} to write to
469020 FileNotFound Control file {0} not found
469030 InvalidControlFile Control file {0} is not valid
469040 FlatFileInvalidFixedPosParams Fixed position parsing, enabled by setting an empty field delimiter, requires an empty quote character and an empty escape character
469050 FlatFileNoFixedPosSample Cannot derive column sizes for fixed position data file “{0}”
469060 CannotDeriveColumnTypes Cannot derive column types for flat file {0}
469070 InvalidControlFileTooManyCols Too many columns in control file {0}
469080 InvalidControlFileTooFewCols Too few columns in control file {0}
469090 InvalidControlFileOnRow Invalid row {1} in control file {0}
469100 FlatFileMappedRequiresWithHeader Mapping source columns in data files to target columns specified by control files requires column names to be provided by data file headers.
469110 FlatFileMappedRequiresLenient Mapping source columns in data files to target columns specified by control files requires server to be lenient
470000 DatabaseLoadFailed Failed to load database
470010 SessionNoCommitInAutocommit Cannot COMMIT in auto-commit mode
470020 SessionNoRollbackInAutocommit Cannot ROLLBACK in auto-commit mode
470030 SessionDupSavepointName Savepoint name {0} already in use
470040 SessionNoSavepointInAutocommit Cannot create savepoint in auto-commit mode
470050 SessionWrongSavepoint Savepoint {0} is from wrong session
470060 SessionInvalidSavepointId Invalid savepoint ID {0,number,#}
470070 SessionInvalidSavepointName Invalid savepoint name {0}
470080 SessionNoExecuteImmediateParameters Cannot EXECUTE IMMEDIATE a statement with dynamic parameters: {0}
470090 SessionInternalQueryFailed Failed executing internal query
470100 SessionLoginFailed Login failed for {0}: invalid username/password combination
470101 SessionLogoutFailed There was an error when logging out user {0}
470101 SessionLogoutFailed There was an error when logging out user {0}
470110 SessionOptimizerFailed Optimizer failed to find a valid physical implementation for relational expression {0}; see trace for partially optimized plan. Details: reason is [{1}]; while preparing statement [{2}].
470120 SessionNotFound Session {0,number,#} not found
470130 SessionReentrantStmtFailed Failed while executing internal statement
470140 SessionClientProcessIdNotNumeric clientProcessId {0} could not be parsed as an integer
470140 SessionClientProcessIdNotNumeric” ”{0}” could not be parsed as an integer
470150 InvalidParam Invalid parameter setting. Setting must be between {0} and {1}.
470160 NoDatabaseLoaded Existing database server required
470170 InvalidLabelProperty Invalid label property “{0}”.
470180 ReadOnlySession Session is read-only because it has a label setting.
490000 PluginInvalidIntProp Invalid value “{0}” for integer property {1}
490001 PluginInvalidLongProp Invalid value “{0}” for long property {1}
490002 PluginInvalidShortProp Invalid value “{0}” for short property {1}
490003 PluginInvalidFloatProp Invalid value “{0}” for float property {1}
490004 PluginInvalidDoubleProp Invalid value “{0}” for double property {1}
490005 PluginInvalidByteProp Invalid value “{0}” for byte property {1}
490006 PluginInvalidStringProp Invalid value “{0}” for string property {1}
490010 PluginJarLoadFailed Failed to load plugin jar “{0}”
490020 PluginInitFailed Failed to initialize plugin {0}
490030 PluginMethodMismatch Failed to resolve Java method
490040 PluginMalformedJarUrl Malformed URL {0} in definition of {1}
490050 PluginJarClassLoadFailed Failed to load class {0} from plugin jar “{1}”
490060 PluginPropRequired Value required for property {0}
490070 PluginPropsConflict Property {0} conflicts with property {1}
490080 PluginManifestMissing Plugin jar “{0}” manifest lacks attribute “{1}”
490090 PluginManifestSqljInvalid Invalid SQL/J manifest for jar URL {0}
490091 PluginDeploymentFileInvalid Invalid SQL/J deployment file {0} in jar URL {1}
490092 PluginDeploymentFileUnterminated Reached end of deployment descriptor file without proper semicolon termination for last statement
490093 PluginDeploymentFileDuplicate Duplicate {0} action group in deployment descriptor file
490094 PluginDeploymentImplementorMismatch Mismatched implementor block identifiers BEGIN {0} and END {1}
490095 PluginDeploymentImplementorUnbalanced Missing END for implementor block {0}
500000 ProgramCompilationError Calculator program compilation error: {0}
500000 ProgramCompilationError Calculator program compilation error: {0}
500010 ProgramImplementationError Calculator program implementation error: {0}
500010 ProgramImplementationError Calculator program implementation error: {0}
500020 CompilationAssertionError Calculator program compilation assertion error: {0}
500020 CompilationAssertionError Calculator program compilation assertion error: {0}
520000 ExportSchemaSpecifyListOrPattern Parameter list invalid: Cannot specify both TABLE_LIST and TABLE_PATTERN parameters
520001 ExportSchemaTableNotFound One or more tables in TABLE_LIST not found: [{0}]
520002 ExportSchemaCreateTempSchemaError Error during creation of temp schema {0}: {1}
520002 ExportSchemaCreateTempSchemaError Error during creation of temp schema {0}: {1}
520003 ExportSchemaImportForeignSchemaError Error during import foreign schema into temp schema {0}: {1}
520003 ExportSchemaImportForeignSchemaError Error during import foreign schema into temp schema {0}: {1}
520004 ExportSchemaDropTemp SchemaError Error dropping temp schema {0}: {1}
520004 ExportSchemaDropTempSchemaError Error dropping temp schema {0}: {1}
520005 ExportSchemaNoTables No tables to export for catalog={0} schema={1} exclude={2} table_list={3} table_pattern={4}
520006 ExportSchemaNoTablesImported No tables to export for foreign_server={0} foreign_schema={1} exclude={2} table_list={3} table_pattern={4} temp schema={5}
520007 ExportSchemaCreateDirFailed Failed to create export directory {0}: {1}
520008 ExportSchemaCreateFileWriterFailed Failed to create file writer for file {0}: {1}
520009 ExportSchemaFileWriterError FileWriter error for file {0}: {1}
520009 ExportSchemaFileWriterError FileWriter error for file {0}: {1}
520010 ExportSchemaSpecifyLastModified Parameter list invalid: last modified timestamp and column name must be specified
520011 ExportSchemaInvalidExpType Invalid Export type: {0}
520012 ExportSchemaMergeTablesDiffer Tables differ in schemas to be merged
520013 InvalidDateString Date format “{0}” could not be applied to string “{1}”
520014 InvalidConvertDatetimeCaller Caller type “{0}” for datetime conversion functions is unknown
520015 InvalidBackupType Invalid backup type “{0}”. Must be either FULL, INCREMENTAL, or DIFFERENTIAL.
520016 InvalidCompressionMode Invalid compression mode “{0}”. Must be either COMPRESSED or UNCOMPRESSED.
520017 InvalidBackupPropertyValue Invalid backup property value “{0}”
520018 InvalidBackupPropertySetting Invalid backup property setting “{0}”
520019 NoFullBackup A full backup has not been executed yet
520020 BackupInProgress Another database backup is already in progress
520021 NeedExclusiveAccess Exclusive database access required
520022 MissingPropertySetting Backup property file is missing a property setting for “{0}”
520024 BackupFileAlreadyExists The file “{0}” already exists in the archive directory
520025 BackupFileDoesNotExist The file “{0}” does not exist in the archive directory
520026 BackupFileNotReadable The file “{0}” is not readable in the archive directory
520027 BackupArchiveDirNotWritable The backup archive directory “{0}” is not writable
520028 BackupArchiveDirNotReadable The backup archive directory “{0}” is not readable
520030 FileDeletionFailed Failed to delete “{0}”
520040 ServerTestConnFailed Failed testing connection to data server “{0}”
520050 ChangeToUnicodeFailed Cannot change default character set to Unicode because local tables have already been defined
520060 ShutdownPreventedBySessions Cannot shut down because other sessions remain
520070 NoDdlGenObjsFound No matching objects found for DDL generation

Calculator error codes and SQLSTATE numbers

The following table shows the SQLSTATE number for each type of calculator error code, with possible causes for that SQLSTATE to arise. For most of them, the table also shows relevant details and possible corrections or workarounds.

Each of these error codes is treated by SQLstream as an error, causing the current row to be rejected.

SQLSTATE Value Possible Causes Possible Details, Corrections, or Workarounds
21000 More than one value resulted from a SELECT INTO, a scalar fullselect, or a subquery.
22000Data exception Numeric underfloworCalculation returned inexact result
22001

See also[SQLSTATE 22012] and [SQLSTATE 22023] above.
Right truncation occurred in string data;Examples:1. An update or insert value that uses a string too long for the intended column.2. A datetime value that is too small to be assigned to a host variable. An encountered value cannot be converted as the statement requires. Error type meanings include:
- 1 – Overflow
- 2 – Floating point overflow
- 3 – Floating point underflow
- 4 – Floating point conversion error
- 5 – Inexact resultSolution or workaround:Change the size, value or type of the column or value so that it can be converted and is valid. Try the request again.
22003 Out-of-range numeric value Same possible causes and error types as [22001 above].
22004Null value not allowed Assign NULL to a column declared NOT NULL. An expression assigning to a column declared NOT NULL returned a NULL value.
22007Invalid datetime format A datetime occurred in an invalid format: an invalid string representation or value String representation of a date, time, or timestamp value differs from correct syntax for the specified or implied data type and format.Solution or workaround:Make the date, time, or timestamp value conform to the syntax for the represented data type, and try again.
2200B Escape character conflict See also [22019].
2200C Invalid use of escape character See also [22019].
22012 Substring error, for example, a SUBSTR argument out of range Arguments are either out of range or not evaluating to an integer: best bets are either argument 2 of the LEFT function (the length of the result) or arguments 2 or 3 of the SUBSTRING function.For the LEFT function, argument 2 must not exceed argument 1’s length.For the SUBSTRING function, argument 2 is the location of the first target character within argument 1. Argument 3 is the length of the intended result, starting at the character whose position is specified by argument 2. Argument 3 must not exceed the number of characters between that position and the end of argument 1.
22012See also [SQLSTATE 22023]. Division by zero Division by zero. Correct the data and then retry.
22018 Invalid character value for CAST, DECIMAL, or INTEGER scalar function Solution or workaround:
- Change the result data type to recognize the characters actually used in the CAST argument, or
- Change the argument actually used in the CAST to a value valid in the result data type. Then retry.
22019 Invalid escape character, as used in a LIKE string pattern What is invalid is either the escape character or its use in the LIKE pattern.The LIKE pattern is invalid if its character string expression contains an escape character not followed by a percent sign, an underscore, or another escape character.
2201B Invalid regular expression
22023
See also[SQLSTATE 22012] above.
Invalid parameter or host variable value(+sq3000 re cursor not open) Same possible causes and error types as [22001 above], as well as the following possible causes:
- When assigning a column value using INSERT or UPDATE, a conversion error occurred of the specified type. (Or when converting a numeric constant to the same attributes as the column.)Solution or workaround:Change the statement to ensure the result value is valid and fits in the column, or re-create the table, stream or view with a new column type or length so that the result value fits.
22025 Invalid escape sequence, as used in a LIKE string pattern See also [22019] above.
22027 Trim error