topic Re: tLogRow ok, tFileOutputExcell IllegalArgumentException: Invalid row number (1048577) in Talend Studio

tLogRow ok, tFileOutputExcell IllegalArgumentException: Invalid row number (1048577)

Skywalker1 — Sat, 16 Nov 2024 02:37:56 GMT

Task description: merging five (5) tables; 1st (ID, PRODUCT_NAME) 5438 rows, 2nd to 4th 14 colums (ID, PRODUCT_NAME, MONTHLY_SALE_JAN - DEC). Table 2 to 4 are 14 columns, each 4.5-5k rows. Expected outcome 50 columns, 5438 rows. System (Talend Studio) behaviour: tLogRow runs without errors, but continously (?!). tFileOutputExcell reaches 1.048.576 and reports error - maximum file size exceeded (number of rows exceeded). Please have a look at attached screenshots. Anybody encountered similar situation? Any hints how to achieve expected results? Kind regards, S. Ps. Posting at the right place now (not Sandbox but MySQL) and explaining the issue more clearly.

Re: tLogRow ok, tFileOutputExcell IllegalArgumentException: Invalid row number (1048577)

manodwhb — Tue, 21 Apr 2020 03:43:25 GMT

Check the below solution.
https://community.talend.com/t5/Design-and-Development/IllegalArgumentException-Invalid-row-number-outside-allowable/ta-p/194

Re: tLogRow ok, tFileOutputExcell IllegalArgumentException: Invalid row number (1048577)

Skywalker1 — Tue, 21 Apr 2020 20:36:54 GMT

tMap node wrongly specified produced Cartesian product :-0 😉

Re: tLogRow ok, tFileOutputExcell IllegalArgumentException: Invalid row number (1048577)

manodwhb — Wed, 22 Apr 2020 04:41:21 GMT

@Skywalker , yes, if you have not configured tmap for join you will find Cartesian product .