topic Re: Scheduling Error 0x1 in Talend Studio

Scheduling Error 0x1

Anonymous — Wed, 22 Feb 2017 01:31:07 GMT

Hi,
Im getting error 0x1 using window task scheduler. How to find/solve the problem?
The data source from DB2. I have try to schedule other job its work but the source from file.
Thank you.

Re: Scheduling Error 0x1

Anonymous — Wed, 22 Feb 2017 04:10:19 GMT

Hi,
Can you execute your job successfully in talend studio?
Best regards
Sabrina

Re: Scheduling Error 0x1

Anonymous — Wed, 22 Feb 2017 05:31:29 GMT

Yes, the job success running in talend

Re: Scheduling Error 0x1

Anonymous — Wed, 22 Feb 2017 08:16:43 GMT

Hi,
Can you execute the exported job .bat file successfully in cmd? Is your DB2 Data Base on local or server?
Best regards
Sabrina

Re: Scheduling Error 0x1

vapukov — Wed, 22 Feb 2017 09:59:07 GMT

First of all - add in Scheduler default folder (Start in) same as .bat file location
If not help:
1 - open CMD Window
2 - change folder to Your Talend Job folder (where locate .bat file)
3 - run .bat file
in this case You will have all errors, and will be possible to understand source of error

Re: Scheduling Error 0x1

Anonymous — Thu, 23 Feb 2017 04:08:46 GMT

Vapukov,
I had try to add directory in Start in. I got error "The directory name is invalid"....

Re: Scheduling Error 0x1

vapukov — Thu, 23 Feb 2017 08:56:59 GMT

Sorry - but I can not guess what are You do wrong
this is from real example
did You operation for other way mentioned by me?

Re: Scheduling Error 0x1

Anonymous — Thu, 23 Feb 2017 09:20:35 GMT

Hi,
Can you execute the exported job .bat file successfully in cmd? Is there any more error when use window task schedule?
Best regards
Sabrina

Re: Scheduling Error 0x1

Anonymous — Fri, 24 Feb 2017 02:44:08 GMT

Hi XDSHI,
The .bat file is unsuccessfully run in cmd.
There is no error show in window task scheduler. Refer image below.

I dont know how to fix the problem...

Re: Scheduling Error 0x1

Anonymous — Fri, 24 Feb 2017 07:45:33 GMT

Hi,
The job should be Ok without issue. Could you please try to use other third scheduler tools to see if it works?
Best regards
Sabrina

Re: Scheduling Error 0x1

vapukov — Fri, 24 Feb 2017 07:55:38 GMT

Hi XDSHI,
The .bat file is unsuccessfully run in cmd.
There is no error show in window task scheduler. Refer image below.
231652/mini_blob_20170223-1843.png
I dont know how to fix the problem...

if .bat unsuccessful in CMD(!!!) - Your Job not working not depending from scheduler
Did You really(?!) run it in CMD (Command Line ) windows?
If You run Job in CMD (as described above)
You must have much more information about - what wrong

Re: Scheduling Error 0x1

Anonymous — Tue, 28 Feb 2017 03:16:56 GMT

Hi Vapukou,
I thought just click run on the .bat file.
This is the result when run in cmd :

There is an error on tDB2Input component. If I run the job from talend, there is no error and connection to db2 is successful.
Thanks

Re: Scheduling Error 0x1

vapukov — Tue, 28 Feb 2017 04:36:02 GMT

Java version (double check !) - the same on both machine? (to clarify - Studio and Scheduler on same machine?)

Re: Scheduling Error 0x1

Anonymous — Tue, 28 Feb 2017 05:32:34 GMT

The job and scheduler in the same machine. Definitely using the same java version.

Re: Scheduling Error 0x1

Anonymous — Fri, 03 Mar 2017 03:52:40 GMT

Hi,
I have build job and extract the zip file. There will generate three file/folder as below :

File in the lib folder :

Folder F_S02_MYRESULTS_SPPII_KRA_BF_RMK_CODE > .bat file

On the bat file bring "db2jcc4.jar", it is different on the lib folder which is "db2jcc.jar".
This is why my task scheduler getting error.
How to make it as same?
Many Thankss....

Re: Scheduling Error 0x1

vapukov — Fri, 03 Mar 2017 07:07:42 GMT

DB2 drivers not free
for developer purpose for LUW You can download it from IBM site
for mainframes - need ask support (with contract number)
this is a born a question - are Your Job work in Studio?!
Talend not provide DB2 drivers (exactly this 3 files), You must install all of them manually
For AS400 - Talend come with drivers and Jobs work and from studio and from command line (tested) for other DB2 - You must worry about jdbc by Your self