SAP Knowledge Base Article - Public

2882683 - "Query results exceeded the row count limit of 800 000. Please edit your query to acquire fewer" error appears in SAP Analytics Cloud (SAC)

Symptom

The following error message occurs in SAP Analytics Cloud (SAC):

  • Query results exceeded the row count limit of 800 000. Please edit your query to acquire fewer
  • Query results exceeded the column count limit of 100. Please upload different data, or edit your query to acquire fewer columns.

Environment

  • SAP Analytics Cloud (Enterprise) 
  • Import Data Connection

Reproducing the Issue

  1. Create data model.
  2. Schedule an update.
  3. In Data Management under Data Timeline observe error message.

Cause

800 000 is the limitation for the amount of rows by design.

Resolution

  • If the amount of data that need's to be updated now is above 800 000, the way to import it is by filtering, so dividing data into chunks and uploading it. Filtering data on parameter X and uploading it, then filtering it on parameter everything but X and uploading again.
  • To avoid this situation in the future, set import updates more often with specifying filters in scheduling query settings.
  • An improvement request has also been submitted regarding this topic on the customer's influence page: Model - Increase Row Limitation (Currently at 800K limit) for Acquired Data Connection

See Also

Updating and Scheduling Models

Keywords

Cloud for Analytics, Cloud4Analytics, CloudforAnalytics, Cloud 4 Planning, BOC, SAPBusinessObjectsCloud, BusinessObjectsCloud, BOBJcloud, BOCloud., SAC, SAP AC, Cloud-Analytics, CloudAnalytics, SAPCloudAnalytics,Error,  Unable to update,  Sac, setup, Model, , Import Failed, Using, Update not Working, sapanalyticscloud, sap analytical cloud, sap analytical cloud, SAC, Die Quelle, konnte nicht aktualisiert werden. Die Abfrageergebnisse haben die maximale Zeilenanzahl von 800000 überschritten. Bearbeiten Sie Ihre Abfrage dahingehend, dass weniger Zeilen abgerufen werden,Query results exceeded the row count limit of 800 000. Please edit your query to acquire fewer, 800 000, amount of rows exceeds,800000 , KBA , LOD-ANA-AQU , Import Data Connections (Acquiring Data) , LOD-ANA-PL , Planning , Known Error

Product

SAP Analytics Cloud 1.0