Hi
We have started to get the following error occur, at present our solution is to upgrade from a basic database to a premium tier to force the database to be deployed in a different location, this corrects the issue and we can then downgrade again without the issue reoccurring this points to a problem within Azure. Is this being looked into or is there any alternative solution we can use?
HttpApplication.Error event caught: appId=/LM/W3SVC/1273337584/ROOT
type=System.Data.SqlClient.SqlException
message=An error occurred in the Microsoft .NET Framework while
trying to load assembly id 1. 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.FileNotFoundException: Could not load file or assembly
'microsoft.sqlserver.types, Version=11.1.0.0, Culture=neutral,
PublicKeyToken=89845dcd8080cc91' or one of its dependencies. The system
cannot find the file specified. ---> System.IO.FileNotFoundException:
Could not load file or assembly 'microsoft.sqlserver.types,
Version=11.0.0.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91' or
one of its dependencies. The system cannot find the file specified.
System.IO.FileNotFoundException:
System.IO.FileNotFoundException:
at System.Reflection.RuntimeAssembly._nLoad(AssemblyName
fileName, String codeBase, Evidence assemblySecurity, RuntimeAssembly
locationHint, StackCrawlMark& stackMark, Boolean
throwOnFileNotFound, Boolean forIntrospection, Boolean
suppressSecurityChecks)
at
System.Reflection.RuntimeAssembly.InternalLoadAssemblyName(AssemblyName
assemblyRef, Evidence assemblySecurity, StackCrawlMark& stackMark,
Boolean forIntrospection, Boolean suppressSecurityChecks)
at System.Reflection.RuntimeAssembly.InternalLoad(String
assemblyString, Evidence assemblySecurity, StackCrawlMark&
stackMark, Boolean forIntrospection)
at System.Reflection.Assembly.Load(String assemblyString)
stack=
at Common.DB.DoSP(ReliableSqlConnection conn, String commandText, SqlParameter[] params)
at Common.DB.DoSP(String connectionString, String commandText, SqlParameter[] params)
at Common.VacancyViewIncrementer.ProcessRequest(HttpContext context)
at System.Web.HttpApplication.CallHandlerExecutionStep.System.Web.HttpApplication.IExecutionStep.Execute()
at System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean& completedSynchronously)