pentaho / pentaho-mongodb-plugin Goto Github PK

Hi i've this error?
num of collection is a 47110.
driver mongodb is a 2.7.2
PDI: 4.4.0 Stable
/**************** ERROR/
ERROR 26-07 11:13:23,407 - Data - Unexpected error
ERROR 26-07 11:13:23,408 - Data - com.mongodb.MongoException$CursorNotFound: cursor not found on server
at com.mongodb.DBApiLayer$Result.init(DBApiLayer.java:391)
at com.mongodb.DBApiLayer$Result._advance(DBApiLayer.java:454)
at com.mongodb.DBApiLayer$Result.hasNext(DBApiLayer.java:418)
at com.mongodb.DBCursor._hasNext(DBCursor.java:503)
at com.mongodb.DBCursor.hasNext(DBCursor.java:523)
at org.pentaho.di.trans.steps.mongodbinput.MongoDbInput.processRow(MongoDbInput.java:77)
at org.pentaho.di.trans.step.RunThread.run(RunThread.java:50)
at java.lang.Thread.run(Thread.java:662)

Error i found i am attaching here..

[test - MongoDB Output] INFO org.mongodb.driver.connection - Opened connection [connectionId{localValue:2, serverValue:8}] to localhost:27017
java.lang.NoSuchMethodError: com.mongodb.WriteResult.getLastError()Lcom/mongodb/CommandResult;
at org.pentaho.di.trans.steps.mongodboutput.MongoDbOutput.doBatch(MongoDbOutput.java:339)
at org.pentaho.di.trans.steps.mongodboutput.MongoDbOutput.processRow(MongoDbOutput.java:211)
at org.pentaho.di.trans.step.RunThread.run(RunThread.java:62)
at java.lang.Thread.run(Thread.java:744)

forcefully telling us use Text file input instead of csv Input. But time taken to execute a million records are faster in csvInput not in Text file input.

import org.pentaho.di.trans.steps.textfileinput.EncodingType;
import org.pentaho.di.trans.steps.textfileinput.TextFileInput;
import org.pentaho.di.trans.steps.textfileinput.TextFileInputField;
import org.pentaho.di.trans.steps.textfileinput.TextFileInputMeta;

Can we have lighter version of mongo insert where it does not do lot of loops. Takes the data from prev step map the data to with valueMetaInterface name and dump to Mongo ..

From Modified Java Script Value step, we can dynamically create transformation(rewrite .ktr file). By using “var meta = new org.pentaho.di.trans.TransMeta( ktrFileName );”, we can use the API defined in the source code. But Mongodb plugin is not among those original steps, how can we use API defined in Mongodb plugins?
I got the idea from the blog here: https://dankeeley.wordpress.com/2015/01/08/non-native-metadata-injection/comment-page-1/#comment-26

Hi,
We were previously using mongodb 2.6 and java mongodb driver version was 2.11.1. But now we have updated mongodb version to 3.0.1 and java driver to 2.13 for compatibility purposes. Kindly can you provide an update on when we can expect latest version of pentaho-mongodb-plugin?

Note*: We are currently facing an error "Can not open connection with same db twice".

Hello,

I have downloaded your plugin, but when running "ant" to generate, it complains about a missing "build.xml" file. Can you provide this file?

Thanks.

I want to track hours many rows inserted / updated to mongodb for MongodbOutput so just want to enable log4j to debug the plugin.

Thanks.

Hello, is there any way to have the ssl section added, even just a checkbox that appends "ssl=true" to the connection string? Or is there a way to do it in the current version and i am just completely missing it?

Will the mongo driver version ever be updated? The version used 3.2.2 does not support the BigDecimal type and hence unusable for any sort of economic applications. I manually rebuild the step by upping the version but then karaf throws all sort of weird errors. It would be great if the driver version was increased.