topic tFileUnarchive does not work in scheduled task in Talend Studio

tFileUnarchive does not work in scheduled task

s_mil — Fri, 15 Nov 2024 22:17:45 GMT

Hello!

I've created a job where a ZIP file is downloaded to a folder and I use the component tFileUnarchive to extract files in the same folder where the ZIP file is located.

I've built my job and now it's running on a Windows Server as scheduled task. I've set up the task with my personal account on the server, but it is running with a service account and highest privileges. Obviously I've set the job to run whether the user is loggen on or not.

The job starts correctly, it downloads the ZIP file correctly but it is unable to extract files from ZIP file.

The task scheduler returns the job is succesfully completed but it has 2147942401 as return code.

I've checked suggestions I've found here https://stackoverflow.com/questions/65129072/batch-file-run-as-scheduled-job-returns-2147942659 and here https://stackoverflow.com/questions/48343993/batch-file-from-scheduled-task-returns-code-2147942401 without success.

The weird thing is that if I run the job manually (right click --> run) or If I log on the server with my account and I schedule a job after a couple of minutes (always running with the service account) it works correctly.

Do you have any suggestion?

Thanks

Re: tFileUnarchive does not work in scheduled task

Anonymous — Thu, 08 Dec 2022 07:40:34 GMT

Hello,

Generally it could depend from Your Job design.

Would you mind posting your job design screenshots here which will be helpful for us to address your issue quickly?

Best regards

Sabrina

Re: tFileUnarchive does not work in scheduled task

jlolling — Fri, 09 Dec 2022 10:31:52 GMT

Sound strange but the SYSTEM account does not have all permissions to work with files from other users.

It has nothing to do with the job design, it has only to do with the file system permissions. Your normal job use do not have write permission to the desired target extraction folder, I guess. Try to run the job with a dedicated user (e.g. create a user talend) for running jobs and not with the SYSTEM user.