Qlik MongoDB Connector: socket error or timeout upon loading a large dataset

Ayaka_Hanazono — Tue, 10 May 2022 17:34:28 GMT

When loading a large dataset via Qlik MongoDB connector, the following error occurs, and the data load fails:

Error: ERROR [HY000] [Qlik][MongoDBODBC] (110) Error from MongoDB Client: Failed to send "find" command with database "database_name": Failed to read 4 bytes: socket error or timeout (Error Code: 4)

Reducing the data volume eliminates the issue, which may be an alternate workaround.

Environment

Qlik ODBC connector package using MongoDB connector

Resolution

Specify the Socket Timeout value in the Advanced section of the connector configuration:

Name: SocketTimeoutMS

Value: 1200000 (in milliseconds/20 minutes)

The image is retrieved from Qlik Cloud.

Cause

The default value of SocketTimeout for the connector is -1.

However, if the connector doesn't set a specific timeout value, the mongo-c-driver library the Simba MongoDB
ODBC Connector uses as a third-party dependency would determine a behavior.

article Qlik MongoDB Connector: socket error or timeout upon loading a large dataset in Official Support Articles

Qlik MongoDB Connector: socket error or timeout upon loading a large dataset

Environment

Resolution

Cause