12:41:23 - IsConnectionValid True 12:41:31 - IsConnectionValid True 12:41:37 - IsConnectionValid True 12:41:38 - IsConnectionValid True 15:12:14 - IsConnectionValid True 15:12:15 - IsConnectionValid True 15:12:17 - IsConnectionValid True 15:12:31 - IsConnectionValid True 15:12:41 - IsConnectionValid True 15:12:48 - IsConnectionValid True 15:12:51 - IsConnectionValid True 15:12:51 - SELECT DISTINCT COUNT(*) AS DayCount FROM HRMS_vwVacTransType WHERE TenantID = 1 AND TenantID = @val0 AND IsOverTime = @val1 Query 15:12:52 - IsConnectionValid True 15:12:52 - (1-ot-000003) : Count_From_Attendance 15:13:28 - IsConnectionValid True 15:13:35 - IsConnectionValid True 15:13:35 - IsConnectionValid True 15:13:38 - IsConnectionValid True 15:13:42 - IsConnectionValid True 15:13:47 - IsConnectionValid True 15:13:47 - SELECT DISTINCT COUNT(*) AS DayCount FROM HRMS_vwVacTransType WHERE TenantID = 1 AND TenantID = @val0 AND IsOverTime = @val1 Query 15:13:56 - IsConnectionValid True 15:15:14 - IsConnectionValid True 15:15:17 - IsConnectionValid True 15:15:17 - SELECT DISTINCT COUNT(*) AS DayCount FROM HRMS_vwVacTransType WHERE TenantID = 1 AND TenantID = @val0 AND IsOverTime = @val1 Query 15:15:18 - IsConnectionValid True 15:16:03 - IsConnectionValid True 15:16:05 - IsConnectionValid True 15:16:05 - SELECT DISTINCT COUNT(*) AS DayCount FROM HRMS_vwVacTransType WHERE TenantID = 1 AND TenantID = @val0 AND IsOverTime = @val1 Query 15:16:06 - IsConnectionValid True 15:16:35 - IsConnectionValid True 15:16:43 - IsConnectionValid True 15:16:43 - SELECT DISTINCT COUNT(*) AS DayCount FROM HRMS_vwVacTransType WHERE TenantID = 1 AND TenantID = @val0 AND IsOverTime = @val1 Query 15:16:44 - IsConnectionValid True 16:00:17 - IsConnectionValid True 16:00:17 - IsConnectionValid True 16:01:29 - IsConnectionValid True 16:01:36 - IsConnectionValid True 16:01:36 - IsConnectionValid True 16:01:41 - IsConnectionValid True 16:01:45 - IsConnectionValid True 16:01:46 - IsConnectionValid True 16:01:51 - IsConnectionValid True 16:01:51 - SELECT DISTINCT COUNT(*) AS DayCount FROM HRMS_vwVacTransType WHERE TenantID = 1 AND TenantID = @val0 AND IsOverTime = @val1 Query 16:01:56 - IsConnectionValid True 16:01:56 - (1-ot-000003) : ProjectID 16:02:27 - IsConnectionValid True 16:02:27 - (1-ot-000003) : ProjectID 16:03:00 - IsConnectionValid True 16:03:09 - IsConnectionValid True 16:03:09 - SELECT DISTINCT COUNT(*) AS DayCount FROM HRMS_vwVacTransType WHERE TenantID = 1 AND TenantID = @val0 AND IsOverTime = @val1 Query 16:03:16 - IsConnectionValid True 16:03:17 - (1-ot-000003) : ProjectID 16:05:13 - IsConnectionValid True 16:05:15 - IsConnectionValid True 16:05:38 - IsConnectionValid True 16:23:11 - IsConnectionValid True 16:23:17 - IsConnectionValid True 16:23:17 - SELECT DISTINCT COUNT(*) AS DayCount FROM HRMS_vwVacTransType WHERE TenantID = 1 AND TenantID = @val0 AND IsOverTime = @val1 Query 16:23:27 - IsConnectionValid True 16:23:58 - IsConnectionValid True 16:24:09 - IsConnectionValid True 16:24:09 - SELECT DISTINCT COUNT(*) AS DayCount FROM HRMS_vwVacTransType WHERE TenantID = 1 AND TenantID = @val0 AND IsOverTime = @val1 Query 16:24:20 - IsConnectionValid True 16:24:21 - IsConnectionValid True 16:24:21 - (3-hr-0010001) : Subquery returned more than 1 value. This is not permitted when the subquery follows =, !=, <, <= , >, >= or when the subquery is used as an expression. 16:27:35 - IsConnectionValid True 16:27:44 - IsConnectionValid True 16:27:47 - IsConnectionValid True 16:27:47 - SELECT DISTINCT COUNT(*) AS DayCount FROM HRMS_vwVacTransType WHERE TenantID = 1 AND TenantID = @val0 AND IsOverTime = @val1 Query 16:32:01 - IsConnectionValid True 16:32:01 - IsConnectionValid True 16:32:33 - IsConnectionValid True 16:32:43 - IsConnectionValid True 16:32:43 - SELECT DISTINCT COUNT(*) AS DayCount FROM HRMS_vwVacTransType WHERE TenantID = 1 AND TenantID = @val0 AND IsOverTime = @val1 Query 16:32:52 - IsConnectionValid True 16:32:52 - IsConnectionValid True 16:38:35 - IsConnectionValid True 16:38:41 - IsConnectionValid True 16:38:41 - SELECT DISTINCT COUNT(*) AS DayCount FROM HRMS_vwVacTransType WHERE TenantID = 1 AND TenantID = @val0 AND IsOverTime = @val1 Query 16:38:43 - IsConnectionValid True 16:38:52 - IsConnectionValid True 16:38:53 - IsConnectionValid True 16:39:44 - IsConnectionValid True 16:39:50 - IsConnectionValid True 16:39:50 - SELECT DISTINCT COUNT(*) AS DayCount FROM HRMS_vwVacTransType WHERE TenantID = 1 AND TenantID = @val0 AND IsOverTime = @val1 Query 16:40:04 - IsConnectionValid True 16:40:05 - IsConnectionValid True 16:40:15 - IsConnectionValid True 16:40:57 - IsConnectionValid True 16:41:08 - IsConnectionValid True 16:41:08 - SELECT DISTINCT COUNT(*) AS DayCount FROM HRMS_vwVacTransType WHERE TenantID = 1 AND TenantID = @val0 AND IsOverTime = @val1 Query 16:41:18 - IsConnectionValid True 16:41:19 - IsConnectionValid True 16:41:24 - IsConnectionValid True 16:42:14 - IsConnectionValid True 16:42:22 - IsConnectionValid True 16:42:22 - SELECT DISTINCT COUNT(*) AS DayCount FROM HRMS_vwVacTransType WHERE TenantID = 1 AND TenantID = @val0 AND IsOverTime = @val1 Query 16:42:28 - IsConnectionValid True 16:42:29 - IsConnectionValid True 16:42:35 - IsConnectionValid True 16:43:34 - IsConnectionValid True 16:43:34 - finalQuery ;WITH CTE AS (SELECT ROW_NUMBER() OVER ( ORDER BY Code ASC) AS rn, COUNT(*) OVER() AS _total, * FROM (SELECT ID AS ID, Code AS Code, Name AS Name, EnglishName AS EnglishName FROM Employees WHERE TenantID = 1 AND TenantID = @val0 ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow 16:43:45 - IsConnectionValid True 16:43:45 - finalQuery ;WITH CTE AS (SELECT ROW_NUMBER() OVER ( ORDER BY Code ASC) AS rn, COUNT(*) OVER() AS _total, * FROM (SELECT ID AS ID, Code AS Code, Name AS Name, EnglishName AS EnglishName FROM Employees WHERE TenantID = 1 AND TenantID = @val0 AND Code LIKE @val1 ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow 16:43:46 - IsConnectionValid True 16:43:47 - IsConnectionValid True 16:43:52 - IsConnectionValid True 16:43:53 - IsConnectionValid True 16:45:02 - IsConnectionValid True 16:46:34 - IsConnectionValid True 16:46:34 - IsConnectionValid True 16:51:30 - IsConnectionValid True 16:51:36 - IsConnectionValid True 16:51:36 - SELECT DISTINCT COUNT(*) AS DayCount FROM HRMS_vwVacTransType WHERE TenantID = 1 AND TenantID = @val0 AND IsOverTime = @val1 Query 16:51:48 - IsConnectionValid True 16:51:48 - IsConnectionValid True 16:51:52 - IsConnectionValid True 16:51:52 - finalQuery ;WITH CTE AS (SELECT ROW_NUMBER() OVER ( ORDER BY Code ASC) AS rn, COUNT(*) OVER() AS _total, * FROM (SELECT ID AS ID, Code AS Code, Name AS Name, EnglishName AS EnglishName FROM Employees WHERE TenantID = 1 AND TenantID = @val0 ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow 16:52:06 - IsConnectionValid True 16:52:06 - finalQuery ;WITH CTE AS (SELECT ROW_NUMBER() OVER ( ORDER BY Code ASC) AS rn, COUNT(*) OVER() AS _total, * FROM (SELECT ID AS ID, Code AS Code, Name AS Name, EnglishName AS EnglishName FROM Employees WHERE TenantID = 1 AND TenantID = @val0 AND Code LIKE @val1 ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow 16:52:08 - IsConnectionValid True 16:52:08 - IsConnectionValid True 16:52:11 - IsConnectionValid True 16:55:46 - IsConnectionValid True 16:55:49 - IsConnectionValid True 16:55:49 - SELECT DISTINCT COUNT(*) AS DayCount FROM HRMS_vwVacTransType WHERE TenantID = 1 AND TenantID = @val0 AND IsOverTime = @val1 Query 16:55:59 - IsConnectionValid True 16:55:59 - finalQuery ;WITH CTE AS (SELECT ROW_NUMBER() OVER ( ORDER BY Code ASC) AS rn, COUNT(*) OVER() AS _total, * FROM (SELECT ID AS ID, Code AS Code, Name AS Name, EnglishName AS EnglishName FROM Employees WHERE TenantID = 1 AND TenantID = @val0 ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow 16:56:04 - IsConnectionValid True 16:56:04 - finalQuery ;WITH CTE AS (SELECT ROW_NUMBER() OVER ( ORDER BY Code ASC) AS rn, COUNT(*) OVER() AS _total, * FROM (SELECT ID AS ID, Code AS Code, Name AS Name, EnglishName AS EnglishName FROM Employees WHERE TenantID = 1 AND TenantID = @val0 AND Code LIKE @val1 ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow 16:56:07 - IsConnectionValid True 16:56:08 - IsConnectionValid True 16:56:10 - IsConnectionValid True 17:05:22 - IsConnectionValid True 17:05:26 - IsConnectionValid True 17:05:27 - SELECT DISTINCT COUNT(*) AS DayCount FROM HRMS_vwVacTransType WHERE TenantID = 1 AND TenantID = @val0 AND IsOverTime = @val1 Query 17:05:39 - IsConnectionValid True 17:05:39 - IsConnectionValid True 17:05:41 - IsConnectionValid True 17:05:41 - finalQuery ;WITH CTE AS (SELECT ROW_NUMBER() OVER ( ORDER BY Code ASC) AS rn, COUNT(*) OVER() AS _total, * FROM (SELECT ID AS ID, Code AS Code, Name AS Name, EnglishName AS EnglishName FROM Employees WHERE TenantID = 1 AND TenantID = @val0 ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow 17:05:45 - IsConnectionValid True 17:05:45 - finalQuery ;WITH CTE AS (SELECT ROW_NUMBER() OVER ( ORDER BY Code ASC) AS rn, COUNT(*) OVER() AS _total, * FROM (SELECT ID AS ID, Code AS Code, Name AS Name, EnglishName AS EnglishName FROM Employees WHERE TenantID = 1 AND TenantID = @val0 AND Code LIKE @val1 ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow 17:05:49 - IsConnectionValid True 17:05:49 - finalQuery ;WITH CTE AS (SELECT ROW_NUMBER() OVER ( ORDER BY Code ASC) AS rn, COUNT(*) OVER() AS _total, * FROM (SELECT ID AS ID, Code AS Code, Name AS Name, EnglishName AS EnglishName FROM Employees WHERE TenantID = 1 AND TenantID = @val0 AND Code LIKE @val1 ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow 17:05:51 - IsConnectionValid True 17:05:52 - IsConnectionValid True 17:06:11 - IsConnectionValid True 17:06:11 - IsConnectionValid True 17:06:41 - IsConnectionValid True 17:06:54 - IsConnectionValid True 17:06:55 - IsConnectionValid True 17:07:02 - IsConnectionValid True 17:07:02 - IsConnectionValid True 17:08:49 - IsConnectionValid True 17:08:54 - IsConnectionValid True 17:08:54 - SELECT DISTINCT COUNT(*) AS DayCount FROM HRMS_vwVacTransType WHERE TenantID = 1 AND TenantID = @val0 AND IsOverTime = @val1 Query 17:09:07 - IsConnectionValid True 17:09:10 - IsConnectionValid True 17:09:10 - SELECT DISTINCT COUNT(*) AS DayCount FROM HRMS_vwVacTransType WHERE TenantID = 1 AND TenantID = @val0 AND IsOverTime = @val1 Query 17:09:20 - IsConnectionValid True 17:09:20 - finalQuery ;WITH CTE AS (SELECT ROW_NUMBER() OVER ( ORDER BY Code ASC) AS rn, COUNT(*) OVER() AS _total, * FROM (SELECT ID AS ID, Code AS Code, Name AS Name, EnglishName AS EnglishName FROM Employees WHERE TenantID = 1 AND TenantID = @val0 ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow 17:09:27 - IsConnectionValid True 17:09:27 - finalQuery ;WITH CTE AS (SELECT ROW_NUMBER() OVER ( ORDER BY Code ASC) AS rn, COUNT(*) OVER() AS _total, * FROM (SELECT ID AS ID, Code AS Code, Name AS Name, EnglishName AS EnglishName FROM Employees WHERE TenantID = 1 AND TenantID = @val0 AND Code LIKE @val1 ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow 17:09:30 - IsConnectionValid True 17:09:30 - IsConnectionValid True 17:09:35 - IsConnectionValid True 17:11:58 - IsConnectionValid True 17:12:03 - IsConnectionValid True 17:12:03 - SELECT DISTINCT COUNT(*) AS DayCount FROM HRMS_vwVacTransType WHERE TenantID = 1 AND TenantID = @val0 AND IsOverTime = @val1 Query 17:12:23 - IsConnectionValid True 17:12:24 - IsConnectionValid True 17:12:25 - IsConnectionValid True 17:12:25 - finalQuery ;WITH CTE AS (SELECT ROW_NUMBER() OVER ( ORDER BY Code ASC) AS rn, COUNT(*) OVER() AS _total, * FROM (SELECT ID AS ID, Code AS Code, Name AS Name, EnglishName AS EnglishName FROM Employees WHERE TenantID = 1 AND TenantID = @val0 ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow 17:12:34 - IsConnectionValid True 17:12:34 - finalQuery ;WITH CTE AS (SELECT ROW_NUMBER() OVER ( ORDER BY Code ASC) AS rn, COUNT(*) OVER() AS _total, * FROM (SELECT ID AS ID, Code AS Code, Name AS Name, EnglishName AS EnglishName FROM Employees WHERE TenantID = 1 AND TenantID = @val0 AND Code LIKE @val1 ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow 17:12:36 - IsConnectionValid True 17:12:36 - IsConnectionValid True 17:14:12 - IsConnectionValid True 17:14:16 - IsConnectionValid True 17:14:16 - SELECT DISTINCT COUNT(*) AS DayCount FROM HRMS_vwVacTransType WHERE TenantID = 1 AND TenantID = @val0 AND IsOverTime = @val1 Query 17:14:30 - IsConnectionValid True 17:14:30 - finalQuery ;WITH CTE AS (SELECT ROW_NUMBER() OVER ( ORDER BY Code ASC) AS rn, COUNT(*) OVER() AS _total, * FROM (SELECT ID AS ID, Code AS Code, Name AS Name, EnglishName AS EnglishName FROM Employees WHERE TenantID = 1 AND TenantID = @val0 ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow 17:14:33 - IsConnectionValid True 17:14:33 - finalQuery ;WITH CTE AS (SELECT ROW_NUMBER() OVER ( ORDER BY Code ASC) AS rn, COUNT(*) OVER() AS _total, * FROM (SELECT ID AS ID, Code AS Code, Name AS Name, EnglishName AS EnglishName FROM Employees WHERE TenantID = 1 AND TenantID = @val0 AND Code LIKE @val1 ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow 17:14:35 - IsConnectionValid True 17:14:35 - IsConnectionValid True 17:16:32 - IsConnectionValid True 17:16:37 - IsConnectionValid True 17:16:37 - SELECT DISTINCT COUNT(*) AS DayCount FROM HRMS_vwVacTransType WHERE TenantID = 1 AND TenantID = @val0 AND IsOverTime = @val1 Query 17:16:45 - IsConnectionValid True 17:16:45 - finalQuery ;WITH CTE AS (SELECT ROW_NUMBER() OVER ( ORDER BY Code ASC) AS rn, COUNT(*) OVER() AS _total, * FROM (SELECT ID AS ID, Code AS Code, Name AS Name, EnglishName AS EnglishName FROM Employees WHERE TenantID = 1 AND TenantID = @val0 ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow 17:16:48 - IsConnectionValid True 17:16:48 - finalQuery ;WITH CTE AS (SELECT ROW_NUMBER() OVER ( ORDER BY Code ASC) AS rn, COUNT(*) OVER() AS _total, * FROM (SELECT ID AS ID, Code AS Code, Name AS Name, EnglishName AS EnglishName FROM Employees WHERE TenantID = 1 AND TenantID = @val0 AND Code LIKE @val1 ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow 17:16:50 - IsConnectionValid True 17:16:50 - IsConnectionValid True 17:21:18 - IsConnectionValid True 17:21:22 - IsConnectionValid True 17:21:22 - SELECT DISTINCT COUNT(*) AS DayCount FROM HRMS_vwVacTransType WHERE TenantID = 1 AND TenantID = @val0 AND IsOverTime = @val1 Query 17:21:31 - IsConnectionValid True 17:21:31 - finalQuery ;WITH CTE AS (SELECT ROW_NUMBER() OVER ( ORDER BY Code ASC) AS rn, COUNT(*) OVER() AS _total, * FROM (SELECT ID AS ID, Code AS Code, Name AS Name, EnglishName AS EnglishName FROM Employees WHERE TenantID = 1 AND TenantID = @val0 ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow 17:21:34 - IsConnectionValid True 17:21:34 - finalQuery ;WITH CTE AS (SELECT ROW_NUMBER() OVER ( ORDER BY Code ASC) AS rn, COUNT(*) OVER() AS _total, * FROM (SELECT ID AS ID, Code AS Code, Name AS Name, EnglishName AS EnglishName FROM Employees WHERE TenantID = 1 AND TenantID = @val0 AND Code LIKE @val1 ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow 17:21:36 - IsConnectionValid True 17:21:36 - IsConnectionValid True 17:21:39 - IsConnectionValid True 17:22:27 - IsConnectionValid True 17:22:32 - IsConnectionValid True 17:22:32 - SELECT DISTINCT COUNT(*) AS DayCount FROM HRMS_vwVacTransType WHERE TenantID = 1 AND TenantID = @val0 AND IsOverTime = @val1 Query 17:22:38 - IsConnectionValid True 17:22:38 - finalQuery ;WITH CTE AS (SELECT ROW_NUMBER() OVER ( ORDER BY Code ASC) AS rn, COUNT(*) OVER() AS _total, * FROM (SELECT ID AS ID, Code AS Code, Name AS Name, EnglishName AS EnglishName FROM Employees WHERE TenantID = 1 AND TenantID = @val0 ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow 17:22:41 - IsConnectionValid True 17:22:41 - finalQuery ;WITH CTE AS (SELECT ROW_NUMBER() OVER ( ORDER BY Code ASC) AS rn, COUNT(*) OVER() AS _total, * FROM (SELECT ID AS ID, Code AS Code, Name AS Name, EnglishName AS EnglishName FROM Employees WHERE TenantID = 1 AND TenantID = @val0 AND Code LIKE @val1 ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow 17:22:43 - IsConnectionValid True 17:22:44 - IsConnectionValid True 17:22:47 - IsConnectionValid True