I upgraded CRM standalone from 7.3 to 2017 R3 recently . I was asked to disable all triggers before upgrade so I did. I assume CRM will enable the triggers automatically but it did not.

Now I have an issue. After a user create a company with person contact info it did not show on company summary screen. Obvious the triggers was still disabled.

So I enabled all triggers.

USE MyCrm;
GO

ENABLE TRIGGER EmailLink_Ins ON EmailLink;
ENABLE TRIGGER EmailLink_Upd ON EmailLink;
ENABLE TRIGGER Email_Upd ON Email;
ENABLE TRIGGER PhoneLink_Ins ON PhoneLink;
ENABLE TRIGGER PhoneLink_Upd ON PhoneLink;
ENABLE TRIGGER Phone_Upd ON Phone;
ENABLE TRIGGER TrgAfterCaseInsert ON Cases;
ENABLE TRIGGER EmailLink_InstUpd ON EmailLink;
ENABLE TRIGGER PhoneLink_InstUpd ON PhoneLink;
Go

Unfortunately this brought another bigger issue, I cannot add new cases or update existed cases. All of this is related to a trigger TrgAfterCaseInsert on table Cases, which is an external assembly: CrmTriggers.DLL

An error occurred in the Microsoft .NET Framework while trying to load assembly id 65607. The server may be running out of resources, or the assembly may not be trusted with PERMISSION_SET = EXTERNAL_ACCESS or UNSAFE. Run the query again, or check documentation to see how to solve the assembly trust issues. For more information about this error:

System.IO.FileLoadException: Could not load file or assembly 'crmtriggers, Version=0.0.0.0, Culture=neutral, PublicKeyToken=null' or one of its dependencies. Exception from HRESULT: 0x80FC80F1

System.IO.FileLoadException:

at System.Reflection.RuntimeAssembly._nLoad(AssemblyName fileName, String codeBase, Evidence assemblySecurity, RuntimeAssembly locationHint, StackCrawlMark& stackMark, IntPtr pPrivHostBinder, Boolean throwOnFileNotFound, Boolean forIntrospection, Boolean suppressSecurityChecks)

at System.Reflection.RuntimeAssembly.InternalLoadAssemblyName(AssemblyName assemblyRef, Evidence assemblySecurity, RuntimeAssembly reqAssembly, StackCrawlMark& stackMark, IntPtr pPrivHostBinder, Boolean throwOnFileNotFound, Boolean forIntrospection, Boolean suppressSecurityChecks)

at System.Reflection.RuntimeAssembly.InternalLoad(String assemblyString, Evidence assemblySecurity, StackCrawlMark& stackMark, IntPtr pPrivHostBinder, Boolean forIntrospection)

at System.Reflection.RuntimeAssembly.InternalLoad(String assemblyString, Evidence assemblySecurity, StackCrawlMark& stackMark, Boolean forIntrospection)

at System.Reflection.Assembly.Load(String assemblyString)

Anyone know how to fix it?

Appreciate any feedback.