Error Codes - Teradata Unity

Teradata Unity User Guide

Product
Teradata Unity
Release Number
16.10
Published
January 2018
Language
English (United States)
Last Update
2018-03-29
dita:mapPath
anz1496162519675.ditamap
dita:ditavalPath
ft:empty
dita:id
B035-2520
lifecycle
previous
Product Category
Analytical Ecosystem
Number Message Summary Recommendation
1068 Teradata socket read disconnect. An error occurred while receiving data. Connection to the underlying Teradata instance was lost before all expected data was received. Resubmit the transaction.
2631 Transaction ABORTed due to Deadlock.   Resubmit the transaction.
3029 Associated LSN was not found. Invalid Logical Session Number.

An LSN associate connect request was received for a host/LSN which cannot be found in the system.

Check the LSN sent to the DBC to see if it already exists.
3615 Statement not permitted during Fast Load. Only BT, CHECKPOINT LOADING, END LOADING, ET, and INSERT are permitted during Fast Load. Correct the statement and resubmit the request.
3807 Object does not exist. An object associated with the request was not found. If the object exists in the database, check to see if the object was deployed in the Unity Dictionary.
3807 Object '%s' does not exist. Object name provided (%s) but no period at end of message. If the object exists in the database, check to see if the object was deployed in the Unity Dictionary.
4500 Insufficient memory to complete the request.   Wait and resubmit request.
4501 Invalid request parcel received.   Check all TTU client tools are the correct version.
4502 Internal error: System error occurred. Contact your administrator.   Check Unity error logs for more details.
4503 Internal error: Unexpected response or invalid state encountered. Contact your administrator. An unsupported message was received from the database. Check Unity error logs for more details.
4504 Recovery table is not accessible. During recovery a table or system became inaccessible.  
4505 Connection does not exist.    
4506 Connection name in use or invalid.    
4507 Database system is unavailable.    
4508 The request was canceled by the dispatcher due to a dispatcher reset command.    
4509 Failed to define execution context.    
4510 No systems available.    
4511 Systems to be queried incompatible with current transaction.    
4512 Query not allowed from read-only session.    
4513 An error has occurred while receiving data. Connection to the underlying Teradata instance was lost before all expected data was received.    
4514 Query is disallowed because it writes to a table containing an identity column.    
4514 Write disallowed because it contains a TOP clause without an ORDER BY clause and is therefore inherently non-deterministic.    
4514 Write disallowed because it contains a SAMPLE clause and is therefore inherently non-deterministic.    
4515 Client-side file access and deferred LOB access is not currently supported by Unity.    
4516 The request could not be processed because the session is interrupted.    
4517 Logon rejected. The default database for this user is not the same across all systems managed by Unity.    
4518 Load feature not enabled.    
4519 An unspecified error occurred while Unity was receiving elicit packets.    
4520 Loading not allowed through read only session.    
4521 Unity table restart state not consistent with DB.    
4522 Load cannot continue, no more space on Unity server.    
4523 Synchronous write returned inconsistent results.    
4524 Specified system is not accessible for the session.    
4525 Queryband only applicable to create routed session.    
4526 Export feature not enabled.    
4527 Unity heartbeat failed for all managed databases. Check active sequencer.    
4528 Unity failed to communicate with an endpoint to begin load operation.    
4529 Object(s) required for this query are not available.    
4530 Query rejected because associated routing rule prohibits writing to managed objects.    
4531 The request limit for a single transaction has been reached.    
4532 User aborted elicit load.    
4533 Timeout waiting for preceding message. Please resubmit the request.    
4534 Passive Routing feature not enabled.   Make sure Unity is fully upgraded across all servers in the cluster, then enable Passive Routing with the unityadmin command.
4535 The transaction log limit for this session has been reached.    
4536 Number of checkpoints exceeded checkpoints limit setting.    
4537 SQL request is not supported by Unity.    
4538 Invalid request causing lock queue out of sequence. This is a self-correcting error. The affected object should be interrupted and get autorecovered.  
4539 Failed to modify object(s) in dictionary.    
4540 Query disallowed because it writes to a mix of objects that are managed and unmanaged by Unity.    
4541 Write to Unity managed objects disallowed from unmanaged stored procedure. Please issue an object scan to update the Unity dictionary.    
7423 Object already locked and NOWAIT. Transaction Aborted. Request object already locked and NOWAIT option specified. Transaction are rolled back. Resubmit the transaction.
8017 The UserId, Password, or Account is invalid.    
8018 The session id is illegal.    
8019 Server instance shutdown or failure. The parcel stream following the message header on the assign, reassign, authorization, single sign-on, connect, or reconnect request is not valid either because the parcel(s) sizes or parcel(s) types are wrong. Repeat the assign sequence with a good parcel stream.
8019 Internal server error (invalid sequencer response). The parcel stream following the message header on the assign, reassign, authorization, single sign-on, connect, or reconnect request is not valid either because the parcel(s) sizes or the parcel(s) types are wrong. Repeat the assign sequence with a good parcel stream.
8019 Invalid query text. A PCLREQ packet was received with a negative query text length. Repeat the assign sequence with a good parcel stream.
8019 Failed to prepare dictionary for dynamic DDL. The parcel stream following the message header on the assign, reassign, authorization, single sign-on, connect, or reconnect request is not valid either because the parcel(s) sizes or the parcel(s) types are wrong. Repeat the assign sequence with a good parcel stream.
8019 Disallowed connection type. The connection was rejected because it came from an unsupported client tool (for example, FastLoad Stand Alone). Repeat the assign sequence with a good parcel stream.
8026 The LAN message RequestNo field is invalid. This error is generated when a start request contains a request number lower than that of any previous start request or when a continue request contains a request number higher than any previous start request. Correct the request number and retry the continue or start request.
8051 Failed to run statement due to dictionary modification failure.    
8051 Failed to drop object(s) due to dictionary modification failure.    
8051 Failed to modify object(s) in dictionary.    
8051 Internal memory failure.    
8917 Session targeted Teradata system(s) are unavailable. Same error as 4513, but used for read-override (Query Director Like) mode.  
9999 Write to objects on non-readable systems.    
9999 Write to objects on systems unavailable in session.