asked on October 25, 2022
Hi,
When trying to expand a report thats large this error gets thrown on the node server. Wanted to see if your team has run into anything similar and what we might be able to do about it.
UnhandledPromiseRejectionWarning: MongoServerError: PlanExecutor error during aggregation :: caused by :: BSONObj size: 20328590 (0x136308E) is invalid. Size must be between 0 and 16793600(16MB) First element: grandTotal: [ { _id: {}, negatives!_!sum: 48800621.155870, negatives_neutrals!_!sum: 78447310.681762, neutrals!_!sum: 34819159.463523, positives!_!sum: 19306571.774653, positives_neutrals!_!sum: 48953261.300700 } ]
Thanks
⋅ October 25, 2022
Here's the response from mongo db attached
⋅ October 26, 2022
Hello, Younus!
Thank you for reporting the issue and providing a detailed description of it.
While developing the MongoDB connector, we considered the size limitations for BSON, but now we can see that sometimes it exceeds the 16MB size.
Our team will provide a fix in one of the upcoming minor releases, ETA Nov 15th. If needed, we can try to share the beta version of this update earlier so that you can try it out before the official release.
Looking forward to hearing your feedback.
Best Regards,
Maksym
⋅ October 26, 2022
Hi Maksym,
If we can get the beta release earlier that would be helpful. Also, if its a small code change I can also patch the package in the meantime. I would just need to be pointed in the right place to do so.
Thanks,
Younus
⋅ October 27, 2022
Hello, Younus!
Thank you for your response.
Kindly note that our team needs some time to research and fix this issue. We can not say with certainty if this would be a small change that could be easily patched by adjusting a few lines of code. Nevertheless, we will provide you with a fix as soon as it is ready.
Best Regards,
Maksym
⋅ November 15, 2022
Hello, Younus!
We are glad to announce that the issue with the BSON size limit was fixed.
This is available in the 2.9.38 version of Flexmonster MongoDB Connector: https://www.flexmonster.com/release-notes/version-2-9-38/
We will be happy to hear your feedback.
Best Regards,
Maksym
⋅ November 15, 2022
Ok thank you, will let you know.
