{"store_code":"","client_code":"","source":"","message":"Data Not Found. SyncId:15","method":"","class_name":"","line_number":"","time":"2024-12-30 09:17:48","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":"2024-12-30 10:17:38","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":"Execution Timeout Expired. The timeout period elapsed prior to completion of the operation or the server is not responding.\r\n\r\n\t\tSELECT\tCOUNT(1) OVER() AS TotalRecord,\t\t\r\n\t\t\t\tDoc_Type,\r\n\t\t\t\tDoc_ID,\r\n\t\t\t\tDOC_FullPath,\r\n\t\t\t\tStoreType,\r\n\t\t\t\tCategory,\r\n\t\t\t\tState,\r\n\t\t\t\tStoreNo,\r\n\t\t\t\tStore_Name,\r\n\t\t\t\tdoc_Cust_Code,\r\n\t\t\t\tCust_Name, \r\n\t\t\t\tDoc_No, \r\n\t\t\t\tDoc_Date, \r\n\t\t\t\tDocd_GrossTotal, \r\n\t\t\t\tTaxTotal, Total, \r\n\t\t\t\tDOC_Cgst_Amt,\r\n\t\t\t\tDOC_Sgst_Amt,\r\n\t\t\t\tDOC_Igst_Amt,\r\n\t\t\t\tDOC_Cess_Amt,\r\n\t\t\t\tSUM(Docd_GrossTotal) OVER() AS sumDOC_GrossTotal,\r\n\t\t\t\tSUM(TaxTotal) OVER() AS sumDOC_Total_Tax,\r\n\t\t\t\tSUM(Total) OVER() AS sumDOC_Totall, \r\n\t\t\t\tSUM(DOC_Cgst_Amt) OVER() AS sumDOC_Cgst_Amt,\r\n\t\t\t\tSUM(DOC_Sgst_Amt) OVER() AS sumDOC_Sgst_Amt, \r\n\t\t\t\tSUM(DOC_Igst_Amt) OVER() AS sumDOC_Igst_Amt,\r\n\t\t\t\tSUM(0) OVER() AS sumDOC_Cess_Amt,\r\n\t\t\t\tSUM(discAmount) OVER() AS sumDOC_DiscAmount,\r\n\t\t\t\tdiscAmount,\r\n\t\t\t\tactive,Isactive,\r\n\t\t\t\treturn_type,\r\n\t\t\t\treason,\r\n\t\t\t\tremark,\r\n\t\t\t\trefInvNo,\r\n\t\t\t\tsupSiNo,\r\n\t\t\t\tdOC_Disc\r\n\t\tFROM(SELECT\tDISTINCT\r\n\t\t\t\t\tANH.Doc_ID AS Doc_ID,\r\n\t\t\t\t\t(CASE WHEN ANH.Doc_Type = 0 THEN 'Sales Return' WHEN ANH.Doc_Type = 1 THEN 'Debit Note' WHEN ANH.Doc_Type = 2 THEN 'Credit Note' END) doc_Type,\r\n\t\t\t\t\tSD.StoreType\tAS storeType,\r\n\t\t\t\t\tSD.Category\t\tAS category, \r\n\t\t\t\t\tSD.State \t\tAS state, \r\n\t\t\t\t\tANH.Doc_Store_Code\t\tAS storeNo, \r\n\t\t\t\t\tISNULL(REPLACE(SD.store_Name,',',' / '),'') AS Store_Name,\r\n\t\t\t\t\tISNULL(CASE WHEN ANH.Doc_Type=0 OR ANH.Doc_Type=2 THEN CAST(ANH.DOC_PM_Id AS VARCHAR) ELSE ANH.DOC_Cust_Code END,'') AS doc_Cust_Code,\r\n\t\t\t\t\tISNULL(CASE WHEN ANH.Doc_Type=0 OR ANH.Doc_Type=2 THEN REPLACE(PMP.Pm_Fullname,',',' / ') ELSE REPLACE(SDC.Store_Name,',',' / ') END,'') AS Cust_Name,\r\n\t\t\t\t\t(CASE WHEN ISNULL(ANH.Doc_No_New,'') <> '' THEN ANH.Doc_No_New ELSE CAST(ANH.Doc_No AS VARCHAR) END) AS doc_No, \r\n\t\t\t\t\tANH.Doc_Date\t\tAS doc_Date, \r\n\t\t\t\t\tANH.DOC_GrossTotal\tAS docd_GrossTotal, \r\n\t\t\t\t\tANH.DOC_Total_Tax\tAS taxTotal, \r\n\t\t\t\t\tISNULL(ANH.DOC_Total,0)\tAS total,\r\n\t\t\t\t\t(CASE WHEN DOC_Total_Tax = 0 THEN (ANH.DOC_Total_Tax / 2) ELSE (CASE WHEN DOC_Cgst_Amt > 0 THEN (ANH.DOC_Total_Tax / 2) ELSE 0 END) END) AS DOC_Cgst_Amt, \r\n\t\t\t\t\t(CASE WHEN DOC_Total_Tax = 0 THEN (ANH.DOC_Total_Tax / 2) ELSE (CASE WHEN DOC_Cgst_Amt > 0 THEN (ANH.DOC_Total_Tax / 2) ELSE 0 END) END) AS DOC_Sgst_Amt, \r\n\t\t\t\t\t(CASE WHEN DOC_Total_Tax = 0 THEN 0 ELSE (CASE WHEN DOC_Cgst_Amt = 0 THEN ANH.DOC_Total_Tax ELSE 0 END) END) AS DOC_Igst_Amt, \r\n\t\t\t\t\t0 AS DOC_Cess_Amt, \r\n\t\t\t\t\tISNULL(DOC_DiscAmount,0) discAmount, \r\n\t\t\t\t\tCASE WHEN ISNULL(SD.IsActive,0) = 1 THEN 'Y' ELSE 'N' END AS active,\r\n\t\t\t\t\tISNULL(SD.IsActive,0) AS Isactive,\r\n\t\t\t\t\tANH.DOC_FullPath AS DOC_FullPath,\r\n\t\t\t\t\tISNULL(RPH.Typename,'') AS return_type,\r\n\t\t\t\t\tISNULL(DOC_Reason,'') AS reason,\r\n\t\t\t\t\tISNULL(DOC_Remark,'') AS remark,\r\n\t\t\t\t\t(CASE WHEN ANH.Doc_Type = 1 THEN (CASE WHEN ISNULL(pih.Pih_No_New,'') <> '' THEN pih.Pih_No_New ELSE CAST(pih.Pih_No AS VARCHAR) END) ELSE\r\n\t\t\t\t\t(CASE WHEN ISNULL(SIHP.Sih_No_New,'') <> '' THEN SIHP.Sih_No_New ELSE CAST(SIHP.Sih_No AS VARCHAR) END)END) AS refInvNo, \r\n\t\t\t\t\t--CASE WHEN ANH.Doc_Type = 1 THEN ISNULL(pih.Pih_RefNo,'') ELSE '' END AS supSiNo,\r\n\t\t\t\t\t/*---~~~ GID:897 Nidhi 2024-08-21~~~------*/\r\n\t\t\t\t\tCASE WHEN ANH.Doc_Type = 1 THEN\r\n\t\t\t\t\tCASE WHEN ISNULL(pih.pih_vendor_code,'')<>'HGJSUR0222' THEN ISNULL(pih.Pih_RefNo,'') ELSE SI.Sih_RefNo END\r\n\t\t\t\t\tELSE '' END AS supSiNo,\r\n\t\t\t\t\t/*---~~~ GID:897 ~~~------*/\r\n\t\t\t\t\tISNULL(DOC_Disc,0) as dOC_Disc\r\n\t\t\tFROM\tAccountNoteHeader (NOLOCK) ANH\r\n\t\t\t\tINNER JOIN Store_Detail (NOLOCK) SD \r\n\t\t\tON\t\tANH.Doc_Store_Code = SD.StoreNo \r\n\t\t\t\tAND ISNULL(SD.IsZotaStore,0) = 0 \r\n\t\t\t\tLEFT JOIN Store_Detail (NOLOCK) SDC \r\n\t\t\tON\t\t(ANH.DOC_Cust_Code = SDC.StoreNo\r\n\t\t\t\tAND\tANH.Doc_Type = 1)\r\n\t\t\t\tLEFT JOIN PatientMaster_POS (NOLOCK) PMP \r\n\t\t\tON\t\tANH.DOC_PM_Id = PMP.Pm_Id\r\n\t\t\t\tAND ANH.Doc_Store_Code = PMP.Store_Code\r\n\t\t\t\tAND(ANH.Doc_Type = 0 \r\n\t\t\t\t\tOR\tANH.Doc_Type = 2)\r\n\t\t\t\tLEFT JOIN ReturnPolicyHeader (NOLOCK) RPH\r\n\t\t\tON\t\tANH.DOC_ReturnPID = RPH.Id\r\n\t\t\t\tLEFT JOIN [dbo].[PurchaseInvoiceHeader_POS] (nolock) pih\r\n\t\t ON\t\tANH.doc_idockey = pih.pih_key\tAND ANH.doc_store_code = pih.pih_storecode AND AN","method":"","class_name":"11","line_number":"0","time":"2024-12-30 10:45:13","error_code":"-2","procedure":"","server":"SERVER04","stack_trace":"at Ethics.HelperModules.DataContext.SqlDapperHelper.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.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.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.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":"2024-12-30 10:45:17","error_code":"-2","procedure":"","server":"SERVER04","stack_trace":"at Ethics.HelperModules.DataContext.SqlDapperHelper.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.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.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.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":"2024-12-30 10:45:39","error_code":"-2","procedure":"","server":"SERVER04","stack_trace":"at Ethics.HelperModules.DataContext.SqlServerHelper.DbDataSet(String commandText, List`1 param, CommandType cmd)\r\n at Ethics.HelperModules.SyncLogic.SyncSqlDataClientRepository.prepareSyncDataToSend(Object id, String status)\r\n at Ethics.HelperModules.SyncLogic.SyncSqlDataClientRepository.GetCPOSSyncData(String storeCode)\r\n at ZOTA.CPOS.BAL.SyncServices.SyncRepositories.<>c__DisplayClass4_0.b__0() in E:\\DPC15\\GIT Repository\\ZOTA\\CPOS_API\\ZOTA.CPOS.BAL\\SyncServices\\SyncRepositories.cs:line 57\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.GetResult()\r\n at ZOTA.CPOS.BAL.SyncServices.SyncRepositories.d__4.MoveNext() in E:\\DPC15\\GIT Repository\\ZOTA\\CPOS_API\\ZOTA.CPOS.BAL\\SyncServices\\SyncRepositories.cs:line 51\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 ZOTA.CPOS.BAL.SyncServices.SyncRepositories.d__3.MoveNext() in E:\\DPC15\\GIT Repository\\ZOTA\\CPOS_API\\ZOTA.CPOS.BAL\\SyncServices\\SyncRepositories.cs:line 33\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.SyncController.d__10.MoveNext() in E:\\DPC15\\GIT Repository\\ZOTA\\CPOS_API\\ZOTA.CPOS.API\\Controllers\\SyncController.cs:line 224\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.SyncController.d__2.MoveNext() in E:\\DPC15\\GIT Repository\\ZOTA\\CPOS_API\\ZOTA.CPOS.API\\Controllers\\SyncController.cs:line 26","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":"2024-12-30 11:07:24","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.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":"2024-12-30 11:17:32","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":"2024-12-30 12:17:32","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":"2024-12-30 13:17:45","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":"2024-12-30 16:31:42","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.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":"2024-12-30 16:32:18","error_code":"","procedure":"","server":"","stack_trace":"","priority":"","version_no":null,"app_version_no":null,"reccurence_count":1} , {"store_code":"","client_code":"","source":"mscorlib","message":"Exception of type 'System.OutOfMemoryException' was thrown.","method":"","class_name":"","line_number":"","time":"2024-12-30 16:51:53","error_code":"","procedure":"","server":"","stack_trace":"at System.Threading.Thread.StartInternal(IPrincipal principal, StackCrawlMark& stackMark)\r\n at System.Threading.Thread.Start()\r\n at System.Data.ProviderBase.DbConnectionPool.TryGetConnection(DbConnection owningObject, TaskCompletionSource`1 retry, DbConnectionOptions userOptions, DbConnectionInternal& connection)\r\n at System.Data.ProviderBase.DbConnectionFactory.TryGetConnection(DbConnection owningConnection, TaskCompletionSource`1 retry, DbConnectionOptions userOptions, DbConnectionInternal oldConnection, DbConnectionInternal& connection)\r\n at System.Data.ProviderBase.DbConnectionInternal.TryOpenConnectionInternal(DbConnection outerConnection, DbConnectionFactory connectionFactory, TaskCompletionSource`1 retry, DbConnectionOptions userOptions)\r\n at System.Data.SqlClient.SqlConnection.TryOpenInner(TaskCompletionSource`1 retry)\r\n at System.Data.SqlClient.SqlConnection.TryOpen(TaskCompletionSource`1 retry)\r\n at System.Data.SqlClient.SqlConnection.OpenAsync(CancellationToken cancellationToken)\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.Data.Entity.SqlServer.DefaultSqlExecutionStrategy.<>c__DisplayClass4.<b__3>d__6.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.Data.Entity.SqlServer.DefaultSqlExecutionStrategy.d__9`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.Data.Entity.Core.EntityClient.EntityConnection.d__8.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.Data.Entity.Core.Objects.ObjectContext.d__9.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.Data.Entity.Core.Objects.ObjectContext.d__3d`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.Data.Entity.SqlServer.DefaultSqlExecutionStrategy.d__9`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.Data.Entity.Core.Objects.ObjectContext.d__6c`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.Data.Entity.Internal.LazyAsyncEnumerator`1.d__0.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.Data.Entity.Infrastructure.IDbAsyncEnumerableExtensions.d__5`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.Users.UserRepository.d__9.MoveNext() in E:\\DPC15\\GIT Repository\\ZOTA\\CPOS_API\\ZOTA.CPOS.BAL\\Users\\UserRepository.cs:line 409","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":"2024-12-30 17:29:06","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.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":"2024-12-30 17:32:43","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":"2024-12-30 18:15:25","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.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":"2024-12-30 18:32: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":"2024-12-30 18:52:55","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.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":"2024-12-30 18:53:30","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.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":"System.Core","message":"Value cannot be null.\r\nParameter name: source","method":"","class_name":"","line_number":"","time":"2024-12-30 19:02:24","error_code":"","procedure":"","server":"","stack_trace":"at System.Linq.Enumerable.Select[TSource,TResult](IEnumerable`1 source, Func`2 selector)\r\n at BPPI.CPOS.BAL.Users.UserRepository.d__3.MoveNext() in E:\\DPC15\\GIT Repository\\ZOTA\\CPOS_API\\ZOTA.CPOS.BAL\\Users\\UserRepository.cs:line 282","priority":"medium","version_no":null,"app_version_no":null,"reccurence_count":1} , {"store_code":"","client_code":"","source":".Net SqlClient Data Provider","message":"@UserId is not a parameter for procedure USP_GetSchemeRequstReport.","method":"","class_name":"16","line_number":"0","time":"2024-12-30 19:21:45","error_code":"8145","procedure":"USP_GetSchemeRequstReport","server":"SERVER04","stack_trace":"at Ethics.HelperModules.DataContext.SqlDapperHelper.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.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.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} ,