topic Re: Unable to read data from Mogodb using talend open studio in Talend Studio

Unable to read data from Mogodb using talend open studio

Vthota1687286448 — Fri, 15 Nov 2024 21:31:02 GMT

Hi @all

Talend open studio Version: 8.0.1

Mondo Db version : 4.0.9

when in run below job connections look working , but when trying to query collection throws error , please help

Error:

Exception in component tMongoDBInput_1 (MongoDbTOSnowflake)

java.lang.RuntimeException: db error [not authorized for query on qas.Form]

at com.mongodb.DBApiLayer$MyCollection.find(DBApiLayer.java:321)

at com.mongodb.DBCursor._check(DBCursor.java:253)

at com.mongodb.DBCursor._hasNext(DBCursor.java:374)

at com.mongodb.DBCursor.hasNext(DBCursor.java:399)

at usgbc_dev_etl.mongodbtosnowflake_0_1.MongoDbTOSnowflake.tMongoDBInput_1Process(MongoDbTOSnowflake.java:795)

at usgbc_dev_etl.mongodbtosnowflake_0_1.MongoDbTOSnowflake.tMongoDBConnection_1Process(MongoDbTOSnowflake.java:431)

at usgbc_dev_etl.mongodbtosnowflake_0_1.MongoDbTOSnowflake.runJobInTOS(MongoDbTOSnowflake.java:1197)

at usgbc_dev_etl.mongodbtosnowflake_0_1.MongoDbTOSnowflake.main(MongoDbTOSnowflake.java:1035)

Re: Unable to read data from Mogodb using talend open studio

Anonymous — Mon, 07 Aug 2023 00:58:56 GMT

Hello @VENKATESHWARLU thota ,

You need to assign the read role to the mongo db user in question, e.g.

db.grantRolesToUser(

"your_user",

[

{ role: "read", db: "your_db" }

]

)

please refer to the article : https://stackoverflow.com/questions/22067612/mongodb-not-authorized-for-query-admin-system-users

Best regards

Aiming

Re: Unable to read data from Mogodb using talend open studio

Vthota1687286448 — Mon, 07 Aug 2023 02:00:56 GMT

Hi @Aiming Chen

Thanks for the response, but with the same user I can able to query data using Studio 3T,

I will double with the MongoDb admin regarding the read role

Thanks,

Venkat

Re: Unable to read data from Mogodb using talend open studio

Vthota1687286448 — Mon, 07 Aug 2023 06:01:59 GMT

@Aiming Chen

MongoDB component ( mongo-1.3.jar)

Talend version 8.0.1

IMPORTANT: when I put a password/username empty in the connection component, the connection is showing success

is there any problem with jar file?

please suggest the correct mongodb jar for talend version 8.0.1

Re: Unable to read data from Mogodb using talend open studio

Vthota1687286448 — Mon, 07 Aug 2023 06:16:31 GMT

@Xiaodi Shi

Re: Unable to read data from Mogodb using talend open studio

Anonymous — Mon, 07 Aug 2023 09:26:16 GMT

Hello @VENKATESHWARLU thota ,

If you select the DB Version = "MongoDB 4.4.X and later" in tMongoDBConnection as the below to re-try?

Re: Unable to read data from Mogodb using talend open studio

Vthota1687286448 — Mon, 07 Aug 2023 13:57:43 GMT

HI @Aiming Chen

I see below the MongoDB connection component

Re: Unable to read data from Mogodb using talend open studio

Vthota1687286448 — Sat, 19 Aug 2023 15:37:30 GMT

@Xiaodi Shi @not specified not specified

can guys able to help me ?