BPM 11g Case Management: Could not find records in table using query select count(caseInstance) from Case as caseInstance

Caused By: BPM-73004

Unable to find records in table.
Could not find records in table using query select count(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'))) order by caseInstance.caseHeader.caseNumber desc .
Contact system administrator for assistance.


You can also find this error when you try get list of Cases from from the case manager

Solution:

• Download the patch for 14791221
• Unzip the patch in a temporary directory
• Copy patch-catalog_18499.xml and HLJ3.jar to  utils/bsu/cache_dir under your BEA Home. For e.g. this will be /oracle/fmwhome/utils/bsu/cache_dir in the BPM VirtualBox image
• Change directory to /oracle/fmwhome/utils/bsu
• Run ./bsu.sh
• This will launch the Smart Update application. Once it initializes, you should see the patch in the Downloaded Patches panel. Click on the button in the Apply column to apply the patch

  Restart all the servers.