ExceptionValue Column - Advanced SQL Engine - Teradata Database

Data Dictionary

Product
Advanced SQL Engine
Teradata Database
Release Number
17.05
Published
January 2021
Language
English (United States)
Last Update
2021-01-22
dita:mapPath
prb1610499325399.ditamap
dita:ditavalPath
hoy1596145193032.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