topic Re: Facing Issue when fields are more for SCD type 2 with TOS SCD components in Talend Studio

Facing Issue when fields are more for SCD type 2 with TOS SCD components

Anonymous — Fri, 26 Jun 2020 08:46:37 GMT

Hi,

I'm trying to do SCD type 2 on mysql tables using TOS SCD components. But getting error stating -

"The code of tDBInput_1Process(Map<String,Object) is exceeding the 65535 bytes limit".

Please suggest what is the solution for this issue.

vapukov — Fri, 26 Jun 2020 14:10:26 GMT

Hi,

as variant too many columns and/or columns names too long

65k it is a java limit for code module, with many columns AND long names it could happen

try to revise columns set, do all must be tracked as SCD?

cheers

vapukov — Fri, 26 Jun 2020 14:10:26 GMT

Hi,

as variant too many columns and/or columns names too long

65k it is a java limit for code module, with many columns AND long names it could happen

try to revise columns set, do all must be tracked as SCD?

cheers