Error in ODBC or MongoDB

[Gaddam]

Hello Everyone, 

I am trying to fetch the data from MongoDB through ODBC driver. List of collections are defined. Among them i am having issue with one collection. when i try to get data from that collection i am getting error like this

DataSource.Error: ODBC: ERROR [HY090] [MySQL][ODBC 1.4(w) Driver][mysqld-5.7.12 mongosqld v2.14.5]One or more parameters exceed the maximum allowed name length
Details:
DataSourceKind=Odbc
DataSourcePath=dsn=MongoDB
OdbcErrors=[Table]

Not able to figure the issue. Did anyone faced this issue? it would much help if someone guide me with it.

Thanks in advance for your time 

Regards Sushma

[v-shex-msft · Accepted solution]

HI @Gaddam,

According to the error message, it seems like the issue is related to the connection string and ‘one or more parameters exceed the maximum allowed name length’. You can also take a look at the following document about limit on MongoDB if helps:

MongoDB Limits and Thresholds — MongoDB Manual

Regards,

Xiaoxin Sheng

[Gaddam]

To add more info to the above issue. Among list of the collection as shown in attached pic. I don't have any issue when get data from the collections Dependency_dependencies,ExecutionDetails, ExecutionDetails_execution_details, ObjectUnderTest, QualityGate. Only getting error with TestSuiteExectionInfo and also observed below that some random files which are not collections.