Getting "WinHttp request failed with code (10093)" errors in Spotfire when using MongoDB ODBC driver

Getting "WinHttp request failed with code (10093)" errors in Spotfire when using MongoDB ODBC driver

book

Article ID: KB0083646

calendar_today

Updated On:

Products Versions
Spotfire Drivers 1.2.0
Spotfire Web Player All versions

Description

When opening reports using connections to MongoDB through the ODBC driver included in the TIBCO Spotfire Drivers 1.2.0 bundle (version 2.0.0), you may encounter that the client software (e.g. Spotfire Analyst or Web Player) stops responding and you'll have to force a restart to get it back up and running. The issue occurs when you try and create three or more connections with the driver, which causes the .NET session to run out of available sockets. When using TIBCO Spotfire Analyst, this is limited to that client process. When using the Web Player however, this affects all user sessions and it is important to ensure that this is prevented on the Web Player.

Issue/Introduction

When trying to run reports using the MongoDB ODBC driver from TIBCO Spotfire Driver 1.2.0, the client stops responding and the logs are filled with "WinHttp request failed with code (10093)" errors.

Resolution

Download the TIBCO Spotfire Drivers 1.3.0 (or later) bundle and install the MongoDB driver included there on the machines running the TIBCO Spotfire Analyst client and TIBCO Spotfire NodeManager / Web Player server.