0 Replies Latest reply on Aug 24, 2009 6:33 AM by Lior Vil

    Error occures while trying to enqueue message (in xml format

    Lior Vil Newbie

      We are working on Operation System Solaris: SunOS 5.9
      with jdk1.5.0_11

      Here is a problem:

      In our customer site occured some error, while trying to enqueue payload message (in xml format) into Oracle queue from java code.

      The message which we are trying to enqueue is in Japanese (localAlarmText in xml). Our guess the issue somehow related to character set.
      In Oracle we are using AL16UTF16 charset. This error is inconsistent and has a rare occurrence.
      We tried to reproduce this error, but when inserting this message directly through oracle procedure, message enqueueing successfully.
      Is there some converting occures when message goes through jboss to oracle?

      Here is a part of the stack trace from the jboss-server.log:

      09:50:51,127 ERROR [agent.IncidentCommandConsumer] (Thread-11) Oracle AQ error during enqueue com.watchmark.common.exception.LocalizedException:Oracle AQ error during enqueue|advancedQueue.enqueue.aqException|oracle.AQ.AQOracleSQLException:

      ORA-00604: error occurred at recursive SQL level 1

      ORA-01460: unimplemented or unreasonable conversion requested

      ORA-06512: at "SYS.DBMS_AQIN", line 399

      ORA-06512: at line 1 at com.watchmark.prospect.enterprise.motorola.agent.IncidentCommandConsumer.forwardUnprocessedPayload (Unknown Source)

      at com.watchmark.prospect.enterprise.motorola.agent.IncidentCommandConsumer.processPayload (Unknown Source)

      at com.watchmark.prospect.enterprise.motorola.agent.AbstractObjectConsumer.consume (Unknown Source)

      at com.watchmark.prospect.enterprise.motorola.agent.IncidentCommandConsumer.consume (Unknown Source)

      at com.watchmark.prospect.enterprise.motorola.agent.AbstractConsumerMBeanSupport.perform (Unknown Source)

      at com.watchmark.common.mbean.ThreadServiceMBeanSupport.run(Unknown Source)

      at java.lang.Thread.run(Thread.java:595)

      Here is the relevant XML payload:

      Can someone assist with this issue?