DSXchange

Hi,

I have a sequencer (Load_GSN_DATA) which has the following calls in a loop (Start Value =1 , End Value = 1000 and Incrementer = 1).

Start Loop

Call Sequencer Seq_Validate (Job Activity Stage)
On Success of Seq_Validate (Condition handled at trigger)

Call Sequencer Seq_GGSN_Data (Job Activity Stage)
Call Sequencer Seq_SGSN_Data (Job Activity Stage)

Wait for both Sequencer to finish (Sequencer Stage)

After completion of Both Sequencer

Call Sequencer Seq_Load_Both
End Loop



The Sequencer went well till 256 iterations, While on 257 it got aborted during the state Wait for both sequencer to finish. i.e. It called the sequencers Seq_GGSN_Data and Seq_SGSN_Data and Seq_GGSN_Data was completed and Seq_SGSN_Data was running. The main sequencer raised an abort as a warning and ended. Whereas during the raise of abort the sequencer Seq_GGSN_Data was running and it completed after the abort. Abort message is :- Attempting to Cleanup abort raised in stage Load_GSN_DATA.JobControl.

Please help me in resolving this.

Regards,
O.A.C.

In Director, reset any job sequence that has aborted.

Tell us if any "from previous run..." message was logged.

And, by the way, a Sequencer is an activity that you can use in a Job Sequence. Please use correct terminology; exactitude aids precise communication.

Hi,

I am sorry for the Please remove the word "Stage" from start loop to end loop.

The sequencer ran sucessfully on 08, 09th January whereas it started giving problem from 10th January onwards onwards. i.e. the sequencer got aborted on 10th & 11th January. There is no log for "From Previous Run ........" for 10th January. Find the below "From Previous Run..." log for 11th January. Let me know if you need any other info. For both times we reset the job and it started running.

Log from Data Stage.

From previous run
DataStage Job 270 Phantom 22313
[16353] Done : DSD.RUN Load_GGSN. 0/0/1/0/0
[16229] Done : DSD.RUN Load_SGSN. 0/0/1/0/0
[7249] Done : DSD.RUN Load_SGSN. 0/0/1/0/0
[7378] Done : DSD.RUN Load_GGSN. 0/0/1/0/0
[22688] Done : DSD.RUN Load_SGSN. 0/0/1/0/0
[22770] Done : DSD.RUN Load_GGSN. 0/0/1/0/0
[27780] Done : DSD.RUN Load_GGSN. 0/0/1/0/0
[27740] Done : DSD.RUN Load_SGSN. 0/0/1/0/0
[479] Done : DSD.RUN Load_GGSN. 0/0/1/0/0
[410] Done : DSD.RUN Load_SGSN. 0/0/1/0/0
[2783] Done : DSD.RUN Load_GGSN. 0/0/1/0/0
[2746] Done : DSD.RUN Load_SGSN. 0/0/1/0/0
[5225] Done : DSD.RUN Load_GGSN. 0/0/1/0/0
[5177] Done : DSD.RUN Load_SGSN. 0/0/1/0/0
[7917] Done : DSD.RUN Load_GGSN. 0/0/1/0/0
[7869] Done : DSD.RUN Load_SGSN. 0/0/1/0/0
[10844] Done : DSD.RUN Load_GGSN. 0/0/1/0/0
[10770] Done : DSD.RUN Load_SGSN. 0/0/1/0/0
[14066] Done : DSD.RUN Load_GGSN. 0/0/1/0/0
[14009] Done : DSD.RUN Load_SGSN. 0/0/1/0/0
[16627] Done : DSD.RUN Load_GGSN. 0/0/1/0/0
[16596] Done : DSD.RUN Load_SGSN. 0/0/1/0/0
[19202] Done : DSD.RUN Load_GGSN. 0/0/1/0/0
[19167] Done : DSD.RUN Load_SGSN. 0/0/1/0/0
[22160] Done : DSD.RUN Load_GGSN. 0/0/1/0/0
[22072] Done : DSD.RUN Load_SGSN. 0/0/1/0/0
[25796] Done : DSD.RUN Load_GGSN. 0/0/1/0/0
[25737] Done : DSD.RUN Load_SGSN. 0/0/1/0/0
[28846] Done : DSD.RUN Load_GGSN. 0/0/1/0/0
[28800] Done : DSD.RUN Load_SGSN. 0/0/1/0/0
[1872] Done : DSD.RUN Load_GGSN. 0/0/1/0/0
[1761] Done : DSD.RUN Load_SGSN. 0/0/1/0/0
[5114] Done : DSD.RUN Load_GGSN. 0/0/1/0/0
[5063] Done : DSD.RUN Load_SGSN. 0/0/1/0/0
[8525] Done : DSD.RUN Load_GGSN. 0/0/1/0/0
[8457] Done : DSD.RUN Load_SGSN. 0/0/1/0/0
[12305] Done : DSD.RUN Load_GGSN. 0/0/1/0/0
[12213] Done : DSD.RUN Load_SGSN. 0/0/1/0/0
[15892] Done : DSD.RUN Load_GGSN. 0/0/1/0/0
[15803] Done : DSD.RUN Load_SGSN. 0/0/1/0/0
[18786] Done : DSD.RUN Load_GGSN. 0/0/1/0/0
[18719] Done : DSD.RUN Load_SGSN. 0/0/1/0/0
[21518] Done : DSD.RUN Load_GGSN. 0/0/1/0/0
[21471] Done : DSD.RUN Load_SGSN. 0/0/1/0/0
[24218] Done : DSD.RUN Load_GGSN. 0/0/1/0/0
[24165] Done : DSD.RUN Load_SGSN. 0/0/1/0/0
[11480] Done : DSD.RUN Load_GGSN. 0/0/1/0/0
[11380] Done : DSD.RUN Load_SGSN. 0/0/1/0/0
[14317] Done : DSD.RUN Load_SGSN. 0/0/1/0/0
[14464] Done : DSD.RUN Load_GGSN. 0/0/1/0/0
[4682] Done : DSD.RUN Load_GGSN. 0/0/1/0/0
[4664] Done : DSD.RUN Load_SGSN. 0/0/1/0/0
[6167] Done : DSD.RUN Load_GGSN. 0/0/1/0/0
[6135] Done : DSD.RUN Load_SGSN. 0/0/1/0/0
[8308] Done : DSD.RUN Load_GGSN. 0/0/1/0/0
[8265] Done : DSD.RUN Load_SGSN. 0/0/1/0/0
[10088] Done : DSD.RUN Load_GGSN. 0/0/1/0/0
[10072] Done : DSD.RUN Load_SGSN. 0/0/1/0/0
[11364] Done : DSD.RUN Load_GGSN. 0/0/1/0/0
[11343] Done : DSD.RUN Load_SGSN. 0/0/1/0/0
[12788] Done : DSD.RUN Load_GGSN. 0/0/1/0/0
[12768] Done : DSD.RUN Load_SGSN. 0/0/1/0/0
[14373] Done : DSD.RUN Load_GGSN. 0/0/1/0/0
[14334] Done : DSD.RUN Load_SGSN. 0/0/1/0/0
[15810] Done : DSD.RUN Load_GGSN. 0/0/1/0/0
[15741] Done : DSD.RUN Load_SGSN. 0/0/1/0/0
[17338] Done : DSD.RUN Load_GGSN. 0/0/1/0/0
[17311] Done : DSD.RUN Load_SGSN. 0/0/1/0/0
[18809] Done : DSD.RUN Load_GGSN. 0/0/1/0/0
[18786] Done : DSD.RUN Load_SGSN. 0/0/1/0/0
[20288] Done : DSD.RUN Load_GGSN. 0/0/1/0/0
[20239] Done : DSD.RUN Load_SGSN. 0/0/1/0/0
[21659] Done : DSD.RUN Load_GGSN. 0/0/1/0/0
[21616] Done : DSD.RUN Load_SGSN. 0/0/1/0/0
[22947] Done : DSD.RUN Load_GGSN. 0/0/1/0/0
[22932] Done : DSD.RUN Load_SGSN. 0/0/1/0/0
[24472] Done : DSD.RUN Load_GGSN. 0/0/1/0/0
[24437] Done : DSD.RUN Load_SGSN. 0/0/1/0/0
[26047] Done : DSD.RUN Load_GGSN. 0/0/1/0/0
[26010] Done : DSD.RUN Load_SGSN. 0/0/1/0/0
[27959] Done : DSD.RUN Load_GGSN. 0/0/1/0/0
[27902] Done : DSD.RUN Load_SGSN. 0/0/1/0/0
[307] Done : DSD.RUN Load_GGSN. 0/0/1/0/0
[266] Done : DSD.RUN Load_SGSN. 0/0/1/0/0
[2571] Done : DSD.RUN Load_GGSN. 0/0/1/0/0
[2439] Done : DSD.RUN Load_SGSN. 0/0/1/0/0
[4649] Done : DSD.RUN Load_GGSN. 0/0/1/0/0
[4613] Done : DSD.RUN Load_SGSN. 0/0/1/0/0
[6993] Done : DSD.RUN Load_GGSN. 0/0/1/0/0
[1139] Done : DSD.RUN Load_SGSN. 0/0/1/0/0
[6946] Done : DSD.RUN Load_SGSN. 0/0/1/0/0
[28682] Done : DSD.RUN Load_SGSN. 0/0/1/0/0
[1285] Done : DSD.RUN Load_GGSN. 0/0/1/0/0
[24563] Done : DSD.RUN Load_GGSN. 0/0/1/0/0
[28756] Done : DSD.RUN Load_GGSN. 0/0/1/0/0
[24517] Done : DSD.RUN Load_SGSN. 0/0/1/0/0
[20465] Done : DSD.RUN Load_SGSN. 0/0/1/0/0
[20542] Done : DSD.RUN Load_GGSN. 0/0/1/0/0
[20867] Done : DSD.RUN Load_SGSN. 0/0/1/0/0
[16412] Done : DSD.RUN Load_GGSN. 0/0/1/0/0
[20923] Done : DSD.RUN Load_GGSN. 0/0/1/0/0
[16357] Done : DSD.RUN Load_SGSN. 0/0/1/0/0
[19033] Done : DSD.RUN Load_GGSN. 0/0/1/0/0
[18970] Done : DSD.RUN Load_SGSN. 0/0/1/0/0
[21658] Done : DSD.RUN Load_GGSN. 0/0/1/0/0
[21569] Done : DSD.RUN Load_SGSN. 0/0/1/0/0
[23754] Done : DSD.RUN Load_GGSN. 0/0/1/0/0
[23709] Done : DSD.RUN Load_SGSN. 0/0/1/0/0
[25902] Done : DSD.RUN Load_GGSN. 0/0/1/0/0
[25861] Done : DSD.RUN Load_SGSN. 0/0/1/0/0
[28023] Done : DSD.RUN Load_GGSN. 0/0/1/0/0
[27981] Done : DSD.RUN Load_SGSN. 0/0/1/0/0
[713] Done : DSD.RUN Load_GGSN. 0/0/1/0/0
[671] Done : DSD.RUN Load_SGSN. 0/0/1/0/0
[3574] Done : DSD.RUN Load_GGSN. 0/0/1/0/0
[3507] Done : DSD.RUN Load_SGSN. 0/0/1/0/0
[6143] Done : DSD.RUN Load_GGSN. 0/0/1/0/0
[6082] Done : DSD.RUN Load_SGSN. 0/0/1/0/0
[8695] Done : DSD.RUN Load_GGSN. 0/0/1/0/0
[8627] Done : DSD.RUN Load_SGSN. 0/0/1/0/0
[11241] Done : DSD.RUN Load_GGSN. 0/0/1/0/0
[11169] Done : DSD.RUN Load_SGSN. 0/0/1/0/0
[13948] Done : DSD.RUN Load_GGSN. 0/0/1/0/0
[13897] Done : DSD.RUN Load_SGSN. 0/0/1/0/0
[16667] Done : DSD.RUN Load_GGSN. 0/0/1/0/0
[16615] Done : DSD.RUN Load_SGSN. 0/0/1/0/0
[19308] Done : DSD.RUN Load_GGSN. 0/0/1/0/0
[19234] Done : DSD.RUN Load_SGSN. 0/0/1/0/0
[6027] Done : DSD.RUN Load_GGSN. 0/0/1/0/0
[5900] Done : DSD.RUN Load_SGSN. 0/0/1/0/0
[19682] Done : DSD.RUN Load_SGSN. 0/0/1/0/0
[19737] Done : DSD.RUN Load_GGSN. 0/0/1/0/0
[19636] Done : DSD.RUN Load_GGSN. 0/0/1/0/0
[22154] Done : DSD.RUN Load_GGSN. 0/0/1/0/0
[19579] Done : DSD.RUN Load_SGSN. 0/0/1/0/0
[22128] Done : DSD.RUN Load_SGSN. 0/0/1/0/0
[24747] Done : DSD.RUN Load_GGSN. 0/0/1/0/0
[24665] Done : DSD.RUN Load_SGSN. 0/0/1/0/0
[28310] Done : DSD.RUN Load_GGSN. 0/0/1/0/0
[28232] Done : DSD.RUN Load_SGSN. 0/0/1/0/0
[1893] Done : DSD.RUN Load_GGSN. 0/0/1/0/0
[1836] Done : DSD.RUN Load_SGSN. 0/0/1/0/0
[5167] Done : DSD.RUN Load_GGSN. 0/0/1/0/0
[5110] Done : DSD.RUN Load_SGSN. 0/0/1/0/0
[8122] Done : DSD.RUN Load_GGSN. 0/0/1/0/0
[7982] Done : DSD.RUN Load_SGSN. 0/0/1/0/0
[11764] Done : DSD.RUN Load_GGSN. 0/0/1/0/0
[11693] Done : DSD.RUN Load_SGSN. 0/0/1/0/0
[14837] Done : DSD.RUN Load_GGSN. 0/0/1/0/0
[14799] Done : DSD.RUN Load_SGSN. 0/0/1/0/0
[17430] Done : DSD.RUN Load_GGSN. 0/0/1/0/0
[17392] Done : DSD.RUN Load_SGSN. 0/0/1/0/0
[19655] Done : DSD.RUN Load_GGSN. 0/0/1/0/0
[19565] Done : DSD.RUN Load_SGSN. 0/0/1/0/0
[22035] Done : DSD.RUN Load_GGSN. 0/0/1/0/0
[22005] Done : DSD.RUN Load_SGSN. 0/0/1/0/0
[24254] Done : DSD.RUN Load_GGSN. 0/0/1/0/0
[24215] Done : DSD.RUN Load_SGSN. 0/0/1/0/0
[26410] Done : DSD.RUN Load_GGSN. 0/0/1/0/0
[26363] Done : DSD.RUN Load_SGSN. 0/0/1/0/0
[28239] Done : DSD.RUN Load_GGSN. 0/0/1/0/0
[28215] Done : DSD.RUN Load_SGSN. 0/0/1/0/0
[29168] Done : DSD.RUN Load_GGSN. 0/0/1/0/0
[29137] Done : DSD.RUN Load_SGSN. 0/0/1/0/0
[256] Done : DSD.RUN Load_GGSN. 0/0/1/0/0
[152] Done : DSD.RUN Load_SGSN. 0/0/1/0/0
[1447] Done : DSD.RUN Load_GGSN. 0/0/1/0/0
[1424] Done : DSD.RUN Load_SGSN. 0/0/1/0/0
[2328] Done : DSD.RUN Load_GGSN. 0/0/1/0/0
[2290] Done : DSD.RUN Load_SGSN. 0/0/1/0/0
[10750] Done : DSD.RUN Load_GGSN. 0/0/1/0/0
[10668] Done : DSD.RUN Load_SGSN. 0/0/1/0/0
[5874] Done : DSD.RUN Load_SGSN. 0/0/1/0/0
[5912] Done : DSD.RUN Load_GGSN. 0/0/1/0/0
[19966] Done : DSD.RUN Load_GGSN. 0/0/1/0/0
[19947] Done : DSD.RUN Load_SGSN. 0/0/1/0/0
[21064] Done : DSD.RUN Load_GGSN. 0/0/1/0/0
[21034] Done : DSD.RUN Load_SGSN. 0/0/1/0/0
[22077] Done : DSD.RUN Load_GGSN. 0/0/1/0/0
[22052] Done : DSD.RUN Load_SGSN. 0/0/1/0/0
[23098] Done : DSD.RUN Load_GGSN. 0/0/1/0/0
[23074] Done : DSD.RUN Load_SGSN. 0/0/1/0/0
[23942] Done : DSD.RUN Load_GGSN. 0/0/1/0/0
[23918] Done : DSD.RUN Load_SGSN. 0/0/1/0/0
[24988] Done : DSD.RUN Load_GGSN. 0/0/1/0/0
[24960] Done : DSD.RUN Load_SGSN. 0/0/1/0/0
[26034] Done : DSD.RUN Load_GGSN. 0/0/1/0/0
[26013] Done : DSD.RUN Load_SGSN. 0/0/1/0/0
[28244] Done : DSD.RUN Load_GGSN. 0/0/1/0/0
[28153] Done : DSD.RUN Load_SGSN. 0/0/1/0/0
[702] Done : DSD.RUN Load_GGSN. 0/0/1/0/0
[656] Done : DSD.RUN Load_SGSN. 0/0/1/0/0
[2948] Done : DSD.RUN Load_GGSN. 0/0/1/0/0
[2882] Done : DSD.RUN Load_SGSN. 0/0/1/0/0
[4412] Done : DSD.RUN Load_GGSN. 0/0/1/0/0
[4377] Done : DSD.RUN Load_SGSN. 0/0/1/0/0
[5801] Done : DSD.RUN Load_GGSN. 0/0/1/0/0
[5752] Done : DSD.RUN Load_SGSN. 0/0/1/0/0
[7338] Done : DSD.RUN Load_GGSN. 0/0/1/0/0
[7296] Done : DSD.RUN Load_SGSN. 0/0/1/0/0
[8952] Done : DSD.RUN Load_GGSN. 0/0/1/0/0
[8925] Done : DSD.RUN Load_SGSN. 0/0/1/0/0
[10500] Done : DSD.RUN Load_GGSN. 0/0/1/0/0
[10472] Done : DSD.RUN Load_SGSN. 0/0/1/0/0
[12050] Done : DSD.RUN Load_GGSN. 0/0/1/0/0
[12011] Done : DSD.RUN Load_SGSN. 0/0/1/0/0
[13474] Done : DSD.RUN Load_GGSN. 0/0/1/0/0
[13451] Done : DSD.RUN Load_SGSN. 0/0/1/0/0
[14997] Done : DSD.RUN Load_GGSN. 0/0/1/0/0
[14976] Done : DSD.RUN Load_SGSN. 0/0/1/0/0
[16417] Done : DSD.RUN Load_GGSN. 0/0/1/0/0
[16359] Done : DSD.RUN Load_SGSN. 0/0/1/0/0
[18365] Done : DSD.RUN Load_GGSN. 0/0/1/0/0
[18311] Done : DSD.RUN Load_SGSN. 0/0/1/0/0
[20938] Done : DSD.RUN Load_GGSN. 0/0/1/0/0
[20903] Done : DSD.RUN Load_SGSN. 0/0/1/0/0
[23596] Done : DSD.RUN Load_GGSN. 0/0/1/0/0
[23557] Done : DSD.RUN Load_SGSN. 0/0/1/0/0
[26136] Done : DSD.RUN Load_GGSN. 0/0/1/0/0
[26108] Done : DSD.RUN Load_SGSN. 0/0/1/0/0
[9490] Done : DSD.RUN Load_GGSN. 0/0/1/0/0
[9396] Done : DSD.RUN Load_SGSN. 0/0/1/0/0
[3821] Done : DSD.RUN Load_SGSN. 0/0/1/0/0
[16079] Done : DSD.RUN Load_GGSN. 0/0/1/0/0
[3956] Done : DSD.RUN Load_GGSN. 0/0/1/0/0
[16022] Done : DSD.RUN Load_SGSN. 0/0/1/0/0
[19550] Done : DSD.RUN Load_GGSN. 0/0/1/0/0
[19524] Done : DSD.RUN Load_SGSN. 0/0/1/0/0
[20950] Done : DSD.RUN Load_GGSN. 0/0/1/0/0
[20921] Done : DSD.RUN Load_SGSN. 0/0/1/0/0
[22023] Done : DSD.RUN Load_GGSN. 0/0/1/0/0
[22005] Done : DSD.RUN Load_SGSN. 0/0/1/0/0
[23058] Done : DSD.RUN Load_GGSN. 0/0/1/0/0
[23037] Done : DSD.RUN Load_SGSN. 0/0/1/0/0
[24840] Done : DSD.RUN Load_GGSN. 0/0/1/0/0
[24813] Done : DSD.RUN Load_SGSN. 0/0/1/0/0
[26589] Done : DSD.RUN Load_GGSN. 0/0/1/0/0
[26571] Done : DSD.RUN Load_SGSN. 0/0/1/0/0
[28482] Done : DSD.RUN Load_GGSN. 0/0/1/0/0
[28446] Done : DSD.RUN Load_SGSN. 0/0/1/0/0
[29913] Done : DSD.RUN Load_GGSN. 0/0/1/0/0
[29890] Done : DSD.RUN Load_SGSN. 0/0/1/0/0
[1564] Done : DSD.RUN Load_GGSN. 0/0/1/0/0
[1531] Done : DSD.RUN Load_SGSN. 0/0/1/0/0
[2555] Done : DSD.RUN Load_GGSN. 0/0/1/0/0
[2508] Done : DSD.RUN Load_SGSN. 0/0/1/0/0
[3546] Done : DSD.RUN Load_GGSN. 0/0/1/0/0
[3514] Done : DSD.RUN Load_SGSN. 0/0/1/0/0
[4651] Done : DSD.RUN Load_GGSN. 0/0/1/0/0
[4592] Done : DSD.RUN Load_SGSN. 0/0/1/0/0
[5602] Done : DSD.RUN Load_GGSN. 0/0/1/0/0
[5584] Done : DSD.RUN Load_SGSN. 0/0/1/0/0
[6864] Done : DSD.RUN Load_GGSN. 0/0/1/0/0
[6799] Done : DSD.RUN Load_SGSN. 0/0/1/0/0
[7794] Done : DSD.RUN Load_GGSN. 0/0/1/0/0
[7772] Done : DSD.RUN Load_SGSN. 0/0/1/0/0
[8934] Done : DSD.RUN Load_GGSN. 0/0/1/0/0
[8897] Done : DSD.RUN Load_SGSN. 0/0/1/0/0
[9946] Done : DSD.RUN Load_GGSN. 0/0/1/0/0
[9907] Done : DSD.RUN Load_SGSN. 0/0/1/0/0
[11222] Done : DSD.RUN Load_GGSN. 0/0/1/0/0
[11195] Done : DSD.RUN Load_SGSN. 0/0/1/0/0
[12802] Done : DSD.RUN Load_GGSN. 0/0/1/0/0
[12778] Done : DSD.RUN Load_SGSN. 0/0/1/0/0
[14307] Done : DSD.RUN Load_GGSN. 0/0/1/0/0
[14272] Done : DSD.RUN Load_SGSN. 0/0/1/0/0
[20761] Done : DSD.RUN Load_GGSN. 0/0/1/0/0
[20725] Done : DSD.RUN Load_SGSN. 0/0/1/0/0
[20393] Done : DSD.RUN Load_SGSN. 0/0/1/0/0
[20473] Done : DSD.RUN Load_GGSN. 0/0/1/0/0
[5798] Done : DSD.RUN Load_GGSN. 0/0/1/0/0
[5768] Done : DSD.RUN Load_SGSN. 0/0/1/0/0
[6947] Done : DSD.RUN Load_GGSN. 0/0/1/0/0
[7889] Done : DSD.RUN Load_GGSN. 0/0/1/0/0
[6922] Done : DSD.RUN Load_SGSN. 0/0/1/0/0
[7868] Done : DSD.RUN Load_SGSN. 0/0/1/0/0
[9004] Done : DSD.RUN Load_GGSN. 0/0/1/0/0
[8961] Done : DSD.RUN Load_SGSN. 0/0/1/0/0
[10479] Done : DSD.RUN Load_GGSN. 0/0/1/0/0
[10432] Done : DSD.RUN Load_SGSN. 0/0/1/0/0
[12583] Done : DSD.RUN Load_GGSN. 0/0/1/0/0
[12553] Done : DSD.RUN Load_SGSN. 0/0/1/0/0
[14303] Done : DSD.RUN Load_GGSN. 0/0/1/0/0
[14285] Done : DSD.RUN Load_SGSN. 0/0/1/0/0
[15435] Done : DSD.RUN Load_GGSN. 0/0/1/0/0
[15412] Done : DSD.RUN Load_SGSN. 0/0/1/0/0
[17360] Done : DSD.RUN Load_GGSN. 0/0/1/0/0
[17294] Done : DSD.RUN Load_SGSN. 0/0/1/0/0
[19602] Done : DSD.RUN Load_GGSN. 0/0/1/0/0
[19577] Done : DSD.RUN Load_SGSN. 0/0/1/0/0
[22167] Done : DSD.RUN Load_GGSN. 0/0/1/0/0
[22139] Done : DSD.RUN Load_SGSN. 0/0/1/0/0
[23502] Done : DSD.RUN Load_GGSN. 0/0/1/0/0
[23461] Done : DSD.RUN Load_SGSN. 0/0/1/0/0
[25704] Done : DSD.RUN Load_GGSN. 0/0/1/0/0
[25671] Done : DSD.RUN Load_SGSN. 0/0/1/0/0
[27831] Done : DSD.RUN Load_GGSN. 0/0/1/0/0
[29907] Done : DSD.RUN Load_GGSN. 0/0/1/0/0
[27790] Done : DSD.RUN Load_SGSN. 0/0/1/0/0
[29881] Done : DSD.RUN Load_SGSN. 0/0/1/0/0
[2626] Done : DSD.RUN Load_GGSN. 0/0/1/0/0
[2554] Done : DSD.RUN Load_SGSN. 0/0/1/0/0
[4679] Done : DSD.RUN Load_GGSN. 0/0/1/0/0
[4563] Done : DSD.RUN Load_SGSN. 0/0/1/0/0
[6453] Done : DSD.RUN Load_GGSN. 0/0/1/0/0
[6378] Done : DSD.RUN Load_SGSN. 0/0/1/0/0
[7950] Done : DSD.RUN Load_GGSN. 0/0/1/0/0
[7916] Done : DSD.RUN Load_SGSN. 0/0/1/0/0
[20559] Done : DSD.RUN Load_GGSN. 0/0/1/0/0
[14124] Done : DSD.RUN Load_SGSN. 0/0/1/0/0
[20491] Done : DSD.RUN Load_SGSN. 0/0/1/0/0
[28213] Done : DSD.RUN Load_GGSN. 0/0/1/0/0
[14175] Done : DSD.RUN Load_GGSN. 0/0/1/0/0
[28187] Done : DSD.RUN Load_SGSN. 0/0/1/0/0
[29722] Done : DSD.RUN Load_GGSN. 0/0/1/0/0
[29695] Done : DSD.RUN Load_SGSN. 0/0/1/0/0
[1342] Done : DSD.RUN Load_GGSN. 0/0/1/0/0
[1293] Done : DSD.RUN Load_SGSN. 0/0/1/0/0
[2295] Done : DSD.RUN Load_GGSN. 0/0/1/0/0
[2258] Done : DSD.RUN Load_SGSN. 0/0/1/0/0
[3419] Done : DSD.RUN Load_GGSN. 0/0/1/0/0
[3401] Done : DSD.RUN Load_SGSN. 0/0/1/0/0
[4644] Done : DSD.RUN Load_GGSN. 0/0/1/0/0
[4613] Done : DSD.RUN Load_SGSN. 0/0/1/0/0
[6015] Done : DSD.RUN Load_GGSN. 0/0/1/0/0
[5983] Done : DSD.RUN Load_SGSN. 0/0/1/0/0
[7364] Done : DSD.RUN Load_GGSN. 0/0/1/0/0
[7340] Done : DSD.RUN Load_SGSN. 0/0/1/0/0
[8637] Done : DSD.RUN Load_GGSN. 0/0/1/0/0
[8602] Done : DSD.RUN Load_SGSN. 0/0/1/0/0
[9978] Done : DSD.RUN Load_GGSN. 0/0/1/0/0
[9955] Done : DSD.RUN Load_SGSN. 0/0/1/0/0
[11944] Done : DSD.RUN Load_GGSN. 0/0/1/0/0
[11888] Done : DSD.RUN Load_SGSN. 0/0/1/0/0
[12888] Done : DSD.RUN Load_GGSN. 0/0/1/0/0
[12862] Done : DSD.RUN Load_SGSN. 0/0/1/0/0
[13811] Done : DSD.RUN Load_GGSN. 0/0/1/0/0
[13786] Done : DSD.RUN Load_SGSN. 0/0/1/0/0
[14660] Done : DSD.RUN Load_GGSN. 0/0/1/0/0
[14635] Done : DSD.RUN Load_SGSN. 0/0/1/0/0
[15549] Done : DSD.RUN Load_GGSN. 0/0/1/0/0
[15472] Done : DSD.RUN Load_SGSN. 0/0/1/0/0
[16418] Done : DSD.RUN Load_GGSN. 0/0/1/0/0
[16380] Done : DSD.RUN Load_SGSN. 0/0/1/0/0
[17717] Done : DSD.RUN Load_GGSN. 0/0/1/0/0
[17691] Done : DSD.RUN Load_SGSN. 0/0/1/0/0
[19203] Done : DSD.RUN Load_GGSN. 0/0/1/0/0
[27774] Done : DSD.RUN Load_GGSN. 0/0/1/0/0
[19181] Done : DSD.RUN Load_SGSN. 0/0/1/0/0
[27707] Done : DSD.RUN Load_SGSN. 0/0/1/0/0
[17904] Done : DSD.RUN Load_SGSN. 0/0/1/0/0
[18002] Done : DSD.RUN Load_GGSN. 0/0/1/0/0
[832] Done : DSD.RUN Load_GGSN. 0/0/1/0/0
[785] Done : DSD.RUN Load_SGSN. 0/0/1/0/0
[2343] Done : DSD.RUN Load_GGSN. 0/0/1/0/0
[2316] Done : DSD.RUN Load_SGSN. 0/0/1/0/0
[3725] Done : DSD.RUN Load_GGSN. 0/0/1/0/0
[3619] Done : DSD.RUN Load_SGSN. 0/0/1/0/0
[7195] Done : DSD.RUN Load_GGSN. 0/0/1/0/0
[7133] Done : DSD.RUN Load_SGSN. 0/0/1/0/0
[10798] Done : DSD.RUN Load_GGSN. 0/0/1/0/0
[10732] Done : DSD.RUN Load_SGSN. 0/0/1/0/0
[13187] Done : DSD.RUN Load_GGSN. 0/0/1/0/0
[13104] Done : DSD.RUN Load_SGSN. 0/0/1/0/0
[14643] Done : DSD.RUN Load_GGSN. 0/0/1/0/0
[14613] Done : DSD.RUN Load_SGSN. 0/0/1/0/0
[15784] Done : DSD.RUN Load_GGSN. 0/0/1/0/0
[15764] Done : DSD.RUN Load_SGSN. 0/0/1/0/0
[16729] Done : DSD.RUN Load_GGSN. 0/0/1/0/0
[16710] Done : DSD.RUN Load_SGSN. 0/0/1/0/0
[17900] Done : DSD.RUN Load_GGSN. 0/0/1/0/0
[17870] Done : DSD.RUN Load_SGSN. 0/0/1/0/0
[18744] Done : DSD.RUN Load_GGSN. 0/0/1/0/0
[18722] Done : DSD.RUN Load_SGSN. 0/0/1/0/0
[20738] Done : DSD.RUN Load_GGSN. 0/0/1/0/0
[20636] Done : DSD.RUN Load_SGSN. 0/0/1/0/0
[22550] Done : DSD.RUN Load_GGSN. 0/0/1/0/0
[22516] Done : DSD.RUN Load_SGSN. 0/0/1/0/0
[24227] Done : DSD.RUN Load_GGSN. 0/0/1/0/0
[25346] Done : DSD.RUN Load_GGSN. 0/0/1/0/0
[24202] Done : DSD.RUN Load_SGSN. 0/0/1/0/0
[25326] Done : DSD.RUN Load_SGSN. 0/0/1/0/0
[26525] Done : DSD.RUN Load_GGSN. 0/0/1/0/0
[26449] Done : DSD.RUN Load_SGSN. 0/0/1/0/0
[27738] Done : DSD.RUN Load_GGSN. 0/0/1/0/0
[27717] Done : DSD.RUN Load_SGSN. 0/0/1/0/0
[28837] Done : DSD.RUN Load_GGSN. 0/0/1/0/0
[28812] Done : DSD.RUN Load_SGSN. 0/0/1/0/0
[7553] Done : DSD.RUN Load_GGSN. 0/0/1/0/0
[7461] Done : DSD.RUN Load_SGSN. 0/0/1/0/0
[2188] Done : DSD.RUN Load_SGSN. 0/0/1/0/0
[2261] Done : DSD.RUN Load_GGSN. 0/0/1/0/0
[16973] Done : DSD.RUN Load_GGSN. 0/0/1/0/0
[16933] Done : DSD.RUN Load_SGSN. 0/0/1/0/0
[19665] Done : DSD.RUN Load_GGSN. 0/0/1/0/0
[19615] Done : DSD.RUN Load_SGSN. 0/0/1/0/0
[21604] Done : DSD.RUN Load_GGSN. 0/0/1/0/0
[21552] Done : DSD.RUN Load_SGSN. 0/0/1/0/0
[23360] Done : DSD.RUN Load_GGSN. 0/0/1/0/0
[23325] Done : DSD.RUN Load_SGSN. 0/0/1/0/0
[24613] Done : DSD.RUN Load_GGSN. 0/0/1/0/0
[24589] Done : DSD.RUN Load_SGSN. 0/0/1/0/0
[26127] Done : DSD.RUN Load_GGSN. 0/0/1/0/0
[26070] Done : DSD.RUN Load_SGSN. 0/0/1/0/0
[27657] Done : DSD.RUN Load_GGSN. 0/0/1/0/0
[27622] Done : DSD.RUN Load_SGSN. 0/0/1/0/0
[28871] Done : DSD.RUN Load_GGSN. 0/0/1/0/0
[28847] Done : DSD.RUN Load_SGSN. 0/0/1/0/0
[29889] Done : DSD.RUN Load_GGSN. 0/0/1/0/0
[29849] Done : DSD.RUN Load_SGSN. 0/0/1/0/0
[1156] Done : DSD.RUN Load_GGSN. 0/0/1/0/0
[1136] Done : DSD.RUN Load_SGSN. 0/0/1/0/0
[2866] Done : DSD.RUN Load_GGSN. 0/0/1/0/0
[2835] Done : DSD.RUN Load_SGSN. 0/0/1/0/0
[5041] Done : DSD.RUN Load_GGSN. 0/0/1/0/0
[4999] Done : DSD.RUN Load_SGSN. 0/0/1/0/0
[6678] Done : DSD.RUN Load_GGSN. 0/0/1/0/0
[6656] Done : DSD.RUN Load_SGSN. 0/0/1/0/0
[8015] Done : DSD.RUN Load_GGSN. 0/0/1/0/0
[7974] Done : DSD.RUN Load_SGSN. 0/0/1/0/0
[9193] Done : DSD.RUN Load_GGSN. 0/0/1/0/0
[10409] Done : DSD.RUN Load_GGSN. 0/0/1/0/0
[9177] Done : DSD.RUN Load_SGSN. 0/0/1/0/0
[10390] Done : DSD.RUN Load_SGSN. 0/0/1/0/0
[11642] Done : DSD.RUN Load_GGSN. 0/0/1/0/0
[11601] Done : DSD.RUN Load_SGSN. 0/0/1/0/0
[13143] Done : DSD.RUN Load_GGSN. 0/0/1/0/0
[13120] Done : DSD.RUN Load_SGSN. 0/0/1/0/0
[14653] Done : DSD.RUN Load_GGSN. 0/0/1/0/0
[14632] Done : DSD.RUN Load_SGSN. 0/0/1/0/0
[17020] Done : DSD.RUN Load_GGSN. 0/0/1/0/0
[16972] Done : DSD.RUN Load_SGSN. 0/0/1/0/0
[26368] Done : DSD.RUN Load_GGSN. 0/0/1/0/0
[23076] Done : DSD.RUN Load_SGSN. 0/0/1/0/0
[26280] Done : DSD.RUN Load_SGSN. 0/0/1/0/0
[23156] Done : DSD.RUN Load_GGSN. 0/0/1/0/0
[8568] Done : DSD.RUN Load_GGSN. 0/0/1/0/0
[8547] Done : DSD.RUN Load_SGSN. 0/0/1/0/0
[9499] Done : DSD.RUN Load_GGSN. 0/0/1/0/0
[9478] Done : DSD.RUN Load_SGSN. 0/0/1/0/0
[10715] Done : DSD.RUN Load_GGSN. 0/0/1/0/0
[10690] Done : DSD.RUN Load_SGSN. 0/0/1/0/0
[12833] Done : DSD.RUN Load_GGSN. 0/0/1/0/0
[14923] Done : DSD.RUN Load_GGSN. 0/0/1/0/0
[12772] Done : DSD.RUN Load_SGSN. 0/0/1/0/0
[14900] Done : DSD.RUN Load_SGSN. 0/0/1/0/0
[16271] Done : DSD.RUN Load_GGSN. 0/0/1/0/0
[16248] Done : DSD.RUN Load_SGSN. 0/0/1/0/0
[17643] Done : DSD.RUN Load_GGSN. 0/0/1/0/0
[17576] Done : DSD.RUN Load_SGSN. 0/0/1/0/0
[19041] Done : DSD.RUN Load_GGSN. 0/0/1/0/0
[19007] Done : DSD.RUN Load_SGSN. 0/0/1/0/0
[20619] Done : DSD.RUN Load_GGSN. 0/0/1/0/0
[20598] Done : DSD.RUN Load_SGSN. 0/0/1/0/0
[22048] Done : DSD.RUN Load_GGSN. 0/0/1/0/0
[22018] Done : DSD.RUN Load_SGSN. 0/0/1/0/0
[23391] Done : DSD.RUN Load_GGSN. 0/0/1/0/0
[23371] Done : DSD.RUN Load_SGSN. 0/0/1/0/0
[25408] Done : DSD.RUN Load_GGSN. 0/0/1/0/0
[25353] Done : DSD.RUN Load_SGSN. 0/0/1/0/0
[28006] Done : DSD.RUN Load_GGSN. 0/0/1/0/0
[27960] Done : DSD.RUN Load_SGSN. 0/0/1/0/0
[29766] Done : DSD.RUN Load_GGSN. 0/0/1/0/0
[29730] Done : DSD.RUN Load_SGSN. 0/0/1/0/0
[1875] Done : DSD.RUN Load_GGSN. 0/0/1/0/0
[1811] Done : DSD.RUN Load_SGSN. 0/0/1/0/0
[3826] Done : DSD.RUN Load_GGSN. 0/0/1/0/0
[3708] Done : DSD.RUN Load_SGSN. 0/0/1/0/0
[5305] Done : DSD.RUN Load_GGSN. 0/0/1/0/0
[5278] Done : DSD.RUN Load_SGSN. 0/0/1/0/0
[6899] Done : DSD.RUN Load_GGSN. 0/0/1/0/0
[6837] Done : DSD.RUN Load_SGSN. 0/0/1/0/0
[14967] Done : DSD.RUN Load_GGSN. 0/0/1/0/0
[14923] Done : DSD.RUN Load_SGSN. 0/0/1/0/0
[9396] Done : DSD.RUN Load_SGSN. 0/0/1/0/0
[25728] Done : DSD.RUN Load_GGSN. 0/0/1/0/0
[9458] Done : DSD.RUN Load_GGSN. 0/0/1/0/0
[25695] Done : DSD.RUN Load_SGSN. 0/0/1/0/0
[26782] Done : DSD.RUN Load_GGSN. 0/0/1/0/0
[26757] Done : DSD.RUN Load_SGSN. 0/0/1/0/0
[27961] Done : DSD.RUN Load_GGSN. 0/0/1/0/0
[27941] Done : DSD.RUN Load_SGSN. 0/0/1/0/0
[29677] Done : DSD.RUN Load_GGSN. 0/0/1/0/0
[29611] Done : DSD.RUN Load_SGSN. 0/0/1/0/0
[2906] Done : DSD.RUN Load_GGSN. 0/0/1/0/0
[2874] Done : DSD.RUN Load_SGSN. 0/0/1/0/0
[5604] Done : DSD.RUN Load_GGSN. 0/0/1/0/0
[5581] Done : DSD.RUN Load_SGSN. 0/0/1/0/0
[7146] Done : DSD.RUN Load_GGSN. 0/0/1/0/0
[9108] Done : DSD.RUN Load_GGSN. 0/0/1/0/0
[7065] Done : DSD.RUN Load_SGSN. 0/0/1/0/0
[9102] Done : DSD.RUN Load_SGSN. 0/0/1/0/0
[10669] Done : DSD.RUN Load_GGSN. 0/0/1/0/0
[10645] Done : DSD.RUN Load_SGSN. 0/0/1/0/0
[11754] Done : DSD.RUN Load_GGSN. 0/0/1/0/0
[11738] Done : DSD.RUN Load_SGSN. 0/0/1/0/0
[12878] Done : DSD.RUN Load_GGSN. 0/0/1/0/0
[12857] Done : DSD.RUN Load_SGSN. 0/0/1/0/0
[13814] Done : DSD.RUN Load_GGSN. 0/0/1/0/0


Regards,
O.A.C.

Each "Done" message from DSD.RUN indicates a run of a server job. In your case everything appears to have worked (there are no warning messages). Your loop runs job Load_GGSN then runs job Load_SGSN.

Does your job design trap exceptions (via an Exception Handler) or non-success triggers from the controlled jobs? If not, you are not propagating the information that you require to solve the problem, and will need to inspect the Load_GGSN and Load_SGSN job logs as well.

Suggestion: create a trigger from each job activity to a routine activity. In the routine activity call UtilityWarningToLog, and specify a message that indicates which job has generated warnings. You can use an Otherwise trigger if you already have OK triggers, otherwise use a Custom trigger expression of the form JobActivity.$JobStatus <> DSJS.RUNOK
(Here $JobStatus is an activity variable and DSJS.RUNOK is a DataStage constant.)

Isn't 256 an awfully coincidental number? 256 good, 257 bad? Silly, I know, but any chance that's the maximum number of iterations it can handle?

I don't think there's a documented limit. What does Help say about the StartLoop activity properties?

Nothing specific, but the example for the Loop stage shows one that goes through 1440 iterations, so... "never mind".

Hi,

I checked in the help, it is not problem with looping counter. It is the problem with Sequence Activity. Is there any time limits for waiting of the job.

Please find the time stamp of the execution

For Iteration 257,

11:28:04 Load_GGSN Called from Sequencer
11:28:04 Load_SGSN Called from Sequencer
11:28:06 Load_GGSN Started
11:28:06 Load_SGSN Started
11:28:24 Load_SGSN Finished
11:28:30 Abort Raised
11:29:10 Load_GGSN Finished

Both the Sequencer Finished Successfully (with OK) status.

Regards,
O.A.C.

Hi,

I checked in the help, it is not problem with looping counter. It is the problem with Sequence Activity. Is there any time limits for waiting of the job.

Please find the time stamp of the execution

For Iteration 257,

11:28:04 Load_GGSN Called from Sequencer
11:28:04 Load_SGSN Called from Sequencer
11:28:06 Load_GGSN Started
11:28:06 Load_SGSN Started
11:28:24 Load_SGSN Finished
11:28:30 Abort Raised
11:29:10 Load_GGSN Finished

Both the Sequencer Finished Successfully (with OK) status.

Regards,
O.A.C.

We had the same problem on my current project and raised a case with Ascential. They supplied as with a patch - a new DLL (vmdsjsgn.dll) which need to be installed on the client and the jobs then had to be recompiled. Seems to have fixed the problem!

Hi,

Thanks for your reply. Today the same sequence went well, the only difference is the total number of iterations completed is 76. I guess you are correct. Can you let us know when did you face the problem as well when you got the patch (Roughly Month & Year might help us).

Regards,
O.A.C.

Part of the case description was as follows:

The Loop function fails at the 257 iteration if the loop includes a Sequencer stage. Control job fails with "runtime stack overflow" error

This occured around July 2005.

Aha!

Hi,

We didn't get that error message, Please find the below log.

Attempting to Cleanup after ABORT raised in stage Load_GSN_data..JobControl

Which we received, Please let us know if you received the same. Hope you can help me. Do i need to raise this to Support Group?

Regards,
O.A.C.

I would suggest that there are enough similarities to suggest that this is the same problem. Contact Ascential support!