Cannot import data due to the following error message:-
Orchestrate Data Flow Import has failed. The detailed information is as follows:
ERROR [08004] [Microsoft] [ODBC Text Driver] too many client tasks.
ERROR [08004] [Microsoft] [ODBC Driver Manager] Driver's SQLSetConnectAttr failed.
Import Command:
SELECT 'SkilledCrew' AS AttribName
, SkilledCrew AS floatValue
, JobCode
, JobCode AS ERP_TaskRef
FROM Tasks.csv
WHERE JOBCODE IS NOT NULL
The issue is with the ODBC 64 bit connection. Please download the Microsoft Data Access Components (MDAC) 2.8 Software Development Kit from the Microsoft website. If this does not resolve the issue, please upgrade your PC to Windows 11 operating system. If you cannot upgrade to Windows 11 yet, we can add an SQL command to your Orchestrate database to force the Microsoft 64 bit Access Text driver to read the file path where the CSV files are kept. Please raise a new case online and reference the title of this article.