IBM Support

JR49635: BAD SQL GRAMMAR ERROR OCCURS WHILE IMPORTING A SNAPSHOT

Subscribe

You can track all active APARs for this component.

 

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 number

    JR49635

  • Reported component name

    BPM STANDARD

  • Reported component ID

    5725C9500

  • Reported release

    801

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2014-03-14

  • Closed date

    2014-05-05

  • Last modified date

    2014-05-05

  • 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

[{"Business Unit":{"code":"BU053","label":"Cloud & Data Platform"},"Product":{"code":"SSFTDH","label":"IBM Business Process Manager Standard"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"8.0.1","Edition":"","Line of Business":{"code":"LOB36","label":"IBM Automation"}}]

Document Information

Modified date:
05 May 2014