Hyper-Q Error Codes

Internal Errors

Error Code

Description

Troubleshooting Instructions

DTM1001

Internal error

Cannot recover from an internal state violation

Critical server error.

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

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.

 

Connections Errors

Error Code

Description

Troubleshooting

Instructions

DTM1004

Connection shut down by administrator.

Process killed due to explicit request by admin

Provide the error information and the full statement text if applicable to Datometry support team.

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

Provide the error information and the full statement text if applicable to Datometry support team.

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 support team.

 

DTM2004

Authentication timed out.

Async authentication exceeded timeout

Provide the error information and the full statement text if applicable to Datometry support team.

DTM2005

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

Backend required an auth method not supported in loopback

Provide the error information and the full statement text if applicable to Datometry support team.

DTM3012

Database connection error '~ts'.

Server socket errored out unexpectedly

Verify the target database connection parameters. If the condition persists, provide the error info and the full statement text to Datometry support for further investigations.

DTM3013

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

Cannot connect to database at given location

Verify the target database connection parameters. If the condition persists, provide the error info and the full statement text to Datometry support for further investigations.

DTM3014

Database refused connection due to temporarily unavailable resources.

Server could not fork backend process

Provide the error information and the full statement text if applicable to Datometry support team.

DTM3020

TLS not supported for connection.

TLS connection is not supported

Provide the error information and the full statement text if applicable to Datometry support team.

DTM3021

Endpoint port '~B' unavailable: ~ts.

Another process is using this port

Provide the error information and the full statement text if applicable to Datometry support team.

DTM3022

Upgrading connection to TLS failed: '~p'.

TLS accept did not succeed

Provide the error information and the full statement text if applicable to Datometry support team.

DTM3031

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

Pool is at capacity and all backlog slots are full

Provide the error information and the full statement text if applicable to Datometry support team.

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

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

Provide the error information and the full statement text if applicable to Datometry support team.

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

Provide the error information and the full statement text if applicable to Datometry support team.

DTM3107

Cancel requested during authentication, shutdown connection

Provide the error information and the full statement text if applicable to Datometry support team.

DTM3110

ODBC port executable not found.

Failed to locate the ODBC port executable

Provide the error information and the full statement text if applicable to Datometry support team.

DTM3111

ODBC process received invalid request: '~p'.

ODBC process received invalid request

Provide the error information and the full statement text if applicable to Datometry support team.

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.

DTM5305

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

Verify the Metadata store configuration and connectivity between Hyper-Q and the underlying database. If the problem persists, provide the error information and the full statement text if applicable to Datometry support team.

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

Provide the error information and the full statement text if applicable to Datometry support team.

DTM8106

Protocol version '~p' not supported (retriable).

Client tried to connect with unsupported protocol version

Provide the error information and the full statement text if applicable to Datometry support team. 

DTM8271

Failed to extract metadata.

Failed to extract metadata from ODBC results

Provide the error information and the full statement text if applicable to Datometry support team.

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.

 

Syntax Errors

Error Code

Description

Troubleshooting Instructions

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.

 

Unknown Keyword Errors

Error Code

Description

Troubleshooting Instructions

DTM5012

Unknown endpoint type: '~ts'.

No suitable alpha process for endpoint type

Provide the error information and the full statement text if applicable to Datometry support team. 

DTM5013

Unknown gateway type: '~ts'.

Decoding of version string unsuccessful

Provide the error information and the full statement text if applicable to Datometry support team. 

DTM5202

Flag '~b' unknown.

Traceflag translation failed due to unknown flag

Provide the error information and the full statement text if applicable to Datometry support team.

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

Provide the error information and the full statement text if applicable to Datometry support team. 

DTM8036

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

Unknown conversion requested

Provide the error information and the full statement text if applicable to Datometry support team. 

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 support team.

DTM9035

Unknown incoming message type.

Provide the error information and the full statement text if applicable to Datometry support team.

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.

 

License Errors

Error Code

Description

Troubleshooting Instructions

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

Provide the error information and the full statement text if applicable to Datometry support team. 

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

 

LDAP Errors

Error Code

Description

Troubleshooting Instructions

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.

 

GSS API Errors

Error Code

Description

Troubleshooting Instructions

DTM2201

GSSAPI: ~ts.

Generic GSS error; details to be filled by GSS plugin

Provide the error information and the full statement text if applicable to Datometry support team. 

DTM2202

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

Realm returned from GSSAPIs does not match configuration

Provide the error information and the full statement text if applicable to Datometry support team. 

DTM2203

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

GSS returned a different user name that was originally given

Provide the error information and the full statement text if applicable to Datometry support team.

 

Miscellaneous Errors

Error Code

Description

Troubleshooting Instructions

DTM1003

Fault injection.

Explicit injection of fault; only in debug version.

Provide the error information and the full statement text if applicable to Datometry support team.

DTM1009

OpenSSL not found.

No suitable OpenSSL library found.

Provide the error information and the full statement text if applicable to Datometry support team.

DTM1010

Encountered malformed packet.

Packet does not conform to expected protocol.

Provide the error information and the full statement text if applicable to Datometry support team.

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 support team.

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 support team.

DTM1053

Out of memory.

Provide the error information and the full statement text if applicable to Datometry support team.

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 support team.

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 support team.

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 support team.

DTM3004

Session timeout exceeded.

Session has been idle for too long.

Provide the error information and the full statement text if applicable to Datometry support team.

DTM3005

Transaction timeout exceeded.

Session held xact lock for too long.

Provide the error information and the full statement text if applicable to Datometry support team.

DTM3032

Data encryption not supported.

Provide the error information and the full statement text if applicable to Datometry support team.

DTM3108

Unsupported parameter type '~p'.

Provide the error information and the full statement text if applicable to Datometry support team.

DTM3109

Failed to decode date value.

Failed to decode date value.

Provide the error information and the full statement text if applicable to Datometry support team.

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 support team.

DTM3114

TDF cursor is closed.

Provide the error information and the full statement text if applicable to Datometry support team.

DTM4002

Syntax error in control command.

Provide the error information and the full statement text if applicable to Datometry support team.

DTM4003

Object not found or insufficient privileges for operation.

Provide the error information and the full statement text if applicable to Datometry support team.

DTM4004

Unexpected feature name: ~ts.

Provide the error information and the full statement text if applicable to Datometry support team.

DTM4005

mdi_cache file error: ~ts.

Provide the error information and the full statement text if applicable to Datometry support team.

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 support team.

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 support team.

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 support team.

DTM5003

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

Provide the error information and the full statement text if applicable to Datometry support team.

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 support team.

DTM5302

MDI interface : feature ~ts not implemented.

Provide the error information and the full statement text if applicable to Datometry support team.

DTM5306

Invalid MDStore table ~ts. Reason: ~ts.

Invalid MDStore table definition.

Provide the error information and the full statement text if applicable to Datometry support team.

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 support team.

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 support team.

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 support team.

DTM6103

Plugin timed out.

No answer from the plugin within timeout.

Provide the error information and the full statement text if applicable to Datometry support team.

   

Provide the error information and the full statement text if applicable to Datometry support team.

DTM8002

Unsupported language feature or parse error.

Provide the error information and the full statement text if applicable to Datometry support team.

DTM8003

Insufficient credentials.

Provide the error information and the full statement text if applicable to Datometry support team.

DTM8004

Invalid credential data.

Logon string format is not supported.

Provide the error information and the full statement text if applicable to Datometry support team.

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 support team.

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 support team.

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 support team.

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 support team.

DTM8009

Serialization failed: '~p'.

Provide the error information and the full statement text if applicable to Datometry support team.

DTM8010

Cannot execute the statement in compile only mode.

Provide the error information and the full statement text if applicable to Datometry support team.

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 support team.

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 support team.

DTM8031

Object '~ts' not found or no permission.

No valid metadata found for object 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 support team.

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 support team.

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 support team.

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 support team.

DTM8039

Object already exists in the variable scope.

Provide the error information and the full statement text if applicable to Datometry support team.

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 support team.

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 support team.

DTM8042

Schema '~ts' not found.

No schema found with given name.

Provide the error information and the full statement text if applicable to Datometry support team.

DTM8043

Failed to send file via client socket.

Provide the error information and the full statement text if applicable to Datometry support team.

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 support team.

DTM8045

Invalid input for NVL function.

Provide the error information and the full statement text if applicable to Datometry support team.

DTM8046

Max recursion depth exceeded by ~p.

Provide the error information and the full statement text if applicable to Datometry support team.

DTM8104

Malformed packet.

Packet corrupted or of unexpected format.

Provide the error information and the full statement text if applicable to Datometry support team.

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 support team.

DTM8108

Bad request.

Incoming request is not of expected type.

Provide the error information and the full statement text if applicable to Datometry support team.

DTM8109

Language feature '~ts' not yet supported.

Unsupported token.

Provide the error information and the full statement text if applicable to Datometry support team.

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 support team.

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 support team.

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 support team.

DTM8114

Bad literal (~p).

Modifier and value are not compatible.

Provide the error information and the full statement text if applicable to Datometry support team.

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 support team.

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 support team.

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 support team.

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 support team.

DTM8119

Invalid recursive view definition: ~ts.

Provide the error information and the full statement text if applicable to Datometry support team.

DTM8120

Function '~ts' returns unsupported type.

Unable to represent return type.

Provide the error information and the full statement text if applicable to Datometry support team.

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 support team.

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 support team.

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 support team.

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 support team.

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 support team.

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 support team.

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 support team.

DTM8128

Global table feature unsupported.

Provide the error information and the full statement text if applicable to Datometry support team.

DTM8129

Table variables in request scope not supported yet.

Provide the error information and the full statement text if applicable to Datometry support team.

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 support team.

DTM8131

Materialization of table variable failed: ~ts.

Table materialization statement failed.

Provide the error information and the full statement text if applicable to Datometry support team.

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 support team.

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 support team.

DTM8134

Invalid variable reference '~ts'.

Provide the error information and the full statement text if applicable to Datometry support team.

DTM8135

Boolean expression required in where clause.

Provide the error information and the full statement text if applicable to Datometry support team.

DTM8136

Column assignment required in update.

Provide the error information and the full statement text if applicable to Datometry support team.

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 support team.

DTM8138

Expected integer as left argument of operator #.

Provide the error information and the full statement text if applicable to Datometry support team.

DTM8139

Expected relational expression as argument of ungroup.

Provide the error information and the full statement text if applicable to Datometry support team.

DTM8140

Invalid arguments for sublist.

Provide the error information and the full statement text if applicable to Datometry support team.

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 support team.

DTM8142

Invalid multi-column reference.

Provide the error information and the full statement text if applicable to Datometry support team.

DTM8143

Expected table expression as argument of distinct.

Provide the error information and the full statement text if applicable to Datometry support team.

DTM8144

Expected table expression as argument of cols.

Provide the error information and the full statement text if applicable to Datometry support team.

DTM8145

Expected table expression as argument of meta.

Provide the error information and the full statement text if applicable to Datometry support team.

DTM8146

Expected symbol as argument of tables.

Provide the error information and the full statement text if applicable to Datometry support team.

DTM8147

Invalid table expression reference '~ts'.

Invalid table reference in mci.

Provide the error information and the full statement text if applicable to Datometry support team.

DTM8148

Invalid select specification.

Provide the error information and the full statement text if applicable to Datometry support team.

DTM8149

Invalid grouping specification.

Provide the error information and the full statement text if applicable to Datometry support team.

DTM8150

Invalid argument to differ operator.

Provide the error information and the full statement text if applicable to Datometry support team.

DTM8151

Expected non-negative integer as argument of til.

Provide the error information and the full statement text if applicable to Datometry support team.

DTM8152

Invalid dictionary specification.

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

Provide the error information and the full statement text if applicable to Datometry support team.

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 support team.

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 support team.

DTM8155

Cannot open script '~ts': ~ts.

Cannot open q script file.

Provide the error information and the full statement text if applicable to Datometry support team.

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 support team.

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 support team.

DTM8158

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

Provide the error information and the full statement text if applicable to Datometry support team.

DTM8159

Invalid concatenation.

Cannot concatenate table with other types.

Provide the error information and the full statement text if applicable to Datometry support team.

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 support team.

DTM8162

Q's stderr logging.

Provide the error information and the full statement text if applicable to Datometry support team.

DTM8163

Index out of bounds.

Provide the error information and the full statement text if applicable to Datometry support team.

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 support team.

DTM8165

Invalid argument for 'parse'.

Parse function accepts only string argument.

Provide the error information and the full statement text if applicable to Datometry support team.

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 support team.

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 support team.

DTM8168

Invalid constraints specification.

Provide the error information and the full statement text if applicable to Datometry support team.

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 support team.

DTM8170

Condition must be of boolean or integer type.

Provide the error information and the full statement text if applicable to Datometry support team.

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 support team.

DTM8172

Key accepts only table with key columns.

Provide the error information and the full statement text if applicable to Datometry support team.

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 support team.

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 support team.

DTM8175

Invalid IN arguments.

Unexpected number of columns in IN expression.

Provide the error information and the full statement text if applicable to Datometry support team.

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 support team.

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 support team.

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 support team.

DTM8179

Invalid delete query: ~ts.

Provide the error information and the full statement text if applicable to Datometry support team.

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 support team.

DTM8181

Invalid functional specification.

Expected three or four components.

Provide the error information and the full statement text if applicable to Datometry support team.

DTM8182

Xcols does not apply to keyed table.

Provide the error information and the full statement text if applicable to Datometry support team.

DTM8183

Invalid 'prepare_text' command separator.

Expected char type.

Provide the error information and the full statement text if applicable to Datometry support team.

DTM8184

Invalid high-order function definition.

Cannot parse parent function body.

Provide the error information and the full statement text if applicable to Datometry support team.

DTM8185

Encountered Q program error: ~ts.

Provide the error information and the full statement text if applicable to Datometry support team.

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 support team.

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 support team.

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 support team.

DTM8189

Failed to execute statement: '~ts'.

Serialization or execution failed.

Provide the error information and the full statement text if applicable to Datometry support team.

DTM8190

Error: ~ts.

Check type compatibility for comparison failed.

Provide the error information and the full statement text if applicable to Datometry support team.

DTM8191

SET TIMING ON' is not supported for this query.

Provide the error information and the full statement text if applicable to Datometry support team.

DTM8192

Multiple aggregations are not supported in where clause.

Provide the error information and the full statement text if applicable to Datometry support team.

DTM8201

Compiler error.

Bad xtra.

Provide the error information and the full statement text if applicable to Datometry support team.

DTM8202

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

Provide the error information and the full statement text if applicable to Datometry support team.

DTM8250

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

Provide the error information and the full statement text if applicable to Datometry support team.

DTM8251

Numeric overflow.

Provide the error information and the full statement text if applicable to Datometry support team.

DTM8252

Unsupported encryption method.

Provide the error information and the full statement text if applicable to Datometry support team.

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 support team.

DTM8254

Unsuccessful decryption of message: ~ts.

Provide the error information and the full statement text if applicable to Datometry support team.

DTM8255

Message unsupported in current protocol state: ~ts.

Provide the error information and the full statement text if applicable to Datometry support team.

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 support team.

DTM8257

Unsupported window construct: '~ts'.

Provide the error information and the full statement text if applicable to Datometry support team.

DTM8258

Record size must not exceed 64 KB.

Provide the error information and the full statement text if applicable to Datometry support team.

DTM8259

Invalid QUALIFY clause: ~ts.

Provide the error information and the full statement text if applicable to Datometry support team.

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 support team.

DTM8261

Grouping operation not supported by backend system.

Provide the error information and the full statement text if applicable to Datometry support team.

DTM8262

Invalid CREATE VIEW statement. Reason: ~ts.

Provide the error information and the full statement text if applicable to Datometry support team.

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 support team.

DTM8264

Invalid command: there is already an active transaction.

Provide the error information and the full statement text if applicable to Datometry support team.

DTM8265

Invalid command: there is no active transaction.

Provide the error information and the full statement text if applicable to Datometry support team.

DTM8266

Unsupported system procedure call: '~ts'.

Provide the error information and the full statement text if applicable to Datometry support team.

DTM8267

Invalid database name.

Provide the error information and the full statement text if applicable to Datometry support team.

DTM8268

SIGNAL with SQLSTATE or CONDITION name not yet supported.

Provide the error information and the full statement text if applicable to Datometry support team.

DTM8269

SET MESSAGE_TEXT not yet supported.

Provide the error information and the full statement text if applicable to Datometry support team.

DTM8270

RESIGNAL with SQLSTATE or CONDITION name not yet supported.

Provide the error information and the full statement text if applicable to Datometry support team.

DTM8272

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

Provide the error information and the full statement text if applicable to Datometry support team.

DTM8273

Failed TDF conversion.

Conversion to internal result representation has failed.

Provide the error information and the full statement text if applicable to Datometry support team.

DTM8274

Invalid calendar name '~ts'.

Provide the error information and the full statement text if applicable to Datometry support team.

DTM8275

Unsupported INSERT into a set table.

Provide the error information and the full statement text if applicable to Datometry support team.

DTM8276

Unsupported CREATE VIEW using WITH CHECK OPTION: ~ts.

Provide the error information and the full statement text if applicable to Datometry support team.

DTM8277

Database specified for function ~ts is ambiguous.

Provide the error information and the full statement text if applicable to Datometry support team.

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 support team.

DTM8279

Session flag ~p not supported with query override execution.

Provide the error information and the full statement text if applicable to Datometry support team.

   

Provide the error information and the full statement text if applicable to Datometry support team.

DTM8281

Command not allowed in an active transaction.

Provide the error information and the full statement text if applicable to Datometry support team.

DTM8302

String replacement with negative arguments not yet supported.

Provide the error information and the full statement text if applicable to Datometry support team.

DTM8303

Cols function on expressions with side effects not yet supported.

Provide the error information and the full statement text if applicable to Datometry support team.

DTM8304

Sublist function with negative arguments not yet supported.

Provide the error information and the full statement text if applicable to Datometry support team.

DTM8305

Type function on expressions with side effects not yet supported.

Provide the error information and the full statement text if applicable to Datometry support team.

DTM8306

Union join on keyed tables not yet supported.

Provide the error information and the full statement text if applicable to Datometry support team.

DTM8307

Anonymous columns not yet supported.

Provide the error information and the full statement text if applicable to Datometry support team.

DTM8308

Union all on different schemas not yet supported.

Provide the error information and the full statement text if applicable to Datometry support team.

DTM8309

Meta function on expressions with side effects not yet supported.

Provide the error information and the full statement text if applicable to Datometry support team.

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 support team.

DTM8311

Feature '~ts' not supported.

Provide the error information and the full statement text if applicable to Datometry support team.

DTM8312

Unsupported function call.

Provide the error information and the full statement text if applicable to Datometry support team.

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 support team.

DTM8314

Row-number selection on keyed tables not yet supported.

Provide the error information and the full statement text if applicable to Datometry support team.

DTM8315

Duplicate column symbols not supported in xcols.

Provide the error information and the full statement text if applicable to Datometry support team.

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 support team.

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 support team.

DTM8402

Cannot add unlocked result device to another device.

Provide the error information and the full statement text if applicable to Datometry support team.

DTM8403

Query result device failed to spill data to disk.

Provide the error information and the full statement text if applicable to Datometry support team.

DTM8404

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

Provide the error information and the full statement text if applicable to Datometry support team.

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 support team.

DTM8406

Client message character decoding failed '~p'.

Provide the error information and the full statement text if applicable to Datometry support team.

DTM8407

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

Provide the error information and the full statement text if applicable to Datometry support team.

DTM8501

Unexpected table alias for column '~p'.

Unexpected table alias.

The query is using aiases 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 support team.

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 support team.

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 support team.

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 support team.

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 support team.

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 support team.

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 support team.

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 support team.

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 support team.

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 support team.

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 support team.

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 support team.

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 support team.

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 support team.

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 support team.

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 support team.

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 support team.

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 support team.

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 support team.

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 support team.

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 support team.

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 support team.

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 ingored if the object defintions are static.

DTM8524

Undefined variable '~ts'.

Provide the error information and the full statement text if applicable to Datometry support team.

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 support team.

DTM8526

Invalid length specified for char or varchar type '~p'.

Type modifier for char or varchar type needs to be between 1 and 64000.

Provide the error information and the full statement text if applicable to Datometry support team.

DTM8527

Illegal clause or aggregation without table accessed.

Provide the error information and the full statement text if applicable to Datometry support team.

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 support team.

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 support team.

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 support team.

DTM8531

Insert statement has invalid target columns or value expressions.

Provide the error information and the full statement text if applicable to Datometry support team.

DTM8532

Variable '~ts' already defined.

Provide the error information and the full statement text if applicable to Datometry support team.

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 support team.

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 support team.

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 support team.

DTM8536

Unsupported cursor option '~ts'.

Provide the error information and the full statement text if applicable to Datometry support team.

DTM8537

SQLSTATE' reference outside exception handler block is unsupported.

Provide the error information and the full statement text if applicable to Datometry support team.

DTM8538

Unsupported 'SQLCODE' reference.

Provide the error information and the full statement text if applicable to Datometry support team.

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 support team

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 support team

DTM8541

Unable to resolve variable '~ts'.

Provide the error information and the full statement text if applicable to Datometry support team.

DTM8542

Invalid window operation: '~ts'.

Provide the error information and the full statement text if applicable to Datometry support team.

DTM8543

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

Provide the error information and the full statement text if applicable to Datometry support team.

DTM8544

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

Provide the error information and the full statement text if applicable to Datometry support team.

DTM8545

Invalid data attributes: multiple '~p' options.

Provide the error information and the full statement text if applicable to Datometry support team.

DTM8546

Duplicate common table expression definition '~ts'.

Provide the error information and the full statement text if applicable to Datometry support team.

DTM8547

Invalid argument to round function.

Provide the error information and the full statement text if applicable to Datometry support team.

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 support team.

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 support team.

DTM8550

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

Provide the error information and the full statement text if applicable to Datometry support team.

DTM8551

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

Provide the error information and the full statement text if applicable to Datometry support team.

DTM8552

Too many digits in exponent '~ts'.

Provide the error information and the full statement text if applicable to Datometry support team.

DTM8553

Invalid float value '~p'.

Provide the error information and the full statement text if applicable to Datometry support team.

DTM8554

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

Provide the error information and the full statement text if applicable to Datometry support team.

DTM8555

Unsupported function: '~p'.

Provide the error information and the full statement text if applicable to Datometry support team.

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 support team.

DTM8557

Unexpected sqlstate: ~p.

Provide the error information and the full statement text if applicable to Datometry support team.

DTM8558

Global temporary table parse error: '~ts'.

Provide the error information and the full statement text if applicable to Datometry support team.

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 support team.

DTM8560

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

Provide the error information and the full statement text if applicable to Datometry support team.

DTM8561

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

Provide the error information and the full statement text if applicable to Datometry support team.

DTM8562

Invalid named expression.

Provide the error information and the full statement text if applicable to Datometry support team.

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 support team.

DTM8564

Unsupported query band '~ts'.

Provide the error information and the full statement text if applicable to Datometry support team.

DTM8565

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

Provide the error information and the full statement text if applicable to Datometry support team.

DTM8566

Expected one row in query results.

Provide the error information and the full statement text if applicable to Datometry support team.

DTM8567

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

Provide the error information and the full statement text if applicable to Datometry support team.

DTM8568

Expected single row constant table.

Provide the error information and the full statement text if applicable to Datometry support team.

DTM8569

Case sensitivity specified for non-CHAR data.

Provide the error information and the full statement text if applicable to Datometry support team.

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 support team.

DTM8571

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

Provide the error information and the full statement text if applicable to Datometry support team.

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 support team.

DTM8573

Custom ABORT message.

Provide the error information and the full statement text if applicable to Datometry support team.

DTM8574

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

Provide the error information and the full statement text if applicable to Datometry support team.

DTM8575

Incorrect number of arguments when calling '~ts'.

Provide the error information and the full statement text if applicable to Datometry support team.

DTM8576

Invalid macro definition. Reason: ~p.

Provide the error information and the full statement text if applicable to Datometry support team.

DTM8577

Invalid interval type definition.

Provide the error information and the full statement text if applicable to Datometry support team.

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 support team.

DTM8579

Duplicate option for Identity Column.

Provide the error information and the full statement text if applicable to Datometry support team.

DTM8580

Illegal usage of Identity Column.

Provide the error information and the full statement text if applicable to Datometry support team.

DTM8581

Invalid data type for Identity Column.

Provide the error information and the full statement text if applicable to Datometry support team.

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 support team.

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 support team

DTM8584

Duplicate index column.

Provide the error information and the full statement text if applicable to Datometry support team.

DTM8585

Index '~ts' already exists.

Provide the error information and the full statement text if applicable to Datometry support team.

DTM8586

Invalid sample size '~p'.

Provide the error information and the full statement text if applicable to Datometry support team.

DTM8587

Database '~ts' does not exist.

Provide the error information and the full statement text if applicable to Datometry support team.

DTM8588

Conflicting CASESPECIFIC options.

Provide the error information and the full statement text if applicable to Datometry support team.

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 support team.

DTM8590

Interval field overflow.

Provide the error information and the full statement text if applicable to Datometry support team.

DTM8591

Statistics does not exist.

Provide the error information and the full statement text if applicable to Datometry support team.

DTM8592

Invalid function definition. Reason: ~p.

Provide the error information and the full statement text if applicable to Datometry support team.

DTM8593

Function reference ~ts is ambiguous.

Provide the error information and the full statement text if applicable to Datometry support team.

DTM8594

Unexpected error: ~p.

Provide the error information and the full statement text if applicable to Datometry support team.

DTM8595

Invalid hexadecimal constant '~p'.

Provide the error information and the full statement text if applicable to Datometry support team.

DTM8596

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

Provide the error information and the full statement text if applicable to Datometry support team.

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 support team.

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 support team.

DTM8599

Case not found for CASE statement.

Provide the error information and the full statement text if applicable to Datometry support team.

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 support team.

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 support team.

DTM8602

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

Provide the error information and the full statement text if applicable to Datometry support team.

DTM8603

Syntax error: expecting isolation level.

Provide the error information and the full statement text if applicable to Datometry support team.

DTM8604

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

Provide the error information and the full statement text if applicable to Datometry support team.

DTM8605

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

Provide the error information and the full statement text if applicable to Datometry support team.

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 support team.

DTM8607

No data found.

Provide the error information and the full statement text if applicable to Datometry support team.

DTM8608

Illegal statement following DDL statement in transaction.

Provide the error information and the full statement text if applicable to Datometry support team.

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 support team.

DTM8610

~ts' is not a temporary table.

Provide the error information and the full statement text if applicable to Datometry support team.

DTM8611

Failed: '~ts' is not a table.

Invalid SHOW statement.

Provide the error information and the full statement text if applicable to Datometry support team.

DTM8612

Failed: '~ts' is not a view.

Invalid SHOW statement.

Provide the error information and the full statement text if applicable to Datometry support team.

DTM8613

Invalid interval arithmetic operation (~p ~p).

Provide the error information and the full statement text if applicable to Datometry support team.

DTM8614

Invalid Query Band Search.

Provide the error information and the full statement text if applicable to Datometry support team.

DTM8615

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

Invalid SHOW statement.

Provide the error information and the full statement text if applicable to Datometry support team.

DTM8616

Failed: '~ts' is not a macro.

Invalid SHOW statement.

Provide the error information and the full statement text if applicable to Datometry support team.

DTM8617

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

Provide the error information and the full statement text if applicable to Datometry support team.

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 support team.

DTM8619

Input: numeric value within range only.

Provide the error information and the full statement text if applicable to Datometry support team.

DTM8620

Ordered Analytical Functions not allowed in GROUP BY Clause.

Provide the error information and the full statement text if applicable to Datometry support team.

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 support team otherwise rewrite the statement.

DTM9001

Unsupported lock type '~ts'.

Provide the error information and the full statement text if applicable to Datometry support team.

DTM9002

Unsupported lock option '~ts'.

Provide the error information and the full statement text if applicable to Datometry support team.

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 support team.

DTM9007

Unexpected error handler condition: '~p'.

Provide the error information and the full statement text if applicable to Datometry support team.

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 support team.

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 support team.

DTM9013

Query banding is unsupported.

Provide the error information and the full statement text if applicable to Datometry support team.

DTM9014

Unsupported arithmetic operation with non-constant interval expression.

Provide the error information and the full statement text if applicable to Datometry support team.

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 support team 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 support team.

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 support team.

DTM9018

Transaction related statements not supported by the backend system.

Provide the error information and the full statement text if applicable to Datometry support team.

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 support team.

DTM9020

Stored procedures not supported for the backend system.

Provide the error information and the full statement text if applicable to Datometry support team.

DTM9021

Invalid query syntax: '~p'.

Provide the error information and the full statement text if applicable to Datometry support team.

DTM9022

Invalid 'SQLCODE' reference.

Provide the error information and the full statement text if applicable to Datometry support team.

DTM9023

Unsupported DML operation on updatable views.

Provide the error information and the full statement text if applicable to Datometry support team.

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 support team otherwise rewrite the statement.

DTM9025

Unsupported query element: '~ts'.

Provide the error information and the full statement text if applicable to Datometry support team.

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 support team.

DTM9028

View ~ts is not updatable.

Provide the error information and the full statement text if applicable to Datometry support team.

DTM9029

View definition for view ~ts could not be parsed.

Provide the error information and the full statement text if applicable to Datometry support team.

DTM9030

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

Provide the error information and the full statement text if applicable to Datometry support team.

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 support team otherwise rewrite the statement.

DTM9037

Invalid data for USING modifier: '~ts'.

Provide the error information and the full statement text if applicable to Datometry support team.

DTM9038

View definition for view ~ts could not be retrieved.

Provide the error information and the full statement text if applicable to Datometry support team.

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 support team.

DTM9040

Invalid merge statement: '~ts'.

Provide the error information and the full statement text if applicable to Datometry support team.

DTM9041

Unsupported merge statement: '~ts'.

Provide the error information and the full statement text if applicable to Datometry support team.

DTM9042

Mload job error. Reason: '~p'.

Provide the error information and the full statement text if applicable to Datometry support team.

DTM9043

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

Provide the error information and the full statement text if applicable to Datometry support team.

DTM9044

Invalid select list. Reason :'~p'.

Provide the error information and the full statement text if applicable to Datometry support team.

DTM9045

Too many END TRANSACTION statements.

Provide the error information and the full statement text if applicable to Datometry support team.

DTM9047

Invalid upsert statement: '~ts'.

Provide the error information and the full statement text if applicable to Datometry support team.

DTM9048

The user cannot RENAME to a new database.

Provide the error information and the full statement text if applicable to Datometry support team.

DTM9049

Database unspecified for '~ts'.

Must speciify database name.

Provide the error information and the full statement text if applicable to Datometry support team.

DTM9050

Volatile table '~ts' not allowed in statement.

Provide the error information and the full statement text if applicable to Datometry support team.

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 support team.

DTM9056

Invalid unicode literal: '~p'.

Provide the error information and the full statement text if applicable to Datometry support team.

DTM9057

MLOAD retry error: maximum number of errors reached.

Provide the error information and the full statement text if applicable to Datometry support team.

DTM9058

Invalid block number in the FastExport Initiate request.

Provide the error information and the full statement text if applicable to Datometry support team.

DTM9059

Check constraint not satisfied for view ~ts.

Provide the error information and the full statement text if applicable to Datometry support team.

DTM9060

Invalid update statement: '~ts'.

Provide the error information and the full statement text if applicable to Datometry support team.

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 support team.

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 support team.

DTM9063

Unsupported CREATE DATABASE statement.

Provide the error information and the full statement text if applicable to Datometry support team.

DTM9064

Unsupported timezone specifier: ~ts.

Provide the error information and the full statement text if applicable to Datometry support team.

DTM9065

Unsupported GIVE statement.

Provide the error information and the full statement text if applicable to Datometry support team.

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 support team.

DTM9067

Unsupported QUEUE TABLE statement. from parser.

Provide the error information and the full statement text if applicable to Datometry support team.

DTM9068

Unsupported DROP DATABASE statement.

Provide the error information and the full statement text if applicable to Datometry support team.

DTM9069

Unsupported DELETE DATABASE statement.

Provide the error information and the full statement text if applicable to Datometry support team.

DTM9070

Unsupported MODIFY DATABASE statement.

Provide the error information and the full statement text if applicable to Datometry support team.

DTM9071

Unsupported NOT NULL in CTAS column.

Provide the error information and the full statement text if applicable to Datometry support team.

DTM9072

Unsupported PERIOD FOR statement.

Provide the error information and the full statement text if applicable to Datometry support team.

DTM9073

Unsupported HELP DATABASE statement.

Provide the error information and the full statement text if applicable to Datometry support team.

DTM9074

Unsupported Collect Statistics.

Provide the error information and the full statement text if applicable to Datometry support team.

DTM9075

Unsupported Translation of Labels in REPEAT.

Provide the error information and the full statement text if applicable to Datometry support team.

DTM9076

Unsupported Multi-character delimiters in STRTOK.

Provide the error information and the full statement text if applicable to Datometry support team.

DTM9077

Unsupported EXPLAIN statement.

Provide the error information and the full statement text if applicable to Datometry support team.

DTM9078

Unsupported feature 'Identity Column'.

Provide the error information and the full statement text if applicable to Datometry support team.

DTM9079

Unsupported Transaction Command.

Provide the error information and the full statement text if applicable to Datometry support team.

DTM9080

Unsupported Update Identity Column feature.

Provide the error information and the full statement text if applicable to Datometry support team.

DTM9081

Unsupported day_number_of_year statement.

Provide the error information and the full statement text if applicable to Datometry support team.

DTM9082

Unsupported Emulation of UDFs statement.

Provide the error information and the full statement text if applicable to Datometry support team.

DTM9083

Unsupported Non UTC Timezone statement.

Provide the error information and the full statement text if applicable to Datometry support team.

DTM9084

Unsupported Updatable view for non-Teradata endpoint.

Provide the error information and the full statement text if applicable to Datometry support team.

DTM9085

Unsupported format string for function TO_CHAR.

Provide the error information and the full statement text if applicable to Datometry support team.

DTM9086

Unsupported quantified subquery: ~ts.

Provide the error information and the full statement text if applicable to Datometry support team.

DTM9087

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

Provide the error information and the full statement text if applicable to Datometry support team.

DTM9088

Unsupported value for Occurrence: ~ts.

Provide the error information and the full statement text if applicable to Datometry support team.

DTM9089

Unsupported value for Match option: ~ts.

Provide the error information and the full statement text if applicable to Datometry support team.

DTM9090

Unsupported type for Identity Column.

Provide the error information and the full statement text if applicable to Datometry support team.

DTM9091

Unsupported CREATE GLOBAL TEMPORARY TABLE inside stored procedure.

Provide the error information and the full statement text if applicable to Datometry support team.

DTM9092

Unsupported Insert into Identity Column.

Provide the error information and the full statement text if applicable to Datometry support team.

DTM9093

Unsupported Set Session Collation.

Provide the error information and the full statement text if applicable to Datometry support team.

DTM9095

A table may not have more than one identity column.

Provide the error information and the full statement text if applicable to Datometry support team.

DTM9096

Invalid insert statement: '~ts'.

Provide the error information and the full statement text if applicable to Datometry support team.

DTM9098

Stored procedure exception ~ts.

Provide the error information and the full statement text if applicable to Datometry support team.

DTM9099

Unsupported string literal in pattern.

Provide the error information and the full statement text if applicable to Datometry support team.

DTM9100

MLoad MARK DUPLICATE INSERT (dup row).

Provide the error information and the full statement text if applicable to Datometry support team.

DTM9101

MLoad MARK DUPLICATE UPDATE.

Provide the error information and the full statement text if applicable to Datometry support team.

DTM9102

Distinct option is invalid with OVER phrase.

Provide the error information and the full statement text if applicable to Datometry support team.

 

Have more questions? Submit a request

1 Comments

  • 0
    Avatar
    Paul Boisvert

    This resource is my first stop when trying to triage an incident! Thank you Serge. 

Please sign in to leave a comment.