topic Re: tteradata input Truncation Error in Talend Studio

tteradata input Truncation Error

kartikdharia — Sat, 16 Nov 2024 08:09:53 GMT

While reading data from tteradatainput ,I am getting the below error.

If i read 100 records then it works fine, it fails for around 90k records. Any help?

Starting job TestTrunc at 16:16 01/06/2018.

[statistics] connecting to socket on port 3804
[statistics] connected
2018-06-01 16:16:20|I6cAJs|I6cAJs|I6cAJs|11928|MSA|TestTrunc|_iiip8GXvEei_spld3uFkiw|0.1|Default||begin||
2018-06-01.16:16:24.189 TERAJDBC4 ERROR [main] com.teradata.jdbc.jdk6.JDK6_SQL_Connection@3532ec19 Read message 1: Bad response message header with invalid message length of 6362648 bytes2018-06-01.16:16:24.357 TERAJDBC4 ERROR [main] com.teradata.jdbc.jdk6.JDK6_SQL_Connection@3532ec19 Read message 1 failed; closing socket due to: java.io.IOException: Bad response message header with invalid message length of 6362648 bytes2018-06-01.16:16:24.414 TERAJDBC4 ERROR [main] com.teradata.jdbc.jdk6.JDK6_SQL_Connection@3532ec19 Pac

To see the whole post, download it here

Re: tteradata input Truncation Error

Anonymous — Fri, 15 Jun 2018 09:45:51 GMT

Hello,

What's your Teradata version? Could you please indicate on which talend build version you got this issue?

Best regards

Sabrina

Re: tteradata input Truncation Error

kartikdharia — Thu, 09 Aug 2018 16:55:44 GMT

You mean the Teradata Driver ? It is 15.10 ([Teradata Database] [TeraJDBC 15.10.00.33])

I am not sure on how to check the enterprise Teradata version.

I am using Talend Real time big data platform 6.4.1

Re: tteradata input Truncation Error

VK2 — Wed, 11 Mar 2020 17:30:11 GMT

Hi,

Can you tell me the resolution for this issue, if it is fixed.

we are now migrating the Teradata 15 version to 16 version, unfortunately facing similar issue in Talend 6.4.1

I have performed below once to fix the issue, but issue is re-occurring again,

1. Removed the jars of older version in talend studio/workplace from the lib/java folders and placed new Teradata 16 version --> didn't worked.

2. Used tLibraryLoad component in Talend studio 6.4.1 to load the latest version --> Didn't worked.

3. I have manually edited the .java file for all the tTeradata components and started the Talend studio, then at runtime the job it asked for a new version jar.

for once it worked, but after restarting the studio again the version is showing as 15 only.

every day, we cannot go and edit the .java file right.

So, I would like to have a permanent solution for this.

After importing the new Teradata version also, it is showing again the older version after restarting or re-opening the Talend studio, so is it a bug of Talend studio 6.4 or am I missing anything.

Kindly provide any other suggestions for this issue.

Best Regards,

Meena P.

Re: tteradata input Truncation Error

kartikdharia — Thu, 12 Mar 2020 14:59:28 GMT

Please also delete the files from the Nexus repository

Re: tteradata input Truncation Error

srsunnys1 — Tue, 14 Jul 2020 09:19:35 GMT

How did you remove files from nexus repository ? I am facing the exact same problem as Meena mentioned.