topic Detail Message: The code of method tDBInput_1Process(Map<String,Object>) is exceeding the 65535 bytes limit in Talend Studio

Detail Message: The code of method tDBInput_1Process(Map) is exceeding the 65535 bytes limit

Ameyy — Sat, 16 Nov 2024 00:07:35 GMT

I need a solution for this error message. I understand the issue after reading several discussion boards. However, I am not finding a solution that works. My source has 380 columns which i use tmap to do datatype conversions into my oracle target. Any suggestion on how can I reduce the size of the generated code?

Re: Detail Message: The code of method tDBInput_1Process(Map) is exceeding the 65535 bytes limit

gjeremy1617088143 — Tue, 25 May 2021 06:48:09 GMT

Hi, is due to java limitation , you can take a look at https://www.thinkartha.com/blog/talend-studio-best-practices-increase-studio-performance-and-settings/

it will provide a solution that maybe can work in your job.

Send me Love and Kudos

Re: Detail Message: The code of method tDBInput_1Process(Map) is exceeding the 65535 bytes limit

Anonymous — Tue, 25 May 2021 08:00:57 GMT

Hello,

Please feel free to let us know if this article helps.

https://community.talend.com/s/article/Exceeding-the-Java-bytes-limit-1Z1UZ

Best regards

Sabrina

Re: Detail Message: The code of method tDBInput_1Process(Map) is exceeding the 65535 bytes limit

kotvir — Wed, 27 Oct 2021 21:38:23 GMT

This solution does not work at all. This is definately a bug to be fixed or make the fixed version available in Talend Open Studio ASAP ( if already fixed).

Re: Detail Message: The code of method tDBInput_1Process(Map) is exceeding the 65535 bytes limit

Anonymous — Thu, 28 Oct 2021 03:57:43 GMT

Hello,

You could raise a jira issue of DI project for work item issue on talend jira portal. Our developers will check your issue and give a workaround on your use case.

Best regards

Sabrina

Re: Detail Message: The code of method tDBInput_1Process(Map) is exceeding the 65535 bytes limit

gjeremy1617088143 — Thu, 28 Oct 2021 07:43:10 GMT

I can suggest to do it in two time, you made one insert with id and the first 190 columns then you made an update with id and the last 189 columns.