MongoDB almost big data (?) error

Question

Hi guys.

I am facing a problem related to a mongoDB data set. The data source is correctly configured because i can view data from small collections.

I have a collection with  size of 34MB (avg document size 370B) and a total of 93000 documents. I'm working with  query like:

var query=db.<collection>.find();

Knowage shows me an error like:

BSONObj size: 44756327 (0x2AAED67) is invalid. Size must be between 0 and 16793600(16MB) First element: retval: "[{ "_id" : "59dd221afca136000193d741", "_class" : "hubble.backend.storage.models.AvailabilityStorage", "applicationName" : "Benchmark Home Banking"..."

What i can see here is that knowage is creating by itself a unique document in wich ir inserts all the documents to retrieve (Look at: "First element: retval: "[{ "), then i don't know why MongoDB shows this error related to a single document size limit.

I'm reading this guide: http://wiki.spagobi.org/xwiki/bin/view/spagobi_server/data_set#HQueryDataSet28Mongo29

I have played with sbiDatasetfixedResult and var retVal= "LIST&#95;DOCUMENTS&#95;QUERY" and var retVal= "SINGLE&#95;DOCUMENTS&#95;QUERY" but this does not solve the problem, it seems like this is somenthing that need to be changed in the codebase.

I will appreciate any help.

Thanks in advanced

Regards

Answer 1

Hi, MongoDB has a limit of 16MB for document so you cannot exceed this limit. See the official documentation here: https://docs.mongodb.com/manual/reference/limits/#bson-documents. What version of MongoDB are you using?