15:07:04 - IsConnectionValid True 15:07:05 - IsConnectionValid True 15:07:05 - IsConnectionValid True 15:07:11 - IsConnectionValid True 15:07:11 - IsConnectionValid True 15:07:15 - IsConnectionValid True 15:07:17 - IsConnectionValid True 15:07:18 - IsConnectionValid True 15:07:42 - IsConnectionValid False 15:07:42 - (1-att-000001) : Object reference not set to an instance of an object. 15:09:43 - IsConnectionValid False 15:11:10 - (1-att-000001) : Object reference not set to an instance of an object. 15:12:08 - IsConnectionValid False 15:12:15 - (1-att-000001) : Object reference not set to an instance of an object. 15:12:37 - IsConnectionValid False 15:13:29 - (1-att-000001) : Object reference not set to an instance of an object. 15:16:02 - IsConnectionValid False 15:16:17 - (1-att-000001) : Syntax error (missing operator) in query expression 'userid user_uid'. 15:19:40 - IsConnectionValid False 15:19:43 - (1-att-000001) : Arithmetic overflow error for data type tinyint, value = 256. 15:20:18 - IsConnectionValid False 15:21:11 - (1-att-000001) : Arithmetic overflow error for data type tinyint, value = 256. 15:21:34 - IsConnectionValid False 15:22:38 - IsConnectionValid True 15:22:40 - IsConnectionValid True 15:22:40 - 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 15:22:42 - IsConnectionValid True 15:22: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 Code =1360 and DateLeft = '1900-01-01' ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow 15:22:47 - IsConnectionValid True 15:22:47 - 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' and EnglishName LIKE '%jum%' ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow 15:22:51 - IsConnectionValid True 15:22:51 - SELECT * FROM EmpWifeInfo WHERE TenantID =1 and EmpId = @val1 ORDER BY Code Query 15:22:51 - IsConnectionValid True 15:22:51 - SELECT DISTINCT * FROM EducationCity WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 15:22:51 - SELECT DISTINCT * FROM TransportCompanyDef WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 15:22:51 - IsConnectionValid True 15:22:51 - SELECT DISTINCT * FROM Career_Ladder_Grades WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 15:22:52 - IsConnectionValid True 15:22:52 - 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 =719 AND Emp.MasterID =0 Query 15:22:52 - IsConnectionValid True 15:22:52 - SELECT * FROM vwCoursesEntryDetails WHERE TenantID =1 AND EmpID = @val1 AND UserID = @val2 Query 15:22:52 - IsConnectionValid True 15:22:52 - SELECT * FROM vwWarningEntry WHERE TenantID =1 AND EmpID = @val1 AND UserID = @val2 Query 15:22:52 - IsConnectionValid True 15:22:52 - SELECT DISTINCT * FROM Departments WHERE TenantID =1 and ID = @val1 Query 15:22:52 - IsConnectionValid True 15:22:52 - SELECT DISTINCT * FROM Section WHERE TenantID =1 and ID = @val1 Query 15:23:02 - IsConnectionValid True 15:23:02 - 0 :COuntDATA: System.Collections.ArrayList 15:23:02 - : DocumentAttachDetails 15:23:02 - 719 :dddddddddddddddddddddd2 15:23:02 - 719 :dddddddddddddddddddddd3 15:23:03 - IsConnectionValid True 15:23:03 - 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' and EnglishName LIKE '%jum%' ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow 15:23:15 - IsConnectionValid True 15:23:15 - 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 15:23:19 - IsConnectionValid True 15:23: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 AND Name LIKE @val1 ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow 15:23:22 - IsConnectionValid True 15:23: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 EnglishName LIKE @val1 ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow 15:23:24 - IsConnectionValid True 15:23: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 EnglishName LIKE @val1 ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow 15:23:28 - IsConnectionValid False 15:24:27 - IsConnectionValid False 15:24:49 - IsConnectionValid False 15:27:14 - IsConnectionValid True 15:33:21 - SELECT DISTINCT * FROM Jobs WHERE TenantID =1 ORDER BY ID Query 15:33:21 - SELECT DISTINCT * FROM Section WHERE TenantID = 1 AND TenantID = @val0 and ID = @val1 Query 15:33:21 - SELECT Min(CalculationDate) AS Result FROM DailyTransactionCalc WHERE TenantID =1 and EmployeeID = @val1 and month(CalculationDate) IN (select Month(closedate) from CloseMonth where TenantID=1 and Year(closedate)=Year(CalculationDate)) Query 15:33:21 - IsConnectionValid True 15:33:21 - SELECT DISTINCT * FROM Religion WHERE TenantID = 1 AND TenantID = @val0 AND IsActive = @val1 ORDER BY ID Query 15:33:21 - SELECT DISTINCT * FROM Nation WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 15:33:21 - IsConnectionValid True 15:33:21 - SELECT DISTINCT * FROM Projects WHERE TenantID =1 and ID = @val1 Query 15:33:21 - IsConnectionValid True 15:33:21 - IsConnectionValid True 15:33:21 - SELECT DISTINCT * FROM BloodTypes WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 15:33:21 - SELECT DISTINCT * FROM Countries WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 15:33:21 - IsConnectionValid True 15:33:21 - SELECT DISTINCT * FROM EducationCity WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 15:33:21 - IsConnectionValid True 15:33:21 - IsConnectionValid True 15:33:21 - SELECT DISTINCT * FROM JobType WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 15:33:21 - IsConnectionValid True 15:33:21 - SELECT DISTINCT * FROM JobDegree WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 15:33:21 - SELECT DISTINCT * FROM VwEmpEducations WHERE TenantID =1 and EmployeeID = @val1 and UserID = @val2 and (ExtensionsID =(SELECT TOP 1 ID FROM Extensions WHERE TabIndex=3) OR ExtensionsID=0) ORDER BY ID Query 15:33:21 - SELECT DISTINCT * FROM TransportCompanyDef WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 15:33:22 - IsConnectionValid True 15:33:22 - SELECT * FROM VwEmpExperience WHERE TenantID =1 and EmployeeID = @val1 and ExperienceType = @val2 ORDER BY ID Query 15:33:22 - IsConnectionValid True 15:33:22 - IsConnectionValid True 15:33:22 - SELECT DISTINCT * FROM Banks WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 15:33:22 - SELECT DISTINCT * FROM HRMS_vwVacTransType WHERE TenantID =1 and isnull(IsOvertime,0) = @val1 ORDER BY ID Query 15:33:22 - IsConnectionValid True 15:33:22 - 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 = 719 WHERE CustodyItemsDef.TenantID =1 Query 15:33:22 - SELECT DISTINCT * FROM HRMS_vwVacTransType WHERE TenantID =1 and isnull(IsOvertime,0) = @val1 ORDER BY ID Query 15:33:22 - IsConnectionValid True 15:33:22 - SELECT * FROM vwEmpDocumentDet WHERE TenantID =1 and EmpID = @val1 and (ExtensionsID =(SELECT TOP 1 ID FROM Extensions WHERE TabIndex=6) OR ExtensionsID=0) ORDER BY ID Query 15:33:22 - IsConnectionValid True 15:33:22 - IsConnectionValid True 15:33:22 - 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' and EnglishName LIKE '%jum%' ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow 15:33:23 - SELECT * FROM vwWarningEntry WHERE TenantID =1 AND EmpID = @val1 AND UserID = @val2 Query 15:33:23 - SELECT * FROM vwThanksBooksEntry WHERE TenantID =1 AND EmpID = @val1 AND UserID = @val2 Query 15:33:23 - SELECT * FROM vwCoursesEntryDetails WHERE TenantID =1 AND EmpID = @val1 AND UserID = @val2 Query 15:33:23 - 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 15:33:23 - IsConnectionValid False 15:33:48 - IsConnectionValid False 15:43:57 - IsConnectionValid True 15:43:57 - 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' and EnglishName LIKE '%jum%' ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow 15:47:12 - IsConnectionValid True 15:47:12 - SELECT ID AS ID, FromHour AS FromHour, ToHour AS ToHour FROM VacationEntry WHERE TenantID = 1 AND EmployeeID = @val0 and CAST(FromDate AS Date) = @val1 and IsHours = @val2 and Minus > @val3 and IsFromAttendance = @val4 and TenantID = @val5 ORDER BY ID asc Query 15:49:33 - IsConnectionValid True 15:49:34 - IsConnectionValid True 15:49:34 - SELECT * FROM vwEmployeeLanguages WHERE TenantID =1 and EmployeeID = @val1 Query 15:49:34 - IsConnectionValid True 15:49:34 - IsConnectionValid True 15:49:34 - IsConnectionValid True 15:49:34 - SELECT * FROM vwCoursesEntryDetails WHERE TenantID =1 AND EmpID = @val1 AND UserID = @val2 Query 15:49:34 - IsConnectionValid True 15:49:34 - SELECT DISTINCT * FROM Departments WHERE TenantID =1 and ID = @val1 Query 15:49:34 - IsConnectionValid True 15:49:34 - SELECT DISTINCT * FROM Section WHERE TenantID =1 and ID = @val1 Query 15:49:46 - IsConnectionValid True 15:49:46 - 0 :COuntDATA: System.Collections.ArrayList 15:49:46 - : DocumentAttachDetails 15:49:46 - 719 :dddddddddddddddddddddd2 15:49:46 - 719 :dddddddddddddddddddddd3 15:49:47 - IsConnectionValid True 15:49:47 - 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' and EnglishName LIKE '%jum%' ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow 15:49:51 - IsConnectionValid False 15:50:44 - IsConnectionValid False 15:50:45 - IsConnectionValid True 15:50:59 - IsConnectionValid True 15:51:10 - IsConnectionValid True 15:51:10 - IsConnectionValid True 15:51:16 - IsConnectionValid True 15:51:25 - IsConnectionValid False 15:51:34 - IsConnectionValid False 15:51:35 - IsConnectionValid True 15:51:52 - IsConnectionValid True 15:51:52 - IsConnectionValid True 15:57:24 - IsConnectionValid False 15:57:38 - IsConnectionValid False 15:57:44 - IsConnectionValid False 15:57:44 - IsConnectionValid False 15:57:45 - IsConnectionValid False 15:57:54 - IsConnectionValid False 15:57:54 - IsConnectionValid False 15:57:55 - IsConnectionValid False 15:58:27 - IsConnectionValid True 15:58:32 - IsConnectionValid True 15:58:32 - IsConnectionValid True 15:58:37 - IsConnectionValid True 15:59:17 - IsConnectionValid False 15:59:22 - IsConnectionValid False 15:59:22 - IsConnectionValid False 15:59:23 - IsConnectionValid False 15:59:59 - IsConnectionValid False 15:59:59 - IsConnectionValid False 16:00:00 - IsConnectionValid False 16:00:17 - IsConnectionValid True 16:00:17 - IsConnectionValid True 16:00:20 - IsConnectionValid True 16:00:34 - IsConnectionValid False 16:00:42 - IsConnectionValid False 16:00:43 - IsConnectionValid True 16:01:32 - IsConnectionValid True 16:01:37 - IsConnectionValid True 16:01:37 - IsConnectionValid True 16:01:55 - IsConnectionValid True 16:01:57 - IsConnectionValid True 16:02:07 - IsConnectionValid False 16:02:21 - IsConnectionValid False 16:02:21 - IsConnectionValid True 16:04:58 - IsConnectionValid False 16:05:09 - IsConnectionValid False 16:05:09 - IsConnectionValid False 16:05:09 - IsConnectionValid False 16:09:52 - IsConnectionValid False 16:09:58 - IsConnectionValid False 16:09:58 - IsConnectionValid False 16:12:58 - IsConnectionValid False 16:12:58 - IsConnectionValid False 16:23:08 - IsConnectionValid True 16:23:08 - IsConnectionValid True 16:23:18 - IsConnectionValid True 16:23:24 - IsConnectionValid False 16:23:34 - IsConnectionValid False 16:24:50 - IsConnectionValid False 16:25:24 - IsConnectionValid False 16:25:48 - IsConnectionValid False 16:26:57 - IsConnectionValid False 16:27:50 - IsConnectionValid False 16:27:57 - IsConnectionValid True 16:28:02 - IsConnectionValid True 16:28:02 - IsConnectionValid True 16:28:05 - IsConnectionValid True 16:28:14 - IsConnectionValid False 16:28:22 - IsConnectionValid False 16:28:23 - IsConnectionValid True 16:30:10 - IsConnectionValid False 16:30:11 - (2-gen-005001) : Unrecognized attribute 'ProviderName'. Note that attribute names are case-sensitive. (D:\Web Projects\Human Resources Management System\Web Services\WCF\WCF.Web\web.config line 20) 16:33:27 - IsConnectionValid True 16:33:32 - IsConnectionValid True 16:33:32 - IsConnectionValid True 16:33:35 - IsConnectionValid True 16:33:42 - IsConnectionValid False 16:33:49 - IsConnectionValid False 16:33:50 - IsConnectionValid True 16:38:00 - IsConnectionValid True 16:38:08 - IsConnectionValid True 16:38:11 - IsConnectionValid True 16:38:29 - IsConnectionValid True 16:38:36 - IsConnectionValid True 16:38:36 - IsConnectionValid True