SAP Knowledge Base Article - Public

1913181 - Slow Performance While Executing the Activities Query

Symptom

Slow performance while executing the query in OWL screen.

Environment

SAP Business ByDesign

Reproducing the Issue

For example we are selecting Activities view.

  1. Go to the Account Management work center.
  2. Go to the Activities view.
  3. Show All Activities and choose Go button.
  4. The display of list takes more time than your expectation.
  5. You also get a warning message: The data cannot be displayed completely. Sorting and Filtering are not reliable since the number of hits is too large. Reduce the number of search hits by restricting the search criteria.

Cause

On a particular query screen (e.g. Activities, Sales Orders, Service Orders), if the data is huge and you try to query with All parameter then performance will be relatively slow and the system will throw below warning message:
The data cannot be displayed completely. Sorting and Filtering are not reliable since the number of hits is too large. Reduce the number of search hits by restricting the search criteria.

Resolution

In case of such warning message & slow execution, it is always advisable to use the Advanced query, optimize your search criteria then try to view the data. In Advanced query you have many parameters to optimize the query e. g. Date, Activity Type, Employee Responsible, Status, Account Name, Account ID etc.

  1. Go to the Account Management work center.
  2. Go to the Activities view.
  3. Show All Activities and choose the Advanced option.
  4. Select the required parameters and choose the Go button.
  5. The duration for the display of list will be optimized as per your expectation.

Please be noted that this solution is also working for Supplier Invoices, Purchase Orders, etc.

Keywords

Slow performance, Data cannot be displayed completely, Sorting and Filtering are not reliable since the number of hits is too large, Reduce the number of search hits by restricting the search criteria , KBA , AP-SLO , Sales Order Processing , How To

Product

SAP Business ByDesign all versions