multiple invocations of a multi instance job failing
Posted: Thu Apr 16, 2009 3:12 pm
We have a multi instance AUDIT job that runs for each and every job and collect the job stats and load them to AUDIT tables. Sometimes the job is failing when couple instances of the job is running with multiple invocations. We got the following error.
Error calling DSRunJob(SEQX_ROUTINE_SAVE_JOB_INFO.J040_CIMS_MPI_SDS_PHYSICIANS_ODS_O_CUST_ID_test.CCC_sAUDIT_SK), code=-2 [Job is not in the right state (compiled and not running)]
To test the parallel invocation of a multi-instance job,I have created a test Job Sequencer which calls a multi instance job with five different invocations. Some times job is completing successfully where as sometimes the job is failing with one of the INVOCATION CALL is failing with a job status 99.
Do we need to set something at the PROJECT level to support multi instance jobs.Please share if you have faced this issue eariler.
SEQX_PARALLEL_AUDIT_test321..JobControl (@Coordinator): Summary of sequence run
12:06:43: Sequence started (checkpointing on)
12:06:43: EEE (JOB J100_ODS_CONFORMANCE_SMS_CUST_ADDR_TLPHN_4654_SP_test123.EEE) started
12:06:45: DDD (JOB J100_ODS_CONFORMANCE_SMS_CUST_ADDR_TLPHN_4654_SP_test123.DDD) started
12:06:48: CCC (JOB J100_ODS_CONFORMANCE_SMS_CUST_ADDR_TLPHN_4654_SP_test123.CCC) started
12:06:50: BBB (JOB J100_ODS_CONFORMANCE_SMS_CUST_ADDR_TLPHN_4654_SP_test123.BBB) started
12:06:52: AAA (JOB J100_ODS_CONFORMANCE_SMS_CUST_ADDR_TLPHN_4654_SP_test123.AAA) started
12:10:17: CCC (JOB J100_ODS_CONFORMANCE_SMS_CUST_ADDR_TLPHN_4654_SP_test123.CCC) finished, status=2 [Finished with warnings]
12:10:18: AAA (JOB J100_ODS_CONFORMANCE_SMS_CUST_ADDR_TLPHN_4654_SP_test123.AAA) finished, status=99 [Not running]
12:10:19: Exception raised: @AAA, Unhandled abort encountered in job J100_ODS_CONFORMANCE_SMS_CUST_ADDR_TLPHN_4654_SP_test123.AAA
12:10:22: EEE (JOB J100_ODS_CONFORMANCE_SMS_CUST_ADDR_TLPHN_4654_SP_test123.EEE) finished, status=2 [Finished with warnings]
12:10:23: DDD (JOB J100_ODS_CONFORMANCE_SMS_CUST_ADDR_TLPHN_4654_SP_test123.DDD) finished, status=2 [Finished with warnings]
12:10:24: BBB (JOB J100_ODS_CONFORMANCE_SMS_CUST_ADDR_TLPHN_4654_SP_test123.BBB) finished, status=2 [Finished with warnings]
12:10:24: Sequence failed (restartable)
Thank You
Error calling DSRunJob(SEQX_ROUTINE_SAVE_JOB_INFO.J040_CIMS_MPI_SDS_PHYSICIANS_ODS_O_CUST_ID_test.CCC_sAUDIT_SK), code=-2 [Job is not in the right state (compiled and not running)]
To test the parallel invocation of a multi-instance job,I have created a test Job Sequencer which calls a multi instance job with five different invocations. Some times job is completing successfully where as sometimes the job is failing with one of the INVOCATION CALL is failing with a job status 99.
Do we need to set something at the PROJECT level to support multi instance jobs.Please share if you have faced this issue eariler.
SEQX_PARALLEL_AUDIT_test321..JobControl (@Coordinator): Summary of sequence run
12:06:43: Sequence started (checkpointing on)
12:06:43: EEE (JOB J100_ODS_CONFORMANCE_SMS_CUST_ADDR_TLPHN_4654_SP_test123.EEE) started
12:06:45: DDD (JOB J100_ODS_CONFORMANCE_SMS_CUST_ADDR_TLPHN_4654_SP_test123.DDD) started
12:06:48: CCC (JOB J100_ODS_CONFORMANCE_SMS_CUST_ADDR_TLPHN_4654_SP_test123.CCC) started
12:06:50: BBB (JOB J100_ODS_CONFORMANCE_SMS_CUST_ADDR_TLPHN_4654_SP_test123.BBB) started
12:06:52: AAA (JOB J100_ODS_CONFORMANCE_SMS_CUST_ADDR_TLPHN_4654_SP_test123.AAA) started
12:10:17: CCC (JOB J100_ODS_CONFORMANCE_SMS_CUST_ADDR_TLPHN_4654_SP_test123.CCC) finished, status=2 [Finished with warnings]
12:10:18: AAA (JOB J100_ODS_CONFORMANCE_SMS_CUST_ADDR_TLPHN_4654_SP_test123.AAA) finished, status=99 [Not running]
12:10:19: Exception raised: @AAA, Unhandled abort encountered in job J100_ODS_CONFORMANCE_SMS_CUST_ADDR_TLPHN_4654_SP_test123.AAA
12:10:22: EEE (JOB J100_ODS_CONFORMANCE_SMS_CUST_ADDR_TLPHN_4654_SP_test123.EEE) finished, status=2 [Finished with warnings]
12:10:23: DDD (JOB J100_ODS_CONFORMANCE_SMS_CUST_ADDR_TLPHN_4654_SP_test123.DDD) finished, status=2 [Finished with warnings]
12:10:24: BBB (JOB J100_ODS_CONFORMANCE_SMS_CUST_ADDR_TLPHN_4654_SP_test123.BBB) finished, status=2 [Finished with warnings]
12:10:24: Sequence failed (restartable)
Thank You