How To Fix CMS_TSK005 - Database fetch restricted to maximum number of lines

CMS_TSK005 - Overview

• Message type: E = Error

• Message class: CMS_TSK - Message Class for Task

• Message number: 005

• Message text: Database fetch restricted to maximum number of lines

What causes this issue?

The system issues an error message and will not allow you to continue with this transaction until the error is resolved.

System Response

How to fix this error?

In the generation of the <ZH>Task List</> report, you have restricted
the number of records to be retreieved from the database.

Procedure for System Administrators

Error message extract from SAP system. Copyright SAP SE.

Smart SAP Assistant

• What is the cause and solution for SAP error message CMS_TSK005 - Database fetch restricted to maximum number of lines ?

  The SAP error message CMS_TSK005 ("Database fetch restricted to maximum number of lines") typically occurs in the context of the SAP BusinessObjects platform, particularly when dealing with the Central Management Server (CMS) and its database queries. This error indicates that a query has returned more rows than the maximum limit set in the system configuration.
  
  Cause:
  
  Row Limit Exceeded: The error is triggered when a query attempts to fetch more rows than the configured maximum limit. This is often a safeguard to prevent performance issues or excessive memory usage.
  Configuration Settings: The maximum number of rows that can be fetched is defined in the CMS settings. If a report or query is expected to return a large dataset, it may exceed this limit.
  Inefficient Queries: Sometimes, poorly optimized queries or reports can lead to unexpectedly large result sets.
  
  
  Solution:
  
  
  Increase the Maximum Row Limit:
  
  You can adjust the maximum number of rows that can be fetched by