| Author |
Message
|
| maxis |
 Posted: Tue Sep 10, 2002 9:49 am Post subject: execution group Abends ? |
 |
|
Centurion
Joined: 25 Jun 2002
Posts: 144
|
hello,
We are accessing databases resultset is ,
, then using PASSTHRU sending the propagating the X number of records. This messageflow is placed in separate Execution group, A.
So far everything is fine, When we tested with the real data. Execution Group is A is STOPPING & RESTARTING by itself. And its generating an abend file in /var/mqsi/errors.
Opened PMR with IBM .. still no use ..
has anyone ever experience this kind of problem ?
hope to hear something 
M |
|
| Back to top |
|
 |
| kirani |
| Posted: Tue Sep 10, 2002 4:52 pm Post subject: |
|
|
Jedi Knight
Joined: 05 Sep 2001
Posts: 3779
Location: Torrance, CA, USA
|
Do you have any "external loop" in your message flow to process each record in the resultset?
_________________
Kiran
IBM Cert. Solution Designer & System Administrator - WBIMB V5
IBM Cert. Solutions Expert - WMQI
IBM Cert. Specialist - WMQI, MQSeries
IBM Cert. Developer - MQSeries
|
|
| Back to top |
|
|
| maxis |
| Posted: Wed Sep 11, 2002 11:35 am Post subject: |
|
|
Centurion
Joined: 25 Jun 2002
Posts: 144
|
thanx kiran for responding.
Yes I've external loop, in every turn am sending out one recordset & then assigning it to null.
| Code: |
set i=0 ;
set j = cardinality(Environment.Variables.RecordSet.data[])
set m = 1 ;
while (i < j) do
// set appropriate header ...
set OutputRoot.MRM.ABC[i]."fieldName" = Environment.Variables.ResultSet.Record[1]."fieldName" ;
if ( m = 10) then
propagate ;
set m = 1 ;
else
m = m + 1
end if
set Environment.Variables.ResultSet.Record[1]."fieldName" = NULL ;
set j = j + 1 ;
end while ;
//.... |
thanks
M |
|
| Back to top |
|
|
| cloud9 |
| Posted: Fri Jul 18, 2003 8:25 am Post subject: Execution Group abends -- which flow caused it?? |
|
|
Novice
Joined: 18 Jul 2003
Posts: 13
Location: Jacksonville, FL
|
| Sorry to jump on your thread, but I have the same issue with an execution group frequently abending. Is there a way to find out which message flow is causing it to abend ??? I could not find any reference to a messsage flow in the error log: /var/adm/syslog.user, or in the abend error files .... /var/mqsi/errors. Surely, there must be a way! |
|
| Back to top |
|
|
| maxis |
| Posted: Fri Jul 18, 2003 10:57 am Post subject: |
|
|
Centurion
Joined: 25 Jun 2002
Posts: 144
|
Almost forgot that i've started the thread .... 
anyways .. i couldnt get into the granular of message flow ...
anyone has idea or trick to find out ...
thanks
M |
|
| Back to top |
|
|
| WBI_user |
| Posted: Mon Jul 21, 2003 7:51 pm Post subject: |
|
|
Partisan
Joined: 07 Aug 2001
Posts: 386
|
| If you examine your dead letter queue, from my past experience, the message that caused the abend were thrown to the queue by MQSI unless the message is non-persistent. |
|
| Back to top |
|
|
|
|
