topic Re: CLI error - too many client tasks in SAS Software for Learning Community

CLI error - too many client tasks

p_homann — Thu, 26 Jan 2023 21:54:08 GMT

Hi! I have two computers running Windows 10 that have identical SAS installations, and (theoretically) everything else is the same as well. I am running some code that works fine on one computer, but results in the following errors on the other when trying to connect to MS Excel/Access:

ERROR: CLI error trying to establish connection: [Microsoft][ODBC Excel Driver] Too many client tasks.

ERROR: CLI error trying to establish connection: [Microsoft][ODBC Microsoft Access Driver] Too many client tasks.

Any suggestions on what I can compare on the two computers to figure out why one is having this issue?

Thanks in advance!

Re: CLI error - too many client tasks

SASKiwi — Thu, 26 Jan 2023 22:54:03 GMT

I suggest you reboot your problematic computer, start SAS only (no other apps open) and run your code again. Do you still get the errors?

Also is the MS Office version the same on both computers?

Re: CLI error - too many client tasks

p_homann — Fri, 27 Jan 2023 17:49:44 GMT

Thank you for the quick response. I rebooted the computer and tried again with no other apps open . . . unfortunately the same thing. I failed to notice yesterday, that when running the code on the problematic PC, some successful Excel connections are made earlier in the program, but once the first error is encountered, the remaining attempts all result in the error. Can you think of anything else to check, or is there a way to "monitor" client tasks?

Re: CLI error - too many client tasks

SASKiwi — Fri, 27 Jan 2023 20:55:44 GMT

Are you using LIBNAMEs by any chance to connect? If so add this after each finished connection:

LIBNAME <MyLibref> clear;

Can you also post an example of your LIBNAMEs.

Re: CLI error - too many client tasks

p_homann — Fri, 27 Jan 2023 21:54:34 GMT

Thanks again for your input, however I am already doing this.

Re: CLI error - too many client tasks

Reeza — Fri, 27 Jan 2023 22:50:44 GMT

Are multiple computers/people
accessing this file at the same time?

Re: CLI error - too many client tasks

SASKiwi — Sat, 28 Jan 2023 22:39:16 GMT

I'd like to see your LIBNAME statement though. Looks like you are using the ODBC engine - have you compared the ODBC source definitions between the PCs?

Re: CLI error - too many client tasks

p_homann — Mon, 30 Jan 2023 17:57:39 GMT

No, this is a stand-alone PC accessing files that are stored locally.

Re: CLI error - too many client tasks

p_homann — Mon, 30 Jan 2023 18:02:17 GMT

Here is an example of the LIBNAME statement:

libname check2 clear;
libname check2 odbc complete="dsn=Excel Files; dbq=%trim(&workLoc)\MyFileName.xlsb; readOnly=false";

This is used multiple times throughout the process and only fails on this one PC (but works 8-10 times prior to failing). This code is inherited and has been used for many years and ported to several different PCs throughout its lifespan . . . this is the only PC where we have run into issues.

Thanks again for your time!

Re: CLI error - too many client tasks

terryeastman — Fri, 24 Mar 2023 20:05:40 GMT

Same issue just starting to appear consistently in all our processes. I wonder if there was an update to SAS and / or Microsoft excel that creates the issue in the background. Our processes have been running w/o issue since extensions were XLS. XLSX worked too up until very recently

Re: CLI error - too many client tasks

ballardw — Fri, 24 Mar 2023 20:10:21 GMT

@terryeastman wrote:

Same issue just starting to appear consistently in all our processes. I wonder if there was an update to SAS and / or Microsoft excel that creates the issue in the background. Our processes have been running w/o issue since extensions were XLS. XLSX worked too up until very recently

Recent switch in Office install??

I have a suspicion that Office 365 may change features in the background that break existing code, especially from non-Microsoft products. Or I may be paranoid after One Drive decided to remove several hundred of my SAS program examples.

Re: CLI error - too many client tasks

p_homann — Fri, 24 Mar 2023 20:34:06 GMT

(reposting the same message . . . I had responded to the wrong post)

Hi! Thank you for your response (I was afraid this post had died).

The only difference we have been able to track down between the two computers is the Access and Excel ODBC drivers.

Would you be able to check your driver version for:

Microsoft Excel Driver (*.xls, *.xlsx, *xlsm, *xlsb)
Microsoft Access Driver (*.mdb, *.accdb)

(just in case you don't know where to this info: ODBC Data Source app --> Drivers tab)

Thanks!

Re: CLI error - too many client tasks

SASKiwi — Fri, 24 Mar 2023 21:16:59 GMT

I suggest you open a Tech Support track. They are in the best position to help you identify the problem.