Question

Photo of Josh Moore

0

Merging Records - Error 500

1

Hey guys,

I'm having some trouble with merging people's records. After I click Merge Records after selecting the information I want to keep, it takes a few minutes with the waiting logo, and then I get this Error 500 come back at me:

Error

An unknown error occurred while processing the request on the server. The status code returned from the server was: 500

This has happened with a few records when we've merged them. Sometimes it completes the merge, other times it doesn't. Any ideas?

We're on Microsoft Azure Hosting and running the latest version of Rock.

Josh

  • Photo of Josh Moore

    0

    I'm still getting the error. Since upgrading to McKinley 3.2 it's worded slightly differently on the Merge People page, however it looks like it's the same error:

    An error has occurred while processing your request. Your organization's administrators have been notified of this problem

    The accompanying stacks email reads:

    HttpUnhandledException in System.Web

    Message

    Exception of type 'System.Web.HttpUnhandledException' was thrown.

     

    • David Turner

      David Turner

      There should be more details in that exception message and/or stack trace. Can you post the entire message and stack trace. You may have to view it in the "Admin Tools > System Settings > Exception List" area.

      • Jez Hailwood

        Jez Hailwood

        Here's the stack trace:


        HttpUnhandledException in System.Web


        Message
        Exception of type 'System.Web.HttpUnhandledException' was thrown.


        Stack Trace
        at System.Web.UI.Page.HandleError(Exception e)
        at System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)
        at System.Web.UI.Page.ProcessRequest(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)
        at System.Web.UI.Page.ProcessRequest()
        at System.Web.UI.Page.ProcessRequestWithNoAssert(HttpContext context)
        at System.Web.UI.Page.ProcessRequest(HttpContext context)
        at ASP.themes_rock_layouts_fullwidth_aspx.ProcessRequest(HttpContext context)
        at System.Web.HttpApplication.CallHandlerExecutionStep.System.Web.HttpApplication.IExecutionStep.Execute()
        at System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean& completedSynchronously)


        -SqlException in .Net SqlClient Data Provider


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


        Stack Trace
        at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action1 wrapCloseInAction) at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection, Action1 wrapCloseInAction)
        at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose)
        at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady)
        at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString)
        at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async, Int32 timeout, Task& task, Boolean asyncWrite, SqlDataReader ds)
        at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, TaskCompletionSource1 completion, Int32 timeout, Task& task, Boolean asyncWrite) at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(TaskCompletionSource1 completion, String methodName, Boolean sendToPipe, Int32 timeout, Boolean asyncWrite)
        at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
        at Rock.Data.DbService.ExecuteCommand(String query, CommandType commandType, Dictionary2 parameters, Nullable1 commandTimeout)
        at RockWeb.Blocks.Crm.PersonMerge.lbMerge_Click(Object sender, EventArgs e)
        at System.Web.UI.WebControls.LinkButton.OnClick(EventArgs e)
        at System.Web.UI.WebControls.LinkButton.RaisePostBackEvent(String eventArgument)
        at System.Web.UI.WebControls.LinkButton.System.Web.UI.IPostBackEventHandler.RaisePostBackEvent(String eventArgument)
        at System.Web.UI.Page.RaisePostBackEvent(IPostBackEventHandler sourceControl, String eventArgument)
        at System.Web.UI.Page.RaisePostBackEvent(NameValueCollection postData)
        at System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)


        --Win32Exception in


        Message
        The wait operation timed out