IBM Support

JR54713: AD HOC GROUP DESCRIPTIONS THAT ARE LONGER THAN 255 CHARACTERS CAUSE CWLLG0181E DUE TO AN DATABASE EXCEPTION

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as program error.

Error description

  • When the Ad Hoc group description is longer than 255 characters,
    you receive the following exception:
    
    [11/24/15 20:20:36:741 CET] 0000048e wle_scheduler E
    CWLLG0181E: An exception occurred during execution of task 317.
    Error: [<525message:PreparedStatementCallback; SQL [insert into
    LSW_USR_GRP_XREF
    (GROUP_ID,GROUP_NAME,DISPLAY_NAME,GROUP_TYPE,DESCRIPTION,GROUP_S
    TATE,PARENT_GROUP_ID) values (?,?,?,?,?,?,?)]; Error for batch
    element #1: DB2 SQL Error: SQLCODE=-545, SQLSTATE=23513,
    SQLERRMC=DB2ADMIN.LSW_USR_GRP_XREF.DESCRIPTION, DRIVER=4.11.69;
    nested exception is
    com.ibm.db2.jjcc.am.SqlIntegrityConstraintViolationException:
    Error for batch element #1: DB2 SQL Error: SQLCODE=-545,
    SQLSTATE=23513, SQLERRMC=DB2ADMIN.LSW_USR_GRP_XREF.DESCRIPTION,
    DRIVER=4.11.69><200flowObjectID:/25.be629a9a-e09a-4a7c-8688-eb4d
    7d5f1321//bpdid:ac437eb7e55a8fd5:32455340:15134b13518:-7fcd/Step
    (Long56789012345678901234567890123456789012345678901234567890123
    45678901234567890123456789012345678901)>]
    
    com.lombardisoftware.core.TeamWorksDecoratingException:
    PreparedStatementCallback; SQL [insert into LSW_USR_GRP_XREF
    (GROUP_ID,GROUP_NAME,DISPLAY_NAME,GROUP_TYPE,DESCRIPTION,GROUP_S
    TATE,PARENT_GROUP_ID) values (?,?,?,?,?,?,?)]; Error for batch
    element #1: DB2 SQL Error: SQLCODE=-545, SQLSTATE=23513,
    SQLERRMC=DB2ADMIN.LSW_USR_GRP_XREF.DESCRIPTION, DRIVER=4.11.69;
    nested exception is
    com.ibm.db2.jcc.am.SqlIntegrityConstraintViolationException:
    Error for batch element #1: DB2 SQL Error: SQLCODE=-545,
    SQLSTATE=23513, SQLERRMC=DB2ADMIN.LSW_USR_GRP_XREF.DESCRIPTION,
    DRIVER=4.11.69
     at com.lombardisoftware.bpd.runtime.engine.BPDEngine.
      executeTreeNode(BPDEngine.java:412)
     at com.lombardisoftware.bpd.runtime.engine.BPDEngine.
      resume(BPDEngine.java:168)
    

Local fix

  • Because the Ad Hoc group description is built with the following
    pattern
    
    "Automatically created for "" + <activity Name> + " activity in
    "" + <instance display name> + " process"
    
    revise the activity, instance display name, or process so that
    the  description length equates to 255 or fewer characters.
    

Problem summary

  • The Ad Hoc group description is built with the following
    pattern:
    
    "Automatically created for "" + <activity Name> + " activity in
    "" + <instance display name> + " process"
    
    Sometimes, this description can be longer than 255 characters,
    which causes the exception.
    

Problem conclusion

  • A fix is/will be available for IBM BPM V8.0.1.3 that restricts
    entries in the Description column to 255 or fewer characters.
    
    On Fix Central (http://www.ibm.com/support/fixcentral), search
    for JR54713:
    
    1. Select IBM Business Process Manager with your edition from
      the product selector, the installed version to the fix pack
      level, and your platform, and then click Continue.
    
    2. Select APAR or SPR, enter JR54713, and click Continue.
    
    When you download fix packages, ensure that you also download
    the readme file for each fix. Review each readme file for
    additional installation instructions and information about the
    fix.
    

Temporary fix

  • Not applicable
    

Comments

APAR Information

  • APAR number

    JR54713

  • Reported component name

    BPM ADVANCED

  • Reported component ID

    5725C9400

  • Reported release

    801

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt / Xsystem

  • Submitted date

    2015-11-11

  • Closed date

    2016-01-14

  • Last modified date

    2016-06-15

  • 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

  • R801 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:
15 June 2016