29 July 2018        Add to Favorites   Report

Teradata Response Row size or Constant Row size overflow error

Problem: 

When we query Teradata for a specific table in bteq , we get the following error;

 *** Failure 9804 Response Row size or Constant Row size overflow.
                Statement# 1, Info =0 
 *** Total elapsed time was 1 second.


Solution:

The following should work. do this before .logon i.e. before establishing the session with TD.

.set session charset 'ascii';

For ODBC and JDBC clients the connection parameter called CHARSET should be used to resolve this issue



Read great educational content like this and a lot more !

Members get free exclusive access to content, new courses, and discounts. Signup for a free account to write a post / comment / upvote posts. Creating an account takes less than 5 seconds and you can start earning badges & points too

Copied