MongoDB error - The GuidRepresentation for the reader is CSharpLegacy,**UuidLegacy, not UuidStandard

[rohitk1609]

Hi team,

We are using Qlik Web Connector Connector Version: 1.0.8.29766. It is licensed for MongoDB. We know this license is deprecated from market but due to its presence on large level at our Qlik site we are continuing with it.

We have recently upgrade MongoDB from 3.2 to 4.2.x version and testing our Qlik Web MongoDB connector and getting this error 

to fix this I found one Qlik article https://support.qlik.com/articles/000050290

This says append uuidRepresentation=Standard as postifx or after server/connection string. When I tried it it returns new error

The way I am appending the suggested string as

MongoDBHostName1.com,MongoDBHostName2.com,MongoDBHostName3.com?uuidRepresentation=Standard

Can you please help me to understand why this error is coming with 4.2.x version, is there is anything I am missing while using suggested Qlik solution or I can suggest to my DB team what you set to avoid this error?

Thanks,

Rohit

[chrisbrain]

Hi - The part of your screen shot I can see looks a little odd to me - I can see:

uuidRepresentation=Standard:27017

Any additional options look like they should be & separated (see https://docs.mongodb.com/manual/reference/connection-string/) but this looks like it might be a port number appended to the Standard setting.

[rohitk1609]

This is the error:

There was an error running the table (Invalid connection string 'mongodb://qlik:***Password***@MongoDBHostName1.com,MongoDBHostName2.com,pMongoDBHostName3.com?uuidRepresentation=Standard:27017/qlik_database'.)

Can you please help me to implement Qlik article ?

Am I missing anything. I have just added "?uuidRepresentation=Standard" after server or connection string in box

[chrisbrain]

This ':27017/qlik_database' looks like it's in the wrong place to me if you look at the examples on:

https://docs.mongodb.com/manual/reference/connection-string/

The options (e.g. your '?uuidRepresentation=Standard') should be at the very end.

[rohitk1609]

I am appending the suggested sting at last. Check the image below:

I am not sure how it would come at last in result string ?

[chrisbrain]

Ah I see - and you have 'mongodb://' at the start where you enter the connection string?

In that case I am not sure.

[rohitk1609]

I didn't add 'mongodb://' at start. this comes when it return error and says this is the generated string with error.

[chrisbrain]

Can you try creating a full mongodb connection string using the docs I linked to and starting with mongodb:// and entering that into the parameter box?

[rohitk1609]

if I pass this to server/connection string, it works fine and list all the collections

mongodb://UserName:password@MongoHostName1.com, MongoHostName2.com, MongoHostName3.com:27017/qlik_database?uuidRepresentation=Standard

My question here is if I append ?uuidRepresentation=Standard as post fix with "MongoHostName1.com, MongoHostName2.com, MongoHostName3.com", then why ?uuidRepresentation=Standard is coming in between?

Thanks,

Rohit

[chrisbrain]

I am not sure - but it sounds like you have a workaround now?