topic Re: MongoDB error - The GuidRepresentation for the reader is CSharpLegacy,**UuidLegacy, not UuidStan in Connectivity & Data Prep

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

rohitk1609 — Thu, 23 Dec 2021 20:03:03 GMT

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

Re: MongoDB error - The GuidRepresentation for the reader is CSharpLegacy,**UuidLegacy, not UuidStan

chrisbrain — Wed, 01 Jul 2020 06:32:47 GMT

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.

Re: MongoDB error - The GuidRepresentation for the reader is CSharpLegacy,**UuidLegacy, not UuidStan

rohitk1609 — Wed, 01 Jul 2020 07:10:18 GMT

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

Re: MongoDB error - The GuidRepresentation for the reader is CSharpLegacy,**UuidLegacy, not UuidStan

chrisbrain — Wed, 01 Jul 2020 07:44:41 GMT

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.

Re: MongoDB error - The GuidRepresentation for the reader is CSharpLegacy,**UuidLegacy, not UuidStan

rohitk1609 — Wed, 01 Jul 2020 08:03:42 GMT

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 ?

Re: MongoDB error - The GuidRepresentation for the reader is CSharpLegacy,**UuidLegacy, not UuidStan

chrisbrain — Wed, 01 Jul 2020 08:18:00 GMT

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

In that case I am not sure.

Re: MongoDB error - The GuidRepresentation for the reader is CSharpLegacy,**UuidLegacy, not UuidStan

rohitk1609 — Wed, 01 Jul 2020 12:08:57 GMT

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

Re: MongoDB error - The GuidRepresentation for the reader is CSharpLegacy,**UuidLegacy, not UuidStan

chrisbrain — Wed, 01 Jul 2020 12:13:39 GMT

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?

Re: MongoDB error - The GuidRepresentation for the reader is CSharpLegacy,**UuidLegacy, not UuidStan

rohitk1609 — Thu, 02 Jul 2020 12:52:01 GMT

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

Re: MongoDB error - The GuidRepresentation for the reader is CSharpLegacy,**UuidLegacy, not UuidStan

chrisbrain — Thu, 02 Jul 2020 13:01:44 GMT

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

Re: MongoDB error - The GuidRepresentation for the reader is CSharpLegacy,**UuidLegacy, not UuidStan

rohitk1609 — Tue, 14 Jul 2020 17:38:41 GMT

Thanks for your help. I am almost there to my solution.

So this problem seems like MongoDB general problem. Would you like to share some inputs which I can share with my mongoDB team that this could be the root cause and please fix it?

They are thinking Qlik connector has problem.

Thanks,

Rohit