Manage Sections: DataReader error on attempt to create new sectio

Manage Sections: DataReader error on attempt to create new section

Alex Potapenko

Vote:

Hi all,

I'm trying to create new section in EPiServer Mail, but on save I always receive next error:

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

Stack Trace:

[InvalidOperationException: There is already an open DataReader associated with this Command which must be closed first.]
   System.Data.SqlClient.SqlInternalConnectionTds.ValidateConnectionForExecute(SqlCommand command) +4846116
   System.Data.SqlClient.SqlConnection.ValidateConnectionForExecute(String method, SqlCommand command) +23
   System.Data.SqlClient.SqlCommand.ValidateCommand(String method, Boolean async) +144
   System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, DbAsyncResult result) +87
   System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method) +32
   System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior, String method) +141
   System.Data.SqlClient.SqlCommand.ExecuteDbDataReader(CommandBehavior behavior) +12
   System.Data.Common.DbCommand.ExecuteReader() +12
   EPiServer.Common.Data.DatabaseHandler.GetReader(Boolean inTransaction, String sp, CommandType commandType, Object[] args) +44
   EPiServer.Common.Data.DatabaseHandler.GetReader(String sp, Object[] args) +31
   EPiServer.Common.Data.SiteFactory.GetSiteAliasList(Int32 siteId) +112
   EPiServer.Common.Site..ctor(DbDataReader reader) +168
   EPiServer.Common.Data.SiteEntityProvider.GetEntityInstance(Type type, DbDataReader reader) +56
   EPiServer.Common.Data.SiteFactory.ConstructSite(DbDataReader reader) +76
   EPiServer.Common.Data.SiteFactory.GetSite(Int32 siteId) +118
   EPiServer.Common.Data.SiteFactory.AddSite(ISite site) +398
   EPiServer.Common.SiteHandler.AddSite(ISite site) +39
   EPiServer.Mail.Core.Web.Settings.EditSite.buttonSave_Command(Object sender, CommandEventArgs e) +133
   System.Web.UI.WebControls.Button.OnCommand(CommandEventArgs e) +108
   System.Web.UI.WebControls.Button.RaisePostBackEvent(String eventArgument) +166
   System.Web.UI.WebControls.Button.System.Web.UI.IPostBackEventHandler.RaisePostBackEvent(String eventArgument) +10
   System.Web.UI.Page.RaisePostBackEvent(IPostBackEventHandler sourceControl, String eventArgument) +13
   System.Web.UI.Page.RaisePostBackEvent(NameValueCollection postData) +36
   System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +1565

Can anyone tell me what's going on? And if it possible to fix this issue...

Any help would be appreciated.

Alex.

#40909

Jun 22, 2010 18:57

Håkan Lindqvist

Vote:

Is it possible that you may accidentally replaced the connection string with one without MARS enabled?

MultipleActiveResultSets=True is required, not having that would cause this type of error.

#40915

Jun 23, 2010 9:11

Alex Potapenko

Vote:

Thank you very much!

I really changed connection string and forgot about MARS.

My respect for the invaluable help.

#40917

Jun 23, 2010 10:10