{"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-10-24 11:23:20","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.<GetStoreStatus>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":"System.Data","message":"Cannot find table 2.","method":"","class_name":"","line_number":"","time":"2024-10-24 11:23:57","error_code":"","procedure":"","server":"","stack_trace":"at System.Data.DataTableCollection.get_Item(Int32 index)\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:\\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.<ProcessCposToPos>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.<ProcessSyncData>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.<SyncProcess>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.<SyncPOS>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":"","message":"Data Not Found. SyncId:15","method":"","class_name":"","line_number":"","time":"2024-10-24 11:23:57","error_code":"","procedure":"","server":"","stack_trace":"","priority":"","version_no":null,"app_version_no":null,"reccurence_count":1}
,
{"store_code":"","client_code":"","source":"System.Data","message":"Cannot find table 2.","method":"","class_name":"","line_number":"","time":"2024-10-24 12:23:57","error_code":"","procedure":"","server":"","stack_trace":"at System.Data.DataTableCollection.get_Item(Int32 index)\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:\\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.<ProcessCposToPos>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.<ProcessSyncData>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.<SyncProcess>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.<SyncPOS>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":"","message":"Data Not Found. SyncId:15","method":"","class_name":"","line_number":"","time":"2024-10-24 12:23:57","error_code":"","procedure":"","server":"","stack_trace":"","priority":"","version_no":null,"app_version_no":null,"reccurence_count":1}
,
{"store_code":"","client_code":"","source":".Net SqlClient Data Provider","message":"Execution Timeout Expired.  The timeout period elapsed prior to completion of the operation or the server is not responding.\r\nSELECT *,COUNT(1) OVER() AS TotalRecord FROM (\r\n\t\t\tSELECT\t\tPOH.Po_Key,\r\n\t\t\t\t\t\tPOH.Po_Ven_Code\t\t\t\t\tAS po_Ven_Code,\r\n\t\t\t\t\t\tPOH.Po_Store_Code\t\t\tAS po_Store_Code,\r\n\t\t\t\t\t\tREPLACE(REPLACE(LTRIM(RTRIM(SDR.Store_Name)), char(13), ' '), char(10), ' ') AS store_Name,\r\n\t\t\t\t\t\t/*------~~~~~~ GID: 837 Nidhi 25/06/2024 ~~~~~~----  */\r\n\t\t\t\t\t\tSDR.State,\r\n\t\t\t\t\t\tSDR.Category,\r\n\t\t\t\t\t\t/*------~~~~~~ GID: 837 ~~~~~----*/\r\n\t\t\t\t\t\tPOH.Po_No\t\t\t\t\t\tAS po_No,\r\n\t\t\t\t\t\tCAST(POH.Po_Date AS DATE)\t\tAS po_Date,\r\n\t\t\t\t\t\tREPLACE(POD.Mm_Code,',','|')\tAS mm_Code,\r\n\t\t\t\t\t\tREPLACE(POD.Pi_ItemName,',','|') AS pi_ItemName,\r\n\t\t\t\t\t\tPOD.Pi_Qty\t\t\t\t\t\tAS pi_Qty,\r\n\t\t\t\t\t\tPOD.Pi_Rate\t\t\t\t\t\tAS pi_Rate,\r\n\t\t\t\t\t\tCAST(ISNULL((ISNULL(POD.Pi_Rate,0) * ISNULL(POD.Pi_Qty,0)),0) AS numeric(18,2))AS pi_Net_Amt,\r\n\t\t\t\t\t\t--POD.Pi_Net_Amt\t\t\t\t\tAS pi_Net_Amt,\r\n\r\n\t\t\t\t\t\t--~~~~~~~~~~~~~~~~~~~Tuhsar 26-02-2024 Gid:736\r\n\t\t\t\t\t\t--(CASE WHEN SUBSTRING(POH.Po_Ven_Code,1,1) = 'H' THEN SUM(ISNULL(MSD.qty,0)) ELSE SUM(ISNULL(STK.Pms_Qty,0))END) AS orderTimeAvailableStock,\r\n\t\t\t\t\t\tSUM(ISNULL(STK.Pms_Qty,0)) AS orderTimeAvailableStock,\r\n\t\t\t\t\t\t--~~~~~~~~~~~~~~~~~~~Gid:736\r\n\r\n\t\t\t\t\t\t--SUM(ISNULL(STK.Pms_Qty,MSD.qty)) AS orderTimeAvailableStock,\r\n\r\n\t\t\t\t\t\tSIDetail.Sih_No AS sih_No,\r\n\t\t\t\t\t\tCAST(SIDetail.Sih_Date AS DATE) AS sih_Date,\r\n\t\t\t\t\t\tSIDetail.Sid_Qty AS sid_Qty,\r\n\t\t\t\t\t\tSIDetail.Sid_Batch_No AS sid_Batch_No,\r\n\t\t\t\t\t\tCAST(SIDetail.Sid_ExpDate AS DATE) sid_ExpDate,\r\n\t\t\t\t\t\tSIDetail.Sid_Item_Rate AS sid_Item_Rate,\r\n\t\t\t\t\t\tCAST((ISNULL(SIDetail.Sid_Item_Rate,0) * ISNULL(SIDetail.Sid_Qty,0)) AS numeric(18,2))AS sid_Total,\r\n\t\t\t\t\t\t--SIDetail.Sid_Total AS sid_Total,\r\n\t\t\t\t\t\tCAST((ISNULL(POD.Pi_Qty,0)-ISNULL(SIDetail.Sid_Qty,0))  AS NUMERIC(18,2))   AS bounceQty,\r\n\t\t\t\t\t\tcast((case when (SIDetail.Sid_Item_Rate > 0) \r\n\t\t\t\t\t\tthen SIDetail.Sid_Item_Rate\r\n\t\t\t\t\t\telse ISNULL(POD.Pi_Rate,0) end) *  (isnull(POD.Pi_Qty,0)-isnull(SIDetail.Sid_Qty,0))  as numeric(18,2))  as bounceAmount\r\n\t\t\tFROM\t\tPoItemDetails (NOLOCK) POD\r\n\t\t\t\tINNER JOIN PoHeader (NOLOCK) POH\r\n\t\t\tON\t\t\tPOD.PI_PO_ID = POH.ID\r\n\t\t\t\t\tAND ISNULL(POH.PO_IsZotaStore,0)=0\r\n\t\t\t\t\tAND POH.Po_Store_Code NOT LIKE '%ZOTA%'\r\n\t\t\t\tLEFT JOIN Store_Detail (NOLOCK) SDR\r\n\t\t\tON\t\t\tSDR.StoreNo = POH.Po_Store_Code\r\n\t\t\t\t\tAND ISNULL(SDR.IsZotaStore,0) = 0\r\n\t\t\t\tLEFT JOIN(\r\n\t\t\t\t\t\tSELECT\t\tSIHP.Sih_Store_Code\t\t\tAS Sih_Store_Code,\r\n\t\t\t\t\t\t\t\t\tSIHP.Sih_Cust_Code\t\t\tAS Sih_Cust_Code,\r\n\t\t\t\t\t\t\t\t\tISNULL(SIHP.sih_pokeys,'')\tAS Sih_Pokeys,\r\n\t\t\t\t\t\t\t\t\t--~~~~~~~~~~ Rahul 05-06-2024 GID:822\r\n\t\t\t\t\t\t\t\t\t--SIHP.Sih_No\t\t\t\t\tAS Sih_No,\r\n\t\t\t\t\t\t\t\t\tCASE WHEN ISNULL(SIHP.Sih_No_New,'') <> '' THEN SIHP.Sih_No_New ELSE CAST(SIHP.Sih_No AS VARCHAR) END AS Sih_No,  \r\n\t\t\t\t\t\t\t\t\t--~~~~~~~~~~  GID:822\r\n\t\t\t\t\t\t\t\t\tSIHP.Sih_Date\t\t\t\tAS Sih_Date,\r\n\t\t\t\t\t\t\t\t\t[SIDP].Mm_Code\t\t\t\tAS Sid_Item_Code,\r\n\t\t\t\t\t\t\t\t\t[SIDP].Sid_SalesQty\t\t\tAS Sid_Qty,\r\n\t\t\t\t\t\t\t\t\t[SIDP].Sid_BatchNo\t\t\tAS Sid_Batch_No,\r\n\t\t\t\t\t\t\t\t\t[SIDP].Sid_ExpDate\t\t\tAS Sid_ExpDate,\r\n\t\t\t\t\t\t\t\t\t[SIDP].Sid_SalesRate\t\tAS Sid_Item_Rate,\r\n\t\t\t\t\t\t\t\t\t[SIDP].Sid_Total\t\t\tAS Sid_Total,\r\n\t\t\t\t\t\t\t\t\t'DPOS'\t\t\t\t\tAS Sih_type\r\n\t\t\t\t\t\tFROM\t\tSalesInvoiceHeader_pos (NOLOCK) SIHP\r\n\t\t\t\t\t\t\t\tINNER JOIN [SalesInvoiceItemDetail_pos] (NOLOCK) [SIDP]\r\n\t\t\t\t\t\tON\t\t\t[SIDP].Sid_Sih_Id = SIHP.Id\r\n\t\t\t\t\t\tWHERE\t\tSIHP.Sih_Store_Code IN (SELECT StoreNo FROM Store_Detail (NOLOCK) WHERE Category ='STOCKIST' AND ISNULL(IsZotaStore,0) = 0 AND ISNULL(IsActive,0) = 1)\r\n\t\t\t\t\t\t\t\tAND ISNULL(SIHP.sih_pokeys,'') <> ''\r\n\t\t\t\t\t\t--~~~~~~~~~~~~~~~~~~~Tuhsar 26-02-2024 Gid:736\r\n\t\t\t\t\t\t--UNION ALL\r\n\t\t\t\t\t\t--SELECT\t\tSIH.Sih_Store_Code\t\t\tAS Sih_Store_Code,\r\n\t\t\t\t\t\t--\t\t\tCAST(''\tAS VARCHAR)\t\t\tAS Sih_Cust_Code,\r\n\t\t\t\t\t\t--\t\t\tISNULL(SIH.Sih_Pokeys,'')\tAS Sih_Pokeys,\r\n\t\t\t\t\t\t--\t\t\tSIH.Sih_No\t\t\t\t\tAS Sih_No,\r\n\t\t\t\t\t\t--\t\t\tSIH.Sih_Date\t\t\t\tAS Sih_Date,\r\n\t\t\t\t\t\t--\t\t\t[SID].Sid_Item_Code\t\t\tAS Sid_Item_Code,\r\n\t\t\t\t\t\t--\t\t\t[SID].Sid_Qty\t\t\t\tAS Sid_Qty,\r\n\t\t\t\t\t\t--\t\t\t[SID].Sid_Batch_No\t\t\tAS Sid_Batch_No,\r\n\t\t\t\t\t\t--\t\t\t[SID].Sid_ExpDate\t\t\tAS Sid_ExpDate,\r\n\t\t\t\t\t\t--\t\t\t[SID].Sid_Item_Rate\t\t\tAS Sid_Item_Rate,\r\n\t\t\t\t\t\t--\t\t\t[SID].Sid_Total\t\t\t\tAS Sid_Total,\r\n\t\t\t\t\t\t--\t\t\t'HO'\t\t\t\t\t\tAS Sih_type\r\n\t\t\t\t\t","method":"","class_name":"11","line_number":"0","time":"2024-10-24 13:10:15","error_code":"-2","procedure":"","server":"SERVER04","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.<DynamicFilter>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.<ExecuteReportData>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.<GetReportConfiguration>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":"Execution Timeout Expired.  The timeout period elapsed prior to completion of the operation or the server is not responding.\r\nSELECT *,COUNT(1) OVER() AS TotalRecord FROM (\r\n\t\t\tSELECT\t\tPOH.Po_Key,\r\n\t\t\t\t\t\tPOH.Po_Ven_Code\t\t\t\t\tAS po_Ven_Code,\r\n\t\t\t\t\t\tPOH.Po_Store_Code\t\t\tAS po_Store_Code,\r\n\t\t\t\t\t\tREPLACE(REPLACE(LTRIM(RTRIM(SDR.Store_Name)), char(13), ' '), char(10), ' ') AS store_Name,\r\n\t\t\t\t\t\t/*------~~~~~~ GID: 837 Nidhi 25/06/2024 ~~~~~~----  */\r\n\t\t\t\t\t\tSDR.State,\r\n\t\t\t\t\t\tSDR.Category,\r\n\t\t\t\t\t\t/*------~~~~~~ GID: 837 ~~~~~----*/\r\n\t\t\t\t\t\tPOH.Po_No\t\t\t\t\t\tAS po_No,\r\n\t\t\t\t\t\tCAST(POH.Po_Date AS DATE)\t\tAS po_Date,\r\n\t\t\t\t\t\tREPLACE(POD.Mm_Code,',','|')\tAS mm_Code,\r\n\t\t\t\t\t\tREPLACE(POD.Pi_ItemName,',','|') AS pi_ItemName,\r\n\t\t\t\t\t\tPOD.Pi_Qty\t\t\t\t\t\tAS pi_Qty,\r\n\t\t\t\t\t\tPOD.Pi_Rate\t\t\t\t\t\tAS pi_Rate,\r\n\t\t\t\t\t\tCAST(ISNULL((ISNULL(POD.Pi_Rate,0) * ISNULL(POD.Pi_Qty,0)),0) AS numeric(18,2))AS pi_Net_Amt,\r\n\t\t\t\t\t\t--POD.Pi_Net_Amt\t\t\t\t\tAS pi_Net_Amt,\r\n\r\n\t\t\t\t\t\t--~~~~~~~~~~~~~~~~~~~Tuhsar 26-02-2024 Gid:736\r\n\t\t\t\t\t\t--(CASE WHEN SUBSTRING(POH.Po_Ven_Code,1,1) = 'H' THEN SUM(ISNULL(MSD.qty,0)) ELSE SUM(ISNULL(STK.Pms_Qty,0))END) AS orderTimeAvailableStock,\r\n\t\t\t\t\t\tSUM(ISNULL(STK.Pms_Qty,0)) AS orderTimeAvailableStock,\r\n\t\t\t\t\t\t--~~~~~~~~~~~~~~~~~~~Gid:736\r\n\r\n\t\t\t\t\t\t--SUM(ISNULL(STK.Pms_Qty,MSD.qty)) AS orderTimeAvailableStock,\r\n\r\n\t\t\t\t\t\tSIDetail.Sih_No AS sih_No,\r\n\t\t\t\t\t\tCAST(SIDetail.Sih_Date AS DATE) AS sih_Date,\r\n\t\t\t\t\t\tSIDetail.Sid_Qty AS sid_Qty,\r\n\t\t\t\t\t\tSIDetail.Sid_Batch_No AS sid_Batch_No,\r\n\t\t\t\t\t\tCAST(SIDetail.Sid_ExpDate AS DATE) sid_ExpDate,\r\n\t\t\t\t\t\tSIDetail.Sid_Item_Rate AS sid_Item_Rate,\r\n\t\t\t\t\t\tCAST((ISNULL(SIDetail.Sid_Item_Rate,0) * ISNULL(SIDetail.Sid_Qty,0)) AS numeric(18,2))AS sid_Total,\r\n\t\t\t\t\t\t--SIDetail.Sid_Total AS sid_Total,\r\n\t\t\t\t\t\tCAST((ISNULL(POD.Pi_Qty,0)-ISNULL(SIDetail.Sid_Qty,0))  AS NUMERIC(18,2))   AS bounceQty,\r\n\t\t\t\t\t\tcast((case when (SIDetail.Sid_Item_Rate > 0) \r\n\t\t\t\t\t\tthen SIDetail.Sid_Item_Rate\r\n\t\t\t\t\t\telse ISNULL(POD.Pi_Rate,0) end) *  (isnull(POD.Pi_Qty,0)-isnull(SIDetail.Sid_Qty,0))  as numeric(18,2))  as bounceAmount\r\n\t\t\tFROM\t\tPoItemDetails (NOLOCK) POD\r\n\t\t\t\tINNER JOIN PoHeader (NOLOCK) POH\r\n\t\t\tON\t\t\tPOD.PI_PO_ID = POH.ID\r\n\t\t\t\t\tAND ISNULL(POH.PO_IsZotaStore,0)=0\r\n\t\t\t\t\tAND POH.Po_Store_Code NOT LIKE '%ZOTA%'\r\n\t\t\t\tLEFT JOIN Store_Detail (NOLOCK) SDR\r\n\t\t\tON\t\t\tSDR.StoreNo = POH.Po_Store_Code\r\n\t\t\t\t\tAND ISNULL(SDR.IsZotaStore,0) = 0\r\n\t\t\t\tLEFT JOIN(\r\n\t\t\t\t\t\tSELECT\t\tSIHP.Sih_Store_Code\t\t\tAS Sih_Store_Code,\r\n\t\t\t\t\t\t\t\t\tSIHP.Sih_Cust_Code\t\t\tAS Sih_Cust_Code,\r\n\t\t\t\t\t\t\t\t\tISNULL(SIHP.sih_pokeys,'')\tAS Sih_Pokeys,\r\n\t\t\t\t\t\t\t\t\t--~~~~~~~~~~ Rahul 05-06-2024 GID:822\r\n\t\t\t\t\t\t\t\t\t--SIHP.Sih_No\t\t\t\t\tAS Sih_No,\r\n\t\t\t\t\t\t\t\t\tCASE WHEN ISNULL(SIHP.Sih_No_New,'') <> '' THEN SIHP.Sih_No_New ELSE CAST(SIHP.Sih_No AS VARCHAR) END AS Sih_No,  \r\n\t\t\t\t\t\t\t\t\t--~~~~~~~~~~  GID:822\r\n\t\t\t\t\t\t\t\t\tSIHP.Sih_Date\t\t\t\tAS Sih_Date,\r\n\t\t\t\t\t\t\t\t\t[SIDP].Mm_Code\t\t\t\tAS Sid_Item_Code,\r\n\t\t\t\t\t\t\t\t\t[SIDP].Sid_SalesQty\t\t\tAS Sid_Qty,\r\n\t\t\t\t\t\t\t\t\t[SIDP].Sid_BatchNo\t\t\tAS Sid_Batch_No,\r\n\t\t\t\t\t\t\t\t\t[SIDP].Sid_ExpDate\t\t\tAS Sid_ExpDate,\r\n\t\t\t\t\t\t\t\t\t[SIDP].Sid_SalesRate\t\tAS Sid_Item_Rate,\r\n\t\t\t\t\t\t\t\t\t[SIDP].Sid_Total\t\t\tAS Sid_Total,\r\n\t\t\t\t\t\t\t\t\t'DPOS'\t\t\t\t\tAS Sih_type\r\n\t\t\t\t\t\tFROM\t\tSalesInvoiceHeader_pos (NOLOCK) SIHP\r\n\t\t\t\t\t\t\t\tINNER JOIN [SalesInvoiceItemDetail_pos] (NOLOCK) [SIDP]\r\n\t\t\t\t\t\tON\t\t\t[SIDP].Sid_Sih_Id = SIHP.Id\r\n\t\t\t\t\t\tWHERE\t\tSIHP.Sih_Store_Code IN (SELECT StoreNo FROM Store_Detail (NOLOCK) WHERE Category ='STOCKIST' AND ISNULL(IsZotaStore,0) = 0 AND ISNULL(IsActive,0) = 1)\r\n\t\t\t\t\t\t\t\tAND ISNULL(SIHP.sih_pokeys,'') <> ''\r\n\t\t\t\t\t\t--~~~~~~~~~~~~~~~~~~~Tuhsar 26-02-2024 Gid:736\r\n\t\t\t\t\t\t--UNION ALL\r\n\t\t\t\t\t\t--SELECT\t\tSIH.Sih_Store_Code\t\t\tAS Sih_Store_Code,\r\n\t\t\t\t\t\t--\t\t\tCAST(''\tAS VARCHAR)\t\t\tAS Sih_Cust_Code,\r\n\t\t\t\t\t\t--\t\t\tISNULL(SIH.Sih_Pokeys,'')\tAS Sih_Pokeys,\r\n\t\t\t\t\t\t--\t\t\tSIH.Sih_No\t\t\t\t\tAS Sih_No,\r\n\t\t\t\t\t\t--\t\t\tSIH.Sih_Date\t\t\t\tAS Sih_Date,\r\n\t\t\t\t\t\t--\t\t\t[SID].Sid_Item_Code\t\t\tAS Sid_Item_Code,\r\n\t\t\t\t\t\t--\t\t\t[SID].Sid_Qty\t\t\t\tAS Sid_Qty,\r\n\t\t\t\t\t\t--\t\t\t[SID].Sid_Batch_No\t\t\tAS Sid_Batch_No,\r\n\t\t\t\t\t\t--\t\t\t[SID].Sid_ExpDate\t\t\tAS Sid_ExpDate,\r\n\t\t\t\t\t\t--\t\t\t[SID].Sid_Item_Rate\t\t\tAS Sid_Item_Rate,\r\n\t\t\t\t\t\t--\t\t\t[SID].Sid_Total\t\t\t\tAS Sid_Total,\r\n\t\t\t\t\t\t--\t\t\t'HO'\t\t\t\t\t\tAS Sih_type\r\n\t\t\t\t\t","method":"","class_name":"11","line_number":"0","time":"2024-10-24 13:10:48","error_code":"-2","procedure":"","server":"SERVER04","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.<DynamicFilter>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.<ExecuteReportData>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.<GetReportConfiguration>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":"System.Data","message":"Cannot find table 2.","method":"","class_name":"","line_number":"","time":"2024-10-24 13:23:56","error_code":"","procedure":"","server":"","stack_trace":"at System.Data.DataTableCollection.get_Item(Int32 index)\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:\\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.<ProcessCposToPos>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.<ProcessSyncData>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.<SyncProcess>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.<SyncPOS>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":"","message":"Data Not Found. SyncId:15","method":"","class_name":"","line_number":"","time":"2024-10-24 13:23:56","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-10-24 13:57:28","error_code":"-2","procedure":"","server":"SERVER04","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.<DynamicFilter>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.<ExecuteReportData>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.<GetReportConfiguration>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":"System.Data","message":"Cannot find table 2.","method":"","class_name":"","line_number":"","time":"2024-10-24 14:23:25","error_code":"","procedure":"","server":"","stack_trace":"at System.Data.DataTableCollection.get_Item(Int32 index)\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:\\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.<ProcessCposToPos>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.<ProcessSyncData>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.<SyncProcess>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.<SyncPOS>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":"","message":"Data Not Found. SyncId:15","method":"","class_name":"","line_number":"","time":"2024-10-24 14:23: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":"Execution Timeout Expired.  The timeout period elapsed prior to completion of the operation or the server is not responding.\r\nSELECT *,COUNT(1) OVER() AS TotalRecord FROM (\r\n\t\t\tSELECT\t\tPOH.Po_Key,\r\n\t\t\t\t\t\tPOH.Po_Ven_Code\t\t\t\t\tAS po_Ven_Code,\r\n\t\t\t\t\t\tPOH.Po_Store_Code\t\t\tAS po_Store_Code,\r\n\t\t\t\t\t\tREPLACE(REPLACE(LTRIM(RTRIM(SDR.Store_Name)), char(13), ' '), char(10), ' ') AS store_Name,\r\n\t\t\t\t\t\t/*------~~~~~~ GID: 837 Nidhi 25/06/2024 ~~~~~~----  */\r\n\t\t\t\t\t\tSDR.State,\r\n\t\t\t\t\t\tSDR.Category,\r\n\t\t\t\t\t\t/*------~~~~~~ GID: 837 ~~~~~----*/\r\n\t\t\t\t\t\tPOH.Po_No\t\t\t\t\t\tAS po_No,\r\n\t\t\t\t\t\tCAST(POH.Po_Date AS DATE)\t\tAS po_Date,\r\n\t\t\t\t\t\tREPLACE(POD.Mm_Code,',','|')\tAS mm_Code,\r\n\t\t\t\t\t\tREPLACE(POD.Pi_ItemName,',','|') AS pi_ItemName,\r\n\t\t\t\t\t\tPOD.Pi_Qty\t\t\t\t\t\tAS pi_Qty,\r\n\t\t\t\t\t\tPOD.Pi_Rate\t\t\t\t\t\tAS pi_Rate,\r\n\t\t\t\t\t\tCAST(ISNULL((ISNULL(POD.Pi_Rate,0) * ISNULL(POD.Pi_Qty,0)),0) AS numeric(18,2))AS pi_Net_Amt,\r\n\t\t\t\t\t\t--POD.Pi_Net_Amt\t\t\t\t\tAS pi_Net_Amt,\r\n\r\n\t\t\t\t\t\t--~~~~~~~~~~~~~~~~~~~Tuhsar 26-02-2024 Gid:736\r\n\t\t\t\t\t\t--(CASE WHEN SUBSTRING(POH.Po_Ven_Code,1,1) = 'H' THEN SUM(ISNULL(MSD.qty,0)) ELSE SUM(ISNULL(STK.Pms_Qty,0))END) AS orderTimeAvailableStock,\r\n\t\t\t\t\t\tSUM(ISNULL(STK.Pms_Qty,0)) AS orderTimeAvailableStock,\r\n\t\t\t\t\t\t--~~~~~~~~~~~~~~~~~~~Gid:736\r\n\r\n\t\t\t\t\t\t--SUM(ISNULL(STK.Pms_Qty,MSD.qty)) AS orderTimeAvailableStock,\r\n\r\n\t\t\t\t\t\tSIDetail.Sih_No AS sih_No,\r\n\t\t\t\t\t\tCAST(SIDetail.Sih_Date AS DATE) AS sih_Date,\r\n\t\t\t\t\t\tSIDetail.Sid_Qty AS sid_Qty,\r\n\t\t\t\t\t\tSIDetail.Sid_Batch_No AS sid_Batch_No,\r\n\t\t\t\t\t\tCAST(SIDetail.Sid_ExpDate AS DATE) sid_ExpDate,\r\n\t\t\t\t\t\tSIDetail.Sid_Item_Rate AS sid_Item_Rate,\r\n\t\t\t\t\t\tCAST((ISNULL(SIDetail.Sid_Item_Rate,0) * ISNULL(SIDetail.Sid_Qty,0)) AS numeric(18,2))AS sid_Total,\r\n\t\t\t\t\t\t--SIDetail.Sid_Total AS sid_Total,\r\n\t\t\t\t\t\tCAST((ISNULL(POD.Pi_Qty,0)-ISNULL(SIDetail.Sid_Qty,0))  AS NUMERIC(18,2))   AS bounceQty,\r\n\t\t\t\t\t\tcast((case when (SIDetail.Sid_Item_Rate > 0) \r\n\t\t\t\t\t\tthen SIDetail.Sid_Item_Rate\r\n\t\t\t\t\t\telse ISNULL(POD.Pi_Rate,0) end) *  (isnull(POD.Pi_Qty,0)-isnull(SIDetail.Sid_Qty,0))  as numeric(18,2))  as bounceAmount\r\n\t\t\tFROM\t\tPoItemDetails (NOLOCK) POD\r\n\t\t\t\tINNER JOIN PoHeader (NOLOCK) POH\r\n\t\t\tON\t\t\tPOD.PI_PO_ID = POH.ID\r\n\t\t\t\t\tAND ISNULL(POH.PO_IsZotaStore,0)=0\r\n\t\t\t\t\tAND POH.Po_Store_Code NOT LIKE '%ZOTA%'\r\n\t\t\t\tLEFT JOIN Store_Detail (NOLOCK) SDR\r\n\t\t\tON\t\t\tSDR.StoreNo = POH.Po_Store_Code\r\n\t\t\t\t\tAND ISNULL(SDR.IsZotaStore,0) = 0\r\n\t\t\t\tLEFT JOIN(\r\n\t\t\t\t\t\tSELECT\t\tSIHP.Sih_Store_Code\t\t\tAS Sih_Store_Code,\r\n\t\t\t\t\t\t\t\t\tSIHP.Sih_Cust_Code\t\t\tAS Sih_Cust_Code,\r\n\t\t\t\t\t\t\t\t\tISNULL(SIHP.sih_pokeys,'')\tAS Sih_Pokeys,\r\n\t\t\t\t\t\t\t\t\t--~~~~~~~~~~ Rahul 05-06-2024 GID:822\r\n\t\t\t\t\t\t\t\t\t--SIHP.Sih_No\t\t\t\t\tAS Sih_No,\r\n\t\t\t\t\t\t\t\t\tCASE WHEN ISNULL(SIHP.Sih_No_New,'') <> '' THEN SIHP.Sih_No_New ELSE CAST(SIHP.Sih_No AS VARCHAR) END AS Sih_No,  \r\n\t\t\t\t\t\t\t\t\t--~~~~~~~~~~  GID:822\r\n\t\t\t\t\t\t\t\t\tSIHP.Sih_Date\t\t\t\tAS Sih_Date,\r\n\t\t\t\t\t\t\t\t\t[SIDP].Mm_Code\t\t\t\tAS Sid_Item_Code,\r\n\t\t\t\t\t\t\t\t\t[SIDP].Sid_SalesQty\t\t\tAS Sid_Qty,\r\n\t\t\t\t\t\t\t\t\t[SIDP].Sid_BatchNo\t\t\tAS Sid_Batch_No,\r\n\t\t\t\t\t\t\t\t\t[SIDP].Sid_ExpDate\t\t\tAS Sid_ExpDate,\r\n\t\t\t\t\t\t\t\t\t[SIDP].Sid_SalesRate\t\tAS Sid_Item_Rate,\r\n\t\t\t\t\t\t\t\t\t[SIDP].Sid_Total\t\t\tAS Sid_Total,\r\n\t\t\t\t\t\t\t\t\t'DPOS'\t\t\t\t\tAS Sih_type\r\n\t\t\t\t\t\tFROM\t\tSalesInvoiceHeader_pos (NOLOCK) SIHP\r\n\t\t\t\t\t\t\t\tINNER JOIN [SalesInvoiceItemDetail_pos] (NOLOCK) [SIDP]\r\n\t\t\t\t\t\tON\t\t\t[SIDP].Sid_Sih_Id = SIHP.Id\r\n\t\t\t\t\t\tWHERE\t\tSIHP.Sih_Store_Code IN (SELECT StoreNo FROM Store_Detail (NOLOCK) WHERE Category ='STOCKIST' AND ISNULL(IsZotaStore,0) = 0 AND ISNULL(IsActive,0) = 1)\r\n\t\t\t\t\t\t\t\tAND ISNULL(SIHP.sih_pokeys,'') <> ''\r\n\t\t\t\t\t\t--~~~~~~~~~~~~~~~~~~~Tuhsar 26-02-2024 Gid:736\r\n\t\t\t\t\t\t--UNION ALL\r\n\t\t\t\t\t\t--SELECT\t\tSIH.Sih_Store_Code\t\t\tAS Sih_Store_Code,\r\n\t\t\t\t\t\t--\t\t\tCAST(''\tAS VARCHAR)\t\t\tAS Sih_Cust_Code,\r\n\t\t\t\t\t\t--\t\t\tISNULL(SIH.Sih_Pokeys,'')\tAS Sih_Pokeys,\r\n\t\t\t\t\t\t--\t\t\tSIH.Sih_No\t\t\t\t\tAS Sih_No,\r\n\t\t\t\t\t\t--\t\t\tSIH.Sih_Date\t\t\t\tAS Sih_Date,\r\n\t\t\t\t\t\t--\t\t\t[SID].Sid_Item_Code\t\t\tAS Sid_Item_Code,\r\n\t\t\t\t\t\t--\t\t\t[SID].Sid_Qty\t\t\t\tAS Sid_Qty,\r\n\t\t\t\t\t\t--\t\t\t[SID].Sid_Batch_No\t\t\tAS Sid_Batch_No,\r\n\t\t\t\t\t\t--\t\t\t[SID].Sid_ExpDate\t\t\tAS Sid_ExpDate,\r\n\t\t\t\t\t\t--\t\t\t[SID].Sid_Item_Rate\t\t\tAS Sid_Item_Rate,\r\n\t\t\t\t\t\t--\t\t\t[SID].Sid_Total\t\t\t\tAS Sid_Total,\r\n\t\t\t\t\t\t--\t\t\t'HO'\t\t\t\t\t\tAS Sih_type\r\n\t\t\t\t\t","method":"","class_name":"11","line_number":"0","time":"2024-10-24 14:41:54","error_code":"-2","procedure":"","server":"SERVER04","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.<DynamicFilter>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.<ExecuteReportData>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.<GetReportConfiguration>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":"Execution Timeout Expired.  The timeout period elapsed prior to completion of the operation or the server is not responding.\r\nSELECT *,COUNT(1) OVER() AS TotalRecord FROM (\r\n\t\t\tSELECT\t\tPOH.Po_Key,\r\n\t\t\t\t\t\tPOH.Po_Ven_Code\t\t\t\t\tAS po_Ven_Code,\r\n\t\t\t\t\t\tPOH.Po_Store_Code\t\t\tAS po_Store_Code,\r\n\t\t\t\t\t\tREPLACE(REPLACE(LTRIM(RTRIM(SDR.Store_Name)), char(13), ' '), char(10), ' ') AS store_Name,\r\n\t\t\t\t\t\t/*------~~~~~~ GID: 837 Nidhi 25/06/2024 ~~~~~~----  */\r\n\t\t\t\t\t\tSDR.State,\r\n\t\t\t\t\t\tSDR.Category,\r\n\t\t\t\t\t\t/*------~~~~~~ GID: 837 ~~~~~----*/\r\n\t\t\t\t\t\tPOH.Po_No\t\t\t\t\t\tAS po_No,\r\n\t\t\t\t\t\tCAST(POH.Po_Date AS DATE)\t\tAS po_Date,\r\n\t\t\t\t\t\tREPLACE(POD.Mm_Code,',','|')\tAS mm_Code,\r\n\t\t\t\t\t\tREPLACE(POD.Pi_ItemName,',','|') AS pi_ItemName,\r\n\t\t\t\t\t\tPOD.Pi_Qty\t\t\t\t\t\tAS pi_Qty,\r\n\t\t\t\t\t\tPOD.Pi_Rate\t\t\t\t\t\tAS pi_Rate,\r\n\t\t\t\t\t\tCAST(ISNULL((ISNULL(POD.Pi_Rate,0) * ISNULL(POD.Pi_Qty,0)),0) AS numeric(18,2))AS pi_Net_Amt,\r\n\t\t\t\t\t\t--POD.Pi_Net_Amt\t\t\t\t\tAS pi_Net_Amt,\r\n\r\n\t\t\t\t\t\t--~~~~~~~~~~~~~~~~~~~Tuhsar 26-02-2024 Gid:736\r\n\t\t\t\t\t\t--(CASE WHEN SUBSTRING(POH.Po_Ven_Code,1,1) = 'H' THEN SUM(ISNULL(MSD.qty,0)) ELSE SUM(ISNULL(STK.Pms_Qty,0))END) AS orderTimeAvailableStock,\r\n\t\t\t\t\t\tSUM(ISNULL(STK.Pms_Qty,0)) AS orderTimeAvailableStock,\r\n\t\t\t\t\t\t--~~~~~~~~~~~~~~~~~~~Gid:736\r\n\r\n\t\t\t\t\t\t--SUM(ISNULL(STK.Pms_Qty,MSD.qty)) AS orderTimeAvailableStock,\r\n\r\n\t\t\t\t\t\tSIDetail.Sih_No AS sih_No,\r\n\t\t\t\t\t\tCAST(SIDetail.Sih_Date AS DATE) AS sih_Date,\r\n\t\t\t\t\t\tSIDetail.Sid_Qty AS sid_Qty,\r\n\t\t\t\t\t\tSIDetail.Sid_Batch_No AS sid_Batch_No,\r\n\t\t\t\t\t\tCAST(SIDetail.Sid_ExpDate AS DATE) sid_ExpDate,\r\n\t\t\t\t\t\tSIDetail.Sid_Item_Rate AS sid_Item_Rate,\r\n\t\t\t\t\t\tCAST((ISNULL(SIDetail.Sid_Item_Rate,0) * ISNULL(SIDetail.Sid_Qty,0)) AS numeric(18,2))AS sid_Total,\r\n\t\t\t\t\t\t--SIDetail.Sid_Total AS sid_Total,\r\n\t\t\t\t\t\tCAST((ISNULL(POD.Pi_Qty,0)-ISNULL(SIDetail.Sid_Qty,0))  AS NUMERIC(18,2))   AS bounceQty,\r\n\t\t\t\t\t\tcast((case when (SIDetail.Sid_Item_Rate > 0) \r\n\t\t\t\t\t\tthen SIDetail.Sid_Item_Rate\r\n\t\t\t\t\t\telse ISNULL(POD.Pi_Rate,0) end) *  (isnull(POD.Pi_Qty,0)-isnull(SIDetail.Sid_Qty,0))  as numeric(18,2))  as bounceAmount\r\n\t\t\tFROM\t\tPoItemDetails (NOLOCK) POD\r\n\t\t\t\tINNER JOIN PoHeader (NOLOCK) POH\r\n\t\t\tON\t\t\tPOD.PI_PO_ID = POH.ID\r\n\t\t\t\t\tAND ISNULL(POH.PO_IsZotaStore,0)=0\r\n\t\t\t\t\tAND POH.Po_Store_Code NOT LIKE '%ZOTA%'\r\n\t\t\t\tLEFT JOIN Store_Detail (NOLOCK) SDR\r\n\t\t\tON\t\t\tSDR.StoreNo = POH.Po_Store_Code\r\n\t\t\t\t\tAND ISNULL(SDR.IsZotaStore,0) = 0\r\n\t\t\t\tLEFT JOIN(\r\n\t\t\t\t\t\tSELECT\t\tSIHP.Sih_Store_Code\t\t\tAS Sih_Store_Code,\r\n\t\t\t\t\t\t\t\t\tSIHP.Sih_Cust_Code\t\t\tAS Sih_Cust_Code,\r\n\t\t\t\t\t\t\t\t\tISNULL(SIHP.sih_pokeys,'')\tAS Sih_Pokeys,\r\n\t\t\t\t\t\t\t\t\t--~~~~~~~~~~ Rahul 05-06-2024 GID:822\r\n\t\t\t\t\t\t\t\t\t--SIHP.Sih_No\t\t\t\t\tAS Sih_No,\r\n\t\t\t\t\t\t\t\t\tCASE WHEN ISNULL(SIHP.Sih_No_New,'') <> '' THEN SIHP.Sih_No_New ELSE CAST(SIHP.Sih_No AS VARCHAR) END AS Sih_No,  \r\n\t\t\t\t\t\t\t\t\t--~~~~~~~~~~  GID:822\r\n\t\t\t\t\t\t\t\t\tSIHP.Sih_Date\t\t\t\tAS Sih_Date,\r\n\t\t\t\t\t\t\t\t\t[SIDP].Mm_Code\t\t\t\tAS Sid_Item_Code,\r\n\t\t\t\t\t\t\t\t\t[SIDP].Sid_SalesQty\t\t\tAS Sid_Qty,\r\n\t\t\t\t\t\t\t\t\t[SIDP].Sid_BatchNo\t\t\tAS Sid_Batch_No,\r\n\t\t\t\t\t\t\t\t\t[SIDP].Sid_ExpDate\t\t\tAS Sid_ExpDate,\r\n\t\t\t\t\t\t\t\t\t[SIDP].Sid_SalesRate\t\tAS Sid_Item_Rate,\r\n\t\t\t\t\t\t\t\t\t[SIDP].Sid_Total\t\t\tAS Sid_Total,\r\n\t\t\t\t\t\t\t\t\t'DPOS'\t\t\t\t\tAS Sih_type\r\n\t\t\t\t\t\tFROM\t\tSalesInvoiceHeader_pos (NOLOCK) SIHP\r\n\t\t\t\t\t\t\t\tINNER JOIN [SalesInvoiceItemDetail_pos] (NOLOCK) [SIDP]\r\n\t\t\t\t\t\tON\t\t\t[SIDP].Sid_Sih_Id = SIHP.Id\r\n\t\t\t\t\t\tWHERE\t\tSIHP.Sih_Store_Code IN (SELECT StoreNo FROM Store_Detail (NOLOCK) WHERE Category ='STOCKIST' AND ISNULL(IsZotaStore,0) = 0 AND ISNULL(IsActive,0) = 1)\r\n\t\t\t\t\t\t\t\tAND ISNULL(SIHP.sih_pokeys,'') <> ''\r\n\t\t\t\t\t\t--~~~~~~~~~~~~~~~~~~~Tuhsar 26-02-2024 Gid:736\r\n\t\t\t\t\t\t--UNION ALL\r\n\t\t\t\t\t\t--SELECT\t\tSIH.Sih_Store_Code\t\t\tAS Sih_Store_Code,\r\n\t\t\t\t\t\t--\t\t\tCAST(''\tAS VARCHAR)\t\t\tAS Sih_Cust_Code,\r\n\t\t\t\t\t\t--\t\t\tISNULL(SIH.Sih_Pokeys,'')\tAS Sih_Pokeys,\r\n\t\t\t\t\t\t--\t\t\tSIH.Sih_No\t\t\t\t\tAS Sih_No,\r\n\t\t\t\t\t\t--\t\t\tSIH.Sih_Date\t\t\t\tAS Sih_Date,\r\n\t\t\t\t\t\t--\t\t\t[SID].Sid_Item_Code\t\t\tAS Sid_Item_Code,\r\n\t\t\t\t\t\t--\t\t\t[SID].Sid_Qty\t\t\t\tAS Sid_Qty,\r\n\t\t\t\t\t\t--\t\t\t[SID].Sid_Batch_No\t\t\tAS Sid_Batch_No,\r\n\t\t\t\t\t\t--\t\t\t[SID].Sid_ExpDate\t\t\tAS Sid_ExpDate,\r\n\t\t\t\t\t\t--\t\t\t[SID].Sid_Item_Rate\t\t\tAS Sid_Item_Rate,\r\n\t\t\t\t\t\t--\t\t\t[SID].Sid_Total\t\t\t\tAS Sid_Total,\r\n\t\t\t\t\t\t--\t\t\t'HO'\t\t\t\t\t\tAS Sih_type\r\n\t\t\t\t\t","method":"","class_name":"11","line_number":"0","time":"2024-10-24 14:42:30","error_code":"-2","procedure":"","server":"SERVER04","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.<DynamicFilter>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.<ExecuteReportData>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.<GetReportConfiguration>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":"System.Data","message":"Cannot find table 2.","method":"","class_name":"","line_number":"","time":"2024-10-24 15:23:25","error_code":"","procedure":"","server":"","stack_trace":"at System.Data.DataTableCollection.get_Item(Int32 index)\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:\\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.<ProcessCposToPos>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.<ProcessSyncData>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.<SyncProcess>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.<SyncPOS>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":"","message":"Data Not Found. SyncId:15","method":"","class_name":"","line_number":"","time":"2024-10-24 15:23:25","error_code":"","procedure":"","server":"","stack_trace":"","priority":"","version_no":null,"app_version_no":null,"reccurence_count":1}
,
{"store_code":"","client_code":"","source":"System.Data","message":"Cannot find table 2.","method":"","class_name":"","line_number":"","time":"2024-10-24 16:23:25","error_code":"","procedure":"","server":"","stack_trace":"at System.Data.DataTableCollection.get_Item(Int32 index)\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:\\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.<ProcessCposToPos>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.<ProcessSyncData>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.<SyncProcess>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.<SyncPOS>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":"","message":"Data Not Found. SyncId:15","method":"","class_name":"","line_number":"","time":"2024-10-24 16:23: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":"2024-10-24 16:25:14","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.<GetStoreStatus>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":"System.Data","message":"Cannot find table 2.","method":"","class_name":"","line_number":"","time":"2024-10-24 17:23:26","error_code":"","procedure":"","server":"","stack_trace":"at System.Data.DataTableCollection.get_Item(Int32 index)\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:\\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.<ProcessCposToPos>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.<ProcessSyncData>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.<SyncProcess>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.<SyncPOS>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":"","message":"Data Not Found. SyncId:15","method":"","class_name":"","line_number":"","time":"2024-10-24 17:23: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":"Invalid object name 'cPOS_SALES_DATA..ApiConfiguration'.","method":"","class_name":"16","line_number":"9","time":"2024-10-24 17:51:25","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.<GetStoreStatus>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-10-24 18:39:15","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.<GetStoreStatus>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":"System.Data","message":"Cannot find table 2.","method":"","class_name":"","line_number":"","time":"2024-10-24 18:39:51","error_code":"","procedure":"","server":"","stack_trace":"at System.Data.DataTableCollection.get_Item(Int32 index)\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:\\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.<ProcessCposToPos>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.<ProcessSyncData>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.<SyncProcess>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.<SyncPOS>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":"","message":"Data Not Found. SyncId:15","method":"","class_name":"","line_number":"","time":"2024-10-24 18:39:51","error_code":"","procedure":"","server":"","stack_trace":"","priority":"","version_no":null,"app_version_no":null,"reccurence_count":1}
,
{"store_code":"","client_code":"","source":"System.Data","message":"Cannot find table 2.","method":"","class_name":"","line_number":"","time":"2024-10-24 19:39:20","error_code":"","procedure":"","server":"","stack_trace":"at System.Data.DataTableCollection.get_Item(Int32 index)\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:\\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.<ProcessCposToPos>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.<ProcessSyncData>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.<SyncProcess>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.<SyncPOS>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":"","message":"Data Not Found. SyncId:15","method":"","class_name":"","line_number":"","time":"2024-10-24 19:39:20","error_code":"","procedure":"","server":"","stack_trace":"","priority":"","version_no":null,"app_version_no":null,"reccurence_count":1}
,