topic Re: tMongoDBRow - still using eval ??? in Talend Studio

tMongoDBRow - still using eval ???

bglaplante — Sat, 16 Nov 2024 04:13:53 GMT

This very old post https://community.talend.com/t5/Design-and-Development/How-to-rename-a-MongoDB-collection/td-p/75872

indicated that tMongoDBRow would no longer be using eval, but instead would be using runCommand by version 6.1. I am on version 7.1.1 and trying the example... I get an error ... error 13 - unauthorized to execute command { $eval: ....

Eh? The admin doesn't want to give eval permission. Was this not implemented or?

Thank you.

I'm on mongoDB 3.6.14

Re: tMongoDBRow - still using eval ???

Anonymous — Thu, 31 Oct 2019 08:37:38 GMT

Hello,

Starting from V 6.1, we have added a new option that uses the "runCommand" feature to execute commands. This ensures the compatibility between different studio versions and the latest as we keep the $eval option and add the new "runCommand" option.

Please have a look at this component reference:https://help.talend.com/reader/JAVIF8qLh6BhZ~e4~IDqtw/Lgd0SPBAv6Mkw~tV_U2~qw

Here is the related jira issue:https://jira.talendforge.org/browse/TBD-2811

Best regards

Sabrina

Re: tMongoDBRow - still using eval ???

bglaplante — Thu, 31 Oct 2019 15:35:42 GMT

OK, this helps, especially as the link I referenced above says to

Uncheck the 'Execute command' box and type in the command as below

so that's wrong. I need to check Execute Command in order to use runCommand.

Can you provide a functioning example of a command (proper syntax)? As

"db.oldname.renameCollection('newName')"

Given in the old answer... results in "no such command"

Re: tMongoDBRow - still using eval ???

bglaplante — Thu, 31 Oct 2019 21:55:57 GMT

OK - got a bit further --- the correct syntax would be of form

{ renameCollection: "<source_namespace>", to: "<target_namespace>", dropTarget: <true|false>  writeConcern: <document> }

with the " changed to ' when entering this as "construct command from JSON string" in Talend.

that then fails with a mongo error - rename collection may only be run against the admin database. A fairly significant limitation, which seems to be in MongoDB.

So it appears - without eval permission, there is no way to execute a rename collection with tMongoDBRow in my situation.

Re: tMongoDBRow - still using eval ???

Anonymous — Fri, 01 Nov 2019 02:49:49 GMT

Hello,

@bglaplante wrote:

OK - got a bit further --- the correct syntax would be of form
{ renameCollection: "<source_namespace>", to: "<target_namespace>", dropTarget: <true|false>  writeConcern: <document> }
with the " changed to ' when entering this as "construct command from JSON string" in Talend.

that then fails with a mongo error - rename collection may only be run against the admin database. A fairly significant limitation, which seems to be in MongoDB.

So it appears - without eval permission, there is no way to execute a rename collection with tMongoDBRow in my situation.

With your situation, could you please create a jira issue on talend bug tracker?

Best regards

Sabrina