15:36:22 - IsConnectionValid True 15:36:23 - (1-att-000003) : Object reference not set to an instance of an object. 15:37:01 - IsConnectionValid True 15:37:01 - 07:28testresder 15:37:01 - 16:31testresder 15:37:25 - IsConnectionValid True 15:37:25 - 14:29testresder 15:37:51 - IsConnectionValid True 15:37:51 - 14:29testresder 15:38:44 - IsConnectionValid True 15:38:44 - 07:28testresder 15:38:44 - 16:31testresder 15:41:50 - IsConnectionValid True 15:42:01 - IsConnectionValid True 15:42:12 - IsConnectionValid True 15:42:23 - IsConnectionValid True 15:42:23 - 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 vwEmployees WHERE TenantID = @val0 AND UserID = @val1 and (ProjectID =0 or 0 =0) and (DepartmentID =0 or 0 =0) and (SectionID =0 or 0 =0) ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow 15:42:27 - IsConnectionValid True 15:42: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 vwEmployees WHERE TenantID = @val0 AND UserID = @val1 and (ProjectID =0 or 0 =0) and (DepartmentID =0 or 0 =0) and (SectionID =0 or 0 =0) AND Code LIKE @val5 ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow 15:42:29 - IsConnectionValid True 15:42:32 - IsConnectionValid True 15:44:37 - IsConnectionValid True 15:45:28 - IsConnectionValid True 15:45:43 - IsConnectionValid True 15:45:43 - 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 vwEmployees WHERE TenantID = @val0 AND UserID = @val1 and (ProjectID =0 or 0 =0) and (DepartmentID =0 or 0 =0) and (SectionID =0 or 0 =0) ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow 15:45:45 - IsConnectionValid True 15:45: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 vwEmployees WHERE TenantID = @val0 AND UserID = @val1 and (ProjectID =0 or 0 =0) and (DepartmentID =0 or 0 =0) and (SectionID =0 or 0 =0) AND Code LIKE @val5 ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow 15:45:47 - IsConnectionValid True 15:45:53 - IsConnectionValid True 15:45:56 - IsConnectionValid True 15:49:20 - IsConnectionValid True 15:49:31 - IsConnectionValid True 15:49: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 vwEmployees WHERE TenantID = @val0 AND UserID = @val1 and (ProjectID =0 or 0 =0) and (DepartmentID =0 or 0 =0) and (SectionID =0 or 0 =0) ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow 15:49:36 - IsConnectionValid True 15:49:36 - 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 vwEmployees WHERE TenantID = @val0 AND UserID = @val1 and (ProjectID =0 or 0 =0) and (DepartmentID =0 or 0 =0) and (SectionID =0 or 0 =0) AND Code LIKE @val5 ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow 15:49:38 - IsConnectionValid True 15:49:44 - IsConnectionValid True 15:50:24 - IsConnectionValid True 15:50:35 - IsConnectionValid True 15:50:35 - 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 vwEmployees WHERE TenantID = @val0 AND UserID = @val1 and (ProjectID =0 or 0 =0) and (DepartmentID =0 or 0 =0) and (SectionID =0 or 0 =0) ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow 15:50:40 - IsConnectionValid True 15:50:40 - 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 vwEmployees WHERE TenantID = @val0 AND UserID = @val1 and (ProjectID =0 or 0 =0) and (DepartmentID =0 or 0 =0) and (SectionID =0 or 0 =0) AND Code LIKE @val5 ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow 15:50:42 - IsConnectionValid True 15:50:44 - IsConnectionValid True 15:53:05 - IsConnectionValid True 15:53:12 - IsConnectionValid True 15:53:28 - IsConnectionValid True 15:53:29 - 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 vwEmployees WHERE TenantID = @val0 AND UserID = @val1 and (ProjectID =0 or 0 =0) and (DepartmentID =0 or 0 =0) and (SectionID =0 or 0 =0) ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow 15:53:32 - IsConnectionValid True 15:53:32 - 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 vwEmployees WHERE TenantID = @val0 AND UserID = @val1 and (ProjectID =0 or 0 =0) and (DepartmentID =0 or 0 =0) and (SectionID =0 or 0 =0) AND Code LIKE @val5 ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow 15:53:35 - IsConnectionValid True 15:53:40 - IsConnectionValid True 15:54:20 - IsConnectionValid True 15:54:38 - IsConnectionValid True 15:54:39 - 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 vwEmployees WHERE TenantID = @val0 AND UserID = @val1 and (ProjectID =0 or 0 =0) and (DepartmentID =0 or 0 =0) and (SectionID =0 or 0 =0) ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow 15:54:41 - IsConnectionValid True 15:54: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 vwEmployees WHERE TenantID = @val0 AND UserID = @val1 and (ProjectID =0 or 0 =0) and (DepartmentID =0 or 0 =0) and (SectionID =0 or 0 =0) AND Code LIKE @val5 ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow 15:54:43 - IsConnectionValid True 15:54:47 - IsConnectionValid True 15:55:26 - IsConnectionValid True 15:55:44 - IsConnectionValid True 15:55:44 - 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 vwEmployees WHERE TenantID = @val0 AND UserID = @val1 and (ProjectID =0 or 0 =0) and (DepartmentID =0 or 0 =0) and (SectionID =0 or 0 =0) ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow 15:55:47 - IsConnectionValid True 15:55:47 - 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 vwEmployees WHERE TenantID = @val0 AND UserID = @val1 and (ProjectID =0 or 0 =0) and (DepartmentID =0 or 0 =0) and (SectionID =0 or 0 =0) AND Code LIKE @val5 ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow 15:55:49 - IsConnectionValid True 15:55:53 - IsConnectionValid True 15:56:29 - IsConnectionValid True 15:56:47 - IsConnectionValid True 15:56:47 - 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 vwEmployees WHERE TenantID = @val0 AND UserID = @val1 and (ProjectID =0 or 0 =0) and (DepartmentID =0 or 0 =0) and (SectionID =0 or 0 =0) ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow 15:56:49 - IsConnectionValid True 15:56: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 vwEmployees WHERE TenantID = @val0 AND UserID = @val1 and (ProjectID =0 or 0 =0) and (DepartmentID =0 or 0 =0) and (SectionID =0 or 0 =0) AND Code LIKE @val5 ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow 15:56:51 - IsConnectionValid True 15:56:54 - IsConnectionValid True 15:59:29 - IsConnectionValid True 16:00:04 - IsConnectionValid True 16:00: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 vwEmployees WHERE TenantID = @val0 AND UserID = @val1 and (ProjectID =0 or 0 =0) and (DepartmentID =0 or 0 =0) and (SectionID =0 or 0 =0) ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow 16:00:09 - IsConnectionValid True 16:00:09 - 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 vwEmployees WHERE TenantID = @val0 AND UserID = @val1 and (ProjectID =0 or 0 =0) and (DepartmentID =0 or 0 =0) and (SectionID =0 or 0 =0) AND Code LIKE @val5 ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow 16:00:11 - IsConnectionValid True 16:00:17 - IsConnectionValid True 16:00:22 - IsConnectionValid True 16:07:07 - IsConnectionValid True 16:07:18 - IsConnectionValid True 16:07:18 - 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 vwEmployees WHERE TenantID = @val0 AND UserID = @val1 and (ProjectID =0 or 0 =0) and (DepartmentID =0 or 0 =0) and (SectionID =0 or 0 =0) ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow 16:07:21 - IsConnectionValid True 16:07:21 - 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 vwEmployees WHERE TenantID = @val0 AND UserID = @val1 and (ProjectID =0 or 0 =0) and (DepartmentID =0 or 0 =0) and (SectionID =0 or 0 =0) AND Code LIKE @val5 ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow 16:07:23 - IsConnectionValid True 16:07:26 - IsConnectionValid True 16:08:49 - IsConnectionValid True 16:08:53 - IsConnectionValid True 16:09:01 - IsConnectionValid True 16:09:07 - IsConnectionValid True 16:09:10 - IsConnectionValid True 16:09:17 - IsConnectionValid True 16:15:00 - IsConnectionValid True 16:15:02 - IsConnectionValid True 16:15:09 - IsConnectionValid True 16:15:10 - IsConnectionValid True 16:15:10 - SELECT * FROM HRMS_VwVacationEntry WHERE TenantID = 1 AND TenantID = @val0 AND EmployeeID = @val1 AND UserID = @val2 AND Posted <> @val3 ORDER BY FromDate ASC Query 16:16:12 - IsConnectionValid True 16:16:12 - 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 >02/07/2024)) and UserID = @val1 and TenantID = @val2 ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow 16:16:14 - IsConnectionValid True 16:16:14 - SELECT * FROM HRMS_VwVacationEntry WHERE TenantID = 1 AND TenantID = @val0 AND EmployeeID = @val1 AND UserID = @val2 AND Posted <> @val3 ORDER BY FromDate ASC Query 16:16:28 - IsConnectionValid True 16:16:28 - 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 16:31:55 - IsConnectionValid True 16:32:46 - IsConnectionValid True 16:32:46 - SELECT * FROM HRMS_VwVacationEntry WHERE TenantID = 1 AND TenantID = @val0 AND EmployeeID = @val1 AND UserID = @val2 AND Posted <> @val3 ORDER BY FromDate ASC Query 16:32:49 - IsConnectionValid True 16:32:49 - finalQuery ;WITH CTE AS (SELECT ROW_NUMBER() OVER ( ORDER BY ID ASC) AS rn, COUNT(*) OVER() AS _total, * FROM (SELECT * FROM HRMS_vwEmployees WHERE (DateLeft = '1900-01-01' or (DateleftTemp<>DateLeft and DateLeft > GETDATE())) and UserID = @val1 and TenantID = @val2 ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow 16:32:50 - IsConnectionValid True 16:32:50 - SELECT * FROM HRMS_VwVacationEntry WHERE TenantID = 1 AND TenantID = @val0 AND EmployeeID = @val1 AND UserID = @val2 AND Posted <> @val3 ORDER BY FromDate ASC Query 16:32:51 - IsConnectionValid True 16:32:51 - finalQuery ;WITH CTE AS (SELECT ROW_NUMBER() OVER ( ORDER BY ID ASC) AS rn, COUNT(*) OVER() AS _total, * FROM (SELECT * FROM VwVacationTypes WHERE TenantID = 1 AND TenantID = @val0 ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow 16:33:26 - IsConnectionValid True 16:33:32 - IsConnectionValid True 16:33:32 - SELECT * FROM HRMS_VwVacationEntry WHERE TenantID = 1 AND TenantID = @val0 AND EmployeeID = @val1 AND UserID = @val2 AND Posted <> @val3 ORDER BY FromDate ASC Query 16:33:35 - IsConnectionValid True 16:33:35 - finalQuery ;WITH CTE AS (SELECT ROW_NUMBER() OVER ( ORDER BY ID ASC) AS rn, COUNT(*) OVER() AS _total, * FROM (SELECT * FROM HRMS_vwEmployees WHERE (DateLeft = '1900-01-01' or (DateleftTemp<>DateLeft and DateLeft > GETDATE())) and UserID = @val1 and TenantID = @val2 ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow 16:33:37 - IsConnectionValid True 16:33:37 - SELECT * FROM HRMS_VwVacationEntry WHERE TenantID = 1 AND TenantID = @val0 AND EmployeeID = @val1 AND UserID = @val2 AND Posted <> @val3 ORDER BY FromDate ASC Query 16:33:39 - IsConnectionValid True 16:33:39 - finalQuery ;WITH CTE AS (SELECT ROW_NUMBER() OVER ( ORDER BY ID ASC) AS rn, COUNT(*) OVER() AS _total, * FROM (SELECT * FROM HRMS_VwVacationTypes_WithSecurity WHERE TenantID = 1 AND TenantID = @val0 ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow 16:34:34 - IsConnectionValid True 16:34:34 - finalQuery ;WITH CTE AS (SELECT ROW_NUMBER() OVER ( ORDER BY ID ASC) AS rn, COUNT(*) OVER() AS _total, * FROM (SELECT * FROM HRMS_VwVacationTypes_WithSecurity WHERE TenantID = 1 AND TenantID = @val0 ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow 16:34:56 - IsConnectionValid True 16:35:01 - IsConnectionValid True 16:35:01 - SELECT * FROM HRMS_VwVacationEntry WHERE TenantID = 1 AND TenantID = @val0 AND EmployeeID = @val1 AND UserID = @val2 AND Posted <> @val3 ORDER BY FromDate ASC Query 16:35:04 - IsConnectionValid True 16:35:05 - finalQuery ;WITH CTE AS (SELECT ROW_NUMBER() OVER ( ORDER BY ID ASC) AS rn, COUNT(*) OVER() AS _total, * FROM (SELECT * FROM HRMS_vwEmployees WHERE (DateLeft = '1900-01-01' or (DateleftTemp<>DateLeft and DateLeft > GETDATE())) and UserID = @val1 and TenantID = @val2 ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow 16:35:06 - IsConnectionValid True 16:35:06 - SELECT * FROM HRMS_VwVacationEntry WHERE TenantID = 1 AND TenantID = @val0 AND EmployeeID = @val1 AND UserID = @val2 AND Posted <> @val3 ORDER BY FromDate ASC Query 16:35:07 - IsConnectionValid True 16:35:07 - finalQuery ;WITH CTE AS (SELECT ROW_NUMBER() OVER ( ORDER BY ID ASC) AS rn, COUNT(*) OVER() AS _total, * FROM (SELECT * FROM HRMS_VwVacationTypes_WithSecurity WHERE TenantID = 1 AND TenantID = @val0 and UserID = @val1 ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow 16:35:56 - IsConnectionValid True 16:36:02 - IsConnectionValid True 16:36:05 - IsConnectionValid True 16:36:05 - SELECT * FROM HRMS_VwVacationEntry WHERE TenantID = 1 AND TenantID = @val0 AND EmployeeID = @val1 AND UserID = @val2 AND Posted <> @val3 ORDER BY FromDate ASC Query 16:36:09 - IsConnectionValid True 16:36:12 - IsConnectionValid True 16:36:12 - SELECT * FROM HRMS_VwVacationEntry WHERE TenantID = 1 AND TenantID = @val0 AND EmployeeID = @val1 AND UserID = @val2 AND Posted <> @val3 ORDER BY FromDate ASC Query 16:36:15 - IsConnectionValid True 16:36: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 >02/07/2024)) and UserID = @val1 and TenantID = @val2 ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow 16:36:16 - IsConnectionValid True 16:36:16 - SELECT * FROM HRMS_VwVacationEntry WHERE TenantID = 1 AND TenantID = @val0 AND EmployeeID = @val1 AND UserID = @val2 AND Posted <> @val3 ORDER BY FromDate ASC Query 16:36:18 - IsConnectionValid True 16:36:18 - 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, UserID AS UserID FROM HRMS_VwVacationTypes_WithSecurity WHERE TenantID = 1 AND TenantID = @val0 ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow 16:36:26 - IsConnectionValid True 16:36:28 - IsConnectionValid True 16:36:28 - 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 16:37:43 - IsConnectionValid True 16:37:48 - IsConnectionValid True 16:37: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 16:37:51 - IsConnectionValid True 16:37: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 >02/07/2024)) and UserID = @val1 and TenantID = @val2 ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow 16:37:54 - IsConnectionValid True 16:37:54 - 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 HRMS_VwVacationTypes_WithSecurity WHERE TenantID = 1 AND TenantID = @val0 and UserID = @val1 ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow 16:37:56 - IsConnectionValid True 16:37:56 - 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 16:38:00 - IsConnectionValid True 16:38:02 - IsConnectionValid True 16:38:02 - SELECT * FROM HRMS_VwVacationEntry WHERE TenantID = 1 AND TenantID = @val0 AND EmployeeID = @val1 AND UserID = @val2 AND Posted <> @val3 ORDER BY FromDate ASC Query 16:38:04 - IsConnectionValid True 16:38:04 - finalQuery ;WITH CTE AS (SELECT ROW_NUMBER() OVER ( ORDER BY ID ASC) AS rn, COUNT(*) OVER() AS _total, * FROM (SELECT * FROM HRMS_vwEmployees WHERE (DateLeft = '1900-01-01' or (DateleftTemp<>DateLeft and DateLeft > GETDATE())) and UserID = @val1 and TenantID = @val2 ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow 16:38:04 - IsConnectionValid True 16:38:04 - SELECT * FROM HRMS_VwVacationEntry WHERE TenantID = 1 AND TenantID = @val0 AND EmployeeID = @val1 AND UserID = @val2 AND Posted <> @val3 ORDER BY FromDate ASC Query 16:38:06 - IsConnectionValid True 16:38:06 - finalQuery ;WITH CTE AS (SELECT ROW_NUMBER() OVER ( ORDER BY ID ASC) AS rn, COUNT(*) OVER() AS _total, * FROM (SELECT * FROM HRMS_VwVacationTypes_WithSecurity WHERE TenantID = 1 AND TenantID = @val0 and UserID = @val1 ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow 16:38:10 - IsConnectionValid True 16:38:11 - IsConnectionValid True 16:38:11 - SELECT * FROM HRMS_VwVacationEntry WHERE TenantID = 1 AND TenantID = @val0 AND EmployeeID = @val1 AND UserID = @val2 AND Posted <> @val3 ORDER BY FromDate ASC Query 16:38:12 - IsConnectionValid True 16:38:12 - 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 >02/07/2024)) and UserID = @val1 and TenantID = @val2 ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow 16:38:13 - IsConnectionValid True 16:38:13 - SELECT * FROM HRMS_VwVacationEntry WHERE TenantID = 1 AND TenantID = @val0 AND EmployeeID = @val1 AND UserID = @val2 AND Posted <> @val3 ORDER BY FromDate ASC Query 16:38:15 - IsConnectionValid True 16:38:15 - 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 HRMS_VwVacationTypes_WithSecurity WHERE TenantID = 1 AND TenantID = @val0 and UserID = @val1 ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow 16:38:19 - IsConnectionValid True 16:41:05 - IsConnectionValid True 16:41:09 - IsConnectionValid True 16:41:17 - IsConnectionValid True 16:41:23 - IsConnectionValid True 16:41:23 - SELECT ISNULL(reportName,'') AS reportName, ISNULL(OrderNo,0) AS OrderNo FROM Report_HumanResources WHERE TenantID = 1 AND TenantID = @val0 AND SectionName = @val1 ORDER BY OrderNo Query 16:41:26 - IsConnectionValid True 16:41:27 - IsConnectionValid True 16:41:31 - IsConnectionValid True 16:41:41 - IsConnectionValid True 16:41:55 - IsConnectionValid True 16:41:57 - IsConnectionValid True 16:42:09 - IsConnectionValid True 16:42:12 - IsConnectionValid True 16:42:15 - IsConnectionValid True 16:43:31 - IsConnectionValid True 16:43:34 - IsConnectionValid True 16:43:34 - finalQuery ;WITH CTE AS (SELECT ROW_NUMBER() OVER ( ORDER BY ID DESC) AS rn, COUNT(*) OVER() AS _total, * FROM (SELECT * FROM HRMS_vwEmployees WHERE TenantID =1 AND UserID = @val1 and DateLeft = '1900-01-01' ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow 16:44:09 - IsConnectionValid True 16:44:18 - IsConnectionValid True 16:44:18 - finalQuery ;WITH CTE AS (SELECT ROW_NUMBER() OVER ( ORDER BY ID DESC) AS rn, COUNT(*) OVER() AS _total, * FROM (SELECT * FROM HRMS_vwEmployees WHERE TenantID =1 AND UserID = @val1 and DateLeft = '1900-01-01' ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow 16:45:33 - IsConnectionValid True 16:45:39 - IsConnectionValid True 16:45:39 - finalQuery ;WITH CTE AS (SELECT ROW_NUMBER() OVER ( ORDER BY ID DESC) AS rn, COUNT(*) OVER() AS _total, * FROM (SELECT * FROM HRMS_vwEmployees WHERE TenantID =1 AND UserID = @val1 and DateLeft = '1900-01-01' ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow 16:45:58 - IsConnectionValid True 16:46:05 - IsConnectionValid True 16:46:05 - finalQuery ;WITH CTE AS (SELECT ROW_NUMBER() OVER ( ORDER BY ID DESC) AS rn, COUNT(*) OVER() AS _total, * FROM (SELECT * FROM HRMS_vwEmployees WHERE TenantID =1 AND UserID = @val1 and DateLeft = '1900-01-01' ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow 16:46:35 - IsConnectionValid True 16:46:41 - IsConnectionValid True 16:46:41 - finalQuery ;WITH CTE AS (SELECT ROW_NUMBER() OVER ( ORDER BY ID DESC) AS rn, COUNT(*) OVER() AS _total, * FROM (SELECT * FROM HRMS_vwEmployees WHERE TenantID =1 AND UserID = @val1 and DateLeft = '1900-01-01' ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow 16:47:46 - IsConnectionValid True 16:47:54 - IsConnectionValid True 16:47:54 - finalQuery ;WITH CTE AS (SELECT ROW_NUMBER() OVER ( ORDER BY ID DESC) AS rn, COUNT(*) OVER() AS _total, * FROM (SELECT * FROM HRMS_vwEmployees WHERE TenantID =1 AND UserID = @val1 and DateLeft = '1900-01-01' ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow 16:49:20 - IsConnectionValid True 16:49:26 - IsConnectionValid True 16:49:26 - finalQuery ;WITH CTE AS (SELECT ROW_NUMBER() OVER ( ORDER BY ID DESC) AS rn, COUNT(*) OVER() AS _total, * FROM (SELECT * FROM HRMS_vwEmployees WHERE TenantID =1 AND UserID = @val1 and DateLeft = '1900-01-01' ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow 16:50:37 - IsConnectionValid True 16:50:44 - IsConnectionValid True 16:50:44 - finalQuery ;WITH CTE AS (SELECT ROW_NUMBER() OVER ( ORDER BY ID DESC) AS rn, COUNT(*) OVER() AS _total, * FROM (SELECT * FROM HRMS_vwEmployees WHERE TenantID =1 AND UserID = @val1 and DateLeft = '1900-01-01' ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow 16:51:02 - IsConnectionValid True 16:51:09 - IsConnectionValid True 16:51:09 - finalQuery ;WITH CTE AS (SELECT ROW_NUMBER() OVER ( ORDER BY ID DESC) AS rn, COUNT(*) OVER() AS _total, * FROM (SELECT * FROM HRMS_vwEmployees WHERE TenantID =1 AND UserID = @val1 and DateLeft = '1900-01-01' ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow 16:51:45 - IsConnectionValid True 16:51:52 - IsConnectionValid True 16:51:52 - finalQuery ;WITH CTE AS (SELECT ROW_NUMBER() OVER ( ORDER BY ID DESC) AS rn, COUNT(*) OVER() AS _total, * FROM (SELECT * FROM HRMS_vwEmployees WHERE TenantID =1 AND UserID = @val1 and DateLeft = '1900-01-01' ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow 16:55:00 - IsConnectionValid True 16:55:09 - IsConnectionValid True 16:55:09 - finalQuery ;WITH CTE AS (SELECT ROW_NUMBER() OVER ( ORDER BY ID DESC) AS rn, COUNT(*) OVER() AS _total, * FROM (SELECT * FROM HRMS_vwEmployees WHERE TenantID =1 AND UserID = @val1 and DateLeft = '1900-01-01' ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow 16:57:43 - IsConnectionValid True 16:57:52 - IsConnectionValid True 16:57:52 - finalQuery ;WITH CTE AS (SELECT ROW_NUMBER() OVER ( ORDER BY ID DESC) AS rn, COUNT(*) OVER() AS _total, * FROM (SELECT * FROM HRMS_vwEmployees WHERE TenantID =1 AND UserID = @val1 and DateLeft = '1900-01-01' ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow 16:58:17 - IsConnectionValid True 16:58:25 - IsConnectionValid True 16:58:25 - finalQuery ;WITH CTE AS (SELECT ROW_NUMBER() OVER ( ORDER BY ID DESC) AS rn, COUNT(*) OVER() AS _total, * FROM (SELECT * FROM HRMS_vwEmployees WHERE TenantID =1 AND UserID = @val1 and DateLeft = '1900-01-01' ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow 16:58:28 - IsConnectionValid True 16:58:28 - SELECT t.ID AS ID, t.Code AS Code, t.Name AS Name, t.Project AS Project, t.Department AS Department, t.ActualID AS ActualID, t.Father AS Father, t.HLevel AS HLevel, COUNT(t2.ID) AS _children FROM Pro_Dep_SecHierarchy t LEFT OUTER JOIN Pro_Dep_SecHierarchy t2 ON t.ID = t2.Father WHERE t.TenantID =1 AND t.Father = 0 GROUP BY t.ID,t.Code,t.Name,t.Project,t.Department,t.ActualID,t.Father,t.HLevel ORDER BY t.Code ASCQuery 16:58:29 - IsConnectionValid True 16:58:29 - SELECT t.ID AS ID, t.Code AS Code, t.Name AS Name, t.Project AS Project, t.Department AS Department, t.ActualID AS ActualID, t.Father AS Father, t.HLevel AS HLevel, COUNT(t2.ID) AS _children FROM Pro_Dep_SecHierarchy t LEFT OUTER JOIN Pro_Dep_SecHierarchy t2 ON t.ID = t2.Father WHERE t.TenantID =1 AND t.Father = 0 GROUP BY t.ID,t.Code,t.Name,t.Project,t.Department,t.ActualID,t.Father,t.HLevel ORDER BY t.Code ASCQuery 16:58:31 - IsConnectionValid True 16:58:31 - SELECT t.ID AS ID, t.Code AS Code, t.Name AS Name, t.Project AS Project, t.Department AS Department, t.ActualID AS ActualID, t.Father AS Father, t.HLevel AS HLevel, COUNT(t2.ID) AS _children FROM Pro_Dep_SecHierarchy t LEFT OUTER JOIN Pro_Dep_SecHierarchy t2 ON t.ID = t2.Father WHERE t.TenantID =1 AND t.Father = 1 GROUP BY t.ID,t.Code,t.Name,t.Project,t.Department,t.ActualID,t.Father,t.HLevel ORDER BY t.Code ASCQuery 16:58:33 - IsConnectionValid True 16:58:33 - SELECT t.ID AS ID, t.Code AS Code, t.Name AS Name, t.Project AS Project, t.Department AS Department, t.ActualID AS ActualID, t.Father AS Father, t.HLevel AS HLevel, COUNT(t2.ID) AS _children FROM Pro_Dep_SecHierarchy t LEFT OUTER JOIN Pro_Dep_SecHierarchy t2 ON t.ID = t2.Father WHERE t.TenantID =1 AND t.Father = 0 GROUP BY t.ID,t.Code,t.Name,t.Project,t.Department,t.ActualID,t.Father,t.HLevel ORDER BY t.Code ASCQuery 16:58:33 - IsConnectionValid True 16:58:33 - SELECT t.ID AS ID, t.Code AS Code, t.Name AS Name, t.Project AS Project, t.Department AS Department, t.ActualID AS ActualID, t.Father AS Father, t.HLevel AS HLevel, COUNT(t2.ID) AS _children FROM Pro_Dep_SecHierarchy t LEFT OUTER JOIN Pro_Dep_SecHierarchy t2 ON t.ID = t2.Father WHERE t.TenantID =1 AND t.Father = 0 GROUP BY t.ID,t.Code,t.Name,t.Project,t.Department,t.ActualID,t.Father,t.HLevel ORDER BY t.Code ASCQuery 16:58:35 - IsConnectionValid True 16:58:35 - SELECT t.ID AS ID, t.Code AS Code, t.Name AS Name, t.Project AS Project, t.Department AS Department, t.ActualID AS ActualID, t.Father AS Father, t.HLevel AS HLevel, COUNT(t2.ID) AS _children FROM Pro_Dep_SecHierarchy t LEFT OUTER JOIN Pro_Dep_SecHierarchy t2 ON t.ID = t2.Father WHERE t.TenantID =1 AND t.Father = 1 GROUP BY t.ID,t.Code,t.Name,t.Project,t.Department,t.ActualID,t.Father,t.HLevel ORDER BY t.Code ASCQuery 16:58:37 - IsConnectionValid True 16:58:37 - SELECT t.ID AS ID, t.Code AS Code, t.Name AS Name, t.Project AS Project, t.Department AS Department, t.ActualID AS ActualID, t.Father AS Father, t.HLevel AS HLevel, COUNT(t2.ID) AS _children FROM Pro_Dep_SecHierarchy t LEFT OUTER JOIN Pro_Dep_SecHierarchy t2 ON t.ID = t2.Father WHERE t.TenantID =1 AND t.Father = 10 GROUP BY t.ID,t.Code,t.Name,t.Project,t.Department,t.ActualID,t.Father,t.HLevel ORDER BY t.Code ASCQuery 16:58:38 - IsConnectionValid True 16:58:38 - SELECT t.ID AS ID, t.Code AS Code, t.Name AS Name, t.Project AS Project, t.Department AS Department, t.ActualID AS ActualID, t.Father AS Father, t.HLevel AS HLevel, COUNT(t2.ID) AS _children FROM Pro_Dep_SecHierarchy t LEFT OUTER JOIN Pro_Dep_SecHierarchy t2 ON t.ID = t2.Father WHERE t.TenantID =1 AND t.Father = 23 GROUP BY t.ID,t.Code,t.Name,t.Project,t.Department,t.ActualID,t.Father,t.HLevel ORDER BY t.Code ASCQuery 17:00:31 - IsConnectionValid True 17:00:38 - IsConnectionValid True 17:00:38 - finalQuery ;WITH CTE AS (SELECT ROW_NUMBER() OVER ( ORDER BY ID DESC) AS rn, COUNT(*) OVER() AS _total, * FROM (SELECT * FROM HRMS_vwEmployees WHERE TenantID =1 AND UserID = @val1 and DateLeft = '1900-01-01' ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow 17:02:14 - IsConnectionValid True 17:02:21 - IsConnectionValid True 17:02:21 - finalQuery ;WITH CTE AS (SELECT ROW_NUMBER() OVER ( ORDER BY ID DESC) AS rn, COUNT(*) OVER() AS _total, * FROM (SELECT * FROM HRMS_vwEmployees WHERE TenantID =1 AND UserID = @val1 and DateLeft = '1900-01-01' ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow 17:03:10 - IsConnectionValid True 17:03:21 - IsConnectionValid True 17:03:21 - finalQuery ;WITH CTE AS (SELECT ROW_NUMBER() OVER ( ORDER BY ID DESC) AS rn, COUNT(*) OVER() AS _total, * FROM (SELECT * FROM HRMS_vwEmployees WHERE TenantID =1 AND UserID = @val1 and DateLeft = '1900-01-01' ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow 17:04:19 - IsConnectionValid True 17:04:32 - IsConnectionValid True 17:04:32 - finalQuery ;WITH CTE AS (SELECT ROW_NUMBER() OVER ( ORDER BY ID DESC) AS rn, COUNT(*) OVER() AS _total, * FROM (SELECT * FROM HRMS_vwEmployees WHERE TenantID =1 AND UserID = @val1 and DateLeft = '1900-01-01' ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow 17:05:02 - IsConnectionValid True 17:05:10 - IsConnectionValid True 17:05:10 - finalQuery ;WITH CTE AS (SELECT ROW_NUMBER() OVER ( ORDER BY ID DESC) AS rn, COUNT(*) OVER() AS _total, * FROM (SELECT * FROM HRMS_vwEmployees WHERE TenantID =1 AND UserID = @val1 and DateLeft = '1900-01-01' ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow 17:05:27 - IsConnectionValid True 17:05:27 - SELECT t.ID AS ID, t.Code AS Code, t.Name AS Name, t.Project AS Project, t.Department AS Department, t.ActualID AS ActualID, t.Father AS Father, t.HLevel AS HLevel, COUNT(t2.ID) AS _children FROM Pro_Dep_SecHierarchy t LEFT OUTER JOIN Pro_Dep_SecHierarchy t2 ON t.ID = t2.Father WHERE t.TenantID =1 AND t.Father = 0 GROUP BY t.ID,t.Code,t.Name,t.Project,t.Department,t.ActualID,t.Father,t.HLevel ORDER BY t.Code ASCQuery 17:05:27 - IsConnectionValid True 17:05:27 - SELECT t.ID AS ID, t.Code AS Code, t.Name AS Name, t.Project AS Project, t.Department AS Department, t.ActualID AS ActualID, t.Father AS Father, t.HLevel AS HLevel, COUNT(t2.ID) AS _children FROM Pro_Dep_SecHierarchy t LEFT OUTER JOIN Pro_Dep_SecHierarchy t2 ON t.ID = t2.Father WHERE t.TenantID =1 AND t.Father = 0 GROUP BY t.ID,t.Code,t.Name,t.Project,t.Department,t.ActualID,t.Father,t.HLevel ORDER BY t.Code ASCQuery 17:05:29 - IsConnectionValid True 17:05:29 - SELECT t.ID AS ID, t.Code AS Code, t.Name AS Name, t.Project AS Project, t.Department AS Department, t.ActualID AS ActualID, t.Father AS Father, t.HLevel AS HLevel, COUNT(t2.ID) AS _children FROM Pro_Dep_SecHierarchy t LEFT OUTER JOIN Pro_Dep_SecHierarchy t2 ON t.ID = t2.Father WHERE t.TenantID =1 AND t.Father = 1 GROUP BY t.ID,t.Code,t.Name,t.Project,t.Department,t.ActualID,t.Father,t.HLevel ORDER BY t.Code ASCQuery 17:05:30 - IsConnectionValid True 17:05:30 - SELECT t.ID AS ID, t.Code AS Code, t.Name AS Name, t.Project AS Project, t.Department AS Department, t.ActualID AS ActualID, t.Father AS Father, t.HLevel AS HLevel, COUNT(t2.ID) AS _children FROM Pro_Dep_SecHierarchy t LEFT OUTER JOIN Pro_Dep_SecHierarchy t2 ON t.ID = t2.Father WHERE t.TenantID =1 AND t.Father = 10 GROUP BY t.ID,t.Code,t.Name,t.Project,t.Department,t.ActualID,t.Father,t.HLevel ORDER BY t.Code ASCQuery 17:05:31 - IsConnectionValid True 17:05:31 - SELECT t.ID AS ID, t.Code AS Code, t.Name AS Name, t.Project AS Project, t.Department AS Department, t.ActualID AS ActualID, t.Father AS Father, t.HLevel AS HLevel, COUNT(t2.ID) AS _children FROM Pro_Dep_SecHierarchy t LEFT OUTER JOIN Pro_Dep_SecHierarchy t2 ON t.ID = t2.Father WHERE t.TenantID =1 AND t.Father = 23 GROUP BY t.ID,t.Code,t.Name,t.Project,t.Department,t.ActualID,t.Father,t.HLevel ORDER BY t.Code ASCQuery 17:08:13 - IsConnectionValid True 17:08:27 - IsConnectionValid True 17:08:27 - (1-gen-1004) : The given key was not present in the dictionary. 17:08:33 - IsConnectionValid True 17:08:33 - SELECT t.ID AS ID, t.Code AS Code, t.Name AS Name, t.Project AS Project, t.Department AS Department, t.ActualID AS ActualID, t.Father AS Father, t.HLevel AS HLevel, COUNT(t2.ID) AS _children FROM Pro_Dep_SecHierarchy t LEFT OUTER JOIN Pro_Dep_SecHierarchy t2 ON t.ID = t2.Father WHERE t.TenantID =1 AND t.Father = 0 GROUP BY t.ID,t.Code,t.Name,t.Project,t.Department,t.ActualID,t.Father,t.HLevel ORDER BY t.Code ASCQuery 17:08:33 - IsConnectionValid True 17:08:33 - SELECT t.ID AS ID, t.Code AS Code, t.Name AS Name, t.Project AS Project, t.Department AS Department, t.ActualID AS ActualID, t.Father AS Father, t.HLevel AS HLevel, COUNT(t2.ID) AS _children FROM Pro_Dep_SecHierarchy t LEFT OUTER JOIN Pro_Dep_SecHierarchy t2 ON t.ID = t2.Father WHERE t.TenantID =1 AND t.Father = 0 GROUP BY t.ID,t.Code,t.Name,t.Project,t.Department,t.ActualID,t.Father,t.HLevel ORDER BY t.Code ASCQuery 17:08:34 - IsConnectionValid True 17:08:34 - SELECT t.ID AS ID, t.Code AS Code, t.Name AS Name, t.Project AS Project, t.Department AS Department, t.ActualID AS ActualID, t.Father AS Father, t.HLevel AS HLevel, COUNT(t2.ID) AS _children FROM Pro_Dep_SecHierarchy t LEFT OUTER JOIN Pro_Dep_SecHierarchy t2 ON t.ID = t2.Father WHERE t.TenantID =1 AND t.Father = 1 GROUP BY t.ID,t.Code,t.Name,t.Project,t.Department,t.ActualID,t.Father,t.HLevel ORDER BY t.Code ASCQuery 17:08:35 - IsConnectionValid True 17:08:35 - SELECT t.ID AS ID, t.Code AS Code, t.Name AS Name, t.Project AS Project, t.Department AS Department, t.ActualID AS ActualID, t.Father AS Father, t.HLevel AS HLevel, COUNT(t2.ID) AS _children FROM Pro_Dep_SecHierarchy t LEFT OUTER JOIN Pro_Dep_SecHierarchy t2 ON t.ID = t2.Father WHERE t.TenantID =1 AND t.Father = 10 GROUP BY t.ID,t.Code,t.Name,t.Project,t.Department,t.ActualID,t.Father,t.HLevel ORDER BY t.Code ASCQuery 17:08:36 - IsConnectionValid True 17:08:36 - SELECT t.ID AS ID, t.Code AS Code, t.Name AS Name, t.Project AS Project, t.Department AS Department, t.ActualID AS ActualID, t.Father AS Father, t.HLevel AS HLevel, COUNT(t2.ID) AS _children FROM Pro_Dep_SecHierarchy t LEFT OUTER JOIN Pro_Dep_SecHierarchy t2 ON t.ID = t2.Father WHERE t.TenantID =1 AND t.Father = 23 GROUP BY t.ID,t.Code,t.Name,t.Project,t.Department,t.ActualID,t.Father,t.HLevel ORDER BY t.Code ASCQuery 17:08:40 - IsConnectionValid True 17:08:40 - finalQuery ;WITH CTE AS (SELECT ROW_NUMBER() OVER ( ORDER BY ID DESC) AS rn, COUNT(*) OVER() AS _total, * FROM (SELECT * FROM HRMS_vwEmployees WHERE TenantID =1 AND UserID = @val1 and DateLeft = '1900-01-01' and SectionID = @val3 ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow 17:09:10 - IsConnectionValid True 17:09:17 - IsConnectionValid True 17:09:17 - finalQuery ;WITH CTE AS (SELECT ROW_NUMBER() OVER ( ORDER BY ID DESC) AS rn, COUNT(*) OVER() AS _total, * FROM (SELECT * FROM HRMS_vwEmployees WHERE TenantID =1 AND UserID = @val1 and DateLeft = '1900-01-01' and SectionID = @val3 ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow 17:09:26 - IsConnectionValid True 17:09:26 - finalQuery ;WITH CTE AS (SELECT ROW_NUMBER() OVER ( ORDER BY ID DESC) AS rn, COUNT(*) OVER() AS _total, * FROM (SELECT * FROM HRMS_vwEmployees WHERE TenantID =1 AND UserID = @val1 and DateLeft = '1900-01-01' and SectionID = @val3 ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow 17:09:26 - IsConnectionValid True 17:09:26 - finalQuery ;WITH CTE AS (SELECT ROW_NUMBER() OVER ( ORDER BY ID DESC) AS rn, COUNT(*) OVER() AS _total, * FROM (SELECT * FROM HRMS_vwEmployees WHERE TenantID =1 AND UserID = @val1 and DateLeft = '1900-01-01' and SectionID = @val3 ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow 17:10:37 - IsConnectionValid True 17:10:44 - IsConnectionValid True 17:10:44 - (1-gen-1004) : The given key was not present in the dictionary. 17:12:22 - IsConnectionValid True 17:12:29 - IsConnectionValid True 17:12:29 - finalQuery ;WITH CTE AS (SELECT ROW_NUMBER() OVER ( ORDER BY ID DESC) AS rn, COUNT(*) OVER() AS _total, * FROM (SELECT * FROM HRMS_vwEmployees WHERE TenantID =1 AND UserID = @val1 and DateLeft = '1900-01-01' ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow