My maps run fine from the SmartConnect 21 User Interface, but I find that often my Text file and Excel Source Folder & File Data Source maps DO run on schedule, but all fail with the error:
[Microsoft] [ODBC Text Driver] Too many client tasks.
or
[Micorsoft] [ODBC Excel Driver] Too many client tasks.
The other maps that use BC Odata Queries, SQL ODBC Queries, etc are all unaffected and still run scheduled normally.
I am able to restart the eOne SmartConnect Service and the maps run fine again but after a variable amount of time, the error returns. How do I resolve this issue?
SmartConnect Development has informed support of a multi-threading issue with the 64bit Office ODBC drivers we use for Text and Excel files with that version of SmartConnect 21.
While this works OK for a variable amount of time, sometimes there is a “threading” issue that happens and the Office ODBC Driver crashes which then continues to fail until you start the application – the eOne SmartConnect Service in this case.
The solutions for this issue are:
- Upgrade SmartConnect
Because the Office ODBC Driver is from Microsoft, we cannot change the behavior of the driver to resolve the issue. To work around this from SmartConnect, development has moved away from using the Office ODBC Drivers entirely and read the text & Excel files directly now. The driver change was put into SmartConnect 21.1.0.947 – you would want to install the latest SmartConnect 21 version from the SmartConnect download page to resolve the issue permanently. - Work around the issue by NOT using the eOne Schedule Service
To work around this issue temporarily before upgrading to the latest version, your other option is to NOT use the eOne SmartConnect Service to run scheduled maps. Or at least scheduled maps that are using Excel or Text File Sources since those are the ones that will run into this issue.
The eOne.SmartConnect.RunMapConsole.exe is a command line that will run and will execute ONE map that you pass to it and then the process will finish. Because the application will terminate after execution, there never will be “multiple threads” like the eOne SmartConnect Service has.
There isn’t any documentation on this application I can find but it really is just a command line application that takes the map id as the first and only parameter.
This blog article talks about an odd issue you might run into but shows setting up a Window Task to run the eOne.SmartConnect.RunMapConsole.exe and the MapID as the one parameter.
This second article talks about setting up a batch file to run the map using eone.SmartConnect.RunMapConsole.exe. Not shown is setting up the Windows Task to run the windows batch (bat) file.
