10:58:55 - (3-gen-005004) : Input string was not in a correct format.
11:00:38 - SELECT ID AS ID, NameState AS NameState, ItemOrder AS ItemOrder, Serial AS Serial FROM Sections WHERE TenantID = 1 AND   Serial <> @val0 AND IsOtherOption = @val1 ORDER BY ItemOrder  Query
11:00:38 - SELECT ID AS ID, NameState AS NameState, ItemOrder AS ItemOrder, Serial AS Serial FROM Sections WHERE TenantID = 1 AND   Serial <> @val0 AND IsOtherOption = @val1 ORDER BY ItemOrder  Query
11:00:49 - SELECT ID AS ID, NameState AS NameState, ItemOrder AS ItemOrder, Serial AS Serial FROM Sections WHERE TenantID = 1 AND   Serial <> @val0 AND IsOtherOption = @val1 ORDER BY ItemOrder  Query
11:00:49 - SELECT ID AS ID, NameState AS NameState, ItemOrder AS ItemOrder, Serial AS Serial FROM Sections WHERE TenantID = 1 AND   Serial <> @val0 AND IsOtherOption = @val1 ORDER BY ItemOrder  Query
11:00:55 - SELECT ID AS ID, NameState AS NameState, ItemOrder AS ItemOrder, Serial AS Serial FROM Sections WHERE TenantID = 1 AND   Serial <> @val0 AND IsOtherOption = @val1 ORDER BY ItemOrder  Query
11:00:55 - SELECT ID AS ID, NameState AS NameState, ItemOrder AS ItemOrder, Serial AS Serial FROM Sections WHERE TenantID = 1 AND   Serial <> @val0 AND IsOtherOption = @val1 ORDER BY ItemOrder  Query
11:02:55 - SELECT ID AS ID, NameState AS NameState, ItemOrder AS ItemOrder, Serial AS Serial FROM Sections WHERE TenantID = 1 AND   Serial <> @val0 AND IsOtherOption = @val1 ORDER BY ItemOrder  Query
11:02:55 - SELECT ID AS ID, NameState AS NameState, ItemOrder AS ItemOrder, Serial AS Serial FROM Sections WHERE TenantID = 1 AND   Serial <> @val0 AND IsOtherOption = @val1 ORDER BY ItemOrder  Query
11:03:12 - SELECT ID AS ID, NameState AS NameState, ItemOrder AS ItemOrder, Serial AS Serial FROM Sections WHERE TenantID = 1 AND   Serial <> @val0 AND IsOtherOption = @val1 ORDER BY ItemOrder  Query
11:03:12 - SELECT ID AS ID, NameState AS NameState, ItemOrder AS ItemOrder, Serial AS Serial FROM Sections WHERE TenantID = 1 AND   Serial <> @val0 AND IsOtherOption = @val1 ORDER BY ItemOrder  Query
11:03:16 - SELECT ID AS ID, NameState AS NameState, ItemOrder AS ItemOrder, Serial AS Serial FROM Sections WHERE TenantID = 1 AND   Serial <> @val0 AND IsOtherOption = @val1 ORDER BY ItemOrder  Query
11:03:16 - SELECT ID AS ID, NameState AS NameState, ItemOrder AS ItemOrder, Serial AS Serial FROM Sections WHERE TenantID = 1 AND   Serial <> @val0 AND IsOtherOption = @val1 ORDER BY ItemOrder  Query
11:03:20 - SELECT ID AS ID, NameState AS NameState, ItemOrder AS ItemOrder, Serial AS Serial FROM Sections WHERE TenantID = 1 AND   Serial <> @val0 AND IsOtherOption = @val1 ORDER BY ItemOrder  Query
11:03:21 - SELECT ID AS ID, NameState AS NameState, ItemOrder AS ItemOrder, Serial AS Serial FROM Sections WHERE TenantID = 1 AND   Serial <> @val0 AND IsOtherOption = @val1 ORDER BY ItemOrder  Query
11:03:28 - SELECT ID AS ID, NameState AS NameState, ItemOrder AS ItemOrder, Serial AS Serial FROM Sections WHERE TenantID = 1 AND   Serial <> @val0 AND IsOtherOption = @val1 ORDER BY ItemOrder  Query
11:03:28 - SELECT ID AS ID, NameState AS NameState, ItemOrder AS ItemOrder, Serial AS Serial FROM Sections WHERE TenantID = 1 AND   Serial <> @val0 AND IsOtherOption = @val1 ORDER BY ItemOrder  Query
11:03:32 - SELECT ID AS ID, NameState AS NameState, ItemOrder AS ItemOrder, Serial AS Serial FROM Sections WHERE TenantID = 1 AND   Serial <> @val0 AND IsOtherOption = @val1 ORDER BY ItemOrder  Query
11:03:32 - SELECT ID AS ID, NameState AS NameState, ItemOrder AS ItemOrder, Serial AS Serial FROM Sections WHERE TenantID = 1 AND   Serial <> @val0 AND IsOtherOption = @val1 ORDER BY ItemOrder  Query
11:15:44 - SELECT  DISTINCT ID AS ID, AllRights AS AllRights FROM Users WHERE TenantID = 1 AND   IsGroup = @val0 ORDER BY ID  Query
11:15:44 - SELECT  DISTINCT ID AS DepartmentID, Name AS DepartmentName, '' AS Details FROM Departments WHERE TenantID = 1 AND   TenantID = @val0 ORDER BY ID  Query
11:23:31 - SELECT  DISTINCT * FROM StaffCategory WHERE  TenantID =1 ORDER BY ID  Query
11:23:31 - SELECT * FROM web_HRMS_Experience WHERE TenantID = 1 AND   TenantID = @val0 ORDER BY StaffCatID ASC, ExperienceNo2 ASC  Query
11:23:36 - SELECT  DISTINCT * FROM StaffCategory WHERE  TenantID =1 ORDER BY ID  Query
11:23:36 - SELECT * FROM web_HRMS_Experience WHERE TenantID = 1 AND   TenantID = @val0 ORDER BY StaffCatID ASC, ExperienceNo2 ASC  Query
11:23:47 - SELECT * FROM SysAlerts WHERE TenantID=@TenantID AND Active = 1 Query NEW -______- 1
11:23:47 - Select COUNT(ID) AS TotalNum FROM Employees WHERE ( DATEDIFF(DAY,GETDATE(),EndContractDate)<=30 AND DATEDIFF(DAY,GETDATE(),EndContractDate)>0)  COUNT Query 0
11:38:35 - SELECT  DISTINCT ID AS ID, AllRights AS AllRights FROM Users WHERE TenantID = 1 AND   IsGroup = @val0 ORDER BY ID  Query
11:38:35 - SELECT  DISTINCT ID AS DepartmentID, Name AS DepartmentName, '' AS Details FROM Departments WHERE TenantID = 1 AND   TenantID = @val0 ORDER BY ID  Query
12:12:11 - SELECT * FROM SysAlerts WHERE TenantID=@TenantID AND Active = 1 Query NEW -______- 1
12:12:11 - Select COUNT(ID) AS TotalNum FROM Employees WHERE ( DATEDIFF(DAY,GETDATE(),EndContractDate)<=30 AND DATEDIFF(DAY,GETDATE(),EndContractDate)>0)  COUNT Query 0
14:52:53 - 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:53:06 - 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:53: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
14:53:12 - 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:53:40 - 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
14:53:45 - 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
14:53:49 - 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
14:53:50 - 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
14:59:42 - 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:45 - 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:57 - finalQuery  ;WITH CTE AS (SELECT  ROW_NUMBER() OVER ( ORDER BY ID) AS rn, COUNT(*) OVER() AS _total, * FROM (SELECT  DISTINCT * FROM vwJobs  WHERE  TenantID = 1 AND   TenantID = @val0  ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow
15:00:01 - finalQuery  ;WITH CTE AS (SELECT  ROW_NUMBER() OVER ( ORDER BY ID) AS rn, COUNT(*) OVER() AS _total, * FROM (SELECT  DISTINCT * FROM vwJobs  WHERE  TenantID = 1 AND   TenantID = @val0  ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow
15:03:53 - finalQuery  ;WITH CTE AS (SELECT  ROW_NUMBER() OVER ( ORDER BY ID) AS rn, COUNT(*) OVER() AS _total, * FROM (SELECT  DISTINCT * FROM vwJobs  WHERE  TenantID = 1 AND   TenantID = @val0  ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow