10:01:04 - IsConnectionValid True 10:01:04 - IsConnectionValid True 10:01:12 - IsConnectionValid True 10:01:12 - IsConnectionValid True 10:01:16 - IsConnectionValid True 10:01:19 - IsConnectionValid True 10:01:19 - 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 10:01:19 - (1-gen-1002) : Invalid object name 'Schools'. 10:02:07 - IsConnectionValid True 10:02:07 - SELECT DISTINCT ID AS ID, Code AS Code, Name AS Name FROM Projects WHERE TenantID = 1 AND TenantID = @val0 Query 10:02:07 - IsConnectionValid True 10:02:07 - SELECT DISTINCT ID AS ID, Code AS Code, Name AS Name FROM Projects WHERE TenantID = 1 AND TenantID = @val0 Query 10:02:10 - IsConnectionValid True 10:02:10 - SELECT ID AS ID, Code AS Code, Name AS Name, PID AS PID FROM Departments WHERE TenantID = @val0 and (PID =0 or 0 =0) ORDER BY Code ASC Query 10:02:10 - IsConnectionValid True 10:02:10 - SELECT ID AS ID, Code AS Code, Name AS Name, PID AS PID FROM Departments WHERE TenantID = @val0 and (PID =0 or 0 =0) ORDER BY Code ASC Query 10:02:13 - IsConnectionValid True 10:02:13 - SELECT ID AS ID, Code AS Code, Name AS Name, DepartmentID AS DepartmentID, ProjectID AS ProjectID FROM Section WHERE TenantID = @val0 and (ProjectID =0 or 0 =0) and (DepartmentID =0 or 0 =0) ORDER BY Code ASC Query 10:02:13 - IsConnectionValid True 10:02:13 - SELECT ID AS ID, Code AS Code, Name AS Name, DepartmentID AS DepartmentID, ProjectID AS ProjectID FROM Section WHERE TenantID = @val0 and (ProjectID =0 or 0 =0) and (DepartmentID =0 or 0 =0) ORDER BY Code ASC Query 10:02:27 - IsConnectionValid True 10:02:29 - IsConnectionValid True 10:02:31 - IsConnectionValid True 10:02:31 - 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 10:02:31 - (1-gen-1002) : Invalid object name 'Schools'. 10:02:40 - IsConnectionValid True 10:27:12 - IsConnectionValid True 10:27:13 - IsConnectionValid True 10:29:32 - IsConnectionValid True 10:29:33 - IsConnectionValid True 10:31:56 - IsConnectionValid True 10:31:57 - IsConnectionValid True 10:32:19 - IsConnectionValid True 10:32:21 - IsConnectionValid True 10:36:08 - IsConnectionValid True 10:36:09 - IsConnectionValid True 10:36:44 - IsConnectionValid True 10:36:45 - IsConnectionValid True 10:37:15 - IsConnectionValid True 10:37:19 - IsConnectionValid True 10:41:33 - IsConnectionValid True 10:43:13 - IsConnectionValid True 10:43:21 - IsConnectionValid True 10:44:10 - IsConnectionValid True 10:44:59 - IsConnectionValid True 10:50:51 - IsConnectionValid True 10:51:11 - IsConnectionValid True 10:52:40 - IsConnectionValid True 10:54:42 - IsConnectionValid True 10:54:48 - IsConnectionValid True 10:54:53 - IsConnectionValid True 10:54:58 - IsConnectionValid True 10:55:00 - IsConnectionValid True 10:55:00 - SELECT DISTINCT ID AS ID, MonthCode AS Code, MonthName AS Name FROM CalculationPeriods WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 10:55:11 - IsConnectionValid True 10:56:45 - IsConnectionValid True 10:56:46 - IsConnectionValid True 10:57:11 - IsConnectionValid True 10:57:25 - IsConnectionValid True 10:59:27 - IsConnectionValid True 11:00:06 - IsConnectionValid True 11:00:44 - IsConnectionValid True 11:01:25 - IsConnectionValid True 11:01:43 - IsConnectionValid True 11:01:45 - IsConnectionValid True 11:01:45 - SELECT DISTINCT ID AS ID, MonthCode AS Code, MonthName AS Name FROM CalculationPeriods WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 11:02:36 - IsConnectionValid True 11:02:39 - IsConnectionValid True 11:02:39 - SELECT DISTINCT ID AS ID, MonthCode AS Code, MonthName AS Name FROM CalculationPeriods WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 11:03:39 - IsConnectionValid True 11:03:41 - IsConnectionValid True 11:03:41 - SELECT DISTINCT ID AS ID, MonthCode AS Code, MonthName AS Name FROM CalculationPeriods WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 11:04:21 - IsConnectionValid True 11:04:23 - IsConnectionValid True 11:04:23 - SELECT DISTINCT ID AS ID, MonthCode AS Code, MonthName AS Name FROM CalculationPeriods WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 13:18:54 - IsConnectionValid True 13:18:58 - IsConnectionValid True 13:18:58 - SELECT DISTINCT ID AS ID, MonthCode AS Code, MonthName AS Name FROM CalculationPeriods WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 13:19:08 - IsConnectionValid True 13:19:14 - IsConnectionValid True 13:19:18 - IsConnectionValid True 13:19:18 - SELECT DISTINCT ID AS ID, MonthCode AS Code, MonthName AS Name FROM CalculationPeriods WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 13:19:21 - IsConnectionValid True 13:19:52 - IsConnectionValid True 13:19:55 - IsConnectionValid True 13:19:55 - SELECT DISTINCT ID AS ID, MonthCode AS Code, MonthName AS Name FROM CalculationPeriods WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 13:19:58 - IsConnectionValid True 13:26:47 - IsConnectionValid True 13:26:48 - IsConnectionValid True 13:26:52 - IsConnectionValid True 13:26:52 - SELECT DISTINCT ID AS ID, MonthCode AS Code, MonthName AS Name FROM CalculationPeriods WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 13:27:19 - IsConnectionValid True 13:27:23 - IsConnectionValid True 13:27:23 - SELECT DISTINCT ID AS ID, MonthCode AS Code, MonthName AS Name FROM CalculationPeriods WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 13:27:28 - IsConnectionValid True 13:30:18 - IsConnectionValid True 13:30:22 - IsConnectionValid True 13:30:22 - SELECT DISTINCT ID AS ID, MonthCode AS Code, MonthName AS Name FROM CalculationPeriods WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 13:30:24 - IsConnectionValid True 13:31:30 - IsConnectionValid True 13:31:34 - IsConnectionValid True 13:31:34 - SELECT DISTINCT ID AS ID, MonthCode AS Code, MonthName AS Name FROM CalculationPeriods WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 13:31:36 - IsConnectionValid True 13:33:26 - IsConnectionValid True 13:33:31 - IsConnectionValid True 13:33:31 - SELECT DISTINCT ID AS ID, MonthCode AS Code, MonthName AS Name FROM CalculationPeriods WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 13:33:32 - IsConnectionValid True 13:35:17 - IsConnectionValid True 13:35:21 - IsConnectionValid True 13:35:21 - SELECT DISTINCT ID AS ID, MonthCode AS Code, MonthName AS Name FROM CalculationPeriods WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 13:35:23 - IsConnectionValid True 13:36:13 - IsConnectionValid True 13:36:16 - IsConnectionValid True 13:36:16 - SELECT DISTINCT ID AS ID, MonthCode AS Code, MonthName AS Name FROM CalculationPeriods WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 13:36:18 - IsConnectionValid True 13:36:33 - IsConnectionValid True 13:36:37 - IsConnectionValid True 13:36:37 - SELECT DISTINCT ID AS ID, MonthCode AS Code, MonthName AS Name FROM CalculationPeriods WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 13:36:39 - IsConnectionValid True 13:37:14 - IsConnectionValid True 13:39:07 - IsConnectionValid True 13:39:12 - IsConnectionValid True 13:39:12 - SELECT DISTINCT ID AS ID, MonthCode AS Code, MonthName AS Name FROM CalculationPeriods WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 13:39:14 - IsConnectionValid True 13:39:50 - IsConnectionValid True 13:43:41 - IsConnectionValid True 13:45:24 - IsConnectionValid True 13:48:13 - IsConnectionValid True 13:48:18 - IsConnectionValid True 13:48:23 - IsConnectionValid True 13: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 13:48:25 - IsConnectionValid True 13:48:48 - IsConnectionValid True 13:48:52 - IsConnectionValid True 13:48:52 - SELECT DISTINCT ID AS ID, MonthCode AS Code, MonthName AS Name FROM CalculationPeriods WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 13:48:56 - IsConnectionValid True 13:50:33 - IsConnectionValid True 13:51:31 - IsConnectionValid True 13:55:56 - IsConnectionValid True 13:57:07 - IsConnectionValid True 13:57:10 - IsConnectionValid True 14:03:24 - IsConnectionValid True 14:06:30 - IsConnectionValid True 14:15:27 - IsConnectionValid True 14:16:36 - IsConnectionValid True 14:18:11 - IsConnectionValid True 14:19:52 - IsConnectionValid True 14:20:47 - IsConnectionValid True 14:21:36 - IsConnectionValid True 14:24:51 - IsConnectionValid True 14:25:11 - IsConnectionValid True 14:25:31 - IsConnectionValid True 14:26:35 - IsConnectionValid True 14:26:40 - IsConnectionValid True 14:26:40 - SELECT DISTINCT ID AS ID, MonthCode AS Code, MonthName AS Name FROM CalculationPeriods WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 14:26:41 - IsConnectionValid True 14:27:26 - IsConnectionValid True 14:27:40 - IsConnectionValid True 14:29:03 - IsConnectionValid True 14:29:08 - IsConnectionValid True 14:29:08 - SELECT DISTINCT ID AS ID, MonthCode AS Code, MonthName AS Name FROM CalculationPeriods WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 14:29:15 - IsConnectionValid True 14:29:57 - IsConnectionValid True 14:30:31 - IsConnectionValid True 14:31:11 - IsConnectionValid True 14:31:58 - IsConnectionValid True 14:32:18 - IsConnectionValid True 14:33:08 - IsConnectionValid True 14:33:40 - IsConnectionValid True 14:34:19 - IsConnectionValid True 14:34:39 - IsConnectionValid True 14:35:23 - IsConnectionValid True 14:35:50 - IsConnectionValid True 14:55:18 - IsConnectionValid True 14:55:22 - IsConnectionValid True 14:55:22 - SELECT DISTINCT ID AS ID, MonthCode AS Code, MonthName AS Name FROM CalculationPeriods WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 14:55:59 - IsConnectionValid True 14:56:04 - IsConnectionValid True 14:56:04 - SELECT DISTINCT ID AS ID, MonthCode AS Code, MonthName AS Name FROM CalculationPeriods WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 14:57:06 - IsConnectionValid True 14:57:11 - IsConnectionValid True 14:57:11 - SELECT DISTINCT ID AS ID, MonthCode AS Code, MonthName AS Name FROM CalculationPeriods WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 14:57:13 - IsConnectionValid True 14:57:51 - IsConnectionValid True 14:57:55 - IsConnectionValid True 14:57:55 - SELECT DISTINCT ID AS ID, MonthCode AS Code, MonthName AS Name FROM CalculationPeriods WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 14:58:00 - IsConnectionValid True 14:58:02 - IsConnectionValid True 14:59:04 - IsConnectionValid True 14:59:10 - IsConnectionValid True 15:01:54 - IsConnectionValid True 15:02:01 - IsConnectionValid True 15:03:43 - IsConnectionValid True 15:03:48 - IsConnectionValid True 15:03:48 - SELECT DISTINCT ID AS ID, MonthCode AS Code, MonthName AS Name FROM CalculationPeriods WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 15:03:52 - IsConnectionValid True 15:08:19 - IsConnectionValid True 15:08:31 - IsConnectionValid True 15:08:40 - IsConnectionValid True 15:12:04 - IsConnectionValid True 15:13:31 - IsConnectionValid True 15:14:16 - IsConnectionValid True 15:15:08 - IsConnectionValid True 15:15:30 - IsConnectionValid True 15:15:33 - IsConnectionValid True 15:16:01 - IsConnectionValid True 15:16:06 - IsConnectionValid True 15:16:06 - SELECT DISTINCT ID AS ID, MonthCode AS Code, MonthName AS Name FROM CalculationPeriods WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 15:16:09 - IsConnectionValid True 15:16:38 - IsConnectionValid True 15:18:02 - IsConnectionValid True 15:18:06 - IsConnectionValid True 15:18:06 - SELECT DISTINCT ID AS ID, MonthCode AS Code, MonthName AS Name FROM CalculationPeriods WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 15:18:10 - IsConnectionValid True 15:18:17 - IsConnectionValid True 15:20:31 - IsConnectionValid True 15:20:37 - IsConnectionValid True 15:20:37 - SELECT DISTINCT ID AS ID, MonthCode AS Code, MonthName AS Name FROM CalculationPeriods WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 15:23:43 - IsConnectionValid True 15:23:49 - IsConnectionValid True 15:23:49 - SELECT DISTINCT ID AS ID, MonthCode AS Code, MonthName AS Name FROM CalculationPeriods WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 15:23:58 - IsConnectionValid True 15:24:04 - IsConnectionValid True 15:25:13 - IsConnectionValid True 15:25:18 - IsConnectionValid True 15:25:18 - SELECT DISTINCT ID AS ID, MonthCode AS Code, MonthName AS Name FROM CalculationPeriods WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 15:25:45 - IsConnectionValid True 15:25:50 - IsConnectionValid True 15:25:50 - SELECT DISTINCT ID AS ID, MonthCode AS Code, MonthName AS Name FROM CalculationPeriods WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 15:27:57 - IsConnectionValid True 15:28:02 - IsConnectionValid True 15:28:02 - SELECT DISTINCT ID AS ID, MonthCode AS Code, MonthName AS Name FROM CalculationPeriods WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 15:28:47 - IsConnectionValid True 15:28:52 - IsConnectionValid True 15:28:52 - SELECT DISTINCT ID AS ID, MonthCode AS Code, MonthName AS Name FROM CalculationPeriods WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 15:29:26 - IsConnectionValid True 15:29:48 - IsConnectionValid True 15:29:52 - IsConnectionValid True 15:29:52 - SELECT DISTINCT ID AS ID, MonthCode AS Code, MonthName AS Name FROM CalculationPeriods WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 15:30:13 - IsConnectionValid True 15:30:19 - IsConnectionValid True 15:30:19 - SELECT DISTINCT ID AS ID, MonthCode AS Code, MonthName AS Name FROM CalculationPeriods WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 15:30:42 - IsConnectionValid True 15:30:47 - IsConnectionValid True 15:30:47 - SELECT DISTINCT ID AS ID, MonthCode AS Code, MonthName AS Name FROM CalculationPeriods WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 15:32:13 - IsConnectionValid True 15:32:17 - IsConnectionValid True 15:32:17 - SELECT DISTINCT ID AS ID, MonthCode AS Code, MonthName AS Name FROM CalculationPeriods WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 15:32:31 - IsConnectionValid True 15:32:36 - IsConnectionValid True 15:32:36 - SELECT DISTINCT ID AS ID, MonthCode AS Code, MonthName AS Name FROM CalculationPeriods WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 15:33:29 - IsConnectionValid True 15:33:34 - IsConnectionValid True 15:33:34 - SELECT DISTINCT ID AS ID, MonthCode AS Code, MonthName AS Name FROM CalculationPeriods WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 15:38:00 - IsConnectionValid True 15:38:07 - IsConnectionValid True 15:38:07 - IsConnectionValid True 15:38:10 - IsConnectionValid True 15:38:14 - IsConnectionValid True 15:38:15 - IsConnectionValid True 15:38:16 - IsConnectionValid True 15:38:18 - IsConnectionValid True 15:38:19 - IsConnectionValid True 15:38:48 - IsConnectionValid True 15:38:57 - IsConnectionValid True 15:38:57 - IsConnectionValid True 15:39:03 - IsConnectionValid True 15:39:04 - IsConnectionValid True 15:39:05 - IsConnectionValid True 15:39:05 - SELECT * FROM SysAlerts WHERE TenantID=@TenantID AND Active = 1 Query NEW -______- 1 15:39:05 - Select COUNT(ID) AS TotalNum FROM Employees WHERE ( DATEDIFF(DAY,GETDATE(),EndContractDate)<=30 AND DATEDIFF(DAY,GETDATE(),EndContractDate)>0) COUNT Query 0 15:39:06 - IsConnectionValid True 15:42:53 - IsConnectionValid True 15:42:54 - IsConnectionValid True 15:42:57 - IsConnectionValid True 15:43:03 - IsConnectionValid True 15:43:03 - IsConnectionValid True 15:43:05 - IsConnectionValid True 15:43:19 - IsConnectionValid True 15:43:20 - IsConnectionValid True 15:43:22 - IsConnectionValid True 15:43:27 - IsConnectionValid True 15:43:27 - IsConnectionValid True 15:43:29 - IsConnectionValid True 15:44:06 - IsConnectionValid True 15:44:07 - IsConnectionValid True 15:44:19 - IsConnectionValid True 15:44:20 - IsConnectionValid True 15:46:14 - IsConnectionValid True 15:46:16 - IsConnectionValid True 15:50:07 - IsConnectionValid True 15:51:50 - IsConnectionValid True 15:51:55 - IsConnectionValid True 15:53:41 - IsConnectionValid True 15:53:47 - IsConnectionValid True 15:53:48 - IsConnectionValid True 15:53:49 - IsConnectionValid True 15:59:48 - IsConnectionValid True 15:59:50 - IsConnectionValid True 16:00:32 - IsConnectionValid True 16:00:33 - IsConnectionValid True 16:01:03 - IsConnectionValid True 16:01:04 - IsConnectionValid True 16:01:39 - IsConnectionValid True 16:01:45 - IsConnectionValid True 16:01:46 - IsConnectionValid True 16:01:46 - IsConnectionValid True 16:01:50 - IsConnectionValid True 16:01:57 - IsConnectionValid True 16:01:57 - IsConnectionValid True 16:02:01 - IsConnectionValid True 16:02:03 - IsConnectionValid True 16:02:08 - IsConnectionValid True 16:02:09 - IsConnectionValid True 16:02:09 - SELECT * FROM SysAlerts WHERE TenantID=@TenantID AND Active = 1 Query NEW -______- 1 16:02:09 - Select COUNT(ID) AS TotalNum FROM Employees WHERE ( DATEDIFF(DAY,GETDATE(),EndContractDate)<=30 AND DATEDIFF(DAY,GETDATE(),EndContractDate)>0) COUNT Query 0 16:02:11 - IsConnectionValid True 16:03:16 - IsConnectionValid True 16:03:18 - IsConnectionValid True 16:03:33 - IsConnectionValid True 16:04:25 - IsConnectionValid True 16:04:25 - IsConnectionValid True 16:04:54 - IsConnectionValid True 16:14:32 - IsConnectionValid True 16:14:33 - IsConnectionValid True 16:14:51 - IsConnectionValid True 16:14:58 - IsConnectionValid True 16:14:58 - IsConnectionValid True 16:14:59 - IsConnectionValid True 16:15:46 - IsConnectionValid True 16:15:53 - IsConnectionValid True 16:15:53 - SELECT DISTINCT ID AS ID, MonthCode AS Code, MonthName AS Name FROM CalculationPeriods WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 16:16:03 - IsConnectionValid True 16:16:09 - IsConnectionValid True 16:16:09 - SELECT DISTINCT ID AS ID, MonthCode AS Code, MonthName AS Name FROM CalculationPeriods WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 16:16:11 - IsConnectionValid True 16:16:14 - IsConnectionValid True 16:16:14 - SELECT DISTINCT ID AS ID, MonthCode AS Code, MonthName AS Name FROM CalculationPeriods WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 16:16:16 - IsConnectionValid True