This topic covers:
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 | Possible Causes | Possible Details, Corrections, or Workarounds |
---|---|---|
21000 | More than one value resulted from a SELECT INTO, a scalar SELECT, or a subquery. | |
22000 | Data exception | Numeric underflow or Calculation returned inexact result |
22001 | Right truncation occurred in string data | An encountered value cannot be converted as the statement requires. Error type meanings include:
Examples:
|
22003 | Out-of-range numeric value | Same possible causes and error types as 22001. |
22004 | Null value not allowed. Assign NULL to a column declared NOT NULL. | An expression assigning to a column declared NOT NULL returned a NULL value. |
22007 | 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. 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 SUBSTRING argument out of range | Arguments are either out of range or not evaluating to an integer: check arguments 2 or 3 of the SUBSTRING function. Argument 2 is the location of the first target character within argument. Argument 3 is the length of the intended result, starting at the character whose position is specified by argument. Argument 3 must not exceed the number of characters between that position and the end of argument 1. |
22012 | Division by zero | Correct the denominator data and then retry. See also 22023. |
22018 | Invalid character value for CAST, DECIMAL, or INTEGER scalar function | - 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 | The regular expression used in REGEX_REPLACE, REGEX_LOG_PARSE or SIMILAR TO is invalid. Check that regex metacharacters have been escaped correctly. |
22023 | Invalid parameter or host variable value | Same possible causes and error types as 22001, 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.) 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. See also 22012 above. |
22025 | Invalid escape sequence, as used in a LIKE string pattern | See also 22019 above. |
22027 | Trim error | |
SQLstream-specific SQLSTATE values | ||
50000 | Coercion error | |
50001 | Ingestion error | |
50002 | Late row error | |
50003 | Fatal validation error | |
50004 | Invalid startPosition argument | |
50005 | Negative occurrence argument | |
50006 | Bad regular expression | See also 2201B |
50007 | Fatal Pump Error | |
50008 | Regular expression match failure | The regular expression failed to match the incoming data, so was unable to extract data for REGEX_REPLACE or REGEX_LOG_PARSE. |
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 |
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 |