I am trying to deploy an SSIS 2012 project to an SSIS Catalog on a newly built SQL Server machine. It throws an error with the following message whilst creating the folder.
Failed to create appdomain ssisdb.dbo[runtime].6.
Trying to create the folder through SSMS alsos throws the same error, but with ssisdb.dbo[runtime].7
I enabled CLR on the instance, and now it throws the same error on ssisdb.dbo[runtime].9
I have tried running the create_folder proc - same error and SQL Server will not let me step into the proc.
How do I resolve this?
Some searches on the web reveal that there are related issues reported on Microsoft Connect website. Microsoft suggest that this could be due to a recent installation of CLR/.NET related patch, where the system reboot is pending. Try rebooting the server and then create the SSISDB catalog.
Failed to create AppDomain "master.sys[runtime].X"
Errors like:
Msg 6517, Level 16, State 1, Line 3
AppDomain "MDS.dbo [runtime] .20" Could not create.
Exception has been thrown by the target of an invocation.
come directly from .NET/CLR itself. It's usually about some inconsistency with the CLR/.NET itself. It means the CLR installation is corrupted (unlikely), or, more likely, a .NET patch was recently installed and the machine is pending a reboot.
Let us know if reboot doesn't fix the problem.
About the upgrade failure from upgrade step 677 to 678: this issue is fixed in Denali RC1.