Skip to Main Content

OEP 12c spatial project deployment error

3007285Feb 1 2016 — edited Feb 1 2016

>

Exception in thread "SpringOsgiExtenderThread-126" org.springframework.beans.Fat

alBeanException: Error in context lifecycle initialization; nested exception is

com.bea.wlevs.ede.api.ConfigurationException:

Invalid statement: "alter query >>RiteRouteDetailsQuery<< start"

Description: specified predicate requires full scan of external source which is

not supported

Cause: specified predicate requires full scan of external source which is not su

pported

Action: please modify the join predicate

        at com.bea.wlevs.spring.ApplicationContextLifecycle.onApplicationEvent(A

pplicationContextLifecycle.java:146)

        at org.springframework.context.event.SimpleApplicationEventMulticaster.m

ulticastEvent(SimpleApplicationEventMulticaster.java:97)

        at org.springframework.context.support.AbstractApplicationContext.publis

hEvent(AbstractApplicationContext.java:324)

        at org.springframework.context.support.AbstractApplicationContext.finish

Refresh(AbstractApplicationContext.java:929)

        at org.springframework.osgi.context.support.AbstractOsgiBundleApplicatio

nContext.finishRefresh(AbstractOsgiBundleApplicationContext.java:235)

        at org.springframework.osgi.context.support.AbstractDelegatedExecutionAp

plicationContext$4.run(AbstractDelegatedExecutionApplicationContext.java:358)

        at org.springframework.osgi.util.internal.PrivilegedUtils.executeWithCus

tomTCCL(PrivilegedUtils.java:85)

        at org.springframework.osgi.context.support.AbstractDelegatedExecutionAp

plicationContext.completeRefresh(AbstractDelegatedExecutionApplicationContext.ja

va:320)

        at org.springframework.osgi.extender.internal.dependencies.startup.Depen

dencyWaiterApplicationContextExecutor$CompleteRefreshTask.run(DependencyWaiterAp

plicationContextExecutor.java:136)

        at java.lang.Thread.run(Thread.java:745)

Caused by: com.bea.wlevs.ede.api.ConfigurationException:

Invalid statement: "alter query >>RiteRouteDetailsQuery<< start"

Description: specified predicate requires full scan of external source which is

not supported

Cause: specified predicate requires full scan of external source which is not su

pported

Action: please modify the join predicate

        at com.oracle.cep.processor.cql.impl.CQLProcessorImpl.activateRules(CQLP

rocessorImpl.java:1041)

        at com.oracle.cep.processor.cql.impl.CQLProcessorImpl.activate(CQLProces

sorImpl.java:1084)

        at com.oracle.cep.processor.cql.impl.CQLProcessorImpl.afterConfiguration

Active(CQLProcessorImpl.java:2790)

        at com.bea.wlevs.spring.ActivationBeanPostProcessor.postProcessAfterCont

extInitialization(ActivationBeanPostProcessor.java:20)

        at com.bea.wlevs.spring.DeferredBeanPostProcessor.afterConfigurationActi

ve(DeferredBeanPostProcessor.java:27)

        at com.bea.wlevs.spring.ApplicationContextLifecycle.onApplicationEvent(A

pplicationContextLifecycle.java:113)

        ... 9 more

My Processor code:

<?xml version="1.0" encoding="UTF-8"?>

<wlevs:config xmlns:wlevs="http://www.bea.com/ns/wlevs/config/application">

  <processor>

    <name>Routematcher</name>

  <rules>

            <view id="CabDetailsView"><![CDATA[       

           ISTREAM(SELECT cabNumber, routeName, latitude, longitude, emailId, com.oracle.cep.cartridge.spatial.Geometry.createPoint(8307, latitude, longitude) as geom FROM Cabdetails_Channel )

            ]]></view>

            <query id="RiteRouteDetailsQuery"><![CDATA[ 

SELECT p.routeName as routeName, p.cabNumber as cabNumber, p.emailId as emailId, com.oracle.cep.cartridge.spatial.Geometry.distance@spatial(s.geom,p.geom) as distance

FROM CabDetailsView [now] as p, RouteCache as s WHERE com.oracle.cep.cartridge.spatial.Geometry.distance@spatial(s.geom,p.geom)<300 ]]></query>

            <query id="WrongRouteDetailsQuery"><![CDATA[ 

SELECT p.routeName as routeName, p.cabNumber as cabNumber, p.emailId as emailId, com.oracle.cep.cartridge.spatial.Geometry.distance@spatial(s.geom,p.geom) as distance

FROM CabDetailsView [now] as p, RouteCache as s WHERE com.oracle.cep.cartridge.spatial.Geometry.distance@spatial(s.geom,p.geom)>300 ]]></query>

        </rules>

    </processor>

    <channel>

        <name>RiteRoute_channel</name>

        <selector>RiteRouteDetailsQuery</selector>

    </channel>

    <channel>

        <name>WrongRoute_channel</name>

        <selector>WrongRouteDetailsQuery</selector>

    </channel>

  </wlevs:config>

Post Details
Locked due to inactivity on Feb 29 2016
Added on Feb 1 2016
0 comments
486 views