10:47:41 - IsConnectionValid True
10:47:43 - IsConnectionValid True
10:47:45 - IsConnectionValid True
10:51:07 - IsConnectionValid True
10:51:13 - IsConnectionValid True
10:51:18 - IsConnectionValid True
10:52:25 - IsConnectionValid True
10:52:26 - IsConnectionValid True
10:52:31 - IsConnectionValid True
10:52:33 - IsConnectionValid True
10:52:37 - IsConnectionValid True
10:52:37 - SELECT  DISTINCT COUNT(*) AS DayCount FROM HRMS_vwVacTransType WHERE TenantID = 1 AND   TenantID = @val0 AND IsOverTime = @val1  Query
10:52:40 - IsConnectionValid True
10:52:40 - 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, EnglishName AS EnglishName FROM Employees  WHERE  TenantID = 1 AND   TenantID = @val0  ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow
10:52:44 - IsConnectionValid True
10:52:44 - 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, EnglishName AS EnglishName FROM Employees  WHERE  TenantID = 1 AND   TenantID = @val0 AND Code LIKE @val1  ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow
10:52:53 - IsConnectionValid True
10:52:53 - IsConnectionValid True
10:53:03 - IsConnectionValid True
10:53:03 - IsConnectionValid True
10:53:03 - (3-hr-0010001) : Subquery returned more than 1 value. This is not permitted when the subquery follows =, !=, <, <= , >, >= or when the subquery is used as an expression.
10:53:16 - IsConnectionValid True
10:53:16 - IsConnectionValid True
10:53:16 - (3-hr-0010001) : Subquery returned more than 1 value. This is not permitted when the subquery follows =, !=, <, <= , >, >= or when the subquery is used as an expression.
10:53:28 - IsConnectionValid True
10:53:30 - IsConnectionValid True
10:53:32 - IsConnectionValid True
10:53:57 - IsConnectionValid True
10:54:28 - IsConnectionValid True
10:55:07 - IsConnectionValid True
10:55:14 - IsConnectionValid True
10:55:14 - SELECT  DISTINCT COUNT(*) AS DayCount FROM HRMS_vwVacTransType WHERE TenantID = 1 AND   TenantID = @val0 AND IsOverTime = @val1  Query
10:55:38 - IsConnectionValid True
10:55:38 - 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, EnglishName AS EnglishName FROM Employees  WHERE  TenantID = 1 AND   TenantID = @val0  ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow
10:55:41 - IsConnectionValid True
10:55:41 - 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, EnglishName AS EnglishName FROM Employees  WHERE  TenantID = 1 AND   TenantID = @val0 AND Code LIKE @val1  ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow
10:55:44 - IsConnectionValid True
10:55:45 - IsConnectionValid True
10:55:45 - (3-hr-0010001) : Subquery returned more than 1 value. This is not permitted when the subquery follows =, !=, <, <= , >, >= or when the subquery is used as an expression.
10:57:20 - IsConnectionValid True
10:57:29 - IsConnectionValid True
10:57:29 - SELECT  DISTINCT COUNT(*) AS DayCount FROM HRMS_vwVacTransType WHERE TenantID = 1 AND   TenantID = @val0 AND IsOverTime = @val1  Query
10:57:41 - IsConnectionValid True
10:57:41 - 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, EnglishName AS EnglishName FROM Employees  WHERE  TenantID = 1 AND   TenantID = @val0  ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow
10:57:45 - IsConnectionValid True
10:57:45 - 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, EnglishName AS EnglishName FROM Employees  WHERE  TenantID = 1 AND   TenantID = @val0 AND Code LIKE @val1  ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow
10:57:47 - IsConnectionValid True
10:57:47 - IsConnectionValid True
10:58:01 - IsConnectionValid True
10:58:01 - IsConnectionValid True
10:58:15 - IsConnectionValid True
10:58:15 - IsConnectionValid True
10:58:15 - (3-hr-0010001) : Subquery returned more than 1 value. This is not permitted when the subquery follows =, !=, <, <= , >, >= or when the subquery is used as an expression.
10:59:15 - IsConnectionValid True
10:59:15 - IsConnectionValid True
10:59:27 - IsConnectionValid True
10:59:28 - IsConnectionValid True
10:59:28 - (3-hr-0010001) : Subquery returned more than 1 value. This is not permitted when the subquery follows =, !=, <, <= , >, >= or when the subquery is used as an expression.
11:00:04 - IsConnectionValid True
11:00:11 - IsConnectionValid True
11:00:11 - SELECT  DISTINCT COUNT(*) AS DayCount FROM HRMS_vwVacTransType WHERE TenantID = 1 AND   TenantID = @val0 AND IsOverTime = @val1  Query
11:00:19 - IsConnectionValid True
11:00:19 - 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, EnglishName AS EnglishName FROM Employees  WHERE  TenantID = 1 AND   TenantID = @val0  ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow
11:00:22 - IsConnectionValid True
11:00:22 - 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, EnglishName AS EnglishName FROM Employees  WHERE  TenantID = 1 AND   TenantID = @val0 AND Code LIKE @val1  ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow
11:00:24 - IsConnectionValid True
11:00:25 - IsConnectionValid True
11:00:41 - IsConnectionValid True
11:00:42 - IsConnectionValid True
11:00:58 - IsConnectionValid True
11:00:59 - IsConnectionValid True
11:01:00 - (3-hr-0010001) : Subquery returned more than 1 value. This is not permitted when the subquery follows =, !=, <, <= , >, >= or when the subquery is used as an expression.
11:01:01 - IsConnectionValid True
11:01:02 - IsConnectionValid True
11:01:02 - (3-hr-0010001) : Subquery returned more than 1 value. This is not permitted when the subquery follows =, !=, <, <= , >, >= or when the subquery is used as an expression.
11:15:24 - IsConnectionValid True
11:15:26 - IsConnectionValid True
11:15:35 - IsConnectionValid True
11:15:44 - IsConnectionValid True
11:15:44 - IsConnectionValid True
11:16:00 - IsConnectionValid True
11:22:05 - IsConnectionValid True
11:22:14 - IsConnectionValid True
11:22:14 - SELECT  DISTINCT COUNT(*) AS DayCount FROM HRMS_vwVacTransType WHERE TenantID = 1 AND   TenantID = @val0 AND IsOverTime = @val1  Query
11:22:28 - IsConnectionValid True
11:22:29 - IsConnectionValid True
11:22:45 - IsConnectionValid True
11:22:45 - 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, EnglishName AS EnglishName FROM Employees  WHERE  TenantID = 1 AND   TenantID = @val0  ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow
11:22:49 - IsConnectionValid True
11:22:49 - 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, EnglishName AS EnglishName FROM Employees  WHERE  TenantID = 1 AND   TenantID = @val0 AND Code LIKE @val1  ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow
11:22:51 - IsConnectionValid True
11:22:51 - IsConnectionValid True
11:23:00 - IsConnectionValid True
11:23:00 - (2-payroll-0010017) : Subquery returned more than 1 value. This is not permitted when the subquery follows =, !=, <, <= , >, >= or when the subquery is used as an expression.
11:40:24 - IsConnectionValid True
11:40:25 - IsConnectionValid True
11:40:50 - IsConnectionValid True
11:40:50 - IsConnectionValid True
11:40:50 - SELECT  DISTINCT * FROM VwTransactionToUpdate WHERE  TenantID = @val0 AND CAST(TransactionDate AS Date) >= @val1 AND CAST(cast((cast(Month(TransactionDate) as varchar(10)) + '/' + cast(Day(TransactionDate) as varchar(10))+ '/' + cast(Year(TransactionDate) as varchar(10))) as DateTime) AS Date) <= @val2 AND CAST(DATELEFT AS Date) = @val3 AND UserID = @val4 AND EmployeeCode >= @val5 AND EmployeeCode <= @val6 AND TransactionUserID = @val7 AND IsNotManualEntry = @val8 AND IsReserve = @val9 AND Loans = @val10 AND IsInsurance = @val11 AND (Posted <>1 OR (Posted=1 AND IsSALARYDETAILS=1) or (PostedBeforeThisCalc = 0 and 0=1)) AND (Reccuring =1 OR ((Reccuring=99 or Reccuring=2) And TransactionDate>(select max(CloseDate) From CloseMonth where TenantID=1))) AND (ProjectID =0 OR 0=0) AND (DepartmentID =0 OR 0=0) AND (SectionID =0 OR 0=0) AND (TransactionID =0 OR 0=0) AND (Amount =0 OR 0=0) ORDER BY Code  Query
11:40:50 - IsConnectionValid True
11:41:12 - IsConnectionValid True
11:41:13 - IsConnectionValid True
11:41:24 - IsConnectionValid True
11:41:25 - IsConnectionValid True
11:41:54 - IsConnectionValid True
11:42:01 - IsConnectionValid True
11:42:06 - IsConnectionValid True
11:42:07 - IsConnectionValid True
11:42:42 - IsConnectionValid True
11:42:51 - IsConnectionValid True
11:42:51 - SELECT ID AS ID, Code AS Code, Name AS Name, EnglishName AS EnglishName, JobID AS JobID, JobCode AS JobCode, JobName AS JobName, JobEName AS JobEName, DateBegin AS DateBegin, WorkHours AS WorkHours, HourStartWork AS HourStartWork, Relegion AS Relegion, PilgrimageVacation AS PilgrimageVacation, ProjectID AS ProjectID, DepartmentID AS DepartmentID, SectionID AS SectionID, DateLeft AS DateLeft, DateLeftTemp AS DateLeftTemp, EmpSulfAcc AS EmpSulfAcc, EmpCreditAcc AS EmpCreditAcc, CASE WHEN DateLeftTemp<>'01/01/1900' THEN 1 ELSE 0  END AS Resigned, TotalSal AS BasicSalary FROM HRMS_vwEmployees WHERE  UserID = @val0 and TenantID = @val1 AND (CASE WHEN DateLeftTemp<>'01/01/1900' THEN 2 ELSE CASE WHEN DateLeftTemp='01/01/1900' then  1 else 0 END  END LIKE '%1%') ORDER BY ID ASC  Query
11:42:52 - IsConnectionValid True
11:42: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, EnglishName AS EnglishName, JobID AS JobID, JobCode AS JobCode, JobName AS JobName, JobEName AS JobEName, DateBegin AS DateBegin, WorkHours AS WorkHours, HourStartWork AS HourStartWork, Relegion AS Relegion, PilgrimageVacation AS PilgrimageVacation, ProjectID AS ProjectID, DepartmentID AS DepartmentID, SectionID AS SectionID, DateLeft AS DateLeft, DateLeftTemp AS DateLeftTemp, EmpSulfAcc AS EmpSulfAcc, EmpCreditAcc AS EmpCreditAcc, CASE WHEN DateLeftTemp<>'01/01/1900' THEN 1 ELSE 0  END AS Resigned, TotalSal AS BasicSalary FROM HRMS_vwEmployees  WHERE  TenantID = 1 AND   UserID = @val0 and TenantID = @val1 AND CASE WHEN DateLeftTemp<>'01/01/1900' THEN 2 ELSE CASE WHEN DateLeftTemp='01/01/1900' then  1 else 0 END  END LIKE @val2  ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow
11:42:57 - IsConnectionValid True
11:42:57 - 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, EnglishName AS EnglishName, JobID AS JobID, JobCode AS JobCode, JobName AS JobName, JobEName AS JobEName, DateBegin AS DateBegin, WorkHours AS WorkHours, HourStartWork AS HourStartWork, Relegion AS Relegion, PilgrimageVacation AS PilgrimageVacation, ProjectID AS ProjectID, DepartmentID AS DepartmentID, SectionID AS SectionID, DateLeft AS DateLeft, DateLeftTemp AS DateLeftTemp, EmpSulfAcc AS EmpSulfAcc, EmpCreditAcc AS EmpCreditAcc, CASE WHEN DateLeftTemp<>'01/01/1900' THEN 1 ELSE 0  END AS Resigned, TotalSal AS BasicSalary FROM HRMS_vwEmployees  WHERE  TenantID = 1 AND   UserID = @val0 and TenantID = @val1 AND Code LIKE @val2 AND CASE WHEN DateLeftTemp<>'01/01/1900' THEN 2 ELSE CASE WHEN DateLeftTemp='01/01/1900' then  1 else 0 END  END LIKE @val3  ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow
11:43:13 - IsConnectionValid True
11:43:13 - finalQuery  ;WITH CTE AS (SELECT  ROW_NUMBER() OVER ( ORDER BY ID ASC) AS rn, COUNT(*) OVER() AS _total, * FROM (SELECT  DISTINCT * FROM VwTransactionsWithSecurity  WHERE   UserID = @val0 AND TenantID = @val1 AND IsNotManualEntry = @val2 AND IsReserve = @val3 AND Loans = @val4 AND IsInsurance = @val5  AND ID NOT IN(SELECT  TransactionTypeID FROM VacationTypes)  AND Sign = @val7 AND IsReturnEffect = @val8 AND IsSalaryDetails = @val9  ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow
11:43:23 - IsConnectionValid True
11:43:23 - (3-hr-0010001) : Error converting data type varchar to numeric.
11:43:23 - IsConnectionValid True
11:43:24 - IsConnectionValid True
11:43:24 - IsConnectionValid True
11:43:24 - IsConnectionValid True
11:43:57 - IsConnectionValid True
11:43:58 - IsConnectionValid True
11:44:02 - IsConnectionValid True
11:44:02 - IsConnectionValid True
11:44:03 - IsConnectionValid True
11:44:03 - IsConnectionValid True
11:56:02 - IsConnectionValid True
11:56:12 - IsConnectionValid True
11:56:12 - SELECT  DISTINCT COUNT(*) AS DayCount FROM HRMS_vwVacTransType WHERE TenantID = 1 AND   TenantID = @val0 AND IsOverTime = @val1  Query
11:56:20 - IsConnectionValid True
11:56:20 - 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, EnglishName AS EnglishName FROM Employees  WHERE  TenantID = 1 AND   TenantID = @val0  ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow
11:56:24 - IsConnectionValid True
11:56:24 - 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, EnglishName AS EnglishName FROM Employees  WHERE  TenantID = 1 AND   TenantID = @val0 AND Code LIKE @val1  ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow
11:56:25 - IsConnectionValid True
12:15:14 - IsConnectionValid True
12:15:15 - IsConnectionValid True
12:15:16 - IsConnectionValid True
12:15:16 - IsConnectionValid True
12:15:23 - IsConnectionValid True
12:15:31 - IsConnectionValid True
12:15:31 - SELECT  DISTINCT COUNT(*) AS DayCount FROM HRMS_vwVacTransType WHERE TenantID = 1 AND   TenantID = @val0 AND IsOverTime = @val1  Query
12:15:43 - IsConnectionValid True
12:15:43 - 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, EnglishName AS EnglishName FROM Employees  WHERE  TenantID = 1 AND   TenantID = @val0  ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow
12:15:46 - IsConnectionValid True
12:15:46 - 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, EnglishName AS EnglishName FROM Employees  WHERE  TenantID = 1 AND   TenantID = @val0 AND Code LIKE @val1  ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow
12:15:48 - IsConnectionValid True
12:15:49 - IsConnectionValid True
12:19:55 - IsConnectionValid True
12:20:01 - IsConnectionValid True
13:52:26 - IsConnectionValid True