This project is read-only.
1
Vote

Failed to initialize CLR due to memory preasure

description

Open DBDiff Beta 0.9.0.0
Error Loading Source Database (while Reading XML Schema...)
SqlException: Failed to initialize the Common Language Runtime (CLR) v2.0.50727 due to memory pressure. This is probably due to memory pressure in the MemToLeave region of memory. For more information, see the CLR integration documentation in SQL Server Books Online.
at DBDiff.Schema.SQLServer.Generates.Generates.GenerateAssemblies.Fill(Database database, String connectionString) in c:\Users\JS\Desktop\Files\opendbiff\DBDiff.Schema.SQLServer2005\Generates\GenerateAssemblies.cs:line 95
at DBDiff.Schema.SQLServer.Generates.Generates.Generate.Process() in c:\Users\JS\Desktop\Files\opendbiff\DBDiff.Schema.SQLServer2005\Generates\Generate.cs:line 129
at DBDiff.Front.ProgressForm.ProgressForm_Activated(Object sender, EventArgs e) in c:\Users\JS\Desktop\Files\opendbiff\DBDiff\Front\ProgressForm.cs:line 89

7B910C930F3AB039B9916DA78532F043

comments

TenguTech wrote Sep 5, 2016 at 8:39 AM

I was able to get around this problem by unticking 'Assemblys' in Options.
That seems to have reduced enough the memory it was trying to use.

I tried with 'Assemblys' ticked, but all the sub options unticked. And got the same error.

jspraul wrote Sep 12, 2016 at 9:05 PM

Does the database actually use the .NET Assembly feature of SQL Server, or is this some default thing that is causing this problem? If it does use .NET Assemblies, I'm curious to know if it is actually used and known to be working... the error message appears to indicate a misconfiguration of that feature.

Also any info on platform and SQL Server version would be appreciated.

Going forward Assembly support may be disabled by default, it isn't really verified functionality anymore.