Skip to main content
Announcements
Introducing Qlik Answers: A plug-and-play, Generative AI powered RAG solution. READ ALL ABOUT IT!
cancel
Showing results for 
Search instead for 
Did you mean: 
Leonardo_Allog
Contributor II
Contributor II

Error mongodb

Hello community!

I'm trying to extract a collection in our mongodb, but it returns the error below, the first time I've seen it and I didn't find material about it.
Has anyone caught him?

(Connector error: Invalid row status 5 at 32)

I made the query by select * and using the connector and letting Qlik assemble the query.

I'm using Qlik Cloud, on premise it works perfectly.

Allog_0-1680295261994.png

 

 
Labels (2)
2 Replies
AronC
Partner - Creator II
Partner - Creator II

@Leonardo_Allog  Did you manage to solve this problem?

Leonardo_Allog
Contributor II
Contributor II
Author

Hello @AronC !

As mongodb does not have internal data typing, a specific date field, some records were as date and others as string, as qlik takes a sample of the base to identify the types, it gave an error.
After the programmers corrected and put all the dates as date, qlik was able to read it.