09:31:40 - IsConnectionValid True 09:31:41 - IsConnectionValid True 09:31:49 - IsConnectionValid True 09:31:49 - IsConnectionValid True 09:31:52 - IsConnectionValid True 09:41:10 - IsConnectionValid True 09:41:20 - IsConnectionValid True 09:41:20 - SELECT ISNULL(SchoolID,0) AS SchoolID, ISNULL(Name,'') AS Name, ISNULL(branch,'') AS Branch FROM User_Rights INNER JOIN Schools On User_Rights.SchoolID = Schools.ID WHERE TenantID = 1 AND UserID = @val0 and DefaultSchool = @val1 Query 09:41:20 - (1-gen-1002) : Invalid object name 'Schools'. 09:41:22 - IsConnectionValid True 09:41:33 - IsConnectionValid True 09:41:35 - IsConnectionValid True 09:41:38 - IsConnectionValid True 09:42:42 - IsConnectionValid True 09:42:44 - IsConnectionValid True 09:54:42 - IsConnectionValid True 09:55:49 - IsConnectionValid True 09:55:59 - IsConnectionValid True 09:56:01 - IsConnectionValid True 09:56:06 - IsConnectionValid True 09:56:07 - IsConnectionValid True 09:56:44 - IsConnectionValid True 09:56:45 - IsConnectionValid True 10:01:29 - IsConnectionValid True 10:01:30 - IsConnectionValid True 10:13:34 - IsConnectionValid True 10:13:36 - IsConnectionValid True 10:13:44 - IsConnectionValid True 10:14:04 - IsConnectionValid True 10:14:04 - IsConnectionValid True 10:14:06 - IsConnectionValid True 10:14:51 - IsConnectionValid True 10:14:52 - IsConnectionValid True 10:15:46 - IsConnectionValid True 10:15:47 - IsConnectionValid True 10:16:34 - IsConnectionValid True 10:16:35 - IsConnectionValid True 10:17:59 - IsConnectionValid True 10:18:00 - IsConnectionValid True 10:18:04 - IsConnectionValid True 10:18:04 - SELECT * FROM VwVacationEntry WHERE TenantID = 1 AND TenantID = @val0 AND EmployeeID = @val1 AND UserID = @val2 AND Posted <> @val3 ORDER BY FromDate ASC Query 10:18:05 - (1-gen-1002) : Invalid column name 'TenantID'. Invalid column name 'TenantID'. 10:18:59 - IsConnectionValid True 10:27:13 - IsConnectionValid True 10:27:13 - SELECT * FROM VwVacationEntry WHERE TenantID = 1 AND TenantID = @val0 AND EmployeeID = @val1 AND UserID = @val2 AND Posted <> @val3 ORDER BY FromDate ASC Query 10:27:13 - (1-gen-1002) : Invalid column name 'TenantID'. Invalid column name 'TenantID'. 10:27:26 - IsConnectionValid True 10:33:37 - IsConnectionValid True 10:33:37 - IsConnectionValid True 10:33:39 - IsConnectionValid True 10:35:20 - IsConnectionValid True 10:35:21 - IsConnectionValid True 10:35:26 - IsConnectionValid True 10:35:26 - SELECT * FROM SysAlerts WHERE TenantID=@TenantID AND Active = 1 Query NEW -______- 1 10:35:26 - Select COUNT(ID) AS TotalNum FROM Employees WHERE ( DATEDIFF(DAY,GETDATE(),EndContractDate)<=30 AND DATEDIFF(DAY,GETDATE(),EndContractDate)>0) COUNT Query 0 10:35:29 - IsConnectionValid True 10:35:32 - IsConnectionValid True 10:35:33 - IsConnectionValid True 10:44:57 - IsConnectionValid True 10:45:27 - IsConnectionValid True 10:45:28 - IsConnectionValid True 10:45:30 - IsConnectionValid True 10:52:32 - IsConnectionValid True 10:52:33 - IsConnectionValid True 11:01:56 - IsConnectionValid True 11:01:57 - IsConnectionValid True 11:02:52 - IsConnectionValid True 11:04:01 - IsConnectionValid True 11:04:03 - IsConnectionValid True 11:04:05 - IsConnectionValid True 11:05:22 - IsConnectionValid True 11:05:24 - IsConnectionValid True 11:07:27 - IsConnectionValid True 11:09:05 - IsConnectionValid True 11:09:07 - IsConnectionValid True 11:09:11 - IsConnectionValid True 11:15:34 - IsConnectionValid True 11:15:38 - IsConnectionValid True 11:18:22 - IsConnectionValid True 11:29:30 - IsConnectionValid True 11:29:31 - IsConnectionValid True 11:34:33 - IsConnectionValid True 11:34:35 - IsConnectionValid True 11:34:36 - IsConnectionValid True 11:34:38 - IsConnectionValid True 11:36:48 - IsConnectionValid True 11:36:59 - IsConnectionValid True 11:39:29 - IsConnectionValid True 11:41:36 - IsConnectionValid True 11:42:27 - IsConnectionValid True 11:42:30 - IsConnectionValid True 11:42:30 - IsConnectionValid True 11:46:34 - IsConnectionValid True 11:47:01 - IsConnectionValid True 11:47:01 - SELECT * FROM VwVacationEntry WHERE TenantID = 1 AND TenantID = @val0 AND EmployeeID = @val1 AND UserID = @val2 AND Posted <> @val3 ORDER BY FromDate ASC Query 11:47:01 - (1-gen-1002) : Invalid column name 'TenantID'. Invalid column name 'TenantID'. 11:47:03 - IsConnectionValid True 11:47:03 - finalQuery ;WITH CTE AS (SELECT ROW_NUMBER() OVER ( ORDER BY ID ASC) AS rn, COUNT(*) OVER() AS _total, * FROM (SELECT * FROM HRMS_vwEmployees WHERE (DateLeft =01/01/1900 or (DateleftTemp<>DateLeft and DateLeft >01/03/2023)) and UserID = @val1 and TenantID = @val2 ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow 11:47:05 - IsConnectionValid True 11:47:05 - SELECT * FROM VwVacationEntry WHERE TenantID = 1 AND TenantID = @val0 AND EmployeeID = @val1 AND UserID = @val2 AND Posted <> @val3 ORDER BY FromDate ASC Query 11:47:05 - (1-gen-1002) : Invalid column name 'TenantID'. Invalid column name 'TenantID'. 11:47:06 - IsConnectionValid True 11:47:06 - 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, Type AS Type FROM VacationTypes WHERE TenantID = 1 AND TenantID = @val0 ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow 11:47:10 - IsConnectionValid True 11:47:10 - SELECT DISTINCT * FROM HRMS_vwEmployees WHERE TenantID = 1 AND TenantID = @val0 AND ID = @val1 AND UserID = @val2 ORDER BY ID Query 11:47:32 - IsConnectionValid True 11:47:32 - IsConnectionValid True 11:47:32 - IsConnectionValid True 11:47:32 - IsConnectionValid True 11:47:32 - SELECT * FROM VwVacationEntry WHERE TenantID = 1 AND TenantID = @val0 AND EmployeeID = @val1 AND UserID = @val2 AND Posted <> @val3 ORDER BY FromDate ASC Query 11:47:32 - (1-gen-1002) : Invalid column name 'TenantID'. Invalid column name 'TenantID'. 11:47:34 - IsConnectionValid True 11:47:34 - finalQuery ;WITH CTE AS (SELECT ROW_NUMBER() OVER ( ORDER BY ID ASC) AS rn, COUNT(*) OVER() AS _total, * FROM (SELECT * FROM HRMS_vwEmployees WHERE (DateLeft =01/01/1900 or (DateleftTemp<>DateLeft and DateLeft >01/03/2023)) and UserID = @val1 and TenantID = @val2 ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow 11:47:36 - IsConnectionValid True 11:47:36 - SELECT * FROM VwVacationEntry WHERE TenantID = 1 AND TenantID = @val0 AND EmployeeID = @val1 AND UserID = @val2 AND Posted <> @val3 ORDER BY FromDate ASC Query 11:47:36 - (1-gen-1002) : Invalid column name 'TenantID'. Invalid column name 'TenantID'. 11:47:38 - IsConnectionValid True 11:47:38 - 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, Type AS Type FROM VacationTypes WHERE TenantID = 1 AND TenantID = @val0 ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow 11:48:12 - IsConnectionValid True 11:48:14 - IsConnectionValid True 11:48:14 - SELECT * FROM VwVacationEntry WHERE TenantID = 1 AND TenantID = @val0 AND EmployeeID = @val1 AND UserID = @val2 AND Posted <> @val3 ORDER BY FromDate ASC Query 11:48:14 - (1-gen-1002) : Invalid column name 'TenantID'. Invalid column name 'TenantID'. 11:48:16 - IsConnectionValid True 11:48:28 - IsConnectionValid True 11:49:03 - IsConnectionValid True 12:00:17 - IsConnectionValid True 12:00:18 - IsConnectionValid True 12:05:04 - IsConnectionValid True 12:05:05 - IsConnectionValid True 12:05:21 - IsConnectionValid True 12:05:22 - IsConnectionValid True 12:07:09 - IsConnectionValid True 12:30:23 - IsConnectionValid True 12:43:18 - IsConnectionValid True 12:47:38 - IsConnectionValid True 12:50:07 - IsConnectionValid True 12:57:03 - IsConnectionValid True 12:57:03 - IsConnectionValid True 12:57:03 - IsConnectionValid True 12:57:03 - SELECT DISTINCT * FROM StaffCategory WHERE TenantID =1 ORDER BY ID Query 12:57:03 - SELECT * FROM web_HRMS_Experience WHERE TenantID = 1 AND TenantID = @val0 ORDER BY StaffCatID ASC, ExperienceNo2 ASC Query 12:58:05 - IsConnectionValid True 12:58:10 - IsConnectionValid True 12:58:38 - IsConnectionValid True 12:58:41 - IsConnectionValid True 12:58:43 - IsConnectionValid True 13:44:58 - IsConnectionValid True 13:45:00 - IsConnectionValid True 13:46:18 - IsConnectionValid True 13:46:19 - IsConnectionValid True 13:46:36 - IsConnectionValid True 13:46:37 - IsConnectionValid True 13:47:49 - IsConnectionValid True 13:47:50 - IsConnectionValid True 13:48:45 - IsConnectionValid True 13:48:46 - IsConnectionValid True 14:45:31 - IsConnectionValid True 14:45:32 - IsConnectionValid True 14:48:44 - IsConnectionValid True 14:48:45 - IsConnectionValid True 14:48:51 - IsConnectionValid True 14:48:52 - IsConnectionValid True 14:49:26 - IsConnectionValid True 14:49:27 - IsConnectionValid True 14:49:28 - IsConnectionValid True 14:49:30 - IsConnectionValid True 14:50:15 - IsConnectionValid True 14:50:16 - IsConnectionValid True 14:50:36 - IsConnectionValid True 14:50:36 - IsConnectionValid True 14:50:49 - IsConnectionValid True 14:50:51 - IsConnectionValid True 14:51:43 - IsConnectionValid True 14:51:45 - IsConnectionValid True 14:51:50 - IsConnectionValid True 14:51:50 - SELECT ISNULL(SchoolID,0) AS SchoolID, ISNULL(Name,'') AS Name, ISNULL(branch,'') AS Branch FROM User_Rights INNER JOIN Schools On User_Rights.SchoolID = Schools.ID WHERE TenantID = 1 AND UserID = @val0 and DefaultSchool = @val1 Query 14:51:51 - (1-gen-1002) : Invalid object name 'Schools'. 14:52:03 - IsConnectionValid True 14:52:03 - SELECT DISTINCT ID AS ID, Code AS Code, Name AS Name FROM Projects WHERE TenantID = 1 AND TenantID = @val0 Query 14:52:03 - IsConnectionValid True 14:52:03 - SELECT DISTINCT ID AS ID, Code AS Code, Name AS Name FROM Projects WHERE TenantID = 1 AND TenantID = @val0 Query 14:52:58 - IsConnectionValid True 14:53:35 - IsConnectionValid True 14:53:50 - IsConnectionValid True 14:53:50 - 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 =1 or 1 =0) and (DepartmentID =0 or 0 =0) and (SectionID =0 or 0 =0) and UserID = @val4 and CAST(DateLeft AS Date) = @val5 ORDER BY Code ASC Query 14:53:51 - IsConnectionValid True 14:53:51 - 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 =1 or 1 =0) and (DepartmentID =0 or 0 =0) and (SectionID =0 or 0 =0) and UserID = @val4 and CAST(DateLeft AS Date) = @val5 ORDER BY Code ASC Query 14:53:53 - IsConnectionValid True 14:53: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 =1 or 1 =0) and (DepartmentID =0 or 0 =0) and (SectionID =0 or 0 =0) and UserID = @val4 and CAST(DateLeft AS Date) = @val5 ORDER BY Code ASC Query 14:53:53 - IsConnectionValid True 14:53: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 =1 or 1 =0) and (DepartmentID =0 or 0 =0) and (SectionID =0 or 0 =0) and UserID = @val4 and CAST(DateLeft AS Date) = @val5 ORDER BY Code ASC Query 14:53:56 - IsConnectionValid True 14:54:13 - IsConnectionValid True 14:55:01 - IsConnectionValid True 14:55:01 - SELECT ISNULL(SchoolID,0) AS SchoolID, ISNULL(Name,'') AS Name, ISNULL(branch,'') AS Branch FROM User_Rights INNER JOIN Schools On User_Rights.SchoolID = Schools.ID WHERE TenantID = 1 AND UserID = @val0 and DefaultSchool = @val1 Query 14:55:01 - (1-gen-1002) : Invalid object name 'Schools'. 14:55:43 - IsConnectionValid True 15:00:38 - IsConnectionValid True 15:00:42 - IsConnectionValid True 15:01:00 - IsConnectionValid True 15:01:03 - IsConnectionValid True 15:01:37 - IsConnectionValid True 15:01:40 - IsConnectionValid True 15:01:45 - IsConnectionValid True 15:01:45 - SELECT ISNULL(SchoolID,0) AS SchoolID, ISNULL(Name,'') AS Name, ISNULL(branch,'') AS Branch FROM User_Rights INNER JOIN Schools On User_Rights.SchoolID = Schools.ID WHERE TenantID = 1 AND UserID = @val0 and DefaultSchool = @val1 Query 15:01:45 - (1-gen-1002) : Invalid object name 'Schools'. 15:02:06 - IsConnectionValid True 15:02:29 - IsConnectionValid True 15:02:29 - 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 UserID = @val4 and CAST(DateLeft AS Date) = @val5 ORDER BY Code ASC Query 15:02:30 - IsConnectionValid True 15:02:30 - 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 UserID = @val4 and CAST(DateLeft AS Date) = @val5 ORDER BY Code ASC Query 15:02:32 - IsConnectionValid True 15:02:32 - 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 UserID = @val4 and CAST(DateLeft AS Date) = @val5 ORDER BY Code ASC Query 15:02:32 - IsConnectionValid True 15:02:32 - 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 UserID = @val4 and CAST(DateLeft AS Date) = @val5 ORDER BY Code ASC Query 15:02:35 - IsConnectionValid True 15:02:38 - IsConnectionValid True 15:02:40 - IsConnectionValid True 15:02:40 - IsConnectionValid True 15:04:39 - IsConnectionValid True 15:05:44 - IsConnectionValid True 15:05:56 - IsConnectionValid True 15:06:28 - IsConnectionValid True 15:06:28 - 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 UserID = @val4 and CAST(DateLeft AS Date) = @val5 ORDER BY Code ASC Query 15:06:28 - IsConnectionValid True 15:06:28 - 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 UserID = @val4 and CAST(DateLeft AS Date) = @val5 ORDER BY Code ASC Query 15:06:37 - IsConnectionValid True 15:06:37 - 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 UserID = @val4 and CAST(DateLeft AS Date) = @val5 ORDER BY Code ASC Query 15:06:38 - IsConnectionValid True 15:06:38 - 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 UserID = @val4 and CAST(DateLeft AS Date) = @val5 ORDER BY Code ASC Query 15:06:43 - IsConnectionValid True 15:07:00 - IsConnectionValid True 15:22:15 - IsConnectionValid True 15:22:16 - IsConnectionValid True 15:22:38 - IsConnectionValid True 15:22:45 - IsConnectionValid True 15:22:48 - IsConnectionValid True