Teradata Database Message 7415 - 17.10 - 7415 - Advanced SQL Engine - Teradata Database

Teradata Vantageā„¢ - Database Messages

Product
Advanced SQL Engine
Teradata Database
Release Number
17.10
Release Date
July 2021
Content Type
Programming Reference
Publication ID
B035-1096-171K
Language
English (United States)
Message
Probable stale message (WorkID mismatch)
Explanation
A DBS message failed to match the expected work ID, indicating that it is probably a so-called "stale" message improperly left over from another DBS step. Since a stale message means that DBS processing protocols may have been compromised, this error causes a system restart.
Generated By
AMP software
For Whom
Site support representative.
Notes
This error is generated by the message sanity check routine AwtMatch, typically used to verify that the work ID in a received message matches the one in its known ancestor message. Since the system message header containing this work ID is normally copied into spawned, redistributed or response messages generated by a DBS step, the work ID in all these messages should match the one in the original step.
Remedy
1) Save the crashdump for offloading. 2) Have all traceback information ready. 3) Then call your Support Representative.