0 Replies Latest reply on Mar 30, 2006 3:04 AM by Stefan Heckler

    ORA-24801: illegal parameter value in OCI lob function

    Stefan Heckler Novice

      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:


      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