{"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\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\t--FROM\t\tSalesInvoiceHeader (NOLOCK) SIH\r\n\t\t\t\t\t\t--\t\tINNER JOIN [SalesInvoiceItemDetail] (NOLOCK) [SID]\r\n\t\t\t\t\t\t--ON\t\t\t[SID].Sid_Sih_Key = SIH.Sih_","method":"","class_name":"11","line_number":"0","time":"2024-06-19 09:59:44","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.","method":"","class_name":"11","line_number":"0","time":"2024-06-19 13:41:13","error_code":"-2","procedure":"","server":"SERVER04","stack_trace":"at BPPI.CPOS.BAL.Reports.ReportsRepository.<getDataSyncReport>d__5.MoveNext() in D:\\DPC15\\GIT Repository\\ZOTA\\CPOS_API\\ZOTA.CPOS.BAL\\Reports\\ReportsRepository.cs:line 86\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.ReportsController.<GetDataSyncReport>d__3.MoveNext() in D:\\DPC15\\GIT Repository\\ZOTA\\CPOS_API\\ZOTA.CPOS.API\\Controllers\\ReportsController.cs:line 51","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-06-19 14:55: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-06-19 15:08: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.<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-06-19 17:16: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.<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-06-19 17:16:17","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":"","message":"Data Not Found. SyncId:15","method":"","class_name":"","line_number":"","time":"2024-06-19 17:17:30","error_code":"","procedure":"","server":"","stack_trace":"","priority":"","version_no":null,"app_version_no":null,"reccurence_count":1}
,
{"store_code":"","client_code":"","source":".Net SqlClient Data Provider","message":"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-06-19 17:28:01","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":"Invalid object name 'cPOS_SALES_DATA..ApiConfiguration'.","method":"","class_name":"16","line_number":"9","time":"2024-06-19 19:06:45","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-06-19 19:10: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.<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":"","message":"Data Not Found. SyncId:15","method":"","class_name":"","line_number":"","time":"2024-06-19 19:10:57","error_code":"","procedure":"","server":"","stack_trace":"","priority":"","version_no":null,"app_version_no":null,"reccurence_count":1}
,