15:55:44 - IsConnectionValid True
15:55:45 - IsConnectionValid True
15:55:45 - IsConnectionValid True
15:55:51 - IsConnectionValid True
15:55:51 - IsConnectionValid True
15:55:56 - IsConnectionValid True
15:55:58 - IsConnectionValid True
15:56:06 - IsConnectionValid True
15:56:06 - (1-ot-000001) : All queries combined using a UNION, INTERSECT or EXCEPT operator must have an equal number of expressions in their target lists.
15:56:16 - IsConnectionValid True
15:56:18 - (1-ot-000001) : All queries combined using a UNION, INTERSECT or EXCEPT operator must have an equal number of expressions in their target lists.
15:56:19 - IsConnectionValid True
15:56:23 - IsConnectionValid True
15:56:48 - IsConnectionValid True
15:56:50 - IsConnectionValid True
15:56:55 - IsConnectionValid True
15:56:57 - IsConnectionValid True
15:57:04 - IsConnectionValid True
15:57:04 - (1-ot-000001) : All queries combined using a UNION, INTERSECT or EXCEPT operator must have an equal number of expressions in their target lists.
15:57:06 - IsConnectionValid True
15:57:06 - (1-ot-000001) : All queries combined using a UNION, INTERSECT or EXCEPT operator must have an equal number of expressions in their target lists.
15:57:06 - IsConnectionValid True
15:57:06 - (1-ot-000001) : All queries combined using a UNION, INTERSECT or EXCEPT operator must have an equal number of expressions in their target lists.
15:57:06 - IsConnectionValid True
15:57:06 - (1-ot-000001) : All queries combined using a UNION, INTERSECT or EXCEPT operator must have an equal number of expressions in their target lists.
15:57:06 - IsConnectionValid True
15:57:06 - (1-ot-000001) : All queries combined using a UNION, INTERSECT or EXCEPT operator must have an equal number of expressions in their target lists.
15:57:06 - IsConnectionValid True
15:57:06 - (1-ot-000001) : All queries combined using a UNION, INTERSECT or EXCEPT operator must have an equal number of expressions in their target lists.
15:57:06 - IsConnectionValid True
15:57:06 - (1-ot-000001) : All queries combined using a UNION, INTERSECT or EXCEPT operator must have an equal number of expressions in their target lists.
15:57:08 - IsConnectionValid True
16:38:33 - IsConnectionValid True
16:38:33 - IsConnectionValid True
16:38:37 - IsConnectionValid True
16:38:39 - IsConnectionValid True
16:38:39 - 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
16:38:39 - IsConnectionValid True
16:38:39 - 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
16:38:43 - IsConnectionValid True
16:38:43 - 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
16:38:55 - IsConnectionValid True
16:39:05 - IsConnectionValid True
16:39:12 - IsConnectionValid True
16:39:17 - IsConnectionValid True
16:39:20 - IsConnectionValid True
16:39:20 - (2-payroll-0010017) : String or binary data would be truncated.
16:39:34 - IsConnectionValid True
16:39:34 - (2-payroll-0010017) : String or binary data would be truncated.