Skip to main content


Eclipse Community Forums
Forum Search:

Search      Help    Register    Login    Home
Home » Newcomers » Newcomers » MongoDB BIRT Data Source issues
MongoDB BIRT Data Source issues [message #1802781] Fri, 15 February 2019 15:29
Rodrigo Castro is currently offline Rodrigo CastroFriend
Messages: 2
Registered: February 2019
Junior Member
Hello,
I'm new to Eclipse BIRT to make reports, but I'm trying to deal with some issues right now.
1) When I try to perform an aggregation using the Aggregate Command Type, the following error shows up:

org.eclipse.datatools.connectivity.oda.OdaException: Unable to run the Aggregate command operation. 
Check that your connected MongoDB server is version 2.2 or later. ;
    com.mongodb.CommandFailureException: { "serverUsed" : "myhost:27017" , "ok" : 0.0 , "errmsg" : "The 'cursor' option is required, except for aggregate with the explain argument" , "code" : 9 , "codeName" : "FailedToParse"}
	at org.eclipse.birt.data.oda.mongodb.internal.impl.MDbOperation.callAggregateCmd(MDbOperation.java:361)
	at org.eclipse.birt.data.oda.mongodb.internal.impl.MDbMetaData.getAvailableFields(MDbMetaData.java:191)
	at org.eclipse.birt.data.oda.mongodb.ui.util.FieldEntryWrapper.getAvailableFields(FieldEntryWrapper.java:88)
	at org.eclipse.birt.data.oda.mongodb.ui.util.FieldEntryWrapper.updateAvailableFields(FieldEntryWrapper.java:100)
	at org.eclipse.birt.data.oda.mongodb.ui.impl.MongoDBDataSetWizardPage$25.run(MongoDBDataSetWizardPage.java:1438)
	at org.eclipse.swt.custom.BusyIndicator.showWhile(BusyIndicator.java:72)
	at org.eclipse.birt.data.oda.mongodb.ui.impl.MongoDBDataSetWizardPage.updateAvailableFieldsList(MongoDBDataSetWizardPage.java:1418)
	at org.eclipse.birt.data.oda.mongodb.ui.impl.MongoDBDataSetWizardPage.access$28(MongoDBDataSetWizardPage.java:1409)
	at org.eclipse.birt.data.oda.mongodb.ui.impl.MongoDBDataSetWizardPage$18.widgetSelected(MongoDBDataSetWizardPage.java:889)
	at org.eclipse.swt.widgets.TypedListener.handleEvent(TypedListener.java:252)
	at org.eclipse.swt.widgets.EventTable.sendEvent(EventTable.java:89)
	at org.eclipse.swt.widgets.Display.sendEvent(Display.java:4131)
	at org.eclipse.swt.widgets.Widget.sendEvent(Widget.java:1055)
	at org.eclipse.swt.widgets.Display.runDeferredEvents(Display.java:3944)
	at org.eclipse.swt.widgets.Display.readAndDispatch(Display.java:3547)
	at org.eclipse.jface.window.Window.runEventLoop(Window.java:822)
	at org.eclipse.jface.window.Window.open(Window.java:798)
	at org.eclipse.birt.report.designer.ui.dialogs.BaseDialog.open(BaseDialog.java:117)
	at org.eclipse.birt.report.designer.data.ui.providers.EditableDataSetNodeProvider.performEdit(EditableDataSetNodeProvider.java:102)
	at org.eclipse.birt.report.designer.internal.ui.views.DefaultNodeProvider.performRequest(DefaultNodeProvider.java:472)
	at org.eclipse.birt.report.designer.internal.ui.views.actions.EditAction.doAction(EditAction.java:85)
	at org.eclipse.birt.report.designer.internal.ui.views.actions.AbstractElementAction.run(AbstractElementAction.java:70)
	at org.eclipse.birt.report.designer.internal.ui.views.RenameListener.doubleClick(RenameListener.java:214)
	at org.eclipse.jface.viewers.StructuredViewer$1.run(StructuredViewer.java:833)
	at org.eclipse.core.runtime.SafeRunner.run(SafeRunner.java:45)
	at org.eclipse.ui.internal.JFaceUtil.lambda$0(JFaceUtil.java:47)
	at org.eclipse.jface.util.SafeRunnable.run(SafeRunnable.java:176)
	at org.eclipse.jface.viewers.StructuredViewer.fireDoubleClick(StructuredViewer.java:830)
	at org.eclipse.jface.viewers.AbstractTreeViewer.handleDoubleSelect(AbstractTreeViewer.java:1518)
	at org.eclipse.jface.viewers.StructuredViewer$4.widgetDefaultSelected(StructuredViewer.java:1260)
	at org.eclipse.jface.util.OpenStrategy.fireDefaultSelectionEvent(OpenStrategy.java:252)
	at org.eclipse.jface.util.OpenStrategy.access$0(OpenStrategy.java:250)
	at org.eclipse.jface.util.OpenStrategy$1.handleEvent(OpenStrategy.java:309)
	at org.eclipse.swt.widgets.EventTable.sendEvent(EventTable.java:89)
	at org.eclipse.swt.widgets.Display.sendEvent(Display.java:4131)
	at org.eclipse.swt.widgets.Widget.sendEvent(Widget.java:1055)
	at org.eclipse.swt.widgets.Display.runDeferredEvents(Display.java:3944)
	at org.eclipse.swt.widgets.Display.readAndDispatch(Display.java:3547)
	at org.eclipse.e4.ui.internal.workbench.swt.PartRenderingEngine$5.run(PartRenderingEngine.java:1173)
	at org.eclipse.core.databinding.observable.Realm.runWithDefault(Realm.java:339)
	at org.eclipse.e4.ui.internal.workbench.swt.PartRenderingEngine.run(PartRenderingEngine.java:1062)
	at org.eclipse.e4.ui.internal.workbench.E4Workbench.createAndRunUI(E4Workbench.java:155)
	at org.eclipse.ui.internal.Workbench.lambda$3(Workbench.java:636)
	at org.eclipse.core.databinding.observable.Realm.runWithDefault(Realm.java:339)
	at org.eclipse.ui.internal.Workbench.createAndRunWorkbench(Workbench.java:563)
	at org.eclipse.ui.PlatformUI.createAndRunWorkbench(PlatformUI.java:151)
	at org.eclipse.ui.internal.ide.application.IDEApplication.start(IDEApplication.java:155)
	at org.eclipse.equinox.internal.app.EclipseAppHandle.run(EclipseAppHandle.java:203)
	at org.eclipse.core.runtime.internal.adaptor.EclipseAppLauncher.runApplication(EclipseAppLauncher.java:137)
	at org.eclipse.core.runtime.internal.adaptor.EclipseAppLauncher.start(EclipseAppLauncher.java:107)
	at org.eclipse.core.runtime.adaptor.EclipseStarter.run(EclipseStarter.java:400)
	at org.eclipse.core.runtime.adaptor.EclipseStarter.run(EclipseStarter.java:255)
	at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
	at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
	at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
	at java.lang.reflect.Method.invoke(Unknown Source)
	at org.eclipse.equinox.launcher.Main.invokeFramework(Main.java:659)
	at org.eclipse.equinox.launcher.Main.basicRun(Main.java:595)
	at org.eclipse.equinox.launcher.Main.run(Main.java:1501)
	at org.eclipse.equinox.launcher.Main.main(Main.java:1474)

Caused by: com.mongodb.CommandFailureException: { "serverUsed" : "myhost:27017" , "ok" : 0.0 , "errmsg" : "The 'cursor' option is required, except for aggregate with the explain argument" , "code" : 9 , "codeName" : "FailedToParse"}
	at com.mongodb.CommandResult.getException(CommandResult.java:76)
	at com.mongodb.CommandResult.throwOnError(CommandResult.java:140)
	at com.mongodb.DBCollection.aggregate(DBCollection.java:1798)
	at com.mongodb.DBCollection.aggregate(DBCollection.java:1778)
	at com.mongodb.DBCollection.aggregate(DBCollection.java:1766)
	at org.eclipse.birt.data.oda.mongodb.internal.impl.MDbOperation.callAggregateCmd(MDbOperation.java:355)

	... 59 more



How should I write the query's structure to join two or more collections together? Should I use another patch?

2) Another way I found to create a Data Set is to use an Scripted Data Source Connection using an open/fetch method but no results are showing in Preview Results.

I would be grateful if can get some help in the meantime.
Greetings.
Rodrigo.

[Updated on: Fri, 15 February 2019 18:52]

Report message to a moderator

Previous Topic:Strange missing CDT console output
Next Topic:SWT libraries missing from install
Goto Forum:
  


Current Time: Sun May 19 15:01:06 GMT 2019

Powered by FUDForum. Page generated in 0.02702 seconds
.:: Contact :: Home ::.

Powered by: FUDforum 3.0.2.
Copyright ©2001-2010 FUDforum Bulletin Board Software

Back to the top