DWP 19.05 - My Activity is slow to load Requests

Version 1
    Share This:

    This document contains official content from the BMC Software Knowledge Base. It is automatically updated when the knowledge article is modified.


    PRODUCT:

    BMC Digital Workplace Advanced


    COMPONENT:

    BMC Digital Workplace Basic


    APPLIES TO:

    DWP 19.x



    PROBLEM:

    What configurations and/or new DB indexes can be made to limit the number of Requests returned when clicking on 'My Activity'?

    Currently it takes a long time to populate, and when clicking on Details on one of the Requests in the list and go back it takes a long time to populate again (i.e. does not appear to cache)


    CAUSE:

    Index can be added to SRM:


    SOLUTION:

    Add the following compound index to the SRM:Request form:

    301378004 Source Keyword 4 (CHAR)
    303490600 CartID 4 (CHAR)
    1 SysRequestID 4 (CHAR)


    Article Number:

    000172710


    Article Type:

    Solutions to a Product Problem



      Looking for additional information?    Search BMC Support  or  Browse Knowledge Articles