rousseau

Basic mongo/jasper report runs fine on both iReport & server. But when I added a subDataset & chart it fails on the server (but still runs quite happily on ireport). Both the main and subdataset use the mongodb connector. The main uses a simple query e.g. {collectionName : 'mybigtable'}. The subset uses another simple query e.g. {collectionName : 'myothertable'}. Both collections are in the same database, so the chart is set to share the connection using the ususal $P{REPORT_CONNECTION} setting. XML extract below. As above, chart runs fine under iReports 4.5.0, but when deployed to the server get the following error: Error Messagecom.jaspersoft.jasperserver.api.JSExceptionWrapper: No MongoDB connection Error Tracecom.jaspersoft.jasperserver.api.JSExceptionWrapper: net.sf.jasperreports.engine.JRException: No MongoDB connection at com.jaspersoft.mongodb.query.MongoDbQueryExecuter.createDatasource(MongoDbQueryExecuter.java:103) at net.sf.jasperreports.engine.fill.JRFillDataset.createQueryDatasource(JRFillDataset.java:731) at net.sf.jasperreports.engine.fill.JRFillDataset.initDatasource(JRFillDataset.java:629) at net.sf.jasperreports.engine.fill.JRFillDatasetRun.evaluate(JRFillDatasetRun.java:132) at net.sf.jasperreports.engine.fill.JRFillElementDataset.evaluateDatasetRun(JRFillElementDataset.java:224) at net.sf.jasperreports.engine.fill.JRFillChart.evaluateDatasetRun(JRFillChart.java:1356) at net.sf.jasperreports.engine.fill.JRFillChart.evaluateChart(JRFillChart.java:792) at net.sf.jasperreports.engine.fill.JRFillChart.evaluateRenderer(JRFillChart.java:769) at net.sf.jasperreports.engine.fill.JRFillChart.resolveElement(JRFillChart.java:1334) at net.sf.jasperreports.engine.fill.JRFillElement.performDelayedEvaluation(JRFillElement.java:859) at net.sf.jasperreports.engine.fill.JRFillElement.resolveElement(JRFillElement.java:945) at etc. Server build info: Product Version: 4.5.0 Build: 20120110_1602 Mongo connector is 0.5.0 /Steve Code:<timeSeriesChart> <chart evaluationTime="Report"> <reportElement x="0" y="437" width="802" height="98"/> <chartTitle/> <chartSubtitle/> <chartLegend position="Left"/> </chart> <timeSeriesDataset timePeriod="Milisecond"> <dataset> <datasetRun subDataset="mytable"> <connectionExpression><![CDATA[$P{REPORT_CONNECTION}]]></connectionExpression> </datasetRun> </dataset> <timeSeries> <seriesExpression><![CDATA["MySeries"]]></seriesExpression> <timePeriodExpression><![CDATA[new Date($F{timestamp}*1000L)]]></timePeriodExpression> <valueExpression><![CDATA[$F{trigger_event_value}]]></valueExpression> </timeSeries> </timeSeriesDataset> <timeSeriesPlot isShowLines="false"> <plot/> </timeSeriesPlot> </timeSeriesChart>

I want to tweak the adapter and recompile/package. The source package just seems to contain the source - no build file etc. Also there seems to be a netbean plugin thats built as part of the binary. Does anyone have build instructions for it? /Steve

Well I think I figured out the reason: its only supported in a newer version of the DB. Looks like we need to upgrade.

Not sure if I've got the syntax quite right, but i'm just trying to do a simple grouping using the MongoDbQuery driver in iReport: e.g. to count the number of times something crashed for a particular reason { runCommand : { aggregate : 'crashlog', pipeline : [{ $group : { _id : "$data.reason", count : { $sum : 1} } }] } } This gives the error: "Error: no such cmd: aggregate". I'm using the latest mongodb driver (0.5.0). /Steve