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 15.00.00.15] [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 ?
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).
Hi, thanks for response.
I use a Database in version 14.10.00.05 and JDBC driver in 14.10.00.34 or 15.00.00.15 (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 ?
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
CREATE TYPE SYSUDTLIB.AddAttribute_Type AS CHAR(24) CHARACTER SET LATIN ARRAY  DEFAULT NULL ;
So, my question now is ... Is it possible to query this field ? and if yes how ?
Thanks by advance
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.
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.
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.