Discussions

General J2EE: org.jboss.mq.SpyJMSException in JBOSS

  1. org.jboss.mq.SpyJMSException in JBOSS (2 messages)

    Greetings!

    I am using jboss-4.0.0 and SQL Server 2000. I have a session bean that generates some data rapidly and puts them into a Queue which later will be consumed by an MDB. But, after a while I can see some fatal exceptions at the JBoss side. The following is the stack. Please help me to solve this.

    17:20:40,937 INFO [Server] JBoss (MX MicroKernel) [4.0.0 (build: CVSTag=JBoss_4_0_0 date=200409200418)] Started in 35s:250ms
    19:41:53,687 INFO [STDOUT] java.lang.NullPointerException



    19:41:53,812 INFO [STDOUT] org.jboss.mq.SpyJMSException: Could not store message: 209414
    msg=209413 hard NOT_STORED PERSISTENT queue=QUEUE.LogQueue priority=4 lateClone=false hashCode=20676962;
    - nested throwable: (java.sql.SQLException: S1000 General error java.lang.NullPointerException in
    statement [INSERT INTO JMS_MESSAGES (MESSAGEID, DESTINATION, MESSAGEBLOB, TXID, TXOP) VALUES(?,?,?,?,?)])



    19:41:53,812 INFO [STDOUT] at org.jboss.mq.pm.jdbc2.PersistenceManager.add(PersistenceManager.java:802)
    19:41:53,812 INFO [STDOUT] at org.jboss.mq.server.PersistentQueue.addMessage(PersistentQueue.java:38)
    19:41:53,812 INFO [STDOUT] at org.jboss.mq.server.JMSQueue.addMessage(JMSQueue.java:131)
    19:41:53,812 INFO [STDOUT] at org.jboss.mq.server.JMSDestinationManager.addMessage(JMSDestinationManager.java:402)
    19:41:53,812 INFO [STDOUT] at org.jboss.mq.server.JMSDestinationManager.addMessage(JMSDestinationManager.java:378)
    19:41:53,812 INFO [STDOUT] at org.jboss.mq.server.JMSServerInterceptorSupport.addMessage(JMSServerInterceptorSupport.java:136)
    19:41:53,812 INFO [STDOUT] at org.jboss.mq.security.ServerSecurityInterceptor.addMessage(ServerSecurityInterceptor.java:153)
    19:41:53,812 INFO [STDOUT] at org.jboss.mq.server.TracingInterceptor.addMessage(TracingInterceptor.java:270)
    19:41:53,812 INFO [STDOUT] at org.jboss.mq.server.JMSServerInvoker.addMessage(JMSServerInvoker.java:136)
    19:41:53,812 INFO [STDOUT] at org.jboss.mq.il.jvm.JVMServerIL.addMessage(JVMServerIL.java:136)
    19:41:53,812 INFO [STDOUT] at org.jboss.mq.Connection.sendToServer(Connection.java:1020)
    19:41:53,812 INFO [STDOUT] at org.jboss.mq.SpySession.sendMessage(SpySession.java:1005)
    19:41:53,812 INFO [STDOUT] at org.jboss.mq.SpyMessageProducer.send(SpyMessageProducer.java:265)
    19:41:53,812 INFO [STDOUT] at org.jboss.mq.SpyMessageProducer.send(SpyMessageProducer.java:199)
    19:41:53,812 INFO [STDOUT] at org.mirapoint.LogCollectorSessionBean.insertLog(Unknown Source)
    19:41:53,812 INFO [STDOUT] at sun.reflect.GeneratedMethodAccessor77.invoke(Unknown Source)
    19:41:53,812 INFO [STDOUT] at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
    19:41:53,812 INFO [STDOUT] at java.lang.reflect.Method.invoke(Method.java:324)
    19:41:53,812 INFO [STDOUT] at org.jboss.invocation.Invocation.performCall(Invocation.java:345)
    19:41:53,812 INFO [STDOUT] at org.jboss.ejb.StatelessSessionContainer$ContainerInterceptor.invoke(StatelessSessionContainer.java:214)
    19:41:53,812 INFO [STDOUT] at org.jboss.resource.connectionmanager.CachedConnectionInterceptor.invoke(CachedConnectionInterceptor.java:185)
    19:41:53,812 INFO [STDOUT] at org.jboss.ejb.plugins.StatelessSessionInstanceInterceptor.invoke(StatelessSessionInstanceInterceptor.java:113)
    19:41:53,812 INFO [STDOUT] at org.jboss.webservice.server.ServiceEndpointInterceptor.invoke(ServiceEndpointInterceptor.java:51)
    19:41:53,812 INFO [STDOUT] at org.jboss.ejb.plugins.CallValidationInterceptor.invoke(CallValidationInterceptor.java:48)
    19:41:53,812 INFO [STDOUT] at org.jboss.ejb.plugins.AbstractTxInterceptor.invokeNext(AbstractTxInterceptor.java:105)
    19:41:53,812 INFO [STDOUT] at org.jboss.ejb.plugins.TxInterceptorCMT.runWithTransactions(TxInterceptorCMT.java:316)
    19:41:53,812 INFO [STDOUT] at org.jboss.ejb.plugins.TxInterceptorCMT.invoke(TxInterceptorCMT.java:149)
    19:41:53,812 INFO [STDOUT] at org.jboss.ejb.plugins.SecurityInterceptor.invoke(SecurityInterceptor.java:128)
    19:41:53,812 INFO [STDOUT] at org.jboss.ejb.plugins.LogInterceptor.invoke(LogInterceptor.java:191)
    19:41:53,812 INFO [STDOUT] at org.jboss.ejb.plugins.ProxyFactoryFinderInterceptor.invoke(ProxyFactoryFinderInterceptor.java:122)
    19:41:53,812 INFO [STDOUT] at org.jboss.ejb.SessionContainer.internalInvoke(SessionContainer.java:624)
    19:41:53,812 INFO [STDOUT] at org.jboss.ejb.Container.invoke(Container.java:854)
    19:41:53,812 INFO [STDOUT] at sun.reflect.GeneratedMethodAccessor73.invoke(Unknown Source)
    19:41:53,812 INFO [STDOUT] at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
    19:41:53,812 INFO [STDOUT] at java.lang.reflect.Method.invoke(Method.java:324)
    19:41:53,812 INFO [STDOUT] at org.jboss.mx.interceptor.ReflectedDispatcher.invoke(ReflectedDispatcher.java:141)
    19:41:53,812 INFO [STDOUT] at org.jboss.mx.server.Invocation.dispatch(Invocation.java:80)
    19:41:53,812 INFO [STDOUT] at org.jboss.mx.server.Invocation.invoke(Invocation.java:72)
    19:41:53,812 INFO [STDOUT] at org.jboss.mx.server.AbstractMBeanInvoker.invoke(AbstractMBeanInvoker.java:242)
    19:41:53,812 INFO [STDOUT] at org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:642)
    19:41:53,812 INFO [STDOUT] at org.jboss.invocation.jrmp.server.JRMPInvoker$MBeanServerAction.invoke(JRMPInvoker.java:775)
    19:41:53,812 INFO [STDOUT] at org.jboss.invocation.jrmp.server.JRMPInvoker.invoke(JRMPInvoker.java:382)
    19:41:53,812 INFO [STDOUT] at sun.reflect.GeneratedMethodAccessor72.invoke(Unknown Source)
    19:41:53,812 INFO [STDOUT] at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
    19:41:53,812 INFO [STDOUT] at java.lang.reflect.Method.invoke(Method.java:324)
    19:41:53,812 INFO [STDOUT] at sun.rmi.server.UnicastServerRef.dispatch(UnicastServerRef.java:261)
    19:41:53,812 INFO [STDOUT] at sun.rmi.transport.Transport$1.run(Transport.java:148)
    19:41:53,812 INFO [STDOUT] at java.security.AccessController.doPrivileged(Native Method)
    19:41:53,812 INFO [STDOUT] at sun.rmi.transport.Transport.serviceCall(Transport.java:144)
    19:41:53,812 INFO [STDOUT] at sun.rmi.transport.tcp.TCPTransport.handleMessages(TCPTransport.java:460)
    19:41:53,812 INFO [STDOUT] at sun.rmi.transport.tcp.TCPTransport$ConnectionHandler.run(TCPTransport.java:701)
    19:41:53,812 INFO [STDOUT] at java.lang.Thread.run(Thread.java:534)
    19:41:53,812 INFO [STDOUT] Caused by: java.sql.SQLException: S1000 General error java.lang.NullPointerException in statement [INSERT INTO JMS_MESSAGES (MESSAGEID, DESTINATION, MESSAGEBLOB, TXID, TXOP) VALUES(?,?,?,?,?)]
    19:41:53,812 INFO [STDOUT] at org.hsqldb.jdbc.jdbcUtil.throwError(Unknown Source)
    19:41:53,812 INFO [STDOUT] at org.hsqldb.jdbc.jdbcPreparedStatement.executeUpdate(Unknown Source)
    19:41:53,812 INFO [STDOUT] at org.jboss.resource.adapter.jdbc.WrappedPreparedStatement.executeUpdate(WrappedPreparedStatement.java:316)
    19:41:53,812 INFO [STDOUT] at org.jboss.mq.pm.jdbc2.PersistenceManager.add(PersistenceManager.java:840)
    19:41:53,812 INFO [STDOUT] at org.jboss.mq.pm.jdbc2.PersistenceManager.add(PersistenceManager.java:787)
    19:41:53,812 INFO [STDOUT] ... 51 more


    This stack is generated one per each message thatis to be out into queue. Is it an internal error of JBoss?

    Thank you,
    kala.
    --------------------------------------------------------------------------------

    Threaded Messages (2)

  2. me too message[ Go to top ]

    me too me too me too
    Been bugging me for half a year now!
    My platform is Redhat And I'm using JBoss 3.2.6
    After two months of runnign or soo I get exactly the same Exception.

    Help would be vey much appreciated!
  3. Hi I am also getting this message and I am wondering if you have any reply to your post. Any fix ? solution if you could share very much appreciate it. My Senario: Using OracleDB and JBoss 4.2.3.GA Error Log... 00:16:34,624 INFO [STDOUT] End PrelimCheckSourceDB. Valid MechDealsList size= 1557 00:16:34,624 INFO [STDOUT] MechDealFileBursterImpl: Create and Send MechDealTransanction MQMessage... 00:16:34,639 INFO [STDOUT] MechDealFileBursterImpl ==> MechDealInstantiatorMDB. MechDeals Size = 1557 00:16:34,639 INFO [STDOUT] SourceDB Class Name= emi.mechanical.plrdb.generated.Root$SourceDB 00:16:35,014 INFO [STDOUT] Exception occurred: org.jboss.mq.SpyJMSException: Could not store message: 18 msg=6 hard NOT_STORED PERSISTENT queue=QUEUE.MechDealInstantiatorMDB priority=4 lateClone=false hashCode=1219286; - nested throwable: (java.sql.SQLException: ORA-01460: unimplemented or unreasonable conversion requested ) 00:16:35,014 ERROR [STDERR] org.jboss.mq.SpyJMSException: Could not store message: 18 msg=6 hard NOT_STORED PERSISTENT queue=QUEUE.MechDealInstantiatorMDB priority=4 lateClone=false hashCode=1219286; - nested throwable: (java.sql.SQLException: ORA-01460: unimplemented or unreasonable conversion requested ) 00:16:35,014 ERROR [STDERR] at org.jboss.mq.pm.jdbc2.PersistenceManager.add(PersistenceManager.java:1133) 00:16:35,014 ERROR [STDERR] at org.jboss.mq.server.PersistentQueue.addMessage(PersistentQueue.java:58) 00:16:35,014 ERROR [STDERR] at org.jboss.mq.server.JMSQueue.addMessage(JMSQueue.java:180) 00:16:35,014 ERROR [STDERR] at org.jboss.mq.server.JMSDestinationManager.addMessage(JMSDestinationManager.java:439) 00:16:35,014 ERROR [STDERR] at org.jboss.mq.server.JMSDestinationManager.addMessage(JMSDestinationManager.java:422) 00:16:35,014 ERROR [STDERR] at org.jboss.mq.server.JMSServerInterceptorSupport.addMessage(JMSServerInterceptorSupport.java:106) 00:16:35,014 ERROR [STDERR] at org.jboss.mq.security.ServerSecurityInterceptor.addMessage(ServerSecurityInterceptor.java:168) 00:16:35,014 ERROR [STDERR] at org.jboss.mq.server.TracingInterceptor.addMessage(TracingInterceptor.java:226) 00:16:35,014 ERROR [STDERR] at org.jboss.mq.server.JMSServerInvoker.addMessage(JMSServerInvoker.java:112) 00:16:35,014 ERROR [STDERR] at org.jboss.mq.il.jvm.JVMServerIL.addMessage(JVMServerIL.java:101) 00:16:35,014 ERROR [STDERR] at org.jboss.mq.Connection.sendToServer(Connection.java:920) 00:16:35,014 ERROR [STDERR] at org.jboss.mq.SpyXAResourceManager.addMessage(SpyXAResourceManager.java:113) 00:16:35,014 ERROR [STDERR] at org.jboss.mq.SpySession.sendMessage(SpySession.java:918) 00:16:35,014 ERROR [STDERR] at org.jboss.mq.SpyMessageProducer.send(SpyMessageProducer.java:272) 00:16:35,014 ERROR [STDERR] at org.jboss.mq.SpyMessageProducer.send(SpyMessageProducer.java:206) 00:16:35,014 ERROR [STDERR] at org.jboss.resource.adapter.jms.JmsMessageProducer.send(JmsMessageProducer.java:142) 00:16:35,014 ERROR [STDERR] at emi.mechanical.business.ejb.mdb.impl.MechDealFileBursterImpl.sendMechDealTransaction(MechDealFileBursterImpl.java:377) 00:16:35,014 ERROR [STDERR] at emi.mechanical.business.ejb.mdb.impl.MechDealFileBursterImpl.processXmlFile(MechDealFileBursterImpl.java:157) 00:16:35,014 ERROR [STDERR] at emi.mechanical.business.ejb.mdb.impl.MechDealFileBursterMDB.onMessage(MechDealFileBursterMDB.java:100) 00:16:35,014 ERROR [STDERR] at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) 00:16:35,014 ERROR [STDERR] at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source) 00:16:35,014 ERROR [STDERR] at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source) 00:16:35,014 ERROR [STDERR] at java.lang.reflect.Method.invoke(Unknown Source) 00:16:35,014 ERROR [STDERR] at org.jboss.invocation.Invocation.performCall(Invocation.java:359) 00:16:35,014 ERROR [STDERR] at org.jboss.ejb.MessageDrivenContainer$ContainerInterceptor.invoke(MessageDrivenContainer.java:495) 00:16:35,014 ERROR [STDERR] at org.jboss.resource.connectionmanager.CachedConnectionInterceptor.invoke(CachedConnectionInterceptor.java:158) 00:16:35,014 ERROR [STDERR] at org.jboss.ejb.plugins.CallValidationInterceptor.invoke(CallValidationInterceptor.java:63) 00:16:35,014 ERROR [STDERR] at org.jboss.ejb.plugins.AbstractTxInterceptor.invokeNext(AbstractTxInterceptor.java:121) 00:16:35,014 ERROR [STDERR] at org.jboss.ejb.plugins.AbstractTxInterceptorBMT.invokeNext(AbstractTxInterceptorBMT.java:173) 00:16:35,014 ERROR [STDERR] at org.jboss.ejb.plugins.MessageDrivenTxInterceptorBMT.invoke(MessageDrivenTxInterceptorBMT.java:47) 00:16:35,014 ERROR [STDERR] at org.jboss.ejb.plugins.MessageDrivenInstanceInterceptor.invoke(MessageDrivenInstanceInterceptor.java:116) 00:16:35,014 ERROR [STDERR] at org.jboss.ejb.plugins.RunAsSecurityInterceptor.invoke(RunAsSecurityInterceptor.java:109) 00:16:35,014 ERROR [STDERR] at org.jboss.ejb.plugins.LogInterceptor.invoke(LogInterceptor.java:205) 00:16:35,014 ERROR [STDERR] at org.jboss.ejb.plugins.ProxyFactoryFinderInterceptor.invoke(ProxyFactoryFinderInterceptor.java:138) 00:16:35,014 ERROR [STDERR] at org.jboss.ejb.MessageDrivenContainer.internalInvoke(MessageDrivenContainer.java:402) 00:16:35,014 ERROR [STDERR] at org.jboss.ejb.Container.invoke(Container.java:960) 00:16:35,014 ERROR [STDERR] at org.jboss.ejb.plugins.jms.JMSContainerInvoker.invoke(JMSContainerInvoker.java:1092) 00:16:35,014 ERROR [STDERR] at org.jboss.ejb.plugins.jms.JMSContainerInvoker$MessageListenerImpl.onMessage(JMSContainerInvoker.java:1392) 00:16:35,014 ERROR [STDERR] at org.jboss.jms.asf.StdServerSession.onMessage(StdServerSession.java:266) 00:16:35,014 ERROR [STDERR] at org.jboss.mq.SpyMessageConsumer.sessionConsumerProcessMessage(SpyMessageConsumer.java:906) 00:16:35,014 ERROR [STDERR] at org.jboss.mq.SpyMessageConsumer.addMessage(SpyMessageConsumer.java:170) 00:16:35,014 ERROR [STDERR] at org.jboss.mq.SpySession.run(SpySession.java:323) 00:16:35,014 ERROR [STDERR] at org.jboss.jms.asf.StdServerSession.run(StdServerSession.java:194) 00:16:35,014 ERROR [STDERR] at EDU.oswego.cs.dl.util.concurrent.PooledExecutor$Worker.run(PooledExecutor.java:756) 00:16:35,014 ERROR [STDERR] at java.lang.Thread.run(Unknown Source) 00:16:35,014 ERROR [STDERR] Caused by: java.sql.SQLException: ORA-01460: unimplemented or unreasonable conversion requested 00:16:35,014 ERROR [STDERR] at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:134) 00:16:35,014 ERROR [STDERR] at oracle.jdbc.ttc7.TTIoer.processError(TTIoer.java:289) 00:16:35,014 ERROR [STDERR] at oracle.jdbc.ttc7.Oall7.receive(Oall7.java:573) 00:16:35,014 ERROR [STDERR] at oracle.jdbc.ttc7.TTC7Protocol.doOall7(TTC7Protocol.java:1891) 00:16:35,014 ERROR [STDERR] at oracle.jdbc.ttc7.TTC7Protocol.parseExecuteFetch(TTC7Protocol.java:1093) 00:16:35,014 ERROR [STDERR] at oracle.jdbc.driver.OracleStatement.executeNonQuery(OracleStatement.java:2047) 00:16:35,014 ERROR [STDERR] at oracle.jdbc.driver.OracleStatement.doExecuteOther(OracleStatement.java:1940) 00:16:35,014 ERROR [STDERR] at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:2709) 00:16:35,014 ERROR [STDERR] at oracle.jdbc.driver.OraclePreparedStatement.executeUpdate(OraclePreparedStatement.java:589) 00:16:35,014 ERROR [STDERR] at org.jboss.resource.adapter.jdbc.WrappedPreparedStatement.executeUpdate(WrappedPreparedStatement.java:365) 00:16:35,014 ERROR [STDERR] at org.jboss.mq.pm.jdbc2.PersistenceManager.add(PersistenceManager.java:1172) 00:16:35,014 ERROR [STDERR] at org.jboss.mq.pm.jdbc2.PersistenceManager.add(PersistenceManager.java:1118) 00:16:35,014 ERROR [STDERR] ... 44 more