{"store_code":"","client_code":"","source":"","message":"Data Not Found. SyncId:15","method":"","class_name":"","line_number":"","time":"2024-05-09 00:10:54","error_code":"","procedure":"","server":"","stack_trace":"","priority":"","version_no":null,"app_version_no":null,"reccurence_count":1} , {"store_code":"","client_code":"","source":"","message":"Data Not Found. SyncId:15","method":"","class_name":"","line_number":"","time":"2024-05-09 01:11:37","error_code":"","procedure":"","server":"","stack_trace":"","priority":"","version_no":null,"app_version_no":null,"reccurence_count":1} , {"store_code":"","client_code":"","source":"","message":"Data Not Found. SyncId:15","method":"","class_name":"","line_number":"","time":"2024-05-09 02:11:13","error_code":"","procedure":"","server":"","stack_trace":"","priority":"","version_no":null,"app_version_no":null,"reccurence_count":1} , {"store_code":"","client_code":"","source":"","message":"Data Not Found. SyncId:15","method":"","class_name":"","line_number":"","time":"2024-05-09 03:11:14","error_code":"","procedure":"","server":"","stack_trace":"","priority":"","version_no":null,"app_version_no":null,"reccurence_count":1} , {"store_code":"","client_code":"","source":"","message":"Data Not Found. SyncId:15","method":"","class_name":"","line_number":"","time":"2024-05-09 04:11:07","error_code":"","procedure":"","server":"","stack_trace":"","priority":"","version_no":null,"app_version_no":null,"reccurence_count":1} , {"store_code":"","client_code":"","source":"","message":"Data Not Found. SyncId:15","method":"","class_name":"","line_number":"","time":"2024-05-09 05:18:35","error_code":"","procedure":"","server":"","stack_trace":"","priority":"","version_no":null,"app_version_no":null,"reccurence_count":1} , {"store_code":"","client_code":"","source":"","message":"Data Not Found. SyncId:15","method":"","class_name":"","line_number":"","time":"2024-05-09 06:19:32","error_code":"","procedure":"","server":"","stack_trace":"","priority":"","version_no":null,"app_version_no":null,"reccurence_count":1} , {"store_code":"","client_code":"","source":"","message":"Data Not Found. SyncId:15","method":"","class_name":"","line_number":"","time":"2024-05-09 07:22:41","error_code":"","procedure":"","server":"","stack_trace":"","priority":"","version_no":null,"app_version_no":null,"reccurence_count":1} , {"store_code":"","client_code":"","source":"","message":"Data Not Found. SyncId:15","method":"","class_name":"","line_number":"","time":"2024-05-09 08:22:46","error_code":"","procedure":"","server":"","stack_trace":"","priority":"","version_no":null,"app_version_no":null,"reccurence_count":1} , {"store_code":"","client_code":"","source":"","message":"Data Not Found. SyncId:15","method":"","class_name":"","line_number":"","time":"2024-05-09 09:22:04","error_code":"","procedure":"","server":"","stack_trace":"","priority":"","version_no":null,"app_version_no":null,"reccurence_count":1} , {"store_code":"","client_code":"","source":".Net SqlClient Data Provider","message":"Invalid object name 'cPOS_SALES_DATA..ApiConfiguration'.","method":"","class_name":"16","line_number":"9","time":"2024-05-09 09:57:38","error_code":"208","procedure":"SP_VALIDATE_API_KEY","server":"SERVER04","stack_trace":"at BPPI.CPOS.DAL.APIHelper.ValidateAPIKey(Int32 APIId, String APIKey) in D:\\DPC15\\GIT Repository\\ZOTA\\CPOS_API\\ZOTA.CPOS.DAL\\SqlHelperDbSalesData.cs:line 183\r\n at BPPI.CPOS.API.Controllers.StoreController.d__39.MoveNext() in D:\\DPC15\\GIT Repository\\ZOTA\\CPOS_API\\ZOTA.CPOS.API\\Controllers\\StoreController.cs:line 781","priority":"medium","version_no":null,"app_version_no":null,"reccurence_count":1} , {"store_code":"","client_code":"","source":"","message":"Data Not Found. SyncId:15","method":"","class_name":"","line_number":"","time":"2024-05-09 09:57:44","error_code":"","procedure":"","server":"","stack_trace":"","priority":"","version_no":null,"app_version_no":null,"reccurence_count":1} , {"store_code":"","client_code":"","source":"","message":"Data Not Found. SyncId:15","method":"","class_name":"","line_number":"","time":"2024-05-09 10:57:44","error_code":"","procedure":"","server":"","stack_trace":"","priority":"","version_no":null,"app_version_no":null,"reccurence_count":1} , {"store_code":"","client_code":"","source":".Net SqlClient Data Provider","message":"Invalid object name 'cPOS_SALES_DATA..ApiConfiguration'.","method":"","class_name":"16","line_number":"9","time":"2024-05-09 11:59:51","error_code":"208","procedure":"SP_VALIDATE_API_KEY","server":"SERVER04","stack_trace":"at BPPI.CPOS.DAL.APIHelper.ValidateAPIKey(Int32 APIId, String APIKey) in D:\\DPC15\\GIT Repository\\ZOTA\\CPOS_API\\ZOTA.CPOS.DAL\\SqlHelperDbSalesData.cs:line 183\r\n at BPPI.CPOS.API.Controllers.StoreController.d__39.MoveNext() in D:\\DPC15\\GIT Repository\\ZOTA\\CPOS_API\\ZOTA.CPOS.API\\Controllers\\StoreController.cs:line 781","priority":"medium","version_no":null,"app_version_no":null,"reccurence_count":1} , {"store_code":"","client_code":"","source":"","message":"Data Not Found. SyncId:15","method":"","class_name":"","line_number":"","time":"2024-05-09 12:00:29","error_code":"","procedure":"","server":"","stack_trace":"","priority":"","version_no":null,"app_version_no":null,"reccurence_count":1} , {"store_code":"","client_code":"","source":".Net SqlClient Data Provider","message":"Invalid object name 'cPOS_SALES_DATA..ApiConfiguration'.","method":"","class_name":"16","line_number":"9","time":"2024-05-09 12:19:40","error_code":"208","procedure":"SP_VALIDATE_API_KEY","server":"SERVER04","stack_trace":"at BPPI.CPOS.DAL.APIHelper.ValidateAPIKey(Int32 APIId, String APIKey) in D:\\DPC15\\GIT Repository\\ZOTA\\CPOS_API\\ZOTA.CPOS.DAL\\SqlHelperDbSalesData.cs:line 183\r\n at BPPI.CPOS.API.Controllers.StoreController.d__39.MoveNext() in D:\\DPC15\\GIT Repository\\ZOTA\\CPOS_API\\ZOTA.CPOS.API\\Controllers\\StoreController.cs:line 781","priority":"medium","version_no":null,"app_version_no":null,"reccurence_count":1} , {"store_code":"","client_code":"","source":"","message":"Data Not Found. SyncId:15","method":"","class_name":"","line_number":"","time":"2024-05-09 12:19:52","error_code":"","procedure":"","server":"","stack_trace":"","priority":"","version_no":null,"app_version_no":null,"reccurence_count":1} , {"store_code":"","client_code":"","source":"","message":"Sync Config not found for the syncid:65","method":"","class_name":"","line_number":"","time":"2024-05-09 12:20:33","error_code":"","procedure":"","server":"","stack_trace":"","priority":"","version_no":null,"app_version_no":null,"reccurence_count":1} , {"store_code":"","client_code":"","source":"","message":"Data Not Found. SyncId:15","method":"","class_name":"","line_number":"","time":"2024-05-09 13:00:56","error_code":"","procedure":"","server":"","stack_trace":"","priority":"","version_no":null,"app_version_no":null,"reccurence_count":1} , {"store_code":"","client_code":"","source":"","message":"Data Not Found. SyncId:15","method":"","class_name":"","line_number":"","time":"2024-05-09 14:01:27","error_code":"","procedure":"","server":"","stack_trace":"","priority":"","version_no":null,"app_version_no":null,"reccurence_count":1} , {"store_code":"","client_code":"","source":".Net SqlClient Data Provider","message":"Invalid object name 'cPOS_SALES_DATA..ApiConfiguration'.","method":"","class_name":"16","line_number":"9","time":"2024-05-09 14:22:13","error_code":"208","procedure":"SP_VALIDATE_API_KEY","server":"SERVER04","stack_trace":"at BPPI.CPOS.DAL.APIHelper.ValidateAPIKey(Int32 APIId, String APIKey) in D:\\DPC15\\GIT Repository\\ZOTA\\CPOS_API\\ZOTA.CPOS.DAL\\SqlHelperDbSalesData.cs:line 183\r\n at BPPI.CPOS.API.Controllers.StoreController.d__39.MoveNext() in D:\\DPC15\\GIT Repository\\ZOTA\\CPOS_API\\ZOTA.CPOS.API\\Controllers\\StoreController.cs:line 781","priority":"medium","version_no":null,"app_version_no":null,"reccurence_count":1} , {"store_code":"","client_code":"","source":".Net SqlClient Data Provider","message":"Invalid object name 'cPOS_SALES_DATA..ApiConfiguration'.","method":"","class_name":"16","line_number":"9","time":"2024-05-09 14:39:03","error_code":"208","procedure":"SP_VALIDATE_API_KEY","server":"SERVER04","stack_trace":"at BPPI.CPOS.DAL.APIHelper.ValidateAPIKey(Int32 APIId, String APIKey) in D:\\DPC15\\GIT Repository\\ZOTA\\CPOS_API\\ZOTA.CPOS.DAL\\SqlHelperDbSalesData.cs:line 183\r\n at BPPI.CPOS.API.Controllers.StoreController.d__39.MoveNext() in D:\\DPC15\\GIT Repository\\ZOTA\\CPOS_API\\ZOTA.CPOS.API\\Controllers\\StoreController.cs:line 781","priority":"medium","version_no":null,"app_version_no":null,"reccurence_count":1} , {"store_code":"","client_code":"","source":"","message":"Data Not Found. SyncId:15","method":"","class_name":"","line_number":"","time":"2024-05-09 14:39:43","error_code":"","procedure":"","server":"","stack_trace":"","priority":"","version_no":null,"app_version_no":null,"reccurence_count":1} , {"store_code":"","client_code":"","source":".Net SqlClient Data Provider","message":"Invalid object name 'cPOS_SALES_DATA..ApiConfiguration'.","method":"","class_name":"16","line_number":"9","time":"2024-05-09 14:52:51","error_code":"208","procedure":"SP_VALIDATE_API_KEY","server":"SERVER04","stack_trace":"at BPPI.CPOS.DAL.APIHelper.ValidateAPIKey(Int32 APIId, String APIKey) in D:\\DPC15\\GIT Repository\\ZOTA\\CPOS_API\\ZOTA.CPOS.DAL\\SqlHelperDbSalesData.cs:line 183\r\n at BPPI.CPOS.API.Controllers.StoreController.d__39.MoveNext() in D:\\DPC15\\GIT Repository\\ZOTA\\CPOS_API\\ZOTA.CPOS.API\\Controllers\\StoreController.cs:line 781","priority":"medium","version_no":null,"app_version_no":null,"reccurence_count":1} , {"store_code":"","client_code":"","source":".Net SqlClient Data Provider","message":"Execution Timeout Expired. The timeout period elapsed prior to completion of the operation or the server is not responding.\r\n\r\n\t\tSELECT * ,\r\n\t\tCount(*)\r\n OVER() AS totalRecord\r\n\t\tFROM (\r\n\t\t SELECT\t\t\tDISTINCT --ACCNH.*\r\n\t\t\t\t\t\t\t\tstore.state AS state,\r\n\t\t\t\t\t\t\t\tstore.category AS category,\r\n\t\t\t\t\t\t\t\tstore.storeno AS storeNo,\t\t\t\t\t\t\t\t\r\n\t\t\t\t\t\t\t\tRTRIM(LTRIM(REPLACE(REPLACE(REPLACE(store.store_name, char(13), ' '), char(10), ' '),',',''))) as store_Name ,\r\n\t\t\t\t\t\t\t\tCASE\r\n\t\t\t\t\t\t\t\t\tWHEN doc_type = 0 THEN 'Sales Return'\r\n\t\t\t\t\t\t\t\t\twhen doc_type = 1 THEN 'Debit Note'\r\n\t\t\t\t\t\t\t\t\tWHEN doc_type = 2 THEN 'Credit Note'\r\n\t\t\t\t\t\t\t\tEND\tAS returnType,\r\n\t\t\t\t\t\t\t\tdoc_type AS doc_Type,\r\n\t\t\t\t\t\t\t\taccnh.doc_date AS doc_Date,\r\n\t\t\t\t\t\t\t\t--~~~~~~~~~~~ tushar 12-01-2024 Gid.: 694\r\n\t\t\t\t\t\t\t\t--isnull(accnh.doc_pm_id,0) AS dOC_PM_Id,\r\n\t\t\t\t\t\t\t\t--isnull(patim.pm_fullname,'') AS pm_Fullname,\r\n\t\t\t\t\t\t\t\tCASE\r\n\t\t\t\t\t\t\t\t\tWHEN doc_type = 1 THEN isnull(cast(accnh.DOC_Cust_Code AS varchar),'')\r\n\t\t\t\t\t\t\t\t\tELSE isnull(cast(accnh.doc_pm_id AS varchar),'')\r\n\t\t\t\t\t\t\t\tEND\tAS dOC_PM_Id,\r\n\t\t\t\t\t\t\t\tCASE\r\n\t\t\t\t\t\t\t\t\tWHEN doc_type = 1 THEN isnull(cast(supplierstore.Store_Name AS varchar),'')\r\n\t\t\t\t\t\t\t\t\tELSE isnull(patim.pm_fullname,'')\r\n\t\t\t\t\t\t\t\tEND\tAS pm_Fullname,\r\n\t\t\t\t\t\t\t\t--~~~~~~~~~~~ Gid.: 694 \r\n\t\t\t\t\t\t\t\tisnull(m.mm_code,'') AS mm_code,\r\n\t\t\t\t\t\t\t\tisnull(m.mm_name ,'') AS mm_Name,\r\n\t\t\t\t\t\t\t\tisnull(accnd.docd_batchno,'') AS docd_BatchNo,\r\n\t\t\t\t\t\t\t\tisnull(accnd.docd_expdate,NULL) AS docd_ExpDate,\r\n\t\t\t\t\t\t\t\tisnull(m.mm_packsize,0) AS mM_PackSize,\r\n\t\t\t\t\t\t\t\t(m.mm_hsncode) AS mm_HsnCode,\r\n\t\t\t\t\t\t\t\tCASE\r\n\t\t\t\t\t\t\t\t WHEN accnh.doc_type = 0 THEN sih.sih_no\r\n\t\t\t\t\t\t\t\t WHEN accnh.doc_type = 1 THEN pih.pih_no\r\n\t\t\t\t\t\t\t\t WHEN accnh.doc_type = 2 THEN sihcredi.sih_no\r\n\t\t\t\t\t\t\t\tEND AS invoiceRefNo,\r\n\t\t\t\t\t\t\t\tCASE\r\n\t\t\t\t\t\t\t\t WHEN accnh.doc_type = 0 THEN isnull(sid.sid_salesqty,0) + isnull(sid.sid_free_qty,0) + isnull( sid.sid_schemeqty,0)\r\n\t\t\t\t\t\t\t\t WHEN accnh.doc_type = 1 THEN isnull(pid.pid_qty,0) + isnull(pid.pid_freeqty,0)\r\n\t\t\t\t\t\t\t\t --~~~~Start Nidhi 13/03/2024 #708\r\n\t\t\t\t\t\t\t\t --WHEN accnh.doc_type = 2 THEN isnull(sid.sid_salesqty,0) + isnull(sid.sid_free_qty,0) + isnull( sid.sid_schemeqty,0)\r\n\t\t\t\t\t\t\t\t WHEN accnh.doc_type = 2 THEN isnull(sidcredi.sid_salesqty,0) + isnull(sidcredi.sid_free_qty,0) + isnull( sidcredi.sid_schemeqty,0)\r\n\t\t\t\t\t\t\t\t\t--~~~~End Nidhi 13/03/2024 #708\r\n\r\n\t\t\t\t\t\t\t\tEND AS invoiceQty,\r\n\t\t\t\t\t\t\t\tsum(isnull(accnd.docd_qty,0) + isnull(accnd.docd_freeqty,0))\tAS returnQty,\r\n\t\t\t\t\t\t\t\tisnull (pid.pid_rate,m.mm_purrate) AS purchaserate,\r\n\t\t\t\t\t\t\t\t((accnd.Docd_Mrp - accnd.Docd_Mrp * (isnull(accnd.docd_sgst_per,0) + isnull(accnd.docd_cgst_per,0) + isnull(accnd.docd_igst_per,0) +isnull(docd_cess_per,0))/100) ) AS salesRate,\r\n\t\t\t\t\t\t\t\tisnull(accnd.Docd_Mrp,0)\tAS stk_Mrp,\r\n\t\t\t\t\t\t\t\tcast(docd_disc AS numeric(18,2))\tAS docd_Disc,\r\n\t\t\t\t\t\t\t\tcast(docd_discamount AS numeric(18,2)) AS docd_DiscAmount,\r\n\t\t\t\t\t\t\t\t(accnd.docd_subtotal )\t\t\t\tAS dOCd_subTotal,\r\n\t\t\t\t\t\t\t\tisnull(accnd.docd_sgst_per,0) + isnull(accnd.docd_cgst_per,0) + isnull(accnd.docd_igst_per,0) +isnull(docd_cess_per,0) AS taxper,\r\n\t\t\t\t\t\t\t\t(accnd.docd_taxtotal ) AS docd_TaxTotal,\r\n\t\t\t\t\t\t\t\t(accnd.docd_total ) AS docd_Total --,COUNT(1) OVER() AS totalRecord\r\n\t\t FROM\t\t\t[dbo].accountnoteheader (nolock) accnh\r\n\t\t INNER JOIN\t\t[dbo].accountnotedetails (nolock) accnd\r\n\t\t ON\t\t\t\taccnh.doc_id = accnd.docd_docid\r\n\t\t INNER JOIN\t\t[dbo].store_detail (nolock) store\r\n\t\t ON\t\t\t\tstore.storeno = accnh.doc_store_code\r\n\t\t\t\t --~~~~~~~~~~~ tushar 12-01-2024 Gid.: 694\r\n\t\t\t\t LEFT JOIN\t\t[dbo].store_detail (nolock) supplierstore\r\n\t\t ON\t\t\t\tsupplierstore.storeno = accnh.DOC_Cust_Code\r\n\t\t\t\t --~~~~~~~~~~~ Gid.: 694\r\n\t\t LEFT JOIN\t\t[dbo].patientmaster_pos (nolock) patim\r\n\t\t ON\t\t\t\tpatim.pm_id = accnh.doc_pm_id\r\n\t\t AND\t\t\taccnh.doc_store_code = patim.store_code\r\n\t\t INNER JOIN\t\t[dbo].medicinemaster(nolock) m\r\n\t\t ON\t\t\t\tm.mm_code = accnd.docd_mmcode\r\n\t\t LEFT JOIN\t\t[dbo].[SalesIn","method":"","class_name":"11","line_number":"0","time":"2024-05-09 14:56:42","error_code":"-2","procedure":"","server":"SERVER04","stack_trace":"at Ethics.HelperModules.DataContext.SqlDapperHelper.d__17`1.MoveNext()\r\n--- End of stack trace from previous location where exception was thrown ---\r\n at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()\r\n at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)\r\n at System.Runtime.CompilerServices.TaskAwaiter`1.GetResult()\r\n at BPPI.CPOS.BAL.Common.CommonRepositories.d__20.MoveNext() in D:\\DPC15\\GIT Repository\\ZOTA\\CPOS_API\\ZOTA.CPOS.BAL\\Common\\CommonRepositories.cs:line 433\r\n--- End of stack trace from previous location where exception was thrown ---\r\n at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()\r\n at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)\r\n at System.Runtime.CompilerServices.TaskAwaiter`1.GetResult()\r\n at BPPI.CPOS.API.Controllers.CommonController.d__3.MoveNext() in D:\\DPC15\\GIT Repository\\ZOTA\\CPOS_API\\ZOTA.CPOS.API\\Controllers\\CommonController.cs:line 72","priority":"medium","version_no":null,"app_version_no":null,"reccurence_count":1} , {"store_code":"","client_code":"","source":".Net SqlClient Data Provider","message":"Invalid object name 'cPOS_SALES_DATA..ApiConfiguration'.","method":"","class_name":"16","line_number":"9","time":"2024-05-09 15:10:22","error_code":"208","procedure":"SP_VALIDATE_API_KEY","server":"SERVER04","stack_trace":"at BPPI.CPOS.DAL.APIHelper.ValidateAPIKey(Int32 APIId, String APIKey) in D:\\DPC15\\GIT Repository\\ZOTA\\CPOS_API\\ZOTA.CPOS.DAL\\SqlHelperDbSalesData.cs:line 183\r\n at BPPI.CPOS.API.Controllers.StoreController.d__39.MoveNext() in D:\\DPC15\\GIT Repository\\ZOTA\\CPOS_API\\ZOTA.CPOS.API\\Controllers\\StoreController.cs:line 781","priority":"medium","version_no":null,"app_version_no":null,"reccurence_count":1} , {"store_code":"","client_code":"","source":"","message":"Data Not Found. SyncId:15","method":"","class_name":"","line_number":"","time":"2024-05-09 15:39: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 column name 'IsZotaSalesInvoice'.\r\n\r\n\t\t\t\t\t\t\t\t\t\tSELECT \r\n\t\t\t\t\t\t\t\t\t\t\t\tTotalRecord = COUNT(1) OVER(), \t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\r\n\t\t\t\t\t\t\t\t\t\t\t\tsd.Category,\r\n\t\t\t\t\t\t\t\t\t\t\t\tSIH.[Sih_Store_Code],\r\n\t\t\t\t\t\t\t\t\t\t\t\tsd.Store_Name,\r\n\t\t\t\t\t\t\t\t\t\t\t\tSIH.[Sih_Date],\r\n\t\t\t\t\t\t\t\t\t\t\t\tSIH.[Sih_No],\r\n\t\t\t\t\t\t\t\t\t\t\t\tSIH.Sih_DiscAmount, \r\n\t\t\t\t\t\t\t\t\t\t\t\tSumSih_SubTotal = CAST(SUM(ISNULL(SIH.[Sih_SubTotal],0)) OVER() AS DECIMAL),\r\n\t\t\t\t\t\t\t\t\t\t\t\tSumTotal_Tax = CAST(SUM(ISNULL(SIH.[Sih_Total_Tax],0)) OVER() AS DECIMAL),\r\n\t\t\t\t\t\t\t\t\t\t\t\tSumSih_Total = CAST(SUM(ISNULL(SIH.[Sih_Total],0)) OVER() AS DECIMAL),\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\r\n\t\t\t\t\t\t\t\t\t\t\t\tSIH.[Sih_Key],\t\t\t\t\t\t\r\n\t\t\t\t\t\t\t\t\t\t\t SIH.[Sih_Sales_Order_No],\r\n\t\t\t\t\t\t\t\t\t\t\t\tSIH.[Sih_Po_No],\r\n\t\t\t\t\t\t\t\t\t\t\t\tISNULL(SIH.[Sih_SubTotal],0) AS Sih_SubTotal,\r\n\t\t\t\t\t\t\t\t\t\t\t\tSIH.[Sih_Total],\t\t\t\t\t\t\t\t\t\t\t\t\r\n\t\t\t\t\t\t\t\t\t\t\t\tSIH.[Sih_Total_Tax],\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\r\n\t\t\t\t\t\t\t\t\t\t\t\tSIH.[Sih_Total] AS sih_TotalPay,\r\n\t\t\t\t\t\t\t\t\t\t\t\tCASE WHEN sd.Isactive = 1 THEN 'Y' ELSE 'N' END AS IsActive\r\n\t\t\t\t\t\t\t\t\t\tFROM SalesInvoiceHeader_POS (NOLOCK) SIH\r\n\t\t\t\t\t\t\t\t\t\tINNER JOIN Store_Detail (NOLOCK) sd \r\n\t\t\t\t\t\t\t\t\t\tON\t\t sd.StoreNo = SIH.Sih_Store_Code\r\n\t\t\t\t\t\t\t\t\t\tWHERE ISNULL(sd.IsZotaStore,0)=1 \r\n\t\t\t\t\t\t\t\t\t\t\t AND ISNULL(SIH.IsZotaSalesInvoice,0)=1 AND 1=1 ORDER BY Sih_Date desc\r\n\t\tOFFSET @PageSize * (@PageNumber - 1) ROWS\r\n\t\tFETCH NEXT @PageSize ROWS ONLY;","method":"","class_name":"16","line_number":"25","time":"2024-05-09 16:09:13","error_code":"207","procedure":"","server":"SERVER04","stack_trace":"at Ethics.HelperModules.DataContext.SqlDapperHelper.d__17`1.MoveNext()\r\n--- End of stack trace from previous location where exception was thrown ---\r\n at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()\r\n at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)\r\n at System.Runtime.CompilerServices.TaskAwaiter`1.GetResult()\r\n at BPPI.CPOS.BAL.Common.CommonRepositories.d__23.MoveNext() in D:\\DPC15\\GIT Repository\\ZOTA\\CPOS_API\\ZOTA.CPOS.BAL\\Common\\CommonRepositories.cs:line 548\r\n--- End of stack trace from previous location where exception was thrown ---\r\n at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()\r\n at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)\r\n at System.Runtime.CompilerServices.TaskAwaiter`1.GetResult()\r\n at BPPI.CPOS.BAL.Common.CommonRepositories.d__20.MoveNext() in D:\\DPC15\\GIT Repository\\ZOTA\\CPOS_API\\ZOTA.CPOS.BAL\\Common\\CommonRepositories.cs:line 436\r\n--- End of stack trace from previous location where exception was thrown ---\r\n at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()\r\n at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)\r\n at System.Runtime.CompilerServices.TaskAwaiter`1.GetResult()\r\n at BPPI.CPOS.API.Controllers.CommonController.d__3.MoveNext() in D:\\DPC15\\GIT Repository\\ZOTA\\CPOS_API\\ZOTA.CPOS.API\\Controllers\\CommonController.cs:line 72","priority":"medium","version_no":null,"app_version_no":null,"reccurence_count":1} , {"store_code":"","client_code":"","source":".Net SqlClient Data Provider","message":"Invalid object name 'cPOS_SALES_DATA..ApiConfiguration'.","method":"","class_name":"16","line_number":"9","time":"2024-05-09 16:29:00","error_code":"208","procedure":"SP_VALIDATE_API_KEY","server":"SERVER04","stack_trace":"at BPPI.CPOS.DAL.APIHelper.ValidateAPIKey(Int32 APIId, String APIKey) in D:\\DPC15\\GIT Repository\\ZOTA\\CPOS_API\\ZOTA.CPOS.DAL\\SqlHelperDbSalesData.cs:line 183\r\n at BPPI.CPOS.API.Controllers.StoreController.d__39.MoveNext() in D:\\DPC15\\GIT Repository\\ZOTA\\CPOS_API\\ZOTA.CPOS.API\\Controllers\\StoreController.cs:line 781","priority":"medium","version_no":null,"app_version_no":null,"reccurence_count":1} , {"store_code":"","client_code":"","source":".Net SqlClient Data Provider","message":"Invalid object name 'cPOS_SALES_DATA..ApiConfiguration'.","method":"","class_name":"16","line_number":"9","time":"2024-05-09 16:29:07","error_code":"208","procedure":"SP_VALIDATE_API_KEY","server":"SERVER04","stack_trace":"at BPPI.CPOS.DAL.APIHelper.ValidateAPIKey(Int32 APIId, String APIKey) in D:\\DPC15\\GIT Repository\\ZOTA\\CPOS_API\\ZOTA.CPOS.DAL\\SqlHelperDbSalesData.cs:line 183\r\n at BPPI.CPOS.API.Controllers.StoreController.d__39.MoveNext() in D:\\DPC15\\GIT Repository\\ZOTA\\CPOS_API\\ZOTA.CPOS.API\\Controllers\\StoreController.cs:line 781","priority":"medium","version_no":null,"app_version_no":null,"reccurence_count":1} , {"store_code":"","client_code":"","source":"","message":"Data Not Found. SyncId:15","method":"","class_name":"","line_number":"","time":"2024-05-09 16:39:03","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":"2024-05-09 17:37:01","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.b__0() in D:\\DPC15\\GIT Repository\\ZOTA\\CPOS_API\\ZOTA.CPOS.API\\Controllers\\UploadFileController.cs:line 208\r\n at System.Threading.Tasks.Task`1.InnerInvoke()\r\n at System.Threading.Tasks.Task.Execute()\r\n--- End of stack trace from previous location where exception was thrown ---\r\n at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()\r\n at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)\r\n at System.Runtime.CompilerServices.TaskAwaiter`1.GetResult()\r\n at BPPI.CPOS.API.Controllers.UploadFileController.d__8.MoveNext() in D:\\DPC15\\GIT Repository\\ZOTA\\CPOS_API\\ZOTA.CPOS.API\\Controllers\\UploadFileController.cs:line 202","priority":"medium","version_no":null,"app_version_no":null,"reccurence_count":1} , {"store_code":"","client_code":"","source":"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":"2024-05-09 17:42:28","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.b__0() in D:\\DPC15\\GIT Repository\\ZOTA\\CPOS_API\\ZOTA.CPOS.API\\Controllers\\UploadFileController.cs:line 208\r\n at System.Threading.Tasks.Task`1.InnerInvoke()\r\n at System.Threading.Tasks.Task.Execute()\r\n--- End of stack trace from previous location where exception was thrown ---\r\n at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()\r\n at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)\r\n at System.Runtime.CompilerServices.TaskAwaiter`1.GetResult()\r\n at BPPI.CPOS.API.Controllers.UploadFileController.d__8.MoveNext() in D:\\DPC15\\GIT Repository\\ZOTA\\CPOS_API\\ZOTA.CPOS.API\\Controllers\\UploadFileController.cs:line 202","priority":"medium","version_no":null,"app_version_no":null,"reccurence_count":1} , {"store_code":"","client_code":"","source":".Net SqlClient Data Provider","message":"Invalid object name 'cPOS_SALES_DATA..ApiConfiguration'.","method":"","class_name":"16","line_number":"9","time":"2024-05-09 17:44:21","error_code":"208","procedure":"SP_VALIDATE_API_KEY","server":"SERVER04","stack_trace":"at BPPI.CPOS.DAL.APIHelper.ValidateAPIKey(Int32 APIId, String APIKey) in D:\\DPC15\\GIT Repository\\ZOTA\\CPOS_API\\ZOTA.CPOS.DAL\\SqlHelperDbSalesData.cs:line 183\r\n at BPPI.CPOS.API.Controllers.StoreController.d__39.MoveNext() in D:\\DPC15\\GIT Repository\\ZOTA\\CPOS_API\\ZOTA.CPOS.API\\Controllers\\StoreController.cs:line 781","priority":"medium","version_no":null,"app_version_no":null,"reccurence_count":1} , {"store_code":"","client_code":"","source":"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":"2024-05-09 17:44:27","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.b__0() in D:\\DPC15\\GIT Repository\\ZOTA\\CPOS_API\\ZOTA.CPOS.API\\Controllers\\UploadFileController.cs:line 208\r\n at System.Threading.Tasks.Task`1.InnerInvoke()\r\n at System.Threading.Tasks.Task.Execute()\r\n--- End of stack trace from previous location where exception was thrown ---\r\n at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()\r\n at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)\r\n at System.Runtime.CompilerServices.TaskAwaiter`1.GetResult()\r\n at BPPI.CPOS.API.Controllers.UploadFileController.d__8.MoveNext() in D:\\DPC15\\GIT Repository\\ZOTA\\CPOS_API\\ZOTA.CPOS.API\\Controllers\\UploadFileController.cs:line 202","priority":"medium","version_no":null,"app_version_no":null,"reccurence_count":1} , {"store_code":"","client_code":"","source":"","message":"Data Not Found. SyncId:15","method":"","class_name":"","line_number":"","time":"2024-05-09 17:45:00","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":"2024-05-09 17:45:30","error_code":"-2","procedure":"","server":"SERVER04","stack_trace":"at Ethics.HelperModules.DataContext.SqlServerHelper.DbDataSet(String commandText, List`1 param, CommandType cmd)\r\n at Ethics.HelperModules.SyncLogic.SyncSqlDataClientRepository.prepareSyncDataToSend(Object id, String status)\r\n at Ethics.HelperModules.SyncLogic.SyncSqlDataClientRepository.GetCPOSSyncData(String storeCode)\r\n at ZOTA.CPOS.BAL.SyncServices.SyncRepositories.<>c__DisplayClass4_0.b__0() in D:\\DPC15\\GIT Repository\\ZOTA\\CPOS_API\\ZOTA.CPOS.BAL\\SyncServices\\SyncRepositories.cs:line 57\r\n at System.Threading.Tasks.Task.Execute()\r\n--- End of stack trace from previous location where exception was thrown ---\r\n at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()\r\n at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)\r\n at System.Runtime.CompilerServices.TaskAwaiter.GetResult()\r\n at ZOTA.CPOS.BAL.SyncServices.SyncRepositories.d__4.MoveNext() in D:\\DPC15\\GIT Repository\\ZOTA\\CPOS_API\\ZOTA.CPOS.BAL\\SyncServices\\SyncRepositories.cs:line 51\r\n--- End of stack trace from previous location where exception was thrown ---\r\n at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()\r\n at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)\r\n at System.Runtime.CompilerServices.TaskAwaiter`1.GetResult()\r\n at ZOTA.CPOS.BAL.SyncServices.SyncRepositories.d__3.MoveNext() in D:\\DPC15\\GIT Repository\\ZOTA\\CPOS_API\\ZOTA.CPOS.BAL\\SyncServices\\SyncRepositories.cs:line 33\r\n--- End of stack trace from previous location where exception was thrown ---\r\n at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()\r\n at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)\r\n at System.Runtime.CompilerServices.TaskAwaiter`1.GetResult()\r\n at BPPI.CPOS.API.Controllers.SyncController.d__10.MoveNext() in D:\\DPC15\\GIT Repository\\ZOTA\\CPOS_API\\ZOTA.CPOS.API\\Controllers\\SyncController.cs:line 224\r\n--- End of stack trace from previous location where exception was thrown ---\r\n at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()\r\n at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)\r\n at System.Runtime.CompilerServices.TaskAwaiter`1.GetResult()\r\n at BPPI.CPOS.API.Controllers.SyncController.d__2.MoveNext() in D:\\DPC15\\GIT Repository\\ZOTA\\CPOS_API\\ZOTA.CPOS.API\\Controllers\\SyncController.cs:line 26","priority":"medium","version_no":null,"app_version_no":null,"reccurence_count":1} , {"store_code":"","client_code":"","source":".Net SqlClient Data Provider","message":"Invalid object name 'cPOS_SALES_DATA..ApiConfiguration'.","method":"","class_name":"16","line_number":"9","time":"2024-05-09 18:31:02","error_code":"208","procedure":"SP_VALIDATE_API_KEY","server":"SERVER04","stack_trace":"at BPPI.CPOS.DAL.APIHelper.ValidateAPIKey(Int32 APIId, String APIKey) in D:\\DPC15\\GIT Repository\\ZOTA\\CPOS_API\\ZOTA.CPOS.DAL\\SqlHelperDbSalesData.cs:line 183\r\n at BPPI.CPOS.API.Controllers.StoreController.d__39.MoveNext() in D:\\DPC15\\GIT Repository\\ZOTA\\CPOS_API\\ZOTA.CPOS.API\\Controllers\\StoreController.cs:line 781","priority":"medium","version_no":null,"app_version_no":null,"reccurence_count":1} , {"store_code":"","client_code":"","source":".Net SqlClient Data Provider","message":"Invalid object name 'cPOS_SALES_DATA..ApiConfiguration'.","method":"","class_name":"16","line_number":"9","time":"2024-05-09 18:31:09","error_code":"208","procedure":"SP_VALIDATE_API_KEY","server":"SERVER04","stack_trace":"at BPPI.CPOS.DAL.APIHelper.ValidateAPIKey(Int32 APIId, String APIKey) in D:\\DPC15\\GIT Repository\\ZOTA\\CPOS_API\\ZOTA.CPOS.DAL\\SqlHelperDbSalesData.cs:line 183\r\n at BPPI.CPOS.API.Controllers.StoreController.d__39.MoveNext() in D:\\DPC15\\GIT Repository\\ZOTA\\CPOS_API\\ZOTA.CPOS.API\\Controllers\\StoreController.cs:line 781","priority":"medium","version_no":null,"app_version_no":null,"reccurence_count":1} , {"store_code":"","client_code":"","source":"","message":"Data Not Found. SyncId:15","method":"","class_name":"","line_number":"","time":"2024-05-09 18:45:23","error_code":"","procedure":"","server":"","stack_trace":"","priority":"","version_no":null,"app_version_no":null,"reccurence_count":1} ,