IBM Support

IJ06604: SCHEDULER - GANTT VIEW HANGS DUE TO SLOW RUNNING SQL.

Subscribe to this APAR

By subscribing, you receive periodic emails alerting you to the status of the APAR, along with a link to the fix after it becomes available. You can track this item individually or track all items by product.

Notify me when this APAR changes.

Notify me when an APAR for this component changes.

APAR status

  • Closed as program error.

Error description

  • Ø
    This is related to APAR IJ00035 -  IN GRAPHICAL SCHEDULING WHEN
    USING TRUE AVAILABILITY ON SQL SERVER QUERY RUNS FOR MINUTES
    INSTEAD OF SECONDS
    except that this client is using Oracle.
    
    When they open a Schedule at times it just hangs and the wait
    cursor spins forever when they click on the Gantt View.    In a
    webex we found that the slow SQL was the same as for the other
    APAR above.    When the load on their system is light it
    appears to be less likely to happen.
    
    The problem is due to the SQL Maximo creates when using the
    Modify Availability records created in Assignment Manager to
    calculate the True Availability shown in the Resource section
    of the Gantt View tab.
    
    STEPS TO REPRODUCE:
    
    1. Go To System Properties and make sure that
    mxe.skd.resourceavail is set to 1.   Change it and Live Refresh
    if necessary.
    2. We will use the Maxdemo 6000 series WO for these steps.
    3. Go To Assignment Manager to create Modify Availability
    (Modavail) records.
    4. Query for the 600% WOs.
    5. Pick a few ELECT and MECH on the DAY shift and click on the
    Modify Availability icon at the right end of the row to create
    several Modify Work Dates records for each of the Labor.  2
    Labor of each Craft who are on DAY is ok.
    6. Go To Scheduler and create a new Schedule.
    7. Give it Calendar DAY and Shift DAY.    Extend the Calendar
    and Apply shifts through the end of the year if necessary.
    8., Create a Work Query to select the 6000 series WO.
    9. Save
    10. Click on the Gantt View tab.
    11. Click on Resource Time-Based tab in the lower 1/2 Resources
    section at the bottom of the Gantt.
    
    RESULTS:
    
    For the client this would appear to hang if the load on their
    system was heavy.
    
    EXPECTED RESULTS:
    
    It should process in a reasonably short period of time.
    
    PRODUCT VERSION:
    
    Maximo 7.5.0.11 with the current IFix running Oracle.
    

Local fix

  • Turn off System Property mxe.skd.resourceavail by setting it to
    0 and do a Live Refresh.
    

Problem summary

  • ****************************************************************
    * USERS AFFECTED:                                              *
    * maximo scheduler users                                       *
    ****************************************************************
    * PROBLEM DESCRIPTION:                                         *
    * SCHEDULER - GANTT VIEW HANGS DUE TO SLOW RUNNING SQL.        *
    ****************************************************************
    * RECOMMENDATION:                                              *
    * Apply fixpack  Release 7.6.1.0 of Base Services (Scheduler   *
    * 7671)or request an interim fix                               *
    ****************************************************************
    

Problem conclusion

  • Fix has been made to fix....The fix for this APAR is contained
    in the following maintenance package:
    		 | release\fix pack\interim fix for  Release 7.6.1.0 of Base
    Services(Scheduler 7671)
    

Temporary fix

Comments

APAR Information

  • APAR number

    IJ06604

  • Reported component name

    MAXIMO SCHEDULE

  • Reported component ID

    5724R46SE

  • Reported release

    767

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt / Xsystem

  • Submitted date

    2018-05-22

  • Closed date

    2018-05-29

  • Last modified date

    2018-05-29

  • 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

  • R767 PSY

       UP



Document information

More support for: Maximo Asset Management Scheduler

Software version: 767

Reference #: IJ06604

Modified date: 29 May 2018