IBM Support

IV90277: ADDITIONAL SQL SELECTS THAT RUN WHEN CREATING WF ASSIGNMENTS TAKE TOO MUCH TIME.

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as program error.

Error description

  • The client has over 100 people in a person group so when WF
    Assignments are made each validation of the WFAssignment
    records gets run over 100 times, once for each person, and the
    cumulative affect is that creating all these assignments takes
    too much time.
    
    Here are the SQL Selects that we are concerned about:
    
    # SQLs (164) [1744 ms] USER1 -> select * from wfassignment where
    assignid = 1 and processname = 'WFPROCESS' and processrev = 12
    and wfid = 1234 and nodeid = 11 OPTION (FAST 1000)
    
    # SQLs (164) [1851 ms] USER1 -> select top 1000 * from
    synonymdomain where (value= 'ACTIVE' ) and (domainid =
    'WFASGNSTATUS' ) OPTION (FAST 1000)
    
    # SQLs (164) [1838 ms] USER1 -> select top 1000 * from workorder
    where ((workorderid= 23456 and (exists ( select siteid from
    siteauth a,groupuser b where a.groupname=b.groupname and
    b.userid = 'USER1' and a.siteid = workorder.siteid)) OPTION
    (FAST 1000)
    
    Steps to reproduce:
    1. Create a Person Group with 10 or 20 members.
    2. Create a Role that broadcasts to that group.
    3. Create  a WF process for Workorders that has a Task node
    that makes as Assignment to the Role created above.
    4. Save, Enable and Activate the WF process.
    5. Create a new WO and start it into the WF process.
    
    When you examine the logs with 'sql' set to INFO and 'workflow'
    set to DEBUG you will see each WFAssignment being made and
    those selects being run once for each of the 10 or 20 people in
    the Person Group.
    

Local fix

  • (none)
    

Problem summary

  • ****************************************************************
    * USERS AFFECTED:                                              *
    * All Maximo Users                                             *
    ****************************************************************
    * PROBLEM DESCRIPTION:                                         *
    * ADDITIONAL SQL SELECTS THAT RUN WHEN CREATING WF ASSIGNMENTS *
    ****************************************************************
    * RECOMMENDATION:                                              *
    * Upgrade to latest release                                    *
    ****************************************************************
    

Problem conclusion

  • No additional validation sql selects run when creating wf
    assignments when property mxe.wf.novalidate.assignment is set to
    true or Y
    
    
    The fix for this APAR is contained in the following maintenance
    package:
    	 | release\fix pack | Fix Pack Release 7.6.0.8
    

Temporary fix

Comments

APAR Information

  • APAR number

    IV90277

  • Reported component name

    WORK ORDERS

  • Reported component ID

    5724R46WO

  • Reported release

    760

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt / Xsystem

  • Submitted date

    2016-10-25

  • Closed date

    2016-11-08

  • Last modified date

    2016-11-08

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

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

Modules/Macros

  • MAXIMO
    

Fix information

  • Fixed component name

    WORK ORDERS

  • Fixed component ID

    5724R46WO

Applicable component levels

  • R760 PSY

       UP

[{"Business Unit":{"code":"BU048","label":"IBM Software"}, "Product":{"code":"SSCHPPU","label":"Work Order Tracking"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"760","Edition":""}]

Document Information

Modified date:
08 November 2016