Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us to spark ideas for how to put the latest capabilities into action. Register here!
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 (3)
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.