SAP Knowledge Base Article - Preview

2176439 - Complex Table location query is slow when synching (Performance) - SAP Work Manager for Maximo

Symptom

  • Complex table locations-Data query consists of several UNION statements
  • The last part of it does heavy comparison and with big data amount it results in very slow performance.
  • Example:

    ~~~~~~~~~Issue Example~~~~~~~

    Just before creating the report in DB developer - after 408 seconds we stopped it and it shows:

    Locations count = 554508
    LocHierarchy count = 1165915
    sycloLocUp count = 556793
    SycloSiteUsers count = 21

    Server: Agentry 6.0.48, Maximo back-end
    ~~~~~~end Example~~~~~~~~~~~


Read more...

Environment

  • Agentry 6.0.48
  • SAP Work Manager for Maximo 7.5.2

Product

Agentry 6.0 ; Syclo SMART Work Manager 7.0.3 for Maximo

Keywords

SAPWMMx, ctLOC , KBA , MOB-SYC-IBM , Syclo Mobility for IBM backend , Problem

About this page

This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP ONE Support launchpad (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.