{"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-15 10:28: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:\\GitProjectWork\\Dava India\\CPOS\\Web_ApiDotNet_WorkOnthis\\ZOTA.CPOS.DAL\\SqlHelperDbSalesData.cs:line 183\r\n at BPPI.CPOS.API.Controllers.StoreController.d__40.MoveNext() in E:\\GitProjectWork\\Dava India\\CPOS\\Web_ApiDotNet_WorkOnthis\\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-15 10:29:46","error_code":"8114","procedure":"Sync_StockRegister_XML","server":"192.168.0.245,1546","stack_trace":"at Ethics.HelperModules.DataContext.SqlDapperHelper.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.d__5.MoveNext() in E:\\GitProjectWork\\Dava India\\CPOS\\Web_ApiDotNet_WorkOnthis\\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.d__3.MoveNext() in E:\\GitProjectWork\\Dava India\\CPOS\\Web_ApiDotNet_WorkOnthis\\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.d__10.MoveNext() in E:\\GitProjectWork\\Dava India\\CPOS\\Web_ApiDotNet_WorkOnthis\\ZOTA.CPOS.API\\Controllers\\SyncController.cs:line 224\r\n--- End of stack trace from previous location where exception was thrown ---\r\n at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()\r\n at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)\r\n at System.Runtime.CompilerServices.TaskAwaiter`1.GetResult()\r\n at BPPI.CPOS.API.Controllers.SyncController.d__2.MoveNext() in E:\\GitProjectWork\\Dava India\\CPOS\\Web_ApiDotNet_WorkOnthis\\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-15 10:30:07","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-15 11:00:16","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:\\GitProjectWork\\Dava India\\CPOS\\Web_ApiDotNet_WorkOnthis\\ZOTA.CPOS.DAL\\SqlHelperDbSalesData.cs:line 183\r\n at BPPI.CPOS.API.Controllers.StoreController.d__40.MoveNext() in E:\\GitProjectWork\\Dava India\\CPOS\\Web_ApiDotNet_WorkOnthis\\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-15 11:05:21","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:\\GitProjectWork\\Dava India\\CPOS\\Web_ApiDotNet_WorkOnthis\\ZOTA.CPOS.DAL\\SqlHelperDbSalesData.cs:line 183\r\n at BPPI.CPOS.API.Controllers.StoreController.d__40.MoveNext() in E:\\GitProjectWork\\Dava India\\CPOS\\Web_ApiDotNet_WorkOnthis\\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-15 11:05:34","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:\\GitProjectWork\\Dava India\\CPOS\\Web_ApiDotNet_WorkOnthis\\ZOTA.CPOS.DAL\\SqlHelperDbSalesData.cs:line 183\r\n at BPPI.CPOS.API.Controllers.StoreController.d__40.MoveNext() in E:\\GitProjectWork\\Dava India\\CPOS\\Web_ApiDotNet_WorkOnthis\\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-15 11:06:46","error_code":"","procedure":"","server":"","stack_trace":"","priority":"","version_no":null,"app_version_no":null,"reccurence_count":1} , {"store_code":"","client_code":"","source":".Net SqlClient Data Provider","message":"Invalid object name 'cPOS_SALES_DATA..ApiConfiguration'.","method":"","class_name":"16","line_number":"9","time":"2025-09-15 11:09: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:\\GitProjectWork\\Dava India\\CPOS\\Web_ApiDotNet_WorkOnthis\\ZOTA.CPOS.DAL\\SqlHelperDbSalesData.cs:line 183\r\n at BPPI.CPOS.API.Controllers.StoreController.d__40.MoveNext() in E:\\GitProjectWork\\Dava India\\CPOS\\Web_ApiDotNet_WorkOnthis\\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-15 11:30:19","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-09-15 12:06:37","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-15 12:15:24","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:\\GitProjectWork\\Dava India\\CPOS\\Web_ApiDotNet_WorkOnthis\\ZOTA.CPOS.DAL\\SqlHelperDbSalesData.cs:line 183\r\n at BPPI.CPOS.API.Controllers.StoreController.d__40.MoveNext() in E:\\GitProjectWork\\Dava India\\CPOS\\Web_ApiDotNet_WorkOnthis\\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-15 12:29:22","error_code":"8114","procedure":"Sync_StockRegister_XML","server":"192.168.0.245,1546","stack_trace":"at Ethics.HelperModules.DataContext.SqlDapperHelper.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.d__5.MoveNext() in E:\\GitProjectWork\\Dava India\\CPOS\\Web_ApiDotNet_WorkOnthis\\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.d__3.MoveNext() in E:\\GitProjectWork\\Dava India\\CPOS\\Web_ApiDotNet_WorkOnthis\\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.d__10.MoveNext() in E:\\GitProjectWork\\Dava India\\CPOS\\Web_ApiDotNet_WorkOnthis\\ZOTA.CPOS.API\\Controllers\\SyncController.cs:line 224\r\n--- End of stack trace from previous location where exception was thrown ---\r\n at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()\r\n at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)\r\n at System.Runtime.CompilerServices.TaskAwaiter`1.GetResult()\r\n at BPPI.CPOS.API.Controllers.SyncController.d__2.MoveNext() in E:\\GitProjectWork\\Dava India\\CPOS\\Web_ApiDotNet_WorkOnthis\\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-15 12:30: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":"Must declare the scalar variable \"@HOCode\".\r\nIncorrect syntax near 'X'.\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 = @HOCode 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\tP\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":"15","line_number":"58","time":"2025-09-15 12:33:32","error_code":"137","procedure":"","server":"192.168.0.245,1546","stack_trace":"at Ethics.HelperModules.DataContext.SqlDapperHelper.d__17`1.MoveNext()\r\n--- End of stack trace from previous location where exception was thrown ---\r\n at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()\r\n at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)\r\n at System.Runtime.CompilerServices.TaskAwaiter`1.GetResult()\r\n at BPPI.CPOS.BAL.Common.CommonRepositories.d__20.MoveNext() in E:\\GitProjectWork\\Dava India\\CPOS\\Web_ApiDotNet_WorkOnthis\\ZOTA.CPOS.BAL\\Common\\CommonRepositories.cs:line 433\r\n--- End of stack trace from previous location where exception was thrown ---\r\n at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()\r\n at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)\r\n at System.Runtime.CompilerServices.TaskAwaiter`1.GetResult()\r\n at BPPI.CPOS.API.Controllers.CommonController.d__3.MoveNext() in E:\\GitProjectWork\\Dava India\\CPOS\\Web_ApiDotNet_WorkOnthis\\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-09-15 13:06:38","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-09-15 13:30:19","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-09-15 14:07:21","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-15 14:10:02","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:\\GitProjectWork\\Dava India\\CPOS\\Web_ApiDotNet_WorkOnthis\\ZOTA.CPOS.DAL\\SqlHelperDbSalesData.cs:line 183\r\n at BPPI.CPOS.API.Controllers.StoreController.d__40.MoveNext() in E:\\GitProjectWork\\Dava India\\CPOS\\Web_ApiDotNet_WorkOnthis\\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":"Incorrect syntax near the keyword 'AS'.\r\nInvalid usage of the option NEXT in the FETCH statement.","method":"","class_name":"15","line_number":"84","time":"2025-09-15 14:23:03","error_code":"156","procedure":"","server":"192.168.0.245,1546","stack_trace":"at Ethics.HelperModules.DataContext.SqlDapperHelper.d__17`1.MoveNext()\r\n--- End of stack trace from previous location where exception was thrown ---\r\n at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()\r\n at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)\r\n at System.Runtime.CompilerServices.TaskAwaiter`1.GetResult()\r\n at BPPI.CPOS.BAL.Common.CommonRepositories.d__23.MoveNext() in E:\\GitProjectWork\\Dava India\\CPOS\\Web_ApiDotNet_WorkOnthis\\ZOTA.CPOS.BAL\\Common\\CommonRepositories.cs:line 548\r\n--- End of stack trace from previous location where exception was thrown ---\r\n at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()\r\n at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)\r\n at System.Runtime.CompilerServices.TaskAwaiter`1.GetResult()\r\n at BPPI.CPOS.BAL.Common.CommonRepositories.d__20.MoveNext() in E:\\GitProjectWork\\Dava India\\CPOS\\Web_ApiDotNet_WorkOnthis\\ZOTA.CPOS.BAL\\Common\\CommonRepositories.cs:line 436\r\n--- End of stack trace from previous location where exception was thrown ---\r\n at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()\r\n at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)\r\n at System.Runtime.CompilerServices.TaskAwaiter`1.GetResult()\r\n at BPPI.CPOS.API.Controllers.CommonController.d__3.MoveNext() in E:\\GitProjectWork\\Dava India\\CPOS\\Web_ApiDotNet_WorkOnthis\\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":"Error converting data type nvarchar to numeric.","method":"","class_name":"16","line_number":"35","time":"2025-09-15 14:29:25","error_code":"8114","procedure":"Sync_StockRegister_XML","server":"192.168.0.245,1546","stack_trace":"at Ethics.HelperModules.DataContext.SqlDapperHelper.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.d__5.MoveNext() in E:\\GitProjectWork\\Dava India\\CPOS\\Web_ApiDotNet_WorkOnthis\\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.d__3.MoveNext() in E:\\GitProjectWork\\Dava India\\CPOS\\Web_ApiDotNet_WorkOnthis\\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.d__10.MoveNext() in E:\\GitProjectWork\\Dava India\\CPOS\\Web_ApiDotNet_WorkOnthis\\ZOTA.CPOS.API\\Controllers\\SyncController.cs:line 224\r\n--- End of stack trace from previous location where exception was thrown ---\r\n at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()\r\n at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)\r\n at System.Runtime.CompilerServices.TaskAwaiter`1.GetResult()\r\n at BPPI.CPOS.API.Controllers.SyncController.d__2.MoveNext() in E:\\GitProjectWork\\Dava India\\CPOS\\Web_ApiDotNet_WorkOnthis\\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-15 14:30: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":"Invalid object name 'cPOS_SALES_DATA..ApiConfiguration'.","method":"","class_name":"16","line_number":"9","time":"2025-09-15 15: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:\\GitProjectWork\\Dava India\\CPOS\\Web_ApiDotNet_WorkOnthis\\ZOTA.CPOS.DAL\\SqlHelperDbSalesData.cs:line 183\r\n at BPPI.CPOS.API.Controllers.StoreController.d__40.MoveNext() in E:\\GitProjectWork\\Dava India\\CPOS\\Web_ApiDotNet_WorkOnthis\\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-15 15:30:53","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-15 15:58:32","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:\\GitProjectWork\\Dava India\\CPOS\\Web_ApiDotNet_WorkOnthis\\ZOTA.CPOS.DAL\\SqlHelperDbSalesData.cs:line 183\r\n at BPPI.CPOS.API.Controllers.StoreController.d__40.MoveNext() in E:\\GitProjectWork\\Dava India\\CPOS\\Web_ApiDotNet_WorkOnthis\\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-15 16:29:37","error_code":"8114","procedure":"Sync_StockRegister_XML","server":"192.168.0.245,1546","stack_trace":"at Ethics.HelperModules.DataContext.SqlDapperHelper.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.d__5.MoveNext() in E:\\GitProjectWork\\Dava India\\CPOS\\Web_ApiDotNet_WorkOnthis\\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.d__3.MoveNext() in E:\\GitProjectWork\\Dava India\\CPOS\\Web_ApiDotNet_WorkOnthis\\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.d__10.MoveNext() in E:\\GitProjectWork\\Dava India\\CPOS\\Web_ApiDotNet_WorkOnthis\\ZOTA.CPOS.API\\Controllers\\SyncController.cs:line 224\r\n--- End of stack trace from previous location where exception was thrown ---\r\n at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()\r\n at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)\r\n at System.Runtime.CompilerServices.TaskAwaiter`1.GetResult()\r\n at BPPI.CPOS.API.Controllers.SyncController.d__2.MoveNext() in E:\\GitProjectWork\\Dava India\\CPOS\\Web_ApiDotNet_WorkOnthis\\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-15 16:30:36","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-09-15 17:30:54","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-15 17:36: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:\\GitProjectWork\\Dava India\\CPOS\\Web_ApiDotNet_WorkOnthis\\ZOTA.CPOS.DAL\\SqlHelperDbSalesData.cs:line 183\r\n at BPPI.CPOS.API.Controllers.StoreController.d__40.MoveNext() in E:\\GitProjectWork\\Dava India\\CPOS\\Web_ApiDotNet_WorkOnthis\\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-15 18:29:54","error_code":"8114","procedure":"Sync_StockRegister_XML","server":"192.168.0.245,1546","stack_trace":"at Ethics.HelperModules.DataContext.SqlDapperHelper.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.d__5.MoveNext() in E:\\GitProjectWork\\Dava India\\CPOS\\Web_ApiDotNet_WorkOnthis\\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.d__3.MoveNext() in E:\\GitProjectWork\\Dava India\\CPOS\\Web_ApiDotNet_WorkOnthis\\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.d__10.MoveNext() in E:\\GitProjectWork\\Dava India\\CPOS\\Web_ApiDotNet_WorkOnthis\\ZOTA.CPOS.API\\Controllers\\SyncController.cs:line 224\r\n--- End of stack trace from previous location where exception was thrown ---\r\n at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()\r\n at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)\r\n at System.Runtime.CompilerServices.TaskAwaiter`1.GetResult()\r\n at BPPI.CPOS.API.Controllers.SyncController.d__2.MoveNext() in E:\\GitProjectWork\\Dava India\\CPOS\\Web_ApiDotNet_WorkOnthis\\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-15 18:30:53","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-09-15 19:30:53","error_code":"","procedure":"","server":"","stack_trace":"","priority":"","version_no":null,"app_version_no":null,"reccurence_count":1} ,