Exception after deleting a non-used tab from admin mode

Member since: 2010

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
  • Member since: 2004

    Make sure your db connection string contains MultipleActiveRecordSet=true

    #82514 Mar 14, 2014 4:55
  • 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
  • Member since: 2010

    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