ODBC Error Message: Too many client Tasks

Error Message: Exception: ERROR [08004] [Microsoft][ODBC Excel Driver] Too many client tasks. ERROR [IM006] [Microsoft][ODBC Driver Manager] Driver’s SQLSetConnectAttr failed

I have used ExecuteQuery activity that runs the excel file however, the run only lasts for a couple of transactions per file. the file contains 16k line items. it runs for the first 20 or so transactions and then throws this error. But when i run in debug mode, it runs successfully. Any suggestions?

@ashton.lalchan,

It seems excel file in unable to handle the speedy query execution. Try adding few seconds of delay after 10-15 transactions.

Thanks,
Ashok :slight_smile:

Hi @ashokkarale, I still get the same error:
image

@ashton.lalchan,

Open your connection string and try changing this maxbuffersize to more than current

Thanks,
Ashok :slight_smile:

my max buffer is set to 2048 already

@ashton.lalchan,

Try changing it to higher like 4096.

Thanks,
Ashok :slight_smile:

@ashokkarale
yes I have just change it to 4096 and still error persists, even with a delay

@ashton.lalchan

Are you usign connect to db inside a loop?

if so refrain using liek that and do the connection in init and reuse same connection

cheers