IJ45070: GRAPHICAL ASSIGNMENT PERFORMANCE ISSUE WHEN RETRIEVING UNASSIGNED WORK USING UNASSIGNED WORK TOOL FROM MAP VIEW

APAR status

• Closed as program error.

Error description

• Graphical Assignment performance issue experienced when
  retrieving unassigned work when the unassigned work tool
  is used from the map view in the Dispatch tab. This action is
  taking up to 1 minute plus.
  The performance issue is tied to the query being run against the
  unassignedworkview  :
  select * from unassignedworkview where orgid = 'PGE' and ( (
  schedstart >= to_date('2022-12-06 08:45:00', 'YYYY-MM-DD
  HH24:MI:SS')
  and schedfinish <= to_date('2022-12-20 22:00:00', 'YYYY-MM-DD
  HH24:MI:SS') ) )
  and status in (select value from synonymdomain where
  domainid='WOSTATUS' and maxvalue in ('APPR','INPRG'))
  and (wonum in (select wonum from workorder where (wonum in
  ('M3226535')))
  or parent in (select wonum from workorder where (wonum in
  ('M3226535')))) and ( latitudey is not null and longitudex is
  not null );
  
  
  Steps:
  1)Scheduler >Graphical Assignment
  2)Select a Work List
  3)Dispatch Tab > map view >  click unassigned work tool
  
  Results:
  retrieving the unassigned work is taking up to 1 minute plus
  
  Expected Results:
  retrieving unassigned work to run in seconds
  
  
  Reported in Version:
  IBM Maximo Asset Management Scheduler 7.6.8.0
  IBM Maximo Asset Management 7.6.1.2
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED:                                              *
  * Scheduler users                                              *
  ****************************************************************
  

Problem conclusion

• A fix for this APAR will be included in a future release.
  

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:

Fix information

• Fixed component name

  MAXIMO SCHEDULE

• Fixed component ID

  5724R46SE

Applicable component levels