12:10:18 - IsConnectionValid True
12:10:18 - IsConnectionValid True
12:10:18 - IsConnectionValid True
12:10:23 - IsConnectionValid True
12:10:27 - IsConnectionValid True
12:11:12 - IsConnectionValid True
12:11:14 - IsConnectionValid True
12:11:14 - IsConnectionValid True
12:11:16 - IsConnectionValid True
12:11:26 - IsConnectionValid True
12:11:26 - SELECT  DISTINCT * FROM VwEmpTransactionsWithSecurity WHERE  TenantID = @val0 AND CAST(TransactionDate AS Date) >= @val1 AND CAST(cast((cast(Month(TransactionDate) as varchar(10)) + '/' + cast(Day(TransactionDate) as varchar(10)) + '/' + cast(Year(TransactionDate) as varchar(10))) as DateTime) AS Date) <= @val2 AND UserID = @val3 AND EmployeeCode >= @val4 AND EmployeeCode <= @val5 AND TransactionUserID = @val6 AND IsNotManualEntry = @val7 AND IsReserve = @val8 AND Loans = @val9 AND IsInsurance = @val10   AND (Posted<>1 OR (Posted=1 AND IsSALARYDETAILS=1) or (PostedBeforeThisCalc = 0 and 0=1))  AND (Reccuring =1 OR ((Reccuring=99 or Reccuring=2) And TransactionDate>(select max(CloseDate) From CloseMonth where TenantID=1))) AND (ProjectID =0 OR 0=0) AND (DepartmentID =0 OR 0=0) AND (SectionID =0 OR 0=0) AND (TransactionID =0 OR 0=0) AND (Amount =0 OR 0=0) AND ( DATELEFT='01/01/1900' OR  (DATELEFT<>'01/01/1900' and DateLeft > 09/01/2025)) ORDER BY Code  Query
12:11:52 - IsConnectionValid True
12:11:53 - IsConnectionValid True
12:11:53 - SELECT  DISTINCT * FROM VwEmpTransactionsWithSecurity WHERE  TenantID = @val0 AND CAST(TransactionDate AS Date) >= @val1 AND CAST(cast((cast(Month(TransactionDate) as varchar(10)) + '/' + cast(Day(TransactionDate) as varchar(10)) + '/' + cast(Year(TransactionDate) as varchar(10))) as DateTime) AS Date) <= @val2 AND UserID = @val3 AND EmployeeCode >= @val4 AND EmployeeCode <= @val5 AND TransactionUserID = @val6 AND IsNotManualEntry = @val7 AND IsReserve = @val8 AND Loans = @val9 AND IsInsurance = @val10   AND (Posted<>1 OR (Posted=1 AND IsSALARYDETAILS=1) or (PostedBeforeThisCalc = 0 and 0=1))  AND (Reccuring =1 OR ((Reccuring=99 or Reccuring=2) And TransactionDate>(select max(CloseDate) From CloseMonth where TenantID=1))) AND (ProjectID =0 OR 0=0) AND (DepartmentID =0 OR 0=0) AND (SectionID =0 OR 0=0) AND (TransactionID =0 OR 0=0) AND (Amount =0 OR 0=0) AND ( DATELEFT='01/01/1900' OR  (DATELEFT<>'01/01/1900' and DateLeft > 09/30/2025)) ORDER BY Code  Query
12:12:55 - IsConnectionValid True
12:47:55 - IsConnectionValid True
12:48:00 - IsConnectionValid True
12:48:00 - 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
12:48:00 - (1-gen-1002) : Invalid object name 'Schools'.
12:48:02 - IsConnectionValid True
12:48:02 - IsConnectionValid True
12:48:02 - 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
12:48:02 - (1-gen-1002) : Invalid object name 'Schools'.
12:48:12 - IsConnectionValid True
12:48:33 - IsConnectionValid True
12:48:35 - IsConnectionValid True
12:48:35 - 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
12:48:35 - (1-gen-1002) : Invalid object name 'Schools'.
12:48:37 - IsConnectionValid True
14:51:44 - IsConnectionValid True