00:42:36 - IsConnectionValid True 00:42:45 - IsConnectionValid True 00:42:46 - IsConnectionValid True 00:42:46 - IsConnectionValid True 00:42:52 - IsConnectionValid True 00:42:52 - IsConnectionValid True 00:42:55 - IsConnectionValid True 00:42:57 - IsConnectionValid True 00:42:57 - SELECT * FROM HRMS_VwVacationEntry WHERE TenantID = 1 AND TenantID = @val0 AND EmployeeID = @val1 AND UserID = @val2 AND Posted <> @val3 ORDER BY FromDate ASC Query 00:44:45 - IsConnectionValid True 00:44:45 - IsConnectionValid True 00:44:45 - SELECT * FROM HRMS_VwVacationEntry WHERE TenantID = 1 AND TenantID = @val0 AND EmployeeID = @val1 AND UserID = @val2 AND Posted <> @val3 ORDER BY FromDate ASC Query 00:48:22 - IsConnectionValid True 00:48:22 - IsConnectionValid True 00:48:22 - SELECT * FROM HRMS_VwVacationEntry WHERE TenantID = 1 AND TenantID = @val0 AND EmployeeID = @val1 AND UserID = @val2 AND Posted <> @val3 ORDER BY FromDate ASC Query 00:48:51 - IsConnectionValid True 00:48:52 - IsConnectionValid True 00:48:52 - SELECT * FROM HRMS_VwVacationEntry WHERE TenantID = 1 AND TenantID = @val0 AND EmployeeID = @val1 AND UserID = @val2 AND Posted <> @val3 ORDER BY FromDate ASC Query 00:49:43 - IsConnectionValid True 00:49:43 - IsConnectionValid True 00:49:43 - SELECT * FROM HRMS_VwVacationEntry WHERE TenantID = 1 AND TenantID = @val0 AND EmployeeID = @val1 AND UserID = @val2 AND Posted <> @val3 ORDER BY FromDate ASC Query 00:51:30 - IsConnectionValid True 00:51:30 - IsConnectionValid True 00:51:30 - SELECT * FROM HRMS_VwVacationEntry WHERE TenantID = 1 AND TenantID = @val0 AND EmployeeID = @val1 AND UserID = @val2 AND Posted <> @val3 ORDER BY FromDate ASC Query 00:52:46 - IsConnectionValid True 00:52:47 - IsConnectionValid True 00:52:47 - SELECT * FROM HRMS_VwVacationEntry WHERE TenantID = 1 AND TenantID = @val0 AND EmployeeID = @val1 AND UserID = @val2 AND Posted <> @val3 ORDER BY FromDate ASC Query 00:55:57 - IsConnectionValid True 00:55:58 - IsConnectionValid True 00:55:58 - SELECT * FROM HRMS_VwVacationEntry WHERE TenantID = 1 AND TenantID = @val0 AND EmployeeID = @val1 AND UserID = @val2 AND Posted <> @val3 ORDER BY FromDate ASC Query 00:56:27 - IsConnectionValid True 00:56:28 - IsConnectionValid True 00:56:28 - SELECT * FROM HRMS_VwVacationEntry WHERE TenantID = 1 AND TenantID = @val0 AND EmployeeID = @val1 AND UserID = @val2 AND Posted <> @val3 ORDER BY FromDate ASC Query 00:57:10 - IsConnectionValid True 00:57:10 - IsConnectionValid True 00:57: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 00:59:39 - IsConnectionValid True 00:59:39 - finalQuery ;WITH CTE AS (SELECT ROW_NUMBER() OVER ( ORDER BY ID ASC) AS rn, COUNT(*) OVER() AS _total, * FROM (SELECT * FROM HRMS_vwEmployees WHERE (DateLeft =01/01/1900 or (DateleftTemp<>DateLeft and DateLeft >07/12/2023)) and UserID = @val1 and TenantID = @val2 ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow 00:59:40 - IsConnectionValid True 00:59:40 - SELECT * FROM HRMS_VwVacationEntry WHERE TenantID = 1 AND TenantID = @val0 AND EmployeeID = @val1 AND UserID = @val2 AND Posted <> @val3 ORDER BY FromDate ASC Query 01:00:44 - IsConnectionValid True 01:00:44 - IsConnectionValid True 01:00:44 - SELECT * FROM HRMS_VwVacationEntry WHERE TenantID = 1 AND TenantID = @val0 AND EmployeeID = @val1 AND UserID = @val2 AND Posted <> @val3 ORDER BY FromDate ASC Query 01:00:46 - IsConnectionValid True 01:00:46 - 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 >07/12/2023)) and UserID = @val1 and TenantID = @val2 ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow 01:00:47 - IsConnectionValid True 01:00:47 - SELECT * FROM HRMS_VwVacationEntry WHERE TenantID = 1 AND TenantID = @val0 AND EmployeeID = @val1 AND UserID = @val2 AND Posted <> @val3 ORDER BY FromDate ASC Query 01:01:10 - IsConnectionValid True 01:01:11 - IsConnectionValid True 01:01: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 01:01:16 - IsConnectionValid True 01:01:16 - finalQuery ;WITH CTE AS (SELECT ROW_NUMBER() OVER ( ORDER BY ID ASC) AS rn, COUNT(*) OVER() AS _total, * FROM (SELECT * FROM HRMS_vwEmployees WHERE (DateLeft =01/01/1900 or (DateleftTemp<>DateLeft and DateLeft >07/12/2023)) and UserID = @val1 and TenantID = @val2 ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow 01:01:17 - IsConnectionValid True 01:01:17 - SELECT * FROM HRMS_VwVacationEntry WHERE TenantID = 1 AND TenantID = @val0 AND EmployeeID = @val1 AND UserID = @val2 AND Posted <> @val3 ORDER BY FromDate ASC Query 01:02:26 - IsConnectionValid True 01:02:27 - IsConnectionValid True 01:02:27 - SELECT * FROM HRMS_VwVacationEntry WHERE TenantID = 1 AND TenantID = @val0 AND EmployeeID = @val1 AND UserID = @val2 AND Posted <> @val3 ORDER BY FromDate ASC Query 01:02:29 - IsConnectionValid True 01:02:29 - 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 >07/12/2023)) and UserID = @val1 and TenantID = @val2 ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow 01:02:30 - IsConnectionValid True 01:02:30 - SELECT * FROM HRMS_VwVacationEntry WHERE TenantID = 1 AND TenantID = @val0 AND EmployeeID = @val1 AND UserID = @val2 AND Posted <> @val3 ORDER BY FromDate ASC Query 01:03:23 - IsConnectionValid True 01:03:23 - 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 01:03:23 - IsConnectionValid True 01:03:23 - SELECT DISTINCT * FROM HRMS_vwEmployees WHERE TenantID = 1 AND TenantID = @val0 AND ID = @val1 AND UserID = @val2 ORDER BY ID Query 01:05:17 - IsConnectionValid True 01:05:18 - IsConnectionValid True 01:05:18 - SELECT * FROM HRMS_VwVacationEntry WHERE TenantID = 1 AND TenantID = @val0 AND EmployeeID = @val1 AND UserID = @val2 AND Posted <> @val3 ORDER BY FromDate ASC Query 01:06:48 - IsConnectionValid True 01:06:49 - IsConnectionValid True 01:06:49 - SELECT * FROM HRMS_VwVacationEntry WHERE TenantID = 1 AND TenantID = @val0 AND EmployeeID = @val1 AND UserID = @val2 AND Posted <> @val3 ORDER BY FromDate ASC Query 01:06:51 - IsConnectionValid True 01:06: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 >07/12/2023)) and UserID = @val1 and TenantID = @val2 ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow 01:06:52 - IsConnectionValid True 01:06:52 - SELECT * FROM HRMS_VwVacationEntry WHERE TenantID = 1 AND TenantID = @val0 AND EmployeeID = @val1 AND UserID = @val2 AND Posted <> @val3 ORDER BY FromDate ASC Query 01:10:30 - IsConnectionValid True 01:10:31 - IsConnectionValid True 01:10:31 - SELECT * FROM HRMS_VwVacationEntry WHERE TenantID = 1 AND TenantID = @val0 AND EmployeeID = @val1 AND UserID = @val2 AND Posted <> @val3 ORDER BY FromDate ASC Query 01:10:33 - IsConnectionValid True 01:10:33 - 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 >07/12/2023)) and UserID = @val1 and TenantID = @val2 ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow 01:10:34 - IsConnectionValid True 01:10:34 - SELECT * FROM HRMS_VwVacationEntry WHERE TenantID = 1 AND TenantID = @val0 AND EmployeeID = @val1 AND UserID = @val2 AND Posted <> @val3 ORDER BY FromDate ASC Query 01:11:53 - IsConnectionValid True 01:11:53 - IsConnectionValid True 01:11:53 - SELECT * FROM HRMS_VwVacationEntry WHERE TenantID = 1 AND TenantID = @val0 AND EmployeeID = @val1 AND UserID = @val2 AND Posted <> @val3 ORDER BY FromDate ASC Query 01:11:56 - IsConnectionValid True 01:11:56 - 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 >07/12/2023)) and UserID = @val1 and TenantID = @val2 ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow 01:11:56 - IsConnectionValid True 01:11:56 - SELECT * FROM HRMS_VwVacationEntry WHERE TenantID = 1 AND TenantID = @val0 AND EmployeeID = @val1 AND UserID = @val2 AND Posted <> @val3 ORDER BY FromDate ASC Query 01:12:32 - IsConnectionValid True 01:12:33 - IsConnectionValid True 01:12:33 - SELECT * FROM HRMS_VwVacationEntry WHERE TenantID = 1 AND TenantID = @val0 AND EmployeeID = @val1 AND UserID = @val2 AND Posted <> @val3 ORDER BY FromDate ASC Query 01:13:03 - IsConnectionValid True 01:13:03 - 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 >07/12/2023)) and UserID = @val1 and TenantID = @val2 ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow 01:13:04 - IsConnectionValid True 01:13: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 01:15:07 - IsConnectionValid True 01:15:07 - IsConnectionValid True 01:15:07 - SELECT * FROM HRMS_VwVacationEntry WHERE TenantID = 1 AND TenantID = @val0 AND EmployeeID = @val1 AND UserID = @val2 AND Posted <> @val3 ORDER BY FromDate ASC Query 01:15:29 - IsConnectionValid True 01:15:30 - IsConnectionValid True 01:15:30 - SELECT * FROM HRMS_VwVacationEntry WHERE TenantID = 1 AND TenantID = @val0 AND EmployeeID = @val1 AND UserID = @val2 AND Posted <> @val3 ORDER BY FromDate ASC Query 01:16:16 - IsConnectionValid True 01:16:17 - IsConnectionValid True 01:16:17 - SELECT * FROM HRMS_VwVacationEntry WHERE TenantID = 1 AND TenantID = @val0 AND EmployeeID = @val1 AND UserID = @val2 AND Posted <> @val3 ORDER BY FromDate ASC Query 01:16:18 - IsConnectionValid True 01:16:18 - 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 >07/12/2023)) and UserID = @val1 and TenantID = @val2 ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow 01:16:19 - IsConnectionValid True 01:16:19 - SELECT * FROM HRMS_VwVacationEntry WHERE TenantID = 1 AND TenantID = @val0 AND EmployeeID = @val1 AND UserID = @val2 AND Posted <> @val3 ORDER BY FromDate ASC Query 01:21:02 - IsConnectionValid True 01:21:03 - IsConnectionValid True 01:21:03 - SELECT * FROM HRMS_VwVacationEntry WHERE TenantID = 1 AND TenantID = @val0 AND EmployeeID = @val1 AND UserID = @val2 AND Posted <> @val3 ORDER BY FromDate ASC Query 01:21:05 - IsConnectionValid True 01:21: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 =01/01/1900 or (DateleftTemp<>DateLeft and DateLeft >07/12/2023)) and UserID = @val1 and TenantID = @val2 ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow 01:21:06 - IsConnectionValid True 01:21: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 01:21:07 - IsConnectionValid True 01:21:07 - 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 01:21:08 - IsConnectionValid True 01:21:08 - SELECT DISTINCT * FROM HRMS_vwEmployees WHERE TenantID = 1 AND TenantID = @val0 AND ID = @val1 AND UserID = @val2 ORDER BY ID Query 01:21:26 - IsConnectionValid True 01:21:26 - IsConnectionValid True 01:21:26 - IsConnectionValid True 01:21:26 - IsConnectionValid True 01:21:26 - SELECT * FROM HRMS_VwVacationEntry WHERE TenantID = 1 AND TenantID = @val0 AND EmployeeID = @val1 AND UserID = @val2 AND Posted <> @val3 ORDER BY FromDate ASC Query 01:31:26 - IsConnectionValid True 01:31:27 - IsConnectionValid True 01:31:27 - SELECT * FROM HRMS_VwVacationEntry WHERE TenantID = 1 AND TenantID = @val0 AND EmployeeID = @val1 AND UserID = @val2 AND Posted <> @val3 ORDER BY FromDate ASC Query 01:31:28 - IsConnectionValid True 01:31:29 - (1-gen-005001120) : Subquery returned more than 1 value. This is not permitted when the subquery follows =, !=, <, <= , >, >= or when the subquery is used as an expression. 01:32:20 - IsConnectionValid True 01:32:21 - IsConnectionValid True 01:32:23 - IsConnectionValid True 01:32:23 - (1-gen-005001120) : Subquery returned more than 1 value. This is not permitted when the subquery follows =, !=, <, <= , >, >= or when the subquery is used as an expression. 01:32:31 - IsConnectionValid True 01:32:32 - IsConnectionValid True 01:32:32 - (1-gen-005001120) : Subquery returned more than 1 value. This is not permitted when the subquery follows =, !=, <, <= , >, >= or when the subquery is used as an expression. 01:33:01 - IsConnectionValid True 01:33:02 - IsConnectionValid True 01:33:22 - IsConnectionValid True 01:33:27 - IsConnectionValid True 01:33:27 - IsConnectionValid True 01:33:31 - IsConnectionValid True 01:34:15 - IsConnectionValid True 01:34:16 - IsConnectionValid True 01:35:08 - IsConnectionValid True 01:35:08 - IsConnectionValid True 01:35:56 - IsConnectionValid True 01:35:57 - IsConnectionValid True 01:36:06 - IsConnectionValid True 01:36:08 - IsConnectionValid True 01:36:14 - IsConnectionValid True 01:36:20 - IsConnectionValid True 01:36:20 - IsConnectionValid True 01:36:23 - IsConnectionValid True 01:39:35 - IsConnectionValid True 01:39:35 - IsConnectionValid True 01:40:02 - IsConnectionValid True 01:40:03 - IsConnectionValid True 01:40:58 - IsConnectionValid True 01:40:58 - IsConnectionValid True 01:41:55 - IsConnectionValid True 01:41:55 - 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 01:46:54 - IsConnectionValid True 01:46:57 - IsConnectionValid True 01:46:58 - IsConnectionValid True 01:47:01 - IsConnectionValid True 01:47:01 - 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 01:54:33 - IsConnectionValid True 01:54:35 - IsConnectionValid True 01:54:35 - 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 01:54:52 - IsConnectionValid True 01:55:05 - IsConnectionValid True 01:55:07 - IsConnectionValid True 01:55:18 - IsConnectionValid True 01:55:24 - IsConnectionValid True 01:55:27 - IsConnectionValid True 01:55:27 - 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 01:55:39 - IsConnectionValid True 01:57:37 - IsConnectionValid True 01:57:40 - IsConnectionValid True 01:57:40 - 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 01:57:43 - IsConnectionValid True 01:57:45 - IsConnectionValid True 01:57:46 - IsConnectionValid True 01:57:53 - IsConnectionValid True 01:57:53 - 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 01:57:59 - IsConnectionValid True 01:58:05 - IsConnectionValid True 01:58:05 - IsConnectionValid True 01:58:09 - IsConnectionValid True 01:58:12 - IsConnectionValid True 01:58:12 - 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 01:58:46 - IsConnectionValid True 01:58:47 - IsConnectionValid True 01:58:51 - IsConnectionValid True 01:58:53 - IsConnectionValid True 01:58:53 - 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 01:59:23 - IsConnectionValid True 01:59:24 - IsConnectionValid True 01:59:24 - 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 01:59:34 - IsConnectionValid True 02:00:02 - IsConnectionValid True 02:00:05 - IsConnectionValid True 02:00:14 - IsConnectionValid True 02:00:25 - IsConnectionValid True 02:01:48 - IsConnectionValid True 02:02:01 - IsConnectionValid True 02:02:01 - finalQuery ;WITH CTE AS (SELECT ROW_NUMBER() OVER ( ORDER BY ID) AS rn, COUNT(*) OVER() AS _total, * FROM (SELECT DISTINCT * FROM VwSections WHERE TenantID = 1 AND TenantID = @val0 AND UserID = @val1 ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow 02:02:03 - IsConnectionValid True 02:02:03 - SELECT DISTINCT * FROM vwSectionDetails WHERE TenantID = 1 AND TenantID = @val0 AND SectionID = @val1 Query 02:02:06 - IsConnectionValid True 02:02: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 FROM Jobs WHERE TenantID = 1 AND TenantID = @val0 ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow 02:02:13 - IsConnectionValid True 02:02:13 - 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 FROM Jobs WHERE TenantID = 1 AND TenantID = @val0 ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow 02:02:16 - IsConnectionValid True 02:02:16 - 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 FROM Jobs WHERE TenantID = 1 AND TenantID = @val0 ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow 02:02:38 - IsConnectionValid True 02:02:38 - (1-def-0010013) : Invalid object name 'SectionDetails'. 02:08:11 - IsConnectionValid True 02:08:12 - IsConnectionValid True 02:08:12 - IsConnectionValid True 02:08:12 - finalQuery ;WITH CTE AS (SELECT ROW_NUMBER() OVER ( ORDER BY ID) AS rn, COUNT(*) OVER() AS _total, * FROM (SELECT DISTINCT * FROM VwSections WHERE TenantID = 1 AND TenantID = @val0 AND UserID = @val1 ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow 02:08:13 - IsConnectionValid True 02:08:13 - SELECT DISTINCT * FROM vwSectionDetails WHERE TenantID = 1 AND TenantID = @val0 AND SectionID = @val1 Query 02:09:53 - IsConnectionValid True 02:09:54 - IsConnectionValid True 02:09:54 - SELECT DISTINCT * FROM vwSectionDetails WHERE TenantID = 1 AND TenantID = @val0 AND SectionID = @val1 Query 02:10:04 - IsConnectionValid True 02:10:04 - IsConnectionValid True 02:10:04 - IsConnectionValid True 02:10:04 - finalQuery ;WITH CTE AS (SELECT ROW_NUMBER() OVER ( ORDER BY ID) AS rn, COUNT(*) OVER() AS _total, * FROM (SELECT DISTINCT * FROM VwSections WHERE TenantID = 1 AND TenantID = @val0 AND UserID = @val1 ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow 02:10:06 - IsConnectionValid True 02:10:06 - SELECT DISTINCT * FROM vwSectionDetails WHERE TenantID = 1 AND TenantID = @val0 AND SectionID = @val1 Query 02:10:09 - IsConnectionValid True 02:10:09 - finalQuery ;WITH CTE AS (SELECT ROW_NUMBER() OVER ( ORDER BY ID) AS rn, COUNT(*) OVER() AS _total, * FROM (SELECT DISTINCT * FROM VwSections WHERE TenantID = 1 AND TenantID = @val0 AND UserID = @val1 ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow 13:08:44 - IsConnectionValid True 13:08:45 - IsConnectionValid True 13:08:46 - IsConnectionValid True 13:09:02 - IsConnectionValid True 13:09:02 - IsConnectionValid True 13:09:09 - IsConnectionValid True 13:09:11 - IsConnectionValid True 13:09:22 - IsConnectionValid True 13:09:22 - 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 15:32:50 - IsConnectionValid True 15:33:22 - IsConnectionValid True 15:33:22 - SELECT * FROM SysAlerts WHERE TenantID=@TenantID AND Active = 1 Query NEW -______- 1 15:33:23 - IsConnectionValid True 15:33:27 - IsConnectionValid True 15:46:44 - IsConnectionValid True 15:46:44 - IsConnectionValid True 15:55:53 - IsConnectionValid True 15:56:08 - IsConnectionValid True 15:56:08 - finalQuery ;WITH CTE AS (SELECT ROW_NUMBER() OVER ( ORDER BY ID) AS rn, COUNT(*) OVER() AS _total, * FROM (SELECT DISTINCT * FROM JobType WHERE TenantID = 1 AND TenantID = @val0 ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow 15:56:10 - IsConnectionValid True 16:24:20 - IsConnectionValid True 16:24:50 - IsConnectionValid True 16:26:17 - IsConnectionValid True 16:26:40 - IsConnectionValid True 16:26:41 - IsConnectionValid True 16:27:20 - IsConnectionValid True 16:28:07 - IsConnectionValid True 16:28:09 - IsConnectionValid True 16:28: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:28:09 - IsConnectionValid True 16:28:09 - IsConnectionValid True 16:28:35 - IsConnectionValid True 16:28:37 - IsConnectionValid True 16:28:37 - IsConnectionValid True 16:28:37 - 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:28:38 - IsConnectionValid True 16:29:16 - IsConnectionValid True 16:29:17 - IsConnectionValid True 16:29: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' ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow 16:29:18 - IsConnectionValid True 16:29:18 - (3-def-00100066) : Error converting data type nvarchar to datetime. 16:30:02 - IsConnectionValid True 16:30:03 - IsConnectionValid True 16:30:03 - IsConnectionValid True 16:30:03 - 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:30:03 - (3-def-00100066) : Amount 16:31:18 - IsConnectionValid True 16:31:19 - IsConnectionValid True 16:31:19 - 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:31:19 - IsConnectionValid True 16:35:20 - IsConnectionValid True 16:35:21 - IsConnectionValid True 16:35: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 16:35:21 - IsConnectionValid True