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.

    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

  • Richard Soeteman 4042 posts 12890 karma points MVP 2x
    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

  • 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

  • Richard Soeteman 4042 posts 12890 karma points MVP 2x
    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

  • 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

  • Richard Soeteman 4042 posts 12890 karma points MVP 2x
    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

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

    Fantastic Richard, that fix did the trick.

    Regards

    Ed

  • 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

  • Richard Soeteman 4042 posts 12890 karma points MVP 2x
    Jun 05, 2014 @ 15:08
    Richard Soeteman
    0

    Hi Phil,

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

    Best,

    Richard

  • Adriano Fabri 469 posts 1633 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

  • Richard Soeteman 4042 posts 12890 karma points MVP 2x
    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

  • Adriano Fabri 469 posts 1633 karma points
    Feb 05, 2015 @ 09:01
    Adriano Fabri
    0

    just like I thought

    thank you richard.

  • 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

  • Richard Soeteman 4042 posts 12890 karma points MVP 2x
    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

Please Sign in or register to post replies

Write your reply to:

Draft