14:18:16 - IsConnectionValid True
14:18:19 - IsConnectionValid True
14:18:52 - IsConnectionValid True
14:18:52 - IsConnectionValid True
14:19:46 - IsConnectionValid True
14:19:57 - IsConnectionValid True
14:19:57 - SELECT * FROM VwVacationEntry WHERE TenantID = 1 AND   TenantID = @val0 AND EmployeeID = @val1 AND UserID = @val2 AND VacationType = @val3 ORDER BY FromDate ASC  Query
14:19:58 - (1-gen-1002) : Invalid column name 'TenantID'.
Invalid column name 'TenantID'.
14:19:59 - IsConnectionValid True
14:19:59 - IsConnectionValid True
14:19:59 - IsConnectionValid True
14:19:59 - (1-gen-1002) : The given key was not present in the dictionary.
14:19:59 - IsConnectionValid True
14:19:59 - IsConnectionValid True
14:19:59 - IsConnectionValid True
14:19:59 - (1-gen-1002) : The given key was not present in the dictionary.
14:19:59 - IsConnectionValid True
14:19:59 - (1-gen-1002) : The given key was not present in the dictionary.
14:19:59 - (1-gen-1002) : The given key was not present in the dictionary.
14:19:59 - (1-gen-1002) : The given key was not present in the dictionary.
14:19:59 - (1-gen-1002) : The given key was not present in the dictionary.
14:19:59 - IsConnectionValid True
14:19:59 - (1-gen-1002) : The given key was not present in the dictionary.
14:19:59 - IsConnectionValid True
14:19:59 - (1-gen-1002) : The given key was not present in the dictionary.
14:19:59 - IsConnectionValid True
14:19:59 - IsConnectionValid True
14:19:59 - (1-gen-1002) : The given key was not present in the dictionary.
14:19:59 - (1-gen-1002) : The given key was not present in the dictionary.
14:19:59 - IsConnectionValid True
14:19:59 - (1-gen-1002) : The given key was not present in the dictionary.
14:19:59 - IsConnectionValid True
14:19:59 - (1-gen-1002) : The given key was not present in the dictionary.
14:19:59 - IsConnectionValid True
14:19:59 - (1-gen-1002) : The given key was not present in the dictionary.
14:19:59 - IsConnectionValid True
14:19:59 - IsConnectionValid True
14:19:59 - (1-gen-1002) : The given key was not present in the dictionary.
14:19:59 - IsConnectionValid True
14:19:59 - (1-gen-1002) : The given key was not present in the dictionary.
14:19:59 - (1-gen-1002) : The given key was not present in the dictionary.
14:19:59 - (1-gen-1002) : The given key was not present in the dictionary.
14:19:59 - IsConnectionValid True
14:19:59 - (1-gen-1002) : The given key was not present in the dictionary.
14:19:59 - IsConnectionValid True
14:19:59 - IsConnectionValid True
14:19:59 - IsConnectionValid True
14:19:59 - (1-gen-1002) : The given key was not present in the dictionary.
14:19:59 - IsConnectionValid True
14:19:59 - (1-gen-1002) : The given key was not present in the dictionary.
14:19:59 - IsConnectionValid True
14:19:59 - (1-gen-1002) : The given key was not present in the dictionary.
14:19:59 - (1-gen-1002) : The given key was not present in the dictionary.
14:19:59 - (1-gen-1002) : The given key was not present in the dictionary.
14:19:59 - (1-gen-1002) : The given key was not present in the dictionary.
14:19:59 - IsConnectionValid True
14:19:59 - IsConnectionValid True
14:19:59 - IsConnectionValid True
14:19:59 - (1-gen-1002) : The given key was not present in the dictionary.
14:19:59 - IsConnectionValid True
14:19:59 - (1-gen-1002) : The given key was not present in the dictionary.
14:19:59 - IsConnectionValid True
14:19:59 - IsConnectionValid True
14:19:59 - (1-gen-1002) : The given key was not present in the dictionary.
14:19:59 - (1-gen-1002) : The given key was not present in the dictionary.
14:19:59 - (1-gen-1002) : The given key was not present in the dictionary.
14:19:59 - IsConnectionValid True
14:19:59 - (1-gen-1002) : The given key was not present in the dictionary.
14:19:59 - IsConnectionValid True
14:19:59 - IsConnectionValid True
14:19:59 - (1-gen-1002) : The given key was not present in the dictionary.
14:19:59 - IsConnectionValid True
14:19:59 - (1-gen-1002) : The given key was not present in the dictionary.
14:19:59 - IsConnectionValid True
14:19:59 - (1-gen-1002) : The given key was not present in the dictionary.
14:19:59 - IsConnectionValid True
14:19:59 - (1-gen-1002) : The given key was not present in the dictionary.
14:19:59 - (1-gen-1002) : The given key was not present in the dictionary.
14:19:59 - IsConnectionValid True
14:19:59 - IsConnectionValid True
14:19:59 - (1-gen-1002) : The given key was not present in the dictionary.
14:19:59 - (1-gen-1002) : The given key was not present in the dictionary.
14:19:59 - IsConnectionValid True
14:19:59 - (1-gen-1002) : The given key was not present in the dictionary.
14:19:59 - IsConnectionValid True
14:19:59 - IsConnectionValid True
14:19:59 - (1-gen-1002) : The given key was not present in the dictionary.
14:19:59 - (1-gen-1002) : The given key was not present in the dictionary.
14:19:59 - IsConnectionValid True
14:19:59 - (1-gen-1002) : The given key was not present in the dictionary.
14:19:59 - IsConnectionValid True
14:19:59 - IsConnectionValid True
14:19:59 - (1-gen-1002) : The given key was not present in the dictionary.
14:19:59 - (1-gen-1002) : The given key was not present in the dictionary.
14:19:59 - IsConnectionValid True
14:19:59 - IsConnectionValid True
14:19:59 - IsConnectionValid True
14:20:00 - (1-gen-1002) : The given key was not present in the dictionary.
14:20:00 - IsConnectionValid True
14:20:00 - IsConnectionValid True
14:20:00 - (1-gen-1002) : The given key was not present in the dictionary.
14:20:00 - IsConnectionValid True
14:20:00 - IsConnectionValid True
14:20:00 - IsConnectionValid True
14:20:00 - IsConnectionValid True
14:20:00 - (1-gen-1002) : The given key was not present in the dictionary.
14:20:00 - (1-gen-1002) : The given key was not present in the dictionary.
14:20:00 - (1-gen-1002) : The given key was not present in the dictionary.
14:20:00 - (1-gen-1002) : The given key was not present in the dictionary.
14:20:00 - IsConnectionValid True
14:20:00 - (1-gen-1002) : The given key was not present in the dictionary.
14:20:00 - IsConnectionValid True
14:20:00 - IsConnectionValid True
14:20:00 - (1-gen-1002) : The given key was not present in the dictionary.
14:20:00 - IsConnectionValid True
14:20:00 - IsConnectionValid True
14:20:00 - (1-gen-1002) : The given key was not present in the dictionary.
14:20:00 - (1-gen-1002) : The given key was not present in the dictionary.
14:20:00 - (1-gen-1002) : The given key was not present in the dictionary.
14:20:00 - (1-gen-1002) : The given key was not present in the dictionary.
14:20:00 - IsConnectionValid True
14:20:00 - (1-gen-1002) : The given key was not present in the dictionary.
14:20:00 - IsConnectionValid True
14:20:00 - (1-gen-1002) : The given key was not present in the dictionary.
14:20:00 - IsConnectionValid True
14:20:00 - IsConnectionValid True
14:20:00 - (1-gen-1002) : The given key was not present in the dictionary.
14:20:00 - IsConnectionValid True
14:20:00 - (1-gen-1002) : The given key was not present in the dictionary.
14:20:00 - (1-gen-1002) : The given key was not present in the dictionary.
14:20:00 - IsConnectionValid True
14:20:00 - (1-gen-1002) : The given key was not present in the dictionary.
14:20:00 - (1-gen-1002) : The given key was not present in the dictionary.
14:20:00 - IsConnectionValid True
14:20:00 - IsConnectionValid True
14:20:00 - IsConnectionValid True
14:20:00 - IsConnectionValid True
14:20:00 - (1-gen-1002) : The given key was not present in the dictionary.
14:20:00 - (1-gen-1002) : The given key was not present in the dictionary.
14:20:00 - IsConnectionValid True
14:20:00 - (1-gen-1002) : The given key was not present in the dictionary.
14:20:00 - (1-gen-1002) : The given key was not present in the dictionary.
14:20:00 - IsConnectionValid True
14:20:00 - IsConnectionValid True
14:20:00 - (1-gen-1002) : The given key was not present in the dictionary.
14:20:00 - IsConnectionValid True
14:20:00 - (1-gen-1002) : The given key was not present in the dictionary.
14:20:00 - (1-gen-1002) : The given key was not present in the dictionary.
14:20:00 - IsConnectionValid True
14:20:00 - IsConnectionValid True
14:20:00 - (1-gen-1002) : The given key was not present in the dictionary.
14:20:00 - (1-gen-1002) : The given key was not present in the dictionary.
14:20:00 - IsConnectionValid True
14:20:00 - (1-gen-1002) : The given key was not present in the dictionary.
14:20:00 - IsConnectionValid True
14:20:00 - (1-gen-1002) : The given key was not present in the dictionary.
14:20:00 - IsConnectionValid True
14:20:00 - (1-gen-1002) : The given key was not present in the dictionary.
14:20:00 - IsConnectionValid True
14:20:00 - (1-gen-1002) : The given key was not present in the dictionary.
14:20:00 - IsConnectionValid True
14:20:00 - (1-gen-1002) : The given key was not present in the dictionary.
14:20:00 - IsConnectionValid True
14:20:00 - (1-gen-1002) : The given key was not present in the dictionary.
14:20:00 - IsConnectionValid True
14:20:00 - (1-gen-1002) : The given key was not present in the dictionary.
14:20:00 - IsConnectionValid True
14:20:00 - (1-gen-1002) : The given key was not present in the dictionary.
14:20:00 - (1-gen-1002) : The given key was not present in the dictionary.
14:20:00 - IsConnectionValid True
14:20:00 - IsConnectionValid True
14:20:00 - (1-gen-1002) : The given key was not present in the dictionary.
14:20:00 - IsConnectionValid True
14:20:00 - IsConnectionValid True
14:20:00 - (1-gen-1002) : The given key was not present in the dictionary.
14:20:00 - (1-gen-1002) : The given key was not present in the dictionary.
14:20:00 - (1-gen-1002) : The given key was not present in the dictionary.
14:20:00 - IsConnectionValid True
14:20:00 - (1-gen-1002) : The given key was not present in the dictionary.
14:20:00 - IsConnectionValid True
14:20:00 - (1-gen-1002) : The given key was not present in the dictionary.
14:20:00 - IsConnectionValid True
14:20:00 - (1-gen-1002) : The given key was not present in the dictionary.
14:20:00 - (1-gen-1002) : The given key was not present in the dictionary.
14:20:00 - IsConnectionValid True
14:20:00 - (1-gen-1002) : The given key was not present in the dictionary.
14:20:00 - (1-gen-1002) : The given key was not present in the dictionary.
14:20:00 - IsConnectionValid True
14:20:00 - IsConnectionValid True
14:20:00 - (1-gen-1002) : The given key was not present in the dictionary.
14:20:00 - IsConnectionValid True
14:20:00 - (1-gen-1002) : The given key was not present in the dictionary.
14:20:00 - IsConnectionValid True
14:20:00 - (1-gen-1002) : The given key was not present in the dictionary.
14:20:00 - IsConnectionValid True
14:20:00 - IsConnectionValid True
14:20:00 - (1-gen-1002) : The given key was not present in the dictionary.
14:20:00 - (1-gen-1002) : The given key was not present in the dictionary.
14:20:00 - IsConnectionValid True
14:20:00 - IsConnectionValid True
14:20:00 - IsConnectionValid True
14:20:00 - (1-gen-1002) : The given key was not present in the dictionary.
14:20:00 - IsConnectionValid True
14:20:00 - (1-gen-1002) : The given key was not present in the dictionary.
14:20:00 - (1-gen-1002) : The given key was not present in the dictionary.
14:20:00 - (1-gen-1002) : The given key was not present in the dictionary.
14:20:00 - (1-gen-1002) : The given key was not present in the dictionary.
14:20:21 - IsConnectionValid True
14:20:21 - 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 =01/01/1900 or (DateleftTemp<>DateLeft and DateLeft >01/10/2023)) and UserID = @val1 and TenantID = @val2  ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow
14:21:43 - IsConnectionValid True
14:21:43 - finalQuery  ;WITH CTE AS (SELECT  ROW_NUMBER() OVER ( ORDER BY ID ASC) AS rn, COUNT(*) OVER() AS _total, * FROM (SELECT ID AS ID, Code AS Code, Name AS Name, Type AS Type FROM VacationTypes  WHERE  TenantID = 1 AND   TenantID = @val0  ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow
14:21:44 - IsConnectionValid True
14:21:44 - SELECT * FROM VwVacationEntry WHERE TenantID = 1 AND   TenantID = @val0 AND EmployeeID = @val1 AND UserID = @val2 AND VacationType = @val3 ORDER BY FromDate ASC  Query
14:21:44 - (1-gen-1002) : Invalid column name 'TenantID'.
Invalid column name 'TenantID'.
14:21:45 - IsConnectionValid True
14:21:45 - IsConnectionValid True
14:21:45 - IsConnectionValid True
14:21:45 - IsConnectionValid True
14:21:45 - IsConnectionValid True
14:21:45 - (1-gen-1002) : The given key was not present in the dictionary.
14:21:45 - IsConnectionValid True
14:21:45 - (1-gen-1002) : The given key was not present in the dictionary.
14:21:45 - (1-gen-1002) : The given key was not present in the dictionary.
14:21:45 - (1-gen-1002) : The given key was not present in the dictionary.
14:21:45 - (1-gen-1002) : The given key was not present in the dictionary.
14:21:45 - IsConnectionValid True
14:21:45 - IsConnectionValid True
14:21:45 - IsConnectionValid True
14:21:45 - (1-gen-1002) : The given key was not present in the dictionary.
14:21:45 - IsConnectionValid True
14:21:45 - IsConnectionValid True
14:21:45 - (1-gen-1002) : The given key was not present in the dictionary.
14:21:45 - (1-gen-1002) : The given key was not present in the dictionary.
14:21:45 - IsConnectionValid True
14:21:45 - (1-gen-1002) : The given key was not present in the dictionary.
14:21:45 - IsConnectionValid True
14:21:45 - (1-gen-1002) : The given key was not present in the dictionary.
14:21:45 - IsConnectionValid True
14:21:45 - (1-gen-1002) : The given key was not present in the dictionary.
14:21:45 - IsConnectionValid True
14:21:45 - (1-gen-1002) : The given key was not present in the dictionary.
14:21:45 - (1-gen-1002) : The given key was not present in the dictionary.
14:21:45 - IsConnectionValid True
14:21:45 - IsConnectionValid True
14:21:45 - (1-gen-1002) : The given key was not present in the dictionary.
14:21:45 - IsConnectionValid True
14:21:45 - (1-gen-1002) : The given key was not present in the dictionary.
14:21:45 - (1-gen-1002) : The given key was not present in the dictionary.
14:21:45 - IsConnectionValid True
14:21:45 - IsConnectionValid True
14:21:45 - (1-gen-1002) : The given key was not present in the dictionary.
14:21:45 - (1-gen-1002) : The given key was not present in the dictionary.
14:21:45 - (1-gen-1002) : The given key was not present in the dictionary.
14:21:45 - IsConnectionValid True
14:21:45 - IsConnectionValid True
14:21:45 - (1-gen-1002) : The given key was not present in the dictionary.
14:21:45 - IsConnectionValid True
14:21:45 - IsConnectionValid True
14:21:45 - (1-gen-1002) : The given key was not present in the dictionary.
14:21:45 - (1-gen-1002) : The given key was not present in the dictionary.
14:21:45 - IsConnectionValid True
14:21:45 - IsConnectionValid True
14:21:45 - (1-gen-1002) : The given key was not present in the dictionary.
14:21:45 - (1-gen-1002) : The given key was not present in the dictionary.
14:21:45 - IsConnectionValid True
14:21:45 - (1-gen-1002) : The given key was not present in the dictionary.
14:21:45 - IsConnectionValid True
14:21:45 - (1-gen-1002) : The given key was not present in the dictionary.
14:21:45 - IsConnectionValid True
14:21:45 - (1-gen-1002) : The given key was not present in the dictionary.
14:21:45 - IsConnectionValid True
14:21:45 - (1-gen-1002) : The given key was not present in the dictionary.
14:21:45 - IsConnectionValid True
14:21:45 - (1-gen-1002) : The given key was not present in the dictionary.
14:21:45 - (1-gen-1002) : The given key was not present in the dictionary.
14:21:45 - IsConnectionValid True
14:21:45 - (1-gen-1002) : The given key was not present in the dictionary.
14:21:45 - IsConnectionValid True
14:21:45 - IsConnectionValid True
14:21:45 - IsConnectionValid True
14:21:45 - (1-gen-1002) : The given key was not present in the dictionary.
14:21:45 - IsConnectionValid True
14:21:45 - (1-gen-1002) : The given key was not present in the dictionary.
14:21:45 - IsConnectionValid True
14:21:45 - (1-gen-1002) : The given key was not present in the dictionary.
14:21:45 - IsConnectionValid True
14:21:45 - (1-gen-1002) : The given key was not present in the dictionary.
14:21:45 - (1-gen-1002) : The given key was not present in the dictionary.
14:21:45 - (1-gen-1002) : The given key was not present in the dictionary.
14:21:45 - IsConnectionValid True
14:21:45 - IsConnectionValid True
14:21:45 - (1-gen-1002) : The given key was not present in the dictionary.
14:21:45 - (1-gen-1002) : The given key was not present in the dictionary.
14:21:45 - IsConnectionValid True
14:21:45 - (1-gen-1002) : The given key was not present in the dictionary.
14:21:45 - IsConnectionValid True
14:21:45 - IsConnectionValid True
14:21:45 - IsConnectionValid True
14:21:45 - (1-gen-1002) : The given key was not present in the dictionary.
14:21:45 - IsConnectionValid True
14:21:45 - IsConnectionValid True
14:21:45 - (1-gen-1002) : The given key was not present in the dictionary.
14:21:45 - (1-gen-1002) : The given key was not present in the dictionary.
14:21:45 - IsConnectionValid True
14:21:45 - (1-gen-1002) : The given key was not present in the dictionary.
14:21:46 - IsConnectionValid True
14:21:46 - (1-gen-1002) : The given key was not present in the dictionary.
14:21:46 - (1-gen-1002) : The given key was not present in the dictionary.
14:21:46 - (1-gen-1002) : The given key was not present in the dictionary.
14:21:46 - IsConnectionValid True
14:21:46 - IsConnectionValid True
14:21:46 - IsConnectionValid True
14:21:46 - IsConnectionValid True
14:21:46 - IsConnectionValid True
14:21:46 - (1-gen-1002) : The given key was not present in the dictionary.
14:21:46 - (1-gen-1002) : The given key was not present in the dictionary.
14:21:46 - (1-gen-1002) : The given key was not present in the dictionary.
14:21:46 - (1-gen-1002) : The given key was not present in the dictionary.
14:21:46 - IsConnectionValid True
14:21:46 - (1-gen-1002) : The given key was not present in the dictionary.
14:21:46 - IsConnectionValid True
14:21:46 - IsConnectionValid True
14:21:46 - (1-gen-1002) : The given key was not present in the dictionary.
14:21:46 - IsConnectionValid True
14:21:46 - IsConnectionValid True
14:21:46 - (1-gen-1002) : The given key was not present in the dictionary.
14:21:46 - (1-gen-1002) : The given key was not present in the dictionary.
14:21:46 - (1-gen-1002) : The given key was not present in the dictionary.
14:21:46 - (1-gen-1002) : The given key was not present in the dictionary.
14:21:46 - IsConnectionValid True
14:21:46 - (1-gen-1002) : The given key was not present in the dictionary.
14:21:46 - IsConnectionValid True
14:21:46 - (1-gen-1002) : The given key was not present in the dictionary.
14:21:46 - IsConnectionValid True
14:21:46 - IsConnectionValid True
14:21:46 - (1-gen-1002) : The given key was not present in the dictionary.
14:21:46 - IsConnectionValid True
14:21:46 - (1-gen-1002) : The given key was not present in the dictionary.
14:21:46 - IsConnectionValid True
14:21:46 - (1-gen-1002) : The given key was not present in the dictionary.
14:21:46 - IsConnectionValid True
14:21:46 - (1-gen-1002) : The given key was not present in the dictionary.
14:21:46 - (1-gen-1002) : The given key was not present in the dictionary.
14:21:46 - IsConnectionValid True
14:21:46 - (1-gen-1002) : The given key was not present in the dictionary.
14:21:46 - IsConnectionValid True
14:21:46 - IsConnectionValid True
14:21:46 - IsConnectionValid True
14:21:46 - IsConnectionValid True
14:21:46 - (1-gen-1002) : The given key was not present in the dictionary.
14:21:46 - (1-gen-1002) : The given key was not present in the dictionary.
14:21:46 - (1-gen-1002) : The given key was not present in the dictionary.
14:21:46 - IsConnectionValid True
14:21:46 - IsConnectionValid True
14:21:46 - (1-gen-1002) : The given key was not present in the dictionary.
14:21:46 - IsConnectionValid True
14:21:46 - (1-gen-1002) : The given key was not present in the dictionary.
14:21:46 - (1-gen-1002) : The given key was not present in the dictionary.
14:21:46 - (1-gen-1002) : The given key was not present in the dictionary.
14:21:46 - (1-gen-1002) : The given key was not present in the dictionary.
14:21:46 - IsConnectionValid True
14:21:46 - (1-gen-1002) : The given key was not present in the dictionary.
14:21:46 - IsConnectionValid True
14:21:46 - (1-gen-1002) : The given key was not present in the dictionary.
14:21:46 - IsConnectionValid True
14:21:46 - IsConnectionValid True
14:21:46 - (1-gen-1002) : The given key was not present in the dictionary.
14:21:46 - IsConnectionValid True
14:21:46 - (1-gen-1002) : The given key was not present in the dictionary.
14:21:46 - IsConnectionValid True
14:21:46 - (1-gen-1002) : The given key was not present in the dictionary.
14:21:46 - (1-gen-1002) : The given key was not present in the dictionary.
14:21:46 - IsConnectionValid True
14:21:46 - IsConnectionValid True
14:21:46 - (1-gen-1002) : The given key was not present in the dictionary.
14:21:46 - IsConnectionValid True
14:21:46 - (1-gen-1002) : The given key was not present in the dictionary.
14:21:46 - (1-gen-1002) : The given key was not present in the dictionary.
14:21:46 - IsConnectionValid True
14:21:46 - (1-gen-1002) : The given key was not present in the dictionary.
14:21:46 - IsConnectionValid True
14:21:46 - (1-gen-1002) : The given key was not present in the dictionary.
14:21:46 - (1-gen-1002) : The given key was not present in the dictionary.
14:21:46 - IsConnectionValid True
14:21:46 - IsConnectionValid True
14:21:46 - (1-gen-1002) : The given key was not present in the dictionary.
14:21:46 - IsConnectionValid True
14:21:46 - IsConnectionValid True
14:21:46 - (1-gen-1002) : The given key was not present in the dictionary.
14:21:46 - (1-gen-1002) : The given key was not present in the dictionary.
14:21:46 - (1-gen-1002) : The given key was not present in the dictionary.
14:21:46 - IsConnectionValid True
14:21:46 - IsConnectionValid True
14:21:46 - IsConnectionValid True
14:21:46 - (1-gen-1002) : The given key was not present in the dictionary.
14:21:46 - (1-gen-1002) : The given key was not present in the dictionary.
14:21:46 - (1-gen-1002) : The given key was not present in the dictionary.
14:21:46 - (1-gen-1002) : The given key was not present in the dictionary.
14:21:46 - (1-gen-1002) : The given key was not present in the dictionary.
14:21:46 - IsConnectionValid True
14:21:46 - IsConnectionValid True
14:21:46 - (1-gen-1002) : The given key was not present in the dictionary.
14:21:46 - IsConnectionValid True
14:21:46 - IsConnectionValid True
14:21:46 - (1-gen-1002) : The given key was not present in the dictionary.
14:21:46 - (1-gen-1002) : The given key was not present in the dictionary.
14:21:46 - IsConnectionValid True
14:21:46 - (1-gen-1002) : The given key was not present in the dictionary.
14:21:46 - IsConnectionValid True
14:21:46 - (1-gen-1002) : The given key was not present in the dictionary.
14:21:46 - IsConnectionValid True
14:21:46 - (1-gen-1002) : The given key was not present in the dictionary.
14:21:46 - IsConnectionValid True
14:21:46 - (1-gen-1002) : The given key was not present in the dictionary.
14:21:46 - (1-gen-1002) : The given key was not present in the dictionary.
14:21:46 - (1-gen-1002) : The given key was not present in the dictionary.
14:21:46 - (1-gen-1002) : The given key was not present in the dictionary.
14:22:09 - IsConnectionValid True
14:22:09 - SELECT * FROM VwVacationEntry WHERE TenantID = 1 AND   TenantID = @val0 AND EmployeeID = @val1 AND UserID = @val2 AND VacationType = @val3 ORDER BY FromDate ASC  Query
14:22:09 - (1-gen-1002) : Invalid column name 'TenantID'.
Invalid column name 'TenantID'.
14:22:11 - IsConnectionValid True
14:22:11 - IsConnectionValid True
14:22:11 - IsConnectionValid True
14:22:11 - IsConnectionValid True
14:22:11 - (1-gen-1002) : The given key was not present in the dictionary.
14:22:11 - IsConnectionValid True
14:22:11 - IsConnectionValid True
14:22:11 - (1-gen-1002) : The given key was not present in the dictionary.
14:22:11 - (1-gen-1002) : The given key was not present in the dictionary.
14:22:11 - (1-gen-1002) : The given key was not present in the dictionary.
14:22:11 - (1-gen-1002) : The given key was not present in the dictionary.
14:22:11 - IsConnectionValid True
14:22:11 - (1-gen-1002) : The given key was not present in the dictionary.
14:22:11 - IsConnectionValid True
14:22:11 - (1-gen-1002) : The given key was not present in the dictionary.
14:22:11 - IsConnectionValid True
14:22:11 - IsConnectionValid True
14:22:11 - IsConnectionValid True
14:22:11 - (1-gen-1002) : The given key was not present in the dictionary.
14:22:11 - IsConnectionValid True
14:22:11 - (1-gen-1002) : The given key was not present in the dictionary.
14:22:11 - (1-gen-1002) : The given key was not present in the dictionary.
14:22:11 - (1-gen-1002) : The given key was not present in the dictionary.
14:22:11 - IsConnectionValid True
14:22:11 - (1-gen-1002) : The given key was not present in the dictionary.
14:22:11 - (1-gen-1002) : The given key was not present in the dictionary.
14:22:11 - (1-gen-1002) : The given key was not present in the dictionary.
14:22:11 - IsConnectionValid True
14:22:11 - (1-gen-1002) : The given key was not present in the dictionary.
14:22:11 - IsConnectionValid True
14:22:11 - IsConnectionValid True
14:22:11 - IsConnectionValid True
14:22:11 - (1-gen-1002) : The given key was not present in the dictionary.
14:22:11 - IsConnectionValid True
14:22:11 - (1-gen-1002) : The given key was not present in the dictionary.
14:22:11 - (1-gen-1002) : The given key was not present in the dictionary.
14:22:11 - IsConnectionValid True
14:22:11 - IsConnectionValid True
14:22:11 - (1-gen-1002) : The given key was not present in the dictionary.
14:22:11 - IsConnectionValid True
14:22:11 - (1-gen-1002) : The given key was not present in the dictionary.
14:22:11 - (1-gen-1002) : The given key was not present in the dictionary.
14:22:11 - IsConnectionValid True
14:22:11 - IsConnectionValid True
14:22:11 - (1-gen-1002) : The given key was not present in the dictionary.
14:22:11 - (1-gen-1002) : The given key was not present in the dictionary.
14:22:11 - (1-gen-1002) : The given key was not present in the dictionary.
14:22:11 - IsConnectionValid True
14:22:11 - IsConnectionValid True
14:22:11 - IsConnectionValid True
14:22:11 - (1-gen-1002) : The given key was not present in the dictionary.
14:22:11 - IsConnectionValid True
14:22:11 - (1-gen-1002) : The given key was not present in the dictionary.
14:22:11 - IsConnectionValid True
14:22:11 - (1-gen-1002) : The given key was not present in the dictionary.
14:22:11 - (1-gen-1002) : The given key was not present in the dictionary.
14:22:11 - (1-gen-1002) : The given key was not present in the dictionary.
14:22:11 - IsConnectionValid True
14:22:11 - IsConnectionValid True
14:22:11 - IsConnectionValid True
14:22:11 - (1-gen-1002) : The given key was not present in the dictionary.
14:22:11 - IsConnectionValid True
14:22:11 - (1-gen-1002) : The given key was not present in the dictionary.
14:22:11 - (1-gen-1002) : The given key was not present in the dictionary.
14:22:11 - IsConnectionValid True
14:22:11 - (1-gen-1002) : The given key was not present in the dictionary.
14:22:11 - (1-gen-1002) : The given key was not present in the dictionary.
14:22:11 - IsConnectionValid True
14:22:11 - (1-gen-1002) : The given key was not present in the dictionary.
14:22:11 - IsConnectionValid True
14:22:11 - IsConnectionValid True
14:22:11 - (1-gen-1002) : The given key was not present in the dictionary.
14:22:11 - IsConnectionValid True
14:22:11 - IsConnectionValid True
14:22:11 - (1-gen-1002) : The given key was not present in the dictionary.
14:22:11 - (1-gen-1002) : The given key was not present in the dictionary.
14:22:11 - IsConnectionValid True
14:22:11 - IsConnectionValid True
14:22:11 - (1-gen-1002) : The given key was not present in the dictionary.
14:22:11 - (1-gen-1002) : The given key was not present in the dictionary.
14:22:11 - (1-gen-1002) : The given key was not present in the dictionary.
14:22:11 - IsConnectionValid True
14:22:11 - IsConnectionValid True
14:22:11 - IsConnectionValid True
14:22:11 - IsConnectionValid True
14:22:11 - (1-gen-1002) : The given key was not present in the dictionary.
14:22:11 - (1-gen-1002) : The given key was not present in the dictionary.
14:22:11 - IsConnectionValid True
14:22:11 - (1-gen-1002) : The given key was not present in the dictionary.
14:22:11 - (1-gen-1002) : The given key was not present in the dictionary.
14:22:11 - (1-gen-1002) : The given key was not present in the dictionary.
14:22:11 - (1-gen-1002) : The given key was not present in the dictionary.
14:22:11 - IsConnectionValid True
14:22:11 - IsConnectionValid True
14:22:11 - IsConnectionValid True
14:22:11 - (1-gen-1002) : The given key was not present in the dictionary.
14:22:11 - IsConnectionValid True
14:22:11 - IsConnectionValid True
14:22:11 - (1-gen-1002) : The given key was not present in the dictionary.
14:22:11 - IsConnectionValid True
14:22:11 - (1-gen-1002) : The given key was not present in the dictionary.
14:22:11 - (1-gen-1002) : The given key was not present in the dictionary.
14:22:11 - IsConnectionValid True
14:22:11 - IsConnectionValid True
14:22:11 - (1-gen-1002) : The given key was not present in the dictionary.
14:22:11 - (1-gen-1002) : The given key was not present in the dictionary.
14:22:11 - IsConnectionValid True
14:22:11 - (1-gen-1002) : The given key was not present in the dictionary.
14:22:11 - IsConnectionValid True
14:22:11 - (1-gen-1002) : The given key was not present in the dictionary.
14:22:11 - (1-gen-1002) : The given key was not present in the dictionary.
14:22:11 - (1-gen-1002) : The given key was not present in the dictionary.
14:22:11 - (1-gen-1002) : The given key was not present in the dictionary.
14:22:11 - IsConnectionValid True
14:22:11 - IsConnectionValid True
14:22:11 - IsConnectionValid True
14:22:11 - (1-gen-1002) : The given key was not present in the dictionary.
14:22:11 - IsConnectionValid True
14:22:11 - (1-gen-1002) : The given key was not present in the dictionary.
14:22:11 - (1-gen-1002) : The given key was not present in the dictionary.
14:22:11 - (1-gen-1002) : The given key was not present in the dictionary.
14:22:11 - (1-gen-1002) : The given key was not present in the dictionary.
14:22:11 - IsConnectionValid True
14:22:11 - IsConnectionValid True
14:22:11 - IsConnectionValid True
14:22:11 - IsConnectionValid True
14:22:11 - IsConnectionValid True
14:22:11 - (1-gen-1002) : The given key was not present in the dictionary.
14:22:11 - (1-gen-1002) : The given key was not present in the dictionary.
14:22:11 - (1-gen-1002) : The given key was not present in the dictionary.
14:22:11 - (1-gen-1002) : The given key was not present in the dictionary.
14:22:11 - (1-gen-1002) : The given key was not present in the dictionary.
14:22:11 - (1-gen-1002) : The given key was not present in the dictionary.
14:22:11 - IsConnectionValid True
14:22:11 - (1-gen-1002) : The given key was not present in the dictionary.
14:22:11 - IsConnectionValid True
14:22:11 - IsConnectionValid True
14:22:11 - IsConnectionValid True
14:22:11 - IsConnectionValid True
14:22:11 - IsConnectionValid True
14:22:11 - (1-gen-1002) : The given key was not present in the dictionary.
14:22:11 - (1-gen-1002) : The given key was not present in the dictionary.
14:22:11 - IsConnectionValid True
14:22:11 - (1-gen-1002) : The given key was not present in the dictionary.
14:22:11 - (1-gen-1002) : The given key was not present in the dictionary.
14:22:11 - IsConnectionValid True
14:22:11 - (1-gen-1002) : The given key was not present in the dictionary.
14:22:11 - (1-gen-1002) : The given key was not present in the dictionary.
14:22:11 - IsConnectionValid True
14:22:11 - IsConnectionValid True
14:22:11 - (1-gen-1002) : The given key was not present in the dictionary.
14:22:11 - IsConnectionValid True
14:22:11 - IsConnectionValid True
14:22:11 - IsConnectionValid True
14:22:11 - IsConnectionValid True
14:22:11 - (1-gen-1002) : The given key was not present in the dictionary.
14:22:11 - IsConnectionValid True
14:22:11 - (1-gen-1002) : The given key was not present in the dictionary.
14:22:11 - IsConnectionValid True
14:22:11 - (1-gen-1002) : The given key was not present in the dictionary.
14:22:11 - IsConnectionValid True
14:22:11 - (1-gen-1002) : The given key was not present in the dictionary.
14:22:11 - IsConnectionValid True
14:22:11 - (1-gen-1002) : The given key was not present in the dictionary.
14:22:11 - IsConnectionValid True
14:22:11 - IsConnectionValid True
14:22:12 - (1-gen-1002) : The given key was not present in the dictionary.
14:22:12 - IsConnectionValid True
14:22:12 - (1-gen-1002) : The given key was not present in the dictionary.
14:22:12 - IsConnectionValid True
14:22:12 - (1-gen-1002) : The given key was not present in the dictionary.
14:22:12 - IsConnectionValid True
14:22:12 - (1-gen-1002) : The given key was not present in the dictionary.
14:22:12 - IsConnectionValid True
14:22:12 - (1-gen-1002) : The given key was not present in the dictionary.
14:22:12 - IsConnectionValid True
14:22:12 - (1-gen-1002) : The given key was not present in the dictionary.
14:22:12 - IsConnectionValid True
14:22:12 - IsConnectionValid True
14:22:12 - (1-gen-1002) : The given key was not present in the dictionary.
14:22:12 - IsConnectionValid True
14:22:12 - (1-gen-1002) : The given key was not present in the dictionary.
14:22:12 - (1-gen-1002) : The given key was not present in the dictionary.
14:22:12 - IsConnectionValid True
14:22:12 - (1-gen-1002) : The given key was not present in the dictionary.
14:22:12 - (1-gen-1002) : The given key was not present in the dictionary.
14:22:12 - IsConnectionValid True
14:22:12 - IsConnectionValid True
14:22:12 - (1-gen-1002) : The given key was not present in the dictionary.
14:22:12 - IsConnectionValid True
14:22:12 - IsConnectionValid True
14:22:12 - (1-gen-1002) : The given key was not present in the dictionary.
14:22:12 - (1-gen-1002) : The given key was not present in the dictionary.
14:22:12 - (1-gen-1002) : The given key was not present in the dictionary.
14:22:12 - IsConnectionValid True
14:22:12 - IsConnectionValid True
14:22:12 - (1-gen-1002) : The given key was not present in the dictionary.
14:22:12 - (1-gen-1002) : The given key was not present in the dictionary.
14:22:12 - (1-gen-1002) : The given key was not present in the dictionary.
14:22:14 - IsConnectionValid True
14:22:14 - SELECT * FROM VwVacationEntry WHERE TenantID = 1 AND   TenantID = @val0 AND EmployeeID = @val1 AND UserID = @val2 AND VacationType = @val3 AND CAST(FromDate AS Date) >= @val4 AND CAST(ToDate AS Date) <= @val5 ORDER BY FromDate ASC  Query
14:22:14 - (1-gen-1002) : Invalid column name 'TenantID'.
Invalid column name 'TenantID'.
14:22:15 - IsConnectionValid True
14:22:15 - IsConnectionValid True
14:22:15 - IsConnectionValid True
14:22:15 - IsConnectionValid True
14:22:15 - (1-gen-1002) : The given key was not present in the dictionary.
14:22:15 - IsConnectionValid True
14:22:15 - (1-gen-1002) : The given key was not present in the dictionary.
14:22:15 - (1-gen-1002) : The given key was not present in the dictionary.
14:22:15 - IsConnectionValid True
14:22:15 - (1-gen-1002) : The given key was not present in the dictionary.
14:22:15 - (1-gen-1002) : The given key was not present in the dictionary.
14:22:15 - (1-gen-1002) : The given key was not present in the dictionary.
14:22:15 - IsConnectionValid True
14:22:15 - IsConnectionValid True
14:22:15 - IsConnectionValid True
14:22:15 - IsConnectionValid True
14:22:15 - IsConnectionValid True
14:22:15 - (1-gen-1002) : The given key was not present in the dictionary.
14:22:15 - IsConnectionValid True
14:22:15 - (1-gen-1002) : The given key was not present in the dictionary.
14:22:15 - (1-gen-1002) : The given key was not present in the dictionary.
14:22:15 - (1-gen-1002) : The given key was not present in the dictionary.
14:22:15 - IsConnectionValid True
14:22:15 - (1-gen-1002) : The given key was not present in the dictionary.
14:22:15 - IsConnectionValid True
14:22:15 - (1-gen-1002) : The given key was not present in the dictionary.
14:22:15 - IsConnectionValid True
14:22:15 - (1-gen-1002) : The given key was not present in the dictionary.
14:22:15 - IsConnectionValid True
14:22:15 - (1-gen-1002) : The given key was not present in the dictionary.
14:22:15 - IsConnectionValid True
14:22:15 - (1-gen-1002) : The given key was not present in the dictionary.
14:22:15 - (1-gen-1002) : The given key was not present in the dictionary.
14:22:15 - IsConnectionValid True
14:22:15 - IsConnectionValid True
14:22:15 - (1-gen-1002) : The given key was not present in the dictionary.
14:22:15 - IsConnectionValid True
14:22:15 - IsConnectionValid True
14:22:15 - IsConnectionValid True
14:22:15 - (1-gen-1002) : The given key was not present in the dictionary.
14:22:15 - IsConnectionValid True
14:22:15 - (1-gen-1002) : The given key was not present in the dictionary.
14:22:15 - (1-gen-1002) : The given key was not present in the dictionary.
14:22:15 - IsConnectionValid True
14:22:15 - IsConnectionValid True
14:22:15 - (1-gen-1002) : The given key was not present in the dictionary.
14:22:15 - IsConnectionValid True
14:22:15 - (1-gen-1002) : The given key was not present in the dictionary.
14:22:15 - IsConnectionValid True
14:22:15 - (1-gen-1002) : The given key was not present in the dictionary.
14:22:15 - (1-gen-1002) : The given key was not present in the dictionary.
14:22:15 - IsConnectionValid True
14:22:15 - (1-gen-1002) : The given key was not present in the dictionary.
14:22:15 - IsConnectionValid True
14:22:15 - (1-gen-1002) : The given key was not present in the dictionary.
14:22:15 - IsConnectionValid True
14:22:15 - IsConnectionValid True
14:22:15 - (1-gen-1002) : The given key was not present in the dictionary.
14:22:15 - IsConnectionValid True
14:22:15 - IsConnectionValid True
14:22:15 - (1-gen-1002) : The given key was not present in the dictionary.
14:22:15 - IsConnectionValid True
14:22:15 - (1-gen-1002) : The given key was not present in the dictionary.
14:22:15 - (1-gen-1002) : The given key was not present in the dictionary.
14:22:15 - IsConnectionValid True
14:22:15 - (1-gen-1002) : The given key was not present in the dictionary.
14:22:15 - (1-gen-1002) : The given key was not present in the dictionary.
14:22:15 - IsConnectionValid True
14:22:15 - (1-gen-1002) : The given key was not present in the dictionary.
14:22:15 - (1-gen-1002) : The given key was not present in the dictionary.
14:22:15 - (1-gen-1002) : The given key was not present in the dictionary.
14:22:15 - (1-gen-1002) : The given key was not present in the dictionary.
14:22:15 - IsConnectionValid True
14:22:15 - IsConnectionValid True
14:22:15 - IsConnectionValid True
14:22:15 - IsConnectionValid True
14:22:15 - IsConnectionValid True
14:22:15 - (1-gen-1002) : The given key was not present in the dictionary.
14:22:15 - IsConnectionValid True
14:22:15 - (1-gen-1002) : The given key was not present in the dictionary.
14:22:15 - (1-gen-1002) : The given key was not present in the dictionary.
14:22:15 - (1-gen-1002) : The given key was not present in the dictionary.
14:22:15 - IsConnectionValid True
14:22:15 - IsConnectionValid True
14:22:15 - (1-gen-1002) : The given key was not present in the dictionary.
14:22:15 - IsConnectionValid True
14:22:15 - IsConnectionValid True
14:22:15 - (1-gen-1002) : The given key was not present in the dictionary.
14:22:15 - (1-gen-1002) : The given key was not present in the dictionary.
14:22:15 - IsConnectionValid True
14:22:15 - (1-gen-1002) : The given key was not present in the dictionary.
14:22:15 - IsConnectionValid True
14:22:15 - IsConnectionValid True
14:22:15 - (1-gen-1002) : The given key was not present in the dictionary.
14:22:15 - (1-gen-1002) : The given key was not present in the dictionary.
14:22:15 - (1-gen-1002) : The given key was not present in the dictionary.
14:22:15 - IsConnectionValid True
14:22:15 - (1-gen-1002) : The given key was not present in the dictionary.
14:22:15 - IsConnectionValid True
14:22:15 - IsConnectionValid True
14:22:15 - (1-gen-1002) : The given key was not present in the dictionary.
14:22:15 - IsConnectionValid True
14:22:15 - (1-gen-1002) : The given key was not present in the dictionary.
14:22:15 - IsConnectionValid True
14:22:15 - IsConnectionValid True
14:22:15 - (1-gen-1002) : The given key was not present in the dictionary.
14:22:15 - (1-gen-1002) : The given key was not present in the dictionary.
14:22:15 - (1-gen-1002) : The given key was not present in the dictionary.
14:22:15 - IsConnectionValid True
14:22:15 - (1-gen-1002) : The given key was not present in the dictionary.
14:22:16 - IsConnectionValid True
14:22:16 - IsConnectionValid True
14:22:16 - (1-gen-1002) : The given key was not present in the dictionary.
14:22:16 - IsConnectionValid True
14:22:16 - (1-gen-1002) : The given key was not present in the dictionary.
14:22:16 - (1-gen-1002) : The given key was not present in the dictionary.
14:22:16 - IsConnectionValid True
14:22:16 - (1-gen-1002) : The given key was not present in the dictionary.
14:22:16 - IsConnectionValid True
14:22:16 - IsConnectionValid True
14:22:16 - (1-gen-1002) : The given key was not present in the dictionary.
14:22:16 - IsConnectionValid True
14:22:16 - (1-gen-1002) : The given key was not present in the dictionary.
14:22:16 - (1-gen-1002) : The given key was not present in the dictionary.
14:22:16 - IsConnectionValid True
14:22:16 - IsConnectionValid True
14:22:16 - (1-gen-1002) : The given key was not present in the dictionary.
14:22:16 - IsConnectionValid True
14:22:16 - IsConnectionValid True
14:22:16 - (1-gen-1002) : The given key was not present in the dictionary.
14:22:16 - IsConnectionValid True
14:22:16 - IsConnectionValid True
14:22:16 - (1-gen-1002) : The given key was not present in the dictionary.
14:22:16 - (1-gen-1002) : The given key was not present in the dictionary.
14:22:16 - IsConnectionValid True
14:22:16 - (1-gen-1002) : The given key was not present in the dictionary.
14:22:16 - IsConnectionValid True
14:22:16 - (1-gen-1002) : The given key was not present in the dictionary.
14:22:16 - IsConnectionValid True
14:22:16 - IsConnectionValid True
14:22:16 - (1-gen-1002) : The given key was not present in the dictionary.
14:22:16 - IsConnectionValid True
14:22:16 - (1-gen-1002) : The given key was not present in the dictionary.
14:22:16 - IsConnectionValid True
14:22:16 - (1-gen-1002) : The given key was not present in the dictionary.
14:22:16 - (1-gen-1002) : The given key was not present in the dictionary.
14:22:16 - IsConnectionValid True
14:22:16 - IsConnectionValid True
14:22:16 - (1-gen-1002) : The given key was not present in the dictionary.
14:22:16 - IsConnectionValid True
14:22:16 - (1-gen-1002) : The given key was not present in the dictionary.
14:22:16 - (1-gen-1002) : The given key was not present in the dictionary.
14:22:16 - IsConnectionValid True
14:22:16 - IsConnectionValid True
14:22:16 - (1-gen-1002) : The given key was not present in the dictionary.
14:22:16 - IsConnectionValid True
14:22:16 - (1-gen-1002) : The given key was not present in the dictionary.
14:22:16 - (1-gen-1002) : The given key was not present in the dictionary.
14:22:16 - IsConnectionValid True
14:22:16 - IsConnectionValid True
14:22:16 - (1-gen-1002) : The given key was not present in the dictionary.
14:22:16 - IsConnectionValid True
14:22:16 - (1-gen-1002) : The given key was not present in the dictionary.
14:22:16 - IsConnectionValid True
14:22:16 - (1-gen-1002) : The given key was not present in the dictionary.
14:22:16 - IsConnectionValid True
14:22:16 - (1-gen-1002) : The given key was not present in the dictionary.
14:22:16 - IsConnectionValid True
14:22:16 - IsConnectionValid True
14:22:16 - (1-gen-1002) : The given key was not present in the dictionary.
14:22:16 - IsConnectionValid True
14:22:16 - (1-gen-1002) : The given key was not present in the dictionary.
14:22:16 - (1-gen-1002) : The given key was not present in the dictionary.
14:22:16 - IsConnectionValid True
14:22:16 - (1-gen-1002) : The given key was not present in the dictionary.
14:22:16 - (1-gen-1002) : The given key was not present in the dictionary.
14:22:16 - IsConnectionValid True
14:22:16 - IsConnectionValid True
14:22:16 - (1-gen-1002) : The given key was not present in the dictionary.
14:22:16 - IsConnectionValid True
14:22:16 - (1-gen-1002) : The given key was not present in the dictionary.
14:22:16 - (1-gen-1002) : The given key was not present in the dictionary.
14:22:16 - (1-gen-1002) : The given key was not present in the dictionary.
14:22:16 - IsConnectionValid True
14:22:16 - IsConnectionValid True
14:22:16 - IsConnectionValid True
14:22:16 - (1-gen-1002) : The given key was not present in the dictionary.
14:22:16 - (1-gen-1002) : The given key was not present in the dictionary.
14:22:16 - IsConnectionValid True
14:22:16 - (1-gen-1002) : The given key was not present in the dictionary.
14:22:16 - IsConnectionValid True
14:22:16 - IsConnectionValid True
14:22:16 - IsConnectionValid True
14:22:16 - (1-gen-1002) : The given key was not present in the dictionary.
14:22:16 - (1-gen-1002) : The given key was not present in the dictionary.
14:22:16 - IsConnectionValid True
14:22:16 - (1-gen-1002) : The given key was not present in the dictionary.
14:22:16 - IsConnectionValid True
14:22:16 - (1-gen-1002) : The given key was not present in the dictionary.
14:22:16 - (1-gen-1002) : The given key was not present in the dictionary.
14:22:16 - (1-gen-1002) : The given key was not present in the dictionary.
14:22:16 - (1-gen-1002) : The given key was not present in the dictionary.
15:02:38 - IsConnectionValid True
15:02:38 - SELECT * FROM VwVacationEntry WHERE TenantID = 1 AND   TenantID = @val0 AND EmployeeID = @val1 AND UserID = @val2 AND VacationType = @val3 AND CAST(FromDate AS Date) >= @val4 AND CAST(ToDate AS Date) <= @val5 ORDER BY FromDate ASC  Query
15:02:38 - (1-gen-1002) : Invalid column name 'TenantID'.
Invalid column name 'TenantID'.
15:02:39 - IsConnectionValid True
15:02:39 - finalQuery  ;WITH CTE AS (SELECT  ROW_NUMBER() OVER ( ORDER BY ID ASC) AS rn, COUNT(*) OVER() AS _total, * FROM (SELECT ID AS ID, Code AS Code, Name AS Name, Type AS Type FROM VacationTypes  WHERE  TenantID = 1 AND   TenantID = @val0  ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow
15:02:40 - IsConnectionValid True
15:02:40 - IsConnectionValid True
15:02:40 - IsConnectionValid True
15:02:40 - IsConnectionValid True
15:02:40 - IsConnectionValid True
15:02:40 - (1-gen-1002) : The given key was not present in the dictionary.
15:02:40 - (1-gen-1002) : The given key was not present in the dictionary.
15:02:40 - IsConnectionValid True
15:02:40 - (1-gen-1002) : The given key was not present in the dictionary.
15:02:40 - IsConnectionValid True
15:02:40 - (1-gen-1002) : The given key was not present in the dictionary.
15:02:40 - IsConnectionValid True
15:02:40 - (1-gen-1002) : The given key was not present in the dictionary.
15:02:40 - (1-gen-1002) : The given key was not present in the dictionary.
15:02:40 - IsConnectionValid True
15:02:40 - (1-gen-1002) : The given key was not present in the dictionary.
15:02:40 - (1-gen-1002) : The given key was not present in the dictionary.
15:02:40 - (1-gen-1002) : The given key was not present in the dictionary.
15:02:40 - IsConnectionValid True
15:02:40 - IsConnectionValid True
15:02:40 - (1-gen-1002) : The given key was not present in the dictionary.
15:02:40 - IsConnectionValid True
15:02:40 - IsConnectionValid True
15:02:40 - (1-gen-1002) : The given key was not present in the dictionary.
15:02:40 - IsConnectionValid True
15:02:40 - IsConnectionValid True
15:02:40 - (1-gen-1002) : The given key was not present in the dictionary.
15:02:40 - IsConnectionValid True
15:02:40 - (1-gen-1002) : The given key was not present in the dictionary.
15:02:40 - (1-gen-1002) : The given key was not present in the dictionary.
15:02:40 - IsConnectionValid True
15:02:40 - IsConnectionValid True
15:02:40 - (1-gen-1002) : The given key was not present in the dictionary.
15:02:40 - (1-gen-1002) : The given key was not present in the dictionary.
15:02:40 - IsConnectionValid True
15:02:40 - (1-gen-1002) : The given key was not present in the dictionary.
15:02:40 - (1-gen-1002) : The given key was not present in the dictionary.
15:02:40 - IsConnectionValid True
15:02:40 - (1-gen-1002) : The given key was not present in the dictionary.
15:02:40 - IsConnectionValid True
15:02:40 - IsConnectionValid True
15:02:40 - (1-gen-1002) : The given key was not present in the dictionary.
15:02:40 - IsConnectionValid True
15:02:40 - (1-gen-1002) : The given key was not present in the dictionary.
15:02:40 - (1-gen-1002) : The given key was not present in the dictionary.
15:02:40 - IsConnectionValid True
15:02:40 - (1-gen-1002) : The given key was not present in the dictionary.
15:02:40 - IsConnectionValid True
15:02:40 - IsConnectionValid True
15:02:40 - IsConnectionValid True
15:02:40 - IsConnectionValid True
15:02:40 - (1-gen-1002) : The given key was not present in the dictionary.
15:02:40 - IsConnectionValid True
15:02:40 - (1-gen-1002) : The given key was not present in the dictionary.
15:02:40 - (1-gen-1002) : The given key was not present in the dictionary.
15:02:40 - IsConnectionValid True
15:02:40 - IsConnectionValid True
15:02:40 - (1-gen-1002) : The given key was not present in the dictionary.
15:02:40 - (1-gen-1002) : The given key was not present in the dictionary.
15:02:40 - IsConnectionValid True
15:02:40 - IsConnectionValid True
15:02:40 - (1-gen-1002) : The given key was not present in the dictionary.
15:02:40 - (1-gen-1002) : The given key was not present in the dictionary.
15:02:40 - IsConnectionValid True
15:02:40 - (1-gen-1002) : The given key was not present in the dictionary.
15:02:40 - (1-gen-1002) : The given key was not present in the dictionary.
15:02:40 - IsConnectionValid True
15:02:40 - (1-gen-1002) : The given key was not present in the dictionary.
15:02:40 - IsConnectionValid True
15:02:40 - IsConnectionValid True
15:02:40 - (1-gen-1002) : The given key was not present in the dictionary.
15:02:40 - IsConnectionValid True
15:02:40 - (1-gen-1002) : The given key was not present in the dictionary.
15:02:40 - (1-gen-1002) : The given key was not present in the dictionary.
15:02:40 - (1-gen-1002) : The given key was not present in the dictionary.
15:02:40 - IsConnectionValid True
15:02:40 - (1-gen-1002) : The given key was not present in the dictionary.
15:02:40 - IsConnectionValid True
15:02:40 - IsConnectionValid True
15:02:40 - IsConnectionValid True
15:02:40 - (1-gen-1002) : The given key was not present in the dictionary.
15:02:40 - IsConnectionValid True
15:02:40 - IsConnectionValid True
15:02:40 - (1-gen-1002) : The given key was not present in the dictionary.
15:02:40 - (1-gen-1002) : The given key was not present in the dictionary.
15:02:40 - (1-gen-1002) : The given key was not present in the dictionary.
15:02:40 - (1-gen-1002) : The given key was not present in the dictionary.
15:02:40 - IsConnectionValid True
15:02:40 - (1-gen-1002) : The given key was not present in the dictionary.
15:02:40 - IsConnectionValid True
15:02:40 - IsConnectionValid True
15:02:40 - IsConnectionValid True
15:02:40 - IsConnectionValid True
15:02:40 - (1-gen-1002) : The given key was not present in the dictionary.
15:02:40 - IsConnectionValid True
15:02:40 - (1-gen-1002) : The given key was not present in the dictionary.
15:02:40 - IsConnectionValid True
15:02:40 - (1-gen-1002) : The given key was not present in the dictionary.
15:02:40 - IsConnectionValid True
15:02:40 - (1-gen-1002) : The given key was not present in the dictionary.
15:02:40 - IsConnectionValid True
15:02:40 - (1-gen-1002) : The given key was not present in the dictionary.
15:02:40 - (1-gen-1002) : The given key was not present in the dictionary.
15:02:40 - IsConnectionValid True
15:02:40 - IsConnectionValid True
15:02:40 - (1-gen-1002) : The given key was not present in the dictionary.
15:02:40 - (1-gen-1002) : The given key was not present in the dictionary.
15:02:40 - IsConnectionValid True
15:02:40 - (1-gen-1002) : The given key was not present in the dictionary.
15:02:40 - (1-gen-1002) : The given key was not present in the dictionary.
15:02:40 - IsConnectionValid True
15:02:40 - IsConnectionValid True
15:02:40 - IsConnectionValid True
15:02:40 - (1-gen-1002) : The given key was not present in the dictionary.
15:02:40 - (1-gen-1002) : The given key was not present in the dictionary.
15:02:40 - IsConnectionValid True
15:02:40 - (1-gen-1002) : The given key was not present in the dictionary.
15:02:40 - IsConnectionValid True
15:02:40 - IsConnectionValid True
15:02:40 - (1-gen-1002) : The given key was not present in the dictionary.
15:02:41 - IsConnectionValid True
15:02:41 - (1-gen-1002) : The given key was not present in the dictionary.
15:02:41 - IsConnectionValid True
15:02:41 - (1-gen-1002) : The given key was not present in the dictionary.
15:02:41 - (1-gen-1002) : The given key was not present in the dictionary.
15:02:41 - IsConnectionValid True
15:02:41 - (1-gen-1002) : The given key was not present in the dictionary.
15:02:41 - IsConnectionValid True
15:02:41 - IsConnectionValid True
15:02:41 - (1-gen-1002) : The given key was not present in the dictionary.
15:02:41 - IsConnectionValid True
15:02:41 - (1-gen-1002) : The given key was not present in the dictionary.
15:02:41 - (1-gen-1002) : The given key was not present in the dictionary.
15:02:41 - IsConnectionValid True
15:02:41 - (1-gen-1002) : The given key was not present in the dictionary.
15:02:41 - IsConnectionValid True
15:02:41 - IsConnectionValid True
15:02:41 - (1-gen-1002) : The given key was not present in the dictionary.
15:02:41 - IsConnectionValid True
15:02:41 - (1-gen-1002) : The given key was not present in the dictionary.
15:02:41 - (1-gen-1002) : The given key was not present in the dictionary.
15:02:41 - IsConnectionValid True
15:02:41 - (1-gen-1002) : The given key was not present in the dictionary.
15:02:41 - (1-gen-1002) : The given key was not present in the dictionary.
15:02:41 - IsConnectionValid True
15:02:41 - IsConnectionValid True
15:02:41 - (1-gen-1002) : The given key was not present in the dictionary.
15:02:41 - (1-gen-1002) : The given key was not present in the dictionary.
15:02:41 - IsConnectionValid True
15:02:41 - IsConnectionValid True
15:02:41 - (1-gen-1002) : The given key was not present in the dictionary.
15:02:41 - IsConnectionValid True
15:02:41 - (1-gen-1002) : The given key was not present in the dictionary.
15:02:41 - IsConnectionValid True
15:02:41 - (1-gen-1002) : The given key was not present in the dictionary.
15:02:41 - IsConnectionValid True
15:02:41 - (1-gen-1002) : The given key was not present in the dictionary.
15:02:41 - IsConnectionValid True
15:02:41 - (1-gen-1002) : The given key was not present in the dictionary.
15:02:41 - IsConnectionValid True
15:02:41 - IsConnectionValid True
15:02:41 - (1-gen-1002) : The given key was not present in the dictionary.
15:02:41 - IsConnectionValid True
15:02:41 - (1-gen-1002) : The given key was not present in the dictionary.
15:02:41 - IsConnectionValid True
15:02:41 - (1-gen-1002) : The given key was not present in the dictionary.
15:02:41 - (1-gen-1002) : The given key was not present in the dictionary.
15:02:41 - (1-gen-1002) : The given key was not present in the dictionary.
15:02:41 - IsConnectionValid True
15:02:41 - IsConnectionValid True
15:02:41 - IsConnectionValid True
15:02:41 - (1-gen-1002) : The given key was not present in the dictionary.
15:02:41 - (1-gen-1002) : The given key was not present in the dictionary.
15:02:41 - IsConnectionValid True
15:02:41 - IsConnectionValid True
15:02:41 - (1-gen-1002) : The given key was not present in the dictionary.
15:02:41 - IsConnectionValid True
15:02:41 - (1-gen-1002) : The given key was not present in the dictionary.
15:02:41 - IsConnectionValid True
15:02:41 - (1-gen-1002) : The given key was not present in the dictionary.
15:02:41 - IsConnectionValid True
15:02:41 - IsConnectionValid True
15:02:41 - (1-gen-1002) : The given key was not present in the dictionary.
15:02:41 - (1-gen-1002) : The given key was not present in the dictionary.
15:02:41 - IsConnectionValid True
15:02:41 - (1-gen-1002) : The given key was not present in the dictionary.
15:02:41 - IsConnectionValid True
15:02:41 - IsConnectionValid True
15:02:41 - IsConnectionValid True
15:02:41 - (1-gen-1002) : The given key was not present in the dictionary.
15:02:41 - (1-gen-1002) : The given key was not present in the dictionary.
15:02:41 - IsConnectionValid True
15:02:41 - (1-gen-1002) : The given key was not present in the dictionary.
15:02:41 - (1-gen-1002) : The given key was not present in the dictionary.
15:02:41 - IsConnectionValid True
15:02:41 - IsConnectionValid True
15:02:41 - (1-gen-1002) : The given key was not present in the dictionary.
15:02:41 - IsConnectionValid True
15:02:41 - (1-gen-1002) : The given key was not present in the dictionary.
15:02:41 - IsConnectionValid True
15:02:41 - (1-gen-1002) : The given key was not present in the dictionary.
15:02:41 - (1-gen-1002) : The given key was not present in the dictionary.
15:02:41 - (1-gen-1002) : The given key was not present in the dictionary.
15:02:41 - (1-gen-1002) : The given key was not present in the dictionary.
15:02:41 - (1-gen-1002) : The given key was not present in the dictionary.
15:02:43 - IsConnectionValid True
15:02:43 - SELECT * FROM VwVacationEntry WHERE TenantID = 1 AND   TenantID = @val0 AND EmployeeID = @val1 AND UserID = @val2 AND VacationType = @val3 AND CAST(FromDate AS Date) >= @val4 AND CAST(ToDate AS Date) <= @val5 ORDER BY FromDate ASC  Query
15:02:44 - (1-gen-1002) : Invalid column name 'TenantID'.
Invalid column name 'TenantID'.
15:02:45 - IsConnectionValid True
15:02:45 - IsConnectionValid True
15:02:45 - IsConnectionValid True
15:02:45 - IsConnectionValid True
15:02:45 - IsConnectionValid True
15:02:45 - IsConnectionValid True
15:02:45 - (1-gen-1002) : The given key was not present in the dictionary.
15:02:45 - (1-gen-1002) : The given key was not present in the dictionary.
15:02:45 - (1-gen-1002) : The given key was not present in the dictionary.
15:02:45 - IsConnectionValid True
15:02:45 - (1-gen-1002) : The given key was not present in the dictionary.
15:02:45 - (1-gen-1002) : The given key was not present in the dictionary.
15:02:45 - IsConnectionValid True
15:02:45 - IsConnectionValid True
15:02:45 - (1-gen-1002) : The given key was not present in the dictionary.
15:02:45 - IsConnectionValid True
15:02:45 - (1-gen-1002) : The given key was not present in the dictionary.
15:02:45 - IsConnectionValid True
15:02:45 - IsConnectionValid True
15:02:45 - (1-gen-1002) : The given key was not present in the dictionary.
15:02:45 - (1-gen-1002) : The given key was not present in the dictionary.
15:02:45 - IsConnectionValid True
15:02:45 - (1-gen-1002) : The given key was not present in the dictionary.
15:02:45 - (1-gen-1002) : The given key was not present in the dictionary.
15:02:45 - (1-gen-1002) : The given key was not present in the dictionary.
15:02:45 - IsConnectionValid True
15:02:45 - IsConnectionValid True
15:02:45 - IsConnectionValid True
15:02:45 - IsConnectionValid True
15:02:45 - (1-gen-1002) : The given key was not present in the dictionary.
15:02:45 - IsConnectionValid True
15:02:45 - (1-gen-1002) : The given key was not present in the dictionary.
15:02:45 - IsConnectionValid True
15:02:45 - (1-gen-1002) : The given key was not present in the dictionary.
15:02:45 - IsConnectionValid True
15:02:45 - (1-gen-1002) : The given key was not present in the dictionary.
15:02:45 - (1-gen-1002) : The given key was not present in the dictionary.
15:02:45 - (1-gen-1002) : The given key was not present in the dictionary.
15:02:45 - IsConnectionValid True
15:02:45 - (1-gen-1002) : The given key was not present in the dictionary.
15:02:45 - IsConnectionValid True
15:02:45 - (1-gen-1002) : The given key was not present in the dictionary.
15:02:45 - IsConnectionValid True
15:02:45 - IsConnectionValid True
15:02:45 - (1-gen-1002) : The given key was not present in the dictionary.
15:02:45 - IsConnectionValid True
15:02:45 - (1-gen-1002) : The given key was not present in the dictionary.
15:02:45 - IsConnectionValid True
15:02:45 - (1-gen-1002) : The given key was not present in the dictionary.
15:02:45 - IsConnectionValid True
15:02:45 - IsConnectionValid True
15:02:45 - IsConnectionValid True
15:02:45 - (1-gen-1002) : The given key was not present in the dictionary.
15:02:45 - (1-gen-1002) : The given key was not present in the dictionary.
15:02:45 - IsConnectionValid True
15:02:45 - (1-gen-1002) : The given key was not present in the dictionary.
15:02:45 - (1-gen-1002) : The given key was not present in the dictionary.
15:02:45 - (1-gen-1002) : The given key was not present in the dictionary.
15:02:45 - IsConnectionValid True
15:02:45 - IsConnectionValid True
15:02:45 - (1-gen-1002) : The given key was not present in the dictionary.
15:02:45 - (1-gen-1002) : The given key was not present in the dictionary.
15:02:45 - (1-gen-1002) : The given key was not present in the dictionary.
15:02:45 - IsConnectionValid True
15:02:45 - (1-gen-1002) : The given key was not present in the dictionary.
15:02:45 - IsConnectionValid True
15:02:45 - IsConnectionValid True
15:02:46 - (1-gen-1002) : The given key was not present in the dictionary.
15:02:46 - IsConnectionValid True
15:02:46 - IsConnectionValid True
15:02:46 - (1-gen-1002) : The given key was not present in the dictionary.
15:02:46 - IsConnectionValid True
15:02:46 - (1-gen-1002) : The given key was not present in the dictionary.
15:02:46 - (1-gen-1002) : The given key was not present in the dictionary.
15:02:46 - IsConnectionValid True
15:02:46 - (1-gen-1002) : The given key was not present in the dictionary.
15:02:46 - (1-gen-1002) : The given key was not present in the dictionary.
15:02:46 - IsConnectionValid True
15:02:46 - IsConnectionValid True
15:02:46 - IsConnectionValid True
15:02:46 - (1-gen-1002) : The given key was not present in the dictionary.
15:02:46 - (1-gen-1002) : The given key was not present in the dictionary.
15:02:46 - IsConnectionValid True
15:02:46 - (1-gen-1002) : The given key was not present in the dictionary.
15:02:46 - IsConnectionValid True
15:02:46 - (1-gen-1002) : The given key was not present in the dictionary.
15:02:46 - IsConnectionValid True
15:02:46 - IsConnectionValid True
15:02:46 - (1-gen-1002) : The given key was not present in the dictionary.
15:02:46 - (1-gen-1002) : The given key was not present in the dictionary.
15:02:46 - IsConnectionValid True
15:02:46 - (1-gen-1002) : The given key was not present in the dictionary.
15:02:46 - (1-gen-1002) : The given key was not present in the dictionary.
15:02:46 - IsConnectionValid True
15:02:46 - IsConnectionValid True
15:02:46 - IsConnectionValid True
15:02:46 - (1-gen-1002) : The given key was not present in the dictionary.
15:02:46 - (1-gen-1002) : The given key was not present in the dictionary.
15:02:46 - (1-gen-1002) : The given key was not present in the dictionary.
15:02:46 - (1-gen-1002) : The given key was not present in the dictionary.
15:02:46 - IsConnectionValid True
15:02:46 - IsConnectionValid True
15:02:46 - (1-gen-1002) : The given key was not present in the dictionary.
15:02:46 - IsConnectionValid True
15:02:46 - IsConnectionValid True
15:02:46 - IsConnectionValid True
15:02:46 - (1-gen-1002) : The given key was not present in the dictionary.
15:02:46 - IsConnectionValid True
15:02:46 - (1-gen-1002) : The given key was not present in the dictionary.
15:02:46 - (1-gen-1002) : The given key was not present in the dictionary.
15:02:46 - IsConnectionValid True
15:02:46 - (1-gen-1002) : The given key was not present in the dictionary.
15:02:46 - (1-gen-1002) : The given key was not present in the dictionary.
15:02:46 - IsConnectionValid True
15:02:46 - (1-gen-1002) : The given key was not present in the dictionary.
15:02:46 - IsConnectionValid True
15:02:46 - IsConnectionValid True
15:02:46 - IsConnectionValid True
15:02:46 - (1-gen-1002) : The given key was not present in the dictionary.
15:02:46 - IsConnectionValid True
15:02:46 - (1-gen-1002) : The given key was not present in the dictionary.
15:02:46 - (1-gen-1002) : The given key was not present in the dictionary.
15:02:46 - IsConnectionValid True
15:02:46 - IsConnectionValid True
15:02:46 - IsConnectionValid True
15:02:46 - (1-gen-1002) : The given key was not present in the dictionary.
15:02:46 - IsConnectionValid True
15:02:46 - (1-gen-1002) : The given key was not present in the dictionary.
15:02:46 - IsConnectionValid True
15:02:46 - (1-gen-1002) : The given key was not present in the dictionary.
15:02:46 - (1-gen-1002) : The given key was not present in the dictionary.
15:02:46 - (1-gen-1002) : The given key was not present in the dictionary.
15:02:46 - IsConnectionValid True
15:02:46 - (1-gen-1002) : The given key was not present in the dictionary.
15:02:46 - (1-gen-1002) : The given key was not present in the dictionary.
15:02:46 - IsConnectionValid True
15:02:46 - IsConnectionValid True
15:02:46 - IsConnectionValid True
15:02:46 - (1-gen-1002) : The given key was not present in the dictionary.
15:02:46 - IsConnectionValid True
15:02:46 - (1-gen-1002) : The given key was not present in the dictionary.
15:02:46 - IsConnectionValid True
15:02:46 - (1-gen-1002) : The given key was not present in the dictionary.
15:02:46 - IsConnectionValid True
15:02:46 - (1-gen-1002) : The given key was not present in the dictionary.
15:02:46 - IsConnectionValid True
15:02:46 - (1-gen-1002) : The given key was not present in the dictionary.
15:02:46 - IsConnectionValid True
15:02:46 - (1-gen-1002) : The given key was not present in the dictionary.
15:02:46 - (1-gen-1002) : The given key was not present in the dictionary.
15:02:46 - IsConnectionValid True
15:02:46 - (1-gen-1002) : The given key was not present in the dictionary.
15:02:46 - IsConnectionValid True
15:02:46 - (1-gen-1002) : The given key was not present in the dictionary.
15:02:46 - IsConnectionValid True
15:02:46 - IsConnectionValid True
15:02:46 - (1-gen-1002) : The given key was not present in the dictionary.
15:02:46 - IsConnectionValid True
15:02:46 - IsConnectionValid True
15:02:46 - (1-gen-1002) : The given key was not present in the dictionary.
15:02:46 - (1-gen-1002) : The given key was not present in the dictionary.
15:02:46 - IsConnectionValid True
15:02:46 - (1-gen-1002) : The given key was not present in the dictionary.
15:02:46 - (1-gen-1002) : The given key was not present in the dictionary.
15:02:46 - IsConnectionValid True
15:02:46 - IsConnectionValid True
15:02:46 - (1-gen-1002) : The given key was not present in the dictionary.
15:02:46 - IsConnectionValid True
15:02:46 - IsConnectionValid True
15:02:46 - (1-gen-1002) : The given key was not present in the dictionary.
15:02:46 - (1-gen-1002) : The given key was not present in the dictionary.
15:02:46 - IsConnectionValid True
15:02:46 - (1-gen-1002) : The given key was not present in the dictionary.
15:02:46 - IsConnectionValid True
15:02:46 - IsConnectionValid True
15:02:46 - (1-gen-1002) : The given key was not present in the dictionary.
15:02:46 - IsConnectionValid True
15:02:46 - (1-gen-1002) : The given key was not present in the dictionary.
15:02:46 - (1-gen-1002) : The given key was not present in the dictionary.
15:02:46 - IsConnectionValid True
15:02:47 - IsConnectionValid True
15:02:47 - IsConnectionValid True
15:02:47 - (1-gen-1002) : The given key was not present in the dictionary.
15:02:47 - (1-gen-1002) : The given key was not present in the dictionary.
15:02:47 - IsConnectionValid True
15:02:47 - (1-gen-1002) : The given key was not present in the dictionary.
15:02:47 - IsConnectionValid True
15:02:47 - (1-gen-1002) : The given key was not present in the dictionary.
15:02:47 - (1-gen-1002) : The given key was not present in the dictionary.
15:02:47 - IsConnectionValid True
15:02:47 - (1-gen-1002) : The given key was not present in the dictionary.
15:02:47 - (1-gen-1002) : The given key was not present in the dictionary.
15:02:47 - IsConnectionValid True
15:02:47 - IsConnectionValid True
15:02:47 - IsConnectionValid True
15:02:47 - (1-gen-1002) : The given key was not present in the dictionary.
15:02:47 - (1-gen-1002) : The given key was not present in the dictionary.
15:02:47 - IsConnectionValid True
15:02:47 - (1-gen-1002) : The given key was not present in the dictionary.
15:02:47 - (1-gen-1002) : The given key was not present in the dictionary.
15:02:47 - (1-gen-1002) : The given key was not present in the dictionary.
15:02:47 - (1-gen-1002) : The given key was not present in the dictionary.
15:02:47 - (1-gen-1002) : The given key was not present in the dictionary.
15:19:36 - IsConnectionValid True
15:19:40 - IsConnectionValid True
15:19:40 - SELECT * FROM HRMS_VwVacationEntry_Cancel WHERE TenantID = 1 AND   TenantID = @val0 AND EmployeeID = @val1 AND UserID = @val2 AND VacationType = @val3 ORDER BY FromDate ASC  Query
15:19:51 - IsConnectionValid True
15:19:51 - 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 =01/01/1900 or (DateleftTemp<>DateLeft and DateLeft >01/10/2023)) and UserID = @val1 and TenantID = @val2  ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow
15:20:21 - IsConnectionValid True
15:20:21 - finalQuery  ;WITH CTE AS (SELECT  ROW_NUMBER() OVER ( ORDER BY ID ASC) AS rn, COUNT(*) OVER() AS _total, * FROM (SELECT ID AS ID, Code AS Code, Name AS Name, Type AS Type FROM VacationTypes  WHERE  TenantID = 1 AND   TenantID = @val0  ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow
15:20:22 - IsConnectionValid True
15:20:22 - SELECT * FROM HRMS_VwVacationEntry_Cancel WHERE TenantID = 1 AND   TenantID = @val0 AND EmployeeID = @val1 AND UserID = @val2 AND VacationType = @val3 ORDER BY FromDate ASC  Query
15:25:08 - IsConnectionValid True
15:25:12 - IsConnectionValid True
15:25:12 - SELECT * FROM HRMS_VwVacationEntry_Cancel WHERE TenantID = 1 AND   TenantID = @val0 AND EmployeeID = @val1 AND UserID = @val2 AND VacationType = @val3 ORDER BY FromDate ASC  Query
15:25:15 - IsConnectionValid True
15:25:15 - 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 =01/01/1900 or (DateleftTemp<>DateLeft and DateLeft >01/10/2023)) and UserID = @val1 and TenantID = @val2  ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow
15:25:47 - IsConnectionValid True
15:25:47 - finalQuery  ;WITH CTE AS (SELECT  ROW_NUMBER() OVER ( ORDER BY ID ASC) AS rn, COUNT(*) OVER() AS _total, * FROM (SELECT ID AS ID, Code AS Code, Name AS Name, Type AS Type FROM VacationTypes  WHERE  TenantID = 1 AND   TenantID = @val0  ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow
15:25:48 - IsConnectionValid True
15:25:48 - SELECT * FROM HRMS_VwVacationEntry_Cancel WHERE TenantID = 1 AND   TenantID = @val0 AND EmployeeID = @val1 AND UserID = @val2 AND VacationType = @val3 ORDER BY FromDate ASC  Query
15:27:09 - IsConnectionValid True
15:27:13 - IsConnectionValid True
15:27:13 - SELECT * FROM HRMS_VwVacationEntry_Cancel WHERE TenantID = 1 AND   TenantID = @val0 AND EmployeeID = @val1 AND UserID = @val2 AND VacationType = @val3 ORDER BY FromDate ASC  Query
15:27:15 - IsConnectionValid True
15:27:15 - 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 =01/01/1900 or (DateleftTemp<>DateLeft and DateLeft >01/10/2023)) and UserID = @val1 and TenantID = @val2  ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow
15:27:25 - IsConnectionValid True
15:27:25 - finalQuery  ;WITH CTE AS (SELECT  ROW_NUMBER() OVER ( ORDER BY ID ASC) AS rn, COUNT(*) OVER() AS _total, * FROM (SELECT ID AS ID, Code AS Code, Name AS Name, Type AS Type FROM VacationTypes  WHERE  TenantID = 1 AND   TenantID = @val0  ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow
15:27:26 - IsConnectionValid True
15:27:26 - SELECT * FROM HRMS_VwVacationEntry_Cancel WHERE TenantID = 1 AND   TenantID = @val0 AND EmployeeID = @val1 AND UserID = @val2 AND VacationType = @val3 ORDER BY FromDate ASC  Query
15:32:38 - IsConnectionValid True
15:32:38 - finalQuery  ;WITH CTE AS (SELECT  ROW_NUMBER() OVER ( ORDER BY ID ASC) AS rn, COUNT(*) OVER() AS _total, * FROM (SELECT ID AS ID, Code AS Code, Name AS Name, Type AS Type FROM VacationTypes  WHERE  TenantID = 1 AND   TenantID = @val0  ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow
15:32:39 - IsConnectionValid True
15:32:39 - SELECT * FROM HRMS_VwVacationEntry_Cancel WHERE TenantID = 1 AND   TenantID = @val0 AND EmployeeID = @val1 AND UserID = @val2 AND VacationType = @val3 ORDER BY FromDate ASC  Query
15:35:58 - IsConnectionValid True
15:36:03 - IsConnectionValid True
15:36:03 - SELECT * FROM HRMS_VwVacationEntry_Cancel WHERE TenantID = 1 AND   TenantID = @val0 AND EmployeeID = @val1 AND UserID = @val2 AND VacationType = @val3 ORDER BY FromDate ASC  Query
15:36:06 - IsConnectionValid True
15:36:06 - 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 =01/01/1900 or (DateleftTemp<>DateLeft and DateLeft >01/10/2023)) and UserID = @val1 and TenantID = @val2  ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow
15:36:16 - IsConnectionValid True
15:36:16 - finalQuery  ;WITH CTE AS (SELECT  ROW_NUMBER() OVER ( ORDER BY ID ASC) AS rn, COUNT(*) OVER() AS _total, * FROM (SELECT ID AS ID, Code AS Code, Name AS Name, Type AS Type FROM VacationTypes  WHERE  TenantID = 1 AND   TenantID = @val0  ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow
15:36:17 - IsConnectionValid True
15:36:17 - SELECT * FROM HRMS_VwVacationEntry_Cancel WHERE TenantID = 1 AND   TenantID = @val0 AND EmployeeID = @val1 AND UserID = @val2 AND VacationType = @val3 ORDER BY FromDate ASC  Query
15:37:03 - IsConnectionValid True
15:37:10 - IsConnectionValid True
15:37:10 - SELECT * FROM HRMS_VwVacationEntry_Cancel WHERE TenantID = 1 AND   TenantID = @val0 AND EmployeeID = @val1 AND UserID = @val2 AND VacationType = @val3 ORDER BY FromDate ASC  Query
15:37:13 - IsConnectionValid True
15:37:13 - 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 =01/01/1900 or (DateleftTemp<>DateLeft and DateLeft >01/10/2023)) and UserID = @val1 and TenantID = @val2  ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow
15:37:25 - IsConnectionValid True
15:37:25 - finalQuery  ;WITH CTE AS (SELECT  ROW_NUMBER() OVER ( ORDER BY ID ASC) AS rn, COUNT(*) OVER() AS _total, * FROM (SELECT ID AS ID, Code AS Code, Name AS Name, Type AS Type FROM VacationTypes  WHERE  TenantID = 1 AND   TenantID = @val0  ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow
15:37:26 - IsConnectionValid True
15:37:26 - SELECT * FROM HRMS_VwVacationEntry_Cancel WHERE TenantID = 1 AND   TenantID = @val0 AND EmployeeID = @val1 AND UserID = @val2 AND VacationType = @val3 ORDER BY FromDate ASC  Query