Symptom
Slow performance while executing the query in OWL screen.
Environment
SAP Business ByDesign
Reproducing the Issue
For example we are selecting Activities view.
- Go to the Account Management work center.
- Go to the Activities view.
- Show All Activities and choose Go button.
- The display of list takes more time than your expectation.
- 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.
- Go to the Account Management work center.
- Go to the Activities view.
- Show All Activities and choose the Advanced option.
- Select the required parameters and choose the Go button.
- 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