We are working on Operation System Solaris: SunOS 5.9
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)
Here is the relevant XML payload:
Can someone assist with this issue?