12:06:27 - IsConnectionValid True
12:06:28 - IsConnectionValid True
12:06:28 - IsConnectionValid True
12:06:34 - IsConnectionValid True
12:06:34 - IsConnectionValid True
12:06:37 - IsConnectionValid True
12:06:38 - IsConnectionValid True
12:06:42 - IsConnectionValid True
12:12:01 - IsConnectionValid True
12:31:13 - IsConnectionValid True
12:31:17 - IsConnectionValid True
12:31:38 - IsConnectionValid True
12:32:51 - IsConnectionValid True
12:33:09 - IsConnectionValid True
12:33:09 - 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
12:33:11 - IsConnectionValid True
12:33:11 - 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
12:33:12 - IsConnectionValid True
12:33:12 - 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
12:52:44 - IsConnectionValid True
12:53:02 - IsConnectionValid True
12:53:41 - IsConnectionValid True
12:53:51 - IsConnectionValid True
13:48:03 - IsConnectionValid True
13:48:20 - IsConnectionValid True
13:48:26 - IsConnectionValid True
13:48:33 - IsConnectionValid True
13:48:50 - IsConnectionValid True
15:37:43 - IsConnectionValid True
15:37:49 - IsConnectionValid True
15:48:07 - IsConnectionValid True
15:48:37 - (399-pay-00100099) : Execution Timeout Expired.  The timeout period elapsed prior to completion of the operation or the server is not responding.
Operation cancelled by user.
15:48:41 - IsConnectionValid True
15:48:53 - IsConnectionValid True
15:49:33 - IsConnectionValid True
15:49:46 - IsConnectionValid True
15:49:52 - IsConnectionValid True
15:49:52 - 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
15:49:52 - IsConnectionValid True
15:49:52 - 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
15:49:59 - IsConnectionValid True
15:49:59 - 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
15:56:14 - IsConnectionValid True
15:56:14 - 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
15:56:19 - IsConnectionValid True
15:56:19 - 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
15:56:22 - IsConnectionValid True
15:56:25 - IsConnectionValid True
15:56:25 - 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
15:58:45 - IsConnectionValid True
15:58:48 - IsConnectionValid True
15:58:48 - 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
15:59:15 - IsConnectionValid True
15:59:18 - IsConnectionValid True
15:59:18 - 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
15:59:38 - IsConnectionValid True
15:59:41 - IsConnectionValid True
15:59:41 - 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
15:59:41 - IsConnectionValid True
15:59:41 - 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
15:59:45 - IsConnectionValid True
15:59:45 - 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
16:00:09 - IsConnectionValid True
16:00:14 - IsConnectionValid True
16:00:14 - 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
16:02:47 - IsConnectionValid True
16:02: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