Error: "Failed to create new Entity ... A .Net Framework error occurred" following a Windows update
This support note applies to:
- AE Tax Series 6 & 8 (AU)
In MYOB Accountants Enterprise (AE) you may receive the error "Failed to create new Entity. Solution6.VPM.BusinessLogic.SQLRemoteException. A .Net Framework error occurred during execution of the user defined routine or aggregate "MSync_Sqlmsmq2SendMSMQMessage".
This error occurs after a Windows update, which includes a Microsoft .NET 4 update, has been performed. This issue is caused by a restriction in SQL.
An error similar to the following may also appear in the Windows Event Viewer:
"System Release DAL SQL error 6522: [Microsoft][ODBC SQL Server Driver][SQL Server]A .NET Framework error occurred during execution of user-defined routine or aggregate "MSync_SqlMsmq2SendMSMQMessage": System.IO.FileLoadException: Could not load file or assembly System.Messaging, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a' or one of its dependencies. Assembly in host store has a different signature than assembly in GAC. (Exception from HRESULT: 0x80131050) See Microsoft Knowledge Base article 949080 for more informa[SELECT CURSOR]."
To correct this issue, run MsyncIntegration.exe and select the Modify option to reset the assembly System.Messaging. The Msyncintegration.exe file can be found in the following locations:
Operating system | Location |
---|---|
32-bit | C:\Program Files\MYOB\admincentre |
64-bit | C:\Program Files (x86)\MYOB\admincentre |
Alternatively, you can run the following SQL query against both Tax and AEDB (PM) databases.
ALTER ASSEMBLY [system.messaging]
FROM 'C:\Windows\Microsoft.NET\Framework\v4.0.30319\system.messaging.dll'
MYOB INTERNAL STAFF ONLY
Insert PR# 156226913899