ExceptionValue Column - Advanced SQL Engine - Teradata Database

Data Dictionary

Product
Advanced SQL Engine
Teradata Database
Release Number
17.00
Published
June 2020
Language
English (United States)
Last Update
2020-10-15
dita:mapPath
yoz1556235523563.ditamap
dita:ditavalPath
lze1555437562152.ditaval
dita:id
B035-1092
lifecycle
previous
Product Category
Teradata Vantageā„¢

These values show up as an integer. A conversion to hex extracts the bit values. For example, a value of 1024 converted to hex is 400.

Value Description
0x00000001 Exception time limit exceeded
0x00000002 CPU time (AMP and PE) limit exceeded
0x00000004 Blocked time limit exceeded
0x00000008 Disk to CPU ratio exceeded
0x00000010 AMP CPU skew limit exceeded
0x00000020 AMP I/O count limit exceeded
0x00000040 AMP I/O skew limit exceeded
0x00000080 Max row count (for a step) exceeded
0x00000100 Max row count (for a query) exceeded
0x00000200 Spool space limit exceeded
0x00000400 Number of AMPS used in query exceeded
0x00000800 Disk CPU ratio value exceeded
0x00001000 I/O space value exceeded