Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE

Qlik Sense UDC Excel via ODBC tasks fail with ERROR [08004] [Microsoft][ODBC Excel Driver] Too many client tasks

No ratings
cancel
Showing results for 
Search instead for 
Did you mean: 
Andreas_Giesbrecht

Qlik Sense UDC Excel via ODBC tasks fail with ERROR [08004] [Microsoft][ODBC Excel Driver] Too many client tasks

Last Update:

Aug 8, 2022 3:41:37 AM

Updated By:

Sonja_Bauernfeind

Created date:

Jul 26, 2022 12:19:21 AM

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 [08004] [Microsoft][ODBC Excel Driver] Too many client tasks

 

Environment

Resolution

The following options seem to solve the issue:

  1. A reinstalling of the Windows Patches for "Microsoft Access 2016 Runtime"
  2. Installing of  "Microsoft Access Database Engine 2016"  

 

Cause

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".

 

Related Content 

Example for Qlik Sense to synchronize users and attributes from excel
Create and Sync a UDC with Microsoft Excel Driver

Labels (1)
Comments
E-mergo
Partner - Contributor
Partner - Contributor

Hi Andreas, 

Do you have any more information about which patch we should uninstall/reinstall? 

Kind regards,

Andrew

Sonja_Bauernfeind
Digital Support
Digital Support

Hello @E-mergo 

We have seen success by uninstalling for example:

patches.png

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 

 

E-mergo
Partner - Contributor
Partner - Contributor

Hi,

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

Version history
Last update:
‎2022-08-08 06:41 AM
Updated by: