09:09:48 - IsConnectionValid True 09:09:49 - IsConnectionValid True 09:09:50 - IsConnectionValid True 09:10:01 - IsConnectionValid True 09:10:01 - IsConnectionValid True 09:10:05 - IsConnectionValid True 09:10:07 - IsConnectionValid True 09:12:34 - IsConnectionValid True 09:12:38 - IsConnectionValid True 09:12:44 - IsConnectionValid True 09:12:44 - SELECT DISTINCT ID AS ID, MonthCode AS Code, MonthName AS Name FROM CalculationPeriods WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 09:12:48 - IsConnectionValid True 09:12:56 - IsConnectionValid True 09:12:56 - (2-payroll-0010017) : Could not find stored procedure 'HRMS_EndWorkCalculation'. 09:13:08 - IsConnectionValid True 09:13:20 - IsConnectionValid True 12:36:42 - IsConnectionValid True 12:36:42 - IsConnectionValid True 14:54:39 - IsConnectionValid True 14:54:40 - IsConnectionValid True 14:54:43 - IsConnectionValid True 14:54:43 - 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 14:57:00 - IsConnectionValid True 14:57:04 - IsConnectionValid True 14:57:04 - 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 14:57:51 - IsConnectionValid True 14:57:55 - IsConnectionValid True 14:57:55 - 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 14:59:35 - IsConnectionValid True 14:59:38 - IsConnectionValid True 14:59: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 14:59:52 - IsConnectionValid True 14:59:55 - IsConnectionValid True 14:59:55 - 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 15:00:07 - IsConnectionValid True 15:00:10 - IsConnectionValid True 15:00: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