Pentaho BI-由于最近将MongoDB升级到3.6而导致的MongoDB输入聚合错误 [英] Pentaho BI - MongoDB input Aggregation error due to recent MongoDB upgrade to 3.6

问题描述

由于最近将Mogodb升级到3.6，因此pentaho水壶mongoinput步骤聚合无法从Mongodb中获取数据.

Due to recent Mogodb upgrade to 3.6, pentaho kettle mongoinput step aggregation not be able to fetch data from the Mongodb.

错误消息:

com.mongodb.MongoCommandException:命令失败，错误9:'The 需要光标"选项，但带有说明的汇总除外 服务器本地主机上的参数":2915.完整的响应为{"ok":0.0， "errmsg":光标"选项是必需的，但与 说明参数"，代码":9，"codeName":"FailedToParse"}

com.mongodb.MongoCommandException: Command failed with error 9: 'The 'cursor' option is required, except for aggregate with the explain argument' on server localhost:2915. The full response is { "ok" : 0.0, "errmsg" : "The 'cursor' option is required, except for aggregate with the explain argument", "code" : 9, "codeName" : "FailedToParse" }

似乎我需要为pentaho升级mongodb驱动程序，因此我已经下载了mongodb-driver-3.6.3.jar文件并将其保存在pentaho-server \ pentaho-solutions \ system \ karaf \ system \ org中\ mongodb \ mongo-java-driver \ 3.6.3，但问题仍然存在.

It seems that I need to upgrade mongodb driver for the pentaho, so I've downloaded mongodb-driver-3.6.3.jar file and saved it inside pentaho-server\pentaho-solutions\system\karaf\system\org\mongodb\mongo-java-driver\3.6.3, but the issue still exists.

我真的不知道如何升级驱动程序以及是否与它相关联的其他配置.

I don't really know what to do to upgrade the driver and whether there is additional configuration associated with it or not.

有人可以帮助我解决此问题吗?

Can anyone help me to resolve this issue?

推荐答案

要使用新版本，您需要:

To use a new version, you need to:

1. 下载新版本(例如

1. download new version (for example https://oss.sonatype.org/content/repositories/releases/org/mongodb/mongo-java-driver/3.7.1/mongo-java-driver-3.7.1.jar) to directory system/karaf/system/org/mongodb/mongo-java-driver/3.7.1 (where 3.7.1 is version of mongo driver - 3.7.1 works fine with mongo 3.6 too)
2. point in configuration (system/karaf/system/pentaho/pentaho-karaf-features/7.0.0.0-25/pentaho-karaf-features-7.0.0.0-25-standard.xml) a new version of module mongo-java-driver
3. remove cache (system/karaf/caches/) to allow rebuild it.

这篇关于Pentaho BI-由于最近将MongoDB升级到3.6而导致的MongoDB输入聚合错误的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！