[TeraJDBC 15.00.00.15] [Error 1178] [SQLState HY000]

Connectivity

[TeraJDBC 15.00.00.15] [Error 1178] [SQLState HY000]

Hi,

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 ?

Thanks

Tags (1)
6 REPLIES
Teradata Employee

Re: [TeraJDBC 15.00.00.15] [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 15.00.00.15] [Error 1178] [SQLState HY000]

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 ?

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

Ok so I have found the origin of my problem.

In my table I have a field of special type :

...
AddAttribute SYSUDTLIB.ADDATTRIBUTE_TYPE,
...

with ADDATTRIBUTE_TYPE like that

CREATE TYPE SYSUDTLIB.AddAttribute_Type  AS CHAR(24) CHARACTER SET LATIN ARRAY [10] DEFAULT NULL ;

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

Thanks by advance

Frédéric

Teradata Employee

Re: [TeraJDBC 15.00.00.15] [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 15.00.00.15] [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 15.00.00.15] [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.