Teradata Database Message 9600 - 9600 - Analytics Database - Teradata Vantage

Message

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.

Notes

None

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.