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
- Create data model.
- Schedule an update.
- In Data Management under Data Timeline observe error message.
Cause
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
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