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:59 GMT

Task description: merging five (5) tables; 1st (ID, PRODUCT_NAME) ca. 5438 rows, 2nd to 4th 14 colums (ID, PRODUCT_NAME, MONTHLY_SALE_JAN - DEC). Table 2 to 4 are 14 variables, 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.

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

manodwhb — Tue, 21 Apr 2020 03:42:31 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).

manodwhb — Tue, 21 Apr 2020 03:44:54 GMT

I am deleting this since duplicate case.