11:52:50 - IsConnectionValid True 11:52:50 - IsConnectionValid True 11:52:58 - IsConnectionValid True 11:52:58 - IsConnectionValid True 11:53:03 - IsConnectionValid True 11:53:13 - IsConnectionValid True 11:53:33 - IsConnectionValid True 11:53:33 - finalQuery ;WITH CTE AS (SELECT ROW_NUMBER() OVER ( ORDER BY ID ASC) AS rn, COUNT(*) OVER() AS _total, * FROM (SELECT * FROM ShiftDef WHERE TenantID = @val0 AND (SectionID=0 OR SectionID=149) AND CAST(FromDate AS Date) <= @val2 AND CAST(ToDate AS Date) >= @val3 ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow 11:53:39 - IsConnectionValid True 11:53:39 - finalQuery ;WITH CTE AS (SELECT ROW_NUMBER() OVER ( ORDER BY ID ASC) AS rn, COUNT(*) OVER() AS _total, * FROM (SELECT * FROM ShiftDef WHERE TenantID = @val0 AND (SectionID=0 OR SectionID=151) AND CAST(FromDate AS Date) <= @val2 AND CAST(ToDate AS Date) >= @val3 ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow 11:53:42 - IsConnectionValid True 11:53:42 - finalQuery ;WITH CTE AS (SELECT ROW_NUMBER() OVER ( ORDER BY ID ASC) AS rn, COUNT(*) OVER() AS _total, * FROM (SELECT * FROM ShiftDef WHERE TenantID = @val0 AND (SectionID=0 OR SectionID=124) AND CAST(FromDate AS Date) <= @val2 AND CAST(ToDate AS Date) >= @val3 ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow 11:54:25 - IsConnectionValid True 11:56:52 - IsConnectionValid True 11:56:54 - IsConnectionValid True 11:58:52 - IsConnectionValid True 11:58:54 - IsConnectionValid True 15:33:33 - IsConnectionValid True 15:33:35 - IsConnectionValid True 15:33:37 - IsConnectionValid True 15:33:37 - SELECT * FROM HRMS_VwVacationEntry WHERE TenantID = 1 AND TenantID = @val0 AND EmployeeID = @val1 AND UserID = @val2 AND Posted <> @val3 ORDER BY FromDate ASC Query 15:33:38 - IsConnectionValid True 15:33:38 - finalQuery ;WITH CTE AS (SELECT ROW_NUMBER() OVER ( ORDER BY ID ASC) AS rn, COUNT(*) OVER() AS _total, * FROM (SELECT * FROM HRMS_vwEmployees WHERE (DateLeft = '1900-01-01' or (DateleftTemp<>DateLeft and DateLeft > GETDATE())) and UserID = @val1 and TenantID = @val2 ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow 15:33:40 - IsConnectionValid True 15:33:40 - SELECT * FROM HRMS_VwVacationEntry WHERE TenantID = 1 AND TenantID = @val0 AND EmployeeID = @val1 AND UserID = @val2 AND Posted <> @val3 ORDER BY FromDate ASC Query 15:33:41 - IsConnectionValid True 15:33:41 - finalQuery ;WITH CTE AS (SELECT ROW_NUMBER() OVER ( ORDER BY ID ASC) AS rn, COUNT(*) OVER() AS _total, * FROM (SELECT * FROM HRMS_VwVacationTypes_WithSecurity WHERE TenantID = 1 AND TenantID = @val0 and UserID = @val1 ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow 15:33:45 - IsConnectionValid True 15:33:45 - SELECT DISTINCT * FROM HRMS_vwEmployees WHERE TenantID = 1 AND TenantID = @val0 AND ID = @val1 AND UserID = @val2 ORDER BY ID Query 15:38:05 - IsConnectionValid True 15:38:05 - finalQuery ;WITH CTE AS (SELECT ROW_NUMBER() OVER ( ORDER BY ID ASC) AS rn, COUNT(*) OVER() AS _total, * FROM (SELECT * FROM HRMS_VwVacationTypes_WithSecurity WHERE TenantID = 1 AND TenantID = @val0 and UserID = @val1 ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow 15:38:07 - IsConnectionValid True 15:38:07 - SELECT DISTINCT * FROM HRMS_vwEmployees WHERE TenantID = 1 AND TenantID = @val0 AND ID = @val1 AND UserID = @val2 ORDER BY ID Query 15:38:46 - IsConnectionValid True 15:38:46 - IsConnectionValid True 15:38:46 - IsConnectionValid True 15:38:46 - SELECT DISTINCT COUNT(*) AS OccCount FROM Occasions WHERE TenantID = @val0 AND CAST(OccasionDate AS Date) >= @val1 AND CAST(OccasionDate AS Date) <= @val2 AND DayOff = @val3 AND (ProjectID =0 or ProjectID =1) AND (Relegion =-1 or Relegion =1) Query 15:38:46 - SELECT DISTINCT * FROM HRMS_vwEmployees WHERE TenantID = 1 AND TenantID = @val0 AND ID = @val1 AND UserID = @val2 ORDER BY ID Query 15:38:46 - SELECT DISTINCT * FROM HRMS_vwEmployees WHERE TenantID = 1 AND TenantID = @val0 AND ID = @val1 AND UserID = @val2 ORDER BY ID Query 15:38:46 - IsConnectionValid True 15:38:46 - SELECT DISTINCT COUNT(*) AS DayCount FROM EmployeeShiftDetails_PerDate WHERE TenantID = @val0 AND EmployeeID = @val1 AND IsDayOff = @val2 AND CAST(Date AS Date) >= @val3 AND CAST(Date AS Date) <= @val4 AND Not Exists(SELECT ID FROM Occasions WHERE OccasionDate BETWEEN '06/21/2023' AND '06/22/2023' AND DayOff=1 AND (ISNULL(ProjectID,0)=0 OR ProjectID =1) AND (ISNULL(Relegion,-1)=-1 OR Relegion =1)) Query 15:38:48 - IsConnectionValid True 15:38:48 - IsConnectionValid True 15:38:48 - IsConnectionValid True 15:38:48 - SELECT DISTINCT COUNT(*) AS OccCount FROM Occasions WHERE TenantID = @val0 AND CAST(OccasionDate AS Date) >= @val1 AND CAST(OccasionDate AS Date) <= @val2 AND DayOff = @val3 AND (ProjectID =0 or ProjectID =1) AND (Relegion =-1 or Relegion =1) Query 15:38:48 - SELECT DISTINCT * FROM HRMS_vwEmployees WHERE TenantID = 1 AND TenantID = @val0 AND ID = @val1 AND UserID = @val2 ORDER BY ID Query 15:38:48 - SELECT DISTINCT * FROM HRMS_vwEmployees WHERE TenantID = 1 AND TenantID = @val0 AND ID = @val1 AND UserID = @val2 ORDER BY ID Query 15:38:48 - IsConnectionValid True 15:38:48 - SELECT DISTINCT COUNT(*) AS DayCount FROM EmployeeShiftDetails_PerDate WHERE TenantID = @val0 AND EmployeeID = @val1 AND IsDayOff = @val2 AND CAST(Date AS Date) >= @val3 AND CAST(Date AS Date) <= @val4 AND Not Exists(SELECT ID FROM Occasions WHERE OccasionDate BETWEEN '06/21/2023' AND '06/21/2023' AND DayOff=1 AND (ISNULL(ProjectID,0)=0 OR ProjectID =1) AND (ISNULL(Relegion,-1)=-1 OR Relegion =1)) Query 15:38:50 - IsConnectionValid True 15:39:01 - IsConnectionValid True 15:39:59 - IsConnectionValid True 15:40:04 - IsConnectionValid True 15:40:05 - IsConnectionValid True 15:40:05 - SELECT * FROM HRMS_VwVacationEntry WHERE TenantID = 1 AND TenantID = @val0 AND EmployeeID = @val1 AND UserID = @val2 AND Posted <> @val3 ORDER BY FromDate ASC Query 15:40:07 - IsConnectionValid True 15:40:07 - SELECT DISTINCT COUNT(*) AS OccCount FROM Occasions WHERE TenantID = @val0 AND CAST(OccasionDate AS Date) >= @val1 AND CAST(OccasionDate AS Date) <= @val2 AND DayOff = @val3 AND (ProjectID =0 or ProjectID =undefined) AND (Relegion =-1 or Relegion =-1) Query 15:40:07 - (1-gen-1002) : Invalid column name 'undefined'. 15:40:12 - IsConnectionValid True 15:40:19 - IsConnectionValid True 15:40:19 - IsConnectionValid True 15:40:22 - IsConnectionValid True 15:40:24 - IsConnectionValid True 15:40:25 - IsConnectionValid True 15:40:25 - SELECT * FROM HRMS_VwVacationEntry WHERE TenantID = 1 AND TenantID = @val0 AND EmployeeID = @val1 AND UserID = @val2 AND Posted <> @val3 ORDER BY FromDate ASC Query 15:40:26 - IsConnectionValid True 15:40:26 - finalQuery ;WITH CTE AS (SELECT ROW_NUMBER() OVER ( ORDER BY ID ASC) AS rn, COUNT(*) OVER() AS _total, * FROM (SELECT * FROM HRMS_vwEmployees WHERE (DateLeft = '1900-01-01' or (DateleftTemp<>DateLeft and DateLeft > GETDATE())) and UserID = @val1 and TenantID = @val2 ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow 15:40:27 - IsConnectionValid True 15:40:27 - SELECT * FROM HRMS_VwVacationEntry WHERE TenantID = 1 AND TenantID = @val0 AND EmployeeID = @val1 AND UserID = @val2 AND Posted <> @val3 ORDER BY FromDate ASC Query 15:40:28 - IsConnectionValid True 15:40:28 - finalQuery ;WITH CTE AS (SELECT ROW_NUMBER() OVER ( ORDER BY ID ASC) AS rn, COUNT(*) OVER() AS _total, * FROM (SELECT * FROM HRMS_VwVacationTypes_WithSecurity WHERE TenantID = 1 AND TenantID = @val0 and UserID = @val1 ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow 15:40:30 - IsConnectionValid True 15:40:30 - SELECT DISTINCT * FROM HRMS_vwEmployees WHERE TenantID = 1 AND TenantID = @val0 AND ID = @val1 AND UserID = @val2 ORDER BY ID Query 15:40:46 - IsConnectionValid True 15:40:46 - finalQuery ;WITH CTE AS (SELECT ROW_NUMBER() OVER ( ORDER BY ID ASC) AS rn, COUNT(*) OVER() AS _total, * FROM (SELECT * FROM HRMS_VwVacationTypes_WithSecurity WHERE TenantID = 1 AND TenantID = @val0 and UserID = @val1 ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow 15:40:48 - IsConnectionValid True 15:40:48 - SELECT DISTINCT * FROM HRMS_vwEmployees WHERE TenantID = 1 AND TenantID = @val0 AND ID = @val1 AND UserID = @val2 ORDER BY ID Query 15:41:03 - IsConnectionValid True 15:41:03 - IsConnectionValid True 15:41:03 - IsConnectionValid True 15:41:03 - SELECT DISTINCT COUNT(*) AS OccCount FROM Occasions WHERE TenantID = @val0 AND CAST(OccasionDate AS Date) >= @val1 AND CAST(OccasionDate AS Date) <= @val2 AND DayOff = @val3 AND (ProjectID =0 or ProjectID =1) AND (Relegion =-1 or Relegion =1) Query 15:41:03 - SELECT DISTINCT * FROM HRMS_vwEmployees WHERE TenantID = 1 AND TenantID = @val0 AND ID = @val1 AND UserID = @val2 ORDER BY ID Query 15:41:03 - SELECT DISTINCT * FROM HRMS_vwEmployees WHERE TenantID = 1 AND TenantID = @val0 AND ID = @val1 AND UserID = @val2 ORDER BY ID Query 15:41:03 - IsConnectionValid True 15:41:03 - SELECT DISTINCT COUNT(*) AS DayCount FROM EmployeeShiftDetails_PerDate WHERE TenantID = @val0 AND EmployeeID = @val1 AND IsDayOff = @val2 AND CAST(Date AS Date) >= @val3 AND CAST(Date AS Date) <= @val4 AND Not Exists(SELECT ID FROM Occasions WHERE OccasionDate BETWEEN '06/21/2023' AND '06/21/2023' AND DayOff=1 AND (ISNULL(ProjectID,0)=0 OR ProjectID =1) AND (ISNULL(Relegion,-1)=-1 OR Relegion =1)) Query 15:41:04 - IsConnectionValid True 15:41:47 - IsConnectionValid True 15:41:50 - IsConnectionValid True 15:41:57 - IsConnectionValid True 15:41:57 - IsConnectionValid True 15:42:00 - IsConnectionValid True 15:42:12 - IsConnectionValid True 15:42:15 - IsConnectionValid True 15:42:15 - SELECT * FROM HRMS_VwVacationEntry WHERE TenantID = 1 AND TenantID = @val0 AND EmployeeID = @val1 AND UserID = @val2 AND Posted <> @val3 ORDER BY FromDate ASC Query 15:42:17 - IsConnectionValid True 15:42:17 - finalQuery ;WITH CTE AS (SELECT ROW_NUMBER() OVER ( ORDER BY ID ASC) AS rn, COUNT(*) OVER() AS _total, * FROM (SELECT * FROM HRMS_vwEmployees WHERE (DateLeft = '1900-01-01' or (DateleftTemp<>DateLeft and DateLeft > GETDATE())) and UserID = @val1 and TenantID = @val2 ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow 15:42:18 - IsConnectionValid True 15:42:18 - SELECT * FROM HRMS_VwVacationEntry WHERE TenantID = 1 AND TenantID = @val0 AND EmployeeID = @val1 AND UserID = @val2 AND Posted <> @val3 ORDER BY FromDate ASC Query 15:42:19 - IsConnectionValid True 15:42:19 - finalQuery ;WITH CTE AS (SELECT ROW_NUMBER() OVER ( ORDER BY ID ASC) AS rn, COUNT(*) OVER() AS _total, * FROM (SELECT * FROM HRMS_VwVacationTypes_WithSecurity WHERE TenantID = 1 AND TenantID = @val0 and UserID = @val1 ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow 15:42:21 - IsConnectionValid True 15:42:21 - SELECT DISTINCT * FROM HRMS_vwEmployees WHERE TenantID = 1 AND TenantID = @val0 AND ID = @val1 AND UserID = @val2 ORDER BY ID Query 15:42:25 - IsConnectionValid True 15:42:25 - SELECT DISTINCT COUNT(*) AS OccCount FROM Occasions WHERE TenantID = @val0 AND CAST(OccasionDate AS Date) >= @val1 AND CAST(OccasionDate AS Date) <= @val2 AND DayOff = @val3 AND (ProjectID =0 or ProjectID =1) AND (Relegion =-1 or Relegion =1) Query 15:42:25 - IsConnectionValid True 15:42:25 - SELECT DISTINCT COUNT(*) AS DayCount FROM EmployeeShiftDetails_PerDate WHERE TenantID = @val0 AND EmployeeID = @val1 AND IsDayOff = @val2 AND CAST(Date AS Date) >= @val3 AND CAST(Date AS Date) <= @val4 AND Not Exists(SELECT ID FROM Occasions WHERE OccasionDate BETWEEN '04/21/2024' AND '04/21/2024' AND DayOff=1 AND (ISNULL(ProjectID,0)=0 OR ProjectID =1) AND (ISNULL(Relegion,-1)=-1 OR Relegion =1)) Query 15:42:30 - IsConnectionValid True 15:42:30 - SELECT DISTINCT COUNT(*) AS OccCount FROM Occasions WHERE TenantID = @val0 AND CAST(OccasionDate AS Date) >= @val1 AND CAST(OccasionDate AS Date) <= @val2 AND DayOff = @val3 AND (ProjectID =0 or ProjectID =1) AND (Relegion =-1 or Relegion =1) Query 15:42:30 - IsConnectionValid True 15:42:30 - SELECT DISTINCT COUNT(*) AS DayCount FROM EmployeeShiftDetails_PerDate WHERE TenantID = @val0 AND EmployeeID = @val1 AND IsDayOff = @val2 AND CAST(Date AS Date) >= @val3 AND CAST(Date AS Date) <= @val4 AND Not Exists(SELECT ID FROM Occasions WHERE OccasionDate BETWEEN '04/21/2024' AND '04/21/2024' AND DayOff=1 AND (ISNULL(ProjectID,0)=0 OR ProjectID =1) AND (ISNULL(Relegion,-1)=-1 OR Relegion =1)) Query 15:42:34 - IsConnectionValid True 15:42:34 - SELECT DISTINCT COUNT(*) AS OccCount FROM Occasions WHERE TenantID = @val0 AND CAST(OccasionDate AS Date) >= @val1 AND CAST(OccasionDate AS Date) <= @val2 AND DayOff = @val3 AND (ProjectID =0 or ProjectID =1) AND (Relegion =-1 or Relegion =1) Query 15:42:34 - IsConnectionValid True 15:42:34 - SELECT DISTINCT COUNT(*) AS DayCount FROM EmployeeShiftDetails_PerDate WHERE TenantID = @val0 AND EmployeeID = @val1 AND IsDayOff = @val2 AND CAST(Date AS Date) >= @val3 AND CAST(Date AS Date) <= @val4 AND Not Exists(SELECT ID FROM Occasions WHERE OccasionDate BETWEEN '06/21/2023' AND '06/21/2023' AND DayOff=1 AND (ISNULL(ProjectID,0)=0 OR ProjectID =1) AND (ISNULL(Relegion,-1)=-1 OR Relegion =1)) Query 15:42:40 - IsConnectionValid True 15:42:40 - IsConnectionValid True 15:42:40 - IsConnectionValid True 15:42:55 - IsConnectionValid True 15:42:55 - IsConnectionValid True 15:42:55 - IsConnectionValid True 15:44:47 - IsConnectionValid True 15:44:47 - IsConnectionValid True 15:44:47 - IsConnectionValid True 15:44:48 - IsConnectionValid True 15:44:48 - SELECT * FROM HRMS_VwVacationEntry WHERE TenantID = 1 AND TenantID = @val0 AND EmployeeID = @val1 AND UserID = @val2 AND Posted <> @val3 ORDER BY FromDate ASC Query