"errmsg" : "aggregation result exceeds maximum document size (16MB)" , "code" :

[Narayan VJ]

Hi Team,

To share a quick context, Mongo DB is used as the database to persist information for the application. We use a tool called Pentaho which makes connection to the Mongo DB to extract data and generates few reports for the business. As the data in the application has grown up, we are reaching 16MB size on Mongo due to which the query operation fails and hence the reports fails.

 

Please let us know if you have encountered a similar issue in any of your past and have some workaround already identified for it. 

Logs attached for reference.

Regards

Narayan

+91 9035181318

[Stephen Steneker]

On Thursday, 4 April 2019 19:54:00 UTC+10, Narayan VJ wrote:

To share a quick context, Mongo DB is used as the database to persist information for the application. We use a tool called Pentaho which makes connection to the Mongo DB to extract data and generates few reports for the business. As the data in the application has grown up, we are reaching 16MB size on Mongo due to which the query operation fails and hence the reports fails.

 

Please let us know if you have encountered a similar issue in any of your past and have some workaround already identified for it. 

Hi Narayan,

It's been a while since you posted this question. Were you able to find a solution?

If not, what version of Pentaho are you using? This looks similar to a problem which was apparently resolved in the Pentaho 8.1.0 GA release: https://jira.pentaho.com/browse/PDI-16450.

The 16MB result size limit for aggregation only applies to versions of MongoDB prior to 3.6 where there was an option to return an inline aggregation result. In MongoDB 3.6+ servers, the aggregate command will either return a cursor or store results in a collection.

Regards,

Stennie

[Narayan VJ]

Hello  Stennie,

The issue got resolved after upgrading the pentaho version. Appreciate the recommendation. Now we have got 100 MB(which was restricted to 16MB earlier) after the upgrade to play around.

Regards

Narayan

--
You received this message because you are subscribed to the Google Groups "mongodb-user"
group.
 
For other MongoDB technical support options, see: https://docs.mongodb.com/manual/support/
---
You received this message because you are subscribed to the Google Groups "mongodb-user" group.
To unsubscribe from this group and stop receiving emails from it, send an email to mongodb-user...@googlegroups.com.
To post to this group, send email to mongod...@googlegroups.com.
Visit this group at https://groups.google.com/group/mongodb-user.
To view this discussion on the web visit https://groups.google.com/d/msgid/mongodb-user/20d7fe8d-ab5d-4172-9478-5f147a308d32%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

--

Regards
Narayan
+91 9035181318