{"store_code":"","client_code":"","source":".Net SqlClient Data Provider","message":"Execution Timeout Expired.  The timeout period elapsed prior to completion of the operation or the server is not responding.","method":"","class_name":"11","line_number":"0","time":"2025-01-01 10:33:29","error_code":"-2","procedure":"","server":"SERVER04","stack_trace":"at System.Data.SqlClient.SqlCommand.<>c.<ExecuteDbDataReaderAsync>b__180_0(Task`1 result)\r\n   at System.Threading.Tasks.ContinuationResultTaskFromResultTask`2.InnerInvoke()\r\n   at System.Threading.Tasks.Task.Execute()\r\n--- End of stack trace from previous location where exception was thrown ---\r\n   at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()\r\n   at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)\r\n   at Dapper.SqlMapper.<QueryMultipleAsync>d__ca.MoveNext()\r\n--- End of stack trace from previous location where exception was thrown ---\r\n   at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()\r\n   at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)\r\n   at System.Runtime.CompilerServices.TaskAwaiter`1.GetResult()\r\n   at Ethics.HelperModules.DataContext.SqlDapperHelper.<QueryMultiple>d__21.MoveNext()","priority":"medium","version_no":null,"app_version_no":null,"reccurence_count":1}
,
{"store_code":"","client_code":"","source":".Net SqlClient Data Provider","message":"Execution Timeout Expired.  The timeout period elapsed prior to completion of the operation or the server is not responding.","method":"","class_name":"11","line_number":"0","time":"2025-01-01 10:33:29","error_code":"-2","procedure":"","server":"SERVER04","stack_trace":"at Ethics.HelperModules.DataContext.SqlDapperHelper.<QueryMultiple>d__21.MoveNext()\r\n--- End of stack trace from previous location where exception was thrown ---\r\n   at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()\r\n   at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)\r\n   at System.Runtime.CompilerServices.TaskAwaiter`1.GetResult()\r\n   at BPPI.CPOS.BAL.StoreProcess.StoreDocumentProcessRepository.<GetPersonalDetails>d__4.MoveNext() in E:\\DPC15\\GIT Repository\\ZOTA\\CPOS_API\\ZOTA.CPOS.BAL\\StoreProcess\\StoreDocumentProcessRepository.cs:line 48\r\n--- End of stack trace from previous location where exception was thrown ---\r\n   at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()\r\n   at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)\r\n   at System.Runtime.CompilerServices.TaskAwaiter`1.GetResult()\r\n   at BPPI.CPOS.API.Controllers.StoreProcessController.<GetPersonalDetails>d__0.MoveNext() in E:\\DPC15\\GIT Repository\\ZOTA\\CPOS_API\\ZOTA.CPOS.API\\Controllers\\StoreProcessController.cs:line 22","priority":"medium","version_no":null,"app_version_no":null,"reccurence_count":1}
,
{"store_code":"","client_code":"","source":".Net SqlClient Data Provider","message":"Execution Timeout Expired.  The timeout period elapsed prior to completion of the operation or the server is not responding.","method":"","class_name":"11","line_number":"0","time":"2025-01-01 10:33:36","error_code":"-2","procedure":"","server":"SERVER04","stack_trace":"at Ethics.HelperModules.DataContext.SqlDapperHelper.<SqlQueryToListAsync>d__17`1.MoveNext()\r\n--- End of stack trace from previous location where exception was thrown ---\r\n   at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()\r\n   at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)\r\n   at System.Runtime.CompilerServices.TaskAwaiter`1.GetResult()\r\n   at BPPI.CPOS.BAL.StoreProcess.StoreExecutionProcessRepository.<GetRightsTypeWithApplicableStatus>d__49.MoveNext() in E:\\DPC15\\GIT Repository\\ZOTA\\CPOS_API\\ZOTA.CPOS.BAL\\StoreProcess\\StoreExecutionProcessRepository.cs:line 1411\r\n--- End of stack trace from previous location where exception was thrown ---\r\n   at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()\r\n   at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)\r\n   at System.Runtime.CompilerServices.TaskAwaiter`1.GetResult()\r\n   at BPPI.CPOS.API.Controllers.StoreExeProcessController.<GetStoreExecutionRights>d__28.MoveNext() in E:\\DPC15\\GIT Repository\\ZOTA\\CPOS_API\\ZOTA.CPOS.API\\Controllers\\StoreExeProcessController.cs:line 570","priority":"medium","version_no":null,"app_version_no":null,"reccurence_count":1}
,
{"store_code":"","client_code":"","source":".Net SqlClient Data Provider","message":"Execution Timeout Expired.  The timeout period elapsed prior to completion of the operation or the server is not responding.","method":"","class_name":"11","line_number":"0","time":"2025-01-01 10:34:02","error_code":"-2","procedure":"","server":"SERVER04","stack_trace":"at Ethics.HelperModules.DataContext.SqlDapperHelper.<SqlQueryToListAsync>d__17`1.MoveNext()\r\n--- End of stack trace from previous location where exception was thrown ---\r\n   at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()\r\n   at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)\r\n   at System.Runtime.CompilerServices.TaskAwaiter`1.GetResult()\r\n   at BPPI.CPOS.BAL.Common.CommonRepositories.<DynamicFilter>d__23.MoveNext() in E:\\DPC15\\GIT Repository\\ZOTA\\CPOS_API\\ZOTA.CPOS.BAL\\Common\\CommonRepositories.cs:line 548\r\n--- End of stack trace from previous location where exception was thrown ---\r\n   at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()\r\n   at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)\r\n   at System.Runtime.CompilerServices.TaskAwaiter`1.GetResult()\r\n   at BPPI.CPOS.BAL.Common.CommonRepositories.<ExecuteReportData>d__20.MoveNext() in E:\\DPC15\\GIT Repository\\ZOTA\\CPOS_API\\ZOTA.CPOS.BAL\\Common\\CommonRepositories.cs:line 436\r\n--- End of stack trace from previous location where exception was thrown ---\r\n   at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()\r\n   at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)\r\n   at System.Runtime.CompilerServices.TaskAwaiter`1.GetResult()\r\n   at BPPI.CPOS.API.Controllers.CommonController.<GetReportConfiguration>d__3.MoveNext() in E:\\DPC15\\GIT Repository\\ZOTA\\CPOS_API\\ZOTA.CPOS.API\\Controllers\\CommonController.cs:line 72","priority":"medium","version_no":null,"app_version_no":null,"reccurence_count":1}
,
{"store_code":"","client_code":"","source":".Net SqlClient Data Provider","message":"Execution Timeout Expired.  The timeout period elapsed prior to completion of the operation or the server is not responding.","method":"","class_name":"11","line_number":"0","time":"2025-01-01 10:34:06","error_code":"-2","procedure":"","server":"SERVER04","stack_trace":"at Ethics.HelperModules.DataContext.SqlDapperHelper.<SqlQueryToListAsync>d__17`1.MoveNext()\r\n--- End of stack trace from previous location where exception was thrown ---\r\n   at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()\r\n   at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)\r\n   at System.Runtime.CompilerServices.TaskAwaiter`1.GetResult()\r\n   at BPPI.CPOS.BAL.Common.CommonRepositories.<DynamicFilter>d__23.MoveNext() in E:\\DPC15\\GIT Repository\\ZOTA\\CPOS_API\\ZOTA.CPOS.BAL\\Common\\CommonRepositories.cs:line 515\r\n--- End of stack trace from previous location where exception was thrown ---\r\n   at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()\r\n   at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)\r\n   at System.Runtime.CompilerServices.TaskAwaiter`1.GetResult()\r\n   at BPPI.CPOS.BAL.Common.CommonRepositories.<ExecuteReportData>d__20.MoveNext() in E:\\DPC15\\GIT Repository\\ZOTA\\CPOS_API\\ZOTA.CPOS.BAL\\Common\\CommonRepositories.cs:line 436\r\n--- End of stack trace from previous location where exception was thrown ---\r\n   at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()\r\n   at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)\r\n   at System.Runtime.CompilerServices.TaskAwaiter`1.GetResult()\r\n   at BPPI.CPOS.API.Controllers.CommonController.<GetReportConfiguration>d__3.MoveNext() in E:\\DPC15\\GIT Repository\\ZOTA\\CPOS_API\\ZOTA.CPOS.API\\Controllers\\CommonController.cs:line 72","priority":"medium","version_no":null,"app_version_no":null,"reccurence_count":1}
,
{"store_code":"","client_code":"","source":".Net SqlClient Data Provider","message":"Execution Timeout Expired.  The timeout period elapsed prior to completion of the operation or the server is not responding.","method":"","class_name":"11","line_number":"0","time":"2025-01-01 10:34:58","error_code":"-2","procedure":"","server":"SERVER04","stack_trace":"at Ethics.HelperModules.DataContext.SqlDapperHelper.<SqlQueryToListAsync>d__17`1.MoveNext()\r\n--- End of stack trace from previous location where exception was thrown ---\r\n   at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()\r\n   at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)\r\n   at System.Runtime.CompilerServices.TaskAwaiter`1.GetResult()\r\n   at BPPI.CPOS.BAL.Common.CommonRepositories.<DynamicFilter>d__23.MoveNext() in E:\\DPC15\\GIT Repository\\ZOTA\\CPOS_API\\ZOTA.CPOS.BAL\\Common\\CommonRepositories.cs:line 548\r\n--- End of stack trace from previous location where exception was thrown ---\r\n   at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()\r\n   at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)\r\n   at System.Runtime.CompilerServices.TaskAwaiter`1.GetResult()\r\n   at BPPI.CPOS.BAL.Common.CommonRepositories.<ExecuteReportData>d__20.MoveNext() in E:\\DPC15\\GIT Repository\\ZOTA\\CPOS_API\\ZOTA.CPOS.BAL\\Common\\CommonRepositories.cs:line 436\r\n--- End of stack trace from previous location where exception was thrown ---\r\n   at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()\r\n   at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)\r\n   at System.Runtime.CompilerServices.TaskAwaiter`1.GetResult()\r\n   at BPPI.CPOS.API.Controllers.CommonController.<GetReportConfiguration>d__3.MoveNext() in E:\\DPC15\\GIT Repository\\ZOTA\\CPOS_API\\ZOTA.CPOS.API\\Controllers\\CommonController.cs:line 72","priority":"medium","version_no":null,"app_version_no":null,"reccurence_count":1}
,
{"store_code":"","client_code":"","source":".Net SqlClient Data Provider","message":"Execution Timeout Expired.  The timeout period elapsed prior to completion of the operation or the server is not responding.","method":"","class_name":"11","line_number":"0","time":"2025-01-01 10:35:28","error_code":"-2","procedure":"","server":"SERVER04","stack_trace":"at Ethics.HelperModules.DataContext.SqlDapperHelper.<SqlQueryToListAsync>d__17`1.MoveNext()\r\n--- End of stack trace from previous location where exception was thrown ---\r\n   at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()\r\n   at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)\r\n   at System.Runtime.CompilerServices.TaskAwaiter`1.GetResult()\r\n   at BPPI.CPOS.BAL.StoreProcess.StoreExecutionProcessRepository.<GetRightsTypeWithApplicableStatus>d__49.MoveNext() in E:\\DPC15\\GIT Repository\\ZOTA\\CPOS_API\\ZOTA.CPOS.BAL\\StoreProcess\\StoreExecutionProcessRepository.cs:line 1411\r\n--- End of stack trace from previous location where exception was thrown ---\r\n   at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()\r\n   at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)\r\n   at System.Runtime.CompilerServices.TaskAwaiter`1.GetResult()\r\n   at BPPI.CPOS.API.Controllers.StoreExeProcessController.<GetStoreExecutionRights>d__28.MoveNext() in E:\\DPC15\\GIT Repository\\ZOTA\\CPOS_API\\ZOTA.CPOS.API\\Controllers\\StoreExeProcessController.cs:line 570","priority":"medium","version_no":null,"app_version_no":null,"reccurence_count":1}
,
{"store_code":"","client_code":"","source":".Net SqlClient Data Provider","message":"Execution Timeout Expired.  The timeout period elapsed prior to completion of the operation or the server is not responding.","method":"","class_name":"11","line_number":"0","time":"2025-01-01 10:35:28","error_code":"-2","procedure":"","server":"SERVER04","stack_trace":"at System.Data.SqlClient.SqlCommand.<>c.<ExecuteDbDataReaderAsync>b__180_0(Task`1 result)\r\n   at System.Threading.Tasks.ContinuationResultTaskFromResultTask`2.InnerInvoke()\r\n   at System.Threading.Tasks.Task.Execute()\r\n--- End of stack trace from previous location where exception was thrown ---\r\n   at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()\r\n   at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)\r\n   at Dapper.SqlMapper.<QueryMultipleAsync>d__ca.MoveNext()\r\n--- End of stack trace from previous location where exception was thrown ---\r\n   at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()\r\n   at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)\r\n   at System.Runtime.CompilerServices.TaskAwaiter`1.GetResult()\r\n   at Ethics.HelperModules.DataContext.SqlDapperHelper.<QueryMultiple>d__21.MoveNext()","priority":"medium","version_no":null,"app_version_no":null,"reccurence_count":1}
,
{"store_code":"","client_code":"","source":".Net SqlClient Data Provider","message":"Execution Timeout Expired.  The timeout period elapsed prior to completion of the operation or the server is not responding.","method":"","class_name":"11","line_number":"0","time":"2025-01-01 10:35:28","error_code":"-2","procedure":"","server":"SERVER04","stack_trace":"at Ethics.HelperModules.DataContext.SqlDapperHelper.<QueryMultiple>d__21.MoveNext()\r\n--- End of stack trace from previous location where exception was thrown ---\r\n   at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()\r\n   at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)\r\n   at System.Runtime.CompilerServices.TaskAwaiter`1.GetResult()\r\n   at BPPI.CPOS.BAL.StoreProcess.StoreDocumentProcessRepository.<GetPersonalDetails>d__4.MoveNext() in E:\\DPC15\\GIT Repository\\ZOTA\\CPOS_API\\ZOTA.CPOS.BAL\\StoreProcess\\StoreDocumentProcessRepository.cs:line 48\r\n--- End of stack trace from previous location where exception was thrown ---\r\n   at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()\r\n   at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)\r\n   at System.Runtime.CompilerServices.TaskAwaiter`1.GetResult()\r\n   at BPPI.CPOS.API.Controllers.StoreProcessController.<GetPersonalDetails>d__0.MoveNext() in E:\\DPC15\\GIT Repository\\ZOTA\\CPOS_API\\ZOTA.CPOS.API\\Controllers\\StoreProcessController.cs:line 22","priority":"medium","version_no":null,"app_version_no":null,"reccurence_count":1}
,
{"store_code":"","client_code":"","source":".Net SqlClient Data Provider","message":"Execution Timeout Expired.  The timeout period elapsed prior to completion of the operation or the server is not responding.","method":"","class_name":"11","line_number":"0","time":"2025-01-01 10:36:02","error_code":"-2","procedure":"","server":"SERVER04","stack_trace":"at Ethics.HelperModules.DataContext.SqlDapperHelper.<SqlQueryToListAsync>d__17`1.MoveNext()\r\n--- End of stack trace from previous location where exception was thrown ---\r\n   at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()\r\n   at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)\r\n   at System.Runtime.CompilerServices.TaskAwaiter`1.GetResult()\r\n   at BPPI.CPOS.BAL.Common.CommonRepositories.<DynamicFilter>d__23.MoveNext() in E:\\DPC15\\GIT Repository\\ZOTA\\CPOS_API\\ZOTA.CPOS.BAL\\Common\\CommonRepositories.cs:line 515\r\n--- End of stack trace from previous location where exception was thrown ---\r\n   at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()\r\n   at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)\r\n   at System.Runtime.CompilerServices.TaskAwaiter`1.GetResult()\r\n   at BPPI.CPOS.BAL.Common.CommonRepositories.<ExecuteReportData>d__20.MoveNext() in E:\\DPC15\\GIT Repository\\ZOTA\\CPOS_API\\ZOTA.CPOS.BAL\\Common\\CommonRepositories.cs:line 436\r\n--- End of stack trace from previous location where exception was thrown ---\r\n   at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()\r\n   at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)\r\n   at System.Runtime.CompilerServices.TaskAwaiter`1.GetResult()\r\n   at BPPI.CPOS.API.Controllers.CommonController.<GetReportConfiguration>d__3.MoveNext() in E:\\DPC15\\GIT Repository\\ZOTA\\CPOS_API\\ZOTA.CPOS.API\\Controllers\\CommonController.cs:line 72","priority":"medium","version_no":null,"app_version_no":null,"reccurence_count":1}
,
{"store_code":"","client_code":"","source":".Net SqlClient Data Provider","message":"Execution Timeout Expired.  The timeout period elapsed prior to completion of the operation or the server is not responding.","method":"","class_name":"11","line_number":"0","time":"2025-01-01 10:36:02","error_code":"-2","procedure":"","server":"SERVER04","stack_trace":"at System.Data.SqlClient.SqlCommand.<>c.<ExecuteDbDataReaderAsync>b__180_0(Task`1 result)\r\n   at System.Threading.Tasks.ContinuationResultTaskFromResultTask`2.InnerInvoke()\r\n   at System.Threading.Tasks.Task.Execute()\r\n--- End of stack trace from previous location where exception was thrown ---\r\n   at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()\r\n   at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)\r\n   at Dapper.SqlMapper.<QueryAsync>d__83`1.MoveNext()\r\n--- End of stack trace from previous location where exception was thrown ---\r\n   at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()\r\n   at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)\r\n   at System.Runtime.CompilerServices.ConfiguredTaskAwaitable`1.ConfiguredTaskAwaiter.GetResult()\r\n   at Ethics.HelperModules.DataContext.SqlDapperHelper.<FirstOrDefaultScalarAsync>d__20`1.MoveNext()","priority":"medium","version_no":null,"app_version_no":null,"reccurence_count":1}
,
{"store_code":"","client_code":"","source":".Net SqlClient Data Provider","message":"Execution Timeout Expired.  The timeout period elapsed prior to completion of the operation or the server is not responding.","method":"","class_name":"11","line_number":"0","time":"2025-01-01 10:36:02","error_code":"-2","procedure":"","server":"SERVER04","stack_trace":"at Ethics.HelperModules.DataContext.SqlDapperHelper.<FirstOrDefaultScalarAsync>d__20`1.MoveNext()\r\n--- End of stack trace from previous location where exception was thrown ---\r\n   at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()\r\n   at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)\r\n   at System.Runtime.CompilerServices.TaskAwaiter`1.GetResult()\r\n   at BPPI.CPOS.BAL.StoreNotification.StoreNotificationRepository.<CountNotification>d__7.MoveNext() in E:\\DPC15\\GIT Repository\\ZOTA\\CPOS_API\\ZOTA.CPOS.BAL\\StoreNotification\\StoreNotificationRepository.cs:line 103\r\n--- End of stack trace from previous location where exception was thrown ---\r\n   at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()\r\n   at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)\r\n   at System.Runtime.CompilerServices.TaskAwaiter`1.GetResult()\r\n   at BPPI.CPOS.API.Controllers.StoreNotificationController.<NotificationCount>d__3.MoveNext() in E:\\DPC15\\GIT Repository\\ZOTA\\CPOS_API\\ZOTA.CPOS.API\\Controllers\\StoreNotificationController.cs:line 68","priority":"medium","version_no":null,"app_version_no":null,"reccurence_count":1}
,
{"store_code":"","client_code":"","source":"mscorlib","message":"Could not find a part of the path 'D:\\DavaIndia\\POSPublish\\AutoUpdater\\1.0.0.4.zip'.","method":"","class_name":"","line_number":"","time":"2025-01-01 11:21:06","error_code":"","procedure":"","server":"","stack_trace":"at System.IO.__Error.WinIOError(Int32 errorCode, String maybeFullPath)\r\n   at System.IO.FileStream.Init(String path, FileMode mode, FileAccess access, Int32 rights, Boolean useRights, FileShare share, Int32 bufferSize, FileOptions options, SECURITY_ATTRIBUTES secAttrs, String msgPath, Boolean bFromProxy, Boolean useLongPath, Boolean checkHost)\r\n   at System.IO.FileStream..ctor(String path, FileMode mode, FileAccess access, FileShare share, Int32 bufferSize, FileOptions options, String msgPath, Boolean bFromProxy, Boolean useLongPath, Boolean checkHost)\r\n   at System.IO.File.InternalReadAllBytes(String path, Boolean checkHost)\r\n   at BPPI.CPOS.API.Controllers.UploadFileController.<>c__DisplayClass8_0.<GetZipFile>b__0() in E:\\DPC15\\GIT Repository\\ZOTA\\CPOS_API\\ZOTA.CPOS.API\\Controllers\\UploadFileController.cs:line 208\r\n   at System.Threading.Tasks.Task`1.InnerInvoke()\r\n   at System.Threading.Tasks.Task.Execute()\r\n--- End of stack trace from previous location where exception was thrown ---\r\n   at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()\r\n   at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)\r\n   at System.Runtime.CompilerServices.TaskAwaiter`1.GetResult()\r\n   at BPPI.CPOS.API.Controllers.UploadFileController.<GetZipFile>d__8.MoveNext() in E:\\DPC15\\GIT Repository\\ZOTA\\CPOS_API\\ZOTA.CPOS.API\\Controllers\\UploadFileController.cs:line 202","priority":"medium","version_no":null,"app_version_no":null,"reccurence_count":1}
,
{"store_code":"","client_code":"","source":".Net SqlClient Data Provider","message":"Invalid object name 'cPOS_SALES_DATA..ApiConfiguration'.","method":"","class_name":"16","line_number":"9","time":"2025-01-01 11:21:14","error_code":"208","procedure":"SP_VALIDATE_API_KEY","server":"SERVER04","stack_trace":"at BPPI.CPOS.DAL.APIHelper.ValidateAPIKey(Int32 APIId, String APIKey) in E:\\DPC15\\GIT Repository\\ZOTA\\CPOS_API\\ZOTA.CPOS.DAL\\SqlHelperDbSalesData.cs:line 183\r\n   at BPPI.CPOS.API.Controllers.StoreController.<GetStoreStatus>d__39.MoveNext() in E:\\DPC15\\GIT Repository\\ZOTA\\CPOS_API\\ZOTA.CPOS.API\\Controllers\\StoreController.cs:line 781","priority":"medium","version_no":null,"app_version_no":null,"reccurence_count":1}
,
{"store_code":"","client_code":"","source":"Ethics.HelperModules","message":"Timeout expired.  The timeout period elapsed prior to obtaining a connection from the pool.  This may have occurred because all pooled connections were in use and max pool size was reached.","method":"","class_name":"","line_number":"","time":"2025-01-01 12:23:34","error_code":"","procedure":"","server":"","stack_trace":"at Ethics.HelperModules.DataContext.SqlDapperHelper.<SqlQueryToListAsync>d__17`1.MoveNext()\r\n--- End of stack trace from previous location where exception was thrown ---\r\n   at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()\r\n   at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)\r\n   at System.Runtime.CompilerServices.TaskAwaiter`1.GetResult()\r\n   at BPPI.CPOS.BAL.StoreProcess.StoreDocumentProcessRepository.<GetLocationHistory>d__11.MoveNext() in E:\\DPC15\\GIT Repository\\ZOTA\\CPOS_API\\ZOTA.CPOS.BAL\\StoreProcess\\StoreDocumentProcessRepository.cs:line 278\r\n--- End of stack trace from previous location where exception was thrown ---\r\n   at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()\r\n   at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)\r\n   at System.Runtime.CompilerServices.TaskAwaiter`1.GetResult()\r\n   at BPPI.CPOS.API.Controllers.StoreProcessController.<GetLocationHistory>d__8.MoveNext() in E:\\DPC15\\GIT Repository\\ZOTA\\CPOS_API\\ZOTA.CPOS.API\\Controllers\\StoreProcessController.cs:line 181","priority":"medium","version_no":null,"app_version_no":null,"reccurence_count":1}
,
{"store_code":"","client_code":"","source":".Net SqlClient Data Provider","message":"Invalid object name 'cPOS_SALES_DATA..ApiConfiguration'.","method":"","class_name":"16","line_number":"9","time":"2025-01-01 14:43:41","error_code":"208","procedure":"SP_VALIDATE_API_KEY","server":"SERVER04","stack_trace":"at BPPI.CPOS.DAL.APIHelper.ValidateAPIKey(Int32 APIId, String APIKey) in E:\\DPC15\\GIT Repository\\ZOTA\\CPOS_API\\ZOTA.CPOS.DAL\\SqlHelperDbSalesData.cs:line 183\r\n   at BPPI.CPOS.API.Controllers.StoreController.<GetStoreStatus>d__39.MoveNext() in E:\\DPC15\\GIT Repository\\ZOTA\\CPOS_API\\ZOTA.CPOS.API\\Controllers\\StoreController.cs:line 781","priority":"medium","version_no":null,"app_version_no":null,"reccurence_count":1}
,
{"store_code":"","client_code":"","source":"","message":"Data Not Found. SyncId:15","method":"","class_name":"","line_number":"","time":"2025-01-01 14:44:31","error_code":"","procedure":"","server":"","stack_trace":"","priority":"","version_no":null,"app_version_no":null,"reccurence_count":1}
,
{"store_code":"","client_code":"","source":".Net SqlClient Data Provider","message":"Invalid object name 'cPOS_SALES_DATA..ApiConfiguration'.","method":"","class_name":"16","line_number":"9","time":"2025-01-01 14:46:07","error_code":"208","procedure":"SP_VALIDATE_API_KEY","server":"SERVER04","stack_trace":"at BPPI.CPOS.DAL.APIHelper.ValidateAPIKey(Int32 APIId, String APIKey) in E:\\DPC15\\GIT Repository\\ZOTA\\CPOS_API\\ZOTA.CPOS.DAL\\SqlHelperDbSalesData.cs:line 183\r\n   at BPPI.CPOS.API.Controllers.StoreController.<GetStoreStatus>d__39.MoveNext() in E:\\DPC15\\GIT Repository\\ZOTA\\CPOS_API\\ZOTA.CPOS.API\\Controllers\\StoreController.cs:line 781","priority":"medium","version_no":null,"app_version_no":null,"reccurence_count":1}
,
{"store_code":"","client_code":"","source":".Net SqlClient Data Provider","message":"Invalid object name 'cPOS_SALES_DATA..ApiConfiguration'.","method":"","class_name":"16","line_number":"9","time":"2025-01-01 14:57:54","error_code":"208","procedure":"SP_VALIDATE_API_KEY","server":"SERVER04","stack_trace":"at BPPI.CPOS.DAL.APIHelper.ValidateAPIKey(Int32 APIId, String APIKey) in E:\\DPC15\\GIT Repository\\ZOTA\\CPOS_API\\ZOTA.CPOS.DAL\\SqlHelperDbSalesData.cs:line 183\r\n   at BPPI.CPOS.API.Controllers.StoreController.<GetStoreStatus>d__39.MoveNext() in E:\\DPC15\\GIT Repository\\ZOTA\\CPOS_API\\ZOTA.CPOS.API\\Controllers\\StoreController.cs:line 781","priority":"medium","version_no":null,"app_version_no":null,"reccurence_count":1}
,
{"store_code":"","client_code":"","source":".Net SqlClient Data Provider","message":"Invalid object name 'cPOS_SALES_DATA..ApiConfiguration'.","method":"","class_name":"16","line_number":"9","time":"2025-01-01 15:05:09","error_code":"208","procedure":"SP_VALIDATE_API_KEY","server":"SERVER04","stack_trace":"at BPPI.CPOS.DAL.APIHelper.ValidateAPIKey(Int32 APIId, String APIKey) in E:\\DPC15\\GIT Repository\\ZOTA\\CPOS_API\\ZOTA.CPOS.DAL\\SqlHelperDbSalesData.cs:line 183\r\n   at BPPI.CPOS.API.Controllers.StoreController.<GetStoreStatus>d__39.MoveNext() in E:\\DPC15\\GIT Repository\\ZOTA\\CPOS_API\\ZOTA.CPOS.API\\Controllers\\StoreController.cs:line 781","priority":"medium","version_no":null,"app_version_no":null,"reccurence_count":1}
,
{"store_code":"","client_code":"","source":".Net SqlClient Data Provider","message":"Invalid object name 'cPOS_SALES_DATA..ApiConfiguration'.","method":"","class_name":"16","line_number":"9","time":"2025-01-01 15:12:07","error_code":"208","procedure":"SP_VALIDATE_API_KEY","server":"SERVER04","stack_trace":"at BPPI.CPOS.DAL.APIHelper.ValidateAPIKey(Int32 APIId, String APIKey) in E:\\DPC15\\GIT Repository\\ZOTA\\CPOS_API\\ZOTA.CPOS.DAL\\SqlHelperDbSalesData.cs:line 183\r\n   at BPPI.CPOS.API.Controllers.StoreController.<GetStoreStatus>d__39.MoveNext() in E:\\DPC15\\GIT Repository\\ZOTA\\CPOS_API\\ZOTA.CPOS.API\\Controllers\\StoreController.cs:line 781","priority":"medium","version_no":null,"app_version_no":null,"reccurence_count":1}
,
{"store_code":"","client_code":"","source":"","message":"Data Not Found. SyncId:15","method":"","class_name":"","line_number":"","time":"2025-01-01 15:12:48","error_code":"","procedure":"","server":"","stack_trace":"","priority":"","version_no":null,"app_version_no":null,"reccurence_count":1}
,
{"store_code":"","client_code":"","source":".Net SqlClient Data Provider","message":"Invalid object name 'cPOS_SALES_DATA..ApiConfiguration'.","method":"","class_name":"16","line_number":"9","time":"2025-01-01 15:15:36","error_code":"208","procedure":"SP_VALIDATE_API_KEY","server":"SERVER04","stack_trace":"at BPPI.CPOS.DAL.APIHelper.ValidateAPIKey(Int32 APIId, String APIKey) in E:\\DPC15\\GIT Repository\\ZOTA\\CPOS_API\\ZOTA.CPOS.DAL\\SqlHelperDbSalesData.cs:line 183\r\n   at BPPI.CPOS.API.Controllers.StoreController.<GetStoreStatus>d__39.MoveNext() in E:\\DPC15\\GIT Repository\\ZOTA\\CPOS_API\\ZOTA.CPOS.API\\Controllers\\StoreController.cs:line 781","priority":"medium","version_no":null,"app_version_no":null,"reccurence_count":1}
,
{"store_code":"","client_code":"","source":".Net SqlClient Data Provider","message":"Invalid object name 'cPOS_SALES_DATA..ApiConfiguration'.","method":"","class_name":"16","line_number":"9","time":"2025-01-01 15:40:09","error_code":"208","procedure":"SP_VALIDATE_API_KEY","server":"SERVER04","stack_trace":"at BPPI.CPOS.DAL.APIHelper.ValidateAPIKey(Int32 APIId, String APIKey) in E:\\DPC15\\GIT Repository\\ZOTA\\CPOS_API\\ZOTA.CPOS.DAL\\SqlHelperDbSalesData.cs:line 183\r\n   at BPPI.CPOS.API.Controllers.StoreController.<GetStoreStatus>d__39.MoveNext() in E:\\DPC15\\GIT Repository\\ZOTA\\CPOS_API\\ZOTA.CPOS.API\\Controllers\\StoreController.cs:line 781","priority":"medium","version_no":null,"app_version_no":null,"reccurence_count":1}
,
{"store_code":"","client_code":"","source":"","message":"Data Not Found. SyncId:15","method":"","class_name":"","line_number":"","time":"2025-01-01 15:44:45","error_code":"","procedure":"","server":"","stack_trace":"","priority":"","version_no":null,"app_version_no":null,"reccurence_count":1}
,
{"store_code":"","client_code":"","source":"","message":"Data Not Found. SyncId:15","method":"","class_name":"","line_number":"","time":"2025-01-01 16:12:13","error_code":"","procedure":"","server":"","stack_trace":"","priority":"","version_no":null,"app_version_no":null,"reccurence_count":1}
,
{"store_code":"","client_code":"","source":".Net SqlClient Data Provider","message":"Invalid object name 'cPOS_SALES_DATA..ApiConfiguration'.","method":"","class_name":"16","line_number":"9","time":"2025-01-01 16:27:37","error_code":"208","procedure":"SP_VALIDATE_API_KEY","server":"SERVER04","stack_trace":"at BPPI.CPOS.DAL.APIHelper.ValidateAPIKey(Int32 APIId, String APIKey) in E:\\DPC15\\GIT Repository\\ZOTA\\CPOS_API\\ZOTA.CPOS.DAL\\SqlHelperDbSalesData.cs:line 183\r\n   at BPPI.CPOS.API.Controllers.StoreController.<GetStoreStatus>d__39.MoveNext() in E:\\DPC15\\GIT Repository\\ZOTA\\CPOS_API\\ZOTA.CPOS.API\\Controllers\\StoreController.cs:line 781","priority":"medium","version_no":null,"app_version_no":null,"reccurence_count":1}
,
{"store_code":"","client_code":"","source":"","message":"Data Not Found. SyncId:15","method":"","class_name":"","line_number":"","time":"2025-01-01 16:44:47","error_code":"","procedure":"","server":"","stack_trace":"","priority":"","version_no":null,"app_version_no":null,"reccurence_count":1}
,
{"store_code":"","client_code":"","source":"","message":"Data Not Found. SyncId:15","method":"","class_name":"","line_number":"","time":"2025-01-01 17:44:46","error_code":"","procedure":"","server":"","stack_trace":"","priority":"","version_no":null,"app_version_no":null,"reccurence_count":1}
,
{"store_code":"","client_code":"","source":".Net SqlClient Data Provider","message":"Invalid object name 'cPOS_SALES_DATA..ApiConfiguration'.","method":"","class_name":"16","line_number":"9","time":"2025-01-01 18:33:00","error_code":"208","procedure":"SP_VALIDATE_API_KEY","server":"SERVER04","stack_trace":"at BPPI.CPOS.DAL.APIHelper.ValidateAPIKey(Int32 APIId, String APIKey) in E:\\DPC15\\GIT Repository\\ZOTA\\CPOS_API\\ZOTA.CPOS.DAL\\SqlHelperDbSalesData.cs:line 183\r\n   at BPPI.CPOS.API.Controllers.StoreController.<GetStoreStatus>d__39.MoveNext() in E:\\DPC15\\GIT Repository\\ZOTA\\CPOS_API\\ZOTA.CPOS.API\\Controllers\\StoreController.cs:line 781","priority":"medium","version_no":null,"app_version_no":null,"reccurence_count":1}
,
{"store_code":"","client_code":"","source":"Ethics.HelperModules","message":"Timeout expired.  The timeout period elapsed prior to obtaining a connection from the pool.  This may have occurred because all pooled connections were in use and max pool size was reached.","method":"","class_name":"","line_number":"","time":"2025-01-01 18:51:37","error_code":"","procedure":"","server":"","stack_trace":"at Ethics.HelperModules.DataContext.SqlDapperHelper.<SqlQueryToListAsync>d__17`1.MoveNext()\r\n--- End of stack trace from previous location where exception was thrown ---\r\n   at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()\r\n   at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)\r\n   at System.Runtime.CompilerServices.TaskAwaiter`1.GetResult()\r\n   at BPPI.CPOS.BAL.Employee.EmployeeRepository.<GetRelationShipManagers>d__5.MoveNext() in E:\\DPC15\\GIT Repository\\ZOTA\\CPOS_API\\ZOTA.CPOS.BAL\\Employee\\EmployeeRepository.cs:line 77\r\n--- End of stack trace from previous location where exception was thrown ---\r\n   at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()\r\n   at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)\r\n   at System.Runtime.CompilerServices.TaskAwaiter`1.GetResult()\r\n   at BPPI.CPOS.API.Controllers.EmployeeController.<GetRelationShipManagers>d__2.MoveNext() in E:\\DPC15\\GIT Repository\\ZOTA\\CPOS_API\\ZOTA.CPOS.API\\Controllers\\EmployeeController.cs:line 62","priority":"medium","version_no":null,"app_version_no":null,"reccurence_count":1}
,
{"store_code":"","client_code":"","source":".Net SqlClient Data Provider","message":"Invalid object name 'cPOS_SALES_DATA..ApiConfiguration'.","method":"","class_name":"16","line_number":"9","time":"2025-01-01 19:36:20","error_code":"208","procedure":"SP_VALIDATE_API_KEY","server":"SERVER04","stack_trace":"at BPPI.CPOS.DAL.APIHelper.ValidateAPIKey(Int32 APIId, String APIKey) in E:\\DPC15\\GIT Repository\\ZOTA\\CPOS_API\\ZOTA.CPOS.DAL\\SqlHelperDbSalesData.cs:line 183\r\n   at BPPI.CPOS.API.Controllers.StoreController.<GetStoreStatus>d__39.MoveNext() in E:\\DPC15\\GIT Repository\\ZOTA\\CPOS_API\\ZOTA.CPOS.API\\Controllers\\StoreController.cs:line 781","priority":"medium","version_no":null,"app_version_no":null,"reccurence_count":1}
,
{"store_code":"","client_code":"","source":".Net SqlClient Data Provider","message":"Execution Timeout Expired.  The timeout period elapsed prior to completion of the operation or the server is not responding.\r\nDECLARE @LastSyncDate table(\r\n\t\t\t\tstore_Code VARCHAR(MAX),\n\t\t\t\tsalesLastSyncDate DATETIME,\n\t\t\t\tpurchaseLastSyncDate DATETIME,\n\t\t\t\tsalesReturnDate DATETIME,\n\t\t\t\tdebitNoteDate DATETIME,\n\t\t\t\tcreditNoteDate DATETIME,\n\t\t\t\tstockLastSyncDate DATETIME,\n\t\t\t\tMaxDBBackupDATE DATETIME,\n\t\t\t\tIsDataSyncedToday BIGINT\r\n\t\t\t)\r\n\r\n\t\t\tINSERT INTO @LastSyncDate \r\n\t\t\t\t(store_Code, salesLastSyncDate, purchaseLastSyncDate, salesReturnDate, debitNoteDate, creditNoteDate, stockLastSyncDate, MaxDBBackupDATE, IsDataSyncedToday)\r\n\t\t\tSELECT\r\n\t\t\t\tCOALESCE(Sales.store_Code, Purchase.store_Code, AccountNote.store_Code, Stock.store_Code, CloudBackup.store_Code, SyncLog.store_Code) AS store_Code,\r\n\t\t\t\tSales.SalesLastSyncDate,\r\n\t\t\t\tPurchase.PurchaseLastSyncDate,\r\n\t\t\t\tAccountNote.salesReturnDate,\r\n\t\t\t\tAccountNote.debitNoteDate,\r\n\t\t\t\tAccountNote.creditNoteDate,\r\n\t\t\t\tStock.stockLastSyncDate,\r\n\t\t\t\tCloudBackup.MaxDBBackupDATE,\r\n\t\t\t\tSyncLog.IsDataSyncedToday\r\n\t\t\tFROM\r\n\t\t\t\t(\r\n\t\t\t\t\tSELECT\r\n\t\t\t\t\t\tSIH.Sih_Store_Code AS store_Code,\r\n\t\t\t\t\t\tMAX(SIH.Sih_Date) AS SalesLastSyncDate\r\n\t\t\t\t\tFROM\r\n\t\t\t\t\t\tSalesInvoiceHeader_POS (NOLOCK) SIH\r\n\t\t\t\t\tWHERE 1=1 GROUP BY SIH.Sih_Store_Code\r\n\t\t\t\t) Sales\r\n\t\t\t\tFULL OUTER JOIN (\r\n\t\t\t\t\tSELECT\r\n\t\t\t\t\t\tPIH.Pih_StoreCode AS store_Code,\r\n\t\t\t\t\t\tMAX(PIH.Pih_Date) AS PurchaseLastSyncDate\r\n\t\t\t\t\tFROM\r\n\t\t\t\t\t\tPurchaseInvoiceHeader_POS (NOLOCK) PIH\r\n\t\t\t\t\tWHERE 1=1 GROUP BY PIH.Pih_StoreCode\r\n\t\t\t\t) Purchase ON Sales.store_Code = Purchase.store_Code\r\n\t\t\t\tFULL OUTER JOIN (\r\n\t\t\t\t\tSELECT\r\n\t\t\t\t\t\tANH.Doc_Store_Code AS store_Code,\r\n\t\t\t\t\t\tMAX(CASE WHEN ANH.Doc_Type = 0 THEN CAST(ANH.Doc_Date AS DATE) ELSE NULL END) AS salesReturnDate,\r\n\t\t\t\t\t\tMAX(CASE WHEN ANH.Doc_Type = 1 THEN CAST(ANH.Doc_Date AS DATE) ELSE NULL END) AS debitNoteDate,\r\n\t\t\t\t\t\tMAX(CASE WHEN ANH.Doc_Type = 2 THEN CAST(ANH.Doc_Date AS DATE) ELSE NULL END) AS creditNoteDate\r\n\t\t\t\t\tFROM\r\n\t\t\t\t\t\tAccountNoteHeader (NOLOCK) ANH\r\n\t\t\t\t\tWHERE 1=1 GROUP BY ANH.Doc_Store_Code\r\n\t\t\t\t) AccountNote ON Sales.store_Code = AccountNote.store_Code \r\n\t\t\t\tOR Purchase.store_Code = AccountNote.store_Code\r\n\t\t\t\tFULL OUTER JOIN (\r\n\t\t\t\t\tSELECT\r\n\t\t\t\t\t\tPMS.Pms_Store_Code AS store_Code,\r\n\t\t\t\t\t\tMAX(Pms_Last_Updated) AS stockLastSyncDate\r\n\t\t\t\t\tFROM\r\n\t\t\t\t\t\tPosMedicineStock (NOLOCK) PMS\r\n\t\t\t\t\tWHERE 1=1 GROUP BY PMS.Pms_Store_Code\r\n\t\t\t\t) Stock ON Sales.store_Code = Stock.store_Code \r\n\t\t\t\tOR Purchase.store_Code = Stock.store_Code \r\n\t\t\t\tOR AccountNote.store_Code = Stock.store_Code\r\n\t\t\t\tFULL OUTER JOIN (\r\n\t\t\t\t\tSELECT\r\n\t\t\t\t\t\tCBPOS.cb_Store_Code AS store_Code,\r\n\t\t\t\t\t\tMAX(CB_UploadDate) AS MaxDBBackupDATE\r\n\t\t\t\t\tFROM\r\n\t\t\t\t\t\t[CloudBackupInfo_POS] (NOLOCK) CBPOS\r\n\t\t\t\t\tWHERE 1=1 GROUP BY CBPOS.cb_Store_Code\r\n\t\t\t\t) CloudBackup ON Sales.store_Code = CloudBackup.store_Code \r\n\t\t\t\tOR Purchase.store_Code = CloudBackup.store_Code \r\n\t\t\t\tOR AccountNote.store_Code = CloudBackup.store_Code \r\n\t\t\t\tOR Stock.store_Code = CloudBackup.store_Code\r\n\t\t\t\tFULL OUTER JOIN (\r\n\t\t\t\t\tSELECT\r\n\t\t\t\t\t\tSL.StoreCode AS store_Code,\r\n\t\t\t\t\t\tMAX(SL.LogId) AS IsDataSyncedToday\r\n\t\t\t\t\tFROM\r\n\t\t\t\t\t\t[SyncLog] (NOLOCK) SL\r\n\t\t\t\t\tWHERE\r\n\t\t\t\t\t\tCAST(GETDATE() AS DATE) = CAST(SL.SyncDate AS DATE)\r\n\t\t\t\t\t\tGROUP BY SL.StoreCode\r\n\t\t\t\t) SyncLog ON Sales.store_Code = SyncLog.store_Code \r\n\t\t\t\tOR Purchase.store_Code = SyncLog.store_Code \r\n\t\t\t\tOR AccountNote.store_Code = SyncLog.store_Code \r\n\t\t\t\tOR Stock.store_Code = SyncLog.store_Code \r\n\t\t\t\tOR CloudBackup.store_Code = SyncLog.store_Code;\r\n\r\n\t\t\tSELECT COUNT(1) OVER() AS TotalRecord,* FROM(SELECT\r\n\t\t\t\t\tSD.StoreNo\t\t\t\t\t\t\t\tAS storeNo,\r\n\t\t\t\t\tSD.Category\t\t\t\t\t\t\t\tAS category,\r\n\t\t\t\t\t(CASE WHEN ISNULL(LSD.IsDataSyncedToday,0) <> 0 THEN 'YES' ELSE 'NO' END) AS isDataSyncedToday,\r\n\t\t\t\t\tCAST(LSD.MaxDBBackupDATE AS date)\t\tAS backupUploadDate,\r\n\t\t\t\t\tCAST(LSD.SalesLastSyncDate AS date)\t\tAS salesSyncDate,\r\n\t\t\t\t\tCAST(LSD.purchaseLastSyncDate AS date)\tAS purchaseSyncDate,\r\n\t\t\t\t\tCAST(LSD.salesReturnDate AS date)\t\tAS salesReturnDate,\r\n\t\t\t\t\tCAST(LSD.debitNoteDate AS date)\t\t\tAS debitNoteDate,\r\n\t\t\t\t\tCAST(LSD.creditNoteDate AS date)\t\tAS creditNoteDate,\r\n\t\t\t\t\tCAST(LSD.stockLastSync","method":"","class_name":"11","line_number":"0","time":"2025-01-01 19:37:09","error_code":"-2","procedure":"","server":"SERVER04","stack_trace":"at Ethics.HelperModules.DataContext.SqlDapperHelper.<SqlQueryToListAsync>d__17`1.MoveNext()\r\n--- End of stack trace from previous location where exception was thrown ---\r\n   at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()\r\n   at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)\r\n   at System.Runtime.CompilerServices.TaskAwaiter`1.GetResult()\r\n   at BPPI.CPOS.BAL.Common.CommonRepositories.<ExecuteReportData>d__20.MoveNext() in E:\\DPC15\\GIT Repository\\ZOTA\\CPOS_API\\ZOTA.CPOS.BAL\\Common\\CommonRepositories.cs:line 433\r\n--- End of stack trace from previous location where exception was thrown ---\r\n   at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()\r\n   at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)\r\n   at System.Runtime.CompilerServices.TaskAwaiter`1.GetResult()\r\n   at BPPI.CPOS.API.Controllers.CommonController.<GetReportConfiguration>d__3.MoveNext() in E:\\DPC15\\GIT Repository\\ZOTA\\CPOS_API\\ZOTA.CPOS.API\\Controllers\\CommonController.cs:line 72","priority":"medium","version_no":null,"app_version_no":null,"reccurence_count":1}
,