topic Re: FileOutputDelimited writes to a wrong file in Talend Studio

FileOutputDelimited writes to a wrong file

Anonymous — Fri, 24 Nov 2017 08:41:10 GMT

Hi,

I once more need help with a Talend Job Im writing. The Task of it is to check if certain Files are in a directory, rename those and to write a log.txt if there are any problems. The log is written by a tFileOutputDelimited with informations given by a tJavaRow-Code. After testing the Job Ive run into a big and for me strange Problem. Lets say there are 3 Statements to be written in the log (a, b and c). The log in the end contains only b and c, while a is missing. Its always the first one that is not there, the other are normally written to the log in the exact directory. By Accident Ive found the missing Statements on my desktop in a File called "testnull.dat" where the Job has written all the missing statments from the last 2 days I tested this Job.

I really have no clue how to solve this or where it could come from. I hope I could explain my problem properly. If there are any additional informations needed, I will try to provide them.

Re: FileOutputDelimited writes to a wrong file

Anonymous — Fri, 24 Nov 2017 09:42:40 GMT

Hi Bamsen..

Before writing into delimited file just check with tLogRow .

Re: FileOutputDelimited writes to a wrong file

Anonymous — Fri, 24 Nov 2017 09:45:23 GMT

I already have a TlogRow before the output and i can see nothing suspicious.

Re: FileOutputDelimited writes to a wrong file

Anonymous — Fri, 24 Nov 2017 09:47:26 GMT

Send your screen shots I will look once

Re: FileOutputDelimited writes to a wrong file

Anonymous — Fri, 24 Nov 2017 09:55:20 GMT

So this is how my Job looks likeAnd this is the tLogRow, logfile is the name of the log (Timestamp), output is the String written to the log and fall is just the case, just something for testing

Re: FileOutputDelimited writes to a wrong file

Anonymous — Fri, 24 Nov 2017 10:03:45 GMT

Use another one logrow after the delimitedfile .If it's give same log output ..The problem may be in schema of our delimited file.

Re: FileOutputDelimited writes to a wrong file

Anonymous — Fri, 24 Nov 2017 10:11:57 GMT

Ive tried your suggestion, the new tLogRow prints the same as the one in front of the FileOutputDelimited.

Re: FileOutputDelimited writes to a wrong file

Anonymous — Fri, 24 Nov 2017 10:23:48 GMT

check your schema of logrow and delimitedfile..

if you pass three values you must have three fields in schema.

Re: FileOutputDelimited writes to a wrong file

Anonymous — Fri, 24 Nov 2017 10:28:22 GMT

all the fields are in every schema 😕

Re: FileOutputDelimited writes to a wrong file

Anonymous — Fri, 24 Nov 2017 10:46:03 GMT

Check your column value contain any delimited character?

Your input values to delimited file must not contain specified delimited character.

Re: FileOutputDelimited writes to a wrong file

Anonymous — Fri, 24 Nov 2017 11:00:56 GMT

Im sorry, but i dont understand what you mean? what should i check?

Re: FileOutputDelimited writes to a wrong file

Anonymous — Fri, 24 Nov 2017 11:11:23 GMT

Your input column (logfile,output,fall) values (which you got in logrow output) to the delimited file must not contain that 'Field Separator' character. In this case you may get problem.

Re: FileOutputDelimited writes to a wrong file

Anonymous — Fri, 24 Nov 2017 11:17:22 GMT

ive made some changes so that what you meant shouldnt happen. But i still got the same problem... Thank you anyway!

Re: FileOutputDelimited writes to a wrong file

Anonymous — Sat, 25 Nov 2017 10:32:36 GMT

Do you mean the output is wrong or the component fills a wrong file (e.g. the wrong path + file name)?

What you cannot do is to use a value from the flow and use it as output file name.

The output file will be created tight at the start of the process just at the first iteration between tFileList and the 2 component.

Re: FileOutputDelimited writes to a wrong file

Anonymous — Mon, 27 Nov 2017 09:10:13 GMT

Hey,

I´ve just read your comment (weekend ). Now I understand what is going wrong. As you described, I´m using a variable from the process for the created File, so this seams to be the problem. Thank you! Now I can think of how I can avoid this Problem

Re: FileOutputDelimited writes to a wrong file

Anonymous — Mon, 27 Nov 2017 09:23:09 GMT

Hello,

Can we consider this topic as "Solved"? Feel free mark solution as accepted if this solution is OK with you.

Best regards

Sabrina