Mongodb Connection failing in November 2020 Patch 2

[nsm1234567]

Hi there,

We recently upgraded to Qliksense November 2020 Patch 2 from Qliksense June 2020.  We had a MongoDB connection running prior to the upgrade.  After the upgrade, the extract started crashing.  When I tried to test the connection, I got the following error:

ERROR [HY000] [Qlik][MongoDBODBC] (110) Error from MongoDB Client: Authentication failed. (Error Code: 11)

I tested this on an older version of Sense and had no issues.  I see that changes have been made to the connector where more parameters are available, but don't see anything in the docs about changed behaviour.  Is this a bug, or do I need to adjust something on the config of this connection?

[LeonardoSudo]

Hi,
Did you get it to work?

[nsm1234567]

Hey Leonardo,

Unfortunately not.  I reached out to our partner and they reported this to Qlik.  It's apparently a bug that needs to be resolved.

[oliverwhittle]

Hello, We are also receiving the same issue, has a solution been presented yet or a fix?

[LeonardoSudo]

Hello,

We're using SP2.

I think the solution is on SP3...##- Please type your reply above this line
-##

[oliverwhittle]

Hi,

We are on SP3, however received the same error. 

This was resolve by adding by:

Witin Advanced Add:

- Name: authSource

- Value dbname

this resolves the authentication issue.

Kind Regards,

Oliver

[Flo32]

Hello,

We have exactly the same problem with our MongoDB connection.

I have try your workaround without success.

We have 4 parameters:

- Server / Port / Database

- Authentification: MongoDB Username and Password

- User name / password

I have tried to put in "advanced" as suggest

- Name: authSource

- Value: SLS (dbname)

It does not works.

Any idea why?

Many thanks in advance for your response,