Teradata Database Message 3177 - 17.10 - 3177 - 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 buffer size is insufficient to hold more than 64KB of data.
Explanation
This error occurs if the minimum number of bytes that can be returned to the host is larger than what the host application has specified in a RESP, EXTRESP, KEEPRESP or EXTKEEPRESP parcel and more than 64KB of data needs to be returned to that response buffer.
Generated By
Dispatcher.
For Whom
End User.
Notes
An entire response data must be able to fit in the number of bytes specified in a RESP, EXTRESP, KEEPRESP or EXTKEEPRESP parcel. The ERROR parcel in which this error is returned does not indicate the minimum buffer size required in the 2 byte integer Info field. That field contains zero. Instead, the ERRORINFORMATION parcel which follows indicates the minimum buffer size required in the 4 byte integer information field.
Remedy
Client software that cannot handle a Response buffer up to 16MB, should not resend the request. Client software that can handle 16MB response buffer, the client should grow the buffer and send a 'Continue' request with the required buffer size. It should send the new size in EXTRESP (flavor 153) or EXTKEEPRESP (flavor 154) in the continue message. For this error code, the Infomation field in the ERRORINFORMATION parcel has the number of bytes required for the buffer size. The client should read this number, and allocate the new buffer size. Please refer to the Call-Level Interface reference manual for instructions on how to change the response buffer size.