Frequently Asked Questions
Frequently Asked Questions
How to Solve .NET Framework Error Failed to Load Assembly ID 65536 (ERROR: 10314, SQLSTATE: 42000)
Posted by Devansh Parekh (M-Files) on 08 August 2019 05:48 PM

1     Overview

This documents walks through the initial troubleshooting steps for the .NET Framework Issue

2     Impacted Products and Versions

All versions of M-Files.

3     Symptoms

This error can cause loss of many different vault functionalities not just one reoccurring issue. To name a few:

  • Unable to create objects
  • Unable to log in
  • Unable to search

4     Cause and Reason

This can happen when a database is attach or restored from a different server. This problem can occur for several reasons. The login that you used to create the database on Server A is not in the same instance on Server B.

5     Solution/Workaround

  • As a preliminary fix, try to detach then attach the vault. See if this fixes the problem

 

  • From here verify that the account credentials on the SQL server and M-Files database connection match. If they do not please update them, detach the vault, and then attach again
    • Use the sp_changedbowner stored procedure to change the database owner to sysadmin or an available login on Server B.
    • USE <DatabaseName>
      GO

      EXEC sp_changedbowner ‘sa’
  • The final step would be to make sure that the database has the TRUSTWORTHY property set. You can set this in MSSQL Server Management Studio by navigating to the database -> right click -> properties -> options.
    • Note: if this is greyed out despite having sysadmin rights you must execute the following query to change the status.
    • Query to see TRUSTWORTHY setting:
      • SELECT is_trustworthy_on FROM sys.databases WHERE name = 'DatabaseName;'
    • Query to change TRUSTWORTHY setting (Must use sysadmin account)

ALTER DATABASE DatabaseName SET TRUSTWORTHY ON;

6     Reference Documents

https://support.microsoft.com/en-us/help/918040/you-may-receive-an-error-message-when-you-try-to-run-an-existing-clr-o

 

(0 vote(s))
This article was helpful
This article was not helpful

Comments (0)
Post a new comment
 
 
Full Name:
Email:
Comments:
CAPTCHA Verification 
 
Please enter the text you see in the image into the textbox below. This is required to prevent automated registrations and form submissions.

Help Desk Software by Kayako case