IBM Support

JR41687: TEMPLATE CACHE ISSUE WITH PEOPLE SUBSTITUTION.

Fixes are available

Version 7.5.1 Fix Pack 1 for the IBM Business Process Manager products
Version 8.5 Refresh Pack 7 for the IBM Business Process Manager products

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
    • 








      
              
                            

              

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

                          

          
 
        

      

    

      

        

          

            
Document Information


            

            


                        

            Modified date:
            

            06 October 2021
            

            
                      

        


        

        


      

    

  



    

  

  
    
            

          
Page Feedback