2 Replies Latest reply: Jun 23, 2014 7:05 AM by marco.bonadonna RSS

    Case UI in BMP Workspace not working

    marco.bonadonna

      Hi blazers,

       

      my system specs:

       

      OS: Red Hat Enterprise Linux Server release 6.4 (Santiago)

      WLS: 10.3.6.0.8

      SOA:  11.1.1.7.3

      JVM: JROCKIT 1.6.0_71

       

      SELECT version, status, owner FROM schema_version_registry where owner = 'FMW1_SOAINFRA'; ==>

      11.1.1.7.0VALIDFMW1_SOAINFRA

       

       

      I've just tried to access the Case page into my BPM Workspace console, but I get the following exception:

       

      Messages for this page are listed below.

      Error

      Error occured while fetching Case List

      Error

      Error occured while fetching Case List

      Error

      Error occured while fetching Case List

      Error

      Error occured while fetching Case List

       

      and looking into the log files:

       

      <Jun 20, 2014 1:47:21 PM CEST> <Error> <oracle.bpm.casemgmt.instance> <BEA-000000> <Exception BPM-73405

      1)

      Error in quering cases.

      Error in querying cases.

      Please check the case query parameters.

              at oracle.bpm.casemgmt.impl.CaseInstanceServiceImpl.queryCase(CaseInstanceServiceImpl.java:503)

      2)

      Caused BPM-73006

      Error in case persistency.

      Error in case persistency.

      Contact system administrator for assistance.

              at oracle.bpm.casemgmt.persistence.instance.CaseInstancePersistence.queryCase(CaseInstancePersistence.java:209)

       

      3)

      Caused By: BPM-73004

      Unable to find records in table.

      Could not find records in table using query select caseInstance from Case as caseInstance join caseInstance.caseHeader as caseHeader join caseInstance.caseTranslations as caseTranslations where ( caseTranslations.locale = :locale )  and exists (select caseStakeHolders from caseInstance.caseStakeHolders as caseStakeHolders join caseStakeHolders.caseStakeHolderMembers as caseStakeHolderMembers where ((caseStakeHolderMembers.stakeHolder = :stakeHolder and caseStakeHolderMembers.stakeHolderType = 'USER')   or (caseStakeHolderMembers.stakeHolder IN :stakeHolderAppRoleList and caseStakeHolderMembers.stakeHolderType = 'APPLICATION_ROLE')  or (caseStakeHolderMembers.stakeHolder IN :stakeHolderGroupList and caseStakeHolderMembers.stakeHolderType = 'GROUP'))) and (caseHeader.state = 'ACTIVE')  order by caseHeader.createdDate DESC.

       

      Contact system administrator for assistance.

              at oracle.bpm.casemgmt.persistence.CasePersistence.findWithQuery(CasePersistence.java:401)

       

      What's wrong? Any pointers?

       

      Thanks,

      Marco