A .NET framework error occurred

A .NET framework error occurred

A .NET Framework error occurred during execution of user-defined routine or aggregate "D_tvfGetHoliday":
System.Data.SqlClient.SqlException:
The SELECT permission was denied on the object 'HolidayTable', database 'SvcEventMgr', schema 'dbo', System.Data.SqlClient.SqlExcepton: at System.Data.SqlClient.SqlConnection.OnError(SQLException exception, Boolean breakConnection)

This error is caused by a server configuration issue where communication between the Fusion Servicing Director databases fails. 

Workaround:

This error should mean some Investor Cutoff information was updated, but some mid-month cutoff dates may not have been updated.

  1. Confirm the mid-month cutoff dates are correct, and if not, then correct them as needed.
  2. Have your local IT or system administrator use the procedures below to resolve the server configuration issue. 
For your local IT or system administrator:
The .NET exception part of the error text may vary to indicate different exception messages from your SQL server. In the example above, the "SELECT permission denied exception" may come from having the wrong information in the Service.dbo.SystemDefaults EMServer value.
  1.  Run the LSCNFG server application and reset your Fusion Servicing Director database login passwords to update the SystemDefaults EMServer value. For more information about resetting your Fusion Servicing Director database login passwords, search Knowledge Center with the key words Servicing Director resetting passwords. 
  2. Test the communication between the databases with the following troubleshooting SQL command to confirm the configuration issue is resolved.
  3. Open a SQL Server Management Studio with SQL authentication and use the SQL login LoanServicing. 
  4. Enter the password you have just set for Loan Servicing using LSCFNG.
    Note:  Authentication is one key configuration element for this troubleshooting, and be sure to login with the LoanServicing login. The instructions here say to use the LoanServicing SQL login, based on the assumption your desktop clients are using the only supported method, which is SQL authentication. If you are not using SQL authentication for your desktop clients, then this step would have to use a matching Windows user account which matches one of the desktop users related to the Investor updates error. 
  5. Open a New Query screen from the SQL Server Management Studio toolbar to test if the above has resolved the error message.
  6. Enter one of the following SQL commands
    • If you are on Fusion Servicing Director version 18.2 or earlier: SELECT Service.dbo.fMidMonthCutoffDate('2017-05-01') FROM Service.dbo.InvAddlCutoffInfo
    • If you are on Servicing Director version 18.3 or later:  SELECT Service.dbo.fMidMonthCutoffDate('2017-05-01',0) FROM Service.dbo.InvAddlCutoffInfo
      Note: The date '2017-05-01' in the command above is just a random sample date.  Enter yesterday's date in the same format if desired. It is not the date which matters, but the ability to complete the check of the date without error which is being tested. 
  7. Click the Execute button (F5) on the SQL Server Management Studio toolbar. There should be no SQL error and the results should show a date value. If there is a SQL error, then the issue is not resolved.
  8. Use the error with Microsoft SQL server support information to direct your SQL server troubleshooting. 
Submit a case through Case Management to increment Request for Change 00303404.

ArticleNumber:

000042533