org.apache.ojb.broker.PersistenceBrokerSQLException: SQLException during the execution of the query (for org.apache.jetspeed.capabilities.impl.ClientImpl): ORA- 00942: table or view does not exist

portals-jetspeed-user | Lalitha Bourishetty | 2 years ago
tip
Click on the to mark the solution that helps you, Samebug will learn from it.
As a community member, you’ll be rewarded for you help.
  1. 0

    RE: Jetspeed 2.3

    portals-jetspeed-user | 2 years ago | Lalitha Bourishetty
    org.apache.ojb.broker.PersistenceBrokerSQLException: SQLException during the execution of the query (for org.apache.jetspeed.capabilities.impl.ClientImpl): ORA- 00942: table or view does not exist
  2. 0

    RE: Jetspeed 2.3

    portals-jetspeed-user | 2 years ago | Lalitha Bourishetty
    org.apache.ojb.broker.PersistenceBrokerSQLException: SQLException during the execution of the query (for org.apache.jetspeed.capabilities.impl.ClientImpl): ORA- 00942: table or view does not exist

    Root Cause Analysis

    1. org.apache.ojb.broker.PersistenceBrokerSQLException

      SQLException during the execution of the query (for org.apache.jetspeed.capabilities.impl.ClientImpl): ORA- 00942: table or view does not exist

      at org.apache.ojb.broker.accesslayer.JdbcAccessImpl.executeQuery()
    2. ObJectRelationalBridge
      DelegatingPersistenceBroker.getCollectionByQuery
      1. org.apache.ojb.broker.accesslayer.JdbcAccessImpl.executeQuery(JdbcAccessImpl.java:349)
      2. org.apache.ojb.broker.accesslayer.RsQueryObject.performQuery(RsQueryObject.java:74)
      3. org.apache.ojb.broker.accesslayer.RsIterator.<init>(RsIterator.java:185)
      4. org.apache.ojb.broker.core.RsIteratorFactoryImpl.createRsIterator(RsIteratorFactoryImpl.java:58)
      5. org.apache.ojb.broker.core.PersistenceBrokerImpl.getRsIteratorFromQuery(PersistenceBrokerImpl.java:1918)
      6. org.apache.ojb.broker.core.PersistenceBrokerImpl.getIteratorFromQuery(PersistenceBrokerImpl.java:1493)
      7. org.apache.ojb.broker.core.QueryReferenceBroker.getCollectionByQuery(QueryReferenceBroker.java:112)
      8. org.apache.ojb.broker.core.QueryReferenceBroker.getCollectionByQuery(QueryReferenceBroker.java:251)
      9. org.apache.ojb.broker.core.QueryReferenceBroker.getCollectionByQuery(QueryReferenceBroker.java:271)
      10. org.apache.ojb.broker.core.PersistenceBrokerImpl.getCollectionByQuery(PersistenceBrokerImpl.java:1367)
      11. org.apache.ojb.broker.core.DelegatingPersistenceBroker.getCollectionByQuery(DelegatingPersistenceBroker.java:338)
      12. org.apache.ojb.broker.core.DelegatingPersistenceBroker.getCollectionByQuery(DelegatingPersistenceBroker.java:338)
      12 frames
    3. org.springframework.orm
      PersistenceBrokerTemplate.getCollectionByQuery
      1. org.springframework.orm.ojb.PersistenceBrokerTemplate$3.doInPersistenceBroker(PersistenceBrokerTemplate.java:192)
      2. org.springframework.orm.ojb.PersistenceBrokerTemplate.execute(PersistenceBrokerTemplate.java:138)
      3. org.springframework.orm.ojb.PersistenceBrokerTemplate.executeFind(PersistenceBrokerTemplate.java:159)
      4. org.springframework.orm.ojb.PersistenceBrokerTemplate.getCollectionByQuery(PersistenceBrokerTemplate.java:190)
      4 frames
    4. org.apache.jetspeed
      JetspeedCapabilities.getCapabilityMap
      1. org.apache.jetspeed.capabilities.impl.JetspeedCapabilities.getClients(JetspeedCapabilities.java:392)
      2. org.apache.jetspeed.capabilities.impl.JetspeedCapabilities.findClient(JetspeedCapabilities.java:327)
      3. org.apache.jetspeed.capabilities.impl.JetspeedCapabilities.getCapabilityMap(JetspeedCapabilities.java:196)
      3 frames
    5. Java RT
      Method.invoke
      1. sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
      2. sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
      3. sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
      4. java.lang.reflect.Method.invoke(Method.java:497)
      4 frames
    6. Spring AOP
      ReflectiveMethodInvocation.proceed
      1. org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:317)
      2. org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:183)
      3. org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:150)
      3 frames
    7. Spring Tx
      TransactionInterceptor.invoke
      1. org.springframework.transaction.interceptor.TransactionInterceptor$1.proceedWithInvocation(TransactionInterceptor.java:96)
      2. org.springframework.transaction.interceptor.TransactionAspectSupport.invokeWithinTransaction(TransactionAspectSupport.java:260)
      3. org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:94)
      3 frames
    8. Spring AOP
      JdkDynamicAopProxy.invoke
      1. org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)
      2. org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:204)
      2 frames
    9. com.sun.proxy
      $Proxy96.getCapabilityMap
      1. com.sun.proxy.$Proxy96.getCapabilityMap(Unknown Source)
      1 frame
    10. org.apache.jetspeed
      JetspeedServlet.service
      1. org.apache.jetspeed.capabilities.impl.CapabilityValveImpl.invoke(CapabilityValveImpl.java:65)
      2. org.apache.jetspeed.pipeline.JetspeedPipeline$Invocation.invokeNext(JetspeedPipeline.java:242)
      3. org.apache.jetspeed.pipeline.JetspeedPipeline.invoke(JetspeedPipeline.java:163)
      4. org.apache.jetspeed.engine.JetspeedEngine.service(JetspeedEngine.java:219)
      5. org.apache.jetspeed.engine.JetspeedServlet.invoke(JetspeedServlet.java:301)
      6. org.apache.jetspeed.engine.JetspeedServlet.service(JetspeedServlet.java:319)
      6 frames
    11. JavaServlet
      HttpServlet.service
      1. javax.servlet.http.HttpServlet.service(HttpServlet.java:844)
      1 frame
    12. Atmosphere weblogic
      FilterChainImpl.doFilter
      1. weblogic.servlet.internal.StubSecurityHelper$ServletServiceAction.run(StubSecurityHelper.java:280)
      2. weblogic.servlet.internal.StubSecurityHelper$ServletServiceAction.run(StubSecurityHelper.java:254)
      3. weblogic.servlet.internal.StubSecurityHelper.invokeServlet(StubSecurityHelper.java:136)
      4. weblogic.servlet.internal.ServletStubImpl.execute(ServletStubImpl.java:346)
      5. weblogic.servlet.internal.TailFilter.doFilter(TailFilter.java:25)
      6. weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:79)
      6 frames
    13. org.apache.jetspeed
      PortalSessionValidationFilter.doFilter
      1. org.apache.jetspeed.container.session.PortalSessionValidationFilter.doFilter(PortalSessionValidationFilter.java:92)
      1 frame
    14. Atmosphere weblogic
      FilterChainImpl.doFilter
      1. weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:79)
      1 frame
    15. org.apache.jetspeed
      XXSUrlAttackFilter.doFilter
      1. org.apache.jetspeed.engine.servlet.XXSUrlAttackFilter.doFilter(XXSUrlAttackFilter.java:82)
      1 frame
    16. Atmosphere weblogic
      FilterChainImpl.doFilter
      1. weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:79)
      1 frame
    17. org.apache.jetspeed
      ServletRequestCleanupFilter.doFilter
      1. org.apache.jetspeed.util.ServletRequestCleanupService.doFilter(ServletRequestCleanupService.java:146)
      2. org.apache.jetspeed.util.ServletRequestCleanupFilter.doFilter(ServletRequestCleanupFilter.java:52)
      2 frames
    18. Atmosphere weblogic
      WebAppServletContext$ServletInvocationAction.run
      1. weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:79)
      2. weblogic.servlet.internal.WebAppServletContext$ServletInvocationAction.wrapRun(WebAppServletContext.java:3436)
      3. weblogic.servlet.internal.WebAppServletContext$ServletInvocationAction.run(WebAppServletContext.java:3402)
      3 frames
    19. weblogic.security.acl
      AuthenticatedSubject.doAs
      1. weblogic.security.acl.internal.AuthenticatedSubject.doAs(AuthenticatedSubject.java:321)
      1 frame
    20. weblogic.security.service
      SecurityManager.runAs
      1. weblogic.security.service.SecurityManager.runAs(SecurityManager.java:120)
      1 frame
    21. weblogic.servlet.provider
      WlsSubjectHandle.run
      1. weblogic.servlet.provider.WlsSubjectHandle.run(WlsSubjectHandle.java:57)
      1 frame