4 Replies Latest reply: Nov 14, 2012 5:29 AM by alexalves RSS

    ISSUE WITH XMLQUERY

    972323
      I have the following CQL in my processor

      <query id="q1"><![CDATA[
          SELECT
              xmlquery(
                  'for $i in /PDRecord where $i/PDName="hello"  return $i/PDName'
                  PASSING BY VALUE 
                      c2 as "."
                   
                  RETURNING CONTENT
              )  XMLData  as c1
          FROM
              channel
      ]]></query>



      The input data is : <PDRecord><PDName>hello</PDName></PDRecord>

      where c1 and c2 are of type xmltype defined in event type .

      The adapter used here is pubsub . When the event get published , I get the following error message


      <Nov 3, 2012 7:02:03 PM GMT+05:30> <Warning> <Ede> <BEA-000000> <Exception for 'eventType=myEvent object=channel kind=PLUS time=5252630450455 c1=<PDRecord><PDName>hello</PDName></PDRecord>, c2=<PDRecord><PDName>hello</PDName></PDRecord> isTotalOrderGuarantee=true' raised by listener = com.oracle.cep.processor.cql.impl.CQLEventReceiver@47881e1
      com.bea.wlevs.ede.api.EventProcessingException: Internal error processing event [eventType=myEvent object=channel kind=PLUS time=5252630450455 c1=<PDRecord><PDName>hello</PDName></PDRecord>, c2=<PDRecord><PDName>hello</PDName></PDRecord> isTotalOrderGuarantee=true] = oracle/i18n/text/OraCollator
           at com.oracle.cep.processor.cql.impl.CQLEventReceiver.sendToEngine(CQLEventReceiver.java:523)
           at com.oracle.cep.processor.cql.impl.CQLEventReceiver.onInsertEvent(CQLEventReceiver.java:257)
           at com.bea.wlevs.processor.impl.EventSenderImpl.sendInsertEventToListener(EventSenderImpl.java:362)
           at com.bea.wlevs.processor.impl.EventSenderImpl.sendInsertEvent(EventSenderImpl.java:333)
           at com.bea.wlevs.ede.spi.AbstractSendEventInterceptor.sendInsertEvent(AbstractSendEventInterceptor.java:79)
           at com.bea.wlevs.eventinspector.EventInspectInterceptor.sendInsertEvent(EventInspectInterceptor.java:133)
           at com.bea.wlevs.ede.spi.AbstractSendEventInterceptor.sendInsertEvent(AbstractSendEventInterceptor.java:79)
           at com.bea.wlevs.monitor.internal.MonitorSendEventInterceptor.sendInsertEvent(MonitorSendEventInterceptor.java:477)
           at com.bea.wlevs.ede.spi.AbstractSendEventInterceptor.sendInsertEvent(AbstractSendEventInterceptor.java:79)
           at com.bea.wlevs.eventstore.recplay.RecordPlaySendEventInterceptor.sendInsertEvent(RecordPlaySendEventInterceptor.java:161)
           at com.bea.wlevs.channel.impl.ChannelImpl.onInsertEvent(ChannelImpl.java:443)
           at com.bea.wlevs.processor.impl.EventSenderImpl.sendInsertEventToListener(EventSenderImpl.java:362)
           at com.bea.wlevs.processor.impl.EventSenderImpl.sendInsertEvent(EventSenderImpl.java:333)
           at com.bea.wlevs.ede.impl.EventSourceEventSenderImpl.sendInsertEvent(EventSourceEventSenderImpl.java:86)
           at com.bea.wlevs.ede.spi.AbstractSendEventInterceptor.sendInsertEvent(AbstractSendEventInterceptor.java:79)
           at com.bea.wlevs.eventinspector.EventInspectInterceptor.sendInsertEvent(EventInspectInterceptor.java:133)
           at com.bea.wlevs.ede.spi.AbstractSendEventInterceptor.sendInsertEvent(AbstractSendEventInterceptor.java:79)
           at com.bea.wlevs.monitor.internal.MonitorSendEventInterceptor.sendInsertEvent(MonitorSendEventInterceptor.java:477)
           at com.bea.wlevs.ede.spi.AbstractSendEventInterceptor.sendInsertEvent(AbstractSendEventInterceptor.java:79)
           at com.bea.wlevs.eventstore.recplay.RecordPlaySendEventInterceptor.sendInsertEvent(RecordPlaySendEventInterceptor.java:161)
           at com.bea.wlevs.adapters.httppubsub.HttpSubAdapter.deliverEvents(HttpSubAdapter.java:166)
           at com.bea.wlevs.adapters.httppubsub.HttpSubAdapter.run(HttpSubAdapter.java:92)
           at com.bea.wlevs.adapters.httppubsub.HttpSubAdapter$$FastClassByCGLIB$$d6027a4e.invoke(<generated>)
           at net.sf.cglib.proxy.MethodProxy.invoke(MethodProxy.java:149)
           at org.springframework.aop.framework.Cglib2AopProxy$CglibMethodInvocation.invokeJoinpoint(Cglib2AopProxy.java:700)
           at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:149)
           at com.bea.wlevs.ede.impl.EventManagerAccessorProxy.invoke(EventManagerAccessorProxy.java:30)
           at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171)
           at com.bea.wlevs.ede.impl.EventBeanProxy.invoke(EventBeanProxy.java:38)
           at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171)
           at org.springframework.aop.framework.Cglib2AopProxy$DynamicAdvisedInterceptor.intercept(Cglib2AopProxy.java:635)
           at com.bea.wlevs.adapters.httppubsub.HttpSubAdapter$$EnhancerByCGLIB$$3a01ee82.run(<generated>)
           at com.bea.wlevs.spring.RunnableBeanPostProcessor$RunnableWrapper.run(RunnableBeanPostProcessor.java:118)
           at weblogic.work.commonj.CommonjWorkManagerImpl$WorkWithListener.run(CommonjWorkManagerImpl.java:204)
           at weblogic.work.SelfTuningWorkManagerImpl$WorkAdapterImpl.run(SelfTuningWorkManagerImpl.java:545)
           at weblogic.work.ExecuteThread.execute(ExecuteThread.java:256)
           at weblogic.work.ExecuteThread.run(ExecuteThread.java:221)
      Caused By: java.lang.NoClassDefFoundError: oracle/i18n/text/OraCollator
           at oracle.xml.xqxp.functions.builtIns.FNUtil.getCollator(FNUtil.java:355)
           at oracle.xml.xqxp.datamodel.OXMLItem.compareValue(OXMLItem.java:989)
           at oracle.xquery.exec.XQueryUtils.compareValue(XQueryUtils.java:663)
           at oracle.xquery.exec.GeneralComparison.compareItem(GeneralComparison.java:266)
           at oracle.xquery.exec.GeneralComparison.compareItemLists(GeneralComparison.java:210)
           at oracle.xquery.exec.GeneralComparison.Evaluate(GeneralComparison.java:177)
           at oracle.xquery.exec.NodeSource.EvaluateFilter(NodeSource.java:265)
           at oracle.xquery.exec.FilterProject$FilterProjectIterator.Fetch(FilterProject.java:113)
           at oracle.xquery.exec.FLWR$FLWRIterator.Fetch(FLWR.java:151)
           at oracle.xquery.exec.ExprSequence$ExprSequenceIterator.Fetch(ExprSequence.java:103)
           at oracle.xquery.exec.OXQuerySequence.next(OXQuerySequence.java:259)
           at oracle.cep.execution.xml.XMLSequence.next(XMLSequence.java:60)
           at oracle.cep.execution.internals.memory.AEval.invokeXQryFunction(AEval.java:1925)
           at oracle.cep.execution.internals.memory.AEval.eval(AEval.java:487)
           at oracle.cep.execution.internals.memory.AEval.eval(AEval.java:337)
           at oracle.cep.execution.operators.Project.run(Project.java:295)
           at oracle.cep.execution.operators.ExecOpt.run(ExecOpt.java:999)
           at oracle.cep.execution.operators.ExecOpt.run(ExecOpt.java:981)
           at oracle.cep.execution.operators.ExecOpt.run(ExecOpt.java:1059)
           at oracle.cep.execution.queues.DirectInteropQueue.runOperator(DirectInteropQueue.java:549)
           at oracle.cep.execution.queues.DirectInteropQueue.enqueue(DirectInteropQueue.java:451)
           at oracle.cep.execution.queues.DirectInteropQueue.enqueue(DirectInteropQueue.java:78)
           at oracle.cep.execution.operators.StreamSource.run(StreamSource.java:708)
           at oracle.cep.execution.operators.ExecOpt.run(ExecOpt.java:1120)
           at oracle.cep.execution.ExecManager.runOperator(ExecManager.java:326)
           at oracle.cep.execution.operators.ExecOptTask.run(ExecOptTask.java:73)
           at oracle.cep.interfaces.input.QueueSource.putNext(QueueSource.java:371)
           at oracle.cep.interfaces.input.QueueSource.putNext(QueueSource.java:296)
           at oracle.cep.interfaces.input.QueueSource.putNext(QueueSource.java:243)
           at oracle.cep.execution.ExecManager.insertBase(ExecManager.java:978)
           at oracle.cep.execution.ExecManager.insertFastBase(ExecManager.java:1088)
           at oracle.cep.execution.ExecManager.insertFast(ExecManager.java:1031)
           at oracle.cep.server.CEPServer.executeDMLBase(CEPServer.java:318)
           at oracle.cep.server.CEPServer.executeDML(CEPServer.java:224)
           at oracle.cep.jdbc.CEPPreparedStatement.executeDMLBase(CEPPreparedStatement.java:972)
           at oracle.cep.jdbc.CEPPreparedStatement.executeDML(CEPPreparedStatement.java:913)
           at com.oracle.cep.processor.cql.impl.CQLEventReceiver.executeDMLBase(CQLEventReceiver.java:548)
           at com.oracle.cep.processor.cql.impl.CQLEventReceiver.sendToEngine(CQLEventReceiver.java:513)
           at com.oracle.cep.processor.cql.impl.CQLEventReceiver.onInsertEvent(CQLEventReceiver.java:257)
           at com.bea.wlevs.processor.impl.EventSenderImpl.sendInsertEventToListener(EventSenderImpl.java:362)
           at com.bea.wlevs.processor.impl.EventSenderImpl.sendInsertEvent(EventSenderImpl.java:333)
           at com.bea.wlevs.ede.spi.AbstractSendEventInterceptor.sendInsertEvent(AbstractSendEventInterceptor.java:78)
           at com.bea.wlevs.eventinspector.EventInspectInterceptor.sendInsertEvent(EventInspectInterceptor.java:132)
           at com.bea.wlevs.ede.spi.AbstractSendEventInterceptor.sendInsertEvent(AbstractSendEventInterceptor.java:78)
           at com.bea.wlevs.monitor.internal.MonitorSendEventInterceptor.sendInsertEvent(MonitorSendEventInterceptor.java:476)
           at com.bea.wlevs.ede.spi.AbstractSendEventInterceptor.sendInsertEvent(AbstractSendEventInterceptor.java:78)
           at com.bea.wlevs.eventstore.recplay.RecordPlaySendEventInterceptor.sendInsertEvent(RecordPlaySendEventInterceptor.java:160)
           at com.bea.wlevs.channel.impl.ChannelImpl.onInsertEvent(ChannelImpl.java:443)
           at com.bea.wlevs.processor.impl.EventSenderImpl.sendInsertEventToListener(EventSenderImpl.java:362)
           at com.bea.wlevs.processor.impl.EventSenderImpl.sendInsertEvent(EventSenderImpl.java:333)
           at com.bea.wlevs.ede.impl.EventSourceEventSenderImpl.sendInsertEvent(EventSourceEventSenderImpl.java:85)
           at com.bea.wlevs.ede.spi.AbstractSendEventInterceptor.sendInsertEvent(AbstractSendEventInterceptor.java:78)
           at com.bea.wlevs.eventinspector.EventInspectInterceptor.sendInsertEvent(EventInspectInterceptor.java:132)
           at com.bea.wlevs.ede.spi.AbstractSendEventInterceptor.sendInsertEvent(AbstractSendEventInterceptor.java:78)
           at com.bea.wlevs.monitor.internal.MonitorSendEventInterceptor.sendInsertEvent(MonitorSendEventInterceptor.java:476)
           at com.bea.wlevs.ede.spi.AbstractSendEventInterceptor.sendInsertEvent(AbstractSendEventInterceptor.java:78)
           at com.bea.wlevs.eventstore.recplay.RecordPlaySendEventInterceptor.sendInsertEvent(RecordPlaySendEventInterceptor.java:160)
           at com.bea.wlevs.adapters.httppubsub.HttpSubAdapter.deliverEvents(HttpSubAdapter.java:167)
           at com.bea.wlevs.adapters.httppubsub.HttpSubAdapter.run(HttpSubAdapter.java:92)
           at com.bea.wlevs.adapters.httppubsub.HttpSubAdapter$$FastClassByCGLIB$$d6027a4e.invoke(<generated>)
           at net.sf.cglib.proxy.MethodProxy.invoke(MethodProxy.java:149)
           at org.springframework.aop.framework.Cglib2AopProxy$CglibMethodInvocation.invokeJoinpoint(Cglib2AopProxy.java:700)
           at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:149)
           at com.bea.wlevs.ede.impl.EventManagerAccessorProxy.invoke(EventManagerAccessorProxy.java:30)
           at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171)
           at com.bea.wlevs.ede.impl.EventBeanProxy.invoke(EventBeanProxy.java:38)
           at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171)
           at org.springframework.aop.framework.Cglib2AopProxy$DynamicAdvisedInterceptor.intercept(Cglib2AopProxy.java:635)
           at com.bea.wlevs.adapters.httppubsub.HttpSubAdapter$$EnhancerByCGLIB$$3a01ee82.run(<generated>)
           at com.bea.wlevs.spring.RunnableBeanPostProcessor$RunnableWrapper.run(RunnableBeanPostProcessor.java:117)
           at weblogic.work.commonj.CommonjWorkManagerImpl$WorkWithListener.run(CommonjWorkManagerImpl.java:204)
           at weblogic.work.SelfTuningWorkManagerImpl$WorkAdapterImpl.run(SelfTuningWorkManagerImpl.java:545)
           at weblogic.work.ExecuteThread.execute(ExecuteThread.java:256)
           at weblogic.work.ExecuteThread.run(ExecuteThread.java:221)
      >




      I have downloaded the orai18n-collation.jar and put in the classpath . but still the error comes