Online payment event viewer warning: an unhandled exception has occurred

Online payment event viewer warning: an unhandled exception has occurred

In Fusion Servicing Director Customer Self-Service, when you click continue on the Online Payment Terms Screen (ACHWebIntro.ASPX), it can cause the following Windows Event Viewer Application log ASP.NET warning message when the settings on the Servicing Director SQL server are incorrect:

Event code: 3005 
Event message: An unhandled exception has occurred. 
Event time: 
Event time (UTC):
Event ID:
Event sequence: 
Event occurrence: 
Event detail code: 
 
Application information: 
    Application domain:
    Trust level: Full 
    Application Virtual Path: /ILSWeb 
    Application Path: \ILSWeb\ 
    Machine name: <YourServerName>
 
Process information: 
    Process ID:  
    Process name: w3wp.exe 
    Account name: 
 
Exception information: 
    Exception type: HttpUnhandledException 
    Exception message: Exception of type 'System.Web.HttpUnhandledException' was thrown.
   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.achwebdataentry_aspx.ProcessRequest(HttpContext context)
   at System.Web.HttpServerUtility.ExecuteInternal(IHttpHandler handler, TextWriter writer, Boolean preserveForm, Boolean setPreviousPage, VirtualPath path, VirtualPath filePath, String physPath, Exception error, String queryStringOverride)

Object reference not set to an instance of an object.
   at ILSWebData.AchWebDataEntry.get_DateList()
   at ILSWebData.AchWebDataEntry.setCalendarDate(DateTime transDate)
   at ILSWebData.AchWebDataEntry.Page_Load(Object sender, EventArgs e)
   at System.Web.Util.CalliEventHandlerDelegateProxy.Callback(Object sender, EventArgs e)
   at System.Web.UI.Control.OnLoad(EventArgs e)
   at System.Web.UI.Control.LoadRecursive()
   at System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)
 
Request information: 
    Request URL: /AchWebIntro.aspx 
    Request path: /ILSWeb/AchWebIntro.aspx 
    User host address: <YourServerName>
    User: <BorrowerName>
    Is authenticated: True 
    Authentication Type: 
    Thread account name: 
 
Thread information: 
    Thread ID: 227 
    Thread account name: 
    Is impersonating: False 
    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.achwebdataentry_aspx.ProcessRequest(HttpContext context)
   at System.Web.HttpServerUtility.ExecuteInternal(IHttpHandler handler, TextWriter writer, Boolean preserveForm, Boolean setPreviousPage, VirtualPath path, VirtualPath filePath, String physPath, Exception error, String queryStringOverride)

 

Workaround:

This information is for your system administrator or local IT.

  1. Reset your Servicing Director SQL logins, specifically adding the W_Fixrights option. Review the related article for more information/
  2. Restart your web services (IIS) on your Customer Self-Service business application server (ILSWebBus).
  3. Continue with the following advanced troubleshooting if the issue is not resolved. 
  4. Access the Fusion Servicing Director SQL server.
  5. Run the following troubleshooting SQL command. If an error occurs, it will be a SQL message about the root cause of this issue, and it will direct your further actions.
  6. Open the SQL Server Management Studio.
  7. Login specifically using SQL authentication and use only the SQL login ILSWebUser.  This is the SQL login configured by the person installing the Customer Self-Service business application server. Use the default password defined in the Customer Self-Service Installation Guide or your custom password if the person installing Customer Self-Service defined a custom password.
  8. Click New Query.
  9. Enter the following query:
Use Service
Go
Service.dbo.W_GetCompanyWorkdays
Go

If the settings for this query on your system are correct, then the results from the query should return the business days from the Event Manager calendar.

If the settings for this query on your system are incorrect, you will see a SQL error message, and use the error message to direct your further troubleshooting. Reference your Microsoft SQL Support resources as needed.

ArticleNumber:

000042929