IV25855: SITEID MISSING FROM MAXRELATIONSHIP FOR LABSTRANS

APAR status

• Closed as Permanent restriction.

Error description

• When sending work orders from maximo to the handheld devices
  using Maximo mobile data manager, it takes a lot of time. The
  issue is two relationships are not using SITEID properly in the
  query. So it's doing a full table scan on the Labtrans table.
  

Local fix

• update maxrelationship set whereclause='siteid=:siteid and wonum
  in (select wonum from workorder where (wonum=:wonum or
  (parent=:wonum and istask = :yes)) and siteid=:siteid )' where
  parent='WORKORDER' and child='WPLABOR' and name='SHOWPLANLABOR';
  
  update maxrelationship set whereclause='siteid=:siteid and refwo
  in (select wonum from workorder where (wonum=:wonum or
  (parent=:wonum and istask = :yes)) and siteid=:siteid )' where
  parent='WORKORDER' and child='LABTRANS' and
  name='SHOWACTUALLABOR';
  

Problem summary

• ****************************************************************
  * USERS AFFECTED: ALL                                          *
  ****************************************************************
  * PROBLEM DESCRIPTION: When sending work orders from maximo to *
  *                      the handheld devices                    *
  *                                                              *
  *                      using Maximo mobile data manager, it    *
  *                      takes a lot of time. The                *
  *                                                              *
  *                      issue is two relationships are not      *
  *                      using SITEID properly in the            *
  *                                                              *
  *                      query. So it's doing a full table scan  *
  *                      on the Labtrans table.                  *
  *                                                              *
  *                      LOCAL FIX:                              *
  *                                                              *
  *                      update maxrelationship set              *
  *                      whereclause='siteid=:siteid and wonum   *
  *                                                              *
  *                      in (select wonum from workorder where   *
  *                      (wonum=:wonum or                        *
  *                                                              *
  *                      (parent=:wonum and istask = :yes)) and  *
  *                      siteid=:siteid )' where                 *
  *                                                              *
  *                      parent='WORKORDER' and child='WPLABOR'  *
  *                      and name='SHOWPLANLABOR';               *
  *                                                              *
  *                      update maxrelationship set              *
  *                      whereclause='siteid=:siteid and refwo   *
  *                                                              *
  *                      in (select wonum from workorder where   *
  *                      (wonum=:wonum or                        *
  *                                                              *
  *                      (parent=:wonum and istask = :yes)) and  *
  *                      siteid=:siteid )' where                 *
  *                                                              *
  *                      parent='WORKORDER' and child='LABTRANS' *
  *                      and                                     *
  *                                                              *
  *                      name='SHOWACTUALLABOR';                 *
  *                                                              *
  ****************************************************************
  * RECOMMENDATION:                                              *
  *                                                              *
  *                                                              *
  *                                                              *
  ****************************************************************
  SITEID MISSING FROM MAXRELATIONSHIP FOR LABSTRANS
  

Problem conclusion

• The following SQL statements can be run agains the database to
  fix this problem :
  
  
  
  
  
  update maxrelationship set whereclause='siteid=:siteid and
  wonum in (select wonum from workorder where (wonum=:wonum or
  (parent=:wonum and istask = :yes)) and siteid=:siteid )' where
  parent='WORKORDER' and child='WPLABOR' and
  name='SHOWPLANLABOR';
  
  
  
  
  
  update maxrelationship set whereclause='siteid=:siteid and
  refwo in (select wonum from workorder where (wonum=:wonum or
  (parent=:wonum and istask = :yes)) and siteid=:siteid )' where
  parent='WORKORDER' and child='LABTRANS' and
  name='SHOWACTUALLABOR';
  

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

Applicable component levels