{"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-09-10 09:31:05","error_code":"208","procedure":"SP_VALIDATE_API_KEY","server":"192.168.0.245,1546","stack_trace":"at BPPI.CPOS.DAL.APIHelper.ValidateAPIKey(Int32 APIId, String APIKey) in E:\\GitProjects\\Zota CPOS\\CPOS_WEB_API_dev\\ZOTA.CPOS.DAL\\SqlHelperDbSalesData.cs:line 183\r\n   at BPPI.CPOS.API.Controllers.StoreController.<GetStoreStatus>d__40.MoveNext() in E:\\GitProjects\\Zota CPOS\\CPOS_WEB_API_dev\\ZOTA.CPOS.API\\Controllers\\StoreController.cs:line 798","priority":"medium","version_no":null,"app_version_no":null,"reccurence_count":1}
,
{"store_code":"","client_code":"","source":".Net SqlClient Data Provider","message":"Error converting data type nvarchar to numeric.","method":"","class_name":"16","line_number":"35","time":"2025-09-10 09:31:58","error_code":"8114","procedure":"Sync_StockRegister_XML","server":"192.168.0.245,1546","stack_trace":"at Ethics.HelperModules.DataContext.SqlDapperHelper.<ExecuteScalarQueryAsync>d__18`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 ZOTA.CPOS.BAL.SyncServices.SyncRepositories.<ProcessPosToCpos>d__5.MoveNext() in E:\\GitProjects\\Zota CPOS\\CPOS_WEB_API_dev\\ZOTA.CPOS.BAL\\SyncServices\\SyncRepositories.cs:line 74\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.<ProcessSyncData>d__3.MoveNext() in E:\\GitProjects\\Zota CPOS\\CPOS_WEB_API_dev\\ZOTA.CPOS.BAL\\SyncServices\\SyncRepositories.cs:line 37\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.<SyncProcess>d__10.MoveNext() in E:\\GitProjects\\Zota CPOS\\CPOS_WEB_API_dev\\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.<SyncPOS>d__2.MoveNext() in E:\\GitProjects\\Zota CPOS\\CPOS_WEB_API_dev\\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":"","message":"Data Not Found. SyncId:15","method":"","class_name":"","line_number":"","time":"2025-09-10 09:31:59","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-09-10 09:38:30","error_code":"208","procedure":"SP_VALIDATE_API_KEY","server":"192.168.0.245,1546","stack_trace":"at BPPI.CPOS.DAL.APIHelper.ValidateAPIKey(Int32 APIId, String APIKey) in E:\\GitProjects\\Zota CPOS\\CPOS_WEB_API_dev\\ZOTA.CPOS.DAL\\SqlHelperDbSalesData.cs:line 183\r\n   at BPPI.CPOS.API.Controllers.StoreController.<GetStoreStatus>d__40.MoveNext() in E:\\GitProjects\\Zota CPOS\\CPOS_WEB_API_dev\\ZOTA.CPOS.API\\Controllers\\StoreController.cs:line 798","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-09-10 09:41:17","error_code":"208","procedure":"SP_VALIDATE_API_KEY","server":"192.168.0.245,1546","stack_trace":"at BPPI.CPOS.DAL.APIHelper.ValidateAPIKey(Int32 APIId, String APIKey) in E:\\GitProjects\\Zota CPOS\\CPOS_WEB_API_dev\\ZOTA.CPOS.DAL\\SqlHelperDbSalesData.cs:line 183\r\n   at BPPI.CPOS.API.Controllers.StoreController.<GetStoreStatus>d__40.MoveNext() in E:\\GitProjects\\Zota CPOS\\CPOS_WEB_API_dev\\ZOTA.CPOS.API\\Controllers\\StoreController.cs:line 798","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-09-10 09:41:51","error_code":"208","procedure":"SP_VALIDATE_API_KEY","server":"192.168.0.245,1546","stack_trace":"at BPPI.CPOS.DAL.APIHelper.ValidateAPIKey(Int32 APIId, String APIKey) in E:\\GitProjects\\Zota CPOS\\CPOS_WEB_API_dev\\ZOTA.CPOS.DAL\\SqlHelperDbSalesData.cs:line 183\r\n   at BPPI.CPOS.API.Controllers.StoreController.<GetStoreStatus>d__40.MoveNext() in E:\\GitProjects\\Zota CPOS\\CPOS_WEB_API_dev\\ZOTA.CPOS.API\\Controllers\\StoreController.cs:line 798","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-09-10 09:43:04","error_code":"","procedure":"","server":"","stack_trace":"","priority":"","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-09-10 10:22:42","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:\\GitProjects\\Zota CPOS\\CPOS_WEB_API_dev\\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:\\GitProjects\\Zota CPOS\\CPOS_WEB_API_dev\\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-09-10 10:22:50","error_code":"208","procedure":"SP_VALIDATE_API_KEY","server":"192.168.0.245,1546","stack_trace":"at BPPI.CPOS.DAL.APIHelper.ValidateAPIKey(Int32 APIId, String APIKey) in E:\\GitProjects\\Zota CPOS\\CPOS_WEB_API_dev\\ZOTA.CPOS.DAL\\SqlHelperDbSalesData.cs:line 183\r\n   at BPPI.CPOS.API.Controllers.StoreController.<GetStoreStatus>d__40.MoveNext() in E:\\GitProjects\\Zota CPOS\\CPOS_WEB_API_dev\\ZOTA.CPOS.API\\Controllers\\StoreController.cs:line 798","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-09-10 10:24:20","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:\\GitProjects\\Zota CPOS\\CPOS_WEB_API_dev\\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:\\GitProjects\\Zota CPOS\\CPOS_WEB_API_dev\\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":"","message":"Data Not Found. SyncId:40","method":"","class_name":"","line_number":"","time":"2025-09-10 10:26:30","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":"Ambiguous column name 'Sih_Store_Code'.\r\nInvalid object name '##TEMP_PO_DATA_1'.\r\n\r\n\t-----~~~~ START  Nishita 08-07-2025\r\n\t;WITH ErrorStatus AS (SELECT \r\n\t\tPo_Id,\r\n\t\tMAX(CONCAT('Retry Count= ',RetryCount,' , ','Error Message= ', ErrorMsg)) AS [Status] \r\n\t\tFROM PoErrorLog\r\n\t\tGROUP BY Po_Id)\r\n\t------~~~ END \r\n\t\tSELECT\tPH.PO_Store_Code AS po_Store_Code,\r\n\t\t\t\tCOUNT(*) AS itemCount,\r\n\t\t\t\t/*~~~~~~~ Nidhi 21/06/2024 GID:837 ~~~~~ */\r\n\t\t\t\tSD.category,\r\n\t\t\t\t/*~~~~~~~ GID:837 ~~~~~ */\r\n\t\t\t\tSD.Store_Name,\r\n\t\t\t\tSD.State AS state,\r\n\t\t\t\t/* GID: #1301\r\n\t\t\t\tDeveloper: Nishita Roy\r\n\t\t\t\tSummary\t : US: CPOS: Display Full Document Number Format in CPOS Reports\r\n\t\t\t\tDate     : 22-08-2025*/\r\n\t\t\t\t--PH.PO_NO  AS po_No,\r\n\t\t\t\tPO_No_new AS po_No,\r\n\t\t\t\t/* GID: #1301 END */\r\n\t\t\t    CAST(PH.Po_No AS VARCHAR(25)) + '_' + ISNULL(CAST(PH.warehouseId AS VARCHAR(25)),1) AS po_No_Split,----~~~ Gid :#1156 Nidhi 04-04-2025\r\n\t\t\t\t--FORMAT(PH.PO_Date,'dd/MM/yyyy') AS po_Date,\r\n\t\t\t\t--ISNULL(CASE WHEN CAST(Po_UpdatedDt AS DATE) = '1900/01/01' THEN NULL ELSE FORMAT(CAST(Po_UpdatedDt AS DATE),'dd/MM/yyyy') END, FORMAT(CAST(Po_CreatedDt AS DATE),'dd/MM/yyyy')) AS approveDate,\r\n\t\t\t\t--ISNULL(CAST(Po_UpdatedDt AS DATE), CAST(Po_CreatedDt AS DATE)) AS approveDate,\r\n\t\t\t\t--ISNULL(CASE WHEN YEAR(Po_UpdatedDt) = 1900 THEN NULL ELSE CAST(Po_UpdatedDt AS DATE) END, CAST(Po_CreatedDt AS DATE)) AS approveDate,\r\n\t\t\t\t--FORMAT(PH.Po_SyncDate,'dd/MM/yyyy') Po_SyncDate,\r\n\t\t\t\t--PH.Po_SyncDate Po_SyncDate,\r\n\t\t\t\t--CASE WHEN ISNULL(CAST(Po_UpdatedDt AS DATE), CAST(Po_CreatedDt AS DATE)) > CAST(PH.Po_SyncDate AS date) THEN ISNULL(CAST(Po_UpdatedDt AS DATE), CAST(Po_CreatedDt AS DATE)) ELSE CAST(PH.Po_SyncDate AS date) END Po_SyncDate,\r\n\t\t\t\tPH.PO_Date AS po_Date,\r\n\t\t\t\t-----~~~~~~~ Start #711 Nidhi 09/04/2024  ~~~~~~~----\r\n\t\t\t\t--DateOfApprovedOrReject AS approveDate,\t\t\t\r\n\t\t\t\t CONVERT(VARCHAR(30), PH.DateOfApprovedOrReject , 120) as DateOfApprovedOrReject,\t\t\t\r\n\t\t\t -- CASE WHEN CAST(DateOfApprovedOrReject AS date) > CAST(PH.Po_SyncDate AS date) THEN CAST(DateOfApprovedOrReject AS date) ELSE CAST(PH.Po_SyncDate AS date) END Po_SyncDate,\r\n\t\t\t\tCASE WHEN CAST(PH.DateOfApprovedOrReject AS date) > CAST(PH.Po_SyncDate AS date) THEN CONVERT(VARCHAR(30), PH.DateOfApprovedOrReject , 120)   ELSE CONVERT(VARCHAR(30), PH.Po_SyncDate , 120)  END Po_SyncDate,\r\n\t\t\t\t-----~~~~~~~ End #711 Nidhi 09/04/2024  ~~~~~~~----\r\n\t\t\t\tISNULL(PH.Po_TotVal,0) AS TotalAmount,\r\n\t\t\t\tISNULL(G.CreditLimit,0) AS CreditLimit,\r\n\t\t\t\tISNULL(G.Pod_Amount,0) AS OutstandingAmount,\r\n\t\t\t\t--ISNULL(PH.StatusMarkAs,0) AS statusMarkAs,\r\n\t\t\t  --\tCASE WHEN ISNULL(PH.statusMarkAs,0) = 0 THEN 'unApproved' WHEN ISNULL(PH.statusMarkAs,0) = 1 THEN 'approved' WHEN ISNULL(PH.statusMarkAs,0) = 2 THEN 'rejected' WHEN ISNULL(PH.statusMarkAs,0) = 3 THEN 'dispatched' WHEN ISNULL(PH.statusMarkAs,0) = 4 THEN 'hold' END statusMarkAs,\r\n\t\t\t\t ISNULL(ST.Status,'') AS statusMarkAs, ----- Gid :#14 Nidhi 30-05-2025\r\n\t\t\t\t--FORMAT(CAST(ISNULL(PH.Po_CreatedDt,PH.Po_UpdatedDt) AS DATE),'dd/MM/yyyy') AS dateOfApprovedOrReject,\r\n\t\t\t\t--CAST(ISNULL(PH.Po_CreatedDt,PH.Po_UpdatedDt) AS DATE) AS dateOfApprovedOrReject,\r\n\t\t\t\t-----~~~~~~~ Start #711 Nidhi 09/04/2024  ~~~~~~~-\r\n\t\t\t\t--CAST(DateOfApprovedOrReject AS date) AS dateOfApprovedOrReject,\r\n\t\t\t\tCAST(PH.DateOfApprovedOrReject AS date) AS dateOfApprovedOrRejectupdate,\r\n\t\t\t\t-----~~~~~~~ End #711 Nidhi 09/04/2024  ~~~~~~~-\r\n\t\t\t\tPH.Po_Sales_Order_No,\r\n\t\t\t\tsd.store_Contact_Person,\r\n\t\t\t\tsd.Mobile_No,\r\n\t\t\t\tSD.email_ID,\r\n\t\t\t\tISNULL(PH.Remark,'') AS Remark,\r\n\t\t\t\t(D.FirstName + ' ' + ISNULL(D.LastName,'')) AS ApprovedBy,\r\n\t\t\t\t--CASE WHEN PH.Po_VendorCode = 'HGJSUR0222' THEN ISNULL(SIHH.Sih_No,0) ELSE ISNULL(SIH.Sih_No,0) END AS sih_No,\r\n\t\t\t\t--CASE WHEN PH.Po_VendorCode = 'HGJSUR0222' THEN ISNULL(SIHH.Sih_refNo,0) ELSE\r\n\t\t\t\tCASE WHEN PH.Po_VendorCode = dbo.fn_GetVendorCodeByStore(Sih_Store_Code) THEN ISNULL(SIHH.Sih_refNo,0) ELSE\r\n\t\t\t\tCASE WHEN ISNULL(SIH.Sih_No_New, '') <> '' THEN SIH.Sih_No_New\r\n\t\t\t\t\t WHEN ISNULL(SIH.Sih_No_New, '') = '' THEN CAST(ISNULL(SIH.Sih_No,0) AS VARCHAR)END \r\n\t\t\t\tEND AS sih_No,---- Nidhi 14-0\r\nSELECT *, TotalRecord = COUNT(1) OVER(), SumTotalAmount = CAST(SUM(TotalAmount) OVER() AS DECIMAL)\r\n\t\tFROM ##TEMP_PO_DATA_1 ORDER BY PO_Store_Code\r\n\t\tOFFSET @PageSize * (@PageNumber - 1) ROWS\r\n\t\tFETCH NEXT @PageSize ROWS ONLY;","method":"","class_name":"16","line_number":"80","time":"2025-09-10 10:41:02","error_code":"209","procedure":"","server":"192.168.0.245,1546","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:\\GitProjects\\Zota CPOS\\CPOS_WEB_API_dev\\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:\\GitProjects\\Zota CPOS\\CPOS_WEB_API_dev\\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":"Ambiguous column name 'Sih_Store_Code'.\r\nInvalid object name '##TEMP_PO_DATA_1'.\r\n\r\n\t-----~~~~ START  Nishita 08-07-2025\r\n\t;WITH ErrorStatus AS (SELECT \r\n\t\tPo_Id,\r\n\t\tMAX(CONCAT('Retry Count= ',RetryCount,' , ','Error Message= ', ErrorMsg)) AS [Status] \r\n\t\tFROM PoErrorLog\r\n\t\tGROUP BY Po_Id)\r\n\t------~~~ END \r\n\t\tSELECT\tPH.PO_Store_Code AS po_Store_Code,\r\n\t\t\t\tCOUNT(*) AS itemCount,\r\n\t\t\t\t/*~~~~~~~ Nidhi 21/06/2024 GID:837 ~~~~~ */\r\n\t\t\t\tSD.category,\r\n\t\t\t\t/*~~~~~~~ GID:837 ~~~~~ */\r\n\t\t\t\tSD.Store_Name,\r\n\t\t\t\tSD.State AS state,\r\n\t\t\t\t/* GID: #1301\r\n\t\t\t\tDeveloper: Nishita Roy\r\n\t\t\t\tSummary\t : US: CPOS: Display Full Document Number Format in CPOS Reports\r\n\t\t\t\tDate     : 22-08-2025*/\r\n\t\t\t\t--PH.PO_NO  AS po_No,\r\n\t\t\t\tPO_No_new AS po_No,\r\n\t\t\t\t/* GID: #1301 END */\r\n\t\t\t    CAST(PH.Po_No AS VARCHAR(25)) + '_' + ISNULL(CAST(PH.warehouseId AS VARCHAR(25)),1) AS po_No_Split,----~~~ Gid :#1156 Nidhi 04-04-2025\r\n\t\t\t\t--FORMAT(PH.PO_Date,'dd/MM/yyyy') AS po_Date,\r\n\t\t\t\t--ISNULL(CASE WHEN CAST(Po_UpdatedDt AS DATE) = '1900/01/01' THEN NULL ELSE FORMAT(CAST(Po_UpdatedDt AS DATE),'dd/MM/yyyy') END, FORMAT(CAST(Po_CreatedDt AS DATE),'dd/MM/yyyy')) AS approveDate,\r\n\t\t\t\t--ISNULL(CAST(Po_UpdatedDt AS DATE), CAST(Po_CreatedDt AS DATE)) AS approveDate,\r\n\t\t\t\t--ISNULL(CASE WHEN YEAR(Po_UpdatedDt) = 1900 THEN NULL ELSE CAST(Po_UpdatedDt AS DATE) END, CAST(Po_CreatedDt AS DATE)) AS approveDate,\r\n\t\t\t\t--FORMAT(PH.Po_SyncDate,'dd/MM/yyyy') Po_SyncDate,\r\n\t\t\t\t--PH.Po_SyncDate Po_SyncDate,\r\n\t\t\t\t--CASE WHEN ISNULL(CAST(Po_UpdatedDt AS DATE), CAST(Po_CreatedDt AS DATE)) > CAST(PH.Po_SyncDate AS date) THEN ISNULL(CAST(Po_UpdatedDt AS DATE), CAST(Po_CreatedDt AS DATE)) ELSE CAST(PH.Po_SyncDate AS date) END Po_SyncDate,\r\n\t\t\t\tPH.PO_Date AS po_Date,\r\n\t\t\t\t-----~~~~~~~ Start #711 Nidhi 09/04/2024  ~~~~~~~----\r\n\t\t\t\t--DateOfApprovedOrReject AS approveDate,\t\t\t\r\n\t\t\t\t CONVERT(VARCHAR(30), PH.DateOfApprovedOrReject , 120) as DateOfApprovedOrReject,\t\t\t\r\n\t\t\t -- CASE WHEN CAST(DateOfApprovedOrReject AS date) > CAST(PH.Po_SyncDate AS date) THEN CAST(DateOfApprovedOrReject AS date) ELSE CAST(PH.Po_SyncDate AS date) END Po_SyncDate,\r\n\t\t\t\tCASE WHEN CAST(PH.DateOfApprovedOrReject AS date) > CAST(PH.Po_SyncDate AS date) THEN CONVERT(VARCHAR(30), PH.DateOfApprovedOrReject , 120)   ELSE CONVERT(VARCHAR(30), PH.Po_SyncDate , 120)  END Po_SyncDate,\r\n\t\t\t\t-----~~~~~~~ End #711 Nidhi 09/04/2024  ~~~~~~~----\r\n\t\t\t\tISNULL(PH.Po_TotVal,0) AS TotalAmount,\r\n\t\t\t\tISNULL(G.CreditLimit,0) AS CreditLimit,\r\n\t\t\t\tISNULL(G.Pod_Amount,0) AS OutstandingAmount,\r\n\t\t\t\t--ISNULL(PH.StatusMarkAs,0) AS statusMarkAs,\r\n\t\t\t  --\tCASE WHEN ISNULL(PH.statusMarkAs,0) = 0 THEN 'unApproved' WHEN ISNULL(PH.statusMarkAs,0) = 1 THEN 'approved' WHEN ISNULL(PH.statusMarkAs,0) = 2 THEN 'rejected' WHEN ISNULL(PH.statusMarkAs,0) = 3 THEN 'dispatched' WHEN ISNULL(PH.statusMarkAs,0) = 4 THEN 'hold' END statusMarkAs,\r\n\t\t\t\t ISNULL(ST.Status,'') AS statusMarkAs, ----- Gid :#14 Nidhi 30-05-2025\r\n\t\t\t\t--FORMAT(CAST(ISNULL(PH.Po_CreatedDt,PH.Po_UpdatedDt) AS DATE),'dd/MM/yyyy') AS dateOfApprovedOrReject,\r\n\t\t\t\t--CAST(ISNULL(PH.Po_CreatedDt,PH.Po_UpdatedDt) AS DATE) AS dateOfApprovedOrReject,\r\n\t\t\t\t-----~~~~~~~ Start #711 Nidhi 09/04/2024  ~~~~~~~-\r\n\t\t\t\t--CAST(DateOfApprovedOrReject AS date) AS dateOfApprovedOrReject,\r\n\t\t\t\tCAST(PH.DateOfApprovedOrReject AS date) AS dateOfApprovedOrRejectupdate,\r\n\t\t\t\t-----~~~~~~~ End #711 Nidhi 09/04/2024  ~~~~~~~-\r\n\t\t\t\tPH.Po_Sales_Order_No,\r\n\t\t\t\tsd.store_Contact_Person,\r\n\t\t\t\tsd.Mobile_No,\r\n\t\t\t\tSD.email_ID,\r\n\t\t\t\tISNULL(PH.Remark,'') AS Remark,\r\n\t\t\t\t(D.FirstName + ' ' + ISNULL(D.LastName,'')) AS ApprovedBy,\r\n\t\t\t\t--CASE WHEN PH.Po_VendorCode = 'HGJSUR0222' THEN ISNULL(SIHH.Sih_No,0) ELSE ISNULL(SIH.Sih_No,0) END AS sih_No,\r\n\t\t\t\t--CASE WHEN PH.Po_VendorCode = 'HGJSUR0222' THEN ISNULL(SIHH.Sih_refNo,0) ELSE\r\n\t\t\t\tCASE WHEN PH.Po_VendorCode = dbo.fn_GetVendorCodeByStore(Sih_Store_Code) THEN ISNULL(SIHH.Sih_refNo,0) ELSE\r\n\t\t\t\tCASE WHEN ISNULL(SIH.Sih_No_New, '') <> '' THEN SIH.Sih_No_New\r\n\t\t\t\t\t WHEN ISNULL(SIH.Sih_No_New, '') = '' THEN CAST(ISNULL(SIH.Sih_No,0) AS VARCHAR)END \r\n\t\t\t\tEND AS sih_No,---- Nidhi 14-0\r\nSELECT *, TotalRecord = COUNT(1) OVER(), SumTotalAmount = CAST(SUM(TotalAmount) OVER() AS DECIMAL)\r\n\t\tFROM ##TEMP_PO_DATA_1 ORDER BY PO_Store_Code\r\n\t\tOFFSET @PageSize * (@PageNumber - 1) ROWS\r\n\t\tFETCH NEXT @PageSize ROWS ONLY;","method":"","class_name":"16","line_number":"80","time":"2025-09-10 10:41:12","error_code":"209","procedure":"","server":"192.168.0.245,1546","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:\\GitProjects\\Zota CPOS\\CPOS_WEB_API_dev\\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:\\GitProjects\\Zota CPOS\\CPOS_WEB_API_dev\\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":"Invalid object name 'cPOS_SALES_DATA..ApiConfiguration'.","method":"","class_name":"16","line_number":"9","time":"2025-09-10 10:59:49","error_code":"208","procedure":"SP_VALIDATE_API_KEY","server":"192.168.0.245,1546","stack_trace":"at BPPI.CPOS.DAL.APIHelper.ValidateAPIKey(Int32 APIId, String APIKey) in E:\\GitProjects\\Zota CPOS\\CPOS_WEB_API_dev\\ZOTA.CPOS.DAL\\SqlHelperDbSalesData.cs:line 183\r\n   at BPPI.CPOS.API.Controllers.StoreController.<GetStoreStatus>d__40.MoveNext() in E:\\GitProjects\\Zota CPOS\\CPOS_WEB_API_dev\\ZOTA.CPOS.API\\Controllers\\StoreController.cs:line 798","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-09-10 11:00:36","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-09-10 11:01:42","error_code":"208","procedure":"SP_VALIDATE_API_KEY","server":"192.168.0.245,1546","stack_trace":"at BPPI.CPOS.DAL.APIHelper.ValidateAPIKey(Int32 APIId, String APIKey) in E:\\GitProjects\\Zota CPOS\\CPOS_WEB_API_dev\\ZOTA.CPOS.DAL\\SqlHelperDbSalesData.cs:line 183\r\n   at BPPI.CPOS.API.Controllers.StoreController.<GetStoreStatus>d__40.MoveNext() in E:\\GitProjects\\Zota CPOS\\CPOS_WEB_API_dev\\ZOTA.CPOS.API\\Controllers\\StoreController.cs:line 798","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-09-10 11:01: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-09-10 11:02:46","error_code":"208","procedure":"SP_VALIDATE_API_KEY","server":"192.168.0.245,1546","stack_trace":"at BPPI.CPOS.DAL.APIHelper.ValidateAPIKey(Int32 APIId, String APIKey) in E:\\GitProjects\\Zota CPOS\\CPOS_WEB_API_dev\\ZOTA.CPOS.DAL\\SqlHelperDbSalesData.cs:line 183\r\n   at BPPI.CPOS.API.Controllers.StoreController.<GetStoreStatus>d__40.MoveNext() in E:\\GitProjects\\Zota CPOS\\CPOS_WEB_API_dev\\ZOTA.CPOS.API\\Controllers\\StoreController.cs:line 798","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-09-10 11:14:11","error_code":"208","procedure":"SP_VALIDATE_API_KEY","server":"192.168.0.245,1546","stack_trace":"at BPPI.CPOS.DAL.APIHelper.ValidateAPIKey(Int32 APIId, String APIKey) in E:\\GitProjects\\Zota CPOS\\CPOS_WEB_API_dev\\ZOTA.CPOS.DAL\\SqlHelperDbSalesData.cs:line 183\r\n   at BPPI.CPOS.API.Controllers.StoreController.<GetStoreStatus>d__40.MoveNext() in E:\\GitProjects\\Zota CPOS\\CPOS_WEB_API_dev\\ZOTA.CPOS.API\\Controllers\\StoreController.cs:line 798","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-09-10 11:53:27","error_code":"208","procedure":"SP_VALIDATE_API_KEY","server":"192.168.0.245,1546","stack_trace":"at BPPI.CPOS.DAL.APIHelper.ValidateAPIKey(Int32 APIId, String APIKey) in E:\\GitProjects\\Zota CPOS\\CPOS_WEB_API_dev\\ZOTA.CPOS.DAL\\SqlHelperDbSalesData.cs:line 183\r\n   at BPPI.CPOS.API.Controllers.StoreController.<GetStoreStatus>d__40.MoveNext() in E:\\GitProjects\\Zota CPOS\\CPOS_WEB_API_dev\\ZOTA.CPOS.API\\Controllers\\StoreController.cs:line 798","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-09-10 12:01:32","error_code":"","procedure":"","server":"","stack_trace":"","priority":"","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-09-10 12:08:41","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:\\GitProjects\\Zota CPOS\\CPOS_WEB_API_dev\\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:\\GitProjects\\Zota CPOS\\CPOS_WEB_API_dev\\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":"","message":"Data Not Found. SyncId:40","method":"","class_name":"","line_number":"","time":"2025-09-10 13:26:38","error_code":"","procedure":"","server":"","stack_trace":"","priority":"","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-09-10 13:46:00","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:\\GitProjects\\Zota CPOS\\CPOS_WEB_API_dev\\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:\\GitProjects\\Zota CPOS\\CPOS_WEB_API_dev\\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-09-10 14:07:31","error_code":"208","procedure":"SP_VALIDATE_API_KEY","server":"192.168.0.245,1546","stack_trace":"at BPPI.CPOS.DAL.APIHelper.ValidateAPIKey(Int32 APIId, String APIKey) in E:\\GitProjects\\Zota CPOS\\CPOS_WEB_API_dev\\ZOTA.CPOS.DAL\\SqlHelperDbSalesData.cs:line 183\r\n   at BPPI.CPOS.API.Controllers.StoreController.<GetStoreStatus>d__40.MoveNext() in E:\\GitProjects\\Zota CPOS\\CPOS_WEB_API_dev\\ZOTA.CPOS.API\\Controllers\\StoreController.cs:line 798","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-09-10 14:20:54","error_code":"208","procedure":"SP_VALIDATE_API_KEY","server":"192.168.0.245,1546","stack_trace":"at BPPI.CPOS.DAL.APIHelper.ValidateAPIKey(Int32 APIId, String APIKey) in E:\\GitProjects\\Zota CPOS\\CPOS_WEB_API_dev\\ZOTA.CPOS.DAL\\SqlHelperDbSalesData.cs:line 183\r\n   at BPPI.CPOS.API.Controllers.StoreController.<GetStoreStatus>d__40.MoveNext() in E:\\GitProjects\\Zota CPOS\\CPOS_WEB_API_dev\\ZOTA.CPOS.API\\Controllers\\StoreController.cs:line 798","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-09-10 14:21:11","error_code":"208","procedure":"SP_VALIDATE_API_KEY","server":"192.168.0.245,1546","stack_trace":"at BPPI.CPOS.DAL.APIHelper.ValidateAPIKey(Int32 APIId, String APIKey) in E:\\GitProjects\\Zota CPOS\\CPOS_WEB_API_dev\\ZOTA.CPOS.DAL\\SqlHelperDbSalesData.cs:line 183\r\n   at BPPI.CPOS.API.Controllers.StoreController.<GetStoreStatus>d__40.MoveNext() in E:\\GitProjects\\Zota CPOS\\CPOS_WEB_API_dev\\ZOTA.CPOS.API\\Controllers\\StoreController.cs:line 798","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-09-10 14:29:35","error_code":"208","procedure":"SP_VALIDATE_API_KEY","server":"192.168.0.245,1546","stack_trace":"at BPPI.CPOS.DAL.APIHelper.ValidateAPIKey(Int32 APIId, String APIKey) in E:\\GitProjects\\Zota CPOS\\CPOS_WEB_API_dev\\ZOTA.CPOS.DAL\\SqlHelperDbSalesData.cs:line 183\r\n   at BPPI.CPOS.API.Controllers.StoreController.<GetStoreStatus>d__40.MoveNext() in E:\\GitProjects\\Zota CPOS\\CPOS_WEB_API_dev\\ZOTA.CPOS.API\\Controllers\\StoreController.cs:line 798","priority":"medium","version_no":null,"app_version_no":null,"reccurence_count":1}
,
{"store_code":"","client_code":"","source":".Net SqlClient Data Provider","message":"Error converting data type nvarchar to numeric.","method":"","class_name":"16","line_number":"35","time":"2025-09-10 14:30:33","error_code":"8114","procedure":"Sync_StockRegister_XML","server":"192.168.0.245,1546","stack_trace":"at Ethics.HelperModules.DataContext.SqlDapperHelper.<ExecuteScalarQueryAsync>d__18`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 ZOTA.CPOS.BAL.SyncServices.SyncRepositories.<ProcessPosToCpos>d__5.MoveNext() in E:\\GitProjects\\Zota CPOS\\CPOS_WEB_API_dev\\ZOTA.CPOS.BAL\\SyncServices\\SyncRepositories.cs:line 74\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.<ProcessSyncData>d__3.MoveNext() in E:\\GitProjects\\Zota CPOS\\CPOS_WEB_API_dev\\ZOTA.CPOS.BAL\\SyncServices\\SyncRepositories.cs:line 37\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.<SyncProcess>d__10.MoveNext() in E:\\GitProjects\\Zota CPOS\\CPOS_WEB_API_dev\\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.<SyncPOS>d__2.MoveNext() in E:\\GitProjects\\Zota CPOS\\CPOS_WEB_API_dev\\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":"","message":"Data Not Found. SyncId:15","method":"","class_name":"","line_number":"","time":"2025-09-10 14:30:33","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-09-10 15:22:55","error_code":"208","procedure":"SP_VALIDATE_API_KEY","server":"192.168.0.245,1546","stack_trace":"at BPPI.CPOS.DAL.APIHelper.ValidateAPIKey(Int32 APIId, String APIKey) in E:\\GitProjects\\Zota CPOS\\CPOS_WEB_API_dev\\ZOTA.CPOS.DAL\\SqlHelperDbSalesData.cs:line 183\r\n   at BPPI.CPOS.API.Controllers.StoreController.<GetStoreStatus>d__40.MoveNext() in E:\\GitProjects\\Zota CPOS\\CPOS_WEB_API_dev\\ZOTA.CPOS.API\\Controllers\\StoreController.cs:line 798","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-09-10 15:30: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":"Invalid object name 'cPOS_SALES_DATA..ApiConfiguration'.","method":"","class_name":"16","line_number":"9","time":"2025-09-10 15:40:47","error_code":"208","procedure":"SP_VALIDATE_API_KEY","server":"192.168.0.245,1546","stack_trace":"at BPPI.CPOS.DAL.APIHelper.ValidateAPIKey(Int32 APIId, String APIKey) in E:\\GitProjects\\Zota CPOS\\CPOS_WEB_API_dev\\ZOTA.CPOS.DAL\\SqlHelperDbSalesData.cs:line 183\r\n   at BPPI.CPOS.API.Controllers.StoreController.<GetStoreStatus>d__40.MoveNext() in E:\\GitProjects\\Zota CPOS\\CPOS_WEB_API_dev\\ZOTA.CPOS.API\\Controllers\\StoreController.cs:line 798","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-09-10 16:12:59","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:\\GitProjects\\Zota CPOS\\CPOS_WEB_API_dev\\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:\\GitProjects\\Zota CPOS\\CPOS_WEB_API_dev\\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":"Error converting data type nvarchar to numeric.","method":"","class_name":"16","line_number":"35","time":"2025-09-10 16:30:39","error_code":"8114","procedure":"Sync_StockRegister_XML","server":"192.168.0.245,1546","stack_trace":"at Ethics.HelperModules.DataContext.SqlDapperHelper.<ExecuteScalarQueryAsync>d__18`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 ZOTA.CPOS.BAL.SyncServices.SyncRepositories.<ProcessPosToCpos>d__5.MoveNext() in E:\\GitProjects\\Zota CPOS\\CPOS_WEB_API_dev\\ZOTA.CPOS.BAL\\SyncServices\\SyncRepositories.cs:line 74\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.<ProcessSyncData>d__3.MoveNext() in E:\\GitProjects\\Zota CPOS\\CPOS_WEB_API_dev\\ZOTA.CPOS.BAL\\SyncServices\\SyncRepositories.cs:line 37\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.<SyncProcess>d__10.MoveNext() in E:\\GitProjects\\Zota CPOS\\CPOS_WEB_API_dev\\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.<SyncPOS>d__2.MoveNext() in E:\\GitProjects\\Zota CPOS\\CPOS_WEB_API_dev\\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":"","message":"Data Not Found. SyncId:15","method":"","class_name":"","line_number":"","time":"2025-09-10 16:30:39","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.","method":"","class_name":"11","line_number":"0","time":"2025-09-10 16:55:08","error_code":"-2","procedure":"","server":"192.168.0.245,1546","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.<ProcessCposToPos>b__0() in E:\\GitProjects\\Zota CPOS\\CPOS_WEB_API_dev\\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.<ProcessCposToPos>d__4.MoveNext() in E:\\GitProjects\\Zota CPOS\\CPOS_WEB_API_dev\\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.<ProcessSyncData>d__3.MoveNext() in E:\\GitProjects\\Zota CPOS\\CPOS_WEB_API_dev\\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.<SyncProcess>d__10.MoveNext() in E:\\GitProjects\\Zota CPOS\\CPOS_WEB_API_dev\\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.<SyncPOS>d__2.MoveNext() in E:\\GitProjects\\Zota CPOS\\CPOS_WEB_API_dev\\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":"2025-09-10 16:55:40","error_code":"208","procedure":"SP_VALIDATE_API_KEY","server":"192.168.0.245,1546","stack_trace":"at BPPI.CPOS.DAL.APIHelper.ValidateAPIKey(Int32 APIId, String APIKey) in E:\\GitProjects\\Zota CPOS\\CPOS_WEB_API_dev\\ZOTA.CPOS.DAL\\SqlHelperDbSalesData.cs:line 183\r\n   at BPPI.CPOS.API.Controllers.StoreController.<GetStoreStatus>d__40.MoveNext() in E:\\GitProjects\\Zota CPOS\\CPOS_WEB_API_dev\\ZOTA.CPOS.API\\Controllers\\StoreController.cs:line 798","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-09-10 17:22:45","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:\\GitProjects\\Zota CPOS\\CPOS_WEB_API_dev\\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:\\GitProjects\\Zota CPOS\\CPOS_WEB_API_dev\\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":"","message":"Data Not Found. SyncId:15","method":"","class_name":"","line_number":"","time":"2025-09-10 17:31:19","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-09-10 17:48:33","error_code":"208","procedure":"SP_VALIDATE_API_KEY","server":"192.168.0.245,1546","stack_trace":"at BPPI.CPOS.DAL.APIHelper.ValidateAPIKey(Int32 APIId, String APIKey) in E:\\GitProjects\\Zota CPOS\\CPOS_WEB_API_dev\\ZOTA.CPOS.DAL\\SqlHelperDbSalesData.cs:line 183\r\n   at BPPI.CPOS.API.Controllers.StoreController.<GetStoreStatus>d__40.MoveNext() in E:\\GitProjects\\Zota CPOS\\CPOS_WEB_API_dev\\ZOTA.CPOS.API\\Controllers\\StoreController.cs:line 798","priority":"medium","version_no":null,"app_version_no":null,"reccurence_count":1}
,
{"store_code":"","client_code":"","source":".Net SqlClient Data Provider","message":"Error converting data type nvarchar to numeric.","method":"","class_name":"16","line_number":"35","time":"2025-09-10 18:30:42","error_code":"8114","procedure":"Sync_StockRegister_XML","server":"192.168.0.245,1546","stack_trace":"at Ethics.HelperModules.DataContext.SqlDapperHelper.<ExecuteScalarQueryAsync>d__18`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 ZOTA.CPOS.BAL.SyncServices.SyncRepositories.<ProcessPosToCpos>d__5.MoveNext() in E:\\GitProjects\\Zota CPOS\\CPOS_WEB_API_dev\\ZOTA.CPOS.BAL\\SyncServices\\SyncRepositories.cs:line 74\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.<ProcessSyncData>d__3.MoveNext() in E:\\GitProjects\\Zota CPOS\\CPOS_WEB_API_dev\\ZOTA.CPOS.BAL\\SyncServices\\SyncRepositories.cs:line 37\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.<SyncProcess>d__10.MoveNext() in E:\\GitProjects\\Zota CPOS\\CPOS_WEB_API_dev\\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.<SyncPOS>d__2.MoveNext() in E:\\GitProjects\\Zota CPOS\\CPOS_WEB_API_dev\\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":"","message":"Data Not Found. SyncId:15","method":"","class_name":"","line_number":"","time":"2025-09-10 18:31:39","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-09-10 18:47:49","error_code":"208","procedure":"SP_VALIDATE_API_KEY","server":"192.168.0.245,1546","stack_trace":"at BPPI.CPOS.DAL.APIHelper.ValidateAPIKey(Int32 APIId, String APIKey) in E:\\GitProjects\\Zota CPOS\\CPOS_WEB_API_dev\\ZOTA.CPOS.DAL\\SqlHelperDbSalesData.cs:line 183\r\n   at BPPI.CPOS.API.Controllers.StoreController.<GetStoreStatus>d__40.MoveNext() in E:\\GitProjects\\Zota CPOS\\CPOS_WEB_API_dev\\ZOTA.CPOS.API\\Controllers\\StoreController.cs:line 798","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-09-10 19:32:20","error_code":"","procedure":"","server":"","stack_trace":"","priority":"","version_no":null,"app_version_no":null,"reccurence_count":1}
,