0 Replies Latest reply: Jul 4, 2014 4:50 AM by User13512745-Oracle RSS

    Problem to get case activities list

    User13512745-Oracle

      Anyone know how to solve the issue below?    I have already applied patches (14526899, 14791221)

      Unable to find records in table.

      Could not find records in table using query select activityDefinition from CaseA

      ctivityDefinition activityDefinition  where ((EXISTS (select activityInstance fr

      om CaseActivityInstance activityInstance where activityInstance.caseId = :caseId

      and activityDefinition.definitionId = activityInstance.activityDefinitionId and

      activityDefinition.isManual = 'Y'))  OR (activityDefinition.isManual = 'Y' and

      activityDefinition.isCaseSpecific = 'N' and activityDefinition.isConditional = '

      N' ) OR (EXISTS (select caseAssociation from activityDefinition.caseActivityInCa

      seDefinitionList caseAssociation where caseAssociation.caseDefinitionId = :caseD

      efinitionId and activityDefinition.isManual = 'Y' and activityDefinition.isCondi

      tional = 'N'))).

      Contact system administrator for assistance.

       

              at oracle.bpm.casemgmt.persistence.CasePersistence.findWithQuery(CasePer

      sistence.java:401)

              at oracle.bpm.casemgmt.persistence.CasePersistence.findWithQuery(CasePer

      sistence.java:312)

              at sun.reflect.GeneratedMethodAccessor1495.invoke(Unknown Source)

              at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAcces

      sorImpl.java:25)

              at java.lang.reflect.Method.invoke(Method.java:597)

              at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflecti

      on(AopUtils.java:307)

              at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJo

      inpoint(ReflectiveMethodInvocation.java:182)

              at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(

      ReflectiveMethodInvocation.java:149)

              at oracle.bpel.services.workflow.common.WorkflowServiceCacheEventAdvice.

      invoke(WorkflowServiceCacheEventAdvice.java:102)

              at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(

      ReflectiveMethodInvocation.java:171)

              at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynami

      cAopProxy.java:204)

              at com.sun.proxy.$Proxy511.findWithQuery(Unknown Source)

              at oracle.bpm.casemgmt.caseactivity.ActivityListingUtil.executeQuery(Act

      ivityListingUtil.java:236)

              at oracle.bpm.casemgmt.caseactivity.ActivityListingUtil.findCaseActiviti

      es(ActivityListingUtil.java:120)

              at oracle.bpm.casemgmt.impl.CaseActivityServiceImpl.getCaseActivities(Ca

      seActivityServiceImpl.java:221)

              at sun.reflect.GeneratedMethodAccessor2219.invoke(Unknown Source)

              at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAcces

      sorImpl.java:25)

              at java.lang.reflect.Method.invoke(Method.java:597)

              at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflecti

      on(AopUtils.java:307)

              at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJo

      inpoint(ReflectiveMethodInvocation.java:182)

              at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(

      ReflectiveMethodInvocation.java:149)

              at oracle.bpm.casemgmt.interceptors.CaseServiceAdvice.invoke(CaseService

      Advice.java:195)

              at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(

      ReflectiveMethodInvocation.java:171)

              at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynami

      cAopProxy.java:204)

              at com.sun.proxy.$Proxy345.getCaseActivities(Unknown Source)

              at sun.reflect.GeneratedMethodAccessor2219.invoke(Unknown Source)

              at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAcces

      sorImpl.java:25)

              at java.lang.reflect.Method.invoke(Method.java:597)

              at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflecti

      on(AopUtils.java:307)

              at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJo

      inpoint(ReflectiveMethodInvocation.java:182)

              at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(

      ReflectiveMethodInvocation.java:149)

              at oracle.bpel.services.workflow.common.WorkflowServiceCacheEventAdvice.

      invoke(WorkflowServiceCacheEventAdvice.java:102)

              at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(

      ReflectiveMethodInvocation.java:171)

              at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynami

      cAopProxy.java:204)

              at com.sun.proxy.$Proxy570.getCaseActivities(Unknown Source)

              at oracle.bpm.casemgmt.ejb.CaseManagementService.getCaseActivities(CaseM

      anagementService.java:603)

              at sun.reflect.GeneratedMethodAccessor2221.invoke(Unknown Source)

              at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAcces

      sorImpl.java:25)

              at java.lang.reflect.Method.invoke(Method.java:597)

              at com.bea.core.repackaged.springframework.aop.support.AopUtils.invokeJo

      inpointUsingReflection(AopUtils.java:310)

              at com.bea.core.repackaged.springframework.aop.framework.ReflectiveMetho

      dInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:182)

              at com.bea.core.repackaged.springframework.aop.framework.ReflectiveMetho

      dInvocation.proceed(ReflectiveMethodInvocation.java:149)

              at com.bea.core.repackaged.springframework.aop.support.DelegatingIntrodu

      ctionInterceptor.doProceed(DelegatingIntroductionInterceptor.java:131)

              at com.bea.core.repackaged.springframework.aop.support.DelegatingIntrodu

      ctionInterceptor.invoke(DelegatingIntroductionInterceptor.java:119)

              at com.bea.core.repackaged.springframework.aop.framework.ReflectiveMetho

      dInvocation.proceed(ReflectiveMethodInvocation.java:171)

              at com.oracle.pitchfork.spi.MethodInvocationVisitorImpl.visit(MethodInvo

      cationVisitorImpl.java:34)

              at weblogic.ejb.container.injection.EnvironmentInterceptorCallbackImpl.c

      allback(EnvironmentInterceptorCallbackImpl.java:54)

              at com.oracle.pitchfork.spi.EnvironmentInterceptor.invoke(EnvironmentInt

      erceptor.java:42)

              at com.bea.core.repackaged.springframework.aop.framework.ReflectiveMetho

      dInvocation.proceed(ReflectiveMethodInvocation.java:171)

              at com.bea.core.repackaged.springframework.aop.interceptor.ExposeInvocat

      ionInterceptor.invoke(ExposeInvocationInterceptor.java:89)

              at com.bea.core.repackaged.springframework.aop.framework.ReflectiveMetho

      dInvocation.proceed(ReflectiveMethodInvocation.java:171)

              at com.bea.core.repackaged.springframework.aop.support.DelegatingIntrodu

      ctionInterceptor.doProceed(DelegatingIntroductionInterceptor.java:131)

              at com.bea.core.repackaged.springframework.aop.support.DelegatingIntrodu

      ctionInterceptor.invoke(DelegatingIntroductionInterceptor.java:119)

              at com.bea.core.repackaged.springframework.aop.framework.ReflectiveMetho

      dInvocation.proceed(ReflectiveMethodInvocation.java:171)

              at com.bea.core.repackaged.springframework.aop.framework.JdkDynamicAopPr

      oxy.invoke(JdkDynamicAopProxy.java:204)

              at com.sun.proxy.$Proxy327.getCaseActivities(Unknown Source)

              at oracle.bpm.casemgmt.ejb.CaseManagementService_m764e8_ICaseServiceImpl

      .__WL_invoke(Unknown Source)

              at weblogic.ejb.container.internal.SessionRemoteMethodInvoker.invoke(Ses

      sionRemoteMethodInvoker.java:40)

              at oracle.bpm.casemgmt.ejb.CaseManagementService_m764e8_ICaseServiceImpl

      .getCaseActivities(Unknown Source)

              at oracle.bpm.casemgmt.ejb.CaseManagementService_m764e8_ICaseServiceImpl

      _WLSkel.invoke(Unknown Source)

              at weblogic.rmi.internal.ServerRequest.sendReceive(ServerRequest.java:17

      4)

              ... 286 more

      Caused by: Exception [EclipseLink-6029] (Eclipse Persistence Services - 2.3.1.v2

      0111018-r10243): org.eclipse.persistence.exceptions.QueryException

      Exception Description: A reference class must be provided.

              at org.eclipse.persistence.exceptions.QueryException.referenceClassMissi

      ng(QueryException.java:1031)

              at org.eclipse.persistence.queries.ObjectLevelReadQuery.checkDescriptor(

      ObjectLevelReadQuery.java:739)

              at org.eclipse.persistence.queries.ObjectLevelReadQuery.changeDescriptor

      (ObjectLevelReadQuery.java:859)

              at org.eclipse.persistence.internal.jpa.parsing.ParseTree.initBaseExpres

      sion(ParseTree.java:113)

              at org.eclipse.persistence.internal.jpa.parsing.JPQLParseTree.populateRe

      adQueryInternal(JPQLParseTree.java:107)

              at org.eclipse.persistence.internal.jpa.parsing.JPQLParseTree.populateSu

      bquery(JPQLParseTree.java:70)

              at org.eclipse.persistence.internal.jpa.parsing.SubqueryNode.getReportQu

      ery(SubqueryNode.java:42)

              at org.eclipse.persistence.internal.jpa.parsing.ExistsNode.generateExpre

      ssion(ExistsNode.java:62)

              at org.eclipse.persistence.internal.jpa.parsing.OrNode.generateExpressio

      n(OrNode.java:76)

              at org.eclipse.persistence.internal.jpa.parsing.WhereNode.generateExpres

      sion(WhereNode.java:48)

              at org.eclipse.persistence.internal.jpa.parsing.ParseTree.generateExpres

      sion(ParseTree.java:367)

              at org.eclipse.persistence.internal.jpa.parsing.ParseTree.setSelectionCr

      iteriaForQuery(ParseTree.java:545)

              at org.eclipse.persistence.internal.jpa.parsing.JPQLParseTree.populateRe

      adQueryInternal(JPQLParseTree.java:119)

              at org.eclipse.persistence.internal.jpa.parsing.JPQLParseTree.populateQu

      ery(JPQLParseTree.java:84)

              at org.eclipse.persistence.internal.jpa.EJBQueryImpl.buildEJBQLDatabaseQ

      uery(EJBQueryImpl.java:219)

              at org.eclipse.persistence.internal.jpa.EJBQueryImpl.buildEJBQLDatabaseQ

      uery(EJBQueryImpl.java:190)

              at org.eclipse.persistence.internal.jpa.EJBQueryImpl.<init>(EJBQueryImpl

      .java:142)

              at org.eclipse.persistence.internal.jpa.EJBQueryImpl.<init>(EJBQueryImpl

      .java:126)

              at org.eclipse.persistence.internal.jpa.EntityManagerImpl.createQuery(En

      tityManagerImpl.java:1475)

              at sun.reflect.GeneratedMethodAccessor1478.invoke(Unknown Source)

              at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAcces

      sorImpl.java:25)

              at java.lang.reflect.Method.invoke(Method.java:597)

              at weblogic.deployment.BasePersistenceContextProxyImpl.invoke(BasePersis

      tenceContextProxyImpl.java:111)

              at weblogic.deployment.TransactionalEntityManagerProxyImpl.invoke(Transa

      ctionalEntityManagerProxyImpl.java:78)

              at weblogic.deployment.BasePersistenceContextProxyImpl.invoke(BasePersis

      tenceContextProxyImpl.java:92)

              at weblogic.deployment.TransactionalEntityManagerProxyImpl.invoke(Transa

      ctionalEntityManagerProxyImpl.java:18)

              at com.sun.proxy.$Proxy146.createQuery(Unknown Source)

              at oracle.bpm.casemgmt.persistence.CasePersistence.findWithQuery(CasePer

      sistence.java:384)

              ... 346 more