Welcome and thank you for joining our new OpenText forum. Your questions, responses, best practices, and tips shared with other members will help make this channel vibrant. We're glad you're joining us and look forward to collaborating with you online.

Check out the Getting Started With OpenText Forums for tips on personalizing your experience.

MongoDB & Birt Aggregation

Hi
I'm trying to create reports in BIRT, but I'm getting some errors when I execute an aggregation command to join two or more collections. Is there a way to properly execute the queries, like a patch or a fix?
The following error shows as follow:
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"}...

How can I use the 'cursor' option in the command? Is there another way to join two or more collections in BIRT?

I'll be grateful if I get an answer.
Regards

Comments

Sign In or Register to comment.