Appendix B - List of Error Messages

<< Click to Display Table of Contents >>

Navigation:  Streaming SQL Reference Guide >

Appendix B - List of Error Messages

Previous pageReturn to chapter overviewNext page

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

LogFileLogToolMissing

LogName

Error: You must specify the name of a log file or use {0} to specify all log files.

2014

LogFileLogToolRemove

RegisterBadParams

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

LogFileDefaultCharsetName

Illegal

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

LogrotateConfigRead

Security Error

Read access to the logrotate configuration file {0} has been blocked by the Java security framework.

2102

LogrotateConfigRead

DirSecurity 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

LogrotateMalformedGlob

Error

The logrotate configuration file {0} contains a malformed file pattern {1}.

2106

LogrotateUnknownRotation

Criterion

Internal Error: The rotation criteria value {0} is unknown.

2107

LogrotateInvalidRotation

Threshold

Internal Error: The rotation threshold value {0} is invalid. It must be positive.

2108

LogrotateInvalidRotation

Count

Internal Error: The rotation count value {0} is invalid. It must be non-negative.

2109

LogrotateInvalidRotation

Start

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

LogFileXMLFileMarshal

Error

Error marshalling the Log File Plug-in configuration to the file {0}.

2204

LogFileXMLMarshalError

Error marshalling the Log File Plug-in configuration.

2205

LogFileXMLFileUnmarshal

Error

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

MailPluginErrorColumn

Field

Error field to bind this column to

6051

MailPluginInvalidError

Prop

The ERROR property {0} is invalid. It must be 'ASYNC', 'SYNC' or 'NONE'

6052

MailPluginInvalidError

Column

{0} is not a recognized error column

6101

SmtpPluginErrorAccessing

MultipartBody

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

HttpGetUnsupported

Protocol

Error: The protocol {0} is unsupported.

11102

HttpGetUnsupported

MaxByteSize

Error: The maximum byte size {0} is unsupported.

11103

HttpGetUnsupported

SleepInterval

Error: The sleep interval {0} is unsupported.

11104

HttpGetUnsupported

SleepMultiplicand

Error: The sleep multiplicand {0} is unsupported. Value must be >= 1.0.

11607

DatabaseAdapterStream

ValidationConnError

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 alias list 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

FollowingBeforePreceding

Error

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&lt;String&gt; 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

IncompatibleTypeChange

Warning

{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

SessionClientProcessId

NotNumeric

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}</text>

500000

ProgramCompilationError

Calculator program compilation error: {0}

500000

ProgramCompilationError

Calculator program compilation error: {0}

500010

ProgramImplementation

Error

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}</text>

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

ExportSchemaCreateTemp

SchemaError

Error during creation of temp schema {0}: {1}

520002

ExportSchemaCreateTempSchemaError

Error during creation of temp schema {0}: {1}

520003

ExportSchemaImport

ForeignSchemaError

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

ExportSchemaFileWriter

Error

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.

 

22000

Data exception

Numeric underflow

or

Calculation returned inexact result

 

22001

See also

SQLSTATE 22012

and

SQLSTATE 22023.

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 result

Solution 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.

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

Invalid 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.

22012

See 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.

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.

22027

Trim error