Search or browse our knowledge base to find answers to your questions ranging from account questions to troubleshooting error messages. The content is curated and updated by our global Support team
Qlik Sense UDC Excel ODBC tasks start to fail with the following error after Windows Patch upgrades for "Microsoft Access 2016 Runtime" with the following error:
ERROR  [Microsoft][ODBC Excel Driver] Too many client tasks
The following options seem to solve the issue:
The cause of the issue is not 100% clear however the issue seems to be caused by the new Windows Patches for "Microsoft Access 2016 Runtime".
Example for Qlik Sense to synchronize users and attributes from excelCreate and Sync a UDC with Microsoft Excel Driver
Do you have any more information about which patch we should uninstall/reinstall?
We have seen success by uninstalling for example:
Though there may be additional ones installed if you are affected by this issue; we do not have a comprehensive list of which patches affect this issue.
All the best,Sonja
We had success by downloading the Microsoft Access 2016 Runtime and Microsoft Access Database Engine 2016 and choosing repair installation. Requires stopping Qlik services and a restart after.
Cheers,Andrew - E-mergo