[jboss-user] [MQ] - Re: JMS error with SQLServer

[john.hagewood@gmail.com]

I am having this same problem, intermittently, in JBOSS 4.2.3.GA, running on Windows 2003 Server, MS SQL Server 2005:

org.jboss.mq.SpyJMSException: Could not store message: 3682 msg=3669 hard NOT_STORED PERSISTENT queue=QUEUE.VPSEmailQueue priority=4 lateClone=false hashCode=23743259; - nested throwable: (com.microsoft.sqlserver.jdbc.SQLServerException: Cannot insert duplicate key row in object 'dbo.JMS_MESSAGES' with unique index 'JMS_MESSAGES_IDX'.)
	at org.jboss.mq.pm.jdbc2.PersistenceManager.add(PersistenceManager.java:1133)
	at org.jboss.mq.server.PersistentQueue.addMessage(PersistentQueue.java:58)
	at org.jboss.mq.server.JMSQueue.addMessage(JMSQueue.java:180)
	at org.jboss.mq.server.JMSDestinationManager.addMessage(JMSDestinationManager.java:439)
	at org.jboss.mq.server.JMSDestinationManager.addMessage(JMSDestinationManager.java:422)
	at org.jboss.mq.server.JMSServerInvoker.addMessage(JMSServerInvoker.java:112)
	at org.jboss.mq.il.uil2.ServerSocketManagerHandler.handleMsg(ServerSocketManagerHandler.java:114)
	at org.jboss.mq.il.uil2.SocketManager$ReadTask.handleMsg(SocketManager.java:419)
	at org.jboss.mq.il.uil2.msgs.BaseMsg.run(BaseMsg.java:398)
	at EDU.oswego.cs.dl.util.concurrent.PooledExecutor$Worker.run(PooledExecutor.java:761)
	at java.lang.Thread.run(Thread.java:619)
Caused by: com.microsoft.sqlserver.jdbc.SQLServerException: Cannot insert duplicate key row in object 'dbo.JMS_MESSAGES' with unique index 'JMS_MESSAGES_IDX'.
	at com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDatabaseError(Unknown Source)
	at com.microsoft.sqlserver.jdbc.IOBuffer.processPackets(Unknown Source)
	at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement.getPrepExecResponse(Unknown Source)
	at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement.doExecutePreparedStatement(Unknown Source)
	at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement$PreparedStatementExecutionRequest.executeStatement(Unknown Source)
	at com.microsoft.sqlserver.jdbc.CancelableRequest.execute(Unknown Source)
	at com.microsoft.sqlserver.jdbc.SQLServerConnection.executeRequest(Unknown Source)
	at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement.executeUpdate(Unknown Source)
	at org.jboss.resource.adapter.jdbc.WrappedPreparedStatement.executeUpdate(WrappedPreparedStatement.java:365)
	at org.jboss.mq.pm.jdbc2.PersistenceManager.add(PersistenceManager.java:1172)
	at org.jboss.mq.pm.jdbc2.PersistenceManager.add(PersistenceManager.java:1118)
	... 10 more

We have had to turn on JMS queuing of our outbound emails until a resolution can be found.  We are dropping notification emails on the floor due to this JMS issue!  

Please help!?

Thanks

John Hagewood
Manager of Software Development

View the original post : http://www.jboss.org/index.html?module=bb&op=viewtopic&p=4260186#4260186

Reply to the post : http://www.jboss.org/index.html?module=bb&op=posting&mode=reply&p=4260186