Teradata Database Message 9602 - 9602 - Analytics Database - Teradata Vantage

Message

Response buffer size is insufficient to hold one record 64KB.

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 64K and 2) user specifies a response buffer <= 64K but the actual data is > 64K.

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 1MB response buffer, they should not resend the request. (OR) For Host utilities that can handle 1MB response buffer, the client should grow the buffer and send a 'Continue' request with the required buffer size