Job starts,gets completed but does no processing

A forum for discussing DataStage<sup>®</sup> basics. If you're not sure where your question goes, start here.

Moderators: chulett, rschirm, roy

Post Reply
pdntsap
Premium Member
Premium Member
Posts: 107
Joined: Mon Jul 04, 2011 5:38 pm

Job starts,gets completed but does no processing

Post by pdntsap »

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.
chulett
Charter Member
Charter Member
Posts: 43085
Joined: Tue Nov 12, 2002 4:34 pm
Location: Denver, CO

Post by chulett »

Can you post the log entries from the "no processing" run?
-craig

"You can never have too many knives" -- Logan Nine Fingers
pdntsap
Premium Member
Premium Member
Posts: 107
Joined: Mon Jul 04, 2011 5:38 pm

Post by pdntsap »

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.
chulett
Charter Member
Charter Member
Posts: 43085
Joined: Tue Nov 12, 2002 4:34 pm
Location: Denver, CO

Post by chulett »

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

"You can never have too many knives" -- Logan Nine Fingers
pdntsap
Premium Member
Premium Member
Posts: 107
Joined: Mon Jul 04, 2011 5:38 pm

Post by pdntsap »

You are right, Craig. My bad as I wanted it to be "reset if required, then run".

Thanks.
Post Reply