0 Replies Latest reply on Aug 24, 2009 6:56 AM by lulik

    Error occures while trying to enqueue message (in xml format

      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?