MQSeries.net :: View topic

lohit · Posted: Fri May 30, 2003 1:06 am Post subject:

Hi,
I am trying to install MQSI 2.0.1 on Sun Solaris Sun OS 5.8 with oracle 8.1.7.

While giving the command

Code:

mqsicreatebroker MQSI_BROKER -i mqsiuser -a mqsiuser -q MQSI_BROKER_QM -n mqbkdb -u system -p manager

I get the following errror:

Code:

BIP2371E: Database statement 'CREATE TABLE SYSTEM.BROKERAAEG (BrokerUUID (16) NOT NULL,ExecGroupUUID (16) NOT NULL,ExecGroupLabel BLOB NOT NULL,RetryInterval ,PubSubServer ,ProcessId ,ProcessState ,DynamicState ,DynamicSync ,MsgId (24),CntlGrpMsgId (24))' 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 SYSTEM.BROKERAAEG (BrokerUUID (16) NOT NULL,ExecGroupUUID (16) NOT NULL,ExecGroupLabel BLOB NOT NULL,RetryInterval ,PubSubServer ,ProcessId ,ProcessState ,DynamicState ,DynamicSync ,MsgId (24),CntlGrpMsgId (24))'.
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 '60'; Native Error Code '902'; Error Text '[MERANT][ODBC 20101 driver][20101]ORA-00902: invalid datatype
'.
The error has the following diagnostic information: SQL State '60' SQL Native Error Code '902' SQL Error Text '[MERANT][ODBC 20101 driver][20101]ORA-00902: invalid datatype
'
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 SYSTEM.BROKERAAEG (BrokerUUID (16) NOT NULL,ExecGroupUUID (16) NOT NULL,ExecGroupLabel BLOB NOT NULL,RetryInterval ,PubSubServer ,ProcessId ,ProcessState ,DynamicState ,DynamicSync ,MsgId (24),CntlGrpMsgId (24))': SQL state '902'; 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.

I am a newbie in MQSI, Please help.

Thanks & Regards
Lohit