15.00 - 9600 Response buffer size is insufficient to hold records 32KB. - Teradata Database

Teradata Database Messages

Product
Teradata Database
Release Number
15.00
Language
English (United States)
Last Update
2018-09-24

9600 Response buffer size is insufficient to hold records 32KB.

Explanation:

This error occurs if FetchRowCount value is greater than number of rows that can be returned in a single response buffer to the host. This occurs when the below conditions are true. 1) fetchrowcount value is greater than number of rows that would fit in 32K and 2) user specifies a response buffer <= 32K but the actual data is > 32K.

Generated By:

Dispatcher.

For Whom:

End User.

Remedy:

Client application can reduce the fetchrowcount value and submit a CONTINUE request. (OR) For Host utilities that cannot handle 64KB Row Size, they should not resend the request. (OR) For Host utilities that can handle 64KB Row Size, enlarge the application's response buffer size to at least the size (but no more than 64,256) returned in the Info field of the ERROR parcel and submit a CONTINUE request containing a single RESP or KEEPRESP parcel that specifies the new response buffer size.