Unable to insert rows into Excel (BUG)

[jensej]

Hi 

Im working with Talend Open Studio for Data Integration Version 7.3.1 and I have a problem that's driving me insane.

I try to explain this part of my job (picture). First of all i have a context.output that has either csv or excel. If the context.output is excel as in this case the job is going to create a output.xlsx file and for csv a output.csv.
 
Up left I create an Excel or CSV File and then i'm inserting a header. 

In the next subjob I'm iterating over a list of DB connections. With this connections i'm then running a non select query. In this case an Insert. If the connection is wrong im catching that error and makes an insert to the Excel saying that it was connection error for this connection. If it gets rejected I do the same and if it's succesfully executed I wan't to make a insert with infos about the insert for that connection. 

For csv everything works as I want but for excel I can't manage to Insert row where the red frame is. On the other OutputExcel (green frame) the inserts works as expected. I have doublechecked all settings and it component has exact the same settings/schema and so on as the others. Im appending rows to existing file and sheet from the file that were created in the headers part. 

I made a copy of the schema to a logrow to see if really had some values to insert and I even tried to add a tjavarow between the tmap and my exceloutput to see if that could solve why I just can't insert this row. I just passed the values thru the tjavarow and printed each row. I marked the tjavarow and tlogrow with colors so that you can see what it returns to the log but even though tjavarow and tlogrow has value my file holds rows from all the green frames but not from the red one. 

This has to be a bug or not? Im inserting into a postgres database if that is neccesarry to know. 




In this part of my job 

[Shicong_Hong · Accepted solution]

Hello @jensej Thanks for your demo job, finally I have reproduced the issue and confirm the bug. Can you please open a Jira issue in this page? You can attach my demo job in the Jira ticket for our R&D team to reproduce the issue. 

Here is a workaround to fix this issue, see below. 

Please try it and let me know if it works.

Regards

Shicong

[jensej]

Iv'e tried your workaround and it still doesn't work as wish. Now the rows are being added from the insert but it also has the same row multiple times. 

I think you have to add the iteration over the connection file to really test my usecase and there add multiple connections. 

In the pictures you see how my job looks like now with the workaround and the outputs. 

[jensej]

I now found the setting in the tHashinput to clear the cache after reading and now the workaround works. 

[Shicong_Hong]

Glad to hear that and thanks for your feedback!