10:34:31 - IsConnectionValid True 10:34:33 - IsConnectionValid True 10:34:36 - IsConnectionValid True 10:34:44 - IsConnectionValid True 10:34:44 - IsConnectionValid True 10:34:48 - IsConnectionValid True 10:35:23 - IsConnectionValid True 10:35:29 - IsConnectionValid True 10:35:29 - SELECT DISTINCT ID AS ID, MonthCode AS Code, MonthName AS Name FROM CalculationPeriods WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 10:35:32 - IsConnectionValid True 10:35:35 - IsConnectionValid True 10:35:35 - SELECT DISTINCT ID AS ID, MonthCode AS Code, MonthName AS Name FROM CalculationPeriods WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 10:35:38 - IsConnectionValid True 10:35:41 - IsConnectionValid True 10:35:41 - SELECT DISTINCT ID AS ID, MonthCode AS Code, MonthName AS Name FROM CalculationPeriods WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 10:35:50 - IsConnectionValid True 10:39:26 - IsConnectionValid True 10:42:02 - IsConnectionValid True 10:45:20 - IsConnectionValid True 10:46:21 - IsConnectionValid True 10:47:17 - IsConnectionValid True 10:47:43 - IsConnectionValid True 10:47:51 - IsConnectionValid True 10:47:51 - SELECT DISTINCT ID AS ID, MonthCode AS Code, MonthName AS Name FROM CalculationPeriods WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 10:47:57 - IsConnectionValid True 10:49:11 - IsConnectionValid True 10:49:17 - IsConnectionValid True 10:49:17 - SELECT DISTINCT ID AS ID, MonthCode AS Code, MonthName AS Name FROM CalculationPeriods WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 10:49:24 - IsConnectionValid True 10:50:26 - IsConnectionValid True 10:50:33 - IsConnectionValid True 10:50:33 - SELECT DISTINCT ID AS ID, MonthCode AS Code, MonthName AS Name FROM CalculationPeriods WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 10:50:40 - IsConnectionValid True 10:51:25 - IsConnectionValid True 11:33:07 - IsConnectionValid True 11:33:08 - IsConnectionValid True 11:33:12 - IsConnectionValid True 11:33:12 - SELECT DISTINCT ID AS ID, MonthCode AS Code, MonthName AS Name FROM CalculationPeriods WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 11:34:49 - IsConnectionValid True 11:35:02 - IsConnectionValid True 11:35:04 - IsConnectionValid True 11:35:04 - SELECT DISTINCT ID AS ID, MonthCode AS Code, MonthName AS Name FROM CalculationPeriods WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 11:35:18 - IsConnectionValid True 11:35:20 - IsConnectionValid True 11:35:20 - SELECT DISTINCT ID AS ID, MonthCode AS Code, MonthName AS Name FROM CalculationPeriods WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 11:35:38 - IsConnectionValid True 11:35:41 - IsConnectionValid True 11:35: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:37:48 - IsConnectionValid True 11:38:04 - IsConnectionValid True 11:38:13 - IsConnectionValid True 11:38:15 - IsConnectionValid True 11:40:45 - IsConnectionValid True 11:40:47 - IsConnectionValid True 11:40:49 - IsConnectionValid True 11:41:14 - IsConnectionValid True 12:16:18 - IsConnectionValid True 12:17:28 - IsConnectionValid True 12:18:49 - IsConnectionValid True 12:19:06 - IsConnectionValid True 12:19:32 - IsConnectionValid True 12:24:40 - IsConnectionValid True 12:25:25 - IsConnectionValid True 12:26:07 - IsConnectionValid True 12:28:14 - IsConnectionValid True 12:30:48 - IsConnectionValid True 12:31:25 - IsConnectionValid True 12:31:33 - IsConnectionValid True 12:32:00 - IsConnectionValid True 12:32:12 - IsConnectionValid True 12:32:18 - IsConnectionValid True 12:33:07 - IsConnectionValid True 12:33:13 - IsConnectionValid True 12:33:36 - IsConnectionValid True 12:33:40 - IsConnectionValid True 12:33:58 - IsConnectionValid True 12:35:46 - IsConnectionValid True 12:36:55 - IsConnectionValid True 12:36:56 - IsConnectionValid True 12:36:56 - 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:36:56 - (1-gen-1002) : Invalid object name 'Schools'. 12:36:58 - IsConnectionValid True 12:37:05 - IsConnectionValid True 12:37:22 - IsConnectionValid True 12:37:52 - IsConnectionValid True 12:39:09 - IsConnectionValid True 12:39:59 - IsConnectionValid True 12:40:05 - IsConnectionValid True 12:41:23 - IsConnectionValid True 12:41:34 - IsConnectionValid True 12:42:09 - IsConnectionValid True 12:42:40 - IsConnectionValid True 12:42:56 - IsConnectionValid True 12:43:10 - IsConnectionValid True 12:43:24 - IsConnectionValid True 12:43:29 - IsConnectionValid True 12:44:47 - IsConnectionValid True 12:44:53 - IsConnectionValid True 12:45:13 - IsConnectionValid True 12:46:12 - IsConnectionValid True 12:46:23 - IsConnectionValid True 12:46:43 - IsConnectionValid True 12:46:50 - IsConnectionValid True 12:47:02 - IsConnectionValid True 12:47:11 - IsConnectionValid True 13:07:58 - IsConnectionValid True 13:08:00 - IsConnectionValid True 13:13:38 - IsConnectionValid True 13:13:41 - IsConnectionValid True 13:14:32 - IsConnectionValid True 13:14:35 - IsConnectionValid True 13:16:26 - IsConnectionValid True 13:16:28 - IsConnectionValid True 13:16:32 - IsConnectionValid True 13:16:32 - finalQuery ;WITH CTE AS (SELECT ROW_NUMBER() OVER ( ORDER BY Code) AS rn, COUNT(*) OVER() AS _total, * FROM (SELECT DISTINCT * FROM Resign WHERE TenantID = 1 AND TenantID = @val0 ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow 13:16:35 - IsConnectionValid True 13:16:55 - IsConnectionValid True 13:16:55 - IsConnectionValid True 13:16:55 - finalQuery ;WITH CTE AS (SELECT ROW_NUMBER() OVER ( ORDER BY Code) AS rn, COUNT(*) OVER() AS _total, * FROM (SELECT DISTINCT * FROM Resign WHERE TenantID = 1 AND TenantID = @val0 ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow 13:17:06 - IsConnectionValid True 13:17:06 - IsConnectionValid True 13:17:06 - finalQuery ;WITH CTE AS (SELECT ROW_NUMBER() OVER ( ORDER BY Code) AS rn, COUNT(*) OVER() AS _total, * FROM (SELECT DISTINCT * FROM Resign WHERE TenantID = 1 AND TenantID = @val0 ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow 13:17:33 - IsConnectionValid True 13:22:28 - IsConnectionValid True 13:22:31 - IsConnectionValid True 13:22:34 - IsConnectionValid True 13:22:34 - finalQuery ;WITH CTE AS (SELECT ROW_NUMBER() OVER ( ORDER BY ID) AS rn, COUNT(*) OVER() AS _total, * FROM (SELECT DISTINCT * FROM Banks WHERE TenantID = 1 AND TenantID = @val0 ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow 13:22:39 - IsConnectionValid True 13:22:42 - IsConnectionValid True 13:22:42 - finalQuery ;WITH CTE AS (SELECT ROW_NUMBER() OVER ( ORDER BY ID) AS rn, COUNT(*) OVER() AS _total, * FROM (SELECT DISTINCT * FROM Banks WHERE TenantID = 1 AND TenantID = @val0 ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow 13:22:58 - IsConnectionValid True 13:22:58 - IsConnectionValid True 13:22:58 - finalQuery ;WITH CTE AS (SELECT ROW_NUMBER() OVER ( ORDER BY ID) AS rn, COUNT(*) OVER() AS _total, * FROM (SELECT DISTINCT * FROM Banks WHERE TenantID = 1 AND TenantID = @val0 ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow 13:23:07 - IsConnectionValid True 13:23:07 - finalQuery ;WITH CTE AS (SELECT ROW_NUMBER() OVER ( ORDER BY ID) AS rn, COUNT(*) OVER() AS _total, * FROM (SELECT DISTINCT * FROM Banks WHERE TenantID = 1 AND TenantID = @val0 ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow 13:25:43 - IsConnectionValid True 13:25:46 - IsConnectionValid True 13:25:46 - finalQuery ;WITH CTE AS (SELECT ROW_NUMBER() OVER ( ORDER BY ID) AS rn, COUNT(*) OVER() AS _total, * FROM (SELECT DISTINCT * FROM Banks WHERE TenantID = 1 AND TenantID = @val0 ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow 13:25:49 - IsConnectionValid True 13:25:52 - IsConnectionValid True 13:25:52 - finalQuery ;WITH CTE AS (SELECT ROW_NUMBER() OVER ( ORDER BY Code) AS rn, COUNT(*) OVER() AS _total, * FROM (SELECT DISTINCT * FROM vwBranches WHERE TenantID = 1 AND TenantID = @val0 ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow 13:25:58 - IsConnectionValid True 13:26:04 - IsConnectionValid True 13:26:04 - 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, BankName AS BankName FROM Banks WHERE TenantID = 1 AND TenantID = @val0 ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow 13:26:08 - IsConnectionValid True 13:26:08 - 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, BankName AS BankName FROM Banks WHERE TenantID = 1 AND TenantID = @val0 ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow 13:26:10 - IsConnectionValid True 13:26:10 - IsConnectionValid True 13:26:10 - finalQuery ;WITH CTE AS (SELECT ROW_NUMBER() OVER ( ORDER BY Code) AS rn, COUNT(*) OVER() AS _total, * FROM (SELECT DISTINCT * FROM vwBranches WHERE TenantID = 1 AND TenantID = @val0 ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow 13:26:21 - IsConnectionValid True 13:26:21 - finalQuery ;WITH CTE AS (SELECT ROW_NUMBER() OVER ( ORDER BY Code) AS rn, COUNT(*) OVER() AS _total, * FROM (SELECT DISTINCT * FROM vwBranches WHERE TenantID = 1 AND TenantID = @val0 AND Name LIKE @val1 ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow 13:26:21 - IsConnectionValid True 13:26:21 - finalQuery ;WITH CTE AS (SELECT ROW_NUMBER() OVER ( ORDER BY Code) AS rn, COUNT(*) OVER() AS _total, * FROM (SELECT DISTINCT * FROM vwBranches WHERE TenantID = 1 AND TenantID = @val0 AND Name LIKE @val1 ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow 13:26:42 - IsConnectionValid True 13:26:47 - IsConnectionValid True 13:26:47 - finalQuery ;WITH CTE AS (SELECT ROW_NUMBER() OVER ( ORDER BY ID) AS rn, COUNT(*) OVER() AS _total, * FROM (SELECT DISTINCT * FROM PaymentTypes WHERE TenantID = 1 AND TenantID = @val0 ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow 13:26:50 - IsConnectionValid True 13:26:53 - IsConnectionValid True 13:26:54 - IsConnectionValid True 13:26:54 - finalQuery ;WITH CTE AS (SELECT ROW_NUMBER() OVER ( ORDER BY ID) AS rn, COUNT(*) OVER() AS _total, * FROM (SELECT DISTINCT * FROM PaymentTypes WHERE TenantID = 1 AND TenantID = @val0 ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow 13:27:05 - IsConnectionValid True 13:28:11 - IsConnectionValid True 13:28:11 - finalQuery ;WITH CTE AS (SELECT ROW_NUMBER() OVER ( ORDER BY ID) AS rn, COUNT(*) OVER() AS _total, * FROM (SELECT DISTINCT * FROM TransactionsDef WHERE TenantID = 1 AND TenantID = @val0 ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow 13:28:15 - IsConnectionValid True 13:28:15 - finalQuery ;WITH CTE AS (SELECT ROW_NUMBER() OVER ( ORDER BY ID) AS rn, COUNT(*) OVER() AS _total, * FROM (SELECT DISTINCT * FROM TransactionsDef WHERE TenantID = 1 AND TenantID = @val0 ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow 13:28:17 - IsConnectionValid True 13:28:17 - finalQuery ;WITH CTE AS (SELECT ROW_NUMBER() OVER ( ORDER BY ID) AS rn, COUNT(*) OVER() AS _total, * FROM (SELECT DISTINCT * FROM TransactionsDef WHERE TenantID = 1 AND TenantID = @val0 ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow 13:28:19 - IsConnectionValid True 13:28:19 - finalQuery ;WITH CTE AS (SELECT ROW_NUMBER() OVER ( ORDER BY ID) AS rn, COUNT(*) OVER() AS _total, * FROM (SELECT DISTINCT * FROM TransactionsDef WHERE TenantID = 1 AND TenantID = @val0 ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow 13:38:33 - IsConnectionValid True 13:38:37 - IsConnectionValid True 13:39:07 - IsConnectionValid True 13:39:08 - IsConnectionValid True 13:39:12 - IsConnectionValid True 13:39:12 - finalQuery ;WITH CTE AS (SELECT ROW_NUMBER() OVER ( ORDER BY ID) AS rn, COUNT(*) OVER() AS _total, * FROM (SELECT DISTINCT * FROM VwLoans WHERE TenantID = 1 AND TenantID = @val0 ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow 13:39:12 - (1-gen-1004) : Invalid column name 'TenantID'. Invalid column name 'TenantID'. 13:39:14 - IsConnectionValid True 13:39:16 - IsConnectionValid True 13:39:16 - SELECT ID AS ID, Code AS Code, Name AS Name FROM TransactionsDef WHERE TenantID = 1 AND TenantID = @val0 and Loans = @val1 ORDER BY Code ASC Query 13:39:17 - IsConnectionValid True 13:39:17 - SELECT ID AS ID, Code AS Code, Name AS Name FROM TransactionsDef WHERE TenantID = 1 AND TenantID = @val0 and Loans = @val1 ORDER BY Code ASC Query 13:42:29 - IsConnectionValid True 13:42:30 - IsConnectionValid True 13:42:33 - IsConnectionValid True 13:43:04 - IsConnectionValid True 13:43:04 - IsConnectionValid True 13:43:07 - IsConnectionValid True 13:43:07 - finalQuery ;WITH CTE AS (SELECT ROW_NUMBER() OVER ( ORDER BY ID) AS rn, COUNT(*) OVER() AS _total, * FROM (SELECT DISTINCT * FROM VwLoans WHERE TenantID = 1 AND TenantID = @val0 ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow 13:43:07 - (1-gen-1004) : Invalid column name 'TenantID'. Invalid column name 'TenantID'. 13:43:09 - IsConnectionValid True 13:43:13 - IsConnectionValid True 13:43:13 - IsConnectionValid True 13:43:13 - finalQuery ;WITH CTE AS (SELECT ROW_NUMBER() OVER ( ORDER BY ID) AS rn, COUNT(*) OVER() AS _total, * FROM (SELECT DISTINCT * FROM VwLoans WHERE TenantID = 1 AND TenantID = @val0 ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow 13:43:13 - (1-gen-1004) : Invalid column name 'TenantID'. Invalid column name 'TenantID'. 13:43:16 - IsConnectionValid True 13:43:17 - IsConnectionValid True 13:43:17 - finalQuery ;WITH CTE AS (SELECT ROW_NUMBER() OVER ( ORDER BY ID) AS rn, COUNT(*) OVER() AS _total, * FROM (SELECT DISTINCT * FROM VwLoans WHERE TenantID = 1 AND TenantID = @val0 ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow 13:43:17 - (1-gen-1004) : Invalid column name 'TenantID'. Invalid column name 'TenantID'. 13:43:18 - IsConnectionValid True 13:43:30 - IsConnectionValid True 13:43:30 - IsConnectionValid True 13:43:30 - finalQuery ;WITH CTE AS (SELECT ROW_NUMBER() OVER ( ORDER BY ID) AS rn, COUNT(*) OVER() AS _total, * FROM (SELECT DISTINCT * FROM VwLoans WHERE TenantID = 1 AND TenantID = @val0 ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow 13:43:30 - (1-gen-1004) : Invalid column name 'TenantID'. Invalid column name 'TenantID'. 14:16:57 - IsConnectionValid True 14:17:01 - IsConnectionValid True 14:17:01 - SELECT DISTINCT ID AS ID, MonthCode AS Code, MonthName AS Name FROM CalculationPeriods WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 14:17:01 - IsConnectionValid True 14:17:01 - SELECT DISTINCT ID AS ID, MonthCode AS Code, MonthName AS Name FROM CalculationPeriods WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 14:17:52 - IsConnectionValid True 14:17:56 - IsConnectionValid True 14:17:58 - IsConnectionValid True 14:24:51 - IsConnectionValid True 14:24:59 - IsConnectionValid True 14:24:59 - SELECT DISTINCT ID AS ID, Code AS Code, BankName AS Name FROM Banks WHERE TenantID = 1 AND TenantID = @val0 Query 14:24:59 - IsConnectionValid True 14:24:59 - SELECT DISTINCT ID AS ID, Code AS Code, BankName AS Name FROM Banks WHERE TenantID = 1 AND TenantID = @val0 Query 14:25:02 - IsConnectionValid True 14:25:02 - SELECT DISTINCT ID AS ID, Code AS Code, BankName AS Name FROM Banks WHERE TenantID = 1 AND TenantID = @val0 Query 14:25:02 - IsConnectionValid True 14:25:02 - SELECT DISTINCT ID AS ID, Code AS Code, BankName AS Name FROM Banks WHERE TenantID = 1 AND TenantID = @val0 Query 14:34:34 - IsConnectionValid True 14:34:45 - IsConnectionValid True 14:34:45 - SELECT DISTINCT ID AS ID, Code AS Code, Name AS Name, BankID AS BankID, BankCode AS BankCode, BanksName AS BanksName FROM vwBranches WHERE TenantID = @val0 And (0= 0 OR BankID=0) Query 14:34:46 - IsConnectionValid True 14:34:46 - SELECT DISTINCT ID AS ID, Code AS Code, Name AS Name, BankID AS BankID, BankCode AS BankCode, BanksName AS BanksName FROM vwBranches WHERE TenantID = @val0 And (0= 0 OR BankID=0) Query 14:34:49 - IsConnectionValid True 14:34:49 - SELECT DISTINCT ID AS ID, Code AS Code, BankName AS Name FROM Banks WHERE TenantID = 1 AND TenantID = @val0 Query 14:34:49 - IsConnectionValid True 14:34:49 - SELECT DISTINCT ID AS ID, Code AS Code, BankName AS Name FROM Banks WHERE TenantID = 1 AND TenantID = @val0 Query 14:34:52 - IsConnectionValid True 14:34:52 - SELECT DISTINCT ID AS ID, Code AS Code, Name AS Name, BankID AS BankID, BankCode AS BankCode, BanksName AS BanksName FROM vwBranches WHERE TenantID = @val0 And (3= 0 OR BankID=3) Query 14:34:52 - IsConnectionValid True 14:34:52 - SELECT DISTINCT ID AS ID, Code AS Code, Name AS Name, BankID AS BankID, BankCode AS BankCode, BanksName AS BanksName FROM vwBranches WHERE TenantID = @val0 And (3= 0 OR BankID=3) Query 14:35:54 - IsConnectionValid True 14:36:52 - IsConnectionValid True 14:36:52 - SELECT DISTINCT ID AS ID, Code AS Code, Name AS Name, BankID AS BankID, BankCode AS BankCode, BanksName AS BanksName FROM vwBranches WHERE TenantID = @val0 And (0= 0 OR BankID=0) Query 14:36:52 - IsConnectionValid True 14:36:52 - SELECT DISTINCT ID AS ID, Code AS Code, Name AS Name, BankID AS BankID, BankCode AS BankCode, BanksName AS BanksName FROM vwBranches WHERE TenantID = @val0 And (0= 0 OR BankID=0) Query 14:36:57 - IsConnectionValid True 14:36:57 - SELECT DISTINCT ID AS ID, Code AS Code, BankName AS Name FROM Banks WHERE TenantID = 1 AND TenantID = @val0 Query 14:36:57 - IsConnectionValid True 14:36:57 - SELECT DISTINCT ID AS ID, Code AS Code, BankName AS Name FROM Banks WHERE TenantID = 1 AND TenantID = @val0 Query 14:36:59 - IsConnectionValid True 14:36:59 - SELECT DISTINCT ID AS ID, Code AS Code, Name AS Name, BankID AS BankID, BankCode AS BankCode, BanksName AS BanksName FROM vwBranches WHERE TenantID = @val0 And (3= 0 OR BankID=3) Query 14:36:59 - IsConnectionValid True 14:36:59 - SELECT DISTINCT ID AS ID, Code AS Code, Name AS Name, BankID AS BankID, BankCode AS BankCode, BanksName AS BanksName FROM vwBranches WHERE TenantID = @val0 And (3= 0 OR BankID=3) Query 14:44:24 - IsConnectionValid True 14:44:29 - IsConnectionValid True