Teradata Database Message 9991 - 17.10 - 9991 - 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
Response Row size is greater than the 1MB allowed maximum.
Explanation
The user request generated a response row size greater than 1MB of data which exceeds Teradata database limitations. This error is returned if the 1MB Perm and Response Rows feature is enabled and the Large Rows and APH flags in the Option parcel are set.
Generated By
Parser modules.
For Whom
End User.
Notes
None
Remedy
Change the SQL and/or reduce the data field sizes and/or number of fields being returned and resubmit the request. Limit the total bytes used by the projection list and the order by clause to approximately 1MB.