0 Replies Latest reply: Aug 24, 2009 6:56 AM by Lior Vil RSS

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
jboss-4.0.5.GA


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:

<EAPEventMessage CorrelationId="1522872101">
 <ActionableAlarm AlarmID="9520">
 <Alarm state="Outstanding" domain="Domain dsaemsfms1_ns:.dsomcr2_NE_Domain" ocName="dsaemsfms1_ns:.dsomcr2_OC" saTotal="17" userText="" eventDate="2009-08-01" eventTime="09:50:45" eventType="QualityofServiceAlarm" identifier="138360" alarmOrigin="IncomingAlarm" operatorNote="" managedObject="OMCR220 dsaemsfms1_ns:.omcr_2 CBSC CBSC-20021 BTS BTS-596 SECTOR SECTOR-596-2 CARRIER CARRIER-596-2-
225" probableCause="ThresholdCrossed" problemStatus="Not Handled" additionalText="Interference Canceller Unable to Cancel All Interferers" escalatedAlarm="false"
 localAlarmText="\feff \0049\006e\0074\0065\0072\0066\0065\0072\0065\006e\0063\0065\0020\0043\0061 \006e\0063\0065\0
06c\006c\0065\0072\0020\0055\006e\0061\0062\006c\0065\0020 \0074\006f\0020\0043\0061\006e\0063\0065\
006c\0020\0041\006c\006c\0020\0049 \006e\0074\0065\0072\0066\0065\0072\0065\0072\0073" originalSeverity="Warning" problemOccurence="18" originalEventDate="2009-07-07" originalEventTime="08:57:45" perceivedSeverity="Warning" securtiyProbableCause="AuthenticationFailure" notificationIdentifier="95209999" correlatedNotificiations="" alarmReportClearanceReceived="false">
 <specificProblems EventIDCode="0" EntityClassDefinition=" ">
 <specificProblem SpecificProblem="9520 - Interference Canceller Unable to Cancel All Interferers"/> </specificProblems>
 <TargetEntity targetEntity="OMCR220 dsaemsfms1_ns:.omcr_2 CBSC CBSC-20021 BTS BTS-596 SECTOR SECTOR-596-2 CARRIER CARRIER-596-2-
225"/>
 </Alarm>
 <Device DeviceID="" DeviceType="Mate Device"/>
 </ActionableAlarm>
</EAPEventMessage>

Can someone assist with this issue?