{"action":"closed","issue":{"url":"https://api.github.com/repos/Famintus/WebPlataform/issues/190","labels_url":"https://api.github.com/repos/Famintus/WebPlataform/issues/190/labels{/name}","comments_url":"https://api.github.com/repos/Famintus/WebPlataform/issues/190/comments","events_url":"https://api.github.com/repos/Famintus/WebPlataform/issues/190/events","html_url":"https://github.com/Famintus/WebPlataform/issues/190","id":115259358,"number":190,"title":"Analisar erro no GetRostersForTeacher","user":{"login":"gBritz","id":4161527,"avatar_url":"https://avatars.githubusercontent.com/u/4161527?v=3","gravatar_id":"","url":"https://api.github.com/users/gBritz","html_url":"https://github.com/gBritz","followers_url":"https://api.github.com/users/gBritz/followers","following_url":"https://api.github.com/users/gBritz/following{/other_user}","gists_url":"https://api.github.com/users/gBritz/gists{/gist_id}","starred_url":"https://api.github.com/users/gBritz/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/gBritz/subscriptions","organizations_url":"https://api.github.com/users/gBritz/orgs","repos_url":"https://api.github.com/users/gBritz/repos","events_url":"https://api.github.com/users/gBritz/events{/privacy}","received_events_url":"https://api.github.com/users/gBritz/received_events","type":"User","site_admin":false},"labels":[],"state":"closed","locked":false,"assignee":null,"milestone":null,"comments":1,"created_at":"2015-11-05T10:54:28Z","updated_at":"2015-11-05T10:54:28Z","closed_at":"2015-11-05T10:54:28Z","body":"System.Data.Entity.Core.EntityCommandExecutionException\r\n/lt.elefanteletrado.com.br/Admin/Roster/GetRostersForTeacher\r\n\r\nError message\r\nSystem.Data.Entity.Core.EntityCommandExecutionException: Transaction (Process ID 165) was deadlocked on lock resources with another process and has been chosen as the deadlock victim. Rerun the transaction.\r\n\r\nStack trace\r\n[SqlException: Transaction (Process ID 165) was deadlocked on lock resources with another process and has been chosen as the deadlock victim. Rerun the transaction.]\r\nat System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)\r\nat System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose)\r\nat System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady)\r\nat System.Data.SqlClient.SqlDataReader.TryHasMoreRows(Boolean& moreRows)\r\nat System.Data.SqlClient.SqlDataReader.TryReadInternal(Boolean setTimeout, Boolean& more)\r\nat System.Data.SqlClient.SqlDataReader.Read()\r\nat Glimpse.Ado.AlternateType.GlimpseDbDataReader.Read()\r\nat System.Data.Entity.Core.Common.Internal.Materialization.Shaper`1.StoreRead()\r\n\r\n[EntityCommandExecutionException: An error occurred while reading from the store provider's data reader. See the inner exception for details.]\r\nat System.Data.Entity.Core.Common.Internal.Materialization.Shaper`1.HandleReaderException(Exception e)\r\nat System.Data.Entity.Core.Common.Internal.Materialization.Shaper`1.StoreRead()\r\nat System.Data.Entity.Core.Common.Internal.Materialization.Shaper`1.RowNestedResultEnumerator.MoveNext()\r\nat System.Data.Entity.Core.Common.Internal.Materialization.Shaper`1.ObjectQueryNestedEnumerator.TryReadToNextElement()\r\nat System.Data.Entity.Core.Common.Internal.Materialization.Shaper`1.ObjectQueryNestedEnumerator.MoveNext()\r\nat LiterateElephant.Controller.UserController.TimeSpentOnlineByUsers(Nullable`1 fromDate, Nullable`1 toDate, Nullable`1 userId, Nullable`1 schoolId, Nullable`1 teacherId, Boolean isStudent) in c:\\TFS\\ElefanteLetrado\\Portal\\trunk\\LiterateElephant\\LiterateElephant.Controller\\UserController.cs:line 755\r\nat LiterateElephant.Behaviors.UserService.TimeSpentOnlineByUsers(Nullable`1 fromDate, Nullable`1 toDate, Nullable`1 userId, Nullable`1 schoolId, Nullable`1 teacherId, Boolean isStudent) in c:\\TFS\\ElefanteLetrado\\Portal\\trunk\\LiterateElephant\\LiterateElephant.Behaviors\\UserService.cs:line 270\r\nat LiterateElephant.Web.Areas.Admin.Controllers.RosterController.<GetCourseForTeacher>b__6b(Student student) in c:\\TFS\\ElefanteLetrado\\Portal\\trunk\\LiterateElephant\\LiterateElephant.Web\\LiterateElephant.Web\\Areas\\Admin\\Controllers\\RosterController.cs:line 1711\r\nat System.Linq.Enumerable.WhereSelectListIterator`2.MoveNext()\r\nat System.Collections.Generic.List`1.InsertRange(Int32 index, IEnumerable`1 collection)\r\nat LiterateElephant.Web.Areas.Admin.Controllers.RosterController.GetCourseForTeacher(Int32 rosterId, List`1& users, Int32& returnStatus) in c:\\TFS\\ElefanteLetrado\\Portal\\trunk\\LiterateElephant\\LiterateElephant.Web\\LiterateElephant.Web\\Areas\\Admin\\Controllers\\RosterController.cs:line 1744\r\nat LiterateElephant.Web.Areas.Admin.Controllers.RosterController.GetRostersForTeacher(String teacherName, Int32 teacherId, Boolean parentRoster, Int32 studentId, Boolean isFromReport) in c:\\TFS\\ElefanteLetrado\\Portal\\trunk\\LiterateElephant\\LiterateElephant.Web\\LiterateElephant.Web\\Areas\\Admin\\Controllers\\RosterController.cs:line 359\r\nat lambda_method(Closure , ControllerBase , Object[] )\r\nat System.Web.Mvc.ReflectedActionDescriptor.Execute(ControllerContext controllerContext, IDictionary`2 parameters)\r\nat System.Web.Mvc.ControllerActionInvoker.InvokeActionMethod(ControllerContext controllerContext, ActionDescriptor actionDescriptor, IDictionary`2 parameters)\r\nat System.Web.Mvc.Async.AsyncControllerActionInvoker.<BeginInvokeSynchronousActionMethod>b__39(IAsyncResult asyncResult, ActionInvocation innerInvokeState)\r\nat System.Web.Mvc.Async.AsyncResultWrapper.WrappedAsyncResult`2.CallEndDelegate(IAsyncResult asyncResult)\r\nat System.Web.Mvc.Async.AsyncControllerActionInvoker.AsyncInvocationWithFilters.<InvokeActionMethodFilterAsynchronouslyRecursive>b__3d()\r\nat System.Web.Mvc.Async.AsyncControllerActionInvoker.AsyncInvocationWithFilters.<>c__DisplayClass46.<InvokeActionMethodFilterAsynchronouslyRecursive>b__3f()\r\nat System.Web.Mvc.Async.AsyncControllerActionInvoker.<>c__DisplayClass33.<BeginInvokeActionMethodWithFilters>b__32(IAsyncResult asyncResult)\r\nat System.Web.Mvc.Async.AsyncControllerActionInvoker.<>c__DisplayClass21.<>c__DisplayClass2b.<BeginInvokeAction>b__1c()\r\nat System.Web.Mvc.Async.AsyncControllerActionInvoker.<>c__DisplayClass21.<BeginInvokeAction>b__1e(IAsyncResult asyncResult)"}}