Job fails when run as a batch, yet works fine when run from Talend

Highlighted
One Star

Job fails when run as a batch, yet works fine when run from Talend

Hi
I have created a simple Talend DI job which extracts data from one data source and inserts into a SQL database into a number of tables. I need the job to run on a daily schedule, so have exported the job scripts and am able to run the windows batch job created.
When the job is running from the batch file, it stops half way through having updated some tables and not others. If I run the job from within Talend it completes successfully every time.
Any ideas why this would be happening, or how I would diagnose the issue?
I am running an old version of Talend 4.1.0, happy to upgrade of this would help, so long as I can import the job into the new version.

Many thanks
Steve
Moderator

Re: Job fails when run as a batch, yet works fine when run from Talend

Hi,
Is there any dependency in your job? Did you follow up online document TalendHelpCenter:How to build Jobs to export your job as .bat file?
Best regards
Sabrina
--
Don't forget to give kudos when a reply is helpful and click Accept the solution when you think you're good with it.
One Star

Re: Job fails when run as a batch, yet works fine when run from Talend

Hi Sabrina
I fall over on the The first part of the documentation you refer to which states:
before building your Job, go to Window > Preferences, select Talend > Import/Export, and then select the Add classpath Jar, when export job.
I don't seem to have this option, the only options I see when navigating to Import/Export are:
Import / Export > Use recent file name to save, When export job script
Shell Setting> %GENERATED_TOS_CALL%
Spagic Server> Enable / Disable Deploy on Spagic
SpagoBi> Enable/Disable Deploy on SpagoBi
Continuing through the documentation, I also don't have the option for the next step of right click the job and select "build job"
I am running 4.1.0, are there separate instructions for this version, do I need to upgrade, can I import projects / jobs from 4.1.0 if I do need to upgrade?
Thanks!
Steve

15TH OCTOBER, COUNTY HALL, LONDON

Join us at the Community Lounge.

Register Now

2019 GARNER MAGIC QUADRANT FOR DATA INTEGRATION TOOL

Talend named a Leader.

Get your copy

OPEN STUDIO FOR DATA INTEGRATION

Kickstart your first data integration and ETL projects.

Download now

What’s New for Talend Summer ’19

Watch the recorded webinar!

Watch Now

Best Practices for Using Context Variables with Talend – Part 4

Pick up some tips and tricks with Context Variables

Blog

How Media Organizations Achieved Success with Data Integration

Learn how media organizations have achieved success with Data Integration

Read

6 Ways to Start Utilizing Machine Learning with Amazon We Services and Talend

Look at6 ways to start utilizing Machine Learning with Amazon We Services and Talend

Blog