Scheduling Error 0x1

One Star

Scheduling Error 0x1

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. 
Moderator

Re: Scheduling Error 0x1

Hi,
Can you execute your job successfully in talend studio?
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: Scheduling Error 0x1

Yes, the job success running in talend
Moderator

Re: Scheduling Error 0x1

Hi,
Can you execute the exported job .bat file successfully in cmd? Is your DB2 Data Base on local or server?
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.
Twelve Stars

Re: Scheduling Error 0x1

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
-----------
One Star

Re: Scheduling Error 0x1

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

Re: Scheduling Error 0x1

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

Re: Scheduling Error 0x1

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
--
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: Scheduling Error 0x1

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...
Moderator

Re: Scheduling Error 0x1

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
--
Don't forget to give kudos when a reply is helpful and click Accept the solution when you think you're good with it.
Twelve Stars

Re: Scheduling Error 0x1

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
   
-----------
One Star

Re: Scheduling Error 0x1

Hi Vapukou,
I thought just click run on the .bat file.  Smiley Very Happy
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
Twelve Stars

Re: Scheduling Error 0x1

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

Re: Scheduling Error 0x1

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

Re: Scheduling Error 0x1

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....
Twelve Stars

Re: Scheduling Error 0x1

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
-----------