Maximo Open Forum

 View Only
  • 1.  Maximo Service Request (Work Center Portal) - Long Data Load Time on Request Parameters

    Posted 01-19-2022 14:15
    As I was working on the new Service Portal for Maximo Work Center Tools. I've noticed there is a significant load time during the default page that shows the current "Active Request" for users login.
     
    Using the Chrome Dev tools, to look at Network request,  the following request is made using the following string parameter, with around 2.6 minutes. However sometime it takes up to 3 minutes or more. For users with more service request submission,
     
    Request URL: https://maxdev.ucsf.edu/maximo/oslc/os/mxapisr?savedQuery=SERVICEREQUEST&lean=1&collectioncount=1&oslc.select=reportedpriority%2Cdescription%2Cdescription_longdescription%2Ctargetfinish%2Cactualfinish%2Cstatusdate%2Cticketid%2Cstatus%2Cstatus_maxvalue%2Cstatus_description%2Creportedby%2Creportdate%2Clocation.location%2Cserviceaddress.description%2Cdoclinks%7Btitle%7D%2Cworklog%2Crelatedwo.relatedrecwonum%2Crelatedticket.relatedreckey&oslc.pageSize=15&searchAttributes=description%2Cdescription_longdescription%2Cticketid%2Clocation&addlocalizedrep=1&querywhere=%7B%22qbewhere%22%3A%7B%22status%22%3A%7B%22operator%22%3A%22in%22%2C%22valueset%22%3A%5B%22HISTEDIT%22%2C%22INPROG%22%2C%22FMTRACKNEW%22%2C%22NEW%22%2C%22PENDING%22%2C%22APPROVE%22%2C%22QUEUED%22%2C%22RE-ASSIGN%22%5D%7D%7D%7D&oslc.orderBy=-reportdate&internalvalues=1&ignorecollectionref=1&addid=1&querylocalized=1 
     
    How can we optimize the following request to reduced the load time when requesting data. 
     
    Is there an efficient way to load the data ore change how the savedQuery=SERVICEREQUEST is structured?
     
    Please see Attached documents for further information, on screen capture on the network request.

    NOTE: This actually applies to any Work Center applications. We've been having this issue for some time with load load time when query via oslc/os.  Any clues where to investigate can be helpful.

    #WorkCenters

    ------------------------------
    Xayaseth Boudsady
    University of California San Francisco
    ------------------------------


  • 2.  RE: Maximo Service Request (Work Center Portal) - Long Data Load Time on Request Parameters

    Posted 01-20-2022 11:59
    Hi,

    Couple of suggestions:
    1. Exclude all the fields which you don't need from OS MXAPISR. Keep only attributes in different objects which you really need. This will help to cut down the payload size.

    2. If you see OOB MXAPISR, it contains a lot of MBOs. When response from API to be processed, Maximo makes SQL Query on basis of mbos available in OS and then it provide the output. If there are tables which has not data because you are not using those feature it will take more time to get the response because of Inner Queries which Maximo uses. Hence you can delete all unwanted MBOs from this OS to speed up the response.

    Another important thing to check the relationship between Parent & Child MBOs. You can tune them as per your requirements. If you are not using Doclinks then it will be better to remove this MBO from OS as it takes lot of cost at DB end.


    Thanks
    PS

    ------------------------------
    Prashant Sharma
    EAM360
    Connect with me @ https://www.linkedin.com/in/psharmamaximo/
    ------------------------------



  • 3.  RE: Maximo Service Request (Work Center Portal) - Long Data Load Time on Request Parameters

    Posted 01-20-2022 15:42
    Thanks for the great information Prashant. I'll go ahead have this sent up to our system admin to review.  Quick question though, when viewing and editing the MXAPISR, is this through the Integration > Object Structures, or the System Configuration>Migration>Object Structure?

    (See Attached Image for reference)



    ------------------------------
    Xayaseth Boudsady
    University of California San Francisco
    ------------------------------



  • 4.  RE: Maximo Service Request (Work Center Portal) - Long Data Load Time on Request Parameters

    Posted 01-21-2022 00:13
    Yes, it is the correct path.

    To exclude/Include fields from MXAPISR , there is select action > Include/Exclude Field available.


    Thanks,
    PS


    ------------------------------
    Prashant Sharma
    EAM360
    Connect with me @ https://www.linkedin.com/in/psharmamaximo/
    ------------------------------



  • 5.  RE: Maximo Service Request (Work Center Portal) - Long Data Load Time on Request Parameters

    Posted 01-24-2022 11:23
    Also, please be aware that for some versions the WORKLOG relationship was bad and led to poor performance. Please confirm that the relationship is UXWORKLOG and not WORKLOG (which has no filter and retrieves the entire worklog table). The APAR is IJ25277 https://www.ibm.com/support/pages/apar/IJ25277

    ------------------------------
    Steven Shull
    IBM
    ------------------------------



  • 6.  RE: Maximo Service Request (Work Center Portal) - Long Data Load Time on Request Parameters

    Posted 01-26-2022 12:19
    Thanks Steven.

    I tried to select that link, but it took me to a restricted page, only for IBM Support customer subscriber only?  I'll pass this information to our System Admin, they may have access to view APAR: IJ25277.

    https://www.esri.com/en-us/arcgis/products/arcgis-indoors/overview


    ------------------------------
    Xayaseth Boudsady
    University of California San Francisco
    ------------------------------