[subdataset/chart error when run on server (mongo connector)]

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 Message

com.jaspersoft.jasperserver.api.JSExceptionWrapper: No MongoDB connection

Error Trace

com.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>

[Build instructions for mongo connector?]

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

[MongoDB aggregate broken?]

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

[MongoDB aggregate broken?]

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