13:53:25 - IsConnectionValid True
13:53:25 - IsConnectionValid True
13:53:32 - IsConnectionValid True
13:53:32 - IsConnectionValid True
13:53:35 - IsConnectionValid True
13:53:37 - IsConnectionValid True
13:53: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
13:53:39 - IsConnectionValid True
13:53:39 - 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
13:53:47 - IsConnectionValid True
13:53:47 - SELECT * FROM HRMS_VwVacationEntry WHERE TenantID = 1 AND   TenantID = @val0 AND EmployeeID = @val1 AND UserID = @val2 AND Posted <> @val3 ORDER BY FromDate ASC  Query
13:53:48 - IsConnectionValid True
13:53:48 - finalQuery  ;WITH CTE AS (SELECT  ROW_NUMBER() OVER ( ORDER BY ID ASC) AS rn, COUNT(*) OVER() AS _total, * FROM (SELECT * FROM VwVacationTypes  WHERE  TenantID = 1 AND   TenantID = @val0  ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow
13:53:49 - IsConnectionValid True
13:53:49 - SELECT  DISTINCT * FROM HRMS_vwEmployees WHERE TenantID = 1 AND   TenantID = @val0 AND ID = @val1 AND UserID = @val2 ORDER BY ID  Query
13:53:49 - IsConnectionValid True
13:53:49 - SELECT  DISTINCT * FROM HRMS_vwEmployees WHERE TenantID = 1 AND   TenantID = @val0 AND ID = @val1 AND UserID = @val2 ORDER BY ID  Query
13:54:02 - IsConnectionValid True
13:54:06 - IsConnectionValid True
13:54:33 - IsConnectionValid True
13:54:35 - IsConnectionValid True
13:54:35 - SELECT * FROM HRMS_VwVacationEntry WHERE TenantID = 1 AND   TenantID = @val0 AND EmployeeID = @val1 AND UserID = @val2 AND Posted <> @val3 ORDER BY FromDate ASC  Query
13:54:41 - IsConnectionValid True
13:54:41 - 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
13:54:44 - IsConnectionValid True
13:54:44 - SELECT * FROM HRMS_VwVacationEntry WHERE TenantID = 1 AND   TenantID = @val0 AND EmployeeID = @val1 AND UserID = @val2 AND Posted <> @val3 ORDER BY FromDate ASC  Query
13:54:46 - IsConnectionValid True
13:54:46 - finalQuery  ;WITH CTE AS (SELECT  ROW_NUMBER() OVER ( ORDER BY ID ASC) AS rn, COUNT(*) OVER() AS _total, * FROM (SELECT * FROM VwVacationTypes  WHERE  TenantID = 1 AND   TenantID = @val0  ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow
13:54:47 - IsConnectionValid True
13:54:47 - SELECT  DISTINCT * FROM HRMS_vwEmployees WHERE TenantID = 1 AND   TenantID = @val0 AND ID = @val1 AND UserID = @val2 ORDER BY ID  Query
13:54:48 - IsConnectionValid True
13:54:48 - SELECT  DISTINCT * FROM HRMS_vwEmployees WHERE TenantID = 1 AND   TenantID = @val0 AND ID = @val1 AND UserID = @val2 ORDER BY ID  Query
13:55:10 - IsConnectionValid True
13:55:10 - IsConnectionValid True
13:55:10 - IsConnectionValid True
13:55:11 - IsConnectionValid True
13:55:11 - SELECT * FROM HRMS_VwVacationEntry WHERE TenantID = 1 AND   TenantID = @val0 AND EmployeeID = @val1 AND UserID = @val2 AND Posted <> @val3 ORDER BY FromDate ASC  Query
17:31:00 - IsConnectionValid True
17:31:00 - IsConnectionValid True
17:31:21 - IsConnectionValid True
17:31:29 - IsConnectionValid True
17:31:29 - SELECT * FROM HRMS_VwVacationEntry WHERE TenantID = 1 AND   TenantID = @val0 AND EmployeeID = @val1 AND UserID = @val2 AND Posted <> @val3 ORDER BY FromDate ASC  Query
17:31:31 - IsConnectionValid True
17:31:31 - 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
17:31:32 - IsConnectionValid True
17:31:32 - SELECT * FROM HRMS_VwVacationEntry WHERE TenantID = 1 AND   TenantID = @val0 AND EmployeeID = @val1 AND UserID = @val2 AND Posted <> @val3 ORDER BY FromDate ASC  Query
17:31:33 - IsConnectionValid True
17:31:33 - finalQuery  ;WITH CTE AS (SELECT  ROW_NUMBER() OVER ( ORDER BY ID ASC) AS rn, COUNT(*) OVER() AS _total, * FROM (SELECT * FROM VwVacationTypes  WHERE  TenantID = 1 AND   TenantID = @val0  ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow
17:31:34 - IsConnectionValid True
17:31:34 - SELECT  DISTINCT * FROM HRMS_vwEmployees WHERE TenantID = 1 AND   TenantID = @val0 AND ID = @val1 AND UserID = @val2 ORDER BY ID  Query
17:31:34 - IsConnectionValid True
17:31:34 - SELECT  DISTINCT * FROM HRMS_vwEmployees WHERE TenantID = 1 AND   TenantID = @val0 AND ID = @val1 AND UserID = @val2 ORDER BY ID  Query
17:32:21 - IsConnectionValid True
17:32:21 - IsConnectionValid True
17:32:21 - IsConnectionValid True
17:32:21 - SELECT  DISTINCT FromDate AS FromDate, ToDate AS ToDate FROM HRMS_VwVacationEntry WHERE TenantID = 1 AND   ID = @val0 and TenantID = @val1  Query
17:32:34 - IsConnectionValid True
17:32:34 - IsConnectionValid True
17:32:34 - IsConnectionValid True
17:32:35 - (3-hr-0010025) : Cannot insert the value NULL into column 'ID', table 'HRMSystemICS2023.dbo.VacationEntry_Details'; column does not allow nulls. INSERT fails.
17:33:08 - IsConnectionValid True
17:33:08 - IsConnectionValid True
17:33:08 - IsConnectionValid True
17:33:08 - IsConnectionValid True
17:33:08 - SELECT * FROM HRMS_VwVacationEntry WHERE TenantID = 1 AND   TenantID = @val0 AND EmployeeID = @val1 AND UserID = @val2 AND Posted <> @val3 ORDER BY FromDate ASC  Query
17:36:30 - IsConnectionValid True
17:36:30 - 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
17:36:31 - IsConnectionValid True
17:36:31 - SELECT * FROM HRMS_VwVacationEntry WHERE TenantID = 1 AND   TenantID = @val0 AND EmployeeID = @val1 AND UserID = @val2 AND Posted <> @val3 ORDER BY FromDate ASC  Query
17:36:32 - IsConnectionValid True
17:36:32 - finalQuery  ;WITH CTE AS (SELECT  ROW_NUMBER() OVER ( ORDER BY ID ASC) AS rn, COUNT(*) OVER() AS _total, * FROM (SELECT * FROM VwVacationTypes  WHERE  TenantID = 1 AND   TenantID = @val0  ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow
17:36:34 - IsConnectionValid True
17:36:34 - SELECT  DISTINCT * FROM HRMS_vwEmployees WHERE TenantID = 1 AND   TenantID = @val0 AND ID = @val1 AND UserID = @val2 ORDER BY ID  Query
17:36:34 - IsConnectionValid True
17:36:34 - SELECT  DISTINCT * FROM HRMS_vwEmployees WHERE TenantID = 1 AND   TenantID = @val0 AND ID = @val1 AND UserID = @val2 ORDER BY ID  Query
17:37:07 - IsConnectionValid True
17:37:07 - IsConnectionValid True
17:37:07 - IsConnectionValid True
17:37:07 - IsConnectionValid True
17:37:07 - SELECT * FROM HRMS_VwVacationEntry WHERE TenantID = 1 AND   TenantID = @val0 AND EmployeeID = @val1 AND UserID = @val2 AND Posted <> @val3 ORDER BY FromDate ASC  Query
17:39:16 - IsConnectionValid True
17:39:16 - 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
17:39:17 - IsConnectionValid True
17:39:17 - SELECT * FROM HRMS_VwVacationEntry WHERE TenantID = 1 AND   TenantID = @val0 AND EmployeeID = @val1 AND UserID = @val2 AND Posted <> @val3 ORDER BY FromDate ASC  Query