Exception after deleting a non-used tab from admin mode

Marija Jemuovic

Vote:

After I delete a tab from admin mode, I get 500:

There is already an open DataReader associated with this Command which must be closed first.

StackTrace:

at System.Data.SqlClient.SqlInternalConnectionTds.ValidateConnectionForExecute(SqlCommand command)
at System.Data.SqlClient.SqlConnection.ValidateConnectionForExecute(String method, SqlCommand command)
at System.Data.SqlClient.SqlCommand.ValidateCommand(String method, Boolean async)
at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, TaskCompletionSource`1 completion, Int32 timeout, Task& task, Boolean asyncWrite)
at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method)

Do you get the same error, so that I report a bug or is it just me?

#82484

Mar 13, 2014 13:54

Johan Björnfot

Vote:

Make sure your db connection string contains MultipleActiveRecordSet=true

#82514

Mar 14, 2014 4:55

Hans Oosting

Vote:

Thank you for the tip Johan,

I found your reply after a search for the more generlized scenario where the error "There is already an open DataReader associated with this Command which must be closed first. " occurred.

Applying your solution generated the server error:

Keyword not supported: 'multipleactiverecordsets'. Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.

Exception Details: System.ArgumentException: Keyword not supported: 'multipleactiverecordsets'.

After looking up the keyword it appeared that in the version I am using the proper keyword is:

MultipleActiveResultSets

The connectionstring would be formatted as follows:

<connectionStrings>
     <add connectionString="Server=localhost;Database=EPiServerDB_9ca77233;User ID=xxxxx;Password=yyyyy;MultipleActiveResultSets=True" name="EPiServerDB" providerName="System.Data.SqlClient" />
  </connectionStrings>

#147106

Edited, Apr 06, 2016 11:36

Marija Jemuovic

Vote:

Hi, Hans,

It looks like this is elsewhere, the error suggests that you are using multipleactiveRECORDsets, should be resultsets. Do you have a typo in the error or can you search your config files for that keyword?

Exception Details: System.ArgumentException: Keyword not supported: 'multipleactiverecordsets'.

#147117

Apr 06, 2016 15:09