Troubleshooting
Problem
Attempts to use the RPX to open IBM Rational RequisitePro projects that are stored in MS Access databases results in the error "System.Runtime.InteropServices.COMException (0x80040E4D): [Microsoft][ODBC Microsoft Access Driver] Too many client tasks."
Symptom
The full error message is as follows:
System.Runtime.InteropServices.COMException (0x80040E4D):
[Microsoft][ODBC Microsoft Access Driver] Too many client tasks.
at
ReqProEventGenerator.RequisiteProEventManager.CreateConnection(String
ProjectName, String ProjectPath, String UserName, String Password, enumProjectFlags enumPrjFlg, ApplicationClass& reqProApplication, Project& ReqProProject)
Cause
The Microsoft Jet Driver is limited to only a certain number of connections. Per Microsoft, the Jet Driver can only support a maximum of 64 connections per process. However, sometimes it can fail with less than 64 connections due to memory issues because it is a file based DB and there is a lot of page caching.
Resolving The Problem
Possible solutions to this Microsoft Access Driver error:
- Make sure that your RPX code is closing each connection before opening a new one. If connections are not closed properly, they are pooling each time a new one is made until it reaches the limitation and the error is thrown.
- If you are using an application to run your script and open multiple connections, make sure that it is not exceeding 64 connections all at once. Try reducing the number of simultaneous connections until the error is not seen when executing the script.
- Move projects to a supported enterprise database (SQL, Oracle, DB2) where this limitation will not be seen.
Was this topic helpful?
Document Information
Modified date:
23 June 2018
UID
swg21409628