I have many sequences that hang at certain points of the job run. Checkpointing in the job properties is selected so that the sequence is restartable on failure. A typical log from director shows as:
Code: Select all
Item #: 1
Message Id: IIS-DSTAGE-RUN-I-0070
Message: Starting Job Seq_StgCMT_FACILITY_TYPE_T.
Item #: 4
Message Id: IIS-DSTAGE-RUN-I-0019
Message: Seq_StgCMT_FACILITY_TYPE_T..JobControl (@Coordinator): Starting new run of checkpointed Sequence job
Message: Seq_StgCMT_FACILITY_TYPE_T..JobControl (@Test_Source_File): Omitted checkpoint for call of routine 'DSWaitForFile'
Message Id: IIS-DSTAGE-RUN-I-0034
Message: Seq_StgCMT_FACILITY_TYPE_T -> (Stg_CMT_FACILITY_TYPE_T): Job run requested
Mode (row/warn limits) = 0/0
Message: Seq_StgCMT_FACILITY_TYPE_T..JobControl (DSRunJob): Waiting for job Stg_CMT_FACILITY_TYPE_T to start
Message: Seq_StgCMT_FACILITY_TYPE_T..JobControl (DSWaitForJob): Waiting for job Stg_CMT_FACILITY_TYPE_T to finish
Message: Seq_StgCMT_FACILITY_TYPE_T..JobControl (DSWaitForJob): Job Stg_CMT_FACILITY_TYPE_T has finished, status = 1 (Finished OK)
Message: Seq_StgCMT_FACILITY_TYPE_T..JobControl (@jsCMT_FACILITY_TYPE_T): Omitted checkpoint for run of job 'Stg_CMT_FACILITY_TYPE_T'
End of report.
Problem is that many times my many sequences hang at the last point...after the "child server job" has run, then the sequence is to checkpoint it or to omit the checkpoint. Soonafter, it has to make a call to a routine that will run a multi instance job that will populate a control table.
can somebody please tell me what could be the reason for the job hanging?
I initially thought that it may be because i am running many jobs at the same time..so the routine may not be invoked concurrently.....or the databse table lock....But I ran this particular job in isolation and i still got stuck.
Please advise