MQSeries.net :: View topic

ayanc · Posted: Wed Nov 15, 2006 3:31 am Post subject:

Hi All,

We have planned to upgrade to MB6 from MB5. We have installed MB6 in the same m/c (with MB5 running perfectly).

MB5 has been affected rather strangely.

1. The Problems view show that Broker is not Running, Execution Group is not running. However the deploy is working ... (

)

2. I am getting the following 3 errors in the event viewer

1st Error
==============================================
( WBRK_BROKER.default ) Message broker internal error: diagnostic information 'DynamicSubscriptionEngine'.

An internal software error has occurred in the message broker. Further messages will indicate the effect of this error on the broker's transactions. The diagnostic information associated with this message is: 'DynamicSubscriptionEngine'.

Shutdown and restart the message broker. If the problem continues to occur, then restart the system. If the problem still continues to occur contact your IBM support center.
==============================================

2nd Error
===============================================
( WBRK_BROKER.default ) Database error: ODBC return code '-1'.

The message broker encountered an error whilst executing a database operation. The ODBC return code was '-1'. See the following messages for information obtained from the database pertaining to this error.

Use the following messages to determine the cause of the error. This is likely to be such things as incorrect datasource or table names. Then correct either the database or message broker configuration.
===============================================

3rd Error
===============================================
( WBRK_BROKER.default ) Database error: SQL State '38553'; Native Error Code '-443'; Error Text '[IBM][CLI Driver][DB2/NT] SQL0443N Routine "SYSIBM.SQLTABLES" (specific name "TABLES") has returned an error SQLSTATE with diagnostic text "SYSIBM:CLI:-805". SQLSTATE=38553 '.

The error has the following diagnostic information: SQL State '38553' SQL Native Error Code '-443' SQL Error Text '[IBM][CLI Driver][DB2/NT] SQL0443N Routine "SYSIBM.SQLTABLES" (specific name "TABLES") has returned an error SQLSTATE with diagnostic text "SYSIBM:CLI:-805". SQLSTATE=38553 '

This message may be accompanied by other messages describing the effect on the message broker itself. Use the reason identified in this message with the accompanying messages to determine the cause of the error.
==============================================

3. My Subscriptions are not working. In MB5 I am not able to register any subscriptions.

Another error that is very new to me is as follows:
==============================================
ConfigMgr ) Error casting character string 'ConfigMgr' to a TIMESTAMP

The character string must have a TIMESTAMP format, for it to be castable to a timestamp.

Ensure that the string being cast is formatted correctly. Examples of correct formats include 'yyyy-mm-dd hh:mm:ss[.f+]' and 'yyyy-mm-dd hh:mm:ss[.uuu]'.
==============================================

I could go on with the list of errors ... but anyway if you want me to I will definitely post them. I had to uninstall the entire set up and reinstall a number of times ... facing new problems every time. However currently I am facing this problem.

I think installing both versions in the same m/c is creating all this trouble. Can anyone give me an idea as to a suitable course of action. Sadly I need to have both of em in a single m/c.

Now for the system details:

Win XP SP2
WMQ 5.3 CSD 10
WBIMB 5.0 CSD 5
DB2 8.1 Fixpack 13
WBIMB 6.0 ( CMVC Level: S000-L50920.2 DH000-L50920)

I have a separate queue manager for v5 with both ConfigMgr and Broker sharing the same qmgr.

I have a separate queue manager for v6 with both ConfigMgr and Broker sharing the same qmgr.

Could you please let me know if you need any further info?

Thanks.