Solution - Responder - Web Error when Submitting Customer Call

Version 8

    Behavior

     

    When submitting a customer call from Responder Web at 10.2.1b, nothing happens and two errors appear in the Miner Event log:

    ERROR Miner.Responder.Web.Global [(null)] - http://responderss2/Responder/Authorized/CSR/CustomerCallEntry.aspx

    Uncaught exception

    System.Web.HttpUnhandledException: Exception of type 'System.Web.HttpUnhandledException' was thrown. ---> System.InvalidOperationException: Nullable object must have a value.

    at System.ThrowHelper.ThrowInvalidOperationException(ExceptionResource resource)

    at Miner.Responder.Web.DataProviders.CustomerDataProvider.CustomerCallSubmit(Call call, List`1 hazards)

    at Miner.Responder.Web.Presentation.CustomerCallEntryPresenter.CustomerSubmit(Object sender, EventArgs e)

    at Miner.Responder.Web.WebParts.CustomerInputView.btnSubmit_Click(Object sender, EventArgs e)

    at System.Web.UI.WebControls.Button.OnClick(EventArgs e)

    at System.Web.UI.WebControls.Button.RaisePostBackEvent(String eventArgument)

    at System.Web.UI.WebControls.Button.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)

    ERROR Miner.Responder.Web.Default [(null)] - Error during asynchronous postback

    System.InvalidOperationException: Nullable object must have a value.

       at System.ThrowHelper.ThrowInvalidOperationException(ExceptionResource resource)

       at Miner.Responder.Web.DataProviders.CustomerDataProvider.CustomerCallSubmit(Call call, List`1 hazards)

       at Miner.Responder.Web.Presentation.CustomerCallEntryPresenter.CustomerSubmit(Object sender, EventArgs e)

       at Miner.Responder.Web.WebParts.CustomerInputView.btnSubmit_Click(Object sender, EventArgs e)

       at System.Web.UI.WebControls.Button.OnClick(EventArgs e)

       at System.Web.UI.WebControls.Button.RaisePostBackEvent(String eventArgument)

       at System.Web.UI.WebControls.Button.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)

     

     

    Cause

     

    There could be NULL values in the following columns in the RX_Customers table:

    • Critical
    • Priority
    • Region

     

     

    Solution

     

    • Run the UpdatePopulationInformation Tool to resolve any NULL values in the Region column.
    • Populate the Critical and/or Priority columns with their correct values; e.g., "0".