JR49635: BAD SQL GRAMMAR ERROR OCCURS WHILE IMPORTING A SNAPSHOT

Version 8.5 Refresh Pack 5 for the IBM Business Process Manager products
Download Version 8.0.1 Fix Pack 3 for the IBM Business Process Manager products
Version 8.5.0 Fix Pack 2 for the IBM Business Process Manager products

APAR status

• Closed as program error.

Error description

• While installing a snapshot, you receive a Bad SQL Grammar
  error.
  

Local fix

• n/a
  

Problem summary

• While installing a snapshot, you receive a Bad SQL Grammar
  error.
  
  PROBLEM DETAILED DESCRIPTION:
  You receive the following Bad SQL Grammar error while installing
  a snapshot:
  
  PreparedStatementCallback; bad SQL grammar [SELECT DISTINCT
  G.GROUP_ID FROM LSW_USR_GRP_XREF G WHERE G.GROUP_TYPE IN (1,4)
  AND NOT EXISTS ( SELECT T.GROUP_ID FROM LSW_TASK T WHERE
  T.GROUP_ID = G.GROUP_ID UNION ALL SELECT T.GROUP_ID FROM
  LSW_TASK T WHERE T.GROUP_ID = - G.GROUP_ID ) AND G.GROUP_ID IN (
  )]; nested exception is
  com.microsoft.sqlserver.jdbc.SQLServerException: Incorrect
  syntax near ')'.
  
  This error occurs after a snapshot is deleted with the use of
  the BPMDeleteSnapshot command when JR48877 is applied. The error
  occurred because more than 1000 participant groups do not have a
  corresponding snapshot in your database and the task of deleting
  them is not split into multiple SQL statements.
  

Problem conclusion

• A fix is available that deletes the participant groups that do
  not have a corresponding snapshot that uses multiple SQL
  statements.
  
  FIX AVAILABILITY:
  iFix for 7.5.1.2 is/will be available on Fix Central; search for
  APAR JR49635 at http://www.ibm.com/support/fixcentral/
  iFix for 8.0.1.1 is/will be available on Fix Central; search for
  APAR JR49635 at http://www.ibm.com/support/fixcentral/
  iFix for 8.0.1.2 is/will be available on Fix Central; search for
  APAR JR49635 at http://www.ibm.com/support/fixcentral/
  iFix for 8.5.0.1 is/will be available on Fix Central; search for
  APAR JR49635 at http://www.ibm.com/support/fixcentral/
  Fix is also targetted for inclusion in next fixpack for
  BPM V7.5.1, BPM 8.0.1
  
  When obtaining any of the above fixes, be sure to download the
  accompanying readme, for itself, and any prerequisite fixes, and
  review them thoroughly.
  

Temporary fix

Comments

APAR Information

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

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

Fix information

• Fixed component name

  BPM STANDARD

• Fixed component ID

  5725C9500

Applicable component levels

• R751 PSY

     UP

• R801 PSY

     UP

• R850 PSY

     UP