{"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-11-05 12:53: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 D:\\DPC22\\GitProjects\\zota\\Cpos\\Cpos_API\\ZOTA.CPOS.DAL\\SqlHelperDbSalesData.cs:line 183\r\n   at BPPI.CPOS.API.Controllers.StoreController.<GetStoreStatus>d__40.MoveNext() in D:\\DPC22\\GitProjects\\zota\\Cpos\\Cpos_API\\ZOTA.CPOS.API\\Controllers\\StoreController.cs:line 814","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-11-05 12:54:43","error_code":"-2","procedure":"","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 D:\\DPC22\\GitProjects\\zota\\Cpos\\Cpos_API\\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 D:\\DPC22\\GitProjects\\zota\\Cpos\\Cpos_API\\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 D:\\DPC22\\GitProjects\\zota\\Cpos\\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.<SyncPOS>d__2.MoveNext() in D:\\DPC22\\GitProjects\\zota\\Cpos\\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":"","message":"Data Not Found. SyncId:15","method":"","class_name":"","line_number":"","time":"2025-11-05 12:54:58","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-11-05 12:56:09","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 D:\\DPC22\\GitProjects\\zota\\Cpos\\Cpos_API\\ZOTA.CPOS.DAL\\SqlHelperDbSalesData.cs:line 183\r\n   at BPPI.CPOS.API.Controllers.StoreController.<GetStoreStatus>d__40.MoveNext() in D:\\DPC22\\GitProjects\\zota\\Cpos\\Cpos_API\\ZOTA.CPOS.API\\Controllers\\StoreController.cs:line 814","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-11-05 12:56:17","error_code":"-2","procedure":"","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 D:\\DPC22\\GitProjects\\zota\\Cpos\\Cpos_API\\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 D:\\DPC22\\GitProjects\\zota\\Cpos\\Cpos_API\\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 D:\\DPC22\\GitProjects\\zota\\Cpos\\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.<SyncPOS>d__2.MoveNext() in D:\\DPC22\\GitProjects\\zota\\Cpos\\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":"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-11-05 13:01:56","error_code":"-2","procedure":"","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 D:\\DPC22\\GitProjects\\zota\\Cpos\\Cpos_API\\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 D:\\DPC22\\GitProjects\\zota\\Cpos\\Cpos_API\\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 D:\\DPC22\\GitProjects\\zota\\Cpos\\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.<SyncPOS>d__2.MoveNext() in D:\\DPC22\\GitProjects\\zota\\Cpos\\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":"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-11-05 13:07:27","error_code":"-2","procedure":"","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 D:\\DPC22\\GitProjects\\zota\\Cpos\\Cpos_API\\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 D:\\DPC22\\GitProjects\\zota\\Cpos\\Cpos_API\\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 D:\\DPC22\\GitProjects\\zota\\Cpos\\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.<SyncPOS>d__2.MoveNext() in D:\\DPC22\\GitProjects\\zota\\Cpos\\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":"Database 53 cannot be autostarted during server shutdown or startup.","method":"","class_name":"16","line_number":"42","time":"2025-11-05 13:07:28","error_code":"904","procedure":"Sync_ProductAndBatchWiseBarcode_LIST","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 D:\\DPC22\\GitProjects\\zota\\Cpos\\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.<ProcessCposToPos>d__4.MoveNext() in D:\\DPC22\\GitProjects\\zota\\Cpos\\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.<ProcessSyncData>d__3.MoveNext() in D:\\DPC22\\GitProjects\\zota\\Cpos\\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.<SyncProcess>d__10.MoveNext() in D:\\DPC22\\GitProjects\\zota\\Cpos\\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.<SyncPOS>d__2.MoveNext() in D:\\DPC22\\GitProjects\\zota\\Cpos\\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":"The multi-part identifier \"SD.Category\" could not be bound.\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 SD.Category = 'HEAD OFFICE' 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-08-2024 GID.: #897\r\n\t\t\t\tPH.Id,\r\n\t\t\t\t\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-11-05 13:30:36","error_code":"4104","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 D:\\DPC22\\GitProjects\\zota\\Cpos\\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 D:\\DPC22\\GitProjects\\zota\\Cpos\\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":"Invalid object name 'cPOS_SALES_DATA..ApiConfiguration'.","method":"","class_name":"16","line_number":"9","time":"2025-11-05 13:43:39","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 D:\\DPC22\\GitProjects\\zota\\Cpos\\Cpos_API\\ZOTA.CPOS.DAL\\SqlHelperDbSalesData.cs:line 183\r\n   at BPPI.CPOS.API.Controllers.StoreController.<GetStoreStatus>d__40.MoveNext() in D:\\DPC22\\GitProjects\\zota\\Cpos\\Cpos_API\\ZOTA.CPOS.API\\Controllers\\StoreController.cs:line 814","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-11-05 13:44:04","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 D:\\DPC22\\GitProjects\\zota\\Cpos\\Cpos_API\\ZOTA.CPOS.DAL\\SqlHelperDbSalesData.cs:line 183\r\n   at BPPI.CPOS.API.Controllers.StoreController.<GetStoreStatus>d__40.MoveNext() in D:\\DPC22\\GitProjects\\zota\\Cpos\\Cpos_API\\ZOTA.CPOS.API\\Controllers\\StoreController.cs:line 814","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-11-05 13:54:26","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":"Error converting data type nvarchar to numeric.","method":"","class_name":"16","line_number":"35","time":"2025-11-05 14:55:13","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 D:\\DPC22\\GitProjects\\zota\\Cpos\\Cpos_API\\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 D:\\DPC22\\GitProjects\\zota\\Cpos\\Cpos_API\\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 D:\\DPC22\\GitProjects\\zota\\Cpos\\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.<SyncPOS>d__2.MoveNext() in D:\\DPC22\\GitProjects\\zota\\Cpos\\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":"","message":"Data Not Found. SyncId:15","method":"","class_name":"","line_number":"","time":"2025-11-05 14:55: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-11-05 15:42:22","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 D:\\DPC22\\GitProjects\\zota\\Cpos\\Cpos_API\\ZOTA.CPOS.DAL\\SqlHelperDbSalesData.cs:line 183\r\n   at BPPI.CPOS.API.Controllers.StoreController.<GetStoreStatus>d__40.MoveNext() in D:\\DPC22\\GitProjects\\zota\\Cpos\\Cpos_API\\ZOTA.CPOS.API\\Controllers\\StoreController.cs:line 814","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-11-05 15:55:24","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-11-05 16:33: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 D:\\DPC22\\GitProjects\\zota\\Cpos\\Cpos_API\\ZOTA.CPOS.DAL\\SqlHelperDbSalesData.cs:line 183\r\n   at BPPI.CPOS.API.Controllers.StoreController.<GetStoreStatus>d__40.MoveNext() in D:\\DPC22\\GitProjects\\zota\\Cpos\\Cpos_API\\ZOTA.CPOS.API\\Controllers\\StoreController.cs:line 814","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-11-05 16:47:48","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 D:\\DPC22\\GitProjects\\zota\\Cpos\\Cpos_API\\ZOTA.CPOS.DAL\\SqlHelperDbSalesData.cs:line 183\r\n   at BPPI.CPOS.API.Controllers.StoreController.<GetStoreStatus>d__40.MoveNext() in D:\\DPC22\\GitProjects\\zota\\Cpos\\Cpos_API\\ZOTA.CPOS.API\\Controllers\\StoreController.cs:line 814","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-11-05 16:48:40","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":"Error converting data type nvarchar to numeric.","method":"","class_name":"16","line_number":"35","time":"2025-11-05 16:55:25","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 D:\\DPC22\\GitProjects\\zota\\Cpos\\Cpos_API\\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 D:\\DPC22\\GitProjects\\zota\\Cpos\\Cpos_API\\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 D:\\DPC22\\GitProjects\\zota\\Cpos\\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.<SyncPOS>d__2.MoveNext() in D:\\DPC22\\GitProjects\\zota\\Cpos\\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":"","message":"Data Not Found. SyncId:15","method":"","class_name":"","line_number":"","time":"2025-11-05 16:55:25","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":"Error converting data type varchar to bigint.","method":"","class_name":"16","line_number":"403","time":"2025-11-05 16:55:32","error_code":"8114","procedure":"Sync_Store_SalesInvoiceScheme_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 D:\\DPC22\\GitProjects\\zota\\Cpos\\Cpos_API\\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 D:\\DPC22\\GitProjects\\zota\\Cpos\\Cpos_API\\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 D:\\DPC22\\GitProjects\\zota\\Cpos\\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.<SyncPOS>d__2.MoveNext() in D:\\DPC22\\GitProjects\\zota\\Cpos\\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":"Error converting data type varchar to bigint.","method":"","class_name":"16","line_number":"403","time":"2025-11-05 17:00:54","error_code":"8114","procedure":"Sync_Store_SalesInvoiceScheme_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 D:\\DPC22\\GitProjects\\zota\\Cpos\\Cpos_API\\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 D:\\DPC22\\GitProjects\\zota\\Cpos\\Cpos_API\\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 D:\\DPC22\\GitProjects\\zota\\Cpos\\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.<SyncPOS>d__2.MoveNext() in D:\\DPC22\\GitProjects\\zota\\Cpos\\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":"","message":"Data Not Found. SyncId:15","method":"","class_name":"","line_number":"","time":"2025-11-05 17:55: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-11-05 18:41:39","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 D:\\DPC22\\GitProjects\\zota\\Cpos\\Cpos_API\\ZOTA.CPOS.DAL\\SqlHelperDbSalesData.cs:line 183\r\n   at BPPI.CPOS.API.Controllers.StoreController.<GetStoreStatus>d__40.MoveNext() in D:\\DPC22\\GitProjects\\zota\\Cpos\\Cpos_API\\ZOTA.CPOS.API\\Controllers\\StoreController.cs:line 814","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-11-05 18:55:35","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 D:\\DPC22\\GitProjects\\zota\\Cpos\\Cpos_API\\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 D:\\DPC22\\GitProjects\\zota\\Cpos\\Cpos_API\\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 D:\\DPC22\\GitProjects\\zota\\Cpos\\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.<SyncPOS>d__2.MoveNext() in D:\\DPC22\\GitProjects\\zota\\Cpos\\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":"","message":"Data Not Found. SyncId:15","method":"","class_name":"","line_number":"","time":"2025-11-05 18:55: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":"The multi-part identifier \"SD.Category\" could not be bound.\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 SD.Category = 'HEAD OFFICE' 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-08-2024 GID.: #897\r\n\t\t\t\tPH.Id,\r\n\t\t\t\t\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-11-05 19:22:48","error_code":"4104","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 D:\\DPC22\\GitProjects\\zota\\Cpos\\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 D:\\DPC22\\GitProjects\\zota\\Cpos\\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":"","message":"Data Not Found. SyncId:15","method":"","class_name":"","line_number":"","time":"2025-11-05 19:55: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":"Error converting data type nvarchar to numeric.","method":"","class_name":"16","line_number":"35","time":"2025-11-05 20:55:34","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 D:\\DPC22\\GitProjects\\zota\\Cpos\\Cpos_API\\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 D:\\DPC22\\GitProjects\\zota\\Cpos\\Cpos_API\\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 D:\\DPC22\\GitProjects\\zota\\Cpos\\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.<SyncPOS>d__2.MoveNext() in D:\\DPC22\\GitProjects\\zota\\Cpos\\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":"","message":"Data Not Found. SyncId:15","method":"","class_name":"","line_number":"","time":"2025-11-05 20:55:34","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-11-05 21:55: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":"Error converting data type nvarchar to numeric.","method":"","class_name":"16","line_number":"35","time":"2025-11-05 22:55:34","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 D:\\DPC22\\GitProjects\\zota\\Cpos\\Cpos_API\\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 D:\\DPC22\\GitProjects\\zota\\Cpos\\Cpos_API\\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 D:\\DPC22\\GitProjects\\zota\\Cpos\\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.<SyncPOS>d__2.MoveNext() in D:\\DPC22\\GitProjects\\zota\\Cpos\\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":"","message":"Data Not Found. SyncId:15","method":"","class_name":"","line_number":"","time":"2025-11-05 22:55:34","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-11-05 23:56:32","error_code":"","procedure":"","server":"","stack_trace":"","priority":"","version_no":null,"app_version_no":null,"reccurence_count":1}
,