topic Re: Schema rearranging in tmap component in Talend Studio

Schema rearranging in tmap component

SPrathipati — Fri, 15 Nov 2024 23:04:47 GMT

Currently using the 'Talend open studio for data integration'. My team and I are facing the following issue,

the input schema in tmap shuffles up once you save and open the job the again, which causes mismatch and errors while running the job. Any help on how to fix this issue is much appreciated. Thanks in advance.

Re: Schema rearranging in tmap component

Anonymous — Mon, 28 Mar 2022 12:11:09 GMT

Can you show us some screenshots of what you are experiencing here? I don't believe I have seen this issue

Re: Schema rearranging in tmap component

SPrathipati — Mon, 28 Mar 2022 12:17:47 GMT

this is the starting order of schema which was manually entered into tmap. (I do not have the original schema screenshot since it's already rearranged, but it was of same order as the select query in tDBinput)

----------------------------------------------------

That automatically got rearranged to this when I reopened the job

Re: Schema rearranging in tmap component

gjeremy1617088143 — Mon, 28 Mar 2022 12:31:43 GMT

Hi @Siddhartha Prathipati , it's a wellknown bug on the 7.1 and 7.2.1 , it was fixed since 7.2.2 , on 7.1 you can use metadata to force the schema and when you want to change the schema you pass by the metadata it's the only workaround i know on this version.

Send me love and kudos

Re: Schema rearranging in tmap component

SPrathipati — Mon, 28 Mar 2022 12:33:43 GMT

we are currently on 7.2.1 version of open studio, so upgrading is the only fix?

Re: Schema rearranging in tmap component

gjeremy1617088143 — Mon, 28 Mar 2022 12:38:20 GMT

go to 7.2.2 or 7.3 , or use metadata

Re: Schema rearranging in tmap component

SPrathipati — Mon, 28 Mar 2022 12:39:42 GMT

Thanks lot @guenneguez jeremy .

Re: Schema rearranging in tmap component

gjeremy1617088143 — Mon, 28 Mar 2022 12:42:59 GMT

you can use generic schema in metadata to force the order

Re: Schema rearranging in tmap component

Anonymous — Mon, 28 Mar 2022 14:28:43 GMT

Sorry, I misunderstood the issue here. Thanks @guenneguez jeremy for answering this.