Teradata Database Message 5597 - 5597 - Analytics Database - Teradata Vantage

Teradata® VantageCloud Lake - Analytics Database Messages

Edition
Lake
Product
Analytics Database
Teradata Vantage
Published
October 2022
Language
English (United States)
Last Update
2024-02-26
dita:mapPath
tzr1629746512312.ditamap
dita:ditavalPath
ft:empty
dita:id
vza1585613049811
lifecycle
latest
Product Category
Teradata® Vantage™
Message
Invalid definition for a Global Temporary Trace Table "%VSTR".
Explanation
The Global Temporary Trace Table has the following restrictions. If the table definition does not comply with these restrictions, this error is generated. 1) The first two columns of Global Temporary Trace Table are fixed. The first column must be specified as two bytes, whereas the second column must be specified as an integer type. 2) The table is always NO FALLBACK. 3) Column entries cannot have any constraints or default values. 4) There cannot be any INDEX declarations including PRIMARY INDEX. 5) It must be a MULTISET TABLE.
Generated By
SYN/RES modules.
For Whom
End User.
Notes
None
Remedy
Correct the statement and resubmit the request.