Skip to Main Content

Integration

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

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

Olivier Dubois - OscarsSep 4 2014 — edited Sep 11 2014

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.*, com.oracle.cep.cartridge.spatial.Geometry.createPoint@Lambert1NORD(a.x, a.y) as geometry ,com.oracle.cep.cartridge.spatial.Geometry.createRectangle@Lambert1NORD( 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 ANYINTERACT@Lambert1NORD(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

Comments

Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Oct 9 2014
Added on Sep 4 2014
1 comment
9,859 views