| Author |
Message
|
| MSAT |
 Posted: Mon May 29, 2006 8:37 am Post subject: Execution Group Problem |
 |
|
Acolyte
Joined: 17 Aug 2005
Posts: 62
Location: Bengalooru
|
Hi All,
We are running WBIMB V5.0 Broker on Solaris server. There are around 3 execution groups running under this broker. Say ExecGrp1, 2 and 3.
I tried to delete ExecGrp3 from the topology (From Toolkit) It deleted also. But when I grep for this execution group in Solaris server it is still in the running state.
I tried to stop both configmgr and broker and then restarted and did the same thing. But the execution group still in active state. If I tried to kill that process, it is coming up again with different PID.
Please let me know how to resolve this issue, as it is very urgent.
Thanks
MSAT |
|
| Back to top |
|
 |
| nvogt |
| Posted: Mon May 29, 2006 11:34 pm Post subject: |
|
|
Novice
Joined: 27 Apr 2006
Posts: 11
Location: Aachen, Germany
|
Hello MSAT
We have the same Problem with Broker V.6 and IBM gave us the following answer upon our request.
-------------------------------------------
Once it has been verified that there are no outstanding deploys the 'rogue' execution groups can be removed from the broker database with the following SQL. Please note, it is strongly recommended that the broker is stopped and the broker database is backed up prior to manually updating database records.
0. mqsiservice <BROKER_NAME>
So you get the UUID of the broker.
With ...
mqsibrowse <BROKER_NAME> -t BROKERAAEG > c:\brokeraaeg.out
... you can get the UUID of the EG(s), which you want to remove.
1. Stop the broker if it is not already stopped.
2. Connect to the broker database as the broker service user ID.
3. Depending on the RDBMS that's used for the broker database, run the following SQL to remove each rogue execution group.
a) DB2 Broker Database
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>'
b) Oracle Broker Database
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>'
4. Restart the broker and ensure that the number of execution groups that are started reflects the number of execution groups that are displayed in the Tooling.
-------------------------------------------
Norbert |
|
| Back to top |
|
|
| jefflowrey |
| Posted: Tue May 30, 2006 5:02 am Post subject: |
|
|
Grand Poobah
Joined: 16 Oct 2002
Posts: 19981
|
Also, please apply the latest fixpacks to the v5 environment! This may be already fixed!
And make sure you have deployed the topology after deleting the EG.
_________________
I am *not* the model of the modern major general. |
|
| Back to top |
|
|
| MSAT |
| Posted: Tue May 30, 2006 11:48 pm Post subject: |
|
|
Acolyte
Joined: 17 Aug 2005
Posts: 62
Location: Bengalooru
|
Hi nvogt,
Thanks for the reply. I implemented the same steps and it worked fine. Now I am able to see only those execution groups in Solaris server, which are present in Topology view. And the table automatically updated by the broker when i restarted the broker after updating Brokeraaeg table.
As I feel when the broker restarts it takes only those records from the brokeraaeg table for which the processstate and dynamicstate having value 1 and starts the corresponfding Exec Group. Rest all with 3 as state deleted by broker.
Thank You
MSAT |
|
| Back to top |
|
|
| vmurali_au |
| Posted: Fri Jan 19, 2007 8:33 am Post subject: |
|
|
Voyager
Joined: 26 Mar 2004
Posts: 76
|
I'm using WMB 6.0.0.1
I've deleted the execution group "default". I also have checked the table BROKERRREG and found the entry for "default" EG. It contains 3 as the value for both the ProcessState and DynamicState. There are no other rows in the table except for this EG.
I cant see this "default" EG in my connections domain in toolkit. But it shows up in my debugger. And the flows in that EG keep processing my messages.
How i can remove this EG completely from the Toolkit. |
|
| Back to top |
|
|
| vmurali_au |
| Posted: Fri Jan 19, 2007 8:35 am Post subject: |
|
|
Voyager
Joined: 26 Mar 2004
Posts: 76
|
Can i remove the row for the EG "default" from the table BROKERAAEG ?
will it have any repercussions. |
|
| Back to top |
|
|
| PieterV |
| Posted: Thu Jan 25, 2007 5:49 am Post subject: |
|
|
Disciple
Joined: 04 Jan 2006
Posts: 164
Location: Belgium
|
Hi vmurali_au,
upgrade to 6.0.0.3 and the problem will be solved.
if you do not wish to upgrade, install fix for APAR IY86532. |
|
| Back to top |
|
|
|
|
