Send feedback on this topic.
Teradata.Client.Provider
Error Messages
.NET Data Provider for Teradata > Developer's Guide > Product Support, Troubleshooting and Error Messages > Error Messages

The following tables describe the error numbers that may be returned from a TdException. A TdException is composed of a one or more instances of TdError. The error numbers are returned in TdError.Number.

TdConnection and TdCommand Related Errors

Message Number Message Text
100001 Cannot close an Active Request. Please Abort the Request.
100002 Cannot create connection within the time specified.
100004 Invalid Connection Pool operation.
100005 Invalid connection string.
100006 {0} is not a valid {1}.
100007 Provider does not support conversion from {0:G} to {1}.
100008 Invalid Database name.
100009 The isolation level is not supported by this version of Teradata Database.
100010 There is an existing open transaction; Teradata does not support nested transactions.
100011 Invalid Parcel buffer length.
100012 Invalid Parcel Flavor.
100013 Invalid Parcel read position.
100014 {0} is not a valid decimal precision.
100015 Total size of all parcels is greater than the max message size.
100016 Invalid Teradata response message sequence.
100017 {0} is not a valid Session Character Set.
100018 {0} is not a valid Session Mode.
100019 {0} is not a valid SQL statement.
100020 Invalid VarChar length.
100021 Session to Teradata is {0:G}.
100022 Semaphore failed to release.
100023 {0} is an invalid value for the Max Decimal Precision.
100024 The precision of the Decimal retrieved is currently not supported.
100026 TdTransaction object is disposed and the transaction has already been committed or rolled back.
100027 Provider does not support Teradata release {0}.
100028 TdCommand is already in active (Prepare / Execute) state.
100029 The connection does not exist.
100030 Cannot transition from {0} state to {1} state.
100031 Provider does not support the specified CommandType.
100032 Provider does not support DbType {0}.
100033 Can not find a TdParameter with the specified name.
100034 Index is outside the bounds of the TdParameterCollection.
100035 The {0} parameter is already a member of this or another TdParameterCollection.
100036 {0} parameter does not exist in the TdParameterCollection.
100037 CommandText is invalid or empty.
100038 Command did not complete within the time specified (timeout).
100039 CommandBehavior was set to SchemaOnly.
100040 Invalid column name.
100041 No data exists for the row or column.
100042 The field could not be converted to {0}.
100043 Cannot convert DBNull.
100044 TdDataReader is closed.
100045 Column Ordinal is invalid. It is less than zero or greater than or equal to FieldCount.
100046 Invalid Transaction Property.
100047 Unsupported Teradata data type.
100048 TdCommand is associated with an active DataReader. Close DataReader first and try again.
100049 {0} is not a valid Time precision.
100050 Cannot convert to {0}.
100051 Invalid parameter Size. The value must be greater than or equal to 0.
100052 {0} is an invalid max length.
100053 {0} is not a valid Time scale.
100054 {0} is not a valid Decimal precision.
100055 {0} is not a valid Decimal scale.
100056 Total size of parameters is greater than the max Data parcel size.
100057 TdStream does not support seeking.
100058 TdStream does not support Flush method.
100059 TdStream does not support writing.
100060 The end of BLOB is reached.
100061 Can not change session isolation level in the middle of a transaction.
100062 Teradata session is busy processing another request.
100063 The asynchronous execution has already completed.
100064 The IAsyncResult parameter cannot be null.
100065 Mismatched end method call for asnycResult. Expected call to {0} but {1} was called instead.
100066 {0} is not a valid {1} precision.
100067 Generated Data Retrieval is not supported for Teradata version {0}.
100068 The input parameter array must of be an Array of type TdError (TdError[]).
100069 Internal Error: Invalid response parcel received. Expected {0}, Received {1}.
100070 The NUMBER data type is not currently supported.
100071 Invalid Statement Status Type in Enhanced Statement Status parcel received.
100072 The object used to read the external file must either be a Stream or TextReader.
100073 An event was not registered with the provider used to specify the external source file.
100074 Unable to read the external source file.
100075 Only one delegate can be registered with the {0} event.
100076 Invalid internal operation. The internal callback for the elicit file was not set.
100077 An unexpected exception occurred.
101001 Default database was successfully changed to {0}.
101002 TdConnection is already in the open state.
101003 TdConnection is not in the closed state.
101004 TdConnection is not open.
101005 Expired password - Cannot change password.
101006 Expired password - Successfully changed.
101007 Expired password - Modify user is the only command supported.
101008 An Open() method is already in progress.
101009 TdConnection Closing the session and cancelling recovery efforts.
101101 Connection string value {0} must be smaller than the maximum value {1}.
101102 Internal Error: App Config Error. DataSource has not been defined in structure.
101103 The name of the schema that is specified in the app config is not valid.
101105 The values for the dataSource, database, and name attributes must be specified for all storeSchemas and schema tags in the application configuration file.
101151 Too many restrictions supplied.
101152 Restriction {0} not supported.
101153 No default restriction found for {0} collection.
101154 No command text found in population string.
101155 Schema {0} not supported.
101156 Key access to internal view of {0} DataTable is invalid.
101157 MetaData DataTable {0} is invalid.
101158 Data type {0} not supported.
101159 HELP COLUMN command returned a NULL column name.
101251 .NET Data Provider for Teradata does not support '{0}' keyword.
111001 The TdAsyncResult object provided does not match this TdCommand.
111002 An overflow occurred while calculating the activity count, actual value is [{0}].
112001 Source code for UDF or External Stored Procedure must reside on the Teradata server.
112002 Request has been canceled by user.

TdInstaller Related Errors

Message Number Message Text
105000 Cannot find System.Data section in the machine.config file.
105001 Cannot find DbProviderFactories in the machine.config file.
105002 TdInstaller.Commit failed. See inner exception for additional information.

TdParameter Related Errors

Message Number Message Text
110070 Invalid cast to Out Parameter. {0} Parameter ordinal: {1}
110071 Parameter arrays are not supported by version of Teradata being accessed.
110072 The parameter array is invalid.
110073 TimeSpan overflows Teradata's Time data type. Days cannot be specified in TimeSpan.
110074 Length of Var Byte array is invalid. Max length is {0}.
110075 {0} is an Invalid Parameter Row.
110076 A null value has been specified as a parameter to a CLOB or BLOB.
110077 The position of the Offset will extend beyond the length of the LOB.
110078 Deferred parameters expected by Teradata but none are available to be processed.
110079 Lobs are unsupported. Lobs are only supported in Teradata V2R5.1 or greater.
110080 Can not read parameter data from a closed Stream, TextReader or File.
110081 Expected Lobs to be returned from Teradata. None returned. Invalid Operation.
110082 Provider does not support {0}.
110083 A null has been specified as the Value for a parameter.
110084 The Size property has an invalid size of 0.
110085 A Value of a parameter in the collection has a precision or scale that is too large.
110086 If TdParameter.IsNullable is set to false, TdParameter.Value cannot be set to DBNull or a Provider Specific Type Null value.
110087 The TdParameter.SecondaryTdType specified is invalid.
113000 Provider does not suppport {0}.

TdDataReader Related Errors

Message Number Message Text
114001 Preceding columns are no longer accessible. Application does not have access to all preceding columns in Sequential access mode. The columns have to be read in order.
114002 .NET Data Provider for Teradata does not support WITH CLAUSE for specifying summary lines / grouping conditions in a SELECT statement.
114003 An overflow occurred while calculating the number of records returned, actual value is [{0}].
114004 An overflow occurred while calculating the number of records affected, actual value is [{0}].
114005 An asynchronous DataReader method is already in progress. Only one method may execute at one time within each data reader.
114006 End of LOB data occurred before expected number bytes/characters were read.
114200 Invalid Parcel Sequence. Teradata did no return ErrorInfo parcel.
114205 Internal Error: Unexpected parcel received during processing of parcels returned while in statement independence mode -- {0}.

Connectivity (Socket) Related Errors

Message Number Message Text
115000 Unable to connect transport. DataSource={0} IpAddress[]=({1}) Port={2}.
115001 Transport error sending data.
115002 Transport error receiving data.
115003 The receive operation timed out.
115004 Unable to begin an asynchronous receive operation.
115005 Transport error performing asynchronous receive.
115006 Could not resolve DataSource={0} to an IpAddress.
115007 The Teradata Database does not support the {0} session character set.
115008 An invalid response message was received.
115009 Message truncation error, not all data was received.
115010 A message has arrived out of sequence.
115011 Error queuing the BeginReceive operation.
115012 Operation aborted due to unrecoverable session errors.
115013 Invalid session state for requested operation, state={0}.
115014 The session is not open, send or receive operation is not allowed.
115015 AuthenticationMechanism={0} not found on the client workstation.
115016 AuthenticationMechanism={0} is not supported by the server.
115017 AuthenticationMechanism={0} requires a local authentication mechanism={1}, but that mechansism could not be found on the client workstation.
115018 Authentication mechanism type={0} could not be mapped to a supported mechanism name.
115019 Error selecting the default server authentication mechanism.
115020 The remote server does not support data encryption.
115021 AuthenticationMechanism={0} is not enabled on the client workstation.
115022 Exception occurred in TeraGSS layer. See inner exception for details.
115023 Error decrypting data, no security context is established.
115024 Transport error initializing socket.
115025 Could not resolve Data Source={0} to an available node after {1} attempts.
115026 authcid@@password is not valid LDAP authentication credentials for this version of the Teradata Database. Use AuthenticationString and do not supply UserId or Password.
115027 Session initialization error: unable to execute HELP SESSION.
115028 Session initialization error: invalid export widths.
115029 A Single Sign On authentication mechanism was not found on the client.
115030 A Single Sign On authentication mechanism was not found on the server.
115031 .NET Data Provider for Teradata does not support / connect to the Teradata Database 5.1 or earlier.
115032 ID field in ErrorInfo parcel must be set to 1 or 4.
115033 The Teradata Database does not support the Unicode session character set {0}.
115034 Messages arrived out of order.
115035 The connection string attribute requesting re-drive is not supported by the database.
115036 The connection string attribute requesting recoverable network protocol is not supported by the database.
115037 Transport error performing asynchronous send.
115038 Error queuing the BeginSend operation.
115039 Unable to begin an asynchronous send operation.
115042 Retry interval constraint {0} exceeded ({1}).
115043 Request ready to be resubmitted during redrive.
115044 Request response ready for retrieval during redrive.
115045 Request cannot be redriven.
115046 Reconnection timeout has expired.
115047 The recovery attempt failed.
115048 Session cannot be reconnected. Refer to the InnerException for more information.
115049 The socket connection was aborted or reset.
115050 ElicitData request response ready for retrieval during redrive.
115051 Request ready to be resubmitted during redrive with a new request number.
115052 Internal sequence error in Continue message handling.

TdQueryBand Related Errors

Message Number Message Text
116000 The connected Teradata Database does not support Query Bands. Query Bands are only supported in 12.0 or higher.
116001 The value {0} for the key {1} is invalid.
116002 The Query Band key {0} is undefined.
116003 The Query Band key {0} already exists.
116004 The connected Teradata Database does not support Trusted Session. Trusted Session is only supported in 13.0 or higher.
116005 An empty string has been specified for {0}.

TdDataAdapter and TdCommandBuilder Related Errors

Message Number Message Text
121000 Can not add a command object without connection to batch.
121001 Can not add a command object with different connections to batch.
121002 Concurrency violation.
121003 Batch size is too big and causing unrecoverable database over limit error. Try batch size smaller than {0}.
121004 Rolled Back.
121005 Multiple rows were updated.
121006 Batch size cannot be less than 0.
121007 The TdParameter.Value property is set to DBNull but the TdParameter.IsNullable property is set to false.
122000 The command parameter to TdCommandBuilder.DeriveParameter is not of StoredProcedure type.
122001 The command text of command parameter to TdCommandBuilder.DeriveParameter is null or empty.
122002 The connection of command parameter to TdCommandBuilder.DeriveParameter is null.
122003 The connection of command parameter to TdCommandBuilder.DeriveParameter is not open.
122007 TdCommandBuilder only supports a single Select statement that returns data from a single table with no calculated columns.
122009 TdCommandBuilder only supports double quote or empty string for quote prefix and suffix.
122010 TdCommandBuilder does not support user defined types.
122011 TdCommandBuilder does not support {0} Teradata data type.

Provider Specific Data Types Related Errors

Message Number Message Text
123000 The value of the numeric type is Null
123001 The format specifier is invalid.
123002 Illegal truncation of numeric type.
123004 The numeric type could not be converted to {0}.
123006 Object must be of type {0}
123008 An overflow occurred performing {0} operation.
123009 The specified scale {0} would cause an overflow of the numeric type.
123010 Either the Precision or Scale is out of range.
123011 The specified string could not be converted to the specified numeric type.
123012 The specified precision ({0}) must be greater than the scale ({1}).
123013 Unable to convert data to a {0}
123014 The {0} type is not supported by the connected Teradata Database.
123015 The number of components are invalid for {0}. The maximum number of components that can be specified is {1}.
123100 The specified Date or Time components contain a value that cannot be represented by a {0}.
123101 Adding the specified value to the date results in a value that cannot be represented by a {0}.
123102 One of the arguments to the operation or method is null.
123103 Specified string was not recognized as a valid {0}.
123104 A null has been specified for one of the parameters.
123105 The value of type {0} is null.
123106 An Invalid UTC Offset has been specified for the {0}.
123107 Only whole minutes or hours can be specified in the UTC offset.
123108 An overflow occurred when performing the arithmetic operation between the {0} and the TimeSpan.
123109 The conversion from {0} to {1} is not supported.
123110 The scale of the specified number exceeds the maximum scale for a Date And Time type.
123200 The Begin cannot be greater than or equal to the End bound. The specified parameters cannot be represented as a Period.
123201 The type {0} could not be converted to {1}.
123203 This version of the Teradata Database does not support Period types. Teradata 13.0 or greater supports Period types.
123204 Period is null.
123205 Either the beginning or ending bound is Null.
123206 Scale of period type is invalid. It is not between the range of 0 and 6.
123207 The {0} scale is greater than the specified scale. The scale cannot be truncated.
123208 Unable to convert the value to a {0}.
123209 Object must be of type {0}.
124000 The resultant {0} operation results in a value less than the MinValue or greater than the MaxValue.
124001 The specified string could not be converted to a {0}.
124002 The {0} is outside the minimum or maximum range of values.
124003 The {0} parameter is null or empty.
124004 The specified precision {0} is less than the minimum required precision {1} to contain this interval.
124005 The conversion cannot be performed.
124006 The resultant {0} operation results in a value or a {0} field that exceeds the minimum or maximum values.
124007 The resultant {0} operation cannot be completed due to a divide by zero error.
124008 The specified interval fields contain a value that cannot be used to create this interval.
124009 The resultant interval operation results in a value or a field that exceeds the minimum or maximum values.
124010 The {0} operation does not support Null values.
124011 The interval cannot be constructed with a precision of {0}.
124012 The calculated precision of {0} is greater than the maximum precision.
124200 The value of type {0} is null.
126000 An Unhandled Xml object has been encountered: {0}.
126001 The {0} has either been closed or is in an error state.
126002 The parameter type is not supported by {0}.
126003 The provider is unable to handle the specified Xml Node Type: {0}.
126004 A error/failure occurred while reading from the source that contains the data to be sent to the Teradata Database.
126005 Internal Error: Deferred parameter was not found in the Deferred Parameter List.

.NET EntityProvider Related Errors

Message Number Message Text
200000 The Command Tree received from the Entity Framework is not supported.
200001 The primitive type {0} is not supported by the Entity Provider for Teradata.
200002 The specified expression is not supported: {0}.
200003 The EDM Type {0} is not supported.
200004 Incorrect metadata was associated with DbExpression.
200005 An error occurred when writing out SQL statement.
200006 An unexpected problem occurred when processing {0}.
200007 The function specified in the GROUP BY clause is not supported. Received {0} object.
200008 The canonical function {0} is not supported.
200010 Unable to update the EntitySet '{0}' because a DefiningQuery is defined and no <{1}> element exists in the <ModificationFunctionMapping> element to support the operation.
200011 Argument is not of type '{0}'.
200012 The following argument is null or empty: {0}.
200013 Store version '{0}' is not supported via this provider.
200014 The Entity Provider does not support the information type {0}.
200015 The Store Type {0} is not supported.
200016 The statement cannot be processed by the Entity Provider. An invalid step was created by the Entity Framework: {0}.
200017 A MaxLength was not specified for the {0} type that is mapped to String.
200018 The generated limit expression containing a TOP function is not supported by Teradata.
200019 The generated SQL contains a scalar sub-query in a select list supported by Teradata version '{0}' or greater.
200020 A CASE statement in the generated SQL contains a sub-query that returns a scalar value. This is supported by Teradata version '{0}' or greater.
200021 Operands in a CASE statement are incompatible.