Hi guys,

I've got a really confusing situation here. We are running Umbraco 7.1.4 in Azure. We have several environments, five of which are working perfectly on the same code. However, one of the new environments works for a while but then something goes wrong after which almost every page in the backoffice throws an error, normally an InvalidCastException. Restarting the websites fixes it for a while but then the same happens again at some point.

Here is some of the error log information from after things go wrong. I can't see anything that really helps me but if anyone has an idea of something to try I would be very appreciative!

Thanks

2015-03-09 09:46:25,993 [174] INFO  Umbraco.Core.Persistence.UmbracoDatabase - [Thread 143]    at System.Data.SqlClient.SqlInternalConnectionTds.ValidateConnectionForExecute(SqlCommand command)

   at System.Data.SqlClient.SqlConnection.ValidateConnectionForExecute(String method, SqlCommand command)

   at System.Data.SqlClient.SqlCommand.ValidateCommand(String method, Boolean async)

   at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, TaskCompletionSource`1 completion, Int32 timeout, Task& task, Boolean asyncWrite)

   at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method)

   at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior, String method)

   at System.Data.SqlClient.SqlCommand.ExecuteDbDataReader(CommandBehavior behavior)

   at System.Data.Common.DbCommand.ExecuteReader(CommandBehavior behavior)

   at StackExchange.Profiling.Data.ProfiledDbCommand.ExecuteDbDataReader(CommandBehavior behavior) in c:\Code\github\SamSaffron\MiniProfiler\StackExchange.Profiling\Data\ProfiledDbCommand.cs:line 235

   at System.Data.Common.DbCommand.System.Data.IDbCommand.ExecuteReader()

   at Umbraco.Core.Persistence.Database.<Query>d__7`1.MoveNext()

2015-03-09 09:46:26,115 [174] INFO  Umbraco.Core.Persistence.UmbracoDatabase - [Thread 115]    at System.Data.SqlClient.SqlInternalConnectionTds.ValidateConnectionForExecute(SqlCommand command)

   at System.Data.SqlClient.SqlConnection.ValidateConnectionForExecute(String method, SqlCommand command)

   at System.Data.SqlClient.SqlCommand.ValidateCommand(String method, Boolean async)

   at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, TaskCompletionSource`1 completion, Int32 timeout, Task& task, Boolean asyncWrite)

   at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method)

   at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior, String method)

   at System.Data.SqlClient.SqlCommand.ExecuteDbDataReader(CommandBehavior behavior)

   at System.Data.Common.DbCommand.ExecuteReader(CommandBehavior behavior)

   at StackExchange.Profiling.Data.ProfiledDbCommand.ExecuteDbDataReader(CommandBehavior behavior) in c:\Code\github\SamSaffron\MiniProfiler\StackExchange.Profiling\Data\ProfiledDbCommand.cs:line 235

   at System.Data.Common.DbCommand.System.Data.IDbCommand.ExecuteReader()

   at Umbraco.Core.Persistence.Database.<Query>d__7`1.MoveNext()

2015-03-09 09:46:26,256 [174] WARN  Umbraco.Web.Routing.DefaultUrlProvider - [Thread 68] Couldn't find any page with nodeId=2279. This is most likely caused by the page not being published.

2015-03-09 09:46:26,304 [174] WARN  Umbraco.Web.Routing.DefaultUrlProvider - [Thread 68] Couldn't find any page with nodeId=2276. This is most likely caused by the page not being published.

2015-03-09 09:46:26,318 [174] WARN  Umbraco.Web.Routing.DefaultUrlProvider - [Thread 68] Couldn't find any page with nodeId=2275. This is most likely caused by the page not being published.

2015-03-09 09:46:26,506 [174] WARN  Umbraco.Web.Routing.DefaultUrlProvider - [Thread 68] Couldn't find any page with nodeId=1263. This is most likely caused by the page not being published.

2015-03-09 09:46:41,990 [174] INFO  Umbraco.Core.Persistence.UmbracoDatabase - [Thread 50]    at System.RuntimeMethodHandle.InvokeMethod(Object target, Object[] arguments, Signature sig, Boolean constructor)

   at System.Reflection.RuntimeMethodInfo.UnsafeInvokeInternal(Object obj, Object[] parameters, Object[] arguments)

   at System.Reflection.RuntimeMethodInfo.UnsafeInvoke(Object obj, BindingFlags invokeAttr, Binder binder, Object[] parameters, CultureInfo culture)

   at System.Delegate.DynamicInvokeImpl(Object[] args)

   at Umbraco.Core.Persistence.Database.MultiPocoFactory.CallDelegate(Int32 index, IDataReader reader)

   at Umbraco.Core.Persistence.Database.MultiPocoFactory.CallCallback[TRet](Delegate callback, IDataReader dr, Int32 count)

   at Umbraco.Core.Persistence.Database.<>c__DisplayClass1a`1.<CreateMultiPocoFactory>b__19(IDataReader reader, Delegate arg3)

   at Umbraco.Core.Persistence.Database.<Query>d__1c`1.MoveNext()

2015-03-09 09:46:42,443 [174] INFO  Umbraco.Core.Persistence.UmbracoDatabase - [Thread 105]    at System.RuntimeMethodHandle.InvokeMethod(Object target, Object[] arguments, Signature sig, Boolean constructor)

   at System.Reflection.RuntimeMethodInfo.UnsafeInvokeInternal(Object obj, Object[] parameters, Object[] arguments)

   at System.Reflection.RuntimeMethodInfo.UnsafeInvoke(Object obj, BindingFlags invokeAttr, Binder binder, Object[] parameters, CultureInfo culture)

   at System.Delegate.DynamicInvokeImpl(Object[] args)

   at Umbraco.Core.Persistence.Database.MultiPocoFactory.CallDelegate(Int32 index, IDataReader reader)

   at Umbraco.Core.Persistence.Database.MultiPocoFactory.CallCallback[TRet](Delegate callback, IDataReader dr, Int32 count)

   at Umbraco.Core.Persistence.Database.<>c__DisplayClass1a`1.<CreateMultiPocoFactory>b__19(IDataReader reader, Delegate arg3)

   at Umbraco.Core.Persistence.Database.<Query>d__1c`1.MoveNext()

2015-03-09 09:46:43,584 [174] INFO  Umbraco.Core.Persistence.UmbracoDatabase - [Thread 68]    at System.RuntimeMethodHandle.InvokeMethod(Object target, Object[] arguments, Signature sig, Boolean constructor)

   at System.Reflection.RuntimeMethodInfo.UnsafeInvokeInternal(Object obj, Object[] parameters, Object[] arguments)

   at System.Reflection.RuntimeMethodInfo.UnsafeInvoke(Object obj, BindingFlags invokeAttr, Binder binder, Object[] parameters, CultureInfo culture)

   at System.Delegate.DynamicInvokeImpl(Object[] args)

   at Umbraco.Core.Persistence.Database.MultiPocoFactory.CallDelegate(Int32 index, IDataReader reader)

   at Umbraco.Core.Persistence.Database.MultiPocoFactory.CallCallback[TRet](Delegate callback, IDataReader dr, Int32 count)

   at Umbraco.Core.Persistence.Database.<>c__DisplayClass1a`1.<CreateMultiPocoFactory>b__19(IDataReader reader, Delegate arg3)

   at Umbraco.Core.Persistence.Database.<Query>d__1c`1.MoveNext()

2015-03-09 09:46:43,584 [174] ERROR Umbraco.Core.UmbracoApplicationBase - [Thread 68] An unhandled exception occurred

System.Reflection.TargetInvocationException: Exception has been thrown by the target of an invocation. ---> System.InvalidCastException: Specified cast is not valid.

   at System.Data.SqlClient.SqlBuffer.get_Int32()

   at System.Data.SqlClient.SqlDataReader.GetInt32(Int32 i)

   at petapoco_factory_1(IDataReader )

   --- End of inner exception stack trace ---

   at System.RuntimeMethodHandle.InvokeMethod(Object target, Object[] arguments, Signature sig, Boolean constructor)

   at System.Reflection.RuntimeMethodInfo.UnsafeInvokeInternal(Object obj, Object[] parameters, Object[] arguments)

   at System.Reflection.RuntimeMethodInfo.UnsafeInvoke(Object obj, BindingFlags invokeAttr, Binder binder, Object[] parameters, CultureInfo culture)

   at System.Delegate.DynamicInvokeImpl(Object[] args)

   at Umbraco.Core.Persistence.Database.MultiPocoFactory.CallDelegate(Int32 index, IDataReader reader)

   at Umbraco.Core.Persistence.Database.MultiPocoFactory.CallCallback[TRet](Delegate callback, IDataReader dr, Int32 count)

   at Umbraco.Core.Persistence.Database.<>c__DisplayClass1a`1.<CreateMultiPocoFactory>b__19(IDataReader reader, Delegate arg3)

   at Umbraco.Core.Persistence.Database.<Query>d__1c`1.MoveNext()

   at System.Collections.Generic.List`1..ctor(IEnumerable`1 collection)

   at System.Linq.Enumerable.ToList[TSource](IEnumerable`1 source)

   at Umbraco.Core.Persistence.Database.Fetch[T1,T2](Sql sql)

   at Umbraco.Core.Persistence.Repositories.TemplateRepository.Get(String alias)

   at Umbraco.Core.Services.FileService.GetTemplate(String alias)

   at Umbraco.Web.Routing.ContentFinderByNiceUrlAndTemplate.TryFindContent(PublishedContentRequest docRequest)

   at Umbraco.Web.Routing.ContentFinderByNotFoundHandlers.HandlePageNotFound(PublishedContentRequest docRequest)

   at Umbraco.Web.Routing.ContentFinderByNotFoundHandlers.TryFindContent(PublishedContentRequest docRequest)

   at Umbraco.Web.Routing.PublishedContentRequestEngine.<FindPublishedContent>b__2a(IContentFinder finder)

   at System.Linq.Enumerable.Any[TSource](IEnumerable`1 source, Func`2 predicate)

   at Umbraco.Web.Routing.PublishedContentRequestEngine.FindPublishedContent()

   at Umbraco.Web.Routing.PublishedContentRequestEngine.FindPublishedContentAndTemplate()

   at Umbraco.Web.Routing.PublishedContentRequestEngine.PrepareRequest()

   at Umbraco.Web.UmbracoModule.ProcessRequest(HttpContextBase httpContext)

   at Umbraco.Web.UmbracoModule.<Init>b__a(Object sender, EventArgs e)

   at System.Web.HttpApplication.SyncEventExecutionStep.System.Web.HttpApplication.IExecutionStep.Execute()

   at System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean& completedSynchronously)