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

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

Environment

SAP Analytics Cloud (Enterprise) 

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

  • Verify which kind of import data options you are using. Consider changing it to Update or Append to decrease the amount of imported rows.
  • As 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 I set import updates more often with specifying filters in scheduling query settings.

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-BI , Business Intelligence Functionality, Analytic Models , LOD-ANA-PL , Planning , Known Error

Product

SAP Analytics Cloud 1.0