Varying nature of job run
Posted: Fri Jul 09, 2010 2:57 am
This is just out of curiosity ,
I have a simple job with seq file as source , then transformer and then target table. I am trying to read input files using File Pattern in Windows. I am unable view data in source so far.
During testing/debugging i found sometimes jobs are getting aborted and sometimes sucessful with no data on link till target.
Below are logs i encountered few times.
Starting Job test3.
Parallel job initiated
Parallel job default NLS map ISO-8859-1, default locale OFF
main_program: Ascential DataStage(tm) Enterprise Edition 7.5 Copyright (c) 2004, 1997-2004 Ascential Software Corporation. All Rights Reserved
main_program: orchgeneral: loaded orchsort: loaded orchstats: loaded
seq_Lead_Response,0: Couldn't find any files on host XXXXXX with pattern C:/Documents and Settings/User1/Desktop/DSX/A_custinteraction*.*.
main_program: Step execution finished with status = OK.
main_program: Startup Time 0:04 Production Run Time 0:02
Parallel job reports successful completion
Finished Job test3.
Starting Job test3.
Parallel job initiated
Parallel job default NLS map ISO-8859-1, default locale OFF
main_program: Ascential DataStage(tm) Enterprise Edition 7.5 Copyright (c) 2004, 1997-2004 Ascential Software Corporation.All Rights Reserved
main_program: orchgeneral: loaded orchsort: loaded orchstats: loaded
main_program: createFilesetFromPattern(): Couldn't find any files on host XXXXXX with pattern C:/Documents and Settings/User1/Desktop/DSX/A_custinteraction*.*.
seq_Lead_Response: At least one filename or data source must be set in APT_FileImportOperator before use.
main_program: Could not check all operators because of previous error(s)
main_program: Creation of step finished with status = FAILED
Job test3 aborted.
My Q is : Why the same job is getting aborted/successful for same issue?
Such issues we have observed few more times where DS seems to be unstable.
I have a simple job with seq file as source , then transformer and then target table. I am trying to read input files using File Pattern in Windows. I am unable view data in source so far.
During testing/debugging i found sometimes jobs are getting aborted and sometimes sucessful with no data on link till target.
Below are logs i encountered few times.
Starting Job test3.
Parallel job initiated
Parallel job default NLS map ISO-8859-1, default locale OFF
main_program: Ascential DataStage(tm) Enterprise Edition 7.5 Copyright (c) 2004, 1997-2004 Ascential Software Corporation. All Rights Reserved
main_program: orchgeneral: loaded orchsort: loaded orchstats: loaded
seq_Lead_Response,0: Couldn't find any files on host XXXXXX with pattern C:/Documents and Settings/User1/Desktop/DSX/A_custinteraction*.*.
main_program: Step execution finished with status = OK.
main_program: Startup Time 0:04 Production Run Time 0:02
Parallel job reports successful completion
Finished Job test3.
Starting Job test3.
Parallel job initiated
Parallel job default NLS map ISO-8859-1, default locale OFF
main_program: Ascential DataStage(tm) Enterprise Edition 7.5 Copyright (c) 2004, 1997-2004 Ascential Software Corporation.All Rights Reserved
main_program: orchgeneral: loaded orchsort: loaded orchstats: loaded
main_program: createFilesetFromPattern(): Couldn't find any files on host XXXXXX with pattern C:/Documents and Settings/User1/Desktop/DSX/A_custinteraction*.*.
seq_Lead_Response: At least one filename or data source must be set in APT_FileImportOperator before use.
main_program: Could not check all operators because of previous error(s)
main_program: Creation of step finished with status = FAILED
Job test3 aborted.
My Q is : Why the same job is getting aborted/successful for same issue?
Such issues we have observed few more times where DS seems to be unstable.