Hello,
We have a sequence of jobs and one of the jobs in the sequence starts and gets completed successfully but does not do any processing. It is like the job starts and completes and skips all the stages in the middle.
Any suggestions on why this might be happening is greatly appreciated.
Thanks.
Job starts,gets completed but does no processing
Moderators: chulett, rschirm, roy
The summary log is posted and please let me know if a detailed log is needed too.
Thanks.
Occurred: 4:31:17 PM On date: 8/2/2012 Type: Info
Event: xfm_IntlFreXtract,10: Numeric string expected . Use default value. (...)
Occurred: 4:31:17 PM On date: 8/2/2012 Type: Fatal
Event: main_program: ORCHESTRATE step execution terminating due to SIGINT
Occurred: 4:31:22 PM On date: 8/2/2012 Type: Fatal
Event: Parallel job was aborted
Occurred: 4:31:22 PM On date: 8/2/2012 Type: Control
Event: Job xfmDSPHFRestriction_DLP18_900k_Srt2aNew2 aborted.
Occurred: 10:11:50 AM On date: 8/3/2012 Type: Control
Event: Validating Job xfmDSPHFRestriction_DLP18_900k_Srt2aNew2. (...)
Occurred: 10:11:51 AM On date: 8/3/2012 Type: Info
Event: Environment variable settings: (...)
Occurred: 10:11:51 AM On date: 8/3/2012 Type: Info
Event: main_program: IBM InfoSphere DataStage Enterprise Edition 8.7.0.6126 (...)
Occurred: 10:11:51 AM On date: 8/3/2012 Type: Info
Event: main_program: conductor uname: -s=Linux; -r=2.6.18-308.0.0.0.1.el5; -v=#1 SMP Sat Feb 25 16:16:23 EST 2012; -n=r2dlac2a.delta.com; -m=x86_64
Occurred: 10:11:51 AM On date: 8/3/2012 Type: Info
Event: main_program: orchgeneral: loaded (...)
Occurred: 10:11:52 AM On date: 8/3/2012 Type: Info
Event: main_program: APT configuration file: /dvl/etl2/IBM/InformationServer/Server/Configurations/12node.apt (...)
Occurred: 10:11:52 AM On date: 8/3/2012 Type: Info
Event: main_program: This step has 5 datasets: (...)
Occurred: 10:11:52 AM On date: 8/3/2012 Type: Warning
Event: src_IntlFreXtract: When checking operator: When binding output schema variable "outRec": When binding output interface field "E_surcharge_amt" to field "E_surcharge_amt": Implicit conversion from sour (...)
Occurred: 10:11:52 AM On date: 8/3/2012 Type: Warning
Event: srt_IntlFreXtract: When checking operator: Operator of type "APT_TSortOperator": will partition despite the (...)
Occurred: 10:11:52 AM On date: 8/3/2012 Type: Warning
Event: tgt_IntlFreXtract: When checking operator: A sequential operator cannot preserve the partitioning (...)
Occurred: 10:11:52 AM On date: 8/3/2012 Type: Warning
Event: tgt_IntlIfpmLd: When checking operator: When validating export schema: At field "E_surcharge_amt": "null_field" length (7) must match field's fixed width (8)
Occurred: 10:11:52 AM On date: 8/3/2012 Type: Warning
Event: tgt_IntlIfpmLd: When checking operator: A sequential operator cannot preserve the partitioning (...)
Occurred: 10:11:52 AM On date: 8/3/2012 Type: Warning
Event: tgt_IntlFreXtract: When checking operator: A sequential operator cannot preserve the partitioning (...)
Occurred: 10:11:52 AM On date: 8/3/2012 Type: Warning
Event: tgt_IntlIfpmLd: When checking operator: A sequential operator cannot preserve the partitioning (...)
Occurred: 10:11:52 AM On date: 8/3/2012 Type: Control
Event: Job xfmDSPHFRestriction_DLP18_900k_Srt2aNew2 validated OK.
Occurred: 10:11:52 AM On date: 8/3/2012 Type: RunJob
Event: (seqPHFRestriction_DL4) <- xfmDSPHFRestriction_DLP18_900k_Srt2aNew2: Job under control finished.
Thanks.
Occurred: 4:31:17 PM On date: 8/2/2012 Type: Info
Event: xfm_IntlFreXtract,10: Numeric string expected . Use default value. (...)
Occurred: 4:31:17 PM On date: 8/2/2012 Type: Fatal
Event: main_program: ORCHESTRATE step execution terminating due to SIGINT
Occurred: 4:31:22 PM On date: 8/2/2012 Type: Fatal
Event: Parallel job was aborted
Occurred: 4:31:22 PM On date: 8/2/2012 Type: Control
Event: Job xfmDSPHFRestriction_DLP18_900k_Srt2aNew2 aborted.
Occurred: 10:11:50 AM On date: 8/3/2012 Type: Control
Event: Validating Job xfmDSPHFRestriction_DLP18_900k_Srt2aNew2. (...)
Occurred: 10:11:51 AM On date: 8/3/2012 Type: Info
Event: Environment variable settings: (...)
Occurred: 10:11:51 AM On date: 8/3/2012 Type: Info
Event: main_program: IBM InfoSphere DataStage Enterprise Edition 8.7.0.6126 (...)
Occurred: 10:11:51 AM On date: 8/3/2012 Type: Info
Event: main_program: conductor uname: -s=Linux; -r=2.6.18-308.0.0.0.1.el5; -v=#1 SMP Sat Feb 25 16:16:23 EST 2012; -n=r2dlac2a.delta.com; -m=x86_64
Occurred: 10:11:51 AM On date: 8/3/2012 Type: Info
Event: main_program: orchgeneral: loaded (...)
Occurred: 10:11:52 AM On date: 8/3/2012 Type: Info
Event: main_program: APT configuration file: /dvl/etl2/IBM/InformationServer/Server/Configurations/12node.apt (...)
Occurred: 10:11:52 AM On date: 8/3/2012 Type: Info
Event: main_program: This step has 5 datasets: (...)
Occurred: 10:11:52 AM On date: 8/3/2012 Type: Warning
Event: src_IntlFreXtract: When checking operator: When binding output schema variable "outRec": When binding output interface field "E_surcharge_amt" to field "E_surcharge_amt": Implicit conversion from sour (...)
Occurred: 10:11:52 AM On date: 8/3/2012 Type: Warning
Event: srt_IntlFreXtract: When checking operator: Operator of type "APT_TSortOperator": will partition despite the (...)
Occurred: 10:11:52 AM On date: 8/3/2012 Type: Warning
Event: tgt_IntlFreXtract: When checking operator: A sequential operator cannot preserve the partitioning (...)
Occurred: 10:11:52 AM On date: 8/3/2012 Type: Warning
Event: tgt_IntlIfpmLd: When checking operator: When validating export schema: At field "E_surcharge_amt": "null_field" length (7) must match field's fixed width (8)
Occurred: 10:11:52 AM On date: 8/3/2012 Type: Warning
Event: tgt_IntlIfpmLd: When checking operator: A sequential operator cannot preserve the partitioning (...)
Occurred: 10:11:52 AM On date: 8/3/2012 Type: Warning
Event: tgt_IntlFreXtract: When checking operator: A sequential operator cannot preserve the partitioning (...)
Occurred: 10:11:52 AM On date: 8/3/2012 Type: Warning
Event: tgt_IntlIfpmLd: When checking operator: A sequential operator cannot preserve the partitioning (...)
Occurred: 10:11:52 AM On date: 8/3/2012 Type: Control
Event: Job xfmDSPHFRestriction_DLP18_900k_Srt2aNew2 validated OK.
Occurred: 10:11:52 AM On date: 8/3/2012 Type: RunJob
Event: (seqPHFRestriction_DL4) <- xfmDSPHFRestriction_DLP18_900k_Srt2aNew2: Job under control finished.
Looks to me like you've set the Job Activity stage to validate the job rather than run it.
Occurred: 10:11:50 AM On date: 8/3/2012 Type: Control
Event: Validating Job xfmDSPHFRestriction_DLP18_900k_Srt2aNew2. (...)
Occurred: 10:11:52 AM On date: 8/3/2012 Type: Control
Event: Job xfmDSPHFRestriction_DLP18_900k_Srt2aNew2 validated OK.
Occurred: 10:11:50 AM On date: 8/3/2012 Type: Control
Event: Validating Job xfmDSPHFRestriction_DLP18_900k_Srt2aNew2. (...)
Occurred: 10:11:52 AM On date: 8/3/2012 Type: Control
Event: Job xfmDSPHFRestriction_DLP18_900k_Srt2aNew2 validated OK.
-craig
"You can never have too many knives" -- Logan Nine Fingers
"You can never have too many knives" -- Logan Nine Fingers