trouble with Sql task - VisualCron - Forum

Community forum

itrevino
2020-10-30T15:58:55Z
I have been getting an error message in my sql task: There is already an open DataReader associated with this Command which must be closed first.

Does anyone know how to troubleshoot this error.

Some of the things I have tried is restarting the Visual Cron service where its hosted, restarted my Sql Server, Take my database offline & online, alter my database with setting single user with rollback immediate and then resetting it to multi user, or anything really that I would think would kill any connection.

Any help is appreciated, thanks!
Support
2020-11-05T16:02:25Z
Originally Posted by: itrevino 

I have been getting an error message in my sql task: There is already an open DataReader associated with this Command which must be closed first.

Does anyone know how to troubleshoot this error.

Some of the things I have tried is restarting the Visual Cron service where its hosted, restarted my Sql Server, Take my database offline & online, alter my database with setting single user with rollback immediate and then resetting it to multi user, or anything really that I would think would kill any connection.

Any help is appreciated, thanks!



Hi,
So this is a windows error, and a quick googling shows a couple of solutions, have you tested them?
https://stackoverflow.co...-command-which-must-be-c 
https://stackoverflow.co...ommand-which-mu/18475525 
https://www.codeproject....ataReader-associated-wit 
Michael
Support
http://www.visualcron.com 

Please like  VisualCron on facebook!
Scroll to Top