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

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