ORA-24801: illegal parameter value in OCI lob function
sheckler Mar 30, 2006 3:04 AMHi 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:
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.<init>(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 [InfoMgrSession@6f55d] 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:
<datasources>
<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>
<password>yyy</password>
<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>
</datasources>
Who can give me a hint on what is the reason for that Runtime Error?
Thanks to all