PJ43132: APPLYING IN-BASKET FILTER CAUSES ERROR WHEN "ALLOW USER TO SHOW OR HIDE WORK ITEMS..." OPTION IS ENABLED WITH 5.2.0.2-ICM-FP002

5.2.1.2-ICM-WIN-IF001
5.2.1.2-ICM-LINUX-IF001
5.2.1.2-ICM-AIX-IF001
5.2.1.2-ICM-ZLINUX-IF001
IBM Case Manager V5.2.1 Fix Pack 2 for Linux for System z
IBM Case Manager V5.2.1 Fix Pack 2 for Windows
IBM Case Manager V5.2.1 Fix Pack 2 for Linux
IBM Case Manager V5.2.1 Fix Pack 2 for AIX

APAR status

• Closed as program error.

Error description

• Description:
  
  Applying an in-basket filter will display the error 'Your
  request cannot be processed' if the option to 'Allow user to
  show or hide work items locked by other users' is enabled on the
  in-basket widget. This error will appear after applying IBM Case
  Manager 5.2.0 Fix Pack 002 (5.2.0.2-ICM-FP002).
  
  The application server log will have database query exceptions,
  such as:
  
  Exception: Database error.  See chained exception ; Cannot
  execute statement, msecs=, SQL: <filter SQL>
  ...
  Caused by: com.ibm.db2.jcc.am.SqlException: DB2 SQL Error:
  SQLCODE=-313, SQLSTATE=07001, SQLERRMC=null, DRIVER=3.64.133
  
  The in-basket works well if no filter is applied.  This problem
  does not occur on ICM 5.2.0 Fix Pack 001 (5.2.0.1-ICM-FP001).
  

Local fix

• Workaround:
  Open In-basket widget setting in Case Manager Builder. Clear the
  "Allow user to show or hide work items locked by other users"
  check box and select "Work items locked by any user" from the
  "Select the locked work items to be displayed" drop-down list.
  Save and redeploy the solution.
  

Problem summary

• ****************************************************************
  * USERS AFFECTED:                                              *
  * End users who use the In-basket widget                       *
  ****************************************************************
  * PROBLEM DESCRIPTION:                                         *
  * See Error Description                                        *
  ****************************************************************
  * RECOMMENDATION:                                              *
  * To fix this problem, apply IBM Case Manager V5.2.1.2 or      *
  * later releases.                                              *
  ****************************************************************
  

Problem conclusion

• The fix for this problem is provided in IBM Case Manager
  V5.2.1.2 or later releases.
  

Temporary fix

Comments

APAR Information

• APAR is sysrouted FROM one or more of the following:

  PJ43120

• APAR is sysrouted TO one or more of the following:

Fix information

• Fixed component name

  CASE MGR CLIENT

• Fixed component ID

  5725A1501

Applicable component levels

• R521 PSN

     UP

• R521 PSY

     UP