| Number | Message | Summary | Recommendation |
|---|---|---|---|
| 1068 | Teradata socket read disconnect. | An error has 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 has been received for a host/LSN which cannot be found in the system. |
Check the LSN sent to the DBC to see that 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 could not be found. | If the object exists in the database, check to see if it has been 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 it has been deployed in the Unity Dictionary. |
| 4500 | Insufficient memory to complete the request. | Wait and resubmit request. | |
| 4501 | Invalid request parcel received. | Check that all TTU client tools are of 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 | ERRUNITYINVLOADREADONLY /* Loading not allowed through read only session. */ | ||
| 4521 | ERRUNITYINCRESTARTSTATE /* Unity table restart state not consistent with DB */ | ||
| 4522 | ERRUNITYNOMOREBULKSPACE /* Load cannot continue, no more space on Unity server */ | ||
| 4523 | ERRUNITYSYNCWRITEFAILURE /* Synchronous write returned inconsistent results */ | ||
| 4524 | ERRUNITYQRYBNDUNKNOWNSYS /* Specified system is not accessible for the session */ | ||
| 4525 | ERRUNITYQRYBNDNOTCREATE /* Queryband only applicable to create routed session */ | ||
| 4534 | Passive Routing feature not enabled | Ensure Unity is fully upgraded across all servers in the cluster, then enable Passive Routing with unityadmin command. | |
| 7423 | Object already locked and NOWAIT. Transaction Aborted. | Request object already locked and NOWAIT option specified. Transaction has been rolled back. | Resubmit the transaction. |
| 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 sizes of the parcel(s) are wrong or the kinds of the parcel(s) 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 sizes of the parcel(s) are wrong or the kinds of the parcel(s) 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 sizes of the parcel(s) are wrong or the kinds of the parcel(s) 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 | This error code must change as 9999 is not a valid error code. | |
| 9999 | Write to objects on systems unavailable in session | This error code must change as 9999 is not a valid error code. |