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

问题描述

由于最近 Mogodb 升级到 3.6，pentaho Kettle 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'cursor' 选项是必需的，除了带有解释的聚合服务器 localhost:2915 上的参数'.完整的响应是 { "ok" : 0.0,"errmsg" : "'cursor' 选项是必需的，除了聚合解释参数", "code" : 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. 下载新版本(例如 https://oss.sonatype.org/content/repositories/releases/org/mongodb/mongo-java-driver/3.7.1/mongo-java-driver-3.7.1.jar) 到目录 system/karaf/system/org/mongodb/mongo-java-driver/3.7.1(其中 3.7.1 是 mongo 驱动程序的版本 - 3.7.1 也适用于 mongo 3.6)
2. 指向配置(system/karaf/system/pentaho/pentaho-karaf-features/7.0.0.0-25/pentaho-karaf-features-7.0.0.0-25-standard.xml)新版本的模块mongo-java驱动程序
3. 删除缓存 (system/karaf/caches/) 以允许重建它.

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屋！