Invalid Column Index error on MQMSG41CMAAMESSAGING table
Hi All,
I am trying to setup Sun Open MQ 4.1 in high availability mode and I am having some problems. I am using 4.1 with a 10g (10.2.0.3) RAC cluster. I am using the newest driver for that version of 10g database.
I get the following error when the application tries to persist messages to the database:
[23/May/2007:16:42:11 MST] ERROR [B2011]: Storing of JMS message from 11764-10.164.2.195(8f:72:80:73:f2:54)-53250-1179963731597 failed:
com.sun.messaging.jmq.jmsserver.util.BrokerException: [B4004]: Failed to persist message 11764-10.164.2.195(8f:72:80:73:f2:54)-53250-1179963731597
at com.sun.messaging.jmq.jmsserver.persist.jdbc.MessageDAOImpl.insert(MessageDAOImpl.java:415)
at com.sun.messaging.jmq.jmsserver.persist.jdbc.OracleMessageDAOImpl.insert(OracleMessageDAOImpl.java:113)
at com.sun.messaging.jmq.jmsserver.persist.jdbc.MessageDAOImpl.insert(MessageDAOImpl.java:335)
at com.sun.messaging.jmq.jmsserver.persist.jdbc.JDBCStore.storeMessage(JDBCStore.java:202)
at com.sun.messaging.jmq.jmsserver.core.PacketReference.store(PacketReference.java:1153)
at com.sun.messaging.jmq.jmsserver.core.Queue.routeNewMessage(Queue.java:521)
at com.sun.messaging.jmq.jmsserver.data.handlers.DataHandler.routeMessage(DataHandler.java:341)
at com.sun.messaging.jmq.jmsserver.data.handlers.DataHandler.handle(DataHandler.java:171)
at com.sun.messaging.jmq.jmsserver.data.handlers.DataHandler.handle(DataHandler.java:85)
at com.sun.messaging.jmq.jmsserver.data.PacketRouter.handleMessage(PacketRouter.java:167)
at com.sun.messaging.jmq.jmsserver.service.imq.IMQIPConnection.readData(IMQIPConnection.java:1443)
at com.sun.messaging.jmq.jmsserver.service.imq.IMQIPConnection.process(IMQIPConnection.java:612)
at com.sun.messaging.jmq.jmsserver.service.imq.OperationRunnable.process(OperationRunnable.java:159)
at com.sun.messaging.jmq.jmsserver.util.pool.BasicRunnable.run(BasicRunnable.java:477)
at java.lang.Thread.run(Thread.java:595)
Caused by: java.sql.SQLException: [INSERT INTO MQMSG41CmaaMessaging ( ID, MESSAGE_SIZE, STORE_SESSION_ID, DESTINATION_ID, TRANSACTION_ID, CREATED_TS, MESSAGE) VALUES ( ?, ?, ?, ?, ?, ?, EMPTY_BLOB() )]: Invalid column index
at com.sun.messaging.jmq.jmsserver.persist.jdbc.DBManager.wrapSQLException(DBManager.java:826)
at com.sun.messaging.jmq.jmsserver.persist.jdbc.MessageDAOImpl.insert(MessageDAOImpl.java:410)
... 14 more
[23/May/2007:16:42:11 MST] WARNING [B2011]: Storing of JMS message from IMQConn[AUTHENTICATED,admin@10.164.2.195:53250,jms:35525] failed:
com.sun.messaging.jmq.jmsserver.util.BrokerException: com.sun.messaging.jmq.jmsserver.util.BrokerException: [B4004]: Failed to persist message 11764-10.164.2.195(8f:72:80:73:f2:54)-53250-1179963731597
I have checked the status of the indexes in the all_indexes table and they are all valid. The initial connection for the messaging server to the database is fine. I can insert a record into that table manually using sqlplus. I can use the imqdbmgr tool to drop and recreate the tables. The only thing I can't do is persist the messages into the database.
Has anyone seen this type of error before? The only other thing that comes to mind is that we are using the 64 bit version of 10g. Could that be causing this problem?
Thanks for any help you can give me
