| |
|
RSS Feed - WebSphere MQ Support
|
RSS Feed - Message Broker Support
|
  |
|
| Does Oracle 10 support Message Broker 5.0 CSD9. |
« View previous topic :: View next topic » |
| Author |
Message
|
| aditya.aggarwal |
 Posted: Fri Oct 23, 2009 9:23 am Post subject: Does Oracle 10 support Message Broker 5.0 CSD9. |
 |
|
Master
Joined: 13 Jan 2009
Posts: 252
|
Hi ,
Does Oracle 10 supports Message Broker 5.0 CSD9?
we are getting the below error while running the mqsicreatebroker command:
BIP2371E: Database statement 'CREATE TABLE BKADMIN.BSUBSCRIPTIONS ( BrokerUUID RAW(16) NOT NULL , ClientId RAW(254) NOT NULL , SubscriptionId RAW(60) NOT NULL , Topic LONG RAW, SubPoint RAW(128), Filter LONG RAW, Expiration RAW(3 , Creation RAW(3, Options NUMBER, SubInfo LONG RAW, PRIMARY KEY(BrokerUUID , SubscriptionId) )' could not be executed.
A message flow node attempted to execute a database statement. However, the database returned an error when executing the statement 'CREATE TABLE BKADMIN.BSUBSCRIPTIONS ( BrokerUUID RAW(16) NOT NULL , ClientId RAW(254) NOT NULL , SubscriptionId RAW(60) NOT NULL , Topic LONG RAW, SubPoint RAW(128), Filter LONG RAW, Expiration RAW(3, Creation RAW(3, Options NUMBER, SubInfo LONG RAW, PRIMARY KEY(BrokerUUID , SubscriptionId) )'.
If necessary, correct the message flow and redeploy the message broker.
BIP2321E: 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.
BIP2322E: Database error: SQL State 'HY000'; Native Error Code '1754'; Error Text '[DataDirect][ODBC Oracle driver][Oracle]
The error has the following diagnostic information: SQL State 'HY000' SQL Native Error Code '1754' SQL Error Text '[DataDirect][ODBC Oracle driver][Oracle]ORA-01754: a table may contain only one column of type LONG '
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.
BIP8070E: Exception accessing database table executing SQL statement 'CREATE TABLE BKADMIN.BSUBSCRIPTIONS ( BrokerUUID RAW(16) NOT NULL , ClientId RAW(254) NOT NULL , SubscriptionId RAW(60) NOT NULL , Topic LONG RAW, SubPoint RAW(128), Filter LONG RAW, Expiration RAW(3, Creation RAW(3, Options NUMBER, SubInfo LONG RAW, PRIMARY KEY(BrokerUUID , SubscriptionId) )': SQL state '1754'; exception 'ImbException'.
An SQL command has failed.
Ensure that the broker's database is available. Examine the exception and SQL state code to determine and correct the cause of the error.
Cheers,
Aditya |
|
| Back to top |
|
 |
| mqjeff |
| Posted: Fri Oct 23, 2009 9:49 am Post subject: |
|
|
Grand Master
Joined: 25 Jun 2008
Posts: 17447
|
The question is not, Does Oracle support Message Broker, the question is : does Message Broker suport Oracle?
And the answer for CSD 9 of MB v5.0 is almost certainly no. And of course, you don't have any support at all for MB v5.0 at any CSD, unless you are paying for extended support from IBM.
Upgrade, and you will be supported. Jump straight to v6.1. |
|
| Back to top |
|
|
| aditya.aggarwal |
| Posted: Fri Oct 23, 2009 11:52 am Post subject: |
|
|
Master
Joined: 13 Jan 2009
Posts: 252
|
Thanks.
We have extended support for MB5.0
We will upgrade to MB to V6.1.3
Cheers,
Aditya |
|
| Back to top |
|
|
| WMBDEV1 |
| Posted: Sat Oct 24, 2009 5:43 am Post subject: |
|
|
Sentinel
Joined: 05 Mar 2009
Posts: 888
Location: UK
|
| aditya.aggarwal wrote: |
We will upgrade to MB to V6.1.3
|
Whats wrong with 6.1.0.4 or better still 6.1.0.5? |
|
| Back to top |
|
|
| aditya.aggarwal |
| Posted: Mon Oct 26, 2009 2:08 am Post subject: |
|
|
Master
Joined: 13 Jan 2009
Posts: 252
|
| Quote: |
The question is not, Does Oracle support Message Broker, the question is : does Message Broker suport Oracle?
And the answer for CSD 9 of MB v5.0 is almost certainly no |
MB Version 5 supports oracle 10g..
We resolved this issue after correcting the setting of ODBC driver for MB.
Cheers,
Aditya |
|
| Back to top |
|
|
| smdavies99 |
| Posted: Mon Oct 26, 2009 2:15 am Post subject: |
|
|
Jedi Council
Joined: 10 Feb 2003
Posts: 6076
Location: Somewhere over the Rainbow this side of Never-never land.
|
| aditya.aggarwal wrote: |
MB Version 5 supports oracle 10g..
|
If the Product documentation does not mention Oracle 10g as a supported database for Broker 5 then you should probably say the following
MB Version 5 works with Oracle 10g..
_________________
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 |
|
|
| aditya.aggarwal |
| Posted: Mon Oct 26, 2009 2:18 am Post subject: |
|
|
Master
Joined: 13 Jan 2009
Posts: 252
|
| Quote: |
aditya.aggarwal wrote:
MB Version 5 supports oracle 10g..
If the Product documentation does not mention Oracle 10g as a supported database for Broker 5 then you should probably say the following
MB Version 5 works with Oracle 10g.. |
Sorry...MB Version 5 product documentation mentioned oracle 10g as a supported databse.  |
|
| 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
|
|
|
|
