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":"","Line of Business":{"code":"","label":""}}]
Document Information
Modified date:
08 November 2016