Reporting API. (500) Internal Server Error appears after request

We are working some time now with Timetracker and are trying to get the data by oData in Excel. But we get the following error:

DataSource.Error: OData: Request failed: The remote server returned an error: (500) Internal Server Error. ("An internal error occurred while getting report data. at TimetrackerOnline.Lib.API.Controllers.TimeEntryExportController.TimeExport(String startDate, String endDate, Nullable`1 populateTopParentColumns, Nullable`1 groupTimeByDateByUser) in C:\\BuildAgent\\_work\\13\\s\\TimetrackerOnline\\TimetrackerOnline.Web\\Lib\\API\\Controllers\\TimeEntryExportController.cs:line 127\r\n at lambda_method(Closure , Object , Object[] )\r\n at System.Web.Http.Controllers.ReflectedHttpActionDescriptor.ActionExecutor.<>c__DisplayClass10.<GetExecutor>b__9(Object instance, Object[] methodParameters)\r\n at System.Web.Http.Controllers.ReflectedHttpActionDescriptor.ExecuteAsync(HttpControllerContext controllerContext, IDictionary`2 arguments, CancellationToken cancellationToken)\r\n--- End of stack trace from previous location where exception was thrown ---\r\n at System.Runtime.CompilerServices.TaskAwaiter.ThrowForNonSuccess(Task task)\r\n at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)\r\n at System.Runtime.CompilerServices.TaskAwaiter`1.GetResult()\r\n at System.Web.Http.Controllers.ApiControllerActionInvoker.<InvokeActionAsyncCore>d__0.MoveNext()\r\n--- End of stack trace from previous location where exception was thrown ---\r\n at System.Runtime.CompilerServices.TaskAwaiter.ThrowForNonSuccess(Task task)\r\n at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)\r\n at System.Runtime.CompilerServices.TaskAwaiter`1.GetResult()\r\n at System.Web.Http.Controllers.ActionFilterResult.<ExecuteAsync>d__2.MoveNext()\r\n--- End of stack trace from previous location where exception was thrown ---\r\n at System.Runtime.CompilerServices.TaskAwaiter.ThrowForNonSuccess(Task task)\r\n at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)\r\n at System.Runtime.CompilerServices.TaskAwaiter`1.GetResult()\r\n at System.Web.Http.Filters.AuthorizationFilterAttribute.<ExecuteAuthorizationFilterAsyncCore>d__2.MoveNext()\r\n--- End of stack trace from previous location where exception was thrown ---\r\n at System.Runtime.CompilerServices.TaskAwaiter.ThrowForNonSuccess(Task task)\r\n at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)\r\n at System.Runtime.CompilerServices.TaskAwaiter`1.GetResult()\r\n at System.Web.Http.Controllers.AuthenticationFilterResult.<ExecuteAsync>d__0.MoveNext()\r\n--- End of stack trace from previous location where exception was thrown ---\r\n at System.Runtime.CompilerServices.TaskAwaiter.ThrowForNonSuccess(Task task)\r\n at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)\r\n at System.Runtime.CompilerServices.TaskAwaiter`1.GetResult()\r\n at System.Web.Http.Controllers.ExceptionFilterResult.<ExecuteAsync>d__0.MoveNext()\r\nObject reference not set to an instance of an object. at TimetrackerOnline.JointCodebase.BusinessLayer.Providers.Implementation.VisualStudioProvider.GetListOfTeamProjects(VsoTokenModel tokenModel, Project virtualProject) in C:\\BuildAgent\\_work\\13\\s\\TimetrackerOnline\\TimetrackerOnline.BusinessLayer\\Providers\\Implementation\\VisualStudioProvider.cs:line 391\r\n at TimetrackerOnline.JointCodebase.BusinessLayer.Context.Services.ContextExportService.GetDataForExportApi(DateTime startDate, DateTime endDate, Boolean isComputeTopPbi, Boolean groupByDays, VsoTokenModel tokenModel) in C:\\BuildAgent\\_work\\13\\s\\TimetrackerOnline\\TimetrackerOnline.BusinessLayer\\Context\\Services\\ContextExportService.cs:line 69\r\n at TimetrackerOnline.Lib.API.Controllers.TimeEntryExportController.TimeExport(String startDate, String endDate, Nullable`1 populateTopParentColumns, Nullable`1 groupTimeByDateByUser) in C:\\BuildAgent\\_work\\13\\s\\TimetrackerOnline\\TimetrackerOnline.Web\\Lib\\API\\Controllers\\TimeEntryExportController.cs:line 120\r\n")

Permanently deleted user

March 21, 2017 16:48

We are gathering information about this issue. Sorry for inconvenience, this appears to be not easy to reproduce issue. I will post updates into this report about progress.

Miranda Dulin

March 29, 2017 16:12

We're experiencing this issue as well. When I run for dates 2017-02-28 through 2017-03-29 the data can be obtained successfully. When extending the range just one day to 2017-02-27 through 2017-03-29 causes the error. Just in case that information is helpful in any way.

Avi Levin

October 25, 2017 23:00

I got this exact error as well.

Handerson Koerich

October 31, 2017 15:38

I'm getting the same error here. It started at October 26, I have a process that export the data every day, until October 26 everything was working fine, then I start to get this error.

I'm using VSTS

January 15, 2018 16:23

I am going through issues which where actually fixed but state was not changed. This one is among them.

That error 500 was fixed, we had some more issues meanwhile which are fixed too.

Maxim

Reporting API. (500) Internal Server Error appears after request

Comments