This site is currently read-only as we are migrating to Oracle Forums for an improved community experience. You will not be able to initiate activity until January 30th, when you will be able to use this site as normal.

    Forum Stats

  • 3,890,116 Users
  • 2,269,775 Discussions
  • 7,916,823 Comments

Discussions

SPATIAL : External fault handler failed: oracle.cep.execution.ExecException

Olivier Dubois - Oscars
Olivier Dubois - Oscars Member Posts: 12 Blue Ribbon
edited Sep 11, 2014 5:22AM in Complex Event Processing

Hi,

I am using a cartesian context with this content :

<spatial:context id="Lambert1NORD" anyinteract-tolerance="0.01" cartesian="true"  srid="41013" tolerance="0.01"/>

I want to detect if a point is anyinteracting a rectangle. Here are my two queries :

        <![CDATA[
            istream(
            select a.*, [email protected]RD(a.x, a.y) as geometry ,[email protected]t1NORD( 613000.0d, 146000.0d,618000.0d, 148000.0d) as rectangle
            from inputchannel[now] as a
            where a.x is not null and a.y is not null
            )
        ]]>
    </view>
   


    <query id="QueryInput"><![CDATA[
           istream(
            select i.nom, i.refSource, i.dateCurrentPos, i.x, i.y, 0d as distance
            from ViewVehicule[now] as i
            WHERE [email protected](i.geometry, i.rectangle, 5.0d)=true
            )
            ]]></query>

It seems to give my the first answer, but after I receive a big stack  with this :

ontext for "ApplicationFormation1.Project3" was started successfully>
VÚhicule: Acquisition Radar(S4) - CDG / ENV 7 : 04/09/2014 17:09:37 [0,000000]--
> X=614373,500000 Y=146004,500000
<Sep 4, 2014 5:05:38 PM CEST> <Warning> <CQLServerTrace> <BEA-000000> <External
fault handler failed: oracle.cep.execution.ExecException: >
<Sep 4, 2014 5:05:38 PM CEST> <Warning> <CQLServerTrace> <BEA-000000> <
oracle.cep.execution.ExecException:
        at oracle.cep.execution.operators.Select.run(Select.java:468)
        at oracle.cep.execution.operators.ExecOpt.run(ExecOpt.java:1080)
        at oracle.cep.execution.operators.ExecOpt.run(ExecOpt.java:1062)
        at oracle.cep.execution.operators.ExecOpt.run(ExecOpt.java:1140)
        at oracle.cep.execution.queues.DirectInteropQueue.runOperator(DirectInte
ropQueue.java:573)
        at oracle.cep.execution.queues.DirectInteropQueue.enqueue(DirectInteropQ
ueue.java:457)
        at oracle.cep.execution.queues.DirectInteropQueue.enqueue(DirectInteropQ
ueue.java:84)
        at oracle.cep.execution.operators.RangeWindow.run(RangeWindow.java:537)
        at oracle.cep.execution.operators.ExecOpt.run(ExecOpt.java:1080)
        at oracle.cep.execution.operators.ExecOpt.run(ExecOpt.java:1062)
        at oracle.cep.execution.operators.ExecOpt.run(ExecOpt.java:1140)
        at oracle.cep.execution.queues.DirectInteropQueue.runOperator(DirectInte
ropQueue.java:573)
        at oracle.cep.execution.queues.DirectInteropQueue.enqueue(DirectInteropQ
ueue.java:457)
        at oracle.cep.execution.queues.DirectInteropQueue.enqueue(DirectInteropQ
ueue.java:84)
        at oracle.cep.execution.operators.ViewStrmSrc.run(ViewStrmSrc.java:341)
        at oracle.cep.execution.operators.ExecOpt.run(ExecOpt.java:1080)
        at oracle.cep.execution.operators.ExecOpt.run(ExecOpt.java:1062)
        at oracle.cep.execution.operators.ExecOpt.run(ExecOpt.java:1140)
        at oracle.cep.execution.queues.DirectInteropQueue.runOperator(DirectInte
ropQueue.java:573)
        at oracle.cep.execution.queues.DirectInteropQueue.enqueue(DirectInteropQ
ueue.java:457)
        at oracle.cep.execution.queues.DirectInteropQueue.enqueue(DirectInteropQ
ueue.java:84)
        at oracle.cep.execution.operators.IStream.run(IStream.java:304)
        at oracle.cep.execution.operators.ExecOpt.run(ExecOpt.java:1080)
        at oracle.cep.execution.operators.ExecOpt.run(ExecOpt.java:1062)
        at oracle.cep.execution.operators.ExecOpt.run(ExecOpt.java:1140)
        at oracle.cep.execution.queues.DirectInteropQueue.runOperator(DirectInte
ropQueue.java:573)
        at oracle.cep.execution.queues.DirectInteropQueue.enqueue(DirectInteropQ
ueue.java:457)
        at oracle.cep.execution.queues.DirectInteropQueue.enqueue(DirectInteropQ
ueue.java:84)
        at oracle.cep.execution.operators.Project.run(Project.java:459)
        at oracle.cep.execution.operators.ExecOpt.run(ExecOpt.java:1080)
        at oracle.cep.execution.operators.ExecOpt.run(ExecOpt.java:1062)
        at oracle.cep.execution.operators.ExecOpt.run(ExecOpt.java:1140)
        at oracle.cep.execution.queues.DirectInteropQueue.runOperator(DirectInte
ropQueue.java:573)
        at oracle.cep.execution.queues.DirectInteropQueue.enqueue(DirectInteropQ
ueue.java:457)
        at oracle.cep.execution.queues.DirectInteropQueue.enqueue(DirectInteropQ
ueue.java:84)
        at oracle.cep.execution.operators.Select.run(Select.java:553)
        at oracle.cep.execution.operators.ExecOpt.run(ExecOpt.java:1080)
        at oracle.cep.execution.operators.ExecOpt.run(ExecOpt.java:1062)
        at oracle.cep.execution.operators.ExecOpt.run(ExecOpt.java:1140)
        at oracle.cep.execution.queues.DirectInteropQueue.runOperator(DirectInte
ropQueue.java:573)
        at oracle.cep.execution.queues.DirectInteropQueue.enqueue(DirectInteropQ
ueue.java:457)
        at oracle.cep.execution.queues.DirectInteropQueue.enqueue(DirectInteropQ
ueue.java:84)
        at oracle.cep.execution.operators.RangeWindow.run(RangeWindow.java:537)
        at oracle.cep.execution.operators.ExecOpt.run(ExecOpt.java:1080)
        at oracle.cep.execution.operators.ExecOpt.run(ExecOpt.java:1062)
        at oracle.cep.execution.operators.ExecOpt.run(ExecOpt.java:1140)
        at oracle.cep.execution.queues.DirectInteropQueue.runOperator(DirectInte
ropQueue.java:573)
        at oracle.cep.execution.queues.DirectInteropQueue.enqueue(DirectInteropQ
ueue.java:457)
        at oracle.cep.execution.queues.DirectInteropQueue.enqueue(DirectInteropQ
ueue.java:84)
        at oracle.cep.execution.operators.StreamSource.run(StreamSource.java:903
)
        at oracle.cep.execution.operators.ExecOpt.run(ExecOpt.java:1216)
        at oracle.cep.execution.ExecManager.runOperator(ExecManager.java:357)
        at oracle.cep.execution.operators.ExecOptTask.run(ExecOptTask.java:82)
        at oracle.cep.interfaces.input.QueueSource.putNext(QueueSource.java:423)

        at oracle.cep.interfaces.input.QueueSource.putNext(QueueSource.java:320)

        at oracle.cep.interfaces.input.QueueSource.putNext(QueueSource.java:267)

        at oracle.cep.execution.ExecManager.insertBase(ExecManager.java:1282)
        at oracle.cep.execution.ExecManager.insertFastBase(ExecManager.java:1392
)
        at oracle.cep.execution.ExecManager.insertFast(ExecManager.java:1335)
        at oracle.cep.server.CEPServer.executeDMLBase(CEPServer.java:327)
        at oracle.cep.server.CEPServer.executeDML(CEPServer.java:233)
        at oracle.cep.jdbc.CEPPreparedStatement.executeDMLBase(CEPPreparedStatem
ent.java:978)
        at oracle.cep.jdbc.CEPPreparedStatement.executeDML(CEPPreparedStatement.
java:919)
        at com.oracle.cep.processor.cql.impl.CQLEventReceiver.executeDMLBase(CQL
EventReceiver.java:562)
        at com.oracle.cep.processor.cql.impl.CQLEventReceiver.sendToEngine(CQLEv
entReceiver.java:523)
        at com.oracle.cep.processor.cql.impl.CQLEventReceiver.onInsertEvent(CQLE
ventReceiver.java:259)
        at com.bea.wlevs.processor.impl.EventSenderImpl.sendInsertEventToListene
r(EventSenderImpl.java:583)
        at com.bea.wlevs.processor.impl.EventSenderImpl.sendInsertEvent(EventSen
derImpl.java:291)
        at com.bea.wlevs.ede.spi.AbstractSendEventInterceptor.sendInsertEvent(Ab
stractSendEventInterceptor.java:84)
        at com.bea.wlevs.eventstore.recplay.RecordPlaySendEventInterceptor.sendI
nsertEvent(RecordPlaySendEventInterceptor.java:160)
        at com.bea.wlevs.ede.spi.AbstractSendEventInterceptor.sendInsertEvent(Ab
stractSendEventInterceptor.java:84)
        at com.bea.wlevs.eventinspector.EventInspectInterceptor.sendInsertEvent(
EventInspectInterceptor.java:131)
        at com.bea.wlevs.ede.spi.AbstractSendEventInterceptor.sendInsertEvent(Ab
stractSendEventInterceptor.java:84)
        at com.bea.wlevs.monitor.internal.MonitorSendEventInterceptor.sendInsert
Event(MonitorSendEventInterceptor.java:476)
        at com.bea.wlevs.channel.impl.ChannelImpl.onInsertEvent(ChannelImpl.java
:459)
        at com.bea.wlevs.processor.impl.EventSenderImpl.sendInsertEventToListene
r(EventSenderImpl.java:583)
        at com.bea.wlevs.processor.impl.EventSenderImpl.sendInsertEvent(EventSen
derImpl.java:291)
        at com.bea.wlevs.ede.impl.EventSourceEventSenderImpl.sendInsertEvent(Eve
ntSourceEventSenderImpl.java:85)
        at com.bea.wlevs.ede.spi.AbstractSendEventInterceptor.sendInsertEvent(Ab
stractSendEventInterceptor.java:84)
        at com.bea.wlevs.eventstore.recplay.RecordPlaySendEventInterceptor.sendI
nsertEvent(RecordPlaySendEventInterceptor.java:160)
        at com.bea.wlevs.ede.spi.AbstractSendEventInterceptor.sendInsertEvent(Ab
stractSendEventInterceptor.java:84)
        at com.bea.wlevs.eventinspector.EventInspectInterceptor.sendInsertEvent(
EventInspectInterceptor.java:131)
        at com.bea.wlevs.ede.spi.AbstractSendEventInterceptor.sendInsertEvent(Ab
stractSendEventInterceptor.java:84)
        at com.bea.wlevs.monitor.internal.MonitorSendEventInterceptor.sendInsert
Event(MonitorSendEventInterceptor.java:476)
        at fr.adp.oep.formation3.DatabaseAdapter.readDatabase(DatabaseAdapter.ja
va:164)
        at fr.adp.oep.formation3.DatabaseAdapter.run(DatabaseAdapter.java:90)
        at fr.adp.oep.formation3.DatabaseAdapter$$FastClassByCGLIB$$7b8987bf.inv
oke(<generated>)
        at net.sf.cglib.proxy.MethodProxy.invoke(MethodProxy.java:149)
        at org.springframework.aop.framework.Cglib2AopProxy$CglibMethodInvocatio
n.invokeJoinpoint(Cglib2AopProxy.java:689)
        at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(
ReflectiveMethodInvocation.java:150)
        at com.bea.wlevs.ede.impl.EventManagerAccessorProxy.invoke(EventManagerA
ccessorProxy.java:30)
        at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(
ReflectiveMethodInvocation.java:172)
        at com.bea.wlevs.ede.impl.EventBeanProxy.invoke(EventBeanProxy.java:38)
        at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(
ReflectiveMethodInvocation.java:172)
        at org.springframework.aop.framework.Cglib2AopProxy$DynamicAdvisedInterc
eptor.intercept(Cglib2AopProxy.java:622)
        at fr.adp.oep.formation3.DatabaseAdapter$$EnhancerByCGLIB$$553045ce.run(
<generated>)
        at com.bea.wlevs.spring.RunnableBeanPostProcessor$RunnableWrapper.run(Ru
nnableBeanPostProcessor.java:117)
        at weblogic.work.commonj.CommonjWorkManagerImpl$WorkWithListener.run(Com
monjWorkManagerImpl.java:204)
        at weblogic.work.SelfTuningWorkManagerImpl$WorkAdapterImpl.run(SelfTunin
gWorkManagerImpl.java:548)
        at weblogic.work.ExecuteThread.execute(ExecuteThread.java:311)
        at weblogic.work.ExecuteThread.run(ExecuteThread.java:263)

What is wrong with this ?

Olivier

Answers

This discussion has been closed.