DTM1002

Internal error. <Stacktrace>

Cannot recover from an internal state violation

Critical server error.

Provide full error information and query trace logs to Datometry support.

DTM1005

Unknown error or bad error format

Triggered if no other message is found or formatting failed

Critical server error.

Provide full error information and query trace logs to Datometry support.

DTM1006

Process ~p unresponsive with stack~n~p

Heart beat found process unresponsive

Critical server error.

Provide full error information and query trace logs to Datometry support.

DTM1015

Internal error. Error: <Stacktrace>

Cannot recover from an internal state violation

Critical server error.

Provide full error information and query trace logs to Datometry support.

DTM1004

Connection shut down by administrator.

Process killed due to explicit request by admin

DTM1016

Client shutdown connection

DTM2001

Authentication failed.

Cannot authenticate user correctly, e.g., wrong password

Verify the user name and password are correct. If the condition persists, provide the error info and the full statement text to Datometry support for further investigations.

DTM2002

Unsupported authentication method: '~ts'.

Auth method as required by server not supported by sds

DTM2003

No valid admission policy found for host \~ts\", database \"~ts\", user \"~ts\", protocol \"~ts\" (retriable)".

Cannot find appropriate mapping

Provide the error information and the full statement text if applicable to Datometry Customer Success.

DTM2004

Authentication timed out.

Async authentication exceeded timeout

DTM2005

Authentication method '~ts' not supported for asynchronous connect.

Backend required an auth method not supported in loopback

DTM3012

Database connection error '~ts'.

Server socket errored out unexpectedly

DTM3013

Database refused connection at '~ts:~B' via gateway '~ts'.

Cannot connect to database at given location

DTM3014

Database refused connection due to temporarily unavailable resources.

Server could not fork backend process

DTM3020

TLS not supported for connection.

TLS connection is not supported

DTM3021

Endpoint port 'port_number' unavailable

Another process is using this port

DTM3022

Upgrading connection to TLS failed: '~p'.

TLS accept did not succeed

DTM3031

The datepart tzoffset is not supported by date function datepart for data type datetime

Capacity of pool '~ts' exhausted and no more waiters permitted.

Pool is at capacity and all backlog slots are full

See the knowledge base article: DTM3031 : The datepart tzoffset is not supported by date function datepart for data type datetime

Provide the error information and the full statement text if applicable to Datometry Customer Success.

DTM3101

Not yet implemented for ODBC gateway: ~p.

Feature not yet implemented

Possibly observed when unsupported ODBC features are encountered. Provide full error information and query trace logs to Datometry support.

DTM3102

Failed to connect to the underlying database: ~p.

ODBC connection failed

See the knowledge base article: DTM3102: Failed to connect to the underlying database

Hyper-Q cannot connect to the target database. Verify the gateway connection string attributes (server name/address, port) and your network connectivity to the target database, and ensure that the database instance is running.

DTM3103

Failed to run query on the underlying database: ~ts.

ODBC query execution failed

The underlying database reported an error while executing a translated query. This failure may cover a wide variety of runtime error conditions ranging from runtime errors, resource constraints, security violations, etc. Inspect the error message from the underlying database to identify the root cause of the problem and address any actionable security and resources related issues.
The most common sources of query failures on the backend database are:

• Casting an invalid value
• Overflow in computations

If the condition persists, provide the error info and the full statement text to Datometry support for further investigations.

DTM3104

Failed to decode value: [~p, ~p, ~p].

ODBC driver failed to decode values, e.g, infinity, NaN

DTM3105

ODBC Gateway misconfigured: missing 'connection_string' field.

ODBC Gateway misconfigured

Configuration issue. Review and adjust your settings in dtm.ini. Contact Datometry support if the issue persists

DTM3106

Failed to close the connection to the database: '~p'.

ODBC disconnection failed

DTM3107

Cancel requested during authentication, shutdown connection

DTM3110

ODBC port executable not found.

Failed to locate the ODBC port executable

DTM3111

ODBC process received invalid request: '~p'.

ODBC process received invalid request

DTM3112

Connection to the underlying database closed: '~p'.

ODBC connection to the c-port odbcserver closed

Possible network configuration issues. This error code indicates that the connection from Hyper-Q to the underlying database has been terminated. These errors may also be reported when the underlying instance is brought down for maintenance or any other reason.

DTM3116

Lost connection to underlying database

See knowledge base article: DTM3116: Lost connection to underlying database

DTM5305

MDStore connection failed when retrieving metadata for ~ts: ~ts.

DTM8034

Unable to retrieve metadata for ~p from database: ~ts.

Metadata interface failed with unspecified error, e.g., missing credetials, etc.

Hyper-Q is unable to retrieve database metadata to process queries. This error may be related to connectivity or the availability of the underlying database. Verify the MDStore connection parameters. If the condition persists, please provide the error info and the full statement text to Datometry support for further investigations.

DTM8103

Initialization of connection failed.

Failure occurred before initialization of connection was completed, e.g., bad auth

DTM8271

Failed to extract metadata.

Failed to extract metadata from ODBC results

DTM9034

Unsupported reconnect request.

Teradata client application has lost connectivity to Hyper-Q and is trying to reconnect to the session it was previously connected to.

To retry the transaction, open a new connection from the client and resubmit the transaction that was interrupted by the connectivity loss.

In case of frequent occurrence of connectivity loss between the client application and Hyper-Q, check firewalls and routers between client and Hyper-Q for settings that drop idle TCP connections or filter out TCP keepalive message.

DTM8101

Syntax error

Syntax errors can result from invalid input statements or may be related to unsupported language features. 

Make sure that the statement is valid. Inspect the statement text at the line/column number specified to check for any syntax issues. You may also try running the statement against your existing Teradata system to validate it. If the statement runs successfully against Teradata, provide the error info and the full statement text to Datometry support for further investigations.

DTM8102

Syntax error before: '~ts', at line '~p'

Syntax errors can result from invalid input statements or may be related to unsupported language features. 

Make sure that the statement is valid. Inspect the statement text at the line/column number specified to check for any syntax issues. You may also try running the statement against your existing Teradata system to validate it. If the statement runs successfully against Teradata, provide the error info and the full statement text to Datometry support for further investigations.

DTM8110

Syntax error before: ~ts, at line ~p, column ~p

Syntax errors can result from invalid input statements or may be related to unsupported language features. 

Make sure that the statement is valid. Inspect the statement text at the line/column number specified to check for any syntax issues. You may also try running the statement against your existing Teradata system to validate it. If the statement runs successfully against Teradata, provide the error info and the full statement text to Datometry support for further investigations.

DTM5012

Unknown endpoint type: '~ts'.

No suitable alpha process for endpoint type

DTM5013

Unknown gateway type: '~ts'.

Decoding of version string unsuccessful

DTM5202

Flag '~b' unknown.

Traceflag translation failed due to unknown flag

DTM8032

Unknown variable '~ts'.

No definition for variable found

This error is returned when:

• the statement points to a variable not defined on the target database.
  Define the variable on the target system
  
• the statement refers to a column that does not exit.
  Verify that your query is consistent with the current state of the schema
  

If the issue is not fixed then provide the error info and the full statement text to Datometry support for further investigation.

DTM8035

Unsupported or invalid endpoint/gateway combination (endpoint:~ts, gateway:~ts).

Unknown conversion requested

DTM8036

Invalid query translation request (endpoint:~p, gateway:~p).

Unknown conversion requested

DTM8280

An unknown character string translation was requested.

This message displays when an unknown option was used. Execute the same statement against your Teradata system and if it works please provide the error info and the full statement text to Datometry Customer Success.

DTM9035

Unknown incoming message type.

DTM9094

Unknown identifier '~ts' at line ~p, column ~p

The error is returned when the statement contains a non-existing column or alias.

Verify that your query is consistent with the current state of the schema. If the issue is not fixed then please provide the error info and the full statement text to Datometry support for further investigation.

DTM5102

License for '~ts': expired.

Trial license no longer valid

Contact Datometry support to get a valid license

DTM5103

License file '~ts' contains invalid license.

License has been tampered with

Contact Datometry support to get a valid license

DTM5106

Process already holds lease.

Process tried to lease license twice

DTM5107

License for '~ts': capacity exhausted.

All seats are taken

Contact Datometry support to review the license configuration.

DTM5108

No licenses registered.

No license loaded for this product

Contact Datometry support to get a valid license

DTM5109

License key incomplete.

License key lacks required components

Contact Datometry support to get a valid license

DTM5110

Functionality not supported under present license.

License SKU does not include the functionality

Contact Datometry support to get a valid license

DTM5111

No license key file found in directory: '~ts'.

No license key found

Configuration issue. Refer to Datomety install guide for details about provisioning license files

DTM5112

Multiple license keys found in directory: '~ts'.

Multiple license keys found

Configuration issue. Refer to Datomety install guide for details about provisioning license files

DTM8001

Cross-compiler module not installed or no license available (endpoint:~ts, gateway:~ts).

Unknown conversion requested or all licenses already taken

Contact Datometry support to get a valid license

DTM2101

LDAP: Failed to establish connection with server '~ts'.

LDAP: Server is not reachable or refuses connection

Verify your LDAP connection parameters.

If the issue persists provide the error info and the full statement text to Datometry support for further investigation.

DTM2102

LDAP: Bind to DN '~ts' failed; no such DN or insufficient credentials.

LDAP: Unsuccessful bind, e.g., non-existent DN, credentials invalid, etc

Verify the DN exists in your LDAP schema. Make sure you have the right access level.

If the issue persists provide the error info and the full statement text to Datometry support for further investigation. 

DTM2103

LDAP: Search failed (~p).

LDAP: Cannot execute search with given filter

Verify your search syntax is valid.

If the issue persists provide the error info and the full statement text to Datometry support for further investigation.

DTM2104

LDAP: User '~ts' is not unique.

LDAP: Search produced more than one entry

Verify that the user is unique in LDAP.

If the issue persists provide the error info and the full statement text to Datometry support for further investigation.

DTM2105

LDAP: No such user '~ts'.

LDAP: Search did not produce any records; no such user

Verify user is valid in LDAP.

If the issue persists provide the error info and the full statement text to Datometry support for further investigation.

DTM2106

LDAP: User name '~ts' contains invalid characters.

LDAP: Search did not produce any records; invalid characters

Verify username is valid.

If the issue persists provide the error info and the full statement text to Datometry support for further investigation.

DTM2121

LDAP Sync: Unknown cache.

LDAP Sync: Unknown cache referenced

Validate your LDAP cache strategy.

If the issue persists provide the error info and the full statement text to Datometry support for further investigation.

DTM2122

LDAP Sync: One or more operations failed.

LDAP Sync: Operation completed with errors,

Re-run operation.

If the issue persists provide the error info and the full statement text to Datometry support for further investigation.

DTM2123

LDAP Sync: Modification regarding user '~ts' failed.

LDAP Sync: Modification failed

Re-run operation.

If the issue persists provide the error info and the full statement text to Datometry support for further investigation.

DTM2124

LDAP Sync: Embedded query failed to execute or returned unrecognized format.

LDAP Sync: Expected a specific format from an embedded query,

Verify validity of your query.

If the issue persists provide the error info and the full statement text to Datometry support for further investigation.

DTM2125

LDAP Sync: Role name '~ts' contains illegal characters.

LDAP Sync: Role name contains invalid characters

Verify role name characters.

If the issue persists provide the error info and the full statement text to Datometry support for further investigation.

DTM2201

GSSAPI: ~ts.

Generic GSS error; details to be filled by GSS plugin

DTM2202

GSSAPI: Name '~ts' does not match configured realm '~ts'.

Realm returned from GSSAPIs does not match configuration

DTM2203

GSSAPI: User '~ts' name does not match authenticated user '~ts'.

GSS returned a different user name that was originally given

DTM1003

Fault injection.

Explicit injection of fault; only in debug version.

Provide the error information and the full statement text if applicable to Datometry Customer Success.

DTM1009

OpenSSL not found.

No suitable OpenSSL library found.

Provide the error information and the full statement text if applicable to Datometry Customer Success.

DTM1010

Encountered malformed packet.

Packet does not conform to expected protocol.

Provide the error information and the full statement text if applicable to Datometry Customer Success.

DTM1011

Cannot find a module ~p for system version ~p.

No suitable module found.

Provide the error information and the full statement text if applicable to Datometry Customer Success.

DTM1012

Cannot load module ~p for system version ~p, reason: ~p.

Invalid module name.

Provide the error information and the full statement text if applicable to Datometry Customer Success.

DTM1053

Out of memory.

Provide the error information and the full statement text if applicable to Datometry Customer Success.

DTM1519

DTM: Invalid configuration file

Verify Hyper-Q configuration file dtm.ini usually located at /opt/datometry/config

Make sure all the property names and values are correct.

DTM2204

Unable to resolve Kerberos service name.

Cannot determine remote Kerberos service name for this operation.

Provide the error information and the full statement text if applicable to Datometry Customer Success.

DTM2205

Cannot determine principal or service host.

Target is not unique, e.g., multiple gateways.

Provide the error information and the full statement text if applicable to Datometry Customer Success.

DTM3003

Client-side socket recieved error '~p'.

Client socket errored out unexpectedly.

Provide the error information and the full statement text if applicable to Datometry Customer Success.

DTM3004

Session timeout exceeded.

Session has been idle for too long.

Provide the error information and the full statement text if applicable to Datometry Customer Success.

DTM3005

Transaction timeout exceeded.

Session held xact lock for too long.

Provide the error information and the full statement text if applicable to Datometry Customer Success.

DTM3032

Data encryption not supported.

Provide the error information and the full statement text if applicable to Datometry Customer Success.

DTM3108

Unsupported parameter type '~p'.

Provide the error information and the full statement text if applicable to Datometry Customer Success.

DTM3109

Failed to decode date value.

Failed to decode date value.

Provide the error information and the full statement text if applicable to Datometry Customer Success.

DTM3113

Incomplete header, unable to decode result.

The tdf contains incomplete header.

Provide the error information and the full statement text if applicable to Datometry Customer Success.

DTM3114

TDF cursor is closed.

Provide the error information and the full statement text if applicable to Datometry Customer Success.

DTM4002

Syntax error in control command.

Provide the error information and the full statement text if applicable to Datometry Customer Success.

DTM4003

Object not found or insufficient privileges for operation.

Provide the error information and the full statement text if applicable to Datometry Customer Success.

DTM4004

Unexpected feature name: ~ts.

Provide the error information and the full statement text if applicable to Datometry Customer Success.

DTM4005

mdi_cache file error: ~ts.

Provide the error information and the full statement text if applicable to Datometry Customer Success.

DTM4103

Scheduler: job ~B: bad or missing parameter '~p'.

Validation of job spec failed.

Provide the error information and the full statement text if applicable to Datometry Customer Success.

DTM4104

Hyper-Q metadata manager was unable to establish connection to underlying database. 

Cannot login with credentials provided.

Review and adjust your DTM.INI settings. Contact Datometry support if the issue persists

DTM4105

Scheduler: job ~B: execution failed.

Execution was terminated with an error.

Provide the error information and the full statement text if applicable to Datometry Customer Success.

DTM5001

No such pool: '~ts'.

Cannot locate appropriate pool for incoming request.

Review and adjust your DTM.INI settings. Contact Datometry support if the issue persists

DTM5002

Bad parameters for tracing pool '~ts'.

Parameters for persistent tracing insufficient/wrong.

Provide the error information and the full statement text if applicable to Datometry Customer Success.

DTM5003

Cannot open trace file '~ts': ~ts.

Provide the error information and the full statement text if applicable to Datometry Customer Success.

DTM5011

No such gateway: '~ts'.

Cannot locate appropriate gateway.

Review and adjust your dtm.ini settings. Contact Datometry support if the issue persists

DTM5014

Type of gateway '~ts' declared as '~ts' but found to be '~ts'.

Declared and actual type of gateway do not match

Review and adjust your dtm.ini settings. Contact Datometry support if the issue persists

DTM5015

Unsupported version for gateway type '~ts': found version ~ts (details: '~ts').

Gateway version not supported.

Review and adjust your dtm.ini settings. Contact Datometry support if the issue persists

DTM5016

Protocol handler '~ts' missing (details: '~ts').

Review and adjust your dtm.ini settings. Contact Datometry support if the issue persists

DTM5017

Invalid query_success_flavor '~p' in endpoint configuration.

Endpoint configuration of query success flavor is invalid.

Review and adjust your dtm.ini settings. Contact Datometry support if the issue persists

DTM5021

No such user: '~ts'.

Cannot locate user by name.

Review and adjust your dtm.ini settings. Contact Datometry support if the issue persists

DTM5031

Failed to parse configuration file '~ts': ~ts.

Cannot parse file; bad configuration.

Review and adjust your dtm.ini settings. Contact Datometry support if the issue persists

DTM5032

Cannot ~ts configuration file '~ts' (~p).

POSIX error when opening file.

Review and adjust your dtm.ini settings. Contact Datometry support if the issue persists

DTM5033

Failed to read referenced file '~ts': ~ts.

POSIX error when opening file.

Review and adjust your dtm.ini settings. Contact Datometry support if the issue persists

DTM5034

Config file '~ts' corrupted.

Cannot process config file; unspecified reasons.

Review and adjust your dtm.ini settings. Contact Datometry support if the issue persists

DTM5037

Invalid configuration file: missing required field '~w' in entry '~ts'.

Error reading configuration file.

Review and adjust your dtm.ini settings. Contact Datometry support if the issue persists

DTM5038

Invalid entry in configuration file: '~ts'.

Invalid entry in configuration file.

Review and adjust your dtm.ini settings. Contact Datometry support if the issue persists

DTM5041

~ts:~B: ~ts.

Lexer/parser-generated error message.

Review and adjust your dtm.ini settings. Contact Datometry support if the issue persists

DTM5201

Environment variable '~ts' has bad value.

Env variable not usable.

Review and adjust your dtm.ini settings. Contact Datometry support if the issue persists

DTM5203

Flag '~ts' has bad value.

Traceflag translation failed due to bad value.

Review and adjust your dtm.ini settings. Contact Datometry support if the issue persists

DTM5301

MDI interface : No valid route for the current session.

Error during look up of gateway type and version by mdi interface.

Provide the error information and the full statement text if applicable to Datometry Customer Success.

DTM5302

MDI interface : feature ~ts not implemented.

Provide the error information and the full statement text if applicable to Datometry Customer Success.

DTM5306

Invalid MDStore table ~ts. Reason: ~ts.

Invalid MDStore table definition.

Provide the error information and the full statement text if applicable to Datometry Customer Success.

DTM6100

Plugin not found or failed to execute (~p).

Cannot find plugin in specified location or failed.

Provide the error information and the full statement text if applicable to Datometry Customer Success.

DTM6101

Plugin terminated unexpectedly with exit code '~B'.

Plugin returned error code as exit.

Provide the error information and the full statement text if applicable to Datometry Customer Success.

DTM6102

Plugin returned unexpected value(s).

Cannot make sense of plugin return values.

Provide the error information and the full statement text if applicable to Datometry Customer Success.

DTM6103

Plugin timed out.

No answer from the plugin within timeout.

Provide the error information and the full statement text if applicable to Datometry Customer Success.

Provide the error information and the full statement text if applicable to Datometry Customer Success.

DTM8002

Unsupported language feature or parse error.

Provide the error information and the full statement text if applicable to Datometry Customer Success.

DTM8003

Insufficient credentials.

Provide the error information and the full statement text if applicable to Datometry Customer Success.

DTM8004

Invalid credential data.

Logon string format is not supported.

Provide the error information and the full statement text if applicable to Datometry Customer Success.

DTM8005

No serialization method found for xtra: '~ts'.

No serialization found for operator.

This error is returned when the statements contain functions supported by Hyper-Q, but are not supported in the underlying database. 

Look into the message coming from the "No serialization method" to identify the specific function name. 

Try to run the same statement against your Teradata system and if it works provide the error information and the full statement text to Datometry Customer Success.

DTM8006

No type derivation method found for '~ts' in '~ts'.

No type derivation method found for operator.

Provide the error information and the full statement text if applicable to Datometry Customer Success.

DTM8007

Unexpected type: ~p.

Operation uses unexpected type.

Inspect the satement to ensure that it uses legitimate data types. If the issue persists, provide the error information and the full statement text to Datometry Customer Success.

DTM8008

Type mismatch (~p/~p).

Wrong type in arguments of operation.

Inspect the satement to ensure that it uses legitimate data types. If the issue persists, provide the error information and the full statement text to Datometry Customer Success.

DTM8009

Serialization failed: '~p'.

Provide the error information and the full statement text if applicable to Datometry Customer Success.

DTM8010

Cannot execute the statement in compile only mode.

Provide the error information and the full statement text if applicable to Datometry Customer Success.

DTM8011

No valid metadata interface defined for database '~ts'.

Metadata interface definition invalid or missing.

Provide the error information and the full statement text if applicable to Datometry Customer Success.

DTM8012

Ambigous metadata interface configured for database '~ts'.

Multiple metadata interfaces found.

Provide the error information and the full statement text if applicable to Datometry Customer Success.

DTM8031

Object '~ts' not found or no permission.

No valid metadata found for object or no permission.

See the knowledge base article: DTM8031: Object not found or no permission 

This error is returned when a statement references a non-existing or inaccessible object. 

Verify that the statement is either using a fully qualfied name or the database context is properly set and also verify security and access policies to ensure that the user trying to acces the object has sufficient level of access. 

If the object exists and is accessible, provide the error information and the full statement text to Datometry Customer Success.

DTM8033

Unsupported or invalid aggregate function.

Output contains columns not supported in aggregation.

Hyper-Q encountered an issue interpreting a statement that uses aggregation or window functions. 

Verify that the statement is syntactically and semantically correct. 

If the error is not resolved, provide the error information and the full statement text to the Datometry Customer Success.

DTM8037

Admin interface failed: schema ~ts not found.

Admin interface failed: admin interface schema not found.

Provide the error information and the full statement text if applicable to Datometry Customer Success.

DTM8038

Loading object alias mapping failed: table ~ts not found.

Alias mapping table not found.

Provide the error information and the full statement text if applicable to Datometry Customer Success.

DTM8039

Object already exists in the variable scope.

Provide the error information and the full statement text if applicable to Datometry Customer Success.

DTM8040

Object name '~ts' is ambiguous.

“Object name is ambiguous” means that you are referencing an attribute or attributes that belong to more than one of the objects that are used in the query.  Verify that the statement is functionally correct. If the error is not resolved, provide the error information and the full statement text to Datometry Customer Success.

DTM8041

No function '~ts' found that matches the parameter specification.

Function name incorrect or paramters of unexpected type.

Provide the error information and the full statement text if applicable to Datometry Customer Success.

DTM8042

Schema '~ts' not found.

No schema found with given name.

Provide the error information and the full statement text if applicable to Datometry Customer Success.

DTM8043

Failed to send file via client socket.

Provide the error information and the full statement text if applicable to Datometry Customer Success.

DTM8044

Wrong format. Unit '~ts' is not supported for trunc function.

Unsupported TRUNC unit.

Provide the error information and the full statement text if applicable to Datometry Customer Success.

DTM8045

Invalid input for NVL function.

Provide the error information and the full statement text if applicable to Datometry Customer Success.

DTM8046

Max recursion depth exceeded by ~p.

Provide the error information and the full statement text if applicable to Datometry Customer Success.

DTM8104

Malformed packet.

Packet corrupted or of unexpected format.

Provide the error information and the full statement text if applicable to Datometry Customer Success.

DTM8105

Memory quota for query results exceeded.

Maximally allowed result set exceeded.

Provide the error information and the full statement text if applicable to Datometry Customer Success.

DTM8108

Bad request.

Incoming request is not of expected type.

Provide the error information and the full statement text if applicable to Datometry Customer Success.

DTM8109

Language feature '~ts' not yet supported.

Unsupported token.

Provide the error information and the full statement text if applicable to Datometry Customer Success.

DTM8111

Variable '~ts' ambiguous.

Failed to resolve column name -- either reference or definition.

Provide the error information and the full statement text if applicable to Datometry Customer Success.

DTM8112

No order encoding column found for table '~ts'.

Table doesn't have proper ordcol defined.

Provide the error information and the full statement text if applicable to Datometry Customer Success.

DTM8113

Order encoding column '~ts' is of wrong type.

Ordcol defined as something else but int8.

Provide the error information and the full statement text if applicable to Datometry Customer Success.

DTM8114

Bad literal (~p).

Modifier and value are not compatible.

Provide the error information and the full statement text if applicable to Datometry Customer Success.

DTM8115

Column '~ts' of unsupported external data type '~p'.

Type used in database not supported in Hyper-Q.

Provide the error information and the full statement text if applicable to Datometry Customer Success.

DTM8116

Table '~ts' contains no columns of supported type.

None of the columns are usable; or table is defined without columns.

Provide the error information and the full statement text if applicable to Datometry Customer Success.

DTM8117

As-of join not applicable because right expression is keyed.

Right table must not have keys.

Provide the error information and the full statement text if applicable to Datometry Customer Success.

DTM8118

As-of join requires specified columns to be present and of the same type in both expressions.

Columns must match by name and type.

Provide the error information and the full statement text if applicable to Datometry Customer Success.

DTM8119

Invalid recursive view definition: ~ts.

Provide the error information and the full statement text if applicable to Datometry Customer Success.

DTM8120

Function '~ts' returns unsupported type.

Unable to represent return type.

Provide the error information and the full statement text if applicable to Datometry Customer Success.

DTM8121

Ungroup operator requires at least one column that contains lists.

Table must have at least one column that contains lists.

Provide the error information and the full statement text if applicable to Datometry Customer Success.

DTM8122

Parameter value out of range.

Only values in (0, 2147483647 are supported for take operator.

Provide the error information and the full statement text if applicable to Datometry Customer Success.

DTM8123

Window join requires specified columns to be present and of the same type in both expressions.

Columns must match by name and type.

Provide the error information and the full statement text if applicable to Datometry Customer Success.

DTM8124

Too many names specified for xcol.

Number of names specified must be smaller or equal to that of the columns for xcol.

Provide the error information and the full statement text if applicable to Datometry Customer Success.

DTM8125

Invalid function definition.

Unable to parse the string to get function body.

Provide the error information and the full statement text if applicable to Datometry Customer Success.

DTM8126

Wrong number of arguments specified for function invocation.

Number of arguments specified for function invocation does not match that in the function definition.

Provide the error information and the full statement text if applicable to Datometry Customer Success.

DTM8127

Invalid arguments for xbar.

Left side of xbar must be positive integer and right side must be numeric type.

Provide the error information and the full statement text if applicable to Datometry Customer Success.

DTM8128

Global table feature unsupported.

Provide the error information and the full statement text if applicable to Datometry Customer Success.

DTM8129

Table variables in request scope not supported yet.

Provide the error information and the full statement text if applicable to Datometry Customer Success.

DTM8130

Kerberos token has invalid format.

Kerberos token got corrupted or incorrectly encoded.

Provide the error information and the full statement text if applicable to Datometry Customer Success.

DTM8131

Materialization of table variable failed: ~ts.

Table materialization statement failed.

Provide the error information and the full statement text if applicable to Datometry Customer Success.

DTM8132

Invalid assignment: cannot assign to 'i' in 'select' query.

Invalid named assignment in 'select' query.

Provide the error information and the full statement text if applicable to Datometry Customer Success.

DTM8133

Key join requires that the keys of the right table be present in the left table.

Provide the error information and the full statement text if applicable to Datometry Customer Success.

DTM8134

Invalid variable reference '~ts'.

Provide the error information and the full statement text if applicable to Datometry Customer Success.

DTM8135

Boolean expression required in where clause.

Provide the error information and the full statement text if applicable to Datometry Customer Success.

DTM8136

Column assignment required in update.

Provide the error information and the full statement text if applicable to Datometry Customer Success.

DTM8137

Expected symbol or list of symbols as left argument of operator '~ts'.

Provide the error information and the full statement text if applicable to Datometry Customer Success.

DTM8138

Expected integer as left argument of operator #.

Provide the error information and the full statement text if applicable to Datometry Customer Success.

DTM8139

Expected relational expression as argument of ungroup.

Provide the error information and the full statement text if applicable to Datometry Customer Success.

DTM8140

Invalid arguments for sublist.

Provide the error information and the full statement text if applicable to Datometry Customer Success.

DTM8141

Invalid arguments for within.

Within expression only accepts one or two arguments.

Provide the error information and the full statement text if applicable to Datometry Customer Success.

DTM8142

Invalid multi-column reference.

Provide the error information and the full statement text if applicable to Datometry Customer Success.

DTM8143

Expected table expression as argument of distinct.

Provide the error information and the full statement text if applicable to Datometry Customer Success.

DTM8144

Expected table expression as argument of cols.

Provide the error information and the full statement text if applicable to Datometry Customer Success.

DTM8145

Expected table expression as argument of meta.

Provide the error information and the full statement text if applicable to Datometry Customer Success.

DTM8146

Expected symbol as argument of tables.

Provide the error information and the full statement text if applicable to Datometry Customer Success.

DTM8147

Invalid table expression reference '~ts'.

Invalid table reference in mci.

Provide the error information and the full statement text if applicable to Datometry Customer Success.

DTM8148

Invalid select specification.

Provide the error information and the full statement text if applicable to Datometry Customer Success.

DTM8149

Invalid grouping specification.

Provide the error information and the full statement text if applicable to Datometry Customer Success.

DTM8150

Invalid argument to differ operator.

Provide the error information and the full statement text if applicable to Datometry Customer Success.

DTM8151

Expected non-negative integer as argument of til.

Provide the error information and the full statement text if applicable to Datometry Customer Success.

DTM8152

Invalid dictionary specification.

Parity mismatch between the domain and the range of the dictionary.

Provide the error information and the full statement text if applicable to Datometry Customer Success.

DTM8153

Invalid q script: '~ts'.

Q script must have '.q' as file extension.

Provide the error information and the full statement text if applicable to Datometry Customer Success.

DTM8154

Invalid load command argument '~ts': ~ts.

Invalid argument for load command.

Provide the error information and the full statement text if applicable to Datometry Customer Success.

DTM8155

Cannot open script '~ts': ~ts.

Cannot open q script file.

Provide the error information and the full statement text if applicable to Datometry Customer Success.

DTM8156

Loading failed at line ~B of '~ts': ~ts.

Error occurred during loading of a statement in the q script.

Provide the error information and the full statement text if applicable to Datometry Customer Success.

DTM8157

Invalid functional form specification.

Parse expression must be bound to an xtra_scaop_list.

Provide the error information and the full statement text if applicable to Datometry Customer Success.

DTM8158

Invalid table specification: columns expressions must have the same length.

Provide the error information and the full statement text if applicable to Datometry Customer Success.

DTM8159

Invalid concatenation.

Cannot concatenate table with other types.

Provide the error information and the full statement text if applicable to Datometry Customer Success.

DTM8160

Invalid stdout/err argument: argument must be string type.

Stdout/err accepts only string type argument.

Provide the error information and the full statement text if applicable to Datometry Customer Success.

DTM8162

Q's stderr logging.

Provide the error information and the full statement text if applicable to Datometry Customer Success.

DTM8163

Index out of bounds.

Provide the error information and the full statement text if applicable to Datometry Customer Success.

DTM8164

Invalid argument for dot operator.

Argument of dot operator must be symbol or integer list.

Provide the error information and the full statement text if applicable to Datometry Customer Success.

DTM8165

Invalid argument for 'parse'.

Parse function accepts only string argument.

Provide the error information and the full statement text if applicable to Datometry Customer Success.

DTM8166

Invalid q query for 'parse'.

Parse function accepts only valid q query.

Provide the error information and the full statement text if applicable to Datometry Customer Success.

DTM8167

Functional form of '~ts' not supported yet.

Functional form does not work for certain operators.

Provide the error information and the full statement text if applicable to Datometry Customer Success.

DTM8168

Invalid constraints specification.

Provide the error information and the full statement text if applicable to Datometry Customer Success.

DTM8169

Invalid condition query.

Condition query must have odd number of expressions.

Provide the error information and the full statement text if applicable to Datometry Customer Success.

DTM8170

Condition must be of boolean or integer type.

Provide the error information and the full statement text if applicable to Datometry Customer Success.

DTM8171

Invalid keyed table update.

Update multiple rows at the same time.

Provide the error information and the full statement text if applicable to Datometry Customer Success.

DTM8172

Key accepts only table with key columns.

Provide the error information and the full statement text if applicable to Datometry Customer Success.

DTM8173

Invalid table argument for flip.

Flip accepts table with non-key columns.

Provide the error information and the full statement text if applicable to Datometry Customer Success.

DTM8174

Invalid logical (and/or) arguments.

Arity mismatch between the logical operator arguments.

Provide the error information and the full statement text if applicable to Datometry Customer Success.

DTM8175

Invalid IN arguments.

Unexpected number of columns in IN expression.

Provide the error information and the full statement text if applicable to Datometry Customer Success.

DTM8176

Materialization of table variable failed: admin schema not configured.

Table materialization statement failed.

Provide the error information and the full statement text if applicable to Datometry Customer Success.

DTM8177

Invalid value for parse expression.

Expect to parse a serialized string of a parse expression.

Provide the error information and the full statement text if applicable to Datometry Customer Success.

DTM8178

Invalid value for select topn argument.

Select topn accepts integer argument only.

Provide the error information and the full statement text if applicable to Datometry Customer Success.

DTM8179

Invalid delete query: ~ts.

Provide the error information and the full statement text if applicable to Datometry Customer Success.

DTM8180

Invalid vector conditional expression.

Expression components should be scalar or list expressions, where the first component is boolean (list and the if and else components are of the same type.

Provide the error information and the full statement text if applicable to Datometry Customer Success.

DTM8181

Invalid functional specification.

Expected three or four components.

Provide the error information and the full statement text if applicable to Datometry Customer Success.

DTM8182

Xcols does not apply to keyed table.

Provide the error information and the full statement text if applicable to Datometry Customer Success.

DTM8183

Invalid 'prepare_text' command separator.

Expected char type.

Provide the error information and the full statement text if applicable to Datometry Customer Success.

DTM8184

Invalid high-order function definition.

Cannot parse parent function body.

Provide the error information and the full statement text if applicable to Datometry Customer Success.

DTM8185

Encountered Q program error: ~ts.

Provide the error information and the full statement text if applicable to Datometry Customer Success.

DTM8186

Invalid arguments for over.

Left side of over must be a function or function reference and right side must be a list expression.

Provide the error information and the full statement text if applicable to Datometry Customer Success.

DTM8187

Equi-join requires specified columns to be present and of the same type in both input expressions.

Columns must match by name and type.

Provide the error information and the full statement text if applicable to Datometry Customer Success.

DTM8188

Failed to reconstruct the result from backend database: ~ts.

Unable to construct Xtra from Rowset, most likely because the underlying database failed to execute the generated query.

Provide the error information and the full statement text if applicable to Datometry Customer Success.

DTM8189

Failed to execute statement: '~ts'.

Serialization or execution failed.

Provide the error information and the full statement text if applicable to Datometry Customer Success.

DTM8190

Error: ~ts.

Check type compatibility for comparison failed.

Provide the error information and the full statement text if applicable to Datometry Customer Success.

DTM8191

SET TIMING ON' is not supported for this query.

Provide the error information and the full statement text if applicable to Datometry Customer Success.

DTM8192

Multiple aggregations are not supported in where clause.

Provide the error information and the full statement text if applicable to Datometry Customer Success.

DTM8193

Syntax error before: 'EOL'

See the knowledge base article: DTM8193: Syntax error before: 'EOL'

DTM8201

Compiler error.

Bad xtra.

Provide the error information and the full statement text if applicable to Datometry Customer Success.

DTM8202

Invalid Date/Time/Timestamp string: '~ts'.

Provide the error information and the full statement text if applicable to Datometry Customer Success.

DTM8250

Invalid numeric type specifications (Precision: ~p, Scale: ~p).

Provide the error information and the full statement text if applicable to Datometry Customer Success.

DTM8251

Numeric overflow.

Provide the error information and the full statement text if applicable to Datometry Customer Success.

DTM8252

Unsupported encryption method.

Provide the error information and the full statement text if applicable to Datometry Customer Success.

DTM8253

Max message size is too small.

Client specified message size that does not fit query results.

Provide the error information and the full statement text if applicable to Datometry Customer Success.

DTM8254

Unsuccessful decryption of message: ~ts.

Provide the error information and the full statement text if applicable to Datometry Customer Success.

DTM8255

Message unsupported in current protocol state: ~ts.

Provide the error information and the full statement text if applicable to Datometry Customer Success.

DTM8256

User-generated transaction ABORT.

In teradata, ROLLBACK command will generate an error response.

Provide the error information and the full statement text if applicable to Datometry Customer Success.

DTM8257

Unsupported window construct: '~ts'.

Provide the error information and the full statement text if applicable to Datometry Customer Success.

DTM8258

Record size must not exceed 64 KB.

Provide the error information and the full statement text if applicable to Datometry Customer Success.

DTM8259

Invalid QUALIFY clause: ~ts.

Provide the error information and the full statement text if applicable to Datometry Customer Success.

DTM8260

Unsupported group by clause: ~ts.

Group by clause not supported by underlying system.

Provide the error information and the full statement text if applicable to Datometry Customer Success.

DTM8261

Grouping operation not supported by backend system.

Provide the error information and the full statement text if applicable to Datometry Customer Success.

DTM8262

Invalid CREATE VIEW statement. Reason: ~ts.

Provide the error information and the full statement text if applicable to Datometry Customer Success.

DTM8263

Invalid CREATE VIEW statement: column name list ~ts than select list.

Provide the error information and the full statement text if applicable to Datometry Customer Success.

DTM8264

Invalid command: there is already an active transaction.

Provide the error information and the full statement text if applicable to Datometry Customer Success.

DTM8265

Invalid command: there is no active transaction.

Provide the error information and the full statement text if applicable to Datometry Customer Success.

DTM8266

Unsupported system procedure call: '~ts'.

Provide the error information and the full statement text if applicable to Datometry Customer Success.

DTM8267

Invalid database name.

Provide the error information and the full statement text if applicable to Datometry Customer Success.

DTM8268

SIGNAL with SQLSTATE or CONDITION name not yet supported.

Provide the error information and the full statement text if applicable to Datometry Customer Success.

DTM8269

SET MESSAGE_TEXT not yet supported.

Provide the error information and the full statement text if applicable to Datometry Customer Success.

DTM8270

RESIGNAL with SQLSTATE or CONDITION name not yet supported.

Provide the error information and the full statement text if applicable to Datometry Customer Success.

DTM8272

Unsupported request mode in query options: '~p'.

Provide the error information and the full statement text if applicable to Datometry Customer Success.

DTM8273

Failed TDF conversion.

Conversion to internal result representation has failed.

Provide the error information and the full statement text if applicable to Datometry Customer Success.

DTM8274

Invalid calendar name '~ts'.

Provide the error information and the full statement text if applicable to Datometry Customer Success.

DTM8275

Unsupported INSERT into a set table.

Provide the error information and the full statement text if applicable to Datometry Customer Success.

DTM8276

Unsupported CREATE VIEW using WITH CHECK OPTION: ~ts.

Provide the error information and the full statement text if applicable to Datometry Customer Success.

DTM8277

Database specified for function ~ts is ambiguous.

Provide the error information and the full statement text if applicable to Datometry Customer Success.

DTM8278

More than ~p columns in collect stats not supported by backend system.

Provide the error information and the full statement text if applicable to Datometry Customer Success.

DTM8279

Session flag ~p not supported with query override execution.

Provide the error information and the full statement text if applicable to Datometry Customer Success.

Provide the error information and the full statement text if applicable to Datometry Customer Success.

DTM8281

Command not allowed in an active transaction.

Provide the error information and the full statement text if applicable to Datometry Customer Success.

DTM8302

String replacement with negative arguments not yet supported.

Provide the error information and the full statement text if applicable to Datometry Customer Success.

DTM8303

Cols function on expressions with side effects not yet supported.

Provide the error information and the full statement text if applicable to Datometry Customer Success.

DTM8304

Sublist function with negative arguments not yet supported.

Provide the error information and the full statement text if applicable to Datometry Customer Success.

DTM8305

Type function on expressions with side effects not yet supported.

Provide the error information and the full statement text if applicable to Datometry Customer Success.

DTM8306

Union join on keyed tables not yet supported.

Provide the error information and the full statement text if applicable to Datometry Customer Success.

DTM8307

Anonymous columns not yet supported.

Provide the error information and the full statement text if applicable to Datometry Customer Success.

DTM8308

Union all on different schemas not yet supported.

Provide the error information and the full statement text if applicable to Datometry Customer Success.

DTM8309

Meta function on expressions with side effects not yet supported.

Provide the error information and the full statement text if applicable to Datometry Customer Success.

DTM8310

Cross compilation: '~ts' type of expression not supported in '~ts' context.

Provide the error information and the full statement text if applicable to Datometry Customer Success.

DTM8311

Feature '~ts' not supported.

Provide the error information and the full statement text if applicable to Datometry Customer Success.

DTM8312

Unsupported function call.

Provide the error information and the full statement text if applicable to Datometry Customer Success.

DTM8313

Unsupported operator '~ts'.

Verify that the statement is functionally correct. If the error persists, provide the error information and the full statement text if applicable to Datometry Customer Success.

DTM8314

Row-number selection on keyed tables not yet supported.

Provide the error information and the full statement text if applicable to Datometry Customer Success.

DTM8315

Duplicate column symbols not supported in xcols.

Provide the error information and the full statement text if applicable to Datometry Customer Success.

DTM8400

Query result device is locked.

Data cannot be inserted into result device.

Provide the error information and the full statement text if applicable to Datometry Customer Success.

DTM8401

Query result device is unlocked.

Data cannot be retrieved from unlocked result device.

Provide the error information and the full statement text if applicable to Datometry Customer Success.

DTM8402

Cannot add unlocked result device to another device.

Provide the error information and the full statement text if applicable to Datometry Customer Success.

DTM8403

Query result device failed to spill data to disk.

Provide the error information and the full statement text if applicable to Datometry Customer Success.

DTM8404

Failed to access spill file '~ts'. Reason: '~ts'.

Provide the error information and the full statement text if applicable to Datometry Customer Success.

DTM8405

response message of size '~p'.

Client message size cannot be used to store results.

Provide the error information and the full statement text if applicable to Datometry Customer Success.

DTM8406

Client message character decoding failed '~p'.

Provide the error information and the full statement text if applicable to Datometry Customer Success.

DTM8407

Failed to access file '~ts'. Reason: '~ts'.

Provide the error information and the full statement text if applicable to Datometry Customer Success.

DTM8501

Unexpected table alias for column '~p'.

Unexpected table alias.

The query is using aliases referencing an attribute or attributes that belong to more than one of the objects. 

Verify that the statement is functionally correct and consider simplifying the statement to avoid forward and backward references. 

If the error is not resolved, provide the error information and the full statement text to Datometry Customer Success.

DTM8502

Invalid TOP-N count '~p'.

TOP-N count should be positive.

Verify that the statement is functionally correct. If the error persists, provide the error information and the full statement text if applicable to Datometry Customer Success.

DTM8503

Invalid column position '~p'.

Column position should be a positive integer.

Verify that the statement is functionally correct. If the error persists, provide the error information and the full statement text if applicable to Datometry Customer Success.

DTM8504

Invalid derived table columns ~ts.

Verify that the statement is functionally correct. If the error persists, provide the error information and the full statement text if applicable to Datometry Customer Success.

DTM8505

Invalid column name ~ts.

Verify that the statement is functionally correct. If the error persists, provide the error information and the full statement text if applicable to Datometry Customer Success.

DTM8506

Unable to resolve column name '~ts'.

Unable to resolve column name.

This error is returned when a statement references columns that are not present in the schema. 

Verify that all columns referenced by the statement are present. 

If the error persists, provide the error information and the full statement text to Datometry Customer Success.

DTM8507

Invalid object name '~ts'.

Verify that the statement is functionally correct. If the error persists, provide the error information and the full statement text if applicable to Datometry Customer Success.

DTM8508

Invalid grouping expression.

Grouping expression can be column names, positions or expressions on columns with no aggregate functions.

Verify that the statement is syntactically and semantically correct. If the error persists, provide the error information and the full statement text if applicable to Datometry Customer Success.

DTM8509

insert expressions ~ts than target columns.

Number of insert expressions should match target columns.

Verify that the statement is syntactically and semantically correct. If the error persists, provide the error information and the full statement text if applicable to Datometry Customer Success.

DTM8510

Invalid interval string '~ts'.

Verify that the statement is syntactically and semantically correct. If the error persists, provide the error information and the full statement text if applicable to Datometry Customer Success.

DTM8511

Subquery must return only one column.

Verify that the statement is syntactically and semantically correct. If the error persists, provide the error information and the full statement text if applicable to Datometry Customer Success.

DTM8512

Unexpected subquery expression.

Verify that the statement is syntactically and semantically correct. If the error persists, provide the error information and the full statement text if applicable to Datometry Customer Success.

DTM8513

Invalid HAVING clause.

Columns in the HAVING clause must be either used in an aggregate function or appear in the GROUP BY clause.

Verify that the statement is functionally correct. If the error persists, provide the error information and the full statement text if applicable to Datometry Customer Success.

DTM8514

Duplicate FROM/WHERE/GROUP BY/HAVING/ORDER BY /QUALIFY/SAMPLE clauses.

Verify that the statement is functionally correct. If the error persists, provide the error information and the full statement text if applicable to Datometry Customer Success.

DTM8515

Invalid Date/Time/Timestamp string: '~ts'.

Verify that the statement is functionally correct. If the error persists, provide the error information and the full statement text if applicable to Datometry Customer Success.

DTM8516

Duplicate column attributes specified for column ~ts.

Column attributes (not null, default etc can only be specified once except for column constraints.

Verify that the statement is functionally correct. If the error persists, provide the error information and the full statement text if applicable to Datometry Customer Success.

DTM8517

Primary key column(s) must be NOT NULL.

If one or more columns is specified as PRIMARY KEY, it must be specified as NOT NULL as well.

Verify that the statement is functionally correct. If the error persists, provide the error information and the full statement text if applicable to Datometry Customer Success.

DTM8518

Unique column(s) must be NOT NULL.

If one or more columns is specified as UNIQUE, it must be specified as NOT NULL as well.

Verify that the statement is functionally correct. If the error persists, provide the error information and the full statement text if applicable to Datometry Customer Success.

DTM8519

Invalid create table syntax: '~ts'.

Verify that the statement is functionally correct. If the error persists, provide the error information and the full statement text if applicable to Datometry Customer Success.

DTM8520

Specifying more than one primary index not permitted.

Teradata does not allow specifying more than one primary index.

Verify that the statement is functionally correct. If the error persists, provide the error information and the full statement text if applicable to Datometry Customer Success.

DTM8521

Mismatching Begin/End labels '(~ts, ~ts)'.

Different labels are used for BEGIN/END of a statement block.

Verify that the statement is functionally correct. If the error persists, provide the error information and the full statement text if applicable to Datometry Customer Success.

DTM8522

Invalid statement block label '~ts'.

Verify that the statement is functionally correct. If the error persists, provide the error information and the full statement text if applicable to Datometry Customer Success.

DTM8523

Object '~ts' already exists.

A CREATE statement was run for an object that already exists. 

Verify the logic of your scripts if this condition is unexpected. Usually these errors can be ignored if the object definitions are static.

DTM8524

Undefined variable '~ts'.

Provide the error information and the full statement text if applicable to Datometry Customer Success.

DTM8525

Nested call of procedure '~ts' with output parameters and returned dynamic result sets not supported.

Unsupported nested procedure call with output parameters and dynamic result sets.

Provide the error information and the full statement text if applicable to Datometry Customer Success.

DTM8526

Invalid length specified for CHAR or VARCHAR type '~p'.

Type modifier for CHAR or VARCHAR data type needs to be between 1 and 64000.

Provide the error information and the full statement text if applicable to Datometry Customer Success.

DTM8527

Illegal clause or aggregation without table accessed.

Provide the error information and the full statement text if applicable to Datometry Customer Success.

DTM8528

Invalid cursor variable '~ts'.

Invalid variable is used in cursor operation.

Provide the error information and the full statement text if applicable to Datometry Customer Success.

DTM8529

Invalid ORDER BY clause in set operation.

Encountered Order By clause in the first Select of a Set operation, or non-positional Order By clause is used.

Provide the error information and the full statement text if applicable to Datometry Customer Success.

DTM8530

Invalid Top N clause.

Top N clause not allowed in Select expressions of Set operation.

Provide the error information and the full statement text if applicable to Datometry Customer Success.

DTM8531

Insert statement has invalid target columns or value expressions.

Provide the error information and the full statement text if applicable to Datometry Customer Success.

DTM8532

Variable '~ts' already defined.

Provide the error information and the full statement text if applicable to Datometry Customer Success.

DTM8533

Incorrect number arguments for function '~ts'.

Function invocation with wrong number of arguments.

Provide the error information and the full statement text if applicable to Datometry Customer Success.

DTM8534

Invalid precision specified for time or timestamp type '~p'.

Precision for time or timestamp type needs to be between 0 and 6.

Provide the error information and the full statement text if applicable to Datometry Customer Success.

DTM8535

Invalid value of argument number '~p' in function call '~ts'.

Function invocation with invalid INOUT/OUT parameter.

Provide the error information and the full statement text if applicable to Datometry Customer Success.

DTM8536

Unsupported cursor option '~ts'.

Provide the error information and the full statement text if applicable to Datometry Customer Success.

DTM8537

SQLSTATE' reference outside exception handler block is unsupported.

Provide the error information and the full statement text if applicable to Datometry Customer Success.

DTM8538

Unsupported 'SQLCODE' reference.

Provide the error information and the full statement text if applicable to Datometry Customer Success.

DTM8539

Unexpected expression '~p'.

This error indicates that either an unsupported expression is provided or the statement contains multi-layer complex dependencies/clauses usage. 

Verify the functionality of the statement and consider simplifying it. 

If the error cannot be resolved, provide the error information and the full statement text to Datometry Customer Success

DTM8540

Unsupported or invalid format string '~ts' for type '~ts'.

Unsupported or invalid format string.

Look at the message coming from "Unsupported or invalid format string" and make sure that the format of the string is supported by Teradata. 

If it is supported provide the error information and the full statement text to Datometry Customer Success

DTM8541

Unable to resolve variable '~ts'.

Provide the error information and the full statement text if applicable to Datometry Customer Success.

DTM8542

Invalid window operation: '~ts'.

Provide the error information and the full statement text if applicable to Datometry Customer Success.

DTM8543

Invalid operation '~ts' for cursor '~ts'.

Provide the error information and the full statement text if applicable to Datometry Customer Success.

DTM8544

Unsupported operation '~ts' for cursor '~ts' on gateway '~p'.

Provide the error information and the full statement text if applicable to Datometry Customer Success.

DTM8545

Invalid data attributes: multiple '~p' options.

Provide the error information and the full statement text if applicable to Datometry Customer Success.

DTM8546

Duplicate common table expression definition '~ts'.

Provide the error information and the full statement text if applicable to Datometry Customer Success.

DTM8547

Invalid argument to round function.

Provide the error information and the full statement text if applicable to Datometry Customer Success.

DTM8548

Invalid sampling rate '~p'.

Invalid sampling rate: Teradata requires sampling rate between 2 and 100 when collecting statistics.

Provide the error information and the full statement text if applicable to Datometry Customer Success.

DTM8549

Subquery output does not match required comparison.

This message displays when the subquery output doesn't match the required comparison. 

Make sure that the subquery type is correct. 

If the error is not resolved, provide the error information and the full statement text to Datometry Customer Success.

DTM8550

Invalid arithmetic operation (~p ~p ~p).

Provide the error information and the full statement text if applicable to Datometry Customer Success.

DTM8551

Unsupported arithmetic operation (~p ~p ~p).

Provide the error information and the full statement text if applicable to Datometry Customer Success.

DTM8552

Too many digits in exponent '~ts'.

Provide the error information and the full statement text if applicable to Datometry Customer Success.

DTM8553

Invalid float value '~p'.

Provide the error information and the full statement text if applicable to Datometry Customer Success.

DTM8554

Invalid interval specification: sign '~ts', unit '~ts'.

Provide the error information and the full statement text if applicable to Datometry Customer Success.

DTM8555

Unsupported function: '~p'.

Provide the error information and the full statement text if applicable to Datometry Customer Success.

DTM8556

Length of object name exceeds the limit of the backend system.

Provide the error information and the full statement text if applicable to Datometry Customer Success.

DTM8557

Unexpected sqlstate: ~p.

Provide the error information and the full statement text if applicable to Datometry Customer Success.

DTM8558

Global temporary table parse error: '~ts'.

Provide the error information and the full statement text if applicable to Datometry Customer Success.

DTM8559

Database name, if specified, must be the login user name for a volatile table.

Provide the error information and the full statement text if applicable to Datometry Customer Success.

DTM8560

Stored procedure DDL cannot be submitted in multi-statement request.

Provide the error information and the full statement text if applicable to Datometry Customer Success.

DTM8561

Multi-statement request is only supported with the new pipeline.

Provide the error information and the full statement text if applicable to Datometry Customer Success.

DTM8562

Invalid named expression.

Provide the error information and the full statement text if applicable to Datometry Customer Success.

DTM8563

Duplicate definition of expression '~ts'.

This error is returned when statements contain duplicated definition of the expression. 

Look into the message coming from the duplicate definition of expression to identify the expression which has the duplicated definition. 

Try to run the same statement against your Teradata system and if it works provide the error information and the full statement text to Datometry Customer Success.

DTM8564

Unsupported query band '~ts'.

Provide the error information and the full statement text if applicable to Datometry Customer Success.

DTM8565

Error encountered while emulating stored procedure operation: '~p'.

Provide the error information and the full statement text if applicable to Datometry Customer Success.

DTM8566

Expected one row in query results.

Provide the error information and the full statement text if applicable to Datometry Customer Success.

DTM8567

Invalid statistics collection command. Reason: '~ts'.

Provide the error information and the full statement text if applicable to Datometry Customer Success.

DTM8568

Expected single row constant table.

Provide the error information and the full statement text if applicable to Datometry Customer Success.

DTM8569

Case sensitivity specified for non-CHAR data.

Provide the error information and the full statement text if applicable to Datometry Customer Success.

DTM8570

Invalid precision specified for interval type '~p'.

Precision for interval type needs to be between 1 and 4.

Provide the error information and the full statement text if applicable to Datometry Customer Success.

DTM8571

Illegal or unsupported set operation inside a recursive query/view.

Provide the error information and the full statement text if applicable to Datometry Customer Success.

DTM8572

Invalid length specified for byte or varbyte type '~p'.

Type modifier for byte or varbyte type needs to be between 1 and 64000.

Provide the error information and the full statement text if applicable to Datometry Customer Success.

DTM8573

Custom ABORT message.

Provide the error information and the full statement text if applicable to Datometry Customer Success.

DTM8574

Unexpected argument at position '~p' when calling '~ts'.

Provide the error information and the full statement text if applicable to Datometry Customer Success.

DTM8575

Incorrect number of arguments when calling '~ts'.

Provide the error information and the full statement text if applicable to Datometry Customer Success.

DTM8576

Invalid macro definition. Reason: ~p.

Provide the error information and the full statement text if applicable to Datometry Customer Success.

DTM8577

Invalid interval type definition.

Provide the error information and the full statement text if applicable to Datometry Customer Success.

DTM8578

Expected IS NULL or IS NOT NULL to test for NULL values.

Provide the error information and the full statement text if applicable to Datometry Customer Success.

DTM8579

Duplicate option for Identity Column.

Provide the error information and the full statement text if applicable to Datometry Customer Success.

DTM8580

Illegal usage of Identity Column.

Provide the error information and the full statement text if applicable to Datometry Customer Success.

DTM8581

Invalid data type for Identity Column.

Provide the error information and the full statement text if applicable to Datometry Customer Success.

DTM8582

Some index columns are not in the table ('~ts').

Index columns must exist in the table.

Provide the error information and the full statement text if applicable to Datometry Customer Success.

DTM8583

Index '~ts' does not exist.

Make sure that the index which you are referring to exists. 

If the index exists, provide the error information and the full statement text to Datometry Customer Success

DTM8584

Duplicate index column.

Provide the error information and the full statement text if applicable to Datometry Customer Success.

DTM8585

Index '~ts' already exists.

Provide the error information and the full statement text if applicable to Datometry Customer Success.

DTM8586

Invalid sample size '~p'.

Provide the error information and the full statement text if applicable to Datometry Customer Success.

DTM8587

Database '~ts' does not exist.

Provide the error information and the full statement text if applicable to Datometry Customer Success.

DTM8588

Conflicting CASESPECIFIC options.

Provide the error information and the full statement text if applicable to Datometry Customer Success.

DTM8589

Operand of EXTRACT function is not a valid data type or value.

Provide the error information and the full statement text if applicable to Datometry Customer Success.

DTM8590

Interval field overflow.

Provide the error information and the full statement text if applicable to Datometry Customer Success.

DTM8591

Statistics does not exist.

See the knowledge base article: DTM8591: Statistics does not exist

DTM8592

Invalid function definition. Reason: ~p.

Provide the error information and the full statement text if applicable to Datometry Customer Success.

DTM8593

Function reference ~ts is ambiguous.

Provide the error information and the full statement text if applicable to Datometry Customer Success.

DTM8594

Unexpected error: ~p.

Provide the error information and the full statement text if applicable to Datometry Customer Success.

DTM8595

Invalid hexadecimal constant '~p'.

Provide the error information and the full statement text if applicable to Datometry Customer Success.

DTM8596

Invalid type or precision for period base type '~p', '~p'.

Provide the error information and the full statement text if applicable to Datometry Customer Success.

DTM8597

Function 'greatest' called with an invalid number or type of parameters.

Provide the error information and the full statement text if applicable to Datometry Customer Success.

DTM8598

Function 'least' called with an invalid number or type of parameters.

Provide the error information and the full statement text if applicable to Datometry Customer Success.

DTM8599

Case not found for CASE statement.

Provide the error information and the full statement text if applicable to Datometry Customer Success.

DTM8600

Only one ORDER BY sort key is currently supported by XMLAgg.

Provide the error information and the full statement text if applicable to Datometry Customer Success.

DTM8601

The Pad Expression for TRIM has an incorrect data type or length.

Provide the error information and the full statement text if applicable to Datometry Customer Success.

DTM8602

The parameter '~ts' must be given a value.

Provide the error information and the full statement text if applicable to Datometry Customer Success.

DTM8603

Syntax error: expecting isolation level.

Provide the error information and the full statement text if applicable to Datometry Customer Success.

DTM8604

Invalid input format for type ~ts: '~ts'.

Provide the error information and the full statement text if applicable to Datometry Customer Success.

DTM8605

Value '~ts' is out of range for type ~ts.

Provide the error information and the full statement text if applicable to Datometry Customer Success.

DTM8606

This statement is not allowed when the target temporary table is already materialized.

Provide the error information and the full statement text if applicable to Datometry Customer Success.

DTM8607

No data found.

Provide the error information and the full statement text if applicable to Datometry Customer Success.

DTM8608

Illegal statement following DDL statement in transaction.

Provide the error information and the full statement text if applicable to Datometry Customer Success.

DTM8609

InputString or Delim length is 0; OR toknum parameter is no larger than 0.

Provide the error information and the full statement text if applicable to Datometry Customer Success.

DTM8610

~ts' is not a temporary table.

Provide the error information and the full statement text if applicable to Datometry Customer Success.

DTM8611

Failed: '~ts' is not a table.

Invalid SHOW statement.

Provide the error information and the full statement text if applicable to Datometry Customer Success.

DTM8612

Failed: '~ts' is not a view.

Invalid SHOW statement.

Provide the error information and the full statement text if applicable to Datometry Customer Success.

DTM8613

Invalid interval arithmetic operation (~p ~p).

Provide the error information and the full statement text if applicable to Datometry Customer Success.

DTM8614

Invalid Query Band Search.

Provide the error information and the full statement text if applicable to Datometry Customer Success.

DTM8615

Failed: '~ts' is not a stored procedure.

Invalid SHOW statement.

Provide the error information and the full statement text if applicable to Datometry Customer Success.

DTM8616

Failed: '~ts' is not a macro.

Invalid SHOW statement.

Provide the error information and the full statement text if applicable to Datometry Customer Success.

DTM8617

Invalid input range. Value '~p' must be in range '~ts'.

Provide the error information and the full statement text if applicable to Datometry Customer Success.

DTM8618

Column'~ts' is an index column and cannot be modified/dropped.

DROP/RENAME COLUMN not allowed.

Provide the error information and the full statement text if applicable to Datometry Customer Success.

DTM8619

Input: numeric value within range only.

Provide the error information and the full statement text if applicable to Datometry Customer Success.

DTM8620

Ordered Analytical Functions not allowed in GROUP BY Clause.

Provide the error information and the full statement text if applicable to Datometry Customer Success.

DTM8621

Regular expression '~ts' is not valid

This message is displayed when using an an invalid regular expression. Verify that the syntax of the regular expression statement is valid.

If the problem persists, provide the error information and the full statement text if applicable to Datometry Customer Success.

DTM8622

This message is displayed when using an an invalid number or parameter type. Verify the syntax of the statement and correct as needed.

If the problem persists, provide the error information and the full statement text if applicable to Datometry Customer Success.

DTM8623

If necessary, put the sampling request in a derived table, and request that it be implemented.

DTM8624

DTM8625

DTM8626

DTM8627

DTM8628

DTM8629

DTM8630

DTM8631

DTM8632

DTM8634

DTM8636

DTM8637

DTM8638

DTM8639

DTM8640

DTM8641

Existing columns: ~ts, new columns: ~ts

DTM8642

DTM9000

Unsupported feature '~ts'.

This message is displayed when using an unsupported feature. 

Make sure that the feature is supported and provide the error information and the full statement text to Datometry Customer Success otherwise rewrite the statement.

DTM9001

Unsupported lock type '~ts'.

Provide the error information and the full statement text if applicable to Datometry Customer Success.

DTM9002

Unsupported lock option '~ts'.

Provide the error information and the full statement text if applicable to Datometry Customer Success.

DTM9003

Unsupported CREATE TABLE statement: '~ts'.

CREATE TABLE statement cannot be mapped to backend database.

Provide the error information and the full statement text if applicable to Datometry Customer Success.

DTM9007

Unexpected error handler condition: '~p'.

Provide the error information and the full statement text if applicable to Datometry Customer Success.

DTM9011

Unsupported operation to convert the format of type '~ts'.

Only converting to date is supported.

Provide the error information and the full statement text if applicable to Datometry Customer Success.

DTM9012

Unsupported argument type for STDDEV_SAMP function '~ts'.

Only numerical data types are supported.

Provide the error information and the full statement text if applicable to Datometry Customer Success.

DTM9013

Query banding is unsupported.

Provide the error information and the full statement text if applicable to Datometry Customer Success.

DTM9014

Unsupported arithmetic operation with non-constant interval expression.

Provide the error information and the full statement text if applicable to Datometry Customer Success.

DTM9015

Unsupported data type '~p'.

This message is displayed when the statement contains an unsupported data type. The type will be displayed after "Unsupported data type" message. 

Run the same statement against your Teradata system and if it works provide the error information and the full statement text to the Datometry Customer Success otherwise rewrite the statement.

DTM9016

Handler for conditions '~p' is already defined.

Provide the error information and the full statement text if applicable to Datometry Customer Success.

DTM9017

DML statements not supported by the backend system: '~p'.

Certain DML statements (DELETE/UPDATE not supported by the backend system.

Provide the error information and the full statement text if applicable to Datometry Customer Success.

DTM9018

Transaction related statements not supported by the backend system.

Provide the error information and the full statement text if applicable to Datometry Customer Success.

DTM9019

Unsupported set operation by the backend system: '~p'.

Certain set operations (e.g. INTERSECT, EXCEPT are not supported by the backend system.

Provide the error information and the full statement text if applicable to Datometry Customer Success.

DTM9020

Stored procedures not supported for the backend system.

Provide the error information and the full statement text if applicable to Datometry Customer Success.

DTM9021

Invalid query syntax: '~p'.

Provide the error information and the full statement text if applicable to Datometry Customer Success.

DTM9022

Invalid 'SQLCODE' reference.

Provide the error information and the full statement text if applicable to Datometry Customer Success.

DTM9023

Unsupported DML operation on updatable views.

Provide the error information and the full statement text if applicable to Datometry Customer Success.

DTM9024

Unsupported access to system object: '~ts'.

This message is displayed when the statement contains an unsupported system object.  

Try to run the same statement against Teradata system and if it works provide the error information and the full statement text to Datometry Customer Success otherwise rewrite the statement.

DTM9025

Unsupported query element: '~ts'.

Provide the error information and the full statement text if applicable to Datometry Customer Success.

DTM9026

DDL statements not supported by the backend system: '~p'.

Certain DDL statements (e.g. CREATE INDEX not supported by the backend system.

Provide the error information and the full statement text if applicable to Datometry Customer Success.

DTM9028

View ~ts is not updatable.

Provide the error information and the full statement text if applicable to Datometry Customer Success.

DTM9029

View definition for view ~ts could not be parsed.

Provide the error information and the full statement text if applicable to Datometry Customer Success.

DTM9030

Invalid reference to non-determinstic expression: '~ts'.

Provide the error information and the full statement text if applicable to Datometry Customer Success.

DTM9031

Creating index not supported by the backend system.

This error is returned when trying to create an index on the backend system which does not have support for that, e.g. the error should be issued when trying to create a unique index on Redshift.

Try to run the same statement against your Teradata system and if it works provide the error information and the full statement text to the Datometry Customer Success otherwise rewrite the statement.

DTM9037

Invalid data for USING modifier: '~ts'.

Provide the error information and the full statement text if applicable to Datometry Customer Success.

DTM9038

View definition for view ~ts could not be retrieved.

Provide the error information and the full statement text if applicable to Datometry Customer Success.

DTM9039

Definition of view '~ts' references itself.

View definition could not be parsed because of recursive reference.

Provide the error information and the full statement text if applicable to Datometry Customer Success.

DTM9040

Invalid merge statement: '~ts'.

Provide the error information and the full statement text if applicable to Datometry Customer Success.

DTM9041

Unsupported merge statement: '~ts'.

Provide the error information and the full statement text if applicable to Datometry Customer Success.

DTM9042

MLoad job error. Reason: '~p'.

Provide the error information and the full statement text if applicable to Datometry Customer Success.

DTM9043

An MultiLoad job for table '~ts.~ts' is already running.

Provide the error information and the full statement text if applicable to Datometry Customer Success.

DTM9044

Invalid select list. Reason :'~p'.

Provide the error information and the full statement text if applicable to Datometry Customer Success.

DTM9045

Too many END TRANSACTION statements.

Provide the error information and the full statement text if applicable to Datometry Customer Success.

DTM9047

Invalid UPSERT statement: '~ts'.

Provide the error information and the full statement text if applicable to Datometry Customer Success.

DTM9048

The user cannot RENAME to a new database.

Provide the error information and the full statement text if applicable to Datometry Customer Success.

DTM9049

Database unspecified for '~ts'.

Must specify database name.

Provide the error information and the full statement text if applicable to Datometry Customer Success.

DTM9050

Volatile table '~ts' not allowed in statement.

Provide the error information and the full statement text if applicable to Datometry Customer Success.

DTM9051

Column name list is not the same length as the select list.

Provide the error information and the full statement text if applicable to Datometry Customer Success.

DTM9056

Invalid unicode literal: '~p'.

Provide the error information and the full statement text if applicable to Datometry Customer Success.

DTM9057

MLoad retry error: maximum number of errors reached.

Provide the error information and the full statement text if applicable to Datometry Customer Success.

DTM9058

Invalid block number in the FastExport Initiate request.

Provide the error information and the full statement text if applicable to Datometry Customer Success.

DTM9059

Check constraint not satisfied for view ~ts.

Provide the error information and the full statement text if applicable to Datometry Customer Success.

DTM9060

Invalid update statement: '~ts'.

Provide the error information and the full statement text if applicable to Datometry Customer Success.

DTM9061

~ts must be empty for Fast Loading.

Table must be empty for Fast Loading.

Provide the error information and the full statement text if applicable to Datometry Customer Success.

DTM9062

Duplication of column ~ts in a table, derived table, view, macro or trigger.

Duplicate column used in object definition.

Provide the error information and the full statement text if applicable to Datometry Customer Success.

DTM9063

Unsupported CREATE DATABASE statement.

Provide the error information and the full statement text if applicable to Datometry Customer Success.

DTM9064

Unsupported timezone specifier: ~ts.

Provide the error information and the full statement text if applicable to Datometry Customer Success.

DTM9065

Unsupported GIVE statement.

Provide the error information and the full statement text if applicable to Datometry Customer Success.

DTM9066

Unsupported SHOW STATISTICS: SHOW STATISTICS | STAT | STATS.

Hyper-Q does not support 'SHOW STATISTICS | STAT | STATS' features yet

Provide the error information and the full statement text if applicable to Datometry Customer Success.

DTM9067

Unsupported QUEUE TABLE statement from parser.

Provide the error information and the full statement text if applicable to Datometry Customer Success.

DTM9068

Unsupported DROP DATABASE statement.

Provide the error information and the full statement text if applicable to Datometry Customer Success.

DTM9069

Unsupported DELETE DATABASE statement.

Provide the error information and the full statement text if applicable to Datometry Customer Success.

DTM9070

Unsupported MODIFY DATABASE statement.

Provide the error information and the full statement text if applicable to Datometry Customer Success.

DTM9071

Unsupported NOT NULL in CTAS column.

Provide the error information and the full statement text if applicable to Datometry Customer Success.

DTM9072

Unsupported PERIOD FOR statement.

Provide the error information and the full statement text if applicable to Datometry Customer Success.

DTM9073

Unsupported HELP DATABASE statement.

Provide the error information and the full statement text if applicable to Datometry Customer Success.

DTM9074

Unsupported Collect Statistics.

Provide the error information and the full statement text if applicable to Datometry Customer Success.

DTM9075

Unsupported Translation of Labels in REPEAT.

Provide the error information and the full statement text if applicable to Datometry Customer Success.

DTM9076

Unsupported Multi-character delimiters in STRTOK.

Provide the error information and the full statement text if applicable to Datometry Customer Success.

DTM9077

Unsupported EXPLAIN statement.

Provide the error information and the full statement text if applicable to Datometry Customer Success.

DTM9078

Unsupported feature 'Identity Column'.

Provide the error information and the full statement text if applicable to Datometry Customer Success.

DTM9079

Unsupported Transaction Command.

Provide the error information and the full statement text if applicable to Datometry Customer Success.

DTM9080

Unsupported Update Identity Column feature.

Provide the error information and the full statement text if applicable to Datometry Customer Success.

DTM9081

Unsupported day_number_of_year statement.

Provide the error information and the full statement text if applicable to Datometry Customer Success.

DTM9082

Unsupported Emulation of UDFs statement.

Provide the error information and the full statement text if applicable to Datometry Customer Success.

DTM9083

Unsupported Non UTC Timezone statement.

Provide the error information and the full statement text if applicable to Datometry Customer Success.

DTM9084

Unsupported Updatable view for non-Teradata endpoint.

Provide the error information and the full statement text if applicable to Datometry Customer Success.

DTM9085

Unsupported format string for function TO_CHAR.

Provide the error information and the full statement text if applicable to Datometry Customer Success.

DTM9086

Unsupported quantified subquery: ~ts.

Provide the error information and the full statement text if applicable to Datometry Customer Success.

DTM9087

Unsupported value for the search start position: '~ts'.

Provide the error information and the full statement text if applicable to Datometry Customer Success.

DTM9088

Unsupported value for Occurrence: ~ts.

Provide the error information and the full statement text if applicable to Datometry Customer Success.

DTM9089

Unsupported value for Match option: ~ts.

Provide the error information and the full statement text if applicable to Datometry Customer Success.

DTM9090

Unsupported type for Identity Column.

Provide the error information and the full statement text if applicable to Datometry Customer Success.

DTM9091

Unsupported CREATE GLOBAL TEMPORARY TABLE inside stored procedure.

Provide the error information and the full statement text if applicable to Datometry Customer Success.

DTM9092

Unsupported Insert into Identity Column.

Provide the error information and the full statement text if applicable to Datometry Customer Success.

DTM9093

Unsupported Set Session Collation.

Provide the error information and the full statement text if applicable to Datometry Customer Success.

DTM9095

A table may not have more than one identity column.

Provide the error information and the full statement text if applicable to Datometry Customer Success.

DTM9096

Invalid insert statement: '~ts'.

Provide the error information and the full statement text if applicable to Datometry Customer Success.

DTM9098

Stored procedure exception ~ts.

Provide the error information and the full statement text if applicable to Datometry Customer Success.

DTM9099

Unsupported string literal in pattern.

Provide the error information and the full statement text if applicable to Datometry Customer Success.

DTM9100

MultiLoad MARK DUPLICATE INSERT (dup row).

Provide the error information and the full statement text if applicable to Datometry Customer Success.

DTM9101

MultiLoad MARK DUPLICATE UPDATE.

Provide the error information and the full statement text if applicable to Datometry Customer Success.

DTM9102

Distinct option is invalid with OVER phrase.

Provide the error information and the full statement text if applicable to Datometry Customer Success.

DTM9103

REGEXP function parameter '~p' is not supported on backend

REGEXP function is not supported.

Due to limited support for REGEXP in the target CDW, revise the query to use string expressions or supported variants of REGEXP functions.

DTM9104

SET QUERY_BAND PROXY_USER is not supported

To make a proxy user connection, a middle tier application that is connected as a trusted user issues a SET QUERY_BAND request that specifies the proxy user name and an optional proxy role for that user. The reserved query band names PROXYUSER and PROXYROLE are used to specify a trusted session user name and proxy role name in the SET QUERY_BAND request, respectively.

If the query band specifies PROXYUSER, Teradata validates that the current user has privileges to connect as the specified proxy user.

A SET QUERY_BAND request returns an error whenever any of the following violations occur.

• The proxy user does not have CONNECT THROUGH privileges with the trusted user.
• The proxy user has not been granted privileges for the specified proxy role.
• The request attempts to set a PROXYUSER for a transaction when a session trusted session already exists.
• The request attempts to set a PROXYUSER for a session when a transaction proxy connection already exists.

Reissue the SET QUERY_BAND statement with a valid proxy user.

DTM9105

Duplicate unique primary key error in ~s table.

Duplicate unique primary key error.

The request generated a row whose prime key duplicated that of an existing row in a table with a unique prime key.

DTM9106

Duplicate row in table ~s.

Duplicate row in table.

An update or insert request generated a row that was a duplicate of an existing row.

Correct and resubmit the request.

DTM9108

Value list too long.

Default value List is too long.

Alter table query caused Default value list to exceed the maximum permissible limit.(1MB)

Decrease the number of Default value columns, or split the ALTER TABLE request into multiple ALTER TABLE requests.

DTM9109

'~s' is not a stored procedure.

Invalid stored procedure version is invalid.

The stored procedure version is not compatible with the Teradata RDBMS server release. It is either out dated or not supported in the current Teradata system release. The version mismatch may be because the stored procedure is created on a different version of the server and is being used in a server release where its behavior may be unpredictable.

Recompile the stored procedure in the current Teradata system.

DTM9110

'~s' is not a macro.

The specified item is a table or view and must be changed to a macro in this context.

DTM9111

Failed to extract source of macro or procedure.

Failed to extract source of macro or procedure.

DTM9112

Column property modified: '~ts'

Column property modified.

DTM9113

PARTITION BY used by CREATE TABLE statement is ignored.

PARTITION BY used by CREATE TABLE statement is ignored.

DTM9114

SET option used by CREATE TABLE statement is ignored.

SET option used by CREATE TABLE statement is ignored.

DTM9115

ON COMMIT PRESERVE/DELETE ROWS option used by CREATE TABLE statement is ignored.

ON COMMIT PRESERVE/DELETE ROWS option used by CREATE TABLE statement is ignored.

DTM9116

Uniqueness constraint on index used by CREATE TABLE statement is ignored: '~ts'

Uniqueness constraint on index used by CREATE TABLE statement is ignored.

For a CREATE TABLE statement, a row partitioned primary index is not allowed to be unique unless all the partitioning columns are included in the set of primary index columns. For an ALTER TABLE statement, UNIQUE may only be specified if the primary index for the table is already unique, there is a unique secondary index on the same set of columns as the primary index, or the table is empty. In addition, a row partitioned primary index may only be specified as UNIQUE if all the partitioning columns are included in the set of primary index columns and altering the primary index columns of a unique primary index to not include all the partitioning columns is only allowed if NOT UNIQUE is specified. If the primary index is altered to be unique and there is a unique secondary index on the same set of columns as the primary index, the unique secondary index is dropped since it is no longer needed.

Use a unique secondary index to define the columns as unique if not all the partitioning columns are included in the set of primary index columns.

Examine the SQL statement and verify that the request is correct. Change the statement to adhere to the partitioned primary index rules and resubmit the request.

DTM9117

Unsupported TEMPORAL TABLE statement.

Temporal operations on a table without a primary index can be done only when EnableNoPITemporal flag in the cost profile is set to 1.

Set EnableNoPITemporal flag in the cost profile to 1 and re-submit the statement.

DTM9118

Unsupported SELECT AND CONSUME statement.

Set operations do not operate on SELECT AND CONSUME statements.

DTM9119

Unsupported NONSEQUENCED SELECT statement.

Unsupported NONSEQUENCED SELECT statement.

DTM9120

Unsupported NONTEMPORAL DELETE statement.

Unsupported NONTEMPORAL DELETE statement.

DTM9121

Unsupported TEMPORAL column.

Unsupported TEMPORAL column.

DTM9122

Unsupported XML column.

Unsupported XML column. 

DTM9123

Unsupported JSON column.

Unsupported JSON column.

DTM9124

Unsupported JSON COMPOSE.

JSON_COMPOSE creates a JSON document composed of the input parameters specified. This function provides a complex composition of a JSON document when used in conjunction with the JSON_AGG function.

DTM9125

Unsupported JSON AGG.

The JSON_AGG function returns a JSON document composed of aggregated values from each input parameter. The input parameters can be a column reference or an expression. Each input parameter results in a name/value pair in the returned JSON document.

DTM9126

Unsupported JSON_CHECK.

The JSON_CHECK function checks a string for valid JSON syntax and provides an informative error message about the cause of the syntax failure if the string is invalid.

DTM9127

Mismatch between required and specified parameters.

The EXECUTE command for a parameterized SQL statement specifies a list of parameters. The number of parameters in that list must equal the number of parameters that appear within the SQL statement.

Correct the SQL statement and resubmit.

DTM9128

A MultiLoad DELETE Statement is Invalid.

In a MultiLoad Complex Import Task, the user provided a DELETE statement that does not fully specify a primary index value or the values of all the partitioning columns. Or, in a MultiLoad Delete Task, the user provided a DELETE statement that specified a primary index.

Correct the error and resubmit the request. In a MultiLoad Complex Import Task, the WHERE condition, including any taken from a view definition, must allow for primary index access (and, if partitioned, partition access) with possible ANDed residual conditions. It must also reference no other tables or views. In a MultiLoad Delete Task, the WHERE condition, including any taken from a view definition, must not include a primary index access. It must also reference no other tables or views.

DTM9129

Unsupported BLOB column.

Ordered analytical functions do not operate on the following data types:

• CLOB or BLOB data types
• UDT data types

Note that CLOB, BLOB, or UDT data types are usable inside an expression if the result is a supported data type. 

DTM9130

Unsupported GEO column.

The target database does not support the Geospatial data type. 

DTM9131

XTRA structural_specs is not implemented. Mod: ~p"

Provide the error information and the full statement text if applicable to Datometry Customer Success.

DTM9132

SQLOP structural_specs is not implemented. Mod: ~p"

Provide the error information and the full statement text if applicable to Datometry Customer Success.

DTM9133

Distribution is ignored for MSSQL

Provide the error information and the full statement text if applicable to Datometry Customer Success.

DTM9134

Pick first column for distribution column due to native_multicolumn_max_cols = 1

Provide the error information and the full statement text if applicable to Datometry Customer Success.

DTM9135

Use ROUND_ROBIN for distribution due to native_multicolumn_distribution = true for wide tables

Use ROUND_ROBIN distribution for tables with more than 8 columns in the primary index (default), or more than the value specified. Synapse supports only up to 8 distribution columns, whereas Teradata allows up to 64 columns in the primary index.

• Use "gateway".native_multicolumn_distribution = true to enable Hyper-Q or qShift to output multiple distribution columns in the Synapse DDL. By default, up to 8 first primary index columns are used as the Synapse distribution columns.
  
  
• In rare cases, when the original Teradata table has more than 8 primary index columns, it may be necessary to use Round Robin distribution instead of using only the first 8 primary index columns as the distribution columns. This may occur, for example, if all 8 columns exhibit data skew. In this scenario, add the option "gateway".native_multicolumn_limit_round_robin.

DTM9136

Pick all distribution columns.

Provide the error information and the full statement text if applicable to Datometry Customer Success.

DTM9137

Pick first N columns as specified by the

native_multicolumn_max_cols

config parameter.

The number of columns in Teradata Primary Index that
Hyper-Q uses as HASH columns. Default is 8 columns.

This is only applicable if native_multicolumn_distribution = true except for native_multicolumn_max_cols = 1 which will pick the first Primary Index (PI) or Unique Primary Index (UPI) for HASH column regardless of the the value specified with native_multicolumn_distribution.

DTM9138

Pick only column AS-IS.

Provide the error information and the full statement text if applicable to Datometry Customer Success.

DTM9139

No option is applicable, use Round-Robin for distribution.

Use a Round Robin distribution style.

DTM9140

IDENTITY column in distribution columns ignored.

Provide the error information and the full statement text if applicable to Datometry Customer Success.

DTM9141

Ignore a large column (with max size) in distribution columns.

Provide the error information and the full statement text if applicable to Datometry Customer Success.

DTM9142

Use HEAP table layout for table with large (with max size) columns.

Use HEAP table layout style.

HEAP tables can be used as staging tables for large, unordered insert operations. Because data is inserted without enforcing a strict order, the insert operation is usually faster than the equivalent insert into a clustered index.

DTM9143

Use HEAP table layout for mload work table.

Use HEAP table layout style.

HEAP tables can be used as staging tables for large, unordered insert operations. Because data is inserted without enforcing a strict order, the insert operation is usually faster than the equivalent insert into a clustered index.

DTM9144

Use HEAP table layout due to default_table_layout config.

The Hyper-Q hint to be used to set default table layout in CREATE TABLE statement in Azure Synapse to be HEAP instead of empty, which defaults to clustered column store index.

"gateway".default_table_layout = heap

DTM9145

No option is applicable. Use default table layout.

Use default table layout.

DTM9146

Renaming columns is unsupported for BigQuery.

You can not rename columns in Google BigQuery.

DTM9147

Unsupported Number Format ~ts

The number format is not supported.

DTM9148

Pick first column for distribution column due to wide columns in the table.

Pick first column for distribution column due to wide columns in the table.

DTM9150

DROP JOIN INDEX is ignored.

-or-

EXPLAIN with no option is ignored.

Provide the error information and the full statement text if applicable to Datometry Customer Success.

DTM9151

EXPLAIN DATABASE is ignored.

Provide the error information and the full statement text if applicable to Datometry Customer Success.

DTM9152

DIAGNOSTIC statement is ignored.

DIAGNOSTIC statement is ignored.

DTM9153

STATS FROM option is ignored.

STATS FROM option is ignored.

DTM9154

FASTEXPORT spool option is ignored.

FASTEXPORT spool option is ignored.

DTM9155

LOCKING hint in HELP statement is ignored.

LOCKING hint in HELP statement is ignored.

DTM9156

DROP TABLE is ignored.

DROP TABLE is ignored.

DTM9157

CREATE TABLE is ignored.

CREATE TABLE is ignored.

DTM9158

DROP INDEX is ignored.

DROP INDEX is ignored.

DTM9159

CREATE INDEX is ignored.

CREATE INDEX is ignored.

DTM9160

ITERATE statement is ignored.

ITERATE statement is ignored.

DTM9161

SEQUENCE statement is ignored.

SEQUENCE statement is ignored.

DTM9162

MLOAD request is ignored.

The Teradata MultiLoad request was ignored.

DTM9163

MLOAD INSERT statement is ignored.

The Teradata MultiLoad INSERT statement was ignored.

DTM9164

MLOAD DELETE statement is ignored.

The Teradata MultiLoad DELETE statement is ignored.

DTM9165

RELEASE MLOAD is ignored.

RELEASE MLOAD is ignored.

DTM9166

COMMENT statement is ignored.

COMMENT statement is ignored.

DTM9167

DROP STATS statement is ignored.

DROP STATS statement is ignored.

DTM9168

COLLECT STATS is ignored.

COLLECT STATS is ignored.

DTM9169

EXEC DYNAMIC SQL is ignored.

EXEC DYNAMIC SQL is ignored.

DTM9170

SWITCH DATABASE statement is ignored.

SWITCH DATABASE statement is ignored.

DTM9171

CALL PROCEDURE statement is ignored.

CALL PROCEDURE statement is ignored.

DTM9172

UPDATE statement is ignored.

UPDATE statement is ignored.

DTM9173

INSERT statement is ignored.

INSERT statement is ignored.

DTM9174

ALTER TABLE statement is ignored.

ALTER TABLE statement is ignored.

DTM9175

ALTER PROCEDURE statement is ignored.

ALTER PROCEDURE statement is ignored.

DTM9176

BEGIN QUERY LOGGING statement is ignored.

BEGIN QUERY LOGGING statement is ignored.

DTM9177

END QUERY LOGGING statement is ignored.

END QUERY LOGGING statement is ignored.

DTM9178

REPLACE QUERY LOGGING statement is ignored.

REPLACE QUERY LOGGING statement is ignored.

DTM9179

FETCH CURSOR is ignored.

FETCH CURSOR is ignored.

DTM9180

CHECKPOINT statement is ignored.

CHECKPOINT statement is ignored.

DTM9181

CREATE JOIN INDEX statement is ignored.

CREATE JOIN INDEX statement is ignored.

DTM9184

DUMP statement is ignored.

DUMP statement is ignored.

DTM9185

HELP STATS is ignored.

HELP STATS is ignored.

DTM9187

RELEASE LOCK is ignored.

RELEASE LOCK is ignored.

DTM9189

SET SESSION COLLATION is ignored.

SET SESSION COLLATION is ignored.

DTM9190

SET SESSION TRANSACTION is ignored.

SET SESSION TRANSACTION is ignored.

DTM9191

BEGIN TRANSACTION is ignored.

BEGIN TRANSACTION is ignored.

DTM9192

COMMIT is ignored.

COMMIT is ignored.

DTM9193

ROLLBACK is ignored.

ROLLBACK is ignored.

DTM9194

UNKNOWN statement is ignored.

UNKNOWN statement is ignored.

DTM9195

DROP STATISTICS on PARTITION column is ignored.

DROP STATISTICS on PARTITION column is ignored.

DTM9196

Non-constant default value is ignored.

Non-constant default value is ignored.

DTM9197

Current database default value is ignored.

Current database default value is ignored.

DTM9198

Create index on global temporary table is ignored.

Create index on global temporary table is ignored.

DTM9199

Uniqueness constraint on index is ignored. index: '~ts'

Uniqueness constraint on index is ignored.

DTM9200

Create index on volatile table is ignored.

Create index on volatile table is ignored.

DTM9201

Create index on set table is ignored.

Create index on set table is ignored.

DTM9202

Create index on CREATE TABLE AS ... is ignored.

Create index on CREATE TABLE AS ... is ignored.

DTM9203

Create non-unique index on distribution column is ignored.

Create non-unique index on distribution column is ignored.

DTM9204

USING option in COLLECT STATS is ignored.

USING option in COLLECT STATS is ignored.

DTM9205

CREATE INDEX is ignored. Number of index columns exceeds the maximum number of allowed index columns.

Change the index definition and resubmit the request.

DTM9206

PRIMARY KEY CONSTRAINT '~ts' in alter table is ignored.

PRIMARY KEY CONSTRAINT in alter table is ignored.

DTM9207

PRIMARY KEY CONSTRAINT '~ts' is ignored because serialize_primary_key config is disabled.

PRIMARY KEY CONSTRAINT is ignored because serialize_primary_key configuration is disabled.

To serialize the PRIMARY KEY on Azure Synapse you can enable the serialize_primary_key configuration parameter. To do so, add the following to the Hyper-Q configuration file (DTM.INI).

"gateway".serialize_primary_key=true

DTM9208

Composite PRIMARY KEY CONSTRAINT is ignored.

Composite PRIMARY KEY CONSTRAINT is ignored.

DTM9209

Ignore a large column (with max size) for clustered index.

Ignore a large column (with max size) for clustered index.

DTM9210

Override table layout. Inferred: ~ts, overriden: ~ts

Override table layout.

DTM9211

Override table layout columns. Inferred: ~ts, overriden: ~ts

Override table layout columns.

DTM9212

Override distribution style. Inferred: ~ts, overriden: ~ts

Override distribution style.

DTM9213

Override distribution columns. Inferred: ~ts, overriden: ~ts

Override distribution columns.

DTM9214

Invalid overridden distribution style: ~ts

Invalid overridden distribution style.

DTM9215

Invalid overridden table layout: ~ts

Invalid overridden table layout

DTM9216

The overridden columns are not in the table columns.Override columns: ~ts, Table columns: ~ts

The overridden columns are not in the table columns.

DTM9217

Table layout overridden to clustered index but columns are not defined. Use primary index columns by default. Columns: ~ts

Table layout overridden to clustered index but columns are not defined. Use primary index columns by default.

DTM9218

No column is defined for hash distribution.

No column is defined for hash distribution.

DTM9219

No column is defined for clustered index.

No column is defined for clustered index.

DTM9220

No column is defined for hash distribution in table ~ts.~ts

No column is defined for hash distribution in the table.

DTM9221

Invalid column for statistics. Column: ~ts table: ~ts.~ts

Invalid column for statistics.

DTM9222

Unsupported regular expression pattern.

Unsupported regular expression pattern.

DTM9223

Unsupported DROP STATISTICS.

Unsupported DROP STATISTICS.

DTM9224

Dropping index not supported by the backend system:

Dropping index not supported by the backend system.

DTM9225

Invalid override table uniqueness option, value: ~ts, expected: 
none|ignore_set|ignore_upi|ignore_all

Invalid override table uniqueness option.

DTM9226

Invalid table options generator, value: ~ts, expected: default|smart

Invalid table options generator.

DTM9227

FastExport NoSpool mode finished retrieving all data chunks.

FastExport NoSpool mode finished retrieving all data chunks.

DTM9228

Secondary index uniqueness violation in ~s table.

Secondary index uniqueness violation.

DTM9229

Comparing BYTE data with other types is illegal.

Comparing BYTE data with other types is illegal.

DTM9230

Numeric overflow occurred during computation.

Numeric overflow occurred during computation.

DTM9501

Job forced to fail due to bulkload errors

The bulkload job was forced to fail (exit code different than 0) due to entries present in the ET error table or the UV error table or both.

• When property "gateway".bulk_load_fail_on_et_errors = true and there are entries in ET error table, the job is forced to fail
  
• When property "gateway".bulk_load_fail_on_uv_errors = true and there are entries in UV error table, the job is forced to fail

DTM9502

Bulk load copy data operation has likely reached limit.

Bulk load copy data operation has likely reached limit.

DTM10001

Failure parsing JSON for method: ~ts

Failure parsing JSON.

DTM10002

Schema or table lookup has failed.

Schema or table lookup has failed.

DTM10003

Existing statistics are not allowed to be recollected with a new statistics name ~ts

Existing statistics are not allowed to be recollected with a new statistics name.

DTM11001

Unsupported pattern for ROWNUM.

Unsupported pattern for ROWNUM.

DTM12001

A character string failed conversion to a numeric value.

A character string failed conversion to a numeric value.

DTM12002

Overflow occurred computing an expression involving ~s.

Overflow occurred computing an expression.