none
ASP.Net Membership - Validate User throws Timeout expired exception RRS feed

  • Question

  • Hi

    I am getting timeout exired exception when calling ASP .net Memmbership Validate User method.

    On investigation we have understood that

    1. While the user logs in, index will be created and these indexes will continuously increase while more and more users get added.

    2. So the index memory needs to be released and for this, a job needs to be created.

    In order to overcome this issue we have created a job to rebuild indexes but sometimes after one day it throws same error again.

    However the other issue is

    1. Daily basis index cleaning is not a solution. Because we are not sure that when it will be full again. The memory needs to be released on a daily or at least in 2 days’ time.

    2. If this job is running continuously then SQL server temp DB will be full and for releasing temp storage we need to restart the SQL server.


    Increasing connection time out in config file also does not help


    Error Details:

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

    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.Data.SqlClient.Squception: Timeout expired. The timeout period elapsed prior to completion of the operation or the sewer is not responding.

    Source Error:

    An unhandled exception was generated during the execution of the current web request. Information regarding the origin and location of the exception can be
    identified using the exception stack trace below.

    Stack Trace:

    [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) +212
    System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj) +245
    System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCorIlnand cdeandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) +2843
    System. Data. SqlCl i ent. Sql DataReader.ConsumeMetaDataO +127
    System. Data. SqlCl i ent. Sql DataReader. getJrletaDataO +112
    System.Data.SqlClient.SqlCorIlnand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString) +6338580
    System.Data.SqlClient.SqlCorIlnand.RunExecuteReadeers(CormandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async) +6339649
    System.Data.SqlClient.SqlCorIlnand.RunExecuteReader(CormandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, DbAsyncResult result) +424
    System.Data.SqlClient.SqlCorIlnand.RunExecuteReader(CormandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method) +28
    System.Data.SqlClient.SqlCorIlnand.ExecuteReader(CormandBehavior behavior, String method) +211
    System. Data. SqlCl i ent . SqlCorIlnand . ExecuteReader (CormandBehavi or behavior) +87
    SystemJieb.Security.SqlMembershipProvider.GetPasswordwithFormat(String username, Boolean updateLastLoginActivityDate, Int32& status, String& password, Int32& passwordFormat, String& passw
    SystemJieb.Security.SqlMembershipProvider.CheckPassword(String username, String password, Boolean updateLastLoginActivityDate, Boolean failIfNotApproved, String& salt, Int32& passwordForma
    SystemJieb.Security.SqlMembershipProvider.ValidateUser(String username, String password) +164

    System. Web. UI . WebControl s . Button . Rai sePostBackEvent (Stri ng eventArgument) +140

    System. Web. UI . Page. Rai sePostBackEvent (IPostBackEventHandl er sourceControl , String eventArgument) +29


    • Edited by Dashrath Jaipal Thursday, June 30, 2016 12:00 PM
    • Moved by Bob Beauchemin Thursday, June 30, 2016 3:30 PM Moved to closest relevant forum, s/b reposted to ASP.NET forums
    Thursday, June 30, 2016 11:36 AM

Answers