IBM Support

JR41687: TEMPLATE CACHE ISSUE WITH PEOPLE SUBSTITUTION.

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as program error.

Error description

  • Template cache issue with people substitution.
    .
    With people substitution enabled, information in the template
    cache can grow over time and lead to redundant data in staff
    resolution SQL querys
    
       The following message may be logged as a result
    [3/10/17 1:26:59:384 EST] 0000006b TraceHTM      3
    com.ibm.bpe.staff.VMMAccessControl.getResultAttributeValues(VMMA
    ccessControl.java:1479) HTM_PA_VMM
     Reached staff query threshold, stopping retrieval of further
    results
    [3/10/17 1:26:59:384 EST] 0000006b StaffPluginUt W   CWWBS0469W:
    The specified threshold for the people (staff) query has been
    reached, no further results will be included.
    
       And a trace of the issue would show duplicate entries in the
    data returned on the query.
    
       Those systems using Oracle for the DB server may also see
    CWWIM4521E  The 'ORA-01795 maximum number of expressions in a
    list is 1000' SQL Exception occurred during processing.
     at
    com.ibm.ws.security.auth.ContextManagerImpl.runAs(ContextManager
    Impl.jav:4656)
     at
    com.ibm.ws.security.auth.ContextManagerImpl.runAsSystem(ContextM
    anagerImpl.java:4698)
     at
    com.ibm.bpe.staff.VMMAccessControl.doVMMGet(VMMAccessControl.jav
    a:547)
     at
    com.ibm.bpe.staff.VMMAccessControl.doPluginGetGroupMembers(VMMAc
    cessControl.java:740)
     at
    com.ibm.bpe.staff.VMMStaffResolutionPlugin.resolveStaff1(VMMStaf
    fResolutionPlugin.java:1473)
    

Local fix

Problem summary

  • Problem fixed
    

Problem conclusion

  • Fix will be included in V7511
    

Temporary fix

Comments

APAR Information

  • APAR number

    JR41687

  • Reported component name

    BPM ADVANCED

  • Reported component ID

    5725C9400

  • Reported release

    751

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt / Xsystem

  • Submitted date

    2012-01-16

  • Closed date

    2012-03-12

  • Last modified date

    2017-03-10

  • 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 ADVANCED

  • Fixed component ID

    5725C9400

Applicable component levels

  • R751 PSY

       UP

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

Document Information

Modified date:
10 March 2017