12:31:09 - IsConnectionValid True 14:16:21 - IsConnectionValid True 14:16:22 - IsConnectionValid True 14:16:38 - IsConnectionValid True 14:16:38 - IsConnectionValid True 15:03:41 - IsConnectionValid True 15:03:46 - IsConnectionValid True 15:08:06 - IsConnectionValid True 15:08:07 - IsConnectionValid True 15:08:11 - IsConnectionValid True 15:08:11 - IsConnectionValid True 15:08:11 - SELECT DISTINCT * FROM VwLoans WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 15:08:11 - SELECT DISTINCT * FROM VwLoansEntry WHERE TenantID = 1 AND TenantID = @val0 AND EmployeeID = @val1 AND UserID = @val2 Query 15:08:11 - SELECT DISTINCT * FROM HRMS_vwEmployees WHERE TenantID = 1 AND TenantID = @val0 and CAST(DateLeft AS Date) = @val1 and UserID = @val2 ORDER BY ID Query 15:08:11 - (1-gen-1002) : Invalid column name 'TenantID'. Invalid column name 'TenantID'. 15:08:11 - (1-gen-1002) : Invalid column name 'TenantID'. Invalid column name 'TenantID'. 15:08:24 - IsConnectionValid True 15:08:24 - SELECT DISTINCT * FROM VwLoansEntry WHERE TenantID = 1 AND TenantID = @val0 AND EmployeeID = @val1 AND UserID = @val2 Query 15:08:24 - (1-gen-1002) : Invalid column name 'TenantID'. Invalid column name 'TenantID'. 15:30:27 - IsConnectionValid True 15:30:28 - IsConnectionValid True 15:30:28 - IsConnectionValid True 15:30:28 - SELECT DISTINCT * FROM VwLoans WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 15:30:28 - SELECT DISTINCT * FROM VwLoansEntry WHERE TenantID = 1 AND TenantID = @val0 AND EmployeeID = @val1 AND UserID = @val2 Query 15:30:28 - SELECT DISTINCT * FROM HRMS_vwEmployees WHERE TenantID = 1 AND TenantID = @val0 and CAST(DateLeft AS Date) = @val1 and UserID = @val2 ORDER BY ID Query 15:30:29 - (1-gen-1002) : Invalid column name 'TenantID'. Invalid column name 'TenantID'. 15:30:33 - IsConnectionValid True 15:30:33 - SELECT DISTINCT * FROM VwLoansEntry WHERE TenantID = 1 AND TenantID = @val0 AND EmployeeID = @val1 AND UserID = @val2 Query 15:30:33 - (1-gen-1002) : Invalid column name 'TenantID'. Invalid column name 'TenantID'. 15:46:20 - IsConnectionValid True 15:46:22 - IsConnectionValid True 15:46:22 - IsConnectionValid True 15:46:22 - IsConnectionValid True 15:46:22 - SELECT DISTINCT * FROM VwLoans WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 15:46:22 - SELECT DISTINCT * FROM HRMS_vwEmployees WHERE TenantID = 1 AND TenantID = @val0 and CAST(DateLeft AS Date) = @val1 and UserID = @val2 ORDER BY ID Query 15:46:22 - SELECT DISTINCT * FROM VwLoansEntry WHERE TenantID = 1 AND TenantID = @val0 AND EmployeeID = @val1 AND UserID = @val2 Query 15:46:22 - (1-gen-1002) : Invalid column name 'TenantID'. Invalid column name 'TenantID'. 15:46:24 - IsConnectionValid True 15:46:24 - SELECT DISTINCT * FROM VwLoansEntry WHERE TenantID = 1 AND TenantID = @val0 AND EmployeeID = @val1 AND UserID = @val2 Query 15:46:24 - (1-gen-1002) : Invalid column name 'TenantID'. Invalid column name 'TenantID'. 15:46:33 - IsConnectionValid True 15:46:33 - (2-payroll-0010027) : Could not find stored procedure 'HRMS_Save_LoansEntry'. 15:47:57 - IsConnectionValid True 15:47:57 - (2-payroll-0010027) : Could not find stored procedure 'HRMS_Save_LoansEntry'. 15:54:16 - IsConnectionValid True 15:54:17 - IsConnectionValid True 15:54:17 - IsConnectionValid True 15:54:17 - IsConnectionValid True 15:54:17 - SELECT DISTINCT * FROM HRMS_vwEmployees WHERE TenantID = 1 AND TenantID = @val0 and CAST(DateLeft AS Date) = @val1 and UserID = @val2 ORDER BY ID Query 15:54:17 - SELECT DISTINCT * FROM VwLoans WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 15:54:17 - SELECT DISTINCT * FROM VwLoansEntry WHERE TenantID = 1 AND TenantID = @val0 AND EmployeeID = @val1 AND UserID = @val2 Query 15:54:17 - (1-gen-1002) : Invalid column name 'TenantID'. Invalid column name 'TenantID'. 15:56:01 - IsConnectionValid True 15:56:02 - IsConnectionValid True 15:56:02 - IsConnectionValid True 15:56:02 - IsConnectionValid True 15:56:02 - SELECT DISTINCT * FROM HRMS_vwEmployees WHERE TenantID = 1 AND TenantID = @val0 and CAST(DateLeft AS Date) = @val1 and UserID = @val2 ORDER BY ID Query 15:56:02 - SELECT DISTINCT * FROM VwLoans WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 15:56:02 - SELECT DISTINCT * FROM VwLoansEntry WHERE TenantID = 1 AND TenantID = @val0 AND EmployeeID = @val1 AND UserID = @val2 Query 15:56:02 - (1-gen-1002) : Invalid column name 'TenantID'. Invalid column name 'TenantID'. 16:00:08 - IsConnectionValid True 16:00:10 - IsConnectionValid True 16:00:10 - IsConnectionValid True 16:00:10 - IsConnectionValid True 16:00:10 - SELECT DISTINCT * FROM VwLoansEntry WHERE TenantID = 1 AND TenantID = @val0 AND EmployeeID = @val1 AND UserID = @val2 Query 16:00:10 - SELECT DISTINCT * FROM VwLoans WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 16:00:10 - SELECT DISTINCT * FROM HRMS_vwEmployees WHERE TenantID = 1 AND TenantID = @val0 and CAST(DateLeft AS Date) = @val1 and UserID = @val2 ORDER BY ID Query 16:00:10 - (1-gen-1002) : Invalid column name 'TenantID'. Invalid column name 'TenantID'. 16:00:21 - IsConnectionValid True 16:00:21 - SELECT DISTINCT * FROM VwLoansEntry WHERE TenantID = 1 AND TenantID = @val0 AND EmployeeID = @val1 AND UserID = @val2 Query 16:00:21 - (1-gen-1002) : Invalid column name 'TenantID'. Invalid column name 'TenantID'. 16:00:37 - IsConnectionValid True 16:00:39 - IsConnectionValid True 16:00:39 - finalQuery ;WITH CTE AS (SELECT ROW_NUMBER() OVER ( ORDER BY ID) AS rn, COUNT(*) OVER() AS _total, * FROM (SELECT DISTINCT * FROM Projects WHERE TenantID = 1 AND TenantID = @val0 ) SUB) SELECT * FROM CTE WHERE rn > @startRow AND rn <= @endRow 16:01:11 - IsConnectionValid True 16:01:12 - IsConnectionValid True 16:01:14 - IsConnectionValid True 16:01:14 - IsConnectionValid True 16:01:15 - IsConnectionValid True 16:01:15 - IsConnectionValid True 16:01:19 - IsConnectionValid True 16:01:21 - IsConnectionValid True 16:01:21 - IsConnectionValid True 16:01:21 - IsConnectionValid True 16:01:21 - SELECT DISTINCT * FROM HRMS_vwEmployees WHERE TenantID = 1 AND TenantID = @val0 and CAST(DateLeft AS Date) = @val1 and UserID = @val2 ORDER BY ID Query 16:01:21 - SELECT DISTINCT * FROM VwLoansEntry WHERE TenantID = 1 AND TenantID = @val0 AND EmployeeID = @val1 AND UserID = @val2 Query 16:01:21 - SELECT DISTINCT * FROM VwLoans WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 16:01:22 - (1-gen-1002) : Invalid column name 'TenantID'. Invalid column name 'TenantID'. 16:01:34 - IsConnectionValid True 16:01:35 - IsConnectionValid True 16:01:35 - IsConnectionValid True 16:01:35 - IsConnectionValid True 16:01:35 - SELECT DISTINCT * FROM HRMS_vwEmployees WHERE TenantID = 1 AND TenantID = @val0 and CAST(DateLeft AS Date) = @val1 and UserID = @val2 ORDER BY ID Query 16:01:35 - SELECT DISTINCT * FROM VwLoans WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 16:01:35 - SELECT DISTINCT * FROM VwLoansEntry WHERE TenantID = 1 AND TenantID = @val0 AND EmployeeID = @val1 AND UserID = @val2 Query 16:01:35 - (1-gen-1002) : Invalid column name 'TenantID'. Invalid column name 'TenantID'. 16:05:54 - IsConnectionValid True 16:05:55 - IsConnectionValid True 16:05:55 - IsConnectionValid True 16:05:55 - IsConnectionValid True 16:05:55 - SELECT DISTINCT * FROM VwLoans WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 16:05:55 - SELECT DISTINCT * FROM VwLoansEntry WHERE TenantID = 1 AND TenantID = @val0 AND EmployeeID = @val1 AND UserID = @val2 Query 16:05:55 - SELECT DISTINCT * FROM HRMS_vwEmployees WHERE TenantID = 1 AND TenantID = @val0 and CAST(DateLeft AS Date) = @val1 and UserID = @val2 ORDER BY ID Query 16:05:56 - (1-gen-1002) : Invalid column name 'TenantID'. Invalid column name 'TenantID'. 16:05:57 - IsConnectionValid True 16:05:57 - SELECT DISTINCT * FROM VwLoansEntry WHERE TenantID = 1 AND TenantID = @val0 AND EmployeeID = @val1 AND UserID = @val2 Query 16:05:57 - (1-gen-1002) : Invalid column name 'TenantID'. Invalid column name 'TenantID'. 16:06:05 - IsConnectionValid True 16:06:05 - (2-payroll-0010027) : Procedure or function 'HRMS_Save_LoansEntry' expects parameter '@Description', which was not supplied. 16:06:26 - IsConnectionValid True 16:06:26 - (2-payroll-0010027) : Cannot insert the value NULL into column 'ID', table 'HRMSystemICS_Live.dbo.LoansEntry'; column does not allow nulls. INSERT fails. 16:07:05 - IsConnectionValid True 16:07:05 - (2-payroll-0010027) : Cannot insert the value NULL into column 'ID', table 'HRMSystemICS_Live.dbo.LoansEntry'; column does not allow nulls. INSERT fails. 16:07:43 - IsConnectionValid True 16:07:43 - (2-payroll-0010027) : Object reference not set to an instance of an object. 16:07:52 - IsConnectionValid True 16:07:52 - (2-payroll-0010027) : Object reference not set to an instance of an object. 16:10:40 - IsConnectionValid True 16:10:40 - IsConnectionValid True 16:10:40 - SELECT DISTINCT * FROM VwLoansEntry WHERE TenantID = 1 AND TenantID = @val0 AND EmployeeID = @val1 AND UserID = @val2 Query 16:10:40 - (1-gen-1002) : Invalid column name 'TenantID'. Invalid column name 'TenantID'. 16:10:45 - IsConnectionValid True 16:10:46 - IsConnectionValid True 16:10:46 - IsConnectionValid True 16:10:46 - IsConnectionValid True 16:10:46 - SELECT DISTINCT * FROM HRMS_vwEmployees WHERE TenantID = 1 AND TenantID = @val0 and CAST(DateLeft AS Date) = @val1 and UserID = @val2 ORDER BY ID Query 16:10:46 - SELECT DISTINCT * FROM VwLoansEntry WHERE TenantID = 1 AND TenantID = @val0 AND EmployeeID = @val1 AND UserID = @val2 Query 16:10:46 - SELECT DISTINCT * FROM VwLoans WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 16:10:46 - (1-gen-1002) : Invalid column name 'TenantID'. Invalid column name 'TenantID'. 16:10:48 - IsConnectionValid True 16:10:48 - SELECT DISTINCT * FROM VwLoansEntry WHERE TenantID = 1 AND TenantID = @val0 AND EmployeeID = @val1 AND UserID = @val2 Query 16:10:48 - (1-gen-1002) : Invalid column name 'TenantID'. Invalid column name 'TenantID'. 16:10:50 - IsConnectionValid True 16:10:51 - IsConnectionValid True 16:10:51 - IsConnectionValid True 16:10:51 - IsConnectionValid True 16:10:51 - SELECT DISTINCT * FROM HRMS_vwEmployees WHERE TenantID = 1 AND TenantID = @val0 and CAST(DateLeft AS Date) = @val1 and UserID = @val2 ORDER BY ID Query 16:10:51 - SELECT DISTINCT * FROM VwLoans WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 16:10:51 - SELECT DISTINCT * FROM VwLoansEntry WHERE TenantID = 1 AND TenantID = @val0 AND EmployeeID = @val1 AND UserID = @val2 Query 16:10:51 - (1-gen-1002) : Invalid column name 'TenantID'. Invalid column name 'TenantID'. 16:13:10 - IsConnectionValid True 16:13:10 - SELECT DISTINCT * FROM VwLoansEntry WHERE TenantID = 1 AND TenantID = @val0 AND EmployeeID = @val1 AND UserID = @val2 Query 16:13:10 - (1-gen-1002) : Invalid column name 'TenantID'. Invalid column name 'TenantID'. 16:13:22 - IsConnectionValid True 16:13:22 - SELECT DISTINCT * FROM VwLoansEntry WHERE TenantID = 1 AND TenantID = @val0 AND EmployeeID = @val1 AND UserID = @val2 Query 16:13:22 - (1-gen-1002) : Invalid column name 'TenantID'. Invalid column name 'TenantID'. 16:13:24 - IsConnectionValid True 16:13:24 - SELECT DISTINCT * FROM VwLoansEntry WHERE TenantID = 1 AND TenantID = @val0 AND EmployeeID = @val1 AND UserID = @val2 Query 16:13:24 - (1-gen-1002) : Invalid column name 'TenantID'. Invalid column name 'TenantID'. 16:13:42 - IsConnectionValid True 16:13:42 - SELECT DISTINCT * FROM VwLoansEntry WHERE TenantID = 1 AND TenantID = @val0 AND EmployeeID = @val1 AND UserID = @val2 Query 16:13:43 - IsConnectionValid True 16:13:43 - SELECT DISTINCT * FROM VwLoansEntry WHERE TenantID = 1 AND TenantID = @val0 AND EmployeeID = @val1 AND UserID = @val2 Query 16:15:56 - IsConnectionValid True 16:15:56 - SELECT DISTINCT * FROM VwLoansEntry WHERE TenantID = 1 AND TenantID = @val0 AND EmployeeID = @val1 AND UserID = @val2 Query 16:15:58 - IsConnectionValid True 16:16:01 - IsConnectionValid True 16:16:01 - IsConnectionValid True 16:16:01 - IsConnectionValid True 16:16:01 - SELECT DISTINCT * FROM HRMS_vwEmployees WHERE TenantID = 1 AND TenantID = @val0 and CAST(DateLeft AS Date) = @val1 and UserID = @val2 ORDER BY ID Query 16:16:01 - SELECT DISTINCT * FROM VwLoansEntry WHERE TenantID = 1 AND TenantID = @val0 AND EmployeeID = @val1 AND UserID = @val2 Query 16:16:01 - SELECT DISTINCT * FROM VwLoans WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 16:16:04 - IsConnectionValid True 16:16:04 - SELECT DISTINCT * FROM VwLoansEntry WHERE TenantID = 1 AND TenantID = @val0 AND EmployeeID = @val1 AND UserID = @val2 Query 16:20:05 - IsConnectionValid True 16:20:08 - IsConnectionValid True 16:20:08 - IsConnectionValid True 16:20:08 - IsConnectionValid True 16:20:08 - SELECT DISTINCT * FROM VwLoansEntry WHERE TenantID = 1 AND TenantID = @val0 AND EmployeeID = @val1 AND UserID = @val2 Query 16:20:08 - SELECT DISTINCT * FROM VwLoans WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 16:20:08 - SELECT DISTINCT * FROM HRMS_vwEmployees WHERE TenantID = 1 AND TenantID = @val0 and CAST(DateLeft AS Date) = @val1 and UserID = @val2 ORDER BY ID Query 16:20:09 - IsConnectionValid True 16:20:09 - SELECT DISTINCT * FROM VwLoansEntry WHERE TenantID = 1 AND TenantID = @val0 AND EmployeeID = @val1 AND UserID = @val2 Query 16:20:19 - IsConnectionValid True 16:20:20 - IsConnectionValid True 16:20:20 - SELECT DISTINCT * FROM VwLoansEntry WHERE TenantID = 1 AND TenantID = @val0 AND EmployeeID = @val1 AND UserID = @val2 Query 16:25:36 - IsConnectionValid True 16:25:39 - IsConnectionValid True 16:25:39 - IsConnectionValid True 16:25:39 - IsConnectionValid True 16:25:39 - SELECT DISTINCT * FROM HRMS_vwEmployees WHERE TenantID = 1 AND TenantID = @val0 and CAST(DateLeft AS Date) = @val1 and UserID = @val2 ORDER BY ID Query 16:25:39 - SELECT DISTINCT * FROM VwLoans WHERE TenantID = 1 AND TenantID = @val0 ORDER BY ID Query 16:25:39 - SELECT DISTINCT * FROM VwLoansEntry WHERE TenantID = 1 AND TenantID = @val0 AND EmployeeID = @val1 AND UserID = @val2 Query 16:26:49 - IsConnectionValid True