| |
|
RSS Feed - WebSphere MQ Support
|
RSS Feed - Message Broker Support
|
  |
|
| broker errors |
« View previous topic :: View next topic » |
| Author |
Message
|
| mqwbiwf |
 Posted: Mon Nov 06, 2006 1:56 pm Post subject: broker errors |
 |
|
Centurion
Joined: 21 Jul 2006
Posts: 126
|
Hi all,
I have recently installed and configured MessageBroker 6 on AIX 5.3.
Complete deployment of broker was fine without any errors in event log. But when I try to delete a test Execution Group, it's throwing foll errors:
BIP2048E: An Exception was caught while issuing database SQL command INSERT INTO DB_SCHEMA.BROKERAAEG ( BrokerUUID, ExecGroupUUID, ExecGroupLabel, RetryInterval, PubSubServer, ProcessId, ProcessState, DynamicState, DynamicSync, ProcArchitecture, MsgId, CntlGrpMsgId ) VALUES ( ?, ?, ?, 3, 0, 0, 0, 6, 0, 32, ?, ? ).
BIP2371E: Database statement 'INSERT INTO DB_SCHEMA.BROKERAAEG ( BrokerUUID, ExecGroupUUID, ExecGroupLabel, RetryInterval, PubSubServer, ProcessId, ProcessState, Dy
namicState, DynamicSync, ProcArchitecture, MsgId, CntlGrpMsgId ) VALUES ( ?, ?, ?, 3, 0, 0, 0, 6, 0, 32, ?, ? )' could not be
executed.
BIP2321E: Database error: ODBC return code '-1'.
BIP2322E: Database error: SQL State '23000'; Native Error Code '1400'; Error Text '[DataDirect][ODBC Oracle driver][Oracle]ORA-01400: cannot insert NULL into "DB_SCHEMA"."BROKERAAEG"."EXECGROUPLABEL") '.
Any thoughts guys?? AFAIK, the Datasource user id has full access on this particular schema. And this is what I gave while creating the broker. |
|
| Back to top |
|
 |
| vk |
| Posted: Mon Nov 06, 2006 2:10 pm Post subject: |
|
|
Partisan
Joined: 20 Sep 2005
Posts: 302
Location: Houston
|
This does not look like the correct error message. This is the error log for a message flow which tried to do an INSERT operation on a table and it failed because the key fields had a NULL value.
Try doing the delete again and see if there are more updates in the error log. Are you getting any messages or alerts in the toolkit?
Regards,
VK. |
|
| Back to top |
|
|
| mqwbiwf |
| Posted: Mon Nov 06, 2006 2:49 pm Post subject: |
|
|
Centurion
Joined: 21 Jul 2006
Posts: 126
|
Hi vk,
Thanks for the response.
These are the messages that I'm getting when deleted the EG. When I created it, the deployment is fine, with a msg in event log which says that the config change has been successful. But when delete it, it's throwing a series of those errors.
I tried to assign the sample airline bar file initially, which was throwin diff error messages. But later just tried to see if a EG can be created and deleted without any issues. Then I see these errors. In the database, I don't see any values for Broker UUID and a few others, but they are in RAW format. Not sure enough, but shouldn't they be in character data type?
Thanks.
Last edited by mqwbiwf on Tue Nov 07, 2006 12:04 pm; edited 2 times in total |
|
| Back to top |
|
|
| mqwbiwf |
| Posted: Tue Nov 07, 2006 11:44 am Post subject: |
|
|
Centurion
Joined: 21 Jul 2006
Posts: 126
|
| Any thoughts on this issue guys? |
|
| Back to top |
|
|
| JosephGramig |
| Posted: Tue Nov 07, 2006 12:09 pm Post subject: |
|
|
Grand Master
Joined: 09 Feb 2006
Posts: 1244
Location: Gold Coast of Florida, USA
|
If you are not logging to a file of your choice, please follow the instructions at http://publib.boulder.ibm.com/infocenter/wmbhelp/v6r0m0/index.jsp?topic=/com.ibm.etools.mft.doc/an04230_.htm and choose user.debug.
If you are logging to a file of your choice, stop the broker and truncate the file with '> file.log'. Restart the broker and watch for errors. If you have no errors, try to delete the execution group.
If you get errors, bring them back here.
_________________
Joseph
Administrator - IBM WebSphere MQ (WMQ) V6.0, IBM WebSphere Message Broker (WMB) V6.1 & V6.0
Solution Designer - WMQ V6.0
Solution Developer - WMB V6.1 & V6.0, WMQ V5.3 |
|
| Back to top |
|
|
| mqwbiwf |
| Posted: Tue Nov 07, 2006 5:19 pm Post subject: |
|
|
Centurion
Joined: 21 Jul 2006
Posts: 126
|
I don't have any problem with logging. The above error messages given are from the re-directed file.
My problem is I am getting above errors when tried to delete an EG. BTW, the broker database being used is an external database and not local. I don't think it's a permission problem because the user id has full access to the database. And I don't know what else might cause this issue.
Please let me know if someone had such issues before.
Thank you. |
|
| Back to top |
|
|
| jbanoop |
| Posted: Wed Nov 08, 2006 12:33 am Post subject: |
|
|
Chevalier
Joined: 17 Sep 2005
Posts: 401
Location: SC
|
is it the only execution group on the broker ?
check it out using mqsilist <brokername> on the console. MB requires atleast 1 execution group to be there on a broker.
how did you try deleting the execution group ? from the toolkit or the console?
it is worth a try to perform an mqsideleteexecutiongroup command from the console and see |
|
| Back to top |
|
|
| PieterV |
| Posted: Wed Nov 08, 2006 3:10 am Post subject: |
|
|
Disciple
Joined: 04 Jan 2006
Posts: 164
Location: Belgium
|
this is a known problem to IBM.
it can be solved with APAR IY86532.
it had the same problem with the deletion of the EG. The've created a fix for Solaris for me based on APAR IY86532.
Use ETR for more info. |
|
| Back to top |
|
|
| mqwbiwf |
| Posted: Wed Nov 08, 2006 2:22 pm Post subject: |
|
|
Centurion
Joined: 21 Jul 2006
Posts: 126
|
We use AIX. And so before I open up a ticket I would like to see there is anything wrong in my settings.
Now here are the errors that I get:
1)Created a simple msg flow with a i/p, o/p and compute nodes. When deployed the bar file, throws these errors:
BIP2087E ,BIP4041E &
BIP2241E: Loadable Implementation Library (.lil, .jar or .par) not found for message flow node type 'ComIbmComputeNode' in message flow 'TEST_FLOW'.
2)Later when removed the compute node out of the flow and deployed, it didn't thrown any errors. Now I see teh test execution group along with default one running.
3) Removed the flow from test EG and tried to delete the ExecGroup, but it's still throwing the same errors as given in my previous posts. I cannot see the EG in the toolkit, but can see it using 'mqsilist broker'.
Do you still think IBM has released a fix for such cases?
Thanks a lot! |
|
| Back to top |
|
|
|
|
|
| |
|
Page 1 of 1 |
|
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum
|
|
|
|
