17.10 - ExceptionValue Column - Advanced SQL Engine - Teradata Database

Teradata Vantageā„¢ - Data Dictionary

Advanced SQL Engine
Teradata Database
Release Number
Release Date
July 2021
Content Type
Programming Reference
Publication ID
English (United States)

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