mongofb 3.6 JRException: The 'cursor' option is required, except for aggregate with the explain argument

[mohamed.aghoulas]

Hello,

i recentlly change my mongodb database version from 3.4 to 3.6 and i started getting this error : 

net.sf.jasperreports.engine.JRException: net.sf.jasperreports.engine.JRRuntimeException: net.sf.jasperreports.engine.JRException: The 'cursor' option is required, except for aggregate with the explain argument
    at com.jaspersoft.studio.editor.preview.view.control.ReportController.fillReport(ReportController.java:550)
    at com.jaspersoft.studio.editor.preview.view.control.ReportController.access$18(ReportController.java:525)
    at com.jaspersoft.studio.editor.preview.view.control.ReportController$1.run(ReportController.java:443)
    at org.eclipse.core.internal.jobs.Worker.run(Worker.java:63)
Caused by: net.sf.jasperreports.engine.JRRuntimeException: net.sf.jasperreports.engine.JRException: The 'cursor' option is required, except for aggregate with the explain argument
    at net.sf.jasperreports.components.list.VerticalFillList.prepare(VerticalFillList.java:150)
    at net.sf.jasperreports.engine.fill.JRFillComponentElement.prepare(JRFillComponentElement.java:152)
    at net.sf.jasperreports.engine.fill.JRFillElementContainer.prepareElements(JRFillElementContainer.java:542)
    at net.sf.jasperreports.engine.fill.JRFillBand.fill(JRFillBand.java:453)
    at net.sf.jasperreports.engine.fill.JRFillBand.fill(JRFillBand.java:428)
    at net.sf.jasperreports.engine.fill.JRVerticalFiller.fillColumnBand(JRVerticalFiller.java:2585)
    at net.sf.jasperreports.engine.fill.JRVerticalFiller.fillDetail(JRVerticalFiller.java:813)
    at net.sf.jasperreports.engine.fill.JRVerticalFiller.fillReportStart(JRVerticalFiller.java:264)
    at net.sf.jasperreports.engine.fill.JRVerticalFiller.fillReport(JRVerticalFiller.java:110)
    at net.sf.jasperreports.engine.fill.JRBaseFiller.fill(JRBaseFiller.java:615)
    at net.sf.jasperreports.engine.fill.BaseFillHandle$ReportFill.run(BaseFillHandle.java:135)
    at java.lang.Thread.run(Thread.java:748)
Caused by: net.sf.jasperreports.engine.JRException: The 'cursor' option is required, except for aggregate with the explain argument
    at com.jaspersoft.mongodb.query.MongoDbQueryWrapper.runCommand(MongoDbQueryWrapper.java:207)
    at com.jaspersoft.mongodb.query.MongoDbQueryWrapper.processQuery(MongoDbQueryWrapper.java:115)
    at com.jaspersoft.mongodb.query.MongoDbQueryWrapper.<init>(MongoDbQueryWrapper.java:93)
    at com.jaspersoft.mongodb.query.MongoDbQueryExecuter.createDatasource(MongoDbQueryExecuter.java:104)
    at net.sf.jasperreports.engine.fill.JRFillDataset.createQueryDatasource(JRFillDataset.java:1257)
    at net.sf.jasperreports.engine.fill.JRFillDataset.initDatasource(JRFillDataset.java:726)
    at net.sf.jasperreports.components.list.FillDatasetRun.start(FillDatasetRun.java:166)
    at net.sf.jasperreports.components.list.VerticalFillList.prepare(VerticalFillList.java:102)
    ... 11 more

when i try to run this script :

{
    runCommand: {
        aggregate : 'Org',
        pipeline : [
            {
                $project : {
                    
                    Miss_Attr.categorie:1,
                    Miss_Attr.texte:1
                }
            },
            { $unwind : '$Miss_Attr'}
       ]
}}

can anyone help me with this. thank you

[arnaudsimon091]

The solution is overhere : https://community.jaspersoft.com/jasperreports-server/issues/10886

"""

Post 19 : 

Probably *not* in JSS, but in JRS, you could try replacing two JAR's with their latest versions here:

https://repo1.maven.org/maven2/org/mongodb/mongo-java-driver/3.10.2/mong...
https://jaspersoft.jfrog.io/jaspersoft/jaspersoft-repo/com/jaspersoft/co...

Post 20 :

@kkumlien 's solution worked for me. Steps I took were the following:

1. Download both .jar specified in post #19
2. Go to "{jasperserver_root}apache-tomcatwebappsjasperserverWEB-INFlib"
3. Remove old versions of jars ("js-mongodb-datasource-2.0.9.jar" and "mongo-java-driver-3.3.0.jar" in my case)
4. Paste downloaded jars
5. Restart JR Server

"""