10:47:59 - IsConnectionValid True
10:48:00 - IsConnectionValid True
10:48:03 - IsConnectionValid True
10:48:13 - IsConnectionValid True
10:48:13 - SELECT  DISTINCT ID AS ID, MonthCode AS Code, MonthName AS Name FROM CalculationPeriods WHERE TenantID = 1 AND   TenantID = @val0 ORDER BY ID  Query
10:48:15 - IsConnectionValid True
10:48:22 - IsConnectionValid True
10:48:23 - IsConnectionValid True
10:48:23 - SELECT  DISTINCT ID AS ID, MonthCode AS Code, MonthName AS Name FROM CalculationPeriods WHERE TenantID = 1 AND   TenantID = @val0 ORDER BY ID  Query
10:48:25 - IsConnectionValid True
10:48:27 - IsConnectionValid True
10:48:29 - IsConnectionValid True
10:48:32 - IsConnectionValid True
10:48:34 - IsConnectionValid True
10:48:34 - IsConnectionValid True
10:48:34 - IsConnectionValid True
10:48:34 - SELECT  DISTINCT * FROM VwLoansEntry WHERE TenantID = 1 AND   TenantID = @val0 AND EmployeeID = @val1 AND UserID = @val2  Query
10:48:34 - SELECT  DISTINCT * FROM HRMS_vwEmployees WHERE TenantID = 1 AND   TenantID = @val0 and CAST(DateLeft AS Date) = @val1 and UserID = @val2 ORDER BY ID  Query
10:48:34 - SELECT  DISTINCT * FROM VwLoans WHERE TenantID = 1 AND   TenantID = @val0 ORDER BY ID  Query
10:48:36 - IsConnectionValid True
10:48:39 - IsConnectionValid True
10:48:42 - IsConnectionValid True
10:48:46 - IsConnectionValid True
11:14:57 - IsConnectionValid True
11:14:57 - IsConnectionValid True
11:14:59 - IsConnectionValid True
11:15:00 - IsConnectionValid True
11:15:00 - SELECT * FROM SysAlerts WHERE TenantID=@TenantID AND Active = 1 Query NEW -______- 1
11:15:00 - Select COUNT(ID) AS TotalNum FROM Employees WHERE ( DATEDIFF(DAY,GETDATE(),EndContractDate)<=30 AND DATEDIFF(DAY,GETDATE(),EndContractDate)>0)  COUNT Query 0
11:15:00 - SELECT COUNT(ID) AS TotalNum 
									FROM VwEmpDocAlerts
									WHERE DocTypeID=1 AND  
									( DATEDIFF(DAY,GETDATE(),ToDate)<=21 AND 
									DATEDIFF(DAY,GETDATE(),ToDate)>0) COUNT Query 0
11:15:00 - Select COUNT(E.ID) AS TotalNum from Employees E INNER JOIN EmploymentTypes ET ON E.EmploymentType=ET.ID WHERE ((( DATEDIFF(DAY,DateBegin ,GETDATE()))-6)/30 )>=6 and et.IsShowInAlert=1 and ISNULL(IsthirdOrFour,0)=0 COUNT Query 0
11:15:00 - SELECT  COUNT(ID) as count from Employees WHERE DateLeft='01/01/1900' AND MONTH(BirthDate)=MONTH(GETDATE())  COUNT Query 17
11:15:00 - SELECT  COUNT(ID) as count from Employees WHERE DateLeft='01/01/1900' AND (DATEDIFF(day,DateBegin,GETDATE()) +1)<=90 AND (90 - (DATEDIFF(day,DateBegin,GETDATE()) +1))<=(SELECT RemainBeforeFinishTrainingPeriod FROM SysParam) COUNT Query 0
11:15:00 - SELECT  COUNT(ID) as count from Employees WHERE DateLeft='01/01/1900' AND MONTH(EndContractDate)=MONTH(GETDATE()) AND YEAR(EndContractDate)=YEAR(GETDATE())  COUNT Query 0
11:15:00 - SELECT COUNT(*)FROM (SELECT Gender,CODE,ID,Name,cASE when ISNULL(NewSocSecDate,'01/01/1900')<>'01/01/1900' AND ISNULL(NewSocSecDate,'')<>'' then DATEADD(DAY, (DATEDIFF(DAY, GETDATE(),NewSocSecDate)), BirthDate)ELSE BirthDate END COMPAREDATE FROM Employees where IsSocialSec = 1 AND DateLeft='01/01/1900') D WHERE Abs((DateDiff(DAY, (COMPAREDATE), GETDATE()) / 365)) > CASE WHEN Gender =1 THEN (SELECT FemaleSocStopY FROM SysParam) ELSE (SELECT MaleSocStopY FROM SysParam) END COUNT Query 0
11:15:00 - IsConnectionValid True
11:17:01 - IsConnectionValid True
11:17:02 - IsConnectionValid True
11:17:50 - IsConnectionValid True
11:17:51 - IsConnectionValid True
11:20:07 - IsConnectionValid True
15:20:52 - IsConnectionValid True
15:21:40 - IsConnectionValid True
15:21:49 - IsConnectionValid True
15:22:49 - IsConnectionValid True
15:22:56 - IsConnectionValid True
15:23:27 - IsConnectionValid True
15:23:34 - IsConnectionValid True
15:23:34 - (2-payroll-0010188) : Input string was not in a correct format.
15:24:46 - IsConnectionValid True