Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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.
Hi Bamsen..
Before writing into delimited file just check with tLogRow .
I already have a TlogRow before the output and i can see nothing suspicious.
So this is how my Job looks like
And 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
Use another one logrow after the delimitedfile .If it's give same log output ..The problem may be in schema of our delimited file.
Ive tried your suggestion, the new tLogRow prints the same as the one in front of the FileOutputDelimited.
check your schema of logrow and delimitedfile..
if you pass three values you must have three fields in schema.
all the fields are in every schema 😕
Check your column value contain any delimited character?
Your input values to delimited file must not contain specified delimited character.