Sign in Register
Copied to clipboard

Flag this post as spam?

This post will be reported to the moderators as potential spam to be looked at


  • Ed McColl 6 posts 26 karma points
    Feb 27, 2012 @ 11:19
    Ed McColl
    0

    Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding.

    MemberExport Bugs

    Hi

    We are getting the following when exporting all our member data.

    [SqlException (0x80131904): Timeout expired.  The timeout period elapsed prior to completion of the operation or the server is not responding.]
   System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection) +2030802
   System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection) +5009584
   System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning() +234
   System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) +2275
   System.Data.SqlClient.SqlDataReader.ConsumeMetaData() +33
   System.Data.SqlClient.SqlDataReader.get_MetaData() +86
   System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString) +311
   System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async) +987
   System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, DbAsyncResult result) +162
   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.ExecuteReader(CommandBehavior behavior) +70
   Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteReader(String connectionString, CommandType commandType, String commandText, SqlParameter[] commandParameters) +152
   umbraco.DataLayer.SqlHelpers.SqlServer.SqlServerHelper.ExecuteReader(String commandText, SqlParameter[] parameters) +37
   umbraco.DataLayer.SqlHelper`1.ExecuteReader(String commandText, IParameter[] parameters) +87

[SqlHelperException: Umbraco Exception (DataLayer): SQL helper exception in ExecuteReader]
   umbraco.DataLayer.SqlHelper`1.ExecuteReader(String commandText, IParameter[] parameters) +142
   MemberExport.DAL.MemberData.GetAllMembers(List`1 fields, List`1 membergroups, Int32 memberType, Int32 amountOfRecords) +864
   MemberExport.Library.Helpers.ExportHelper.ExportMembers(ExportState state) +326
   MemberExport.Usercontrols.MemberExport.ExportButton_Click(Object sender, EventArgs e) +44
   System.Web.UI.WebControls.Button.OnClick(EventArgs e) +118
   System.Web.UI.WebControls.Button.RaisePostBackEvent(String eventArgument) +112
   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) +5563

    Copy Link
  • Richard Soeteman 4035 posts 12842 karma points MVP
    Feb 27, 2012 @ 11:28
    Richard Soeteman
    0

    Hi Ed,

    Can you append a connection timeout to your connection string in the web,.config file? Example:

    ;Connection Timeout=30

    You might need to increase the number.

    Hope this helps,

    Richard

    Copy Link
  • Ed McColl 6 posts 26 karma points
    Feb 27, 2012 @ 11:37
    Ed McColl
    0

    Hi Richard,

    I tried that out, updated the UmbracoDbDSN adding the connection timeout parameter. Still timesout after 30 seconds.

    Any ideas?

    Regards

    Ed

    Copy Link
  • Richard Soeteman 4035 posts 12842 karma points MVP
    Feb 27, 2012 @ 11:47
    Richard Soeteman
    0

    Hi Ed,

    That must be a lot of records. I think the command times out that is a setting you can't manage from the web.config file. I'll create a hotfix for you will be available later today.

    Sorry for the inconvience.

    Best,

    Richard

    Copy Link
  • Ed McColl 6 posts 26 karma points
    Feb 27, 2012 @ 11:55
    Ed McColl
    0

    Great stuff Richard

    Not so much the number of members but the number of members attributes which is > 30. If I just extract a subset of the attributes it works fine.

    Thanks in advance.

    Ed

    Copy Link
  • Richard Soeteman 4035 posts 12842 karma points MVP
    Feb 27, 2012 @ 14:15
    Richard Soeteman
    0

    Hi Ed,

    I've created a hotfix. You can download it from http://hotfix.soetemansoftware.nl/Memberexport/ copy the dll's from the zip file to your umbraco install and the timeout error should be gone. I've set timeout to 100000 should be enough.

    Please let me know if this helped you.

    Thanks,

    Richard

    Copy Link
  • Ed McColl 6 posts 26 karma points
    Feb 27, 2012 @ 14:26
    Ed McColl
    0

    Fantastic Richard, that fix did the trick.

    Regards

    Ed

    Copy Link
  • Philip Rashleigh 1 post 21 karma points
    Jun 05, 2014 @ 14:52
    Philip Rashleigh
    0

    Hello,

    I'm experiencing the same issue now but the link for the hotfix is broken? Is there any chance of getting this?

    Thanks,

    Phil

    Copy Link
  • Richard Soeteman 4035 posts 12842 karma points MVP
    Jun 05, 2014 @ 15:08
    Richard Soeteman
    0

    Hi Phil,

    Hotfix should be in the latest release, which version are you using?

    Best,

    Richard

    Copy Link
  • Adriano Fabri 459 posts 1602 karma points
    Feb 04, 2015 @ 15:48
    Adriano Fabri
    0

    Hi Richard,
    I think to have the same problem with a function of my project FALM Housekeeping.

    Where did you set the timeout to 100000?

    Thank you

    Copy Link
  • Richard Soeteman 4035 posts 12842 karma points MVP
    Feb 05, 2015 @ 08:53
    Richard Soeteman
    0

    Hi Adriano,

    In case of SQL Server I use the sql command directly instead of Umbraco data layer

     var sqlConnection = new SqlConnection(Application.SqlHelper.ConnectionString);
 sqlConnection.Open();
 var command = new SqlCommand(sql, sqlConnection);
 command.CommandTimeout = 100000;
 return new SqlServerDataReader(command.ExecuteReader());

    Hope this helps,

    Richard

    Copy Link
  • Adriano Fabri 459 posts 1602 karma points
    Feb 05, 2015 @ 09:01
    Adriano Fabri
    0

    just like I thought

    thank you richard.

    Copy Link
  • Guttorm Haaversen 2 posts 22 karma points
    Aug 05, 2016 @ 11:21
    Guttorm Haaversen
    0

    I also get a timeout when using one of the following commands:

    ApplicationContext.Services.MemberService.GetAllMembers() Umbraco.Core.ApplicationContext.Current.Services.MemberService.GetAll()

    about two months ago I did not get a timeout.

    The member count is about 4000

    Copy Link
  • Richard Soeteman 4035 posts 12842 karma points MVP
    Aug 08, 2016 @ 05:56
    Richard Soeteman
    0

    Hi Ed,

    This is the forum to report memberexport utility bugs. Best to use http://issues.umbraco.org/ to report Umbraco bugs.

    Best,

    Richard

    Copy Link
Please Sign in or register to post replies

Write your reply to:

Draft