09:38:19 - IsConnectionValid True 09:38:20 - IsConnectionValid True 09:38:21 - IsConnectionValid True 09:38:28 - IsConnectionValid True 09:38:28 - IsConnectionValid True 09:38:32 - IsConnectionValid True 09:38:38 - IsConnectionValid True 09:38:40 - IsConnectionValid True 09:39:14 - IsConnectionValid True 09:39:15 - IsConnectionValid True 09:39:51 - IsConnectionValid True 09:39:52 - IsConnectionValid True 09:40:30 - IsConnectionValid True 09:40:31 - IsConnectionValid True 09:40:53 - IsConnectionValid True 09:40:54 - IsConnectionValid True 09:41:38 - IsConnectionValid True 09:41:39 - IsConnectionValid True 09:42:47 - IsConnectionValid True 09:42:48 - IsConnectionValid True 09:42:50 - IsConnectionValid True 09:48:29 - IsConnectionValid True 09:48:31 - IsConnectionValid True 09:48:33 - IsConnectionValid True 09:49:13 - IsConnectionValid True 09:49:14 - IsConnectionValid True 09:49:15 - IsConnectionValid True 09:49:28 - IsConnectionValid True 09:49:29 - IsConnectionValid True 09:49:30 - IsConnectionValid True 09:49:43 - IsConnectionValid True 09:49:44 - IsConnectionValid True 09:49:45 - IsConnectionValid True 09:53:51 - IsConnectionValid True 09:53:52 - IsConnectionValid True 09:53:56 - IsConnectionValid True 09:57:16 - IsConnectionValid True 09:57:17 - IsConnectionValid True 09:57:18 - IsConnectionValid True 09:58:15 - IsConnectionValid True 09:58:17 - IsConnectionValid True 09:58:19 - IsConnectionValid True 10:02:29 - IsConnectionValid True 10:02:31 - IsConnectionValid True 10:02:35 - IsConnectionValid True 10:03:27 - IsConnectionValid True 10:03:28 - IsConnectionValid True 10:03:30 - IsConnectionValid True 10:03:55 - IsConnectionValid True 10:03:56 - IsConnectionValid True 10:03:57 - IsConnectionValid True 10:04:11 - IsConnectionValid True 10:04:12 - IsConnectionValid True 10:04:16 - IsConnectionValid True 10:04:17 - IsConnectionValid True 10:04:19 - IsConnectionValid True 10:04:59 - IsConnectionValid True 10:05:00 - IsConnectionValid True 10:05:02 - IsConnectionValid True 10:05:24 - IsConnectionValid True 10:05:25 - IsConnectionValid True 10:05:26 - IsConnectionValid True 10:06:12 - IsConnectionValid True 10:06:13 - IsConnectionValid True 10:06:14 - IsConnectionValid True 10:06:28 - IsConnectionValid True 10:06:30 - IsConnectionValid True 10:06:32 - IsConnectionValid True 10:07:04 - IsConnectionValid True 10:07:06 - IsConnectionValid True 10:07:07 - IsConnectionValid True 10:16:15 - IsConnectionValid True 10:16:16 - IsConnectionValid True 10:16:19 - IsConnectionValid True 10:18:00 - IsConnectionValid True 10:18:02 - IsConnectionValid True 10:18:03 - IsConnectionValid True 10:23:11 - IsConnectionValid True 10:23:12 - IsConnectionValid True 10:23:13 - IsConnectionValid True 10:26:22 - IsConnectionValid True 10:26:23 - IsConnectionValid True 10:26:24 - IsConnectionValid True 10:27:11 - IsConnectionValid True 10:27:12 - IsConnectionValid True 10:27:14 - IsConnectionValid True 10:30:05 - IsConnectionValid True 10:30:07 - IsConnectionValid True 10:30:08 - IsConnectionValid True 10:30:16 - IsConnectionValid True 10:30:16 - IsConnectionValid True 10:30:16 - IsConnectionValid True 10:30:16 - IsConnectionValid True 10:30:16 - SELECT DISTINCT * FROM Jobs WHERE TenantID =1 ORDER BY ID Query 10:30:16 - SELECT DISTINCT * FROM Projects WHERE TenantID =1 and ID = @val1 Query 10:30:16 - SELECT * FROM EmpWifeInfo WHERE TenantID =1 and EmpId = @val1 ORDER BY Code Query 10:30:17 - IsConnectionValid True 10:30:17 - IsConnectionValid True 10:30:17 - IsConnectionValid True 10:30:17 - SELECT DISTINCT * FROM Nation WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 10:30:17 - IsConnectionValid True 10:30:17 - IsConnectionValid True 10:30:17 - SELECT DISTINCT * FROM PlaceOfBirth WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 10:30:17 - IsConnectionValid True 10:30:17 - SELECT DISTINCT * FROM BloodTypes WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 10:30:17 - SELECT * FROM vwEmployeeLanguages WHERE TenantID =1 and EmployeeID = @val1 Query 10:30:17 - SELECT DISTINCT * FROM EmployeeEducation WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 10:30:17 - IsConnectionValid True 10:30:17 - IsConnectionValid True 10:30:17 - SELECT DISTINCT * FROM EducationCity WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 10:30:17 - IsConnectionValid True 10:30:17 - SELECT DISTINCT * FROM Conservatism WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 10:30:17 - SELECT DISTINCT * FROM Countries WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 10:30:17 - IsConnectionValid True 10:30:17 - SELECT DISTINCT * FROM EmploymentTypes WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 10:30:17 - IsConnectionValid True 10:30:17 - IsConnectionValid True 10:30:17 - IsConnectionValid True 10:30:17 - SELECT DISTINCT * FROM OriginalCountry WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 10:30:17 - IsConnectionValid True 10:30:17 - SELECT DISTINCT * FROM JobType WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 10:30:17 - SELECT DISTINCT * FROM HRMS_vwEmployees WHERE TenantID =1 and IsManager = @val1 and UserID = @val2 and CAST(DateLeft AS Date) = @val3 ORDER BY ID Query 10:30:17 - IsConnectionValid True 10:30:17 - IsConnectionValid True 10:30:17 - SELECT DISTINCT * FROM Subjects WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 10:30:17 - SELECT DISTINCT * FROM JobDegree WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 10:30:17 - SELECT DISTINCT * FROM TransportCompanyDef WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 10:30:17 - SELECT DISTINCT * FROM TranspLineDef WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 10:30:17 - IsConnectionValid True 10:30:17 - IsConnectionValid True 10:30:17 - SELECT DISTINCT * FROM VwEmpEducations WHERE TenantID =1 and EmployeeID = @val1 and UserID = @val2 ORDER BY ID Query 10:30:17 - IsConnectionValid True 10:30:17 - SELECT * FROM VwEmpExperience WHERE TenantID =1 and EmployeeID = @val1 and ExperienceType = @val2 ORDER BY ID Query 10:30:17 - SELECT DISTINCT * FROM PaymentTypes WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 10:30:17 - SELECT * FROM VwEmpExperience WHERE TenantID =1 and EmployeeID = @val1 and ExperienceType = @val2 ORDER BY ID Query 10:30:17 - SELECT DISTINCT * FROM Banks WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 10:30:17 - IsConnectionValid True 10:30:17 - SELECT * FROM vwEmpDocumentDet WHERE TenantID =1 and EmpID = @val1 ORDER BY ID Query 10:30:17 - IsConnectionValid True 10:30:17 - SELECT LocationDef.ID AS ID, Name AS Name, EmpID AS EmpID, LocationID AS LocationID, IsLocation AS IsLocation FROM LocationDef LEFT OUTER JOIN EmpAccessLocation ON LocationDef.TenantID = EmpAccessLocation.TenantID AND LocationDef.ID = EmpAccessLocation.LocationID AND EmpAccessLocation.EmpID = 0 WHERE LocationDef.TenantID =1 Query 10:30:17 - IsConnectionValid True 10:30:17 - SELECT EmpCustodyItems.ID AS ID, EmpCustodyItems.EmpID AS EmpID, EmpCustodyItems.ItemID AS ItemID, CustodyItemsDef.ID AS CustodyID, CustodyItemsDef.Code AS Code, CustodyItemsDef.Name AS Name, EmpCustodyItems.Qty AS Qty, EmpCustodyItems.Description AS Description, EmpCustodyItems.StartDate AS StartDate, EmpCustodyItems.EndDate AS EndDate, 0 AS IsCustody FROM EmpCustodyItems RIGHT OUTER JOIN CustodyItemsDef ON dbo.EmpCustodyItems.ItemID = dbo.CustodyItemsDef.ID AND EmpCustodyItems.EmpID = 0 WHERE CustodyItemsDef.TenantID =1 Query 10:30:18 - IsConnectionValid True 10:30:18 - IsConnectionValid True 10:30:18 - IsConnectionValid True 10:30:18 - SELECT DISTINCT Emp.EmpID AS EmpID, Emp.ID AS ID, Emp.Path AS Path, Emp.FileName AS FileName, Emp.ExtensionsID AS ExtensionsID, E.Name AS ExtensionsName, E.Name AS ExtensionsName FROM EmpAttachment AS Emp LEFT OUTER JOIN Extensions AS E ON Emp.ExtensionsID = E.ID AND Emp.TenantID = E.TenantID WHERE Emp.TenantID =1 AND Emp.EmpID =0 Query 10:30:18 - IsConnectionValid True 10:30:18 - SELECT * FROM vwCoursesEntryDetails WHERE TenantID =1 AND EmpID = @val1 AND UserID = @val2 Query 10:30:18 - SELECT * FROM vwThanksBooksEntry WHERE TenantID =1 AND EmpID = @val1 AND UserID = @val2 Query 10:30:18 - IsConnectionValid True 10:30:18 - IsConnectionValid True 10:30:18 - SELECT * FROM vwInjuryEntry WHERE TenantID =1 AND EmpID = @val1 AND UserID = @val2 Query 10:30:18 - SELECT * FROM vwWarningEntry WHERE TenantID =1 AND EmpID = @val1 AND UserID = @val2 Query 10:32:39 - IsConnectionValid True 10:33:03 - IsConnectionValid True 10:33:36 - IsConnectionValid True 10:33:37 - IsConnectionValid True 10:33:38 - IsConnectionValid True 10:34:08 - IsConnectionValid True 10:34:09 - IsConnectionValid True 10:34:11 - IsConnectionValid True 10:34:29 - IsConnectionValid True 10:34:30 - IsConnectionValid True 10:34:32 - IsConnectionValid True 10:34:49 - IsConnectionValid True 10:34:50 - IsConnectionValid True 10:34:52 - IsConnectionValid True 10:35:42 - IsConnectionValid True 10:35:43 - IsConnectionValid True 10:35:44 - IsConnectionValid True 10:36:06 - IsConnectionValid True 10:36:07 - IsConnectionValid True 10:36:09 - IsConnectionValid True 10:36:42 - IsConnectionValid True 10:36:43 - IsConnectionValid True 10:36:45 - IsConnectionValid True 10:59:59 - IsConnectionValid True 11:00:02 - IsConnectionValid True 11:00:24 - IsConnectionValid True 11:00:24 - IsConnectionValid True 11:00:24 - IsConnectionValid True 11:00:24 - SELECT DISTINCT * FROM Jobs WHERE TenantID =1 ORDER BY ID Query 11:00:24 - SELECT DISTINCT * FROM Projects WHERE TenantID =1 and ID = @val1 Query 11:00:24 - SELECT * FROM EmpWifeInfo WHERE TenantID =1 and EmpId = @val1 ORDER BY Code Query 11:00:24 - IsConnectionValid True 11:00:24 - IsConnectionValid True 11:00:24 - IsConnectionValid True 11:00:24 - IsConnectionValid True 11:00:24 - IsConnectionValid True 11:00:24 - SELECT DISTINCT * FROM Nation WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 11:00:24 - SELECT DISTINCT * FROM BloodTypes WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 11:00:24 - IsConnectionValid True 11:00:24 - SELECT DISTINCT * FROM OriginalCountry WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 11:00:24 - SELECT * FROM vwEmployeeLanguages WHERE TenantID =1 and EmployeeID = @val1 Query 11:00:24 - SELECT DISTINCT * FROM EmployeeEducation WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 11:00:24 - IsConnectionValid True 11:00:24 - IsConnectionValid True 11:00:24 - SELECT DISTINCT * FROM EducationCity WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 11:00:24 - IsConnectionValid True 11:00:24 - IsConnectionValid True 11:00:24 - SELECT DISTINCT * FROM EmploymentTypes WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 11:00:24 - SELECT DISTINCT * FROM Conservatism WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 11:00:24 - SELECT DISTINCT * FROM JobType WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 11:00:24 - SELECT DISTINCT * FROM Countries WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 11:00:24 - IsConnectionValid True 11:00:24 - IsConnectionValid True 11:00:24 - IsConnectionValid True 11:00:24 - SELECT DISTINCT * FROM HRMS_vwEmployees WHERE TenantID =1 and IsManager = @val1 and UserID = @val2 and CAST(DateLeft AS Date) = @val3 ORDER BY ID Query 11:00:24 - SELECT DISTINCT * FROM Subjects WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 11:00:24 - IsConnectionValid True 11:00:24 - IsConnectionValid True 11:00:24 - SELECT DISTINCT * FROM JobDegree WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 11:00:24 - IsConnectionValid True 11:00:24 - SELECT DISTINCT * FROM TranspLineDef WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 11:00:24 - SELECT DISTINCT * FROM VwEmpEducations WHERE TenantID =1 and EmployeeID = @val1 and UserID = @val2 ORDER BY ID Query 11:00:24 - SELECT DISTINCT * FROM TransportCompanyDef WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 11:00:24 - IsConnectionValid True 11:00:24 - IsConnectionValid True 11:00:24 - SELECT * FROM VwEmpExperience WHERE TenantID =1 and EmployeeID = @val1 and ExperienceType = @val2 ORDER BY ID Query 11:00:24 - IsConnectionValid True 11:00:24 - SELECT * FROM VwEmpExperience WHERE TenantID =1 and EmployeeID = @val1 and ExperienceType = @val2 ORDER BY ID Query 11:00:24 - SELECT DISTINCT * FROM PaymentTypes WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 11:00:25 - IsConnectionValid True 11:00:25 - SELECT DISTINCT * FROM Banks WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 11:00:25 - IsConnectionValid True 11:00:25 - SELECT * FROM vwEmpDocumentDet WHERE TenantID =1 and EmpID = @val1 ORDER BY ID Query 11:00:25 - IsConnectionValid True 11:00:25 - IsConnectionValid True 11:00:25 - SELECT LocationDef.ID AS ID, Name AS Name, EmpID AS EmpID, LocationID AS LocationID, IsLocation AS IsLocation FROM LocationDef LEFT OUTER JOIN EmpAccessLocation ON LocationDef.TenantID = EmpAccessLocation.TenantID AND LocationDef.ID = EmpAccessLocation.LocationID AND EmpAccessLocation.EmpID = 0 WHERE LocationDef.TenantID =1 Query 11:00:25 - IsConnectionValid True 11:00:25 - SELECT EmpCustodyItems.ID AS ID, EmpCustodyItems.EmpID AS EmpID, EmpCustodyItems.ItemID AS ItemID, CustodyItemsDef.ID AS CustodyID, CustodyItemsDef.Code AS Code, CustodyItemsDef.Name AS Name, EmpCustodyItems.Qty AS Qty, EmpCustodyItems.Description AS Description, EmpCustodyItems.StartDate AS StartDate, EmpCustodyItems.EndDate AS EndDate, 0 AS IsCustody FROM EmpCustodyItems RIGHT OUTER JOIN CustodyItemsDef ON dbo.EmpCustodyItems.ItemID = dbo.CustodyItemsDef.ID AND EmpCustodyItems.EmpID = 0 WHERE CustodyItemsDef.TenantID =1 Query 11:00:25 - IsConnectionValid True 11:00:25 - SELECT DISTINCT Emp.EmpID AS EmpID, Emp.ID AS ID, Emp.Path AS Path, Emp.FileName AS FileName, Emp.ExtensionsID AS ExtensionsID, E.Name AS ExtensionsName, E.Name AS ExtensionsName FROM EmpAttachment AS Emp LEFT OUTER JOIN Extensions AS E ON Emp.ExtensionsID = E.ID AND Emp.TenantID = E.TenantID WHERE Emp.TenantID =1 AND Emp.EmpID =0 Query 11:00:25 - IsConnectionValid True 11:00:25 - IsConnectionValid True 11:00:25 - SELECT * FROM vwCoursesEntryDetails WHERE TenantID =1 AND EmpID = @val1 AND UserID = @val2 Query 11:00:25 - SELECT * FROM vwThanksBooksEntry WHERE TenantID =1 AND EmpID = @val1 AND UserID = @val2 Query 11:00:25 - IsConnectionValid True 11:00:25 - SELECT * FROM vwWarningEntry WHERE TenantID =1 AND EmpID = @val1 AND UserID = @val2 Query 11:00:25 - IsConnectionValid True 11:00:25 - SELECT * FROM vwInjuryEntry WHERE TenantID =1 AND EmpID = @val1 AND UserID = @val2 Query 11:01:33 - IsConnectionValid True 11:01:35 - IsConnectionValid True 11:01:35 - IsConnectionValid True 11:01:35 - IsConnectionValid True 11:01:35 - IsConnectionValid True 11:01:35 - SELECT DISTINCT * FROM Projects WHERE TenantID =1 and ID = @val1 Query 11:01:35 - SELECT * FROM EmpWifeInfo WHERE TenantID =1 and EmpId = @val1 ORDER BY Code Query 11:01:36 - IsConnectionValid True 11:01:36 - IsConnectionValid True 11:01:36 - IsConnectionValid True 11:01:36 - SELECT DISTINCT * FROM BloodTypes WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 11:01:36 - IsConnectionValid True 11:01:36 - IsConnectionValid True 11:01:36 - SELECT DISTINCT * FROM OriginalCountry WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 11:01:36 - SELECT DISTINCT * FROM Nation WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 11:01:36 - SELECT DISTINCT * FROM PlaceOfBirth WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 11:01:36 - SELECT * FROM vwEmployeeLanguages WHERE TenantID =1 and EmployeeID = @val1 Query 11:01:36 - IsConnectionValid True 11:01:36 - SELECT DISTINCT * FROM EmployeeEducation WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 11:01:36 - IsConnectionValid True 11:01:36 - IsConnectionValid True 11:01:36 - IsConnectionValid True 11:01:36 - SELECT DISTINCT * FROM EducationCity WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 11:01:36 - SELECT DISTINCT * FROM Countries WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 11:01:36 - IsConnectionValid True 11:01:36 - SELECT DISTINCT * FROM Conservatism WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 11:01:36 - IsConnectionValid True 11:01:36 - SELECT DISTINCT * FROM JobType WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 11:01:36 - SELECT DISTINCT * FROM EmploymentTypes WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 11:01:36 - IsConnectionValid True 11:01:36 - SELECT DISTINCT * FROM HRMS_vwEmployees WHERE TenantID =1 and IsManager = @val1 and UserID = @val2 and CAST(DateLeft AS Date) = @val3 ORDER BY ID Query 11:01:36 - IsConnectionValid True 11:01:36 - IsConnectionValid True 11:01:36 - IsConnectionValid True 11:01:36 - IsConnectionValid True 11:01:36 - SELECT DISTINCT * FROM Subjects WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 11:01:36 - IsConnectionValid True 11:01:36 - SELECT DISTINCT * FROM TransportCompanyDef WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 11:01:36 - SELECT DISTINCT * FROM TranspLineDef WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 11:01:36 - SELECT DISTINCT * FROM JobDegree WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 11:01:36 - SELECT DISTINCT * FROM VwEmpEducations WHERE TenantID =1 and EmployeeID = @val1 and UserID = @val2 ORDER BY ID Query 11:01:36 - IsConnectionValid True 11:01:36 - IsConnectionValid True 11:01:36 - IsConnectionValid True 11:01:36 - SELECT * FROM VwEmpExperience WHERE TenantID =1 and EmployeeID = @val1 and ExperienceType = @val2 ORDER BY ID Query 11:01:36 - SELECT DISTINCT * FROM Banks WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 11:01:36 - SELECT * FROM VwEmpExperience WHERE TenantID =1 and EmployeeID = @val1 and ExperienceType = @val2 ORDER BY ID Query 11:01:36 - IsConnectionValid True 11:01:36 - SELECT DISTINCT * FROM PaymentTypes WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 11:01:37 - IsConnectionValid True 11:01:37 - SELECT * FROM vwEmpDocumentDet WHERE TenantID =1 and EmpID = @val1 ORDER BY ID Query 11:01:37 - IsConnectionValid True 11:01:37 - IsConnectionValid True 11:01:37 - SELECT LocationDef.ID AS ID, Name AS Name, EmpID AS EmpID, LocationID AS LocationID, IsLocation AS IsLocation FROM LocationDef LEFT OUTER JOIN EmpAccessLocation ON LocationDef.TenantID = EmpAccessLocation.TenantID AND LocationDef.ID = EmpAccessLocation.LocationID AND EmpAccessLocation.EmpID = 0 WHERE LocationDef.TenantID =1 Query 11:01:37 - IsConnectionValid True 11:01:37 - IsConnectionValid True 11:01:37 - SELECT EmpCustodyItems.ID AS ID, EmpCustodyItems.EmpID AS EmpID, EmpCustodyItems.ItemID AS ItemID, CustodyItemsDef.ID AS CustodyID, CustodyItemsDef.Code AS Code, CustodyItemsDef.Name AS Name, EmpCustodyItems.Qty AS Qty, EmpCustodyItems.Description AS Description, EmpCustodyItems.StartDate AS StartDate, EmpCustodyItems.EndDate AS EndDate, 0 AS IsCustody FROM EmpCustodyItems RIGHT OUTER JOIN CustodyItemsDef ON dbo.EmpCustodyItems.ItemID = dbo.CustodyItemsDef.ID AND EmpCustodyItems.EmpID = 0 WHERE CustodyItemsDef.TenantID =1 Query 11:01:37 - IsConnectionValid True 11:01:37 - IsConnectionValid True 11:01:37 - SELECT * FROM vwCoursesEntryDetails WHERE TenantID =1 AND EmpID = @val1 AND UserID = @val2 Query 11:01:37 - SELECT DISTINCT Emp.EmpID AS EmpID, Emp.ID AS ID, Emp.Path AS Path, Emp.FileName AS FileName, Emp.ExtensionsID AS ExtensionsID, E.Name AS ExtensionsName, E.Name AS ExtensionsName FROM EmpAttachment AS Emp LEFT OUTER JOIN Extensions AS E ON Emp.ExtensionsID = E.ID AND Emp.TenantID = E.TenantID WHERE Emp.TenantID =1 AND Emp.EmpID =0 Query 11:01:37 - SELECT * FROM vwThanksBooksEntry WHERE TenantID =1 AND EmpID = @val1 AND UserID = @val2 Query 11:01:37 - IsConnectionValid True 11:01:37 - IsConnectionValid True 11:01:37 - SELECT * FROM vwWarningEntry WHERE TenantID =1 AND EmpID = @val1 AND UserID = @val2 Query 11:01:37 - SELECT * FROM vwInjuryEntry WHERE TenantID =1 AND EmpID = @val1 AND UserID = @val2 Query 11:01:43 - IsConnectionValid True 11:01:57 - IsConnectionValid True 11:03:29 - IsConnectionValid True 11:03:32 - IsConnectionValid True 11:06:19 - IsConnectionValid True 11:06:23 - IsConnectionValid True 11:07:11 - IsConnectionValid True 11:07:15 - IsConnectionValid True 11:19:21 - IsConnectionValid True 11:19:36 - IsConnectionValid True 11:20:35 - IsConnectionValid True 11:20:40 - IsConnectionValid True 11:20:56 - IsConnectionValid True 11:21:00 - IsConnectionValid True 11:21:53 - IsConnectionValid True 11:21:56 - IsConnectionValid True 11:22:39 - IsConnectionValid True 11:22:43 - IsConnectionValid True 11:25:12 - IsConnectionValid True 11:25:16 - IsConnectionValid True 11:25:37 - IsConnectionValid True 11:25:39 - IsConnectionValid True 11:26:46 - IsConnectionValid True 11:26:48 - IsConnectionValid True 11:27:27 - IsConnectionValid True 11:27:30 - IsConnectionValid True 11:37:15 - IsConnectionValid True 11:37:36 - IsConnectionValid True 11:37:39 - IsConnectionValid True 11:52:46 - IsConnectionValid True 11:53:32 - IsConnectionValid True 11:53:34 - IsConnectionValid True 11:53:36 - IsConnectionValid True 11:54:33 - IsConnectionValid True 11:55:06 - IsConnectionValid True 11:55:32 - IsConnectionValid True 11:56:21 - IsConnectionValid True 11:56:25 - IsConnectionValid True 11:56:25 - (3-def-00100066) : Error converting data type nvarchar to datetime. 11:56:31 - IsConnectionValid True 11:56:31 - (3-def-00100066) : Error converting data type nvarchar to datetime. 11:56:50 - IsConnectionValid True 11:56:54 - IsConnectionValid True 11:56:54 - (3-def-00100066) : Error converting data type nvarchar to datetime. 11:57:28 - IsConnectionValid True 11:57:58 - IsConnectionValid True 11:58:16 - IsConnectionValid True 11:58:18 - IsConnectionValid True 11:58:20 - IsConnectionValid True 11:59:05 - IsConnectionValid True 12:00:13 - IsConnectionValid True 12:00:16 - IsConnectionValid True 12:00:16 - (3-def-00100066) : Error converting data type nvarchar to datetime. 12:01:09 - IsConnectionValid True 12:01:12 - IsConnectionValid True 12:01:55 - IsConnectionValid True 12:01:59 - IsConnectionValid True 12:28:18 - IsConnectionValid True 12:28:21 - IsConnectionValid True 12:28:54 - IsConnectionValid True 12:29:01 - IsConnectionValid True 12:30:14 - IsConnectionValid True 12:30:15 - IsConnectionValid True 12:30:23 - IsConnectionValid True 12:30:26 - IsConnectionValid True 12:36:10 - IsConnectionValid True 12:36:41 - IsConnectionValid True 12:37:05 - IsConnectionValid True 12:37:11 - IsConnectionValid True 12:37:32 - IsConnectionValid True 12:37:33 - IsConnectionValid True 12:38:10 - IsConnectionValid True 12:39:57 - IsConnectionValid True 12:40:05 - IsConnectionValid True 12:40:44 - IsConnectionValid True 12:41:03 - IsConnectionValid True 12:41:45 - IsConnectionValid True 12:42:06 - IsConnectionValid True 12:43:45 - IsConnectionValid True 12:44:15 - IsConnectionValid True 12:44:31 - IsConnectionValid True 12:56:27 - IsConnectionValid True 12:56:29 - IsConnectionValid True 12:56:29 - SELECT DISTINCT ID AS ID, Code AS Code, Name AS Name FROM Projects WHERE TenantID = 1 AND TenantID = @val0 Query 12:56:29 - IsConnectionValid True 12:56:29 - SELECT DISTINCT ID AS ID, Code AS Code, Name AS Name FROM Projects WHERE TenantID = 1 AND TenantID = @val0 Query 12:56:32 - IsConnectionValid True 12:56:32 - SELECT DISTINCT ID AS ID, Code AS Code, Name AS Name, ProjectID AS ProjectID, ProjectCode AS ProjectCode, ProjectName AS ProjectName FROM vwDepartments WHERE TenantID = @val0 and UserID = @val1 and (ProjectID =2 or 2 =0) ORDER BY Code ASC Query 12:56:32 - IsConnectionValid True 12:56:32 - SELECT DISTINCT ID AS ID, Code AS Code, Name AS Name, ProjectID AS ProjectID, ProjectCode AS ProjectCode, ProjectName AS ProjectName FROM vwDepartments WHERE TenantID = @val0 and UserID = @val1 and (ProjectID =2 or 2 =0) ORDER BY Code ASC Query 12:56:33 - IsConnectionValid True 12:58:14 - IsConnectionValid True 12:58:14 - SELECT DISTINCT ID AS ID, Code AS Code, Name AS Name, ProjectID AS ProjectID, ProjectCode AS ProjectCode, ProjectName AS ProjectName, DepartmentID AS DepartmentID, DepartmentCode AS DepartmentCode, DepartmentName AS DepartmentName FROM VwSections WHERE TenantID = @val0 and UserID = @val1 and (ProjectID =2 or 2 =0) and (DepartmentID =4 or 4 =0) ORDER BY Code ASC Query 12:58:14 - IsConnectionValid True 12:58:14 - SELECT DISTINCT ID AS ID, Code AS Code, Name AS Name, ProjectID AS ProjectID, ProjectCode AS ProjectCode, ProjectName AS ProjectName, DepartmentID AS DepartmentID, DepartmentCode AS DepartmentCode, DepartmentName AS DepartmentName FROM VwSections WHERE TenantID = @val0 and UserID = @val1 and (ProjectID =2 or 2 =0) and (DepartmentID =4 or 4 =0) ORDER BY Code ASC Query 12:58:19 - IsConnectionValid True 12:58:19 - SELECT ID AS ID, Code AS Code, Name AS Name, DepartmentID AS DepartmentID, ProjectID AS ProjectID, SectionID AS SectionID FROM HRMS_vwEmployees WHERE TenantID = @val0 and (ProjectID =2 or 2 =0) and (DepartmentID =4 or 4 =0) and (SectionID =4 or 4 =0) and UserID = @val4 ORDER BY Code ASC Query 12:58:19 - IsConnectionValid True 12:58:19 - SELECT ID AS ID, Code AS Code, Name AS Name, DepartmentID AS DepartmentID, ProjectID AS ProjectID, SectionID AS SectionID FROM HRMS_vwEmployees WHERE TenantID = @val0 and (ProjectID =2 or 2 =0) and (DepartmentID =4 or 4 =0) and (SectionID =4 or 4 =0) and UserID = @val4 ORDER BY Code ASC Query 12:58:23 - IsConnectionValid True 12:58:28 - IsConnectionValid True 13:05:47 - IsConnectionValid True 13:06:02 - IsConnectionValid True 13:46:56 - IsConnectionValid True 13:50:02 - IsConnectionValid True 13:50:04 - IsConnectionValid True 13:50:47 - IsConnectionValid True 13:50:50 - IsConnectionValid True 13:51:51 - IsConnectionValid True 13:51:59 - IsConnectionValid True 13:52:56 - IsConnectionValid True 13:53:00 - IsConnectionValid True 13:53:04 - IsConnectionValid True 13:53:04 - (1-def-0010082) : Conversion failed when converting the varchar value 'true' to data type tinyint. 13:53:49 - IsConnectionValid True 13:53:51 - IsConnectionValid True 13:53:58 - IsConnectionValid True 13:54:02 - IsConnectionValid True 13:54:13 - IsConnectionValid True 13:54:16 - IsConnectionValid True 13:55:03 - IsConnectionValid True 13:55:06 - IsConnectionValid True 13:55:11 - IsConnectionValid True 13:55:33 - IsConnectionValid True 13:55:35 - IsConnectionValid True 13:55:48 - IsConnectionValid True 13:55:48 - SELECT DISTINCT ID AS ID, Code AS Code, Name AS Name FROM Jobs WHERE TenantID = 1 AND TenantID = @val0 Query 13:55:48 - IsConnectionValid True 13:55:48 - SELECT DISTINCT ID AS ID, Code AS Code, Name AS Name FROM Jobs WHERE TenantID = 1 AND TenantID = @val0 Query 13:55:52 - IsConnectionValid True 13:55:52 - SELECT ID AS ID, Code AS Code, Name AS Name, DepartmentID AS DepartmentID, ProjectID AS ProjectID, SectionID AS SectionID FROM HRMS_vwEmployees WHERE TenantID = @val0 and (ProjectID =0 or 0 =0) and (DepartmentID =0 or 0 =0) and (SectionID =0 or 0 =0) and (JobID =0 or 0 =0) and UserID = @val5 ORDER BY Code ASC Query 13:55:53 - IsConnectionValid True 13:55:53 - SELECT ID AS ID, Code AS Code, Name AS Name, DepartmentID AS DepartmentID, ProjectID AS ProjectID, SectionID AS SectionID FROM HRMS_vwEmployees WHERE TenantID = @val0 and (ProjectID =0 or 0 =0) and (DepartmentID =0 or 0 =0) and (SectionID =0 or 0 =0) and (JobID =0 or 0 =0) and UserID = @val5 ORDER BY Code ASC Query 13:55:55 - IsConnectionValid True 13:55:59 - IsConnectionValid True 13:57:17 - IsConnectionValid True 13:57:19 - IsConnectionValid True 14:57:53 - IsConnectionValid True 14:57:57 - IsConnectionValid True 14:57:57 - (3-def-00100066) : EmployeeID 14:58:19 - IsConnectionValid True 14:58:22 - IsConnectionValid True 14:58:30 - IsConnectionValid True 14:58:33 - IsConnectionValid True 14:59:47 - IsConnectionValid True 15:00:38 - IsConnectionValid True 15:00:40 - IsConnectionValid True 15:00:44 - IsConnectionValid True 15:00:46 - IsConnectionValid True 15:00:53 - IsConnectionValid True 15:01:14 - IsConnectionValid True 15:01:23 - IsConnectionValid True 15:01:40 - IsConnectionValid True 15:01:43 - IsConnectionValid True 15:07:37 - IsConnectionValid True 15:12:17 - IsConnectionValid True 15:12:25 - IsConnectionValid True 15:13:43 - IsConnectionValid True 15:14:47 - IsConnectionValid True 15:14:51 - IsConnectionValid True 15:15:43 - IsConnectionValid True 15:16:13 - IsConnectionValid True 15:16:40 - IsConnectionValid True 15:16:44 - IsConnectionValid True 15:16:51 - IsConnectionValid True 15:16:57 - IsConnectionValid True 15:17:02 - IsConnectionValid True