Skip to Content (Press Enter)
2024-01-05 16-00-17
Filipe Lourenço
58Views
3Comments
There is already an open DataReader associated with this Command which must be closed
Question
What to do when receiving this kind of error :

There is already an open DataReader associated with this Command which must be closed first
0
0
10 May 2016
Copy Link
2017-10-09 20-45-22
André Siébra
How exactly are you getting this error?
0
0
10 May 2016
Copy Link
2024-01-05 16-00-17
Filipe Lourenço
I dont know why.It refers one query but if i delete that query i get the error on another query that exists on preparation
0
0
24 May 2016
Copy Link
2016-08-24 14-28-34
Cláudia Frutuoso
Staff
Hello, Filipe,

Are you still experiencing this issue?

We have encountered a pattern that might cause this error: if you have a query with Max. Records set to 1 and if you use the result of this query to iterate a For Each that runs over other queries, you might hit this error. The query that is shown in the error will be the one inside the For Each and not the one with the Max. Records set to 1.

You can workaround the problem by instead of using a For Each, access the results of the query directly (it only has one row anyway).

Let me know if this solves your issue.
DataReaderIssue.PNG
0
0
08 Jul 2016
Copy Link
Community GuidelinesBe kind and respectful, give credit to the original source of content, and search for duplicates before posting.