Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Independent validation for trusted, AI-ready data integration. See why IDC named Qlik a Leader: Read the Excerpt!
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

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. 
Labels (2)
15 Replies
vapukov
Master II
Master II

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
0683p000009MCs9.png    0683p000009MDPP.png
Anonymous
Not applicable
Author

Hi Vapukou,
I thought just click run on the .bat file.   0683p000009MACJ.png
This is the result when run in cmd :
0683p000009MDPU.png
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
vapukov
Master II
Master II

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

The job and scheduler in the same machine. Definitely using the same java version.
Anonymous
Not applicable
Author

Hi,
I have build job and extract the zip file. There will generate three file/folder as below :  
0683p000009MDPZ.png
File in the lib folder : 
0683p000009MDPe.png
Folder F_S02_MYRESULTS_SPPII_KRA_BF_RMK_CODE  > .bat file
 
0683p000009MDPj.png
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....
vapukov
Master II
Master II

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