Hi Ray/ArndW/DSguru,
Thanks to you all for all the help that you have been extending.
The problem is that this PID Failed error is not occurring in a single job only. As i wrote i have 25 jobs in the sequencer, so sometimes this error is coming in the first job, sometimes it is coming in the 5th job and sometimes in some other job. What i mean to say is that it can occur in any of the 25 jobs. Last time when i ran the sequencer again it gave me the same problem and the log for the sequencer looks like this:
Occurred: 2:21:32 PM On date: 12/5/2006 Type: Control
Event: Starting Job Seq1. (...)
Occurred: 2:21:32 PM On date: 12/5/2006 Type: Info
Event: Environment variable settings: (...)
Occurred: 2:21:33 PM On date: 12/5/2006 Type: Info
Event: Seq1..JobControl (@Coordinator): Starting new run of checkpointed Sequence job
Occurred: 2:21:33 PM On date: 12/5/2006 Type: RunJob
Event: Seq1 -> (Sybase_FINCAFL_Load_Job): Job run requested (...)
Occurred: 2:21:33 PM On date: 12/5/2006 Type: Info
Event: Seq1..JobControl (DSRunJob): Waiting for job Sybase_FINCAFL_Load_Job to start
Occurred: 2:21:34 PM On date: 12/5/2006 Type: Info
Event: Seq1..JobControl (DSWaitForJob): Waiting for job Sybase_FINCAFL_Load_Job to finish
Occurred: 2:29:29 PM On date: 12/5/2006 Type: Info
Event: Seq1..JobControl (DSWaitForJob): Job Sybase_FINCAFL_Load_Job has finished, status = 1 (Finished OK)
Occurred: 2:29:30 PM On date: 12/5/2006 Type: Info
Event: Seq1..JobControl (@Sybase_FINCAFL_Load_Job): Report on job: Sybase_FINCAFL_Load_Job (...)
Occurred: 2:29:30 PM On date: 12/5/2006 Type: Info
Event: Seq1..JobControl (@Sybase_FINCAFL_Load_Job): Checkpointed run of job 'Sybase_FINCAFL_Load_Job'
Occurred: 2:29:30 PM On date: 12/5/2006 Type: RunJob
Event: Seq1 -> (Sybase_FINHDR_Load_job): Job run requested (...)
Occurred: 2:29:30 PM On date: 12/5/2006 Type: Info
Event: Seq1..JobControl (DSRunJob): Waiting for job Sybase_FINHDR_Load_job to start
Occurred: 2:29:31 PM On date: 12/5/2006 Type: RunJob
Event: Seq1 -> (Sybase_FINASST_Load_Job): Job run requested (...)
Occurred: 2:29:31 PM On date: 12/5/2006 Type: Info
Event: Seq1..JobControl (DSRunJob): Waiting for job Sybase_FINASST_Load_Job to start
Occurred: 2:29:32 PM On date: 12/5/2006 Type: Info
Event: Seq1..JobControl (DSWaitForJob): Waiting for job Sybase_FINHDR_Load_job+Sybase_FINASST_Load_Job to finish
Occurred: 2:29:32 PM On date: 12/5/2006 Type: Info
Event: Seq1..JobControl (DSWaitForJob): Job Sybase_FINHDR_Load_job has finished, status = 3 (Aborted)
Occurred: 2:29:32 PM On date: 12/5/2006 Type: Warning
Event: Seq1..JobControl (@Sybase_FINHDR_Load_job): Job Sybase_FINHDR_Load_job did not finish OK, status = 'Aborted'
Occurred: 2:29:32 PM On date: 12/5/2006 Type: Info
Event: Seq1..JobControl (@Sybase_FINHDR_Load_job): Report on job: Sybase_FINHDR_Load_job (...)
Occurred: 2:29:32 PM On date: 12/5/2006 Type: Warning
Event: Seq1..JobControl (@Sybase_FINHDR_Load_job): Controller problem: Unhandled abort encountered in job Sybase_FINHDR_Load_job
Occurred: 2:29:32 PM On date: 12/5/2006 Type: Info
Event: Seq1..JobControl (@Sybase_FINHDR_Load_job): Will execute error activity: FailCase_EA
Occurred: 2:29:33 PM On date: 12/5/2006 Type: Info
Event: Seq1..JobControl (DSSendMail): Sent message to '
punardeeps@hcl.in,
ashikm@hcl.in,
amalarpova@hcl.in' (...)
Occurred: 2:29:33 PM On date: 12/5/2006 Type: Info
Event: Seq1..JobControl (@ExceptionMail_NA): Omitted checkpoint for call of routine 'DSSendMail'
Occurred: 2:29:33 PM On date: 12/5/2006 Type: Info
Event: Seq1..JobControl (DSWaitForJob): Waiting for job Sybase_FINASST_Load_Job to finish
Occurred: 2:29:33 PM On date: 12/5/2006 Type: Info
Event: Seq1..JobControl (DSWaitForJob): Job Sybase_FINASST_Load_Job has finished, status = 3 (Aborted)
Occurred: 2:29:33 PM On date: 12/5/2006 Type: Warning
Event: Seq1..JobControl (@Sybase_FINASST_Load_Job): Job Sybase_FINASST_Load_Job did not finish OK, status = 'Aborted'
Occurred: 2:29:33 PM On date: 12/5/2006 Type: Info
Event: Seq1..JobControl (@Sybase_FINASST_Load_Job): Report on job: Sybase_FINASST_Load_Job (...)
Occurred: 2:29:33 PM On date: 12/5/2006 Type: Info
Event: Seq1..JobControl (@Coordinator): Summary of sequence run (...)
Occurred: 2:29:33 PM On date: 12/5/2006 Type: Fatal
Event: Seq1..JobControl (fatal error from @Coordinator): Sequence job (restartable) will abort due to previous unrecoverable errors
Occurred: 2:29:33 PM On date: 12/5/2006 Type: Warning
Event: Attempting to Cleanup after ABORT raised in stage Seq1..JobControl
Occurred: 2:29:33 PM On date: 12/5/2006 Type: Control
Event: Job Seq1 aborted.
End of report.
So 2 jobs got the PID Failed error, the log for the first job(Sybase_FINHDR_Load_job) looks like this:
Occurred: 2:29:30 PM On date: 12/5/2006 Type: Control
Event: Starting Job Sybase_FINHDR_Load_job. (...)
Occurred: 2:29:32 PM On date: 12/5/2006 Type: Warning
Event: Job control process (pid 164150) has failed
Occurred: 2:29:32 PM On date: 12/5/2006 Type: Control
Event: Job Sybase_FINHDR_Load_job. aborted
and the log for the second job(Sybase_FINASST_Load_Job) looks like this:
Occurred: 2:29:32 PM On date: 12/5/2006 Type: Control
Event: Starting Job Sybase_FINASST_Load_Job. (...)
Occurred: 2:29:33 PM On date: 12/5/2006 Type: Warning
Event: Job control process (pid 1781864) has failed
Occurred: 2:29:33 PM On date: 12/5/2006 Type: Control
Event: Job Sybase_FINASST_Load_Job. aborted
End of report.
I am sorry for posting such a long post.But,I think with all this description i will be able to explain my problem. The main issue is that i am getting the PID failed error randomly in jobs. one time it is in one job and the other time it is in some other job. Can you please tell me what could be the possible reason for the same? I am not able to solve this thing from quite some time. I believe with your help I will be able to get through the same.
Thanks a lot for all your help.