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
1 Answer:
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-tomcat\webapps\jasperserver\WEB-INF\lib"
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
"""
