Teradata Database Message 9921 - 17.10 - 9921 - 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
Concrete step size exceeds the limit. The pack factor needs to be reduced.
Explanation
The user has defined too many deferred lob columns in one Using row and/or specified a high pack factor, which causes the concrete step size exceeds the limit of 4MB. The default of pack factor for deferred lob is 1024.
Generated By
gnc modules
For Whom
End User
Notes
None
Remedy
Reduce the number of deferred LOB columns being used in USING row and/or reduce the pack factor to 1024. Resubmit the request.