Hi all, I am using JBoss 3.2.7 with Oracle 9.2.0.4 with HAJMS and Oracle for Persistence (oci) and UIL2 InvocationLayer.
Sporadically on about 1 of 1000 messages receiving from a HA Topic the following error occurs: anonymous wrote : 05:42:00,857 ERROR [STDERR] org.jboss.mq.SpyJMSException: Could not load message : 27543 msg=191 soft STORED NON_PERSISTENT queue=TOPIC.JMS_TT2.ID:49.-2147483643 priority=4 lateClone=false hashCode=16774783; - nested throwable: (java.io.IOException: ORA-24801: illegal parameter value in OCI lob function | ) | 05:42:00,857 ERROR [STDERR] at org.jboss.mq.pm.jdbc2.PersistenceManager.loadFromStorage(PersistenceManager.java:1150) | 05:42:00,857 ERROR [STDERR] at org.jboss.mq.server.MessageCache.loadFromStorage(MessageCache.java:411) | 05:42:00,858 ERROR [STDERR] at org.jboss.mq.server.MessageReference.makeHard(MessageReference.java:351) | 05:42:00,858 ERROR [STDERR] at org.jboss.mq.server.MessageReference.getMessage(MessageReference.java:156) | 05:42:00,858 ERROR [STDERR] at org.jboss.mq.server.BasicQueue.setupMessageAcknowledgement(BasicQueue.java:881) | 05:42:00,858 ERROR [STDERR] at org.jboss.mq.server.BasicQueue.receive(BasicQueue.java:488) | 05:42:00,858 ERROR [STDERR] at org.jboss.mq.server.JMSTopic.receive(JMSTopic.java:285) | 05:42:00,859 ERROR [STDERR] at org.jboss.mq.server.ClientConsumer.receive(ClientConsumer.java:222) | 05:42:00,859 ERROR [STDERR] at org.jboss.mq.server.JMSDestinationManager.receive(JMSDestinationManager.java:673) | 05:42:00,859 ERROR [STDERR] at org.jboss.mq.server.JMSServerInterceptorSupport.receive(JMSServerInterceptorSupport.java:226) | 05:42:00,859 ERROR [STDERR] at org.jboss.mq.security.ServerSecurityInterceptor.receive(ServerSecurityInterceptor.java:100) | 05:42:00,859 ERROR [STDERR] at org.jboss.mq.server.TracingInterceptor.receive(TracingInterceptor.java:570) | 05:42:00,860 ERROR [STDERR] at org.jboss.mq.server.JMSServerInvoker.receive(JMSServerInvoker.java:226) | 05:42:00,860 ERROR [STDERR] at org.jboss.mq.il.uil2.ServerSocketManagerHandler.handleMsg(ServerSocketManagerHandler.java:149) | 05:42:00,860 ERROR [STDERR] at org.jboss.mq.il.uil2.SocketManager$ReadTask.handleMsg(SocketManager.java:374) | 05:42:00,860 ERROR [STDERR] at org.jboss.mq.il.uil2.msgs.BaseMsg.run(BaseMsg.java:377) | 05:42:00,860 ERROR [STDERR] at EDU.oswego.cs.dl.util.concurrent.PooledExecutor$Worker.run(PooledExecutor.java:748) | 05:42:00,861 ERROR [STDERR] at java.lang.Thread.run(Thread.java:534) | 05:42:00,861 ERROR [STDERR] Caused by: java.io.IOException: ORA-24801: illegal parameter value in OCI lob function | 05:42:00,861 ERROR [STDERR] at oracle.jdbc.dbaccess.DBError.SQLToIOException(DBError.java:717) | 05:42:00,861 ERROR [STDERR] at oracle.jdbc.driver.OracleBlobInputStream.needBytes(OracleBlobInputStream.java:249) | 05:42:00,862 ERROR [STDERR] at oracle.jdbc.driver.OracleBufferedStream.read(OracleBufferedStream.java:158) | 05:42:00,862 ERROR [STDERR] at java.io.ObjectInputStream$PeekInputStream.read(ObjectInputStream.java:2150) | 05:42:00,862 ERROR [STDERR] at java.io.ObjectInputStream$PeekInputStream.readFully(ObjectInputStream.java:2163) | 05:42:00,862 ERROR [STDERR] at java.io.ObjectInputStream$BlockDataInputStream.readShort(ObjectInputStream.java:2631) | 05:42:00,863 ERROR [STDERR] at java.io.ObjectInputStream.readStreamHeader(ObjectInputStream.java:734) | 05:42:00,863 ERROR [STDERR] at java.io.ObjectInputStream.(ObjectInputStream.java:253) | 05:42:00,863 ERROR [STDERR] at org.jboss.mq.pm.jdbc2.PersistenceManager.extractMessage(PersistenceManager.java:536) | 05:42:00,863 ERROR [STDERR] at org.jboss.mq.pm.jdbc2.PersistenceManager.loadFromStorage(PersistenceManager.java:1142) | 05:42:00,863 ERROR [STDERR] ... 17 more | 05:42:00,873 ERROR [EMAIL PROTECTED] Unable to get GeoTripel:Could not load message : 27543 msg=191 soft STORED NON_PERSISTENT queue=TOPIC.JMS_TT2.ID:49.-2147483643 priority=4 lateClone=false hashCode=16774783; - nested throwable: (java.io.IOException: ORA-24801: illegal parameter value in OCI lob function | ) | DataSource for JMS: anonymous wrote : | <local-tx-datasource> | <jndi-name>OracleJMSDS</jndi-name> | <connection-url>jdbc:oracle:oci8:@cmd-dbr1</connection-url> | <driver-class>oracle.jdbc.driver.OracleDriver</driver-class> | <user-name>xxx</user-name> | yyy | <check-valid-connection-sql>select table_name from all_tables where owner = 'xxx'</check-valid-connection-sql> | <new-connection-sql>select table_name from all_tables where owner = 'xxx'</new-connection-sql> | <exception-sorter-class-name>org.jboss.resource.adapter.jdbc.vendor.OracleExceptionSorter</exception-sorter-class-name> | <track-statements>nowarn</track-statements> | <set-tx-query-timeout>false</set-tx-query-timeout> | <min-pool-size>1</min-pool-size> | <max-pool-size>30</max-pool-size> | <blocking-timeout-millis>30000</blocking-timeout-millis> | <idle-timeout-minutes>10</idle-timeout-minutes> | </local-tx-datasource> | | Who can give me a hint on what is the reason for that Runtime Error? Thanks to all View the original post : http://www.jboss.com/index.html?module=bb&op=viewtopic&p=3933613#3933613 Reply to the post : http://www.jboss.com/index.html?module=bb&op=posting&mode=reply&p=3933613 ------------------------------------------------------- This SF.Net email is sponsored by xPML, a groundbreaking scripting language that extends applications into web and mobile media. Attend the live webcast and join the prime developer group breaking into this new coding territory! http://sel.as-us.falkag.net/sel?cmd=lnk&kid=110944&bid=241720&dat=121642 _______________________________________________ JBoss-user mailing list JBoss-user@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/jboss-user