[TeraJDBC] [Error 1178] [SQLState HY000]


[TeraJDBC] [Error 1178] [SQLState HY000]


I new with Teradata and I will try to connect TD DB with JDBC. When I try a specific request I get an SQLException with the message :

[Teradata JDBC Driver] [TeraJDBC] [Error 1178] [SQLState HY000] The Teradata Database did not provide the expected response - unable to read 8224 byte(s) from the database. Only 209814 byte(s) were received from the database and 202217 byte(s) have already been read.

When I try to execute the same request in bteq I have a result.

I don't know how to proceed for find more information about the problem ?


Tags (1)
Teradata Employee

Re: [TeraJDBC] [Error 1178] [SQLState HY000]

What version of the Teradata Database are you using?

There was a Teradata Database bug that caused a failure similar to the one you are reporting -- DBS DR 166595 (JDBC Exception is thrown when executing the HELP TYPE "MBR" METHOD query).

Re: [TeraJDBC] [Error 1178] [SQLState HY000]

Hi, thanks for response.

I use a Database in version and JDBC driver in or (I try the two version with the same result).

This problem occur when I try to query on a specific table. I have make some tests and for the same query :

select * from CDR_DATA_KPI where TimeStamp_TS between ? and ? 

For all the table I have a good result but for one speficic table I have the previous problem ? I don't know how to find more information for debugging query or find a workraround ?

Re: [TeraJDBC] [Error 1178] [SQLState HY000]

Ok so I have found the origin of my problem.

In my table I have a field of special type :


with ADDATTRIBUTE_TYPE like that


So, my question now is ... Is it possible to query this field ? and if yes how ?

Thanks by advance


Teradata Employee

Re: [TeraJDBC] [Error 1178] [SQLState HY000]

Are you a customer? We need to gather your DDL, sample data, and your Java code to reproduce the problem. It's easiest to do all that when you open a customer service incident.

Re: [TeraJDBC] [Error 1178] [SQLState HY000]

Currently I wait for a customer account from my client.

So no, I'm not a customer but I will be soon.

Thanks for your help.

Re: [TeraJDBC] [Error 1178] [SQLState HY000]

Some news, after more analyse, the problem occur only if the array column (AddAttribute) is place on the middle of the select, when the column is the last of the select statement the query is correctly executed.