2026-02-09 01:16:58.468 +07:00 [INF] Hangfire configured successfully 2026-02-09 01:16:58.500 +07:00 [INF] ESS Starting api .. Bismillah .. 2026-02-09 08:51:59.627 +07:00 [ERR] { "StatusCode": 207, "Message": "An error occurred while executing the command definition. See the inner exception for details.", "InnerMessage": "An error occurred while executing the command definition. See the inner exception for details. - Invalid column name 'NeedAbsensi'.", "Data": null } 2026-02-09 08:51:59.643 +07:00 [ERR] s : at System.Data.Entity.Core.EntityClient.Internal.EntityCommandDefinition.ExecuteStoreCommands(EntityCommand entityCommand, CommandBehavior behavior) at System.Data.Entity.Core.Objects.Internal.ObjectQueryExecutionPlan.Execute[TResultType](ObjectContext context, ObjectParameterCollection parameterValues) at System.Data.Entity.Core.Objects.ObjectContext.ExecuteInTransaction[T](Func`1 func, IDbExecutionStrategy executionStrategy, Boolean startLocalTransaction, Boolean releaseConnectionOnSuccess) at System.Data.Entity.Core.Objects.ObjectQuery`1.<>c__DisplayClass41_0.b__0() at System.Data.Entity.SqlServer.DefaultSqlExecutionStrategy.Execute[TResult](Func`1 operation) at System.Data.Entity.Core.Objects.ObjectQuery`1.GetResults(Nullable`1 forMergeOption) at System.Data.Entity.Core.Objects.ObjectQuery`1..GetEnumerator>b__31_0() at System.Data.Entity.Internal.LazyEnumerator`1.MoveNext() at System.Collections.Generic.List`1..ctor(IEnumerable`1 collection) at System.Linq.Enumerable.ToList[TSource](IEnumerable`1 source) at ESS.API.Controllers.JadwalStreamingController.<>c__DisplayClass6_0.b__3() in D:\Dev\ess-v2-api\ESS\Controllers\JadwalStreamingController.cs:line 59 at System.Threading.Tasks.Task`1.InnerInvoke() at System.Threading.Tasks.Task.Execute() --- End of stack trace from previous location where exception was thrown --- at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw() at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task) at ESS.API.Controllers.JadwalStreamingController.d__6.MoveNext() in D:\Dev\ess-v2-api\ESS\Controllers\JadwalStreamingController.cs:line 59 --- End of stack trace from previous location where exception was thrown --- at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw() at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task) at ESS.API.Controllers.JadwalStreamingController.d__8.MoveNext() in D:\Dev\ess-v2-api\ESS\Controllers\JadwalStreamingController.cs:line 93 --- End of stack trace from previous location where exception was thrown --- at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw() at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task) at System.Threading.Tasks.TaskHelpersExtensions.d__1`1.MoveNext() --- End of stack trace from previous location where exception was thrown --- at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw() at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task) at System.Web.Http.Controllers.ApiControllerActionInvoker.d__1.MoveNext() --- End of stack trace from previous location where exception was thrown --- at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw() at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task) at System.Web.Http.Filters.ActionFilterAttribute.d__6.MoveNext() --- End of stack trace from previous location where exception was thrown --- at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw() at System.Web.Http.Filters.ActionFilterAttribute.d__6.MoveNext() --- End of stack trace from previous location where exception was thrown --- at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw() at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task) at System.Web.Http.Filters.ActionFilterAttribute.d__5.MoveNext() --- End of stack trace from previous location where exception was thrown --- at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw() at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task) at System.Web.Http.Controllers.ActionFilterResult.d__5.MoveNext() --- End of stack trace from previous location where exception was thrown --- at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw() at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task) at System.Web.Http.Filters.AuthorizationFilterAttribute.d__3.MoveNext() --- End of stack trace from previous location where exception was thrown --- at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw() at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task) at System.Web.Http.Dispatcher.HttpControllerDispatcher.d__15.MoveNext() 2026-02-09 08:54:02.580 +07:00 [INF] Start Generate Nilai Member 38 with id 15838;d4216560-8436-4f2c-bd1e-dace5e1ba64a 2026-02-09 08:54:03.830 +07:00 [INF] End Generate Nilai Member 38 with id 15838;d4216560-8436-4f2c-bd1e-dace5e1ba64a 2026-02-09 08:54:08.413 +07:00 [INF] Start Generate Nilai Member 38 with id 15842;1a4e1679-a58a-4a0a-865d-be25f4aa83e4 2026-02-09 08:54:09.319 +07:00 [INF] End Generate Nilai Member 38 with id 15842;1a4e1679-a58a-4a0a-865d-be25f4aa83e4 2026-02-09 08:54:14.304 +07:00 [INF] Start Generate Nilai Member 38 with id 15843;ee5fd457-f977-4401-b6b3-30a31cda2f0c 2026-02-09 08:54:14.538 +07:00 [INF] End Generate Nilai Member 38 with id 15843;ee5fd457-f977-4401-b6b3-30a31cda2f0c 2026-02-09 09:07:27.767 +07:00 [INF] Start Generate Nilai Member 38 with id 15843;f86bb10c-23b7-4f43-9b9b-66b1f5494d10 2026-02-09 09:07:28.063 +07:00 [INF] End Generate Nilai Member 38 with id 15843;f86bb10c-23b7-4f43-9b9b-66b1f5494d10 2026-02-09 09:14:25.902 +07:00 [INF] Start Generate Nilai Member 38 with id 15843;980a3375-10ad-4db8-a65f-4653d18c2caa 2026-02-09 09:14:26.152 +07:00 [INF] End Generate Nilai Member 38 with id 15843;980a3375-10ad-4db8-a65f-4653d18c2caa 2026-02-09 10:18:02.225 +07:00 [INF] Start Generate Nilai Member 38 with id 15842;67a957d8-82e8-49a3-a4b3-3b1d57c0b5e8 2026-02-09 10:18:03.162 +07:00 [INF] End Generate Nilai Member 38 with id 15842;67a957d8-82e8-49a3-a4b3-3b1d57c0b5e8 2026-02-09 10:18:35.374 +07:00 [INF] Start Generate Nilai Member 38 with id 15842;5817068f-cc6f-4360-b477-24891a5d30a0 2026-02-09 10:18:35.999 +07:00 [INF] End Generate Nilai Member 38 with id 15842;5817068f-cc6f-4360-b477-24891a5d30a0 2026-02-09 10:18:47.268 +07:00 [INF] Start Generate Nilai Member 38 with id 15843;201f2bc7-41d1-406d-b80a-b7ec18347dc4 2026-02-09 10:18:47.503 +07:00 [INF] End Generate Nilai Member 38 with id 15843;201f2bc7-41d1-406d-b80a-b7ec18347dc4 2026-02-09 11:08:16.254 +07:00 [ERR] { "StatusCode": 2627, "Message": "Ooops, data ini sudah ada !", "InnerMessage": "Violation of UNIQUE KEY constraint 'UC_Username_MemberID'. Cannot insert duplicate key in object 'dbo.User'. The duplicate key value is (0085482508, 6).\r\nThe statement has been terminated.", "Data": null } 2026-02-09 11:08:16.254 +07:00 [ERR] s : at System.Data.Entity.Internal.InternalContext.SaveChanges() at ESS.API.Handler.ImportService.d__20.MoveNext() in D:\Dev\ess-v2-api\ESS\Handler\ImportService.cs:line 451 --- End of stack trace from previous location where exception was thrown --- at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw() at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task) at ESS.API.Controllers.ImportController.d__3.MoveNext() in D:\Dev\ess-v2-api\ESS\Controllers\ImportController.cs:line 35 --- End of stack trace from previous location where exception was thrown --- at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw() at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task) at System.Threading.Tasks.TaskHelpersExtensions.d__1`1.MoveNext() --- End of stack trace from previous location where exception was thrown --- at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw() at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task) at System.Web.Http.Controllers.ApiControllerActionInvoker.d__1.MoveNext() --- End of stack trace from previous location where exception was thrown --- at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw() at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task) at System.Web.Http.Filters.ActionFilterAttribute.d__6.MoveNext() --- End of stack trace from previous location where exception was thrown --- at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw() at System.Web.Http.Filters.ActionFilterAttribute.d__6.MoveNext() --- End of stack trace from previous location where exception was thrown --- at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw() at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task) at System.Web.Http.Filters.ActionFilterAttribute.d__5.MoveNext() --- End of stack trace from previous location where exception was thrown --- at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw() at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task) at System.Web.Http.Controllers.ActionFilterResult.d__5.MoveNext() --- End of stack trace from previous location where exception was thrown --- at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw() at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task) at System.Web.Http.Filters.AuthorizationFilterAttribute.d__3.MoveNext() --- End of stack trace from previous location where exception was thrown --- at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw() at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task) at System.Web.Http.Dispatcher.HttpControllerDispatcher.d__15.MoveNext() 2026-02-09 11:09:19.904 +07:00 [ERR] { "StatusCode": 2627, "Message": "Ooops, data ini sudah ada !", "InnerMessage": "Violation of UNIQUE KEY constraint 'UC_Username_MemberID'. Cannot insert duplicate key in object 'dbo.User'. The duplicate key value is (0085482508, 6).\r\nThe statement has been terminated.", "Data": null } 2026-02-09 11:09:19.904 +07:00 [ERR] s : at System.Data.Entity.Internal.InternalContext.SaveChanges() at ESS.API.Handler.ImportService.d__20.MoveNext() in D:\Dev\ess-v2-api\ESS\Handler\ImportService.cs:line 451 --- End of stack trace from previous location where exception was thrown --- at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw() at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task) at ESS.API.Controllers.ImportController.d__3.MoveNext() in D:\Dev\ess-v2-api\ESS\Controllers\ImportController.cs:line 35 --- End of stack trace from previous location where exception was thrown --- at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw() at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task) at System.Threading.Tasks.TaskHelpersExtensions.d__1`1.MoveNext() --- End of stack trace from previous location where exception was thrown --- at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw() at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task) at System.Web.Http.Controllers.ApiControllerActionInvoker.d__1.MoveNext() --- End of stack trace from previous location where exception was thrown --- at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw() at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task) at System.Web.Http.Filters.ActionFilterAttribute.d__6.MoveNext() --- End of stack trace from previous location where exception was thrown --- at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw() at System.Web.Http.Filters.ActionFilterAttribute.d__6.MoveNext() --- End of stack trace from previous location where exception was thrown --- at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw() at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task) at System.Web.Http.Filters.ActionFilterAttribute.d__5.MoveNext() --- End of stack trace from previous location where exception was thrown --- at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw() at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task) at System.Web.Http.Controllers.ActionFilterResult.d__5.MoveNext() --- End of stack trace from previous location where exception was thrown --- at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw() at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task) at System.Web.Http.Filters.AuthorizationFilterAttribute.d__3.MoveNext() --- End of stack trace from previous location where exception was thrown --- at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw() at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task) at System.Web.Http.Dispatcher.HttpControllerDispatcher.d__15.MoveNext() 2026-02-09 12:40:44.719 +07:00 [INF] Start Generate Nilai Member 38 with id 15843;361aa15a-5e1a-41dd-ad6e-c7e7f4ea9bff 2026-02-09 12:40:45.516 +07:00 [INF] End Generate Nilai Member 38 with id 15843;361aa15a-5e1a-41dd-ad6e-c7e7f4ea9bff 2026-02-09 12:40:52.173 +07:00 [INF] Start Generate Nilai Member 38 with id 15842;f214e78c-5e53-4b81-b49c-cd695ee2af60 2026-02-09 12:40:52.673 +07:00 [INF] End Generate Nilai Member 38 with id 15842;f214e78c-5e53-4b81-b49c-cd695ee2af60