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

Olivier Dubois - Oscars

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

Junger He-Oracle

Hi Olivier,

Could you send us the application that is easy to reproduce the failure? You can send the mail to [email protected].

It looks like the error happened at the CQL. But it is not a syntax error.

Thanks

Junger