topic Re: tfileouputpositional having issues while loading in Talend Studio

tfileouputpositional having issues while loading

Sudhee_Maximus — Tue, 09 Jun 2020 22:11:57 GMT

Hi There,

I am trying one to one load by munging data (String) and loading back to positional file ...

fileinputpositional-->tmap-->fileoutputpositional both structures are same , but while loading data to target I get attached error.

any help in resolving this issue is really appreciated...

Re: tfileouputpositional having issues while loading

manodwhb — Wed, 10 Jun 2020 05:08:59 GMT

@SudheeReddy ,can you share the error and configuration of tfileouputpositional ?

Re: tfileouputpositional having issues while loading

Sudhee_Maximus — Wed, 10 Jun 2020 07:43:59 GMT

@manodwhb

Thanks for your reply please find the screenshot below and export of metadata attached

outbound.xml
outbound.xml

Re: tfileouputpositional having issues while loading

manodwhb — Wed, 10 Jun 2020 07:59:49 GMT

@SudheeReddy ,since you have not configured tfileouputpositional because of which you are getting compilation error. can you share the component settings of tfileouputpositional?

Re: tfileouputpositional having issues while loading

manodwhb — Wed, 10 Jun 2020 08:13:07 GMT

@SudheeReddy , it is configuration issue in tfileouputpositional ,because of the you are getting compilation error ,could please check configuration of tfileouputpositional and can you share the screenshot of tfileouputpositional?

Re: tfileouputpositional having issues while loading

Sudhee_Maximus — Thu, 11 Jun 2020 13:31:04 GMT

Hi @manodwhb ,

I don't feel its a configuration issue as I am able to read file with the same configuration of file and trying to generate same output file without any changes ...

the only thing I am doing in between is munging (that too is a string with same size)...

could you please let me know what changes or config you are talking about ?

Re: tfileouputpositional having issues while loading

Sudhee_Maximus — Thu, 11 Jun 2020 13:52:10 GMT

figured out the issue, even though I gave size for each columns some of them are not updated and were having no values(size) .... I guess even-though its a string, we need to provide the no of chars(size) it can accept for fixed file delimited files so that it can process the data.

got my answer @manodwhb ... now I don't see the error any more . Thanks !

Re: tfileouputpositional having issues while loading

manodwhb — Thu, 11 Jun 2020 13:52:25 GMT

@SudheeReddy ,why you have not specified size for few coulmns?

Re: tfileouputpositional having issues while loading

manodwhb — Thu, 11 Jun 2020 13:53:50 GMT

@SudheeReddy , you need to provide size for each and every column in tfileouputpositional.

Re: tfileouputpositional having issues while loading

Sudhee_Maximus — Thu, 11 Jun 2020 14:31:54 GMT

not sure @manodwhb

I have provided the size (as you know we need to specify column size for each col in fixed width), but when it scans the file and find no data in the column it updates with no size / may be some issue .

it has created the column but not the size of it (not assumed this to happen when each column has been defied with specific size while creating ).