tMap changes the column order

[peterko]

Hi, 

tMap changes the column order for the output automatically.

I set the column order, clicked apply button, OK and when I close the job and reopen the job, then the order of output schema is different (newly added columns are on the top instead of my setup).

It's simple job:

CSVSource (schema is OK) --> tMap (output schema is changing automatically all the time) --> tMap (output schema is changing automatically all the time) --> DBInsert (schema is OK)

[Anonymous]

The input schema of your first tMap should match your CSV Source schema. Is this the case? The output schema can be affected by the schema of the component you are linking to. These schemas should match. Does your output schema from your 1st tMap match the input schema of your 2nd tMap? 

[peterko]

yes, the Input schema matches the CSV schema. But the output schema is changing all the time.

I've tried to rename some of the columns, remove the connection between the components (without deleting the output schema in tMap), but nothing works.

The only solution I found is to create a new tMap component and set the columns again, which is a really bad solution, because if the schema contains 30 columns and every column has JAVA transformation code so it takes a lot of time with the possibility to make a mistakes during copying the code... So it's a really weird bug. My colleague has the same issue on another project and on another computer (but the same TOS-DI version). So it seems as an application bug.

[Anonymous]

Is this a job that you could export and send to me? I'd be interested to take a look and see what I can find. Also, what version are you using?

[Anonymous · Accepted solution]

Hello,

Here exists a jira issue:https://jira.talendforge.org/browse/TUP-23809  and it is fixed in 7.3.1, 7.2.2.

Let us know if it is what you are looking for.

Best regards

Sabrina

[MaheswarReddy]

Hi peterko,

Even i was facing the same issue . and this was a bug 

This was a bug in Talend and as @xdshi mentioned, It is fixed  in the latest versions of Talend.

Thanks,

Mahesh.

[peterko]

Thanks.

I'm using v7.2.1. so that's a case. I did exactly as it is described in the fix, but it's a problem in case you have 30 columns with custom expressions...

Unfortunately I haven't find the version 7.2.2 for download. Any ETA when v7.3.1 should be released as the stable version?

[Anonymous]

Hello @peterko 

Here are the newly added features for 7.3.1M1
https://jira.talendforge.org/issues/?filter=30425
and bugfixes:
https://jira.talendforge.org/issues/?filter=30430

The 7.3 GA is probably available in Feb, 2020.

Best regards

Sabrina

[FrancoisSmfy]

Hello,

You said that the issue is fixed in the 7.2.2 version, but this version is nowhere to be found.

We try to get the code modification from Git, but it require a compilation, not just a file modification.

The time between 2 two versions of Talend (7.2 > 7.3) are quite long, how the TOS users can patch their installation ?

[Anonymous]

@sm, unfortunately, the TOS user can not patch their installation, you have to wait for the new release. For testing, you can download the milestone version 7.3.1M5 and validate if it fix the bug.