08:46:29 - IsConnectionValid True
10:01:51 - IsConnectionValid True
10:02:01 - IsConnectionValid True
10:02:01 - IsConnectionValid True
10:02:01 - IsConnectionValid True
10:02:01 - IsConnectionValid True
10:02:03 - IsConnectionValid True
10:02:03 - IsConnectionValid True
10:02:03 - IsConnectionValid True
10:02:03 - IsConnectionValid True
10:02:03 - IsConnectionValid True
10:02:03 - IsConnectionValid True
10:02:03 - IsConnectionValid True
10:02:03 - IsConnectionValid True
10:02:03 - IsConnectionValid True
10:02:03 - IsConnectionValid True
10:02:03 - IsConnectionValid True
10:02:03 - IsConnectionValid True
10:02:03 - IsConnectionValid True
10:02:03 - IsConnectionValid True
10:02:03 - IsConnectionValid True
10:02:03 - IsConnectionValid True
10:02:03 - IsConnectionValid True
10:02:03 - IsConnectionValid True
10:02:03 - IsConnectionValid True
10:02:03 - IsConnectionValid True
10:02:03 - IsConnectionValid True
10:02:03 - IsConnectionValid True
10:02:03 - IsConnectionValid True
10:02:03 - IsConnectionValid True
10:02:03 - IsConnectionValid True
10:02:03 - IsConnectionValid True
10:02:03 - IsConnectionValid True
10:02:04 - IsConnectionValid True
10:02:04 - IsConnectionValid True
10:02:10 - IsConnectionValid True
10:02:30 - IsConnectionValid True
10:02:30 - IsConnectionValid True
10:02:36 - IsConnectionValid True
10:02:43 - IsConnectionValid True
10:02:54 - IsConnectionValid True
10:02: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
10:06:51 - IsConnectionValid True
10:06:58 - IsConnectionValid True
10:06:58 - 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
10:07:19 - IsConnectionValid True
10:07:27 - IsConnectionValid True
10:07:27 - 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
10:07:45 - IsConnectionValid True
11:21:37 - IsConnectionValid True
11:21:44 - IsConnectionValid True
11:22:05 - IsConnectionValid True
11:22:08 - IsConnectionValid True
11:24:22 - IsConnectionValid True
11:24:25 - IsConnectionValid True
11:32:24 - IsConnectionValid True
11:32:28 - IsConnectionValid True
11:32:36 - IsConnectionValid True
11:32:36 - SELECT ID AS ID, Code AS Code, Name AS Name, CASE WHEN DateLeftTemp<>'01/01/1900' THEN 1 ELSE 0  END AS Resigned FROM HRMS_vwEmployees WHERE  UserID = @val0 AND CAST(DateLeft AS Date) = @val1 and TenantID = @val2 and ID IN (select EmployeeID from VwTransactionForSalCal where (Reccuring=2 or Reccuring=99) and UserID='Stc') AND (Code LIKE '%1%'  OR Name LIKE '%1%' ) ORDER BY ID ASC  Query
11:32:36 - IsConnectionValid True
11:32:36 - 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, CASE WHEN DateLeftTemp<>'01/01/1900' THEN 1 ELSE 0  END AS Resigned FROM HRMS_vwEmployees  WHERE   UserID = @val0 AND CAST(DateLeft AS Date) = @val1 and TenantID = @val2 and ID in (select EmployeeID from VwTransactionForSalCal where (Reccuring=2 or Reccuring=99) and UserID='Stc')  ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow
11:32:47 - IsConnectionValid True
11:32:47 - finalQuery  ;WITH CTE AS (SELECT  ROW_NUMBER() OVER ( ORDER BY ID ASC) AS rn, COUNT(*) OVER() AS _total, * FROM (SELECT  DISTINCT * FROM VwLoansEntry  WHERE   TenantID = @val0 AND EmployeeID = @val1 AND UserID = @val2 AND (Status='T' or (Status='F'  AND NET<>0) or ((Status='F'  AND NET=0) AND NOT EXISTS( SELECT closeDate FROM CloseMonth WHERE closeDate =(SELECT MAX(PaymentDate) from LoansDetails where LoanMasterID =VwLoansEntry.ID))))   ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow
11:32:48 - IsConnectionValid True
11:33:07 - IsConnectionValid True
11:34:11 - IsConnectionValid True
11:34:18 - IsConnectionValid True
11:35:39 - IsConnectionValid True
11:36:37 - IsConnectionValid True
11:39:03 - IsConnectionValid True
11:39:35 - IsConnectionValid True
11:41:43 - IsConnectionValid True
11:41:48 - IsConnectionValid True
11:41:48 - finalQuery  ;WITH CTE AS (SELECT  ROW_NUMBER() OVER ( ORDER BY ID ASC) AS rn, COUNT(*) OVER() AS _total, * FROM (SELECT  DISTINCT * FROM VwTransactionForSalCal  WHERE   TenantID = @val0 AND (Reccuring=99 or Reccuring=2)  AND IsNotManualEntry = @val2 AND Loans = @val3 AND EmployeeID = @val4 AND UserID = @val5  ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow
11:41:49 - IsConnectionValid True
11:48:41 - IsConnectionValid True
11:48:48 - IsConnectionValid True
11:48:49 - IsConnectionValid True
11:48:49 - 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 FROM Project  WHERE  TenantID = 1  ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow
11:48:49 - (1-gen-1004) : Invalid object name 'Project'.
11:49:19 - IsConnectionValid True
11:49:40 - IsConnectionValid True
14:47:05 - IsConnectionValid True
14:47:06 - IsConnectionValid True
14:47:20 - IsConnectionValid True
14:47:40 - IsConnectionValid True
14:47:53 - IsConnectionValid True