Author |
Message
|
dixit27 |
Posted: Sat Sep 15, 2012 1:30 am Post subject: Execution group not displaying in toolkit |
|
|
Newbie
Joined: 15 Sep 2012 Posts: 2
|
Hi,
I am facing a very strange issue.For a particular broker i could see the execution group process running in the ssh but when i check in the toolkit i could able to view only default execution group.
Never seen this kind of issue before..
Any lights or suggestions on this ?
Thanks
Hemanth |
|
Back to top |
|
 |
Vitor |
Posted: Sat Sep 15, 2012 5:42 am Post subject: |
|
|
 Grand High Poobah
Joined: 11 Nov 2005 Posts: 26093 Location: Texas, USA
|
What version of broker?
Do you have rights against the "invisible" excecution group? _________________ Honesty is the best policy.
Insanity is the best defence. |
|
Back to top |
|
 |
dixit27 |
Posted: Sat Sep 15, 2012 6:21 am Post subject: Exec group not displaying in toolkit |
|
|
Newbie
Joined: 15 Sep 2012 Posts: 2
|
Broker version : 6.0
Yes having rights to the exec group..Not sure why it's not displaying in toolkit.
Process shows all exec groups running in SSH.
Also checked with the database team they told us that the listeners and broker database up and running fine. |
|
Back to top |
|
 |
fjb_saper |
Posted: Sat Sep 15, 2012 6:55 am Post subject: Re: Exec group not displaying in toolkit |
|
|
 Grand High Poobah
Joined: 18 Nov 2003 Posts: 20756 Location: LI,NY
|
dixit27 wrote: |
Broker version : 6.0
Yes having rights to the exec group..Not sure why it's not displaying in toolkit.
Process shows all exec groups running in SSH.
Also checked with the database team they told us that the listeners and broker database up and running fine. |
It was deleted in the toolkit but not on the broker...
Upgrade to 7.0 or better version 8.
Version 6.0 has been out of support for over a year now...
 _________________ MQ & Broker admin |
|
Back to top |
|
 |
rekarm01 |
Posted: Sat Sep 15, 2012 11:37 am Post subject: Re: Execution group not displaying in toolkit |
|
|
Grand Master
Joined: 25 Jun 2008 Posts: 1415
|
dixit27 wrote: |
For a particular broker i could see the execution group process running in the ssh but when i check in the toolkit i could able to view only default execution group. |
For WMBv6, sometimes the broker and configuration manager can get out of sync, particularly after cancelling a previous deploy in mid-progress. One way to resolve that is to remove deployed children from the broker, and then redeploy the desired execution groups. Consult the locally installed toolkit help for more details.
fjb_saper wrote: |
Upgrade to 7.0 or better version 8. |
 |
|
Back to top |
|
 |
mqsiuser |
Posted: Sat Sep 15, 2012 10:54 pm Post subject: Re: Execution group not displaying in toolkit |
|
|
 Yatiri
Joined: 15 Apr 2008 Posts: 637 Location: Germany
|
did you (try to) delete the exec group (with flows deployed) ?
with Broker 6.0 there is something called zombie execution groups.
to delete them you need to get the UID (unique id) of the exec group, then convert it (or bring it into the right form) and then delete the corresponding rows in the broker-db. Ofc. you need to be carefull when doing so.
To avoid that try to undeploy all flows first, then delete the (empty) exec group... or... just do not / avoid to delete exec groups. |
|
Back to top |
|
 |
mqsiuser |
Posted: Sat Sep 15, 2012 10:56 pm Post subject: Re: Execution group not displaying in toolkit |
|
|
 Yatiri
Joined: 15 Apr 2008 Posts: 637 Location: Germany
|
Search the forum for "zombie" or "orphaned execution groups". Also try if this works for you:
mqsiservice <BROKER_NAME> displays the UUID of the broker.
mqsibrowse <BROKER_NAME> -t BROKERAAEG displays the UUID of the EGs
Stop the broker if it is not already stopped then connect to the broker database with the broker service user ID.
DB2: UPDATE BROKERAAEG SET ProcessState=3, DynamicState=3 WHERE BrokerUUID= x'<UUID of Broker in uppercase without hyphens>' AND ExecGroupUUID = x'<UUID of Execution Group in uppercase without hyphens>'
Oracle: UPDATE BROKERAAEG
SET ProcessState=3, DynamicState=3
WHERE BrokerUUID= '<UUID of Broker in uppercase without hyphens>' AND ExecGroupUUID = '<UUID of Execution Group in uppercase without hyphens>'
Restart the broker and compare the EG-processes with the ones displayed in the toolkit |
|
Back to top |
|
 |
smdavies99 |
Posted: Sun Sep 16, 2012 2:05 am Post subject: Re: Execution group not displaying in toolkit |
|
|
 Jedi Council
Joined: 10 Feb 2003 Posts: 6076 Location: Somewhere over the Rainbow this side of Never-never land.
|
mqsiuser wrote: |
Search the forum for "zombie" or "orphaned execution groups". Also try if this works for you:
mqsiservice <BROKER_NAME> displays the UUID of the broker.
mqsibrowse <BROKER_NAME> -t BROKERAAEG displays the UUID of the EGs
Stop the broker if it is not already stopped then connect to the broker database with the broker service user ID.
DB2: UPDATE BROKERAAEG SET ProcessState=3, DynamicState=3 WHERE BrokerUUID= x'<UUID of Broker in uppercase without hyphens>' AND ExecGroupUUID = x'<UUID of Execution Group in uppercase without hyphens>'
Oracle: UPDATE BROKERAAEG
SET ProcessState=3, DynamicState=3
WHERE BrokerUUID= '<UUID of Broker in uppercase without hyphens>' AND ExecGroupUUID = '<UUID of Execution Group in uppercase without hyphens>'
Restart the broker and compare the EG-processes with the ones displayed in the toolkit |
This is naturall a totally unsupported hack but as you are using an unsupported version of Broker then....
Just bear in mind that you do this at your own risk. _________________ WMQ User since 1999
MQSI/WBI/WMB/'Thingy' User since 2002
Linux user since 1995
Every time you reinvent the wheel the more square it gets (anon). If in doubt think and investigate before you ask silly questions. |
|
Back to top |
|
 |
rekarm01 |
Posted: Sun Sep 16, 2012 8:49 am Post subject: Re: Execution group not displaying in toolkit |
|
|
Grand Master
Joined: 25 Jun 2008 Posts: 1415
|
Using an unsupported DB2 hack on an unsupported version of the broker is just asking for trouble. The documented methods for synchronizing the config manager with the broker is to use:(The WMBv6.0 InfoCenter is no longer on-line, but is available through the locally installed toolkit help, and has the same information provided in the links above.) |
|
Back to top |
|
 |
|