Talend community forum / Logging gives error when ran in batch job.

mpa · 2012-05-16 15:16:56

Tags: [bug, delimited file, error, error management, mssql]

Hi,

I've got a problem with my daily job that is exported and scheduled in windows scheduler.
In my logging it started giving failure for one of my jobs.

So since it doesn't show the error message of what went wrong I opened my talend and ran the job to see what the error is. However suprisingly the job ran without any errors. So I thought it would of been some random error and it would be normal the next day.

It's now been over 7 days and it keeps giving error in the log file everyday. I re-exported the job again (in case of an old version exported maybe) but that didn't solve anything.

Is there anyway to know what can go wrong? (i'm using the tStatcatcher for my logging)

(the job reads in a file by the way)

Regards,
Mario

phobucket · 2012-05-16 18:23:05

mpa,

Did anything change about either the job, or the file inputs to the job 7 days ago? Maybe the file format changed? Also, is the user running from the windows scheduler the same user running the job in Talend. Just wondering if it is a file permissions problem.

mpa · 2012-05-18 08:01:54

phobucket,

Nothing has changed to the job. It ran for over a year without any problems. I don't think the file has changed because when I ran the job in Talend I reloaded the same file as the daily run (batch) used and it ran without any problems.

The windows scheduler job still runs on the same user.

Thanks for your reply.

Regards

mpa · 2012-05-23 10:30:03

I saw something else in the logging.

Since the logging shows failure it seems to start my childjobs two times at the same time for some reason.
I have like 10 chiljobs and the first 3-4 gets ran twice, which it has never done before.

Job runs without any errors in Talend and in the exported job.
However in Talend in writes success to the logging table. When ran from the exported bat file it writes failure to the logging.

What can be the reason of this?

Regards

Last edited by mpa (2012-05-25 09:00:19)

mpa · 2012-05-25 09:00:45

Nobody has a solution for this?

Announcement

Unanswered posts

#1 2012-05-16 15:16:56

Logging gives error when ran in batch job.

#2 2012-05-16 18:23:05

Re: Logging gives error when ran in batch job.

#3 2012-05-18 08:01:54

Re: Logging gives error when ran in batch job.

#4 2012-05-23 10:30:03

Re: Logging gives error when ran in batch job.

#5 2012-05-25 09:00:45

Re: Logging gives error when ran in batch job.

Board footer