IV25855: SITEID MISSING FROM MAXRELATIONSHIP FOR LABSTRANS

Subscribe

You can track all active APARs for this component.

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 number

    IV25855

  • Reported component name

    MOBILE WORK MAN

  • Reported component ID

    5724R62WM

  • Reported release

    711

  • Status

    CLOSED PRS

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2012-08-07

  • Closed date

    2012-09-18

  • Last modified date

    2012-09-18

  • 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



Rate this page:

(0 users)Average rating

Document information


More support for:

IBM Maximo Mobile Work Manager
Mobile Work Mgr

Software version:

711

Reference #:

IV25855

Modified date:

2012-09-18

Translate my page

Machine Translation

Content navigation