Teradata SQL Error and Failure Codes from Error 2949 To 2957

2949 Invalid index definition.
Explanation: The fields provided are not a unique secondary index for the table defined in the “EXPRSI” express request.
Generated By: ExpRSI.
For Whom: Site support representative.
Notes: This is an internal error. The calling routine has specified an invalid index.
Remedy: Contact your Support Representative.

2950 Rebuilt table is dropped.
Explanation: This is an internal status error created when applying rowrange lock to rebuild table. The table is dropped
by on-line transaction.
Generated By: RbdGetD
For Whom: End User
Remedy: The table will not be rebuilt.

2951 Rebuilt table has a DDL change.
Explanation: This is an internal status error created when applying rowrange lock to rebuild table. The table is DDL
changed by on-line transaction.
Generated By: RbdGetD
For Whom: End User
Remedy: The table will be rebuilt again.

2952 Rebuilt table is used by other utilities.
Explanation: This is an internal status error created when applying rowrange lock to rebuild table. The table is used by
other utilities such as FastLoad, Multi-Load, Restore, Recovery, etc.
Generated By: RbdGetD
For Whom: End User
Remedy: Rebuild will handle the table according to who is using it.

2953 The transaction has been aborted.
Explanation: The transaction has been aborted due to error condition or by an user. This error is internal information
only. At this point, it will not be passed back to the end user.
Generated By: AMP Software (AwtAwtIA).
For Whom: AMP Worker Task.

2954 Invalid record type on transient journal.
Explanation: An invalid journal kind was specified or found on a journal. The AMP which detects the error will remain
offline.
Generated By: AwtRcv.
For Whom: Site support representative.
Notes: This is an internal error. Transaction recovery detected an inconsistency in the transient journal, and recovery will
continue to abort. To restart the system, shut down the offending processor and rebuild its disk off-line.
Remedy: Contact your Support Representative.

2955 Invalid before image on transient journal.
Explanation: The row that a before journal has written does not exist in the database. The AMP which detects the error
will remain offline.
Generated By: AwtRcv.
For Whom: Site support representative.
Notes: This is an internal error. Transaction recovery detected an inconsistency on the transient journal. Rebuild the
offending processor’s disk.
Remedy: Contact your Support Representative.

2956 Secondary index does not contain data rowid.
Explanation: The rowid for a data row could not be found in the corresponding secondary index row.
Generated By: SutSI.
For Whom: Site support representative.
Notes: This is an internal error. The secondary index rows are inconsistent. Table rebuild can be used to rebuild the index
subtables.
Remedy: Contact your Support Representative.

2957 Invalid abort step sent by dispatcher.
Explanation: An invalid AAB step was sent to an AMP. Either the specified transaction id or the statement number was
not found.
Generated By: StpAAB.
For Whom: Site support representative.
Notes: This is an internal error. The dispatcher has sent an invalid abort request to the AMPs. The condition should not
reoccur on startup.
Remedy: Contact your Support Representative.

Above are list of Teradata Errors or Failure Codes from Error 2949 To 2957 received while performing certain operation against Teradata Database or related products.

What are Teradata Database Errors?

In general, each Teradata error message contains the following information:
• The message number.
• The message text. This text is usually returned with the message number. Some messages employ word substitution, where the word substituted represents the system-replacement of a term more specific to the occurrence.
• An explanation of how the error may have occurred.
• Generated-by text that indicates the software module which initiated the message. This field serves a diagnostic purpose for support and development personnel.
• A remedy which suggests how to resolve the condition.

Hope this was helpful.

Thanks,
SQLServerF1 Team
Information about Teradata SQL Error and Failure Codes and Error Messages on Windows, Linux Operating Systems.

 

Leave a Reply

Your email address will not be published. Required fields are marked *