Time: 25/07/2026 03:49:34 PM PageName: Employee_EmployeeRegistrationVerification String str: SELECT Count(1) AS Nos0 FROM EmployeeRegistrationDetail WHERE EmployeeId='EMP00170' ; SELECT Count(1) AS Nos1 FROM UserLoginDetail WHERE UserLoginId='EMP00170' ; String sql: INSERT INTO EmployeeRegistrationDetail ( BranchId, BranchName, EmployeeId, EmployeeName, EmployeeSalutation, DepartmentName, DesignationName, ReportingOfficerId, ReportingOfficerName, EmployeeType, EmployeeGrade, EmployeeIdType, EmpJoinDate, GuardianSalutation, GuardianName, EmployeeMobileNo, EmployeeContactNo, EmployeeEmailId, EmployeeDOB, EmployeeGender,EmployeeBloodGroup, EmployeeReligion, EmployeeCategory, MaritalStatus, DateOfMarriage, SpouseName, Qualification, RelevantExperience, PreviousEmployment, DocumentSubmitted, LiabilityHeadId, LiabilityHeadName, ExpenceHeadId, ExpenceHeadName, AdvanceHeadId, AdvanceHeadName, RegStatus, SalaryStatus, AttendanceStatus, GroupLoanTeam, PermanentAddress, PermanentCity, PermanentStateName, PermanentDistrictName, PermanentPinCode, SameAsPostal, PostalAddress, PostalCity, PostalStateName, PostalDistrictName, PostalPinCode, BankAccountType, BankAccountNo, BankIFSCCode, BankName, BankBranch, AadharNo, AadharVerified, PANNo, PANVerified, VoterIdNo, VoterIdVerified, DLNo, PFAccountNo, PFUANNo, ESINo, AttInHH, AttInMM, AttOutHH, AttOutMM, EntryUser, EntryTime ) VALUES ( '101', 'Lucknow', 'EMP00170', 'Anshu Kumar', 'Mr.', 'Finance', 'Asst. Manager Account', 'EMP00107', 'Saurya Singh', 'FullTime', 'Grade-03', 'Software', '7/25/2026 12:00:00 AM', 'S/O', 'Rajesh Kumar', '6355885645', '', 'Mehta@gmail.com', '7/11/1997 12:00:00 AM', 'Male','Select', 'Hindu', 'OBC', 'Married', '1/1/1900 12:00:00 AM', '', 'B tech', '', '', '', '311000', 'Employee Salary Payable - 311000', '711000', 'Employee Salary Expence - 711000', '116100', 'Advance To Employee (Salary Advance) - 116100', 'Approved', 'Active', 'Active', 'Yes', 'Allahabad Uttar Pradesh', 'Allahabad', 'Bihar', 'Hajipur', '266001', 'Yes', 'Allahabad Uttar Pradesh', 'Allahabad', 'Bihar', 'Hajipur', '266001', 'Saving', '', '', '', '', '','','','', '', '','', '', '', '', '7','00','17','00', 'root', GETDATE() ) ; INSERT INTO UserLoginDetail ( UserLoginId, UserPassword, UserRole, UserLoginStatus, UserWebLogin, UserEXELogin, UserMenuType, EmployeeId, BranchId, BranchName, UserWorkingDate, NoOfBackDate, UserName, UserMobileNo, UserEmailId, UserAddress, UserJoinDate, EntryUser, EntryTime ) VALUES ( 'EMP00170', 'RQBNAFAAMAAwADEANwAwAA==', 'SubAdmin', 'Active', 'Active', 'Active', null, 'EMP00170', '101', 'Lucknow', '7/25/2026 12:00:00 AM', '0', 'Anshu Kumar', '6355885645', 'Mehta@gmail.com', 'Allahabad Uttar Pradesh', '7/25/2026 12:00:00 AM', 'root', GETDATE() ) ; INSERT INTO BranchPermission ( UserId, BranchId, EntryUser, EntryTime ) VALUES ( 'EMP00170', '101', 'root', GETDATE() ) ; Data: System.Collections.ListDictionaryInternal HelpLink: InnerException: Message: Invalid column name 'UserMenuType'. Source: .Net SqlClient Data Provider StackTrace: at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose) at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady) at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async, Int32 timeout, Boolean asyncWrite) at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(TaskCompletionSource`1 completion, String methodName, Boolean sendToPipe, Int32 timeout, Boolean& usedCache, Boolean asyncWrite, Boolean inRetry) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at Employee_EmployeeRegistrationVerification.btnSubmit_Click(Object sender, EventArgs e) TargetSite: Void OnError(System.Data.SqlClient.SqlException, Boolean, System.Action`1[System.Action]) Time: 25/07/2026 03:49:39 PM PageName: Employee_EmployeeRegistrationVerification String str: SELECT Count(1) AS Nos0 FROM EmployeeRegistrationDetail WHERE EmployeeId='EMP00170' ; SELECT Count(1) AS Nos1 FROM UserLoginDetail WHERE UserLoginId='EMP00170' ; String sql: INSERT INTO EmployeeRegistrationDetail ( BranchId, BranchName, EmployeeId, EmployeeName, EmployeeSalutation, DepartmentName, DesignationName, ReportingOfficerId, ReportingOfficerName, EmployeeType, EmployeeGrade, EmployeeIdType, EmpJoinDate, GuardianSalutation, GuardianName, EmployeeMobileNo, EmployeeContactNo, EmployeeEmailId, EmployeeDOB, EmployeeGender,EmployeeBloodGroup, EmployeeReligion, EmployeeCategory, MaritalStatus, DateOfMarriage, SpouseName, Qualification, RelevantExperience, PreviousEmployment, DocumentSubmitted, LiabilityHeadId, LiabilityHeadName, ExpenceHeadId, ExpenceHeadName, AdvanceHeadId, AdvanceHeadName, RegStatus, SalaryStatus, AttendanceStatus, GroupLoanTeam, PermanentAddress, PermanentCity, PermanentStateName, PermanentDistrictName, PermanentPinCode, SameAsPostal, PostalAddress, PostalCity, PostalStateName, PostalDistrictName, PostalPinCode, BankAccountType, BankAccountNo, BankIFSCCode, BankName, BankBranch, AadharNo, AadharVerified, PANNo, PANVerified, VoterIdNo, VoterIdVerified, DLNo, PFAccountNo, PFUANNo, ESINo, AttInHH, AttInMM, AttOutHH, AttOutMM, EntryUser, EntryTime ) VALUES ( '101', 'Lucknow', 'EMP00170', 'Anshu Kumar', 'Mr.', 'Finance', 'Asst. Manager Account', 'EMP00107', 'Saurya Singh', 'FullTime', 'Grade-03', 'Software', '7/25/2026 12:00:00 AM', 'S/O', 'Rajesh Kumar', '6355885645', '', 'Mehta@gmail.com', '7/11/1997 12:00:00 AM', 'Male','Select', 'Hindu', 'OBC', 'Married', '1/1/1900 12:00:00 AM', '', 'B tech', '', '', '', '311000', 'Employee Salary Payable - 311000', '711000', 'Employee Salary Expence - 711000', '116100', 'Advance To Employee (Salary Advance) - 116100', 'Approved', 'Active', 'Active', 'Yes', 'Allahabad Uttar Pradesh', 'Allahabad', 'Bihar', 'Hajipur', '266001', 'Yes', 'Allahabad Uttar Pradesh', 'Allahabad', 'Bihar', 'Hajipur', '266001', 'Saving', '', '', '', '', '','','','', '', '','', '', '', '', '7','00','17','00', 'root', GETDATE() ) ; INSERT INTO UserLoginDetail ( UserLoginId, UserPassword, UserRole, UserLoginStatus, UserWebLogin, UserEXELogin, UserMenuType, EmployeeId, BranchId, BranchName, UserWorkingDate, NoOfBackDate, UserName, UserMobileNo, UserEmailId, UserAddress, UserJoinDate, EntryUser, EntryTime ) VALUES ( 'EMP00170', 'RQBNAFAAMAAwADEANwAwAA==', 'SubAdmin', 'Active', 'Active', 'Active', null, 'EMP00170', '101', 'Lucknow', '7/25/2026 12:00:00 AM', '0', 'Anshu Kumar', '6355885645', 'Mehta@gmail.com', 'Allahabad Uttar Pradesh', '7/25/2026 12:00:00 AM', 'root', GETDATE() ) ; INSERT INTO BranchPermission ( UserId, BranchId, EntryUser, EntryTime ) VALUES ( 'EMP00170', '101', 'root', GETDATE() ) ; Data: System.Collections.ListDictionaryInternal HelpLink: InnerException: Message: Invalid column name 'UserMenuType'. Source: .Net SqlClient Data Provider StackTrace: at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose) at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady) at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async, Int32 timeout, Boolean asyncWrite) at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(TaskCompletionSource`1 completion, String methodName, Boolean sendToPipe, Int32 timeout, Boolean& usedCache, Boolean asyncWrite, Boolean inRetry) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at Employee_EmployeeRegistrationVerification.btnSubmit_Click(Object sender, EventArgs e) TargetSite: Void OnError(System.Data.SqlClient.SqlException, Boolean, System.Action`1[System.Action]) Time: 25/07/2026 04:00:15 PM PageName: Employee_EmployeeAttendancePunching String str: DECLARE @OnDate DATE, @EmpId VARCHAR(20); SET @OnDate='7/25/2026 12:00:00 AM'; SET @EmpId='root'; SELECT a.EmployeeId, a.EmployeeName, a.AttendanceStatus, isnull(a.AttInHH,9)AS AttInHH, isnull(a.AttInMM,0)AS AttInMM, isnull(a.AttOutHH,18)AS AttOutHH, isnull(a.AttOutMM,00)AS AttOutMM, (SELECT Count(1) FROM EmployeeAttendanceDetail WITH(nolock) WHERE AttDate=@OnDate AND EmployeeId=a.EmployeeId)AS AttExist, (SELECT datediff(minute,AttInTime,GETDATE()) FROM EmployeeAttendanceDetail WITH(nolock) WHERE AttDate=@OnDate AND EmployeeId=a.EmployeeId)AS AttInDuration FROM EmployeeRegistrationDetail a WITH(nolock) WHERE a.EmployeeId=@EmpId ; String sql: Data: System.Collections.ListDictionaryInternal HelpLink: InnerException: Message: There is no row at position 0. Source: System.Data StackTrace: at System.Data.RBTree`1.GetNodeByIndex(Int32 userIndex) at Employee_EmployeeAttendancePunching.btnSubmit_Click(Object sender, EventArgs e) TargetSite: NodePath GetNodeByIndex(Int32) Time: 25/07/2026 04:26:43 PM PageName: Employee_EmployeeSalaryGenerate String str: String sql: Data: System.Collections.ListDictionaryInternal HelpLink: InnerException: Message: String was not recognized as a valid DateTime. Source: mscorlib StackTrace: at System.DateTimeParse.Parse(String s, DateTimeFormatInfo dtfi, DateTimeStyles styles) at System.Convert.ToDateTime(String value) at DateConversion.DateHelper.ConvertDate(String s) at Employee_EmployeeSalaryGenerate.txtWorkingDate_TextChanged(Object sender, EventArgs e) TargetSite: System.DateTime Parse(System.String, System.Globalization.DateTimeFormatInfo, System.Globalization.DateTimeStyles) Time: 25/07/2026 04:26:43 PM PageName: Employee_EmployeeSalaryGenerate String str: String sql: Data: System.Collections.ListDictionaryInternal HelpLink: InnerException: Message: String was not recognized as a valid DateTime. Source: mscorlib StackTrace: at System.DateTimeParse.Parse(String s, DateTimeFormatInfo dtfi, DateTimeStyles styles) at System.Convert.ToDateTime(String value) at DateConversion.DateHelper.ConvertDate(String s) at Employee_EmployeeSalaryGenerate.txtWorkingDate_TextChanged(Object sender, EventArgs e) TargetSite: System.DateTime Parse(System.String, System.Globalization.DateTimeFormatInfo, System.Globalization.DateTimeStyles) Time: 25/07/2026 04:41:23 PM PageName: Employee_EmployeeSalaryPaymentMultiple String str: String sql: Data: System.Collections.ListDictionaryInternal HelpLink: InnerException: Message: String was not recognized as a valid DateTime. Source: mscorlib StackTrace: at System.DateTimeParse.Parse(String s, DateTimeFormatInfo dtfi, DateTimeStyles styles) at System.Convert.ToDateTime(String value) at DateConversion.DateHelper.ConvertDate(String s) at Employee_EmployeeSalaryPaymentMultiple.txtWorkingDate_TextChanged(Object sender, EventArgs e) TargetSite: System.DateTime Parse(System.String, System.Globalization.DateTimeFormatInfo, System.Globalization.DateTimeStyles) Time: 25/07/2026 04:41:23 PM PageName: Employee_EmployeeSalaryPaymentMultiple String str: String sql: Data: System.Collections.ListDictionaryInternal HelpLink: InnerException: Message: String was not recognized as a valid DateTime. Source: mscorlib StackTrace: at System.DateTimeParse.Parse(String s, DateTimeFormatInfo dtfi, DateTimeStyles styles) at System.Convert.ToDateTime(String value) at DateConversion.DateHelper.ConvertDate(String s) at Employee_EmployeeSalaryPaymentMultiple.txtWorkingDate_TextChanged(Object sender, EventArgs e) TargetSite: System.DateTime Parse(System.String, System.Globalization.DateTimeFormatInfo, System.Globalization.DateTimeStyles) Time: 25/07/2026 04:45:02 PM PageName: Employee_EmployeeSalaryAdvanceMultiple String str: String sql: Data: System.Collections.ListDictionaryInternal HelpLink: InnerException: Message: String was not recognized as a valid DateTime. Source: mscorlib StackTrace: at System.DateTimeParse.Parse(String s, DateTimeFormatInfo dtfi, DateTimeStyles styles) at System.Convert.ToDateTime(String value) at DateConversion.DateHelper.ConvertDate(String s) at Employee_EmployeeSalaryAdvanceMultiple.txtWorkingDate_TextChanged(Object sender, EventArgs e) TargetSite: System.DateTime Parse(System.String, System.Globalization.DateTimeFormatInfo, System.Globalization.DateTimeStyles) Time: 25/07/2026 04:45:02 PM PageName: Employee_EmployeeSalaryAdvanceMultiple String str: String sql: Data: System.Collections.ListDictionaryInternal HelpLink: InnerException: Message: String was not recognized as a valid DateTime. Source: mscorlib StackTrace: at System.DateTimeParse.Parse(String s, DateTimeFormatInfo dtfi, DateTimeStyles styles) at System.Convert.ToDateTime(String value) at DateConversion.DateHelper.ConvertDate(String s) at Employee_EmployeeSalaryAdvanceMultiple.txtWorkingDate_TextChanged(Object sender, EventArgs e) TargetSite: System.DateTime Parse(System.String, System.Globalization.DateTimeFormatInfo, System.Globalization.DateTimeStyles) Time: 25/07/2026 04:53:14 PM PageName: Employee_EmployeeRegistrationVerification String str: SELECT Count(1) AS Nos0 FROM EmployeeRegistrationDetail WHERE EmployeeId='EMP00170' ; SELECT Count(1) AS Nos1 FROM UserLoginDetail WHERE UserLoginId='EMP00170' ; String sql: INSERT INTO EmployeeRegistrationDetail ( BranchId, BranchName, EmployeeId, EmployeeName, EmployeeSalutation, DepartmentName, DesignationName, ReportingOfficerId, ReportingOfficerName, EmployeeType, EmployeeGrade, EmployeeIdType, EmpJoinDate, GuardianSalutation, GuardianName, EmployeeMobileNo, EmployeeContactNo, EmployeeEmailId, EmployeeDOB, EmployeeGender,EmployeeBloodGroup, EmployeeReligion, EmployeeCategory, MaritalStatus, DateOfMarriage, SpouseName, Qualification, RelevantExperience, PreviousEmployment, DocumentSubmitted, LiabilityHeadId, LiabilityHeadName, ExpenceHeadId, ExpenceHeadName, AdvanceHeadId, AdvanceHeadName, RegStatus, SalaryStatus, AttendanceStatus, GroupLoanTeam, PermanentAddress, PermanentCity, PermanentStateName, PermanentDistrictName, PermanentPinCode, SameAsPostal, PostalAddress, PostalCity, PostalStateName, PostalDistrictName, PostalPinCode, BankAccountType, BankAccountNo, BankIFSCCode, BankName, BankBranch, AadharNo, AadharVerified, PANNo, PANVerified, VoterIdNo, VoterIdVerified, DLNo, PFAccountNo, PFUANNo, ESINo, AttInHH, AttInMM, AttOutHH, AttOutMM, EntryUser, EntryTime ) VALUES ( '101', 'Lucknow', 'EMP00170', 'Anshu Kumar', 'Mr.', 'Finance', 'Asst. Manager HR', 'Admin999', 'Administrator', 'FullTime', 'Grade-03', 'Software', '7/25/2026 12:00:00 AM', 'S/O', 'Rajesh Kumar', '6355885645', '', 'Mehta@gmail.com', '7/11/1997 12:00:00 AM', 'Male','Select', 'Hindu', 'OBC', 'Married', '1/1/1900 12:00:00 AM', '', 'B tech', '', '', '', '311000', 'Employee Salary Payable - 311000', '711000', 'Employee Salary Expence - 711000', '116100', 'Advance To Employee (Salary Advance) - 116100', 'Approved', 'Active', 'Active', 'Yes', 'Allahabad Uttar Pradesh', 'Allahabad', 'Andaman & Nicobar', 'Port Blair', '266001', 'Yes', 'Allahabad Uttar Pradesh', 'Allahabad', 'Andaman & Nicobar', 'Port Blair', '266001', 'Saving', '', '', '', '', '','','','', '', '','', '', '', '', '7','00','17','00', 'root', GETDATE() ) ; INSERT INTO UserLoginDetail ( UserLoginId, UserPassword, UserRole, UserLoginStatus, UserWebLogin, UserEXELogin, UserMenuType, EmployeeId, BranchId, BranchName, UserWorkingDate, NoOfBackDate, UserName, UserMobileNo, UserEmailId, UserAddress, UserJoinDate, EntryUser, EntryTime ) VALUES ( 'EMP00170', 'RQBNAFAAMAAwADEANwAwAA==', 'Admin', 'Active', 'Active', 'Active', null, 'EMP00170', '101', 'Lucknow', '7/25/2026 12:00:00 AM', '0', 'Anshu Kumar', '6355885645', 'Mehta@gmail.com', 'Allahabad Uttar Pradesh', '7/25/2026 12:00:00 AM', 'root', GETDATE() ) ; INSERT INTO BranchPermission ( UserId, BranchId, EntryUser, EntryTime ) VALUES ( 'EMP00170', '101', 'root', GETDATE() ) ; Data: System.Collections.ListDictionaryInternal HelpLink: InnerException: Message: Invalid column name 'UserMenuType'. Source: .Net SqlClient Data Provider StackTrace: at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose) at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady) at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async, Int32 timeout, Boolean asyncWrite) at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(TaskCompletionSource`1 completion, String methodName, Boolean sendToPipe, Int32 timeout, Boolean& usedCache, Boolean asyncWrite, Boolean inRetry) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at Employee_EmployeeRegistrationVerification.btnSubmit_Click(Object sender, EventArgs e) TargetSite: Void OnError(System.Data.SqlClient.SqlException, Boolean, System.Action`1[System.Action]) Time: 25/07/2026 04:53:59 PM PageName: Employee_EmployeeRegistrationVerification String str: SELECT Count(1) AS Nos0 FROM EmployeeRegistrationDetail WHERE EmployeeId='EMP00170' ; SELECT Count(1) AS Nos1 FROM UserLoginDetail WHERE UserLoginId='EMP00170' ; String sql: INSERT INTO EmployeeRegistrationDetail ( BranchId, BranchName, EmployeeId, EmployeeName, EmployeeSalutation, DepartmentName, DesignationName, ReportingOfficerId, ReportingOfficerName, EmployeeType, EmployeeGrade, EmployeeIdType, EmpJoinDate, GuardianSalutation, GuardianName, EmployeeMobileNo, EmployeeContactNo, EmployeeEmailId, EmployeeDOB, EmployeeGender,EmployeeBloodGroup, EmployeeReligion, EmployeeCategory, MaritalStatus, DateOfMarriage, SpouseName, Qualification, RelevantExperience, PreviousEmployment, DocumentSubmitted, LiabilityHeadId, LiabilityHeadName, ExpenceHeadId, ExpenceHeadName, AdvanceHeadId, AdvanceHeadName, RegStatus, SalaryStatus, AttendanceStatus, GroupLoanTeam, PermanentAddress, PermanentCity, PermanentStateName, PermanentDistrictName, PermanentPinCode, SameAsPostal, PostalAddress, PostalCity, PostalStateName, PostalDistrictName, PostalPinCode, BankAccountType, BankAccountNo, BankIFSCCode, BankName, BankBranch, AadharNo, AadharVerified, PANNo, PANVerified, VoterIdNo, VoterIdVerified, DLNo, PFAccountNo, PFUANNo, ESINo, AttInHH, AttInMM, AttOutHH, AttOutMM, EntryUser, EntryTime ) VALUES ( '101', 'Lucknow', 'EMP00170', 'Anshu Kumar', 'Mr.', 'Finance', 'Asst. Manager HR', 'Admin999', 'Administrator', 'FullTime', 'Grade-03', 'Software', '7/25/2026 12:00:00 AM', 'S/O', 'Rajesh Kumar', '', '', 'Mehta@gmail.com', '7/11/1997 12:00:00 AM', 'Male','Select', 'Hindu', 'OBC', 'Married', '1/1/1900 12:00:00 AM', '', 'B tech', '', '', '', '311000', 'Employee Salary Payable - 311000', '711000', 'Employee Salary Expence - 711000', '116100', 'Advance To Employee (Salary Advance) - 116100', 'Approved', 'Active', 'Active', 'Yes', 'Allahabad Uttar Pradesh', 'Allahabad', 'Andaman & Nicobar', 'Port Blair', '266001', 'Yes', 'Allahabad Uttar Pradesh', 'Allahabad', 'Andaman & Nicobar', 'Port Blair', '266001', 'Saving', '', '', '', '', '','','','', '', '','', '', '', '', '7','00','17','00', 'root', GETDATE() ) ; INSERT INTO UserLoginDetail ( UserLoginId, UserPassword, UserRole, UserLoginStatus, UserWebLogin, UserEXELogin, UserMenuType, EmployeeId, BranchId, BranchName, UserWorkingDate, NoOfBackDate, UserName, UserMobileNo, UserEmailId, UserAddress, UserJoinDate, EntryUser, EntryTime ) VALUES ( 'EMP00170', 'RQBNAFAAMAAwADEANwAwAA==', 'Admin', 'Active', 'Active', 'Active', null, 'EMP00170', '101', 'Lucknow', '7/25/2026 12:00:00 AM', '0', 'Anshu Kumar', '', 'Mehta@gmail.com', 'Allahabad Uttar Pradesh', '7/25/2026 12:00:00 AM', 'root', GETDATE() ) ; INSERT INTO BranchPermission ( UserId, BranchId, EntryUser, EntryTime ) VALUES ( 'EMP00170', '101', 'root', GETDATE() ) ; Data: System.Collections.ListDictionaryInternal HelpLink: InnerException: Message: Invalid column name 'UserMenuType'. Source: .Net SqlClient Data Provider StackTrace: at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose) at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady) at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async, Int32 timeout, Boolean asyncWrite) at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(TaskCompletionSource`1 completion, String methodName, Boolean sendToPipe, Int32 timeout, Boolean& usedCache, Boolean asyncWrite, Boolean inRetry) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at Employee_EmployeeRegistrationVerification.btnSubmit_Click(Object sender, EventArgs e) TargetSite: Void OnError(System.Data.SqlClient.SqlException, Boolean, System.Action`1[System.Action]) Time: 25/07/2026 06:06:07 PM PageName: Employee_PrintRDLCPage String str: SELECT (SELECT ReportValue FROM ProjectReportSetting WITH(nolock) WHERE ReportName='CompanyURL')+'ResponsiveCSS/images/EmployeeIDCardBackImage.jpg' AS C1, (SELECT ReportValue AS EmployeeIDCardBackRDLC FROM ProjectReportSetting WITH(nolock) WHERE ReportName='EmployeeIDCardBackRDLC')AS C95 FROM EmployeeRegistrationDetail a WITH(nolock) WHERE a.EmployeeId='EMP00101' ; String sql: Data: System.Collections.ListDictionaryInternal HelpLink: InnerException: Message: Thread was being aborted. Source: mscorlib StackTrace: at System.Threading.Thread.AbortInternal() at System.Threading.Thread.Abort(Object stateInfo) at System.Web.HttpResponse.AbortCurrentThread() at Employee_PrintRDLCPage.EmployeeAppointmentLetter() TargetSite: Void AbortInternal() Time: 25/07/2026 06:06:07 PM PageName: Employee_PrintRDLCPage String str: SELECT (SELECT ReportValue FROM ProjectReportSetting WITH(nolock) WHERE ReportName='CompanyURL')+'ResponsiveCSS/images/EmployeeIDCardBackImage.jpg' AS C1, (SELECT ReportValue AS EmployeeIDCardBackRDLC FROM ProjectReportSetting WITH(nolock) WHERE ReportName='EmployeeIDCardBackRDLC')AS C95 FROM EmployeeRegistrationDetail a WITH(nolock) WHERE a.EmployeeId='EMP00101' ; String sql: Data: System.Collections.ListDictionaryInternal HelpLink: InnerException: Message: Thread was being aborted. Source: App_Web_0x1uk3ae StackTrace: at Employee_PrintRDLCPage.EmployeeAppointmentLetter() at Employee_PrintRDLCPage.Page_Load(Object sender, EventArgs e) TargetSite: Void EmployeeAppointmentLetter() Time: 25/07/2026 06:14:06 PM PageName: DataTableResult String str: SELECT a.SrNo,a.BranchName+' ('+a.BranchId+')'AS BranchName, a.DepartmentName, a.DesignationName, a.OldDesignationName, a.EmployeeId, a.EmployeeName, a.GuardianName, Convert(CHAR,a.PermotionDate,106)AS PermotionDate, a.OldSalaryPerMonth, a.NewSalaryPerMonth, a.ReportingOfficerName, a.PermotionRemark, a.EntryUser, Convert(CHAR,a.EntryTime,106)AS EntryTime, (SELECT ReportValue FROM ProjectReportSetting WITH(nolock) WHERE ReportName='EmployeePromotionLetterHTML')+'?EmployeeId='+a.EmployeeId AS EmployeePromotionLetterHTML, 'Employee_PrintRDLCPage.aspx?Report=' + (SELECT ReportValue FROM ProjectReportSetting WITH(nolock)WHERE ReportName='EmployeePromotionLetter')+'&EmployeeId='+a.EmployeeId AS EmployeePromotionLetter FROM EmployeePromotionLetterDetail a WITH(nolock) WHERE 1=1 AND a.EntryTime<'7/26/2026 12:00:00 AM' AND a.BranchId IN ('100','102','101','104','105','103') ORDER BY a.BranchName, a.EmployeeName String sql: Data: System.Collections.ListDictionaryInternal HelpLink: InnerException: Message: Invalid column name 'OldSalaryPerMonth'. Invalid column name 'NewSalaryPerMonth'. Invalid column name 'PermotionRemark'. Source: .Net SqlClient Data Provider StackTrace: at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose) at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady) at System.Data.SqlClient.SqlDataReader.TryConsumeMetaData() at System.Data.SqlClient.SqlDataReader.get_MetaData() at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString, Boolean isInternal, Boolean forDescribeParameterEncryption, Boolean shouldCacheForAlwaysEncrypted) at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async, Int32 timeout, Task& task, Boolean asyncWrite, Boolean inRetry, SqlDataReader ds, Boolean describeParameterEncryptionRequest) at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, TaskCompletionSource`1 completion, Int32 timeout, Task& task, Boolean& usedCache, Boolean asyncWrite, Boolean inRetry) at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method) at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior, String method) at System.Data.Common.DbDataAdapter.FillInternal(DataSet dataset, DataTable[] datatables, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior) at System.Data.Common.DbDataAdapter.Fill(DataTable[] dataTables, Int32 startRecord, Int32 maxRecords, IDbCommand command, CommandBehavior behavior) at System.Data.Common.DbDataAdapter.Fill(DataTable dataTable) at ClassMaster.DataTableResult(String query) TargetSite: Void OnError(System.Data.SqlClient.SqlException, Boolean, System.Action`1[System.Action]) Time: 25/07/2026 06:14:06 PM PageName: Employee_EmployeePromotionLetterList String str: SELECT a.SrNo,a.BranchName+' ('+a.BranchId+')'AS BranchName, a.DepartmentName, a.DesignationName, a.OldDesignationName, a.EmployeeId, a.EmployeeName, a.GuardianName, Convert(CHAR,a.PermotionDate,106)AS PermotionDate, a.OldSalaryPerMonth, a.NewSalaryPerMonth, a.ReportingOfficerName, a.PermotionRemark, a.EntryUser, Convert(CHAR,a.EntryTime,106)AS EntryTime, (SELECT ReportValue FROM ProjectReportSetting WITH(nolock) WHERE ReportName='EmployeePromotionLetterHTML')+'?EmployeeId='+a.EmployeeId AS EmployeePromotionLetterHTML, 'Employee_PrintRDLCPage.aspx?Report=' + (SELECT ReportValue FROM ProjectReportSetting WITH(nolock)WHERE ReportName='EmployeePromotionLetter')+'&EmployeeId='+a.EmployeeId AS EmployeePromotionLetter FROM EmployeePromotionLetterDetail a WITH(nolock) WHERE 1=1 AND a.EntryTime<'7/26/2026 12:00:00 AM' AND a.BranchId IN ('100','102','101','104','105','103') ORDER BY a.BranchName, a.EmployeeName String sql: Data: System.Collections.ListDictionaryInternal HelpLink: InnerException: Message: Object reference not set to an instance of an object. Source: App_Web_dierghye StackTrace: at Employee_EmployeePromotionLetterList.btnSearch_Click(Object sender, EventArgs e) TargetSite: Void btnSearch_Click(System.Object, System.EventArgs) Time: 25/07/2026 06:14:15 PM PageName: DataTableResult String str: SELECT a.SrNo,a.BranchName+' ('+a.BranchId+')'AS BranchName, a.DepartmentName, a.DesignationName, a.OldDesignationName, a.EmployeeId, a.EmployeeName, a.GuardianName, Convert(CHAR,a.PermotionDate,106)AS PermotionDate, a.OldSalaryPerMonth, a.NewSalaryPerMonth, a.ReportingOfficerName, a.PermotionRemark, a.EntryUser, Convert(CHAR,a.EntryTime,106)AS EntryTime, (SELECT ReportValue FROM ProjectReportSetting WITH(nolock) WHERE ReportName='EmployeePromotionLetterHTML')+'?EmployeeId='+a.EmployeeId AS EmployeePromotionLetterHTML, 'Employee_PrintRDLCPage.aspx?Report=' + (SELECT ReportValue FROM ProjectReportSetting WITH(nolock)WHERE ReportName='EmployeePromotionLetter')+'&EmployeeId='+a.EmployeeId AS EmployeePromotionLetter FROM EmployeePromotionLetterDetail a WITH(nolock) WHERE 1=1 AND a.EntryTime<'7/26/2026 12:00:00 AM' AND a.BranchId IN ('100','102','101','104','105','103') ORDER BY a.BranchName, a.EmployeeName String sql: Data: System.Collections.ListDictionaryInternal HelpLink: InnerException: Message: Invalid column name 'OldSalaryPerMonth'. Invalid column name 'NewSalaryPerMonth'. Invalid column name 'PermotionRemark'. Source: .Net SqlClient Data Provider StackTrace: at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose) at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady) at System.Data.SqlClient.SqlDataReader.TryConsumeMetaData() at System.Data.SqlClient.SqlDataReader.get_MetaData() at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString, Boolean isInternal, Boolean forDescribeParameterEncryption, Boolean shouldCacheForAlwaysEncrypted) at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async, Int32 timeout, Task& task, Boolean asyncWrite, Boolean inRetry, SqlDataReader ds, Boolean describeParameterEncryptionRequest) at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, TaskCompletionSource`1 completion, Int32 timeout, Task& task, Boolean& usedCache, Boolean asyncWrite, Boolean inRetry) at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method) at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior, String method) at System.Data.Common.DbDataAdapter.FillInternal(DataSet dataset, DataTable[] datatables, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior) at System.Data.Common.DbDataAdapter.Fill(DataTable[] dataTables, Int32 startRecord, Int32 maxRecords, IDbCommand command, CommandBehavior behavior) at System.Data.Common.DbDataAdapter.Fill(DataTable dataTable) at ClassMaster.DataTableResult(String query) TargetSite: Void OnError(System.Data.SqlClient.SqlException, Boolean, System.Action`1[System.Action]) Time: 25/07/2026 06:14:15 PM PageName: Employee_EmployeePromotionLetterList String str: SELECT a.SrNo,a.BranchName+' ('+a.BranchId+')'AS BranchName, a.DepartmentName, a.DesignationName, a.OldDesignationName, a.EmployeeId, a.EmployeeName, a.GuardianName, Convert(CHAR,a.PermotionDate,106)AS PermotionDate, a.OldSalaryPerMonth, a.NewSalaryPerMonth, a.ReportingOfficerName, a.PermotionRemark, a.EntryUser, Convert(CHAR,a.EntryTime,106)AS EntryTime, (SELECT ReportValue FROM ProjectReportSetting WITH(nolock) WHERE ReportName='EmployeePromotionLetterHTML')+'?EmployeeId='+a.EmployeeId AS EmployeePromotionLetterHTML, 'Employee_PrintRDLCPage.aspx?Report=' + (SELECT ReportValue FROM ProjectReportSetting WITH(nolock)WHERE ReportName='EmployeePromotionLetter')+'&EmployeeId='+a.EmployeeId AS EmployeePromotionLetter FROM EmployeePromotionLetterDetail a WITH(nolock) WHERE 1=1 AND a.EntryTime<'7/26/2026 12:00:00 AM' AND a.BranchId IN ('100','102','101','104','105','103') ORDER BY a.BranchName, a.EmployeeName String sql: Data: System.Collections.ListDictionaryInternal HelpLink: InnerException: Message: Object reference not set to an instance of an object. Source: App_Web_dierghye StackTrace: at Employee_EmployeePromotionLetterList.btnSearch_Click(Object sender, EventArgs e) TargetSite: Void btnSearch_Click(System.Object, System.EventArgs) Time: 25/07/2026 06:14:21 PM PageName: DataTableResult String str: SELECT a.SrNo,a.BranchName+' ('+a.BranchId+')'AS BranchName, a.DepartmentName, a.DesignationName, a.OldDesignationName, a.EmployeeId, a.EmployeeName, a.GuardianName, Convert(CHAR,a.PermotionDate,106)AS PermotionDate, a.OldSalaryPerMonth, a.NewSalaryPerMonth, a.ReportingOfficerName, a.PermotionRemark, a.EntryUser, Convert(CHAR,a.EntryTime,106)AS EntryTime, (SELECT ReportValue FROM ProjectReportSetting WITH(nolock) WHERE ReportName='EmployeePromotionLetterHTML')+'?EmployeeId='+a.EmployeeId AS EmployeePromotionLetterHTML, 'Employee_PrintRDLCPage.aspx?Report=' + (SELECT ReportValue FROM ProjectReportSetting WITH(nolock)WHERE ReportName='EmployeePromotionLetter')+'&EmployeeId='+a.EmployeeId AS EmployeePromotionLetter FROM EmployeePromotionLetterDetail a WITH(nolock) WHERE 1=1 AND a.EntryTime>='2/22/2026 12:00:00 AM' AND a.EntryTime<'7/26/2026 12:00:00 AM' AND a.BranchId IN ('100','102','101','104','105','103') ORDER BY a.BranchName, a.EmployeeName String sql: Data: System.Collections.ListDictionaryInternal HelpLink: InnerException: Message: Invalid column name 'OldSalaryPerMonth'. Invalid column name 'NewSalaryPerMonth'. Invalid column name 'PermotionRemark'. Source: .Net SqlClient Data Provider StackTrace: at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose) at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady) at System.Data.SqlClient.SqlDataReader.TryConsumeMetaData() at System.Data.SqlClient.SqlDataReader.get_MetaData() at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString, Boolean isInternal, Boolean forDescribeParameterEncryption, Boolean shouldCacheForAlwaysEncrypted) at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async, Int32 timeout, Task& task, Boolean asyncWrite, Boolean inRetry, SqlDataReader ds, Boolean describeParameterEncryptionRequest) at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, TaskCompletionSource`1 completion, Int32 timeout, Task& task, Boolean& usedCache, Boolean asyncWrite, Boolean inRetry) at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method) at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior, String method) at System.Data.Common.DbDataAdapter.FillInternal(DataSet dataset, DataTable[] datatables, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior) at System.Data.Common.DbDataAdapter.Fill(DataTable[] dataTables, Int32 startRecord, Int32 maxRecords, IDbCommand command, CommandBehavior behavior) at System.Data.Common.DbDataAdapter.Fill(DataTable dataTable) at ClassMaster.DataTableResult(String query) TargetSite: Void OnError(System.Data.SqlClient.SqlException, Boolean, System.Action`1[System.Action]) Time: 25/07/2026 06:14:21 PM PageName: Employee_EmployeePromotionLetterList String str: SELECT a.SrNo,a.BranchName+' ('+a.BranchId+')'AS BranchName, a.DepartmentName, a.DesignationName, a.OldDesignationName, a.EmployeeId, a.EmployeeName, a.GuardianName, Convert(CHAR,a.PermotionDate,106)AS PermotionDate, a.OldSalaryPerMonth, a.NewSalaryPerMonth, a.ReportingOfficerName, a.PermotionRemark, a.EntryUser, Convert(CHAR,a.EntryTime,106)AS EntryTime, (SELECT ReportValue FROM ProjectReportSetting WITH(nolock) WHERE ReportName='EmployeePromotionLetterHTML')+'?EmployeeId='+a.EmployeeId AS EmployeePromotionLetterHTML, 'Employee_PrintRDLCPage.aspx?Report=' + (SELECT ReportValue FROM ProjectReportSetting WITH(nolock)WHERE ReportName='EmployeePromotionLetter')+'&EmployeeId='+a.EmployeeId AS EmployeePromotionLetter FROM EmployeePromotionLetterDetail a WITH(nolock) WHERE 1=1 AND a.EntryTime>='2/22/2026 12:00:00 AM' AND a.EntryTime<'7/26/2026 12:00:00 AM' AND a.BranchId IN ('100','102','101','104','105','103') ORDER BY a.BranchName, a.EmployeeName String sql: Data: System.Collections.ListDictionaryInternal HelpLink: InnerException: Message: Object reference not set to an instance of an object. Source: App_Web_dierghye StackTrace: at Employee_EmployeePromotionLetterList.btnSearch_Click(Object sender, EventArgs e) TargetSite: Void btnSearch_Click(System.Object, System.EventArgs) Time: 25/07/2026 06:17:55 PM PageName: DataTableResult String str: SELECT a.BranchName+' ('+a.BranchId+')'AS BranchName, a.DepartmentName, a.DesignationName, a.EmployeeId, a.EmployeeName, Convert(CHAR,a.IncrementDate,106)AS IncrementDate, a.BasicSalary, a.HRA, a.LTA, a.FlexiAllowance, a.EmployerPF, a.EmployerESI,a.TotalSalary, a.ChifEmployeeName,a.IncrementRemark, a.EntryUser, Convert(CHAR,a.EntryTime,106)AS EntryTime,(SELECT ReportValue FROM ProjectReportSetting WITH(nolock) WHERE ReportName='EmployeeIncrementLetterHTML')+'?EmployeeId='+a.EmployeeId AS EmployeeIncrementLetterHTML, 'Employee_PrintRDLCPage.aspx?Report=' + (SELECT ReportValue FROM ProjectReportSetting WITH(nolock)WHERE ReportName='EmployeeIncrementLetter')+'&EmployeeId='+a.EmployeeId AS EmployeeIncrementLetter FROM EmployeeIncrementLetterDetail a WITH(nolock) WHERE 1=1 AND a.EntryTime<'7/26/2026 12:00:00 AM' String sql: Data: System.Collections.ListDictionaryInternal HelpLink: InnerException: Message: Invalid column name 'BasicSalary'. Invalid column name 'HRA'. Invalid column name 'LTA'. Invalid column name 'FlexiAllowance'. Invalid column name 'EmployerPF'. Invalid column name 'EmployerESI'. Invalid column name 'TotalSalary'. Invalid column name 'ChifEmployeeName'. Invalid column name 'IncrementRemark'. Source: .Net SqlClient Data Provider StackTrace: at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose) at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady) at System.Data.SqlClient.SqlDataReader.TryConsumeMetaData() at System.Data.SqlClient.SqlDataReader.get_MetaData() at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString, Boolean isInternal, Boolean forDescribeParameterEncryption, Boolean shouldCacheForAlwaysEncrypted) at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async, Int32 timeout, Task& task, Boolean asyncWrite, Boolean inRetry, SqlDataReader ds, Boolean describeParameterEncryptionRequest) at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, TaskCompletionSource`1 completion, Int32 timeout, Task& task, Boolean& usedCache, Boolean asyncWrite, Boolean inRetry) at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method) at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior, String method) at System.Data.Common.DbDataAdapter.FillInternal(DataSet dataset, DataTable[] datatables, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior) at System.Data.Common.DbDataAdapter.Fill(DataTable[] dataTables, Int32 startRecord, Int32 maxRecords, IDbCommand command, CommandBehavior behavior) at System.Data.Common.DbDataAdapter.Fill(DataTable dataTable) at ClassMaster.DataTableResult(String query) TargetSite: Void OnError(System.Data.SqlClient.SqlException, Boolean, System.Action`1[System.Action]) Time: 25/07/2026 06:17:55 PM PageName: Employee_EmployeeIncrementLetterList String str: SELECT a.BranchName+' ('+a.BranchId+')'AS BranchName, a.DepartmentName, a.DesignationName, a.EmployeeId, a.EmployeeName, Convert(CHAR,a.IncrementDate,106)AS IncrementDate, a.BasicSalary, a.HRA, a.LTA, a.FlexiAllowance, a.EmployerPF, a.EmployerESI,a.TotalSalary, a.ChifEmployeeName,a.IncrementRemark, a.EntryUser, Convert(CHAR,a.EntryTime,106)AS EntryTime,(SELECT ReportValue FROM ProjectReportSetting WITH(nolock) WHERE ReportName='EmployeeIncrementLetterHTML')+'?EmployeeId='+a.EmployeeId AS EmployeeIncrementLetterHTML, 'Employee_PrintRDLCPage.aspx?Report=' + (SELECT ReportValue FROM ProjectReportSetting WITH(nolock)WHERE ReportName='EmployeeIncrementLetter')+'&EmployeeId='+a.EmployeeId AS EmployeeIncrementLetter FROM EmployeeIncrementLetterDetail a WITH(nolock) WHERE 1=1 AND a.EntryTime<'7/26/2026 12:00:00 AM' String sql: Data: System.Collections.ListDictionaryInternal HelpLink: InnerException: Message: Object reference not set to an instance of an object. Source: App_Web_ndnxg0j1 StackTrace: at Employee_EmployeeIncrementLetterList.btnSearch_Click(Object sender, EventArgs e) TargetSite: Void btnSearch_Click(System.Object, System.EventArgs) Time: 25/07/2026 06:24:34 PM PageName: Employee_EmployeeTravellingApproval String str: String sql: Data: System.Collections.ListDictionaryInternal HelpLink: InnerException: Message: Object reference not set to an instance of an object. Source: App_Web_dierghye StackTrace: at Employee_EmployeeTravellingApproval.FillData() TargetSite: Void FillData() Time: 27/07/2026 04:34:21 PM PageName: AdminLogOut String str: String sql: Data: System.Collections.ListDictionaryInternal HelpLink: InnerException: Message: Thread was being aborted. Source: mscorlib StackTrace: at System.Threading.Thread.AbortInternal() at System.Threading.Thread.Abort(Object stateInfo) at System.Web.HttpResponse.AbortCurrentThread() at System.Web.HttpResponse.Redirect(String url, Boolean endResponse, Boolean permanent) at AdminLogOut.btnLogout_Click(Object sender, EventArgs e) TargetSite: Void AbortInternal() Time: 27/07/2026 04:34:30 PM PageName: AdminLogOut String str: String sql: Data: System.Collections.ListDictionaryInternal HelpLink: InnerException: Message: Thread was being aborted. Source: mscorlib StackTrace: at System.Threading.Thread.AbortInternal() at System.Threading.Thread.Abort(Object stateInfo) at System.Web.HttpResponse.AbortCurrentThread() at System.Web.HttpResponse.Redirect(String url, Boolean endResponse, Boolean permanent) at AdminLogOut.btnLogout_Click(Object sender, EventArgs e) TargetSite: Void AbortInternal() Time: 27/07/2026 04:35:31 PM PageName: AdminChangePassword String str: SELECT Count(1)AS Nos0 FROM ( SELECT TOP 3 * FROM UserLoginPasswordStatusBackDateHistory WITH(nolock) WHERE UserLoginId='emp00107' ORDER BY UpdateTime DESC )tt WHERE tt.UserPassword='RABlAG0AbwBAADEAMgAzADQANQA2AA==' ; String sql: INSERT INTO UserLoginPasswordStatusBackDateHistory ( UserNo, UserLoginId, UserPassword, UserRole, AdminControl, UserLoginStatus, UserWebLogin, UserMobileLogin, UserEXELogin, UserLocation, MobileLocation, MobileDeviceId, LocationTracing, WebLoginMode, UserWorkingDate, NoOfBackDate, MobilePINNo, UpdateUser, UpdateTime ) SELECT UserNo, UserLoginId, UserPassword, UserRole, AdminControl, UserLoginStatus, UserWebLogin, UserMobileLogin, UserEXELogin, UserLocation, MobileLocation, MobileDeviceId, LocationTracing, WebLoginMode, UserWorkingDate, NoOfBackDate, MobilePINNo, 'emp00107' AS UpdateUser, GETDATE() AS UpdateTime FROM UserLoginDetail WHERE UserLoginId='emp00107' ; UPDATE UserLoginDetail SET UserPassword='RABlAG0AbwBAADEAMgAzADQANQA2AA==' WHERE UserLoginId='emp00107' ; Data: System.Collections.ListDictionaryInternal HelpLink: InnerException: Message: Invalid column name 'AdminControl'. Source: .Net SqlClient Data Provider StackTrace: at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose) at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady) at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async, Int32 timeout, Boolean asyncWrite) at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(TaskCompletionSource`1 completion, String methodName, Boolean sendToPipe, Int32 timeout, Boolean& usedCache, Boolean asyncWrite, Boolean inRetry) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at AdminChangePassword.btnUpdate_Click(Object sender, EventArgs e) TargetSite: Void OnError(System.Data.SqlClient.SqlException, Boolean, System.Action`1[System.Action]) Time: 01/08/2026 12:47:39 AM PageName: AdminLogOut String str: String sql: Data: System.Collections.ListDictionaryInternal HelpLink: InnerException: Message: Thread was being aborted. Source: mscorlib StackTrace: at System.Threading.Thread.AbortInternal() at System.Threading.Thread.Abort(Object stateInfo) at System.Web.HttpResponse.AbortCurrentThread() at System.Web.HttpResponse.Redirect(String url, Boolean endResponse, Boolean permanent) at AdminLogOut.btnLogout_Click(Object sender, EventArgs e) TargetSite: Void AbortInternal() Time: 01/08/2026 12:49:20 AM PageName: AdminLogOut String str: String sql: Data: System.Collections.ListDictionaryInternal HelpLink: InnerException: Message: Thread was being aborted. Source: mscorlib StackTrace: at System.Threading.Thread.AbortInternal() at System.Threading.Thread.Abort(Object stateInfo) at System.Web.HttpResponse.AbortCurrentThread() at System.Web.HttpResponse.Redirect(String url, Boolean endResponse, Boolean permanent) at AdminLogOut.btnLogout_Click(Object sender, EventArgs e) TargetSite: Void AbortInternal() Time: 01/08/2026 02:33:58 AM PageName: AdminLogOut String str: String sql: Data: System.Collections.ListDictionaryInternal HelpLink: InnerException: Message: Thread was being aborted. Source: mscorlib StackTrace: at System.Threading.Thread.AbortInternal() at System.Threading.Thread.Abort(Object stateInfo) at System.Web.HttpResponse.AbortCurrentThread() at System.Web.HttpResponse.Redirect(String url, Boolean endResponse, Boolean permanent) at AdminLogOut.btnLogout_Click(Object sender, EventArgs e) TargetSite: Void AbortInternal() Time: 01/08/2026 06:08:17 PM PageName: AdminLogOut String str: String sql: Data: System.Collections.ListDictionaryInternal HelpLink: InnerException: Message: Thread was being aborted. Source: mscorlib StackTrace: at System.Threading.Thread.AbortInternal() at System.Threading.Thread.Abort(Object stateInfo) at System.Web.HttpResponse.AbortCurrentThread() at System.Web.HttpResponse.Redirect(String url, Boolean endResponse, Boolean permanent) at AdminLogOut.btnLogout_Click(Object sender, EventArgs e) TargetSite: Void AbortInternal() Time: 01/08/2026 06:10:16 PM PageName: AdminLogOut String str: String sql: Data: System.Collections.ListDictionaryInternal HelpLink: InnerException: Message: Thread was being aborted. Source: mscorlib StackTrace: at System.Threading.Thread.AbortInternal() at System.Threading.Thread.Abort(Object stateInfo) at System.Web.HttpResponse.AbortCurrentThread() at System.Web.HttpResponse.Redirect(String url, Boolean endResponse, Boolean permanent) at AdminLogOut.btnLogout_Click(Object sender, EventArgs e) TargetSite: Void AbortInternal() Time: 01/08/2026 06:15:15 PM PageName: AdminLogOut String str: String sql: Data: System.Collections.ListDictionaryInternal HelpLink: InnerException: Message: Thread was being aborted. Source: mscorlib StackTrace: at System.Threading.Thread.AbortInternal() at System.Threading.Thread.Abort(Object stateInfo) at System.Web.HttpResponse.AbortCurrentThread() at System.Web.HttpResponse.Redirect(String url, Boolean endResponse, Boolean permanent) at AdminLogOut.btnLogout_Click(Object sender, EventArgs e) TargetSite: Void AbortInternal() Time: 01/08/2026 06:19:32 PM PageName: AdminLogOut String str: String sql: Data: System.Collections.ListDictionaryInternal HelpLink: InnerException: Message: Thread was being aborted. Source: mscorlib StackTrace: at System.Threading.Thread.AbortInternal() at System.Threading.Thread.Abort(Object stateInfo) at System.Web.HttpResponse.AbortCurrentThread() at System.Web.HttpResponse.Redirect(String url, Boolean endResponse, Boolean permanent) at AdminLogOut.btnLogout_Click(Object sender, EventArgs e) TargetSite: Void AbortInternal() Time: 01/08/2026 06:22:40 PM PageName: AdminLogOut String str: String sql: Data: System.Collections.ListDictionaryInternal HelpLink: InnerException: Message: Thread was being aborted. Source: mscorlib StackTrace: at System.Threading.Thread.AbortInternal() at System.Threading.Thread.Abort(Object stateInfo) at System.Web.HttpResponse.AbortCurrentThread() at System.Web.HttpResponse.Redirect(String url, Boolean endResponse, Boolean permanent) at AdminLogOut.btnLogout_Click(Object sender, EventArgs e) TargetSite: Void AbortInternal() Time: 01/08/2026 06:29:40 PM PageName: AdminLogOut String str: String sql: Data: System.Collections.ListDictionaryInternal HelpLink: InnerException: Message: Thread was being aborted. Source: mscorlib StackTrace: at System.Threading.Thread.AbortInternal() at System.Threading.Thread.Abort(Object stateInfo) at System.Web.HttpResponse.AbortCurrentThread() at System.Web.HttpResponse.Redirect(String url, Boolean endResponse, Boolean permanent) at AdminLogOut.btnLogout_Click(Object sender, EventArgs e) TargetSite: Void AbortInternal() Time: 03/08/2026 10:49:34 AM PageName: DataTableResult String str: SELECT a.BranchId, a.BranchName, a.EmployeeId, a.EmployeeName, convert(CHAR,isnull(b.FromDate,'01/01/1900'),103)AS FromDate, convert(CHAR,isnull(b.ToDate,'01/01/2050'),103)AS ToDate, isnull(b.NewPlanPercent,0)AS NewPlanPercent, isnull(b.RenewalPlanPercent,0)AS RenewalPlanPercent, isnull(b.NewPlanTargetAmount,0)AS NewPlanTargetAmount, isnull(b.RenewalTargetAmount,0)AS RenewalTargetAmount, b.EntryUser, rtrim(convert(CHAR,b.EntryTime,103))+' '+rtrim(convert(CHAR,b.EntryTime,108))AS EntryTime FROM EmployeeRegistrationDetail a LEFT JOIN EmployeeIncentiveMaster b WITH(nolock) ON a.EmployeeId=b.EmployeeId WHERE 1=1 String sql: Data: System.Collections.ListDictionaryInternal HelpLink: InnerException: Message: Invalid column name 'EmployeeId'. Invalid column name 'ToDate'. Invalid column name 'NewPlanPercent'. Invalid column name 'RenewalPlanPercent'. Invalid column name 'NewPlanTargetAmount'. Invalid column name 'RenewalTargetAmount'. Source: .Net SqlClient Data Provider StackTrace: at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose) at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady) at System.Data.SqlClient.SqlDataReader.TryConsumeMetaData() at System.Data.SqlClient.SqlDataReader.get_MetaData() at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString, Boolean isInternal, Boolean forDescribeParameterEncryption, Boolean shouldCacheForAlwaysEncrypted) at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async, Int32 timeout, Task& task, Boolean asyncWrite, Boolean inRetry, SqlDataReader ds, Boolean describeParameterEncryptionRequest) at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, TaskCompletionSource`1 completion, Int32 timeout, Task& task, Boolean& usedCache, Boolean asyncWrite, Boolean inRetry) at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method) at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior, String method) at System.Data.SqlClient.SqlCommand.ExecuteDbDataReader(CommandBehavior behavior) at System.Data.Common.DbCommand.System.Data.IDbCommand.ExecuteReader(CommandBehavior behavior) at System.Data.Common.DbDataAdapter.FillInternal(DataSet dataset, DataTable[] datatables, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior) at System.Data.Common.DbDataAdapter.Fill(DataTable[] dataTables, Int32 startRecord, Int32 maxRecords, IDbCommand command, CommandBehavior behavior) at System.Data.Common.DbDataAdapter.Fill(DataTable dataTable) at ClassMaster.DataTableResult(String query) TargetSite: Void OnError(System.Data.SqlClient.SqlException, Boolean, System.Action`1[System.Action]) Time: 03/08/2026 10:49:34 AM PageName: Employee_EmployeeIncentiveMaster String str: SELECT a.BranchId, a.BranchName, a.EmployeeId, a.EmployeeName, convert(CHAR,isnull(b.FromDate,'01/01/1900'),103)AS FromDate, convert(CHAR,isnull(b.ToDate,'01/01/2050'),103)AS ToDate, isnull(b.NewPlanPercent,0)AS NewPlanPercent, isnull(b.RenewalPlanPercent,0)AS RenewalPlanPercent, isnull(b.NewPlanTargetAmount,0)AS NewPlanTargetAmount, isnull(b.RenewalTargetAmount,0)AS RenewalTargetAmount, b.EntryUser, rtrim(convert(CHAR,b.EntryTime,103))+' '+rtrim(convert(CHAR,b.EntryTime,108))AS EntryTime FROM EmployeeRegistrationDetail a LEFT JOIN EmployeeIncentiveMaster b WITH(nolock) ON a.EmployeeId=b.EmployeeId WHERE 1=1 String sql: Data: System.Collections.ListDictionaryInternal HelpLink: InnerException: Message: Object reference not set to an instance of an object. Source: App_Web_xytv1j0p StackTrace: at Employee_EmployeeIncentiveMaster.FillData() TargetSite: Void FillData() Time: 03/08/2026 10:49:36 AM PageName: DataTableResult String str: SELECT a.BranchId, a.BranchName, a.EmployeeId, a.EmployeeName, convert(CHAR,isnull(b.FromDate,'01/01/1900'),103)AS FromDate, convert(CHAR,isnull(b.ToDate,'01/01/2050'),103)AS ToDate, isnull(b.NewPlanPercent,0)AS NewPlanPercent, isnull(b.RenewalPlanPercent,0)AS RenewalPlanPercent, isnull(b.NewPlanTargetAmount,0)AS NewPlanTargetAmount, isnull(b.RenewalTargetAmount,0)AS RenewalTargetAmount, b.EntryUser, rtrim(convert(CHAR,b.EntryTime,103))+' '+rtrim(convert(CHAR,b.EntryTime,108))AS EntryTime FROM EmployeeRegistrationDetail a LEFT JOIN EmployeeIncentiveMaster b WITH(nolock) ON a.EmployeeId=b.EmployeeId WHERE 1=1 String sql: Data: System.Collections.ListDictionaryInternal HelpLink: InnerException: Message: Invalid column name 'EmployeeId'. Invalid column name 'ToDate'. Invalid column name 'NewPlanPercent'. Invalid column name 'RenewalPlanPercent'. Invalid column name 'NewPlanTargetAmount'. Invalid column name 'RenewalTargetAmount'. Source: .Net SqlClient Data Provider StackTrace: at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose) at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady) at System.Data.SqlClient.SqlDataReader.TryConsumeMetaData() at System.Data.SqlClient.SqlDataReader.get_MetaData() at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString, Boolean isInternal, Boolean forDescribeParameterEncryption, Boolean shouldCacheForAlwaysEncrypted) at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async, Int32 timeout, Task& task, Boolean asyncWrite, Boolean inRetry, SqlDataReader ds, Boolean describeParameterEncryptionRequest) at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, TaskCompletionSource`1 completion, Int32 timeout, Task& task, Boolean& usedCache, Boolean asyncWrite, Boolean inRetry) at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method) at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior, String method) at System.Data.SqlClient.SqlCommand.ExecuteDbDataReader(CommandBehavior behavior) at System.Data.Common.DbCommand.System.Data.IDbCommand.ExecuteReader(CommandBehavior behavior) at System.Data.Common.DbDataAdapter.FillInternal(DataSet dataset, DataTable[] datatables, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior) at System.Data.Common.DbDataAdapter.Fill(DataTable[] dataTables, Int32 startRecord, Int32 maxRecords, IDbCommand command, CommandBehavior behavior) at System.Data.Common.DbDataAdapter.Fill(DataTable dataTable) at ClassMaster.DataTableResult(String query) TargetSite: Void OnError(System.Data.SqlClient.SqlException, Boolean, System.Action`1[System.Action]) Time: 03/08/2026 10:49:36 AM PageName: Employee_EmployeeIncentiveMaster String str: SELECT a.BranchId, a.BranchName, a.EmployeeId, a.EmployeeName, convert(CHAR,isnull(b.FromDate,'01/01/1900'),103)AS FromDate, convert(CHAR,isnull(b.ToDate,'01/01/2050'),103)AS ToDate, isnull(b.NewPlanPercent,0)AS NewPlanPercent, isnull(b.RenewalPlanPercent,0)AS RenewalPlanPercent, isnull(b.NewPlanTargetAmount,0)AS NewPlanTargetAmount, isnull(b.RenewalTargetAmount,0)AS RenewalTargetAmount, b.EntryUser, rtrim(convert(CHAR,b.EntryTime,103))+' '+rtrim(convert(CHAR,b.EntryTime,108))AS EntryTime FROM EmployeeRegistrationDetail a LEFT JOIN EmployeeIncentiveMaster b WITH(nolock) ON a.EmployeeId=b.EmployeeId WHERE 1=1 String sql: Data: System.Collections.ListDictionaryInternal HelpLink: InnerException: Message: Object reference not set to an instance of an object. Source: App_Web_xytv1j0p StackTrace: at Employee_EmployeeIncentiveMaster.FillData() TargetSite: Void FillData() Time: 03/08/2026 10:52:18 AM PageName: AdminLogOut String str: String sql: Data: System.Collections.ListDictionaryInternal HelpLink: InnerException: Message: Thread was being aborted. Source: mscorlib StackTrace: at System.Threading.Thread.AbortInternal() at System.Threading.Thread.Abort(Object stateInfo) at System.Web.HttpResponse.AbortCurrentThread() at System.Web.HttpResponse.End() at System.Web.HttpResponse.Redirect(String url, Boolean endResponse, Boolean permanent) at AdminLogOut.btnLogout_Click(Object sender, EventArgs e) TargetSite: Void AbortInternal() Time: 03/08/2026 11:07:59 AM PageName: GroupLoan_GroupLoanRepaymentMultiple String str: SELECT PaymentMode FROM PaymentModeMaster WITH(nolock) WHERE PaymentStatus='Active' AND PaymentProcess='GroupLoanRepaymentMultiple' ORDER BY PaymentMode ; SELECT DISTINCT TermMode FROM GroupLoanNoMaster WITH(nolock) ORDER BY TermMode DESC SELECT ( SELECT DataValue FROM ProjectDataSetting WITH(nolock) WHERE DataName='APIUserName')AS APIUserName, ( SELECT DataValue FROM ProjectDataSetting WITH(nolock) WHERE DataName='APIUserStatus')AS APIUserStatus, ( SELECT DataValue FROM ProjectDataSetting WITH(nolock) WHERE DataName='GroupLoanEMICollectionSMS')AS GroupLoanEMICollectionSMS, ( SELECT GroupLoanEMIPenalty FROM UserLoginDetail WITH(nolock) WHERE UserLoginId='root')AS UserGroupLoanEMIPenalty, ( SELECT GroupLoanRepaymentMultiple FROM UserLoginDetail WITH(nolock) WHERE UserLoginId='root')AS UserGroupLoanRepaymentMultiple ; String sql: Data: System.Collections.ListDictionaryInternal HelpLink: InnerException: Message: Column 'GroupLoanCloseInCenterMeeting' does not belong to table DSResult2. Source: System.Data StackTrace: at System.Data.DataRow.GetDataColumn(String columnName) at System.Data.DataRow.get_Item(String columnName) at GroupLoan_GroupLoanRepaymentMultiple.FillDDLData() TargetSite: System.Data.DataColumn GetDataColumn(System.String) Time: 03/08/2026 11:19:22 AM PageName: GroupLoan_GroupLoanOutstandingReport String str: DECLARE @TDate DATE; SET @TDate='8/3/2026 12:00:00 AM'; DECLARE @FTable TABLE ( BranchName VARCHAR(50), NoOfOfficer INT, NoOfCenter INT, NoOfLoans INT, TotalTerm INT, LoanAmount DECIMAL(18,2), TotalInterest DECIMAL(18,2), TotalPayable DECIMAL(18,2), EMIAmount DECIMAL(18,2), PaidTerm INT, PaidPrincipal DECIMAL(18,2), PaidInterest DECIMAL(18,2), PaidTotal DECIMAL(18,2), BalanceTerm INT, BalancePrincipal DECIMAL(18,2), BalanceInterest DECIMAL(18,2), BalanceTotal DECIMAL(18,2), TotalPenalty DECIMAL(18,2), PaidPenalty DECIMAL(18,2), BalancePenalty DECIMAL(18,2), WriteOffAmount DECIMAL(18,2), NoPer DECIMAL(18,2), AmountPer DECIMAL(18,2) ); INSERT INTO @FTable ( BranchName, NoOfOfficer, NoOfCenter, NoOfLoans, TotalTerm, LoanAmount, TotalInterest, TotalPayable, EMIAmount, PaidTerm, PaidPrincipal, PaidInterest, PaidTotal, BalanceTerm, BalancePrincipal, BalanceInterest, BalanceTotal, TotalPenalty, PaidPenalty, BalancePenalty, WriteOffAmount ) SELECT a.BranchName+' ('+a.BranchId+')' AS BranchName, count(DISTINCT a.LoanOfficerId)AS NoOfOfficer, count(DISTINCT a.CenterId)AS NoOfCenter, Count(DISTINCT a.LoanId)AS NoOfLoans, SUM(a.LoanTerm)AS TotalTerm, SUM(a.LoanAmount)AS LoanAmount, SUM(a.TotalInterest)AS TotalInterest, SUM(a.LoanAmount+a.TotalInterest) AS TotalPayable, SUM(a.EMIAmount)AS EMIAmount, SUM(isnull(b.PaidTerm,0))AS PaidTerm, SUM(isnull(b.PaidPrincipal,0))AS PaidPrincipal, SUM(isnull(b.PaidInterest,0))AS PaidInterest, SUM(isnull(b.PaidTotal,0))AS PaidTotal, SUM(a.LoanTerm-isnull(b.PaidTerm,0))AS BalanceTerm, SUM(a.LoanAmount-isnull(b.PaidPrincipal,0)-isnull(c.WriteOffAmount,0))AS BalancePrincipal, SUM(a.TotalInterest-isnull(b.PaidInterest,0))AS BalanceInterest, SUM(a.LoanAmount+a.TotalInterest-isnull(b.PaidTotal,0))AS BalanceTotal, SUM(b.TotalPenalty)AS TotalPenalty, SUM(b.PaidPenalty)AS PaidPenalty, SUM(b.BalancePenalty)AS BalancePenalty, SUM(isnull(c.WriteOffAmount,0))AS WriteOffAmount FROM GroupLoanAccount a WITH(nolock) LEFT JOIN ( SELECT LoanId, COUNT(DISTINCT DNo)AS PaidTerm, SUM(Prin)AS PaidPrincipal, SUM(Intt)AS PaidInterest, SUM(Total)AS PaidTotal, SUM(isnull(PDue,0))AS TotalPenalty, SUM(isnull(PPaid,0))AS PaidPenalty, SUM(isnull(PDue,0))-SUM(isnull(PPaid,0))AS BalancePenalty FROM GroupLoanLedger WITH(nolock) WHERE Total>0 AND PStatus='Paid' AND PDate0 AND PStatus='Writeoff' AND PDate0 AND a.BranchId IN ('100','102','101','104','105','103') AND isnull(a.GroupName,'Group')!='Individual' GROUP BY a.BranchName+' ('+a.BranchId+')' ORDER BY a.BranchName+' ('+a.BranchId+')' ; UPDATE ta SET ta.NoPer=convert(DECIMAL(10,0),ta.NoOfLoans*100.00/(SELECT SUM(NoOfLoans) FROM @FTable)), ta.AmountPer=convert(DECIMAL(10,0),ta.BalancePrincipal*100.00/(SELECT SUM(BalancePrincipal) FROM @FTable)) FROM @FTable ta WHERE ta.NoOfLoans>0 AND ta.BalancePrincipal>0 ; SELECT BranchName, NoOfOfficer, NoOfCenter, NoOfLoans, TotalTerm, LoanAmount, TotalInterest, TotalPayable, EMIAmount, PaidTerm, PaidPrincipal, PaidInterest, PaidTotal, BalanceTerm, BalancePrincipal, BalanceInterest, BalanceTotal, TotalPenalty, PaidPenalty, BalancePenalty, WriteOffAmount, dbo.FunNumberOfCharacterFromNumber(NoPer)AS NoStr, dbo.FunNumberOfCharacterFromNumber(AmountPer)AS AmountStr FROM @FTable ORDER BY BranchName ; String sql: Data: System.Collections.ListDictionaryInternal HelpLink: InnerException: Message: Input string was not in a correct format. Source: mscorlib StackTrace: at System.Number.StringToNumber(String str, NumberStyles options, NumberBuffer& number, NumberFormatInfo info, Boolean parseDecimal) at System.Number.ParseDecimal(String value, NumberStyles options, NumberFormatInfo numfmt) at System.Convert.ToDecimal(String value) at GroupLoan_GroupLoanOutstandingReport.grdBranch_RowDataBound(Object sender, GridViewRowEventArgs e) TargetSite: Void StringToNumber(System.String, System.Globalization.NumberStyles, NumberBuffer ByRef, System.Globalization.NumberFormatInfo, Boolean) Time: 03/08/2026 11:19:33 AM PageName: GroupLoan_GroupLoanOutstandingReport String str: DECLARE @TDate DATE; SET @TDate='8/3/2026 12:00:00 AM'; SELECT a.MemberId, a.MemberName, a.NomineeName, a.MemberMobileNo, a.NomineeMobileNo, a.LoanId, convert(CHAR,a.DisburseDate,106)AS DisburseDate, a.LoanTerm AS TotalTerm, a.LoanAmount, a.TotalInterest, a.LoanAmount+a.TotalInterest AS TotalPayable, a.EMIAmount, convert(CHAR,b.LastPaidDate,106)AS LastPaidDate, isnull(b.PaidTerm,0)AS PaidTerm, isnull(b.PaidPrincipal,0)AS PaidPrincipal, isnull(b.PaidInterest,0)AS PaidInterest, isnull(b.PaidTotal,0)AS PaidTotal, convert(CHAR,a.ExpiryDate,106)AS ExpiryDate, a.LoanTerm-isnull(b.PaidTerm,0)AS BalanceTerm, a.LoanAmount-isnull(b.PaidPrincipal,0)-isnull(c.WriteOffAmount,0)AS BalancePrincipal, a.TotalInterest-isnull(b.PaidInterest,0)AS BalanceInterest, a.LoanAmount+a.TotalInterest-isnull(b.PaidTotal,0)-isnull(c.WriteOffAmount,0)AS BalanceTotal, b.TotalPenalty, b.PaidPenalty, b.BalancePenalty, c.WriteOffAmount, dbo.FunNumberOfCharacterFromNumber((a.LoanAmount-isnull(b.PaidPrincipal,0)-isnull(c.WriteOffAmount,0))/2000)AS AmountStr, a.LoanCycle, a.GLoanTypeNo, rtrim(convert(CHAR,a.LoanTerm))+'-'+a.LoanTermMode AS LoanTerm, a.LoanPurpose, a.LoanFunder, a.CenterId, a.CenterName, a.LoanOfficerId, a.LoanOfficerName, a.BranchName+' ('+a.BranchId+')' AS BranchName FROM GroupLoanAccount a WITH(nolock) LEFT JOIN ( SELECT LoanId, MAX(PDate)AS LastPaidDate, COUNT(DISTINCT DNo)AS PaidTerm, SUM(Prin)AS PaidPrincipal, SUM(Intt)AS PaidInterest, SUM(Total)AS PaidTotal, SUM(isnull(PDue,0))AS TotalPenalty, SUM(isnull(PPaid,0))AS PaidPenalty, SUM(isnull(PDue,0))-SUM(isnull(PPaid,0))AS BalancePenalty FROM GroupLoanLedger WITH(nolock) WHERE Total>0 AND PStatus='Paid' AND PDate0 AND PStatus='Writeoff' AND PDate0 AND a.BranchId IN ('100','102','101','104','105','103') AND isnull(a.GroupName,'Group')!='Individual' ORDER BY a.BranchName+' ('+a.BranchId+')', a.LoanOfficerName, a.CenterName, a.MemberName, a.LoanId String sql: Data: System.Collections.ListDictionaryInternal HelpLink: InnerException: Message: Input string was not in a correct format. Source: mscorlib StackTrace: at System.Number.StringToNumber(String str, NumberStyles options, NumberBuffer& number, NumberFormatInfo info, Boolean parseDecimal) at System.Number.ParseDecimal(String value, NumberStyles options, NumberFormatInfo numfmt) at System.Convert.ToDecimal(String value) at GroupLoan_GroupLoanOutstandingReport.grdLoan_RowDataBound(Object sender, GridViewRowEventArgs e) TargetSite: Void StringToNumber(System.String, System.Globalization.NumberStyles, NumberBuffer ByRef, System.Globalization.NumberFormatInfo, Boolean) Time: 03/08/2026 11:19:33 AM PageName: GroupLoan_GroupLoanOutstandingReport String str: DECLARE @TDate DATE; SET @TDate='8/3/2026 12:00:00 AM'; SELECT a.MemberId, a.MemberName, a.NomineeName, a.MemberMobileNo, a.NomineeMobileNo, a.LoanId, convert(CHAR,a.DisburseDate,106)AS DisburseDate, a.LoanTerm AS TotalTerm, a.LoanAmount, a.TotalInterest, a.LoanAmount+a.TotalInterest AS TotalPayable, a.EMIAmount, convert(CHAR,b.LastPaidDate,106)AS LastPaidDate, isnull(b.PaidTerm,0)AS PaidTerm, isnull(b.PaidPrincipal,0)AS PaidPrincipal, isnull(b.PaidInterest,0)AS PaidInterest, isnull(b.PaidTotal,0)AS PaidTotal, convert(CHAR,a.ExpiryDate,106)AS ExpiryDate, a.LoanTerm-isnull(b.PaidTerm,0)AS BalanceTerm, a.LoanAmount-isnull(b.PaidPrincipal,0)-isnull(c.WriteOffAmount,0)AS BalancePrincipal, a.TotalInterest-isnull(b.PaidInterest,0)AS BalanceInterest, a.LoanAmount+a.TotalInterest-isnull(b.PaidTotal,0)-isnull(c.WriteOffAmount,0)AS BalanceTotal, b.TotalPenalty, b.PaidPenalty, b.BalancePenalty, c.WriteOffAmount, dbo.FunNumberOfCharacterFromNumber((a.LoanAmount-isnull(b.PaidPrincipal,0)-isnull(c.WriteOffAmount,0))/2000)AS AmountStr, a.LoanCycle, a.GLoanTypeNo, rtrim(convert(CHAR,a.LoanTerm))+'-'+a.LoanTermMode AS LoanTerm, a.LoanPurpose, a.LoanFunder, a.CenterId, a.CenterName, a.LoanOfficerId, a.LoanOfficerName, a.BranchName+' ('+a.BranchId+')' AS BranchName FROM GroupLoanAccount a WITH(nolock) LEFT JOIN ( SELECT LoanId, MAX(PDate)AS LastPaidDate, COUNT(DISTINCT DNo)AS PaidTerm, SUM(Prin)AS PaidPrincipal, SUM(Intt)AS PaidInterest, SUM(Total)AS PaidTotal, SUM(isnull(PDue,0))AS TotalPenalty, SUM(isnull(PPaid,0))AS PaidPenalty, SUM(isnull(PDue,0))-SUM(isnull(PPaid,0))AS BalancePenalty FROM GroupLoanLedger WITH(nolock) WHERE Total>0 AND PStatus='Paid' AND PDate0 AND PStatus='Writeoff' AND PDate0 AND a.BranchId IN ('100','102','101','104','105','103') AND isnull(a.GroupName,'Group')!='Individual' ORDER BY a.BranchName+' ('+a.BranchId+')', a.LoanOfficerName, a.CenterName, a.MemberName, a.LoanId String sql: Data: System.Collections.ListDictionaryInternal HelpLink: InnerException: Message: Input string was not in a correct format. Source: mscorlib StackTrace: at System.Number.StringToNumber(String str, NumberStyles options, NumberBuffer& number, NumberFormatInfo info, Boolean parseDecimal) at System.Number.ParseDecimal(String value, NumberStyles options, NumberFormatInfo numfmt) at System.Convert.ToDecimal(String value) at GroupLoan_GroupLoanOutstandingReport.grdLoan_RowDataBound(Object sender, GridViewRowEventArgs e) TargetSite: Void StringToNumber(System.String, System.Globalization.NumberStyles, NumberBuffer ByRef, System.Globalization.NumberFormatInfo, Boolean) Time: 03/08/2026 11:19:33 AM PageName: GroupLoan_GroupLoanOutstandingReport String str: DECLARE @TDate DATE; SET @TDate='8/3/2026 12:00:00 AM'; SELECT a.MemberId, a.MemberName, a.NomineeName, a.MemberMobileNo, a.NomineeMobileNo, a.LoanId, convert(CHAR,a.DisburseDate,106)AS DisburseDate, a.LoanTerm AS TotalTerm, a.LoanAmount, a.TotalInterest, a.LoanAmount+a.TotalInterest AS TotalPayable, a.EMIAmount, convert(CHAR,b.LastPaidDate,106)AS LastPaidDate, isnull(b.PaidTerm,0)AS PaidTerm, isnull(b.PaidPrincipal,0)AS PaidPrincipal, isnull(b.PaidInterest,0)AS PaidInterest, isnull(b.PaidTotal,0)AS PaidTotal, convert(CHAR,a.ExpiryDate,106)AS ExpiryDate, a.LoanTerm-isnull(b.PaidTerm,0)AS BalanceTerm, a.LoanAmount-isnull(b.PaidPrincipal,0)-isnull(c.WriteOffAmount,0)AS BalancePrincipal, a.TotalInterest-isnull(b.PaidInterest,0)AS BalanceInterest, a.LoanAmount+a.TotalInterest-isnull(b.PaidTotal,0)-isnull(c.WriteOffAmount,0)AS BalanceTotal, b.TotalPenalty, b.PaidPenalty, b.BalancePenalty, c.WriteOffAmount, dbo.FunNumberOfCharacterFromNumber((a.LoanAmount-isnull(b.PaidPrincipal,0)-isnull(c.WriteOffAmount,0))/2000)AS AmountStr, a.LoanCycle, a.GLoanTypeNo, rtrim(convert(CHAR,a.LoanTerm))+'-'+a.LoanTermMode AS LoanTerm, a.LoanPurpose, a.LoanFunder, a.CenterId, a.CenterName, a.LoanOfficerId, a.LoanOfficerName, a.BranchName+' ('+a.BranchId+')' AS BranchName FROM GroupLoanAccount a WITH(nolock) LEFT JOIN ( SELECT LoanId, MAX(PDate)AS LastPaidDate, COUNT(DISTINCT DNo)AS PaidTerm, SUM(Prin)AS PaidPrincipal, SUM(Intt)AS PaidInterest, SUM(Total)AS PaidTotal, SUM(isnull(PDue,0))AS TotalPenalty, SUM(isnull(PPaid,0))AS PaidPenalty, SUM(isnull(PDue,0))-SUM(isnull(PPaid,0))AS BalancePenalty FROM GroupLoanLedger WITH(nolock) WHERE Total>0 AND PStatus='Paid' AND PDate0 AND PStatus='Writeoff' AND PDate0 AND a.BranchId IN ('100','102','101','104','105','103') AND isnull(a.GroupName,'Group')!='Individual' ORDER BY a.BranchName+' ('+a.BranchId+')', a.LoanOfficerName, a.CenterName, a.MemberName, a.LoanId String sql: Data: System.Collections.ListDictionaryInternal HelpLink: InnerException: Message: Input string was not in a correct format. Source: mscorlib StackTrace: at System.Number.StringToNumber(String str, NumberStyles options, NumberBuffer& number, NumberFormatInfo info, Boolean parseDecimal) at System.Number.ParseDecimal(String value, NumberStyles options, NumberFormatInfo numfmt) at System.Convert.ToDecimal(String value) at GroupLoan_GroupLoanOutstandingReport.grdLoan_RowDataBound(Object sender, GridViewRowEventArgs e) TargetSite: Void StringToNumber(System.String, System.Globalization.NumberStyles, NumberBuffer ByRef, System.Globalization.NumberFormatInfo, Boolean) Time: 03/08/2026 11:19:33 AM PageName: GroupLoan_GroupLoanOutstandingReport String str: DECLARE @TDate DATE; SET @TDate='8/3/2026 12:00:00 AM'; SELECT a.MemberId, a.MemberName, a.NomineeName, a.MemberMobileNo, a.NomineeMobileNo, a.LoanId, convert(CHAR,a.DisburseDate,106)AS DisburseDate, a.LoanTerm AS TotalTerm, a.LoanAmount, a.TotalInterest, a.LoanAmount+a.TotalInterest AS TotalPayable, a.EMIAmount, convert(CHAR,b.LastPaidDate,106)AS LastPaidDate, isnull(b.PaidTerm,0)AS PaidTerm, isnull(b.PaidPrincipal,0)AS PaidPrincipal, isnull(b.PaidInterest,0)AS PaidInterest, isnull(b.PaidTotal,0)AS PaidTotal, convert(CHAR,a.ExpiryDate,106)AS ExpiryDate, a.LoanTerm-isnull(b.PaidTerm,0)AS BalanceTerm, a.LoanAmount-isnull(b.PaidPrincipal,0)-isnull(c.WriteOffAmount,0)AS BalancePrincipal, a.TotalInterest-isnull(b.PaidInterest,0)AS BalanceInterest, a.LoanAmount+a.TotalInterest-isnull(b.PaidTotal,0)-isnull(c.WriteOffAmount,0)AS BalanceTotal, b.TotalPenalty, b.PaidPenalty, b.BalancePenalty, c.WriteOffAmount, dbo.FunNumberOfCharacterFromNumber((a.LoanAmount-isnull(b.PaidPrincipal,0)-isnull(c.WriteOffAmount,0))/2000)AS AmountStr, a.LoanCycle, a.GLoanTypeNo, rtrim(convert(CHAR,a.LoanTerm))+'-'+a.LoanTermMode AS LoanTerm, a.LoanPurpose, a.LoanFunder, a.CenterId, a.CenterName, a.LoanOfficerId, a.LoanOfficerName, a.BranchName+' ('+a.BranchId+')' AS BranchName FROM GroupLoanAccount a WITH(nolock) LEFT JOIN ( SELECT LoanId, MAX(PDate)AS LastPaidDate, COUNT(DISTINCT DNo)AS PaidTerm, SUM(Prin)AS PaidPrincipal, SUM(Intt)AS PaidInterest, SUM(Total)AS PaidTotal, SUM(isnull(PDue,0))AS TotalPenalty, SUM(isnull(PPaid,0))AS PaidPenalty, SUM(isnull(PDue,0))-SUM(isnull(PPaid,0))AS BalancePenalty FROM GroupLoanLedger WITH(nolock) WHERE Total>0 AND PStatus='Paid' AND PDate0 AND PStatus='Writeoff' AND PDate0 AND a.BranchId IN ('100','102','101','104','105','103') AND isnull(a.GroupName,'Group')!='Individual' ORDER BY a.BranchName+' ('+a.BranchId+')', a.LoanOfficerName, a.CenterName, a.MemberName, a.LoanId String sql: Data: System.Collections.ListDictionaryInternal HelpLink: InnerException: Message: Input string was not in a correct format. Source: mscorlib StackTrace: at System.Number.StringToNumber(String str, NumberStyles options, NumberBuffer& number, NumberFormatInfo info, Boolean parseDecimal) at System.Number.ParseDecimal(String value, NumberStyles options, NumberFormatInfo numfmt) at System.Convert.ToDecimal(String value) at GroupLoan_GroupLoanOutstandingReport.grdLoan_RowDataBound(Object sender, GridViewRowEventArgs e) TargetSite: Void StringToNumber(System.String, System.Globalization.NumberStyles, NumberBuffer ByRef, System.Globalization.NumberFormatInfo, Boolean) Time: 03/08/2026 11:19:33 AM PageName: GroupLoan_GroupLoanOutstandingReport String str: DECLARE @TDate DATE; SET @TDate='8/3/2026 12:00:00 AM'; SELECT a.MemberId, a.MemberName, a.NomineeName, a.MemberMobileNo, a.NomineeMobileNo, a.LoanId, convert(CHAR,a.DisburseDate,106)AS DisburseDate, a.LoanTerm AS TotalTerm, a.LoanAmount, a.TotalInterest, a.LoanAmount+a.TotalInterest AS TotalPayable, a.EMIAmount, convert(CHAR,b.LastPaidDate,106)AS LastPaidDate, isnull(b.PaidTerm,0)AS PaidTerm, isnull(b.PaidPrincipal,0)AS PaidPrincipal, isnull(b.PaidInterest,0)AS PaidInterest, isnull(b.PaidTotal,0)AS PaidTotal, convert(CHAR,a.ExpiryDate,106)AS ExpiryDate, a.LoanTerm-isnull(b.PaidTerm,0)AS BalanceTerm, a.LoanAmount-isnull(b.PaidPrincipal,0)-isnull(c.WriteOffAmount,0)AS BalancePrincipal, a.TotalInterest-isnull(b.PaidInterest,0)AS BalanceInterest, a.LoanAmount+a.TotalInterest-isnull(b.PaidTotal,0)-isnull(c.WriteOffAmount,0)AS BalanceTotal, b.TotalPenalty, b.PaidPenalty, b.BalancePenalty, c.WriteOffAmount, dbo.FunNumberOfCharacterFromNumber((a.LoanAmount-isnull(b.PaidPrincipal,0)-isnull(c.WriteOffAmount,0))/2000)AS AmountStr, a.LoanCycle, a.GLoanTypeNo, rtrim(convert(CHAR,a.LoanTerm))+'-'+a.LoanTermMode AS LoanTerm, a.LoanPurpose, a.LoanFunder, a.CenterId, a.CenterName, a.LoanOfficerId, a.LoanOfficerName, a.BranchName+' ('+a.BranchId+')' AS BranchName FROM GroupLoanAccount a WITH(nolock) LEFT JOIN ( SELECT LoanId, MAX(PDate)AS LastPaidDate, COUNT(DISTINCT DNo)AS PaidTerm, SUM(Prin)AS PaidPrincipal, SUM(Intt)AS PaidInterest, SUM(Total)AS PaidTotal, SUM(isnull(PDue,0))AS TotalPenalty, SUM(isnull(PPaid,0))AS PaidPenalty, SUM(isnull(PDue,0))-SUM(isnull(PPaid,0))AS BalancePenalty FROM GroupLoanLedger WITH(nolock) WHERE Total>0 AND PStatus='Paid' AND PDate0 AND PStatus='Writeoff' AND PDate0 AND a.BranchId IN ('100','102','101','104','105','103') AND isnull(a.GroupName,'Group')!='Individual' ORDER BY a.BranchName+' ('+a.BranchId+')', a.LoanOfficerName, a.CenterName, a.MemberName, a.LoanId String sql: Data: System.Collections.ListDictionaryInternal HelpLink: InnerException: Message: Input string was not in a correct format. Source: mscorlib StackTrace: at System.Number.StringToNumber(String str, NumberStyles options, NumberBuffer& number, NumberFormatInfo info, Boolean parseDecimal) at System.Number.ParseDecimal(String value, NumberStyles options, NumberFormatInfo numfmt) at System.Convert.ToDecimal(String value) at GroupLoan_GroupLoanOutstandingReport.grdLoan_RowDataBound(Object sender, GridViewRowEventArgs e) TargetSite: Void StringToNumber(System.String, System.Globalization.NumberStyles, NumberBuffer ByRef, System.Globalization.NumberFormatInfo, Boolean) Time: 03/08/2026 11:27:00 AM PageName: DataTableResult String str: DECLARE @ODate DATE; SET @ODate='8/3/2026 12:00:00 AM'; DECLARE @FTable TABLE ( BranchName VARCHAR(50), LoanOfficerId VARCHAR(20), LoanOfficerName VARCHAR(50), CenterId VARCHAR(20), CenterName VARCHAR(50), MeetingDay VARCHAR(20), MeetingTime VARCHAR(20), MeetingType VARCHAR(20), MemberId VARCHAR(20), MemberName VARCHAR(60), NomineeName VARCHAR(60), MemberMobileNo varchar(20), LoanId VARCHAR(50), LoanCycle VARCHAR(2), DisburseDate VARCHAR(20), LoanAmount DECIMAL(10,2), EMIAmount DECIMAL(10,2), LoanTerm INT, ODFromDate VARCHAR(20), NoOfOD INT, DueDate VARCHAR(20), DueNo INT, LastPaidDate varchar(20), MeetingAmount DECIMAL(10,2), ODAmount DECIMAL(10,2), DueAmount DECIMAL(10,2), AdvanceAmount DECIMAL(10,2), Outstanding DECIMAL(10,2), BalanceAmount DECIMAL(10,2), PayableAmount DECIMAL(10,2), DemandAmount DECIMAL(10,2), TodayPaidAmount DECIMAL(10,2), TodayNotReceived DECIMAL(10,2) ); DECLARE @CTable TABLE ( BranchName VARCHAR(50), CenterOfficerId VARCHAR(20), CenterOfficerName VARCHAR(50), CenterId VARCHAR(20), CenterName VARCHAR(50), MeetingDay VARCHAR(20), MeetingTime VARCHAR(20) ); INSERT INTO @CTable ( BranchName, CenterOfficerId, CenterOfficerName, CenterId, CenterName, MeetingDay, MeetingTime ) SELECT a.BranchName, a.CenterOfficerId, a.CenterOfficerName, a.CenterId, a.CenterName, a.MeetingDay, a.MeetingTime FROM GroupCenterMaster a WITH(nolock) WHERE a.CenterStatus='Active' AND a.MeetingType='Daily' AND a.BranchId='102' INSERT INTO @CTable ( BranchName, CenterOfficerId, CenterOfficerName, CenterId, CenterName, MeetingDay, MeetingTime ) SELECT a.BranchName, a.CenterOfficerId, a.CenterOfficerName, a.CenterId, a.CenterName, a.MeetingDay, a.MeetingTime FROM GroupCenterMaster a WITH(nolock) WHERE a.CenterStatus='Active' AND a.MeetingType IN ('Weekly','BiWeekly') AND a.MeetingDay=datename(dw, @ODate) AND a.BranchId='102' INSERT INTO @CTable ( BranchName, CenterOfficerId, CenterOfficerName, CenterId, CenterName, MeetingDay, MeetingTime ) SELECT a.BranchName, a.CenterOfficerId, a.CenterOfficerName, a.CenterId, a.CenterName, a.MeetingDay, a.MeetingTime FROM GroupCenterMaster a WITH(nolock) WHERE a.CenterStatus='Active' AND a.MeetingType='Monthly' AND a.MeetingDay=datepart(day, @ODate) AND a.BranchId='102' INSERT INTO @FTable ( BranchName, LoanOfficerId, LoanOfficerName, CenterId, CenterName, MeetingDay, MeetingTime, MeetingType, MemberId, MemberName, NomineeName, MemberMobileNo, LoanId, LoanCycle, DisburseDate, LoanAmount, LoanTerm, EMIAmount, MeetingAmount ) SELECT b.BranchName, b.CenterOfficerId, b.CenterOfficerName, b.CenterId, b.CenterName, b.MeetingDay, b.MeetingTime, a.LoanTermMode AS MeetingType, a.MemberId, a.MemberName, a.NomineeName, a.MemberMobileNo, a.LoanId, a.LoanCycle, rtrim(convert(CHAR, a.DisburseDate, 103))AS DisburseDate, a.LoanAmount, a.LoanTerm, a.EMIAmount, CASE WHEN a.CMDatedateadd(day,-1,@ODate) AND a.LoanStatus IN ('LoanDisbursed','LoanClosed' ) AND a.BranchId='102' DECLARE @TTable TABLE ( LoanId VARCHAR(50), DDate DATE, PDate DATE, DNo INT, Prin DECIMAL(10,2), Intt DECIMAL(10,2), Total DECIMAL(10,2), PStatus VARCHAR(10) ); INSERT INTO @TTable ( LoanId, DDate, PDate, DNo, Prin, Intt, Total, PStatus ) SELECT a.LoanId, a.DDate, a.PDate, a.DNo, a.Prin, a.Intt, a.Total, a.PStatus FROM GroupLoanLedger a WITH(nolock) INNER JOIN @FTable b ON a.LoanId=b.LoanId WHERE a.DNo>0 ; UPDATE ta SET ta.LastPaidDate=(SELECT Convert(char,MAX(PDate),106) FROM @TTable WHERE PStatus='Paid' AND LoanId=ta.LoanId) FROM @FTable ta; UPDATE ta SET ta.NoOfOD=(SELECT COUNT(DISTINCT DNo) FROM @TTable WHERE isnull(PDate,dateadd(day,1,@ODate))>dateadd(day,0,@ODate) AND DDate<@ODate AND LoanId=ta.LoanId) FROM @FTable ta; UPDATE ta SET ta.ODAmount=(SELECT SUM(Total) FROM @TTable WHERE isnull(PDate,dateadd(day,1,@ODate))>dateadd(day,0,@ODate) AND DDate<@ODate AND LoanId=ta.LoanId) FROM @FTable ta; UPDATE ta SET ta.DueDate=(SELECT Convert(CHAR,MIN(DDate),106) FROM @TTable WHERE isnull(PDate,dateadd(day,0,@ODate))>dateadd(day,-1,@ODate) AND LoanId=ta.LoanId) FROM @FTable ta; UPDATE ta SET ta.DueNo=(SELECT MIN(DNo) FROM @TTable WHERE isnull(PDate,dateadd(day,0,@ODate))>dateadd(day,-1,@ODate) AND LoanId=ta.LoanId) FROM @FTable ta; UPDATE ta SET ta.DueAmount=(SELECT SUM(Total) FROM @TTable WHERE isnull(PDate,dateadd(day,0,@ODate))>dateadd(day,-1,@ODate) AND DDate=dateadd(day,0,@ODate) AND LoanId=ta.LoanId) FROM @FTable ta; UPDATE ta SET ta.Outstanding=(SELECT SUM(Prin) FROM @TTable WHERE isnull(PDate,dateadd(day,0,@ODate))>dateadd(day,-1,@ODate) AND LoanId=ta.LoanId) FROM @FTable ta; UPDATE ta SET ta.BalanceAmount=(SELECT SUM(Total) FROM @TTable WHERE isnull(PDate,dateadd(day,0,@ODate))>dateadd(day,-1,@ODate) AND LoanId=ta.LoanId) FROM @FTable ta; UPDATE ta SET ta.TodayPaidAmount=(SELECT SUM(Total) FROM @TTable WHERE LoanId=ta.LoanId AND PStatus='Paid' AND PDate=@ODate) FROM @FTable ta; UPDATE ta SET ta.AdvanceAmount=(SELECT SUM(Total) FROM @TTable WHERE PStatus='Paid' AND PDatedateadd(day,0,@ODate) AND LoanId=ta.LoanId) FROM @FTable ta; UPDATE ta SET ta.PayableAmount=CASE WHEN isnull(ta.MeetingAmount,0)>0 THEN 0 ELSE isnull(ta.ODAmount,0)+isnull(ta.DueAmount, 0) END FROM @FTable ta; UPDATE ta SET ta.DemandAmount=CASE WHEN isnull(ta.DueAmount,0)>0 THEN ta.DueAmount WHEN isnull(ta.DueAmount,0)=0 AND isnull(ta.ODAmount,0)>0 THEN ta.EMIAmount ELSE isnull(ta.ODAmount,0)+isnull(ta.DueAmount,0) END FROM @FTable ta; UPDATE ta SET ta.DemandAmount=CASE WHEN isnull(ta.BalanceAmount,0)>isnull(ta.DemandAmount,0) THEN ta.DemandAmount ELSE isnull(ta.BalanceAmount,0) END FROM @FTable ta; UPDATE ta SET ta.TodayNotReceived=CASE WHEN isnull(ta.DemandAmount,0)>isnull(ta.TodayPaidAmount,0) THEN isnull(ta.DemandAmount,0)-isnull(ta.TodayPaidAmount,0) ELSE 0 END FROM @FTable ta; SELECT a.MemberId, a.MemberName, a.NomineeName, a.MemberMobileNo, a.LoanId, a.DueDate, a.DueNo, a.NoOfOD, a.ODAmount, a.DueAmount, a.BalanceAmount, a.PayableAmount, a.DemandAmount, a.TodayPaidAmount, a.TodayNotReceived, a.MeetingAmount, a.AdvanceAmount, a.Outstanding, a.EMIAmount, a.LoanAmount, a.LastPaidDate, a.DisburseDate, convert(CHAR,rtrim(a.LoanTerm))+'-'+a.MeetingType AS LoanTerm, a.CenterId, a.CenterName, a.LoanOfficerId, a.LoanOfficerName, a.BranchName FROM @FTable a WHERE isnull(a.BalanceAmount, 0)+isnull(a.TodayPaidAmount, 0)> 0 ORDER BY a.BranchName, a.LoanOfficerName, a.CenterName, a.MemberName String sql: Data: System.Collections.ListDictionaryInternal HelpLink: InnerException: Message: Conversion failed when converting the varchar value 'Monday' to data type int. Source: .Net SqlClient Data Provider StackTrace: at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose) at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady) at System.Data.SqlClient.SqlDataReader.TryConsumeMetaData() at System.Data.SqlClient.SqlDataReader.get_MetaData() at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString, Boolean isInternal, Boolean forDescribeParameterEncryption, Boolean shouldCacheForAlwaysEncrypted) at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async, Int32 timeout, Task& task, Boolean asyncWrite, Boolean inRetry, SqlDataReader ds, Boolean describeParameterEncryptionRequest) at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, TaskCompletionSource`1 completion, Int32 timeout, Task& task, Boolean& usedCache, Boolean asyncWrite, Boolean inRetry) at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method) at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior, String method) at System.Data.SqlClient.SqlCommand.ExecuteDbDataReader(CommandBehavior behavior) at System.Data.Common.DbCommand.System.Data.IDbCommand.ExecuteReader(CommandBehavior behavior) at System.Data.Common.DbDataAdapter.FillInternal(DataSet dataset, DataTable[] datatables, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior) at System.Data.Common.DbDataAdapter.Fill(DataTable[] dataTables, Int32 startRecord, Int32 maxRecords, IDbCommand command, CommandBehavior behavior) at System.Data.Common.DbDataAdapter.Fill(DataTable dataTable) at ClassMaster.DataTableResult(String query) TargetSite: Void OnError(System.Data.SqlClient.SqlException, Boolean, System.Action`1[System.Action]) Time: 03/08/2026 11:27:00 AM PageName: GroupLoan_GroupLoanCurrentStatusReport String str: DECLARE @ODate DATE; SET @ODate='8/3/2026 12:00:00 AM'; DECLARE @FTable TABLE ( BranchName VARCHAR(50), LoanOfficerId VARCHAR(20), LoanOfficerName VARCHAR(50), CenterId VARCHAR(20), CenterName VARCHAR(50), MeetingDay VARCHAR(20), MeetingTime VARCHAR(20), MeetingType VARCHAR(20), MemberId VARCHAR(20), MemberName VARCHAR(60), NomineeName VARCHAR(60), MemberMobileNo varchar(20), LoanId VARCHAR(50), LoanCycle VARCHAR(2), DisburseDate VARCHAR(20), LoanAmount DECIMAL(10,2), EMIAmount DECIMAL(10,2), LoanTerm INT, ODFromDate VARCHAR(20), NoOfOD INT, DueDate VARCHAR(20), DueNo INT, LastPaidDate varchar(20), MeetingAmount DECIMAL(10,2), ODAmount DECIMAL(10,2), DueAmount DECIMAL(10,2), AdvanceAmount DECIMAL(10,2), Outstanding DECIMAL(10,2), BalanceAmount DECIMAL(10,2), PayableAmount DECIMAL(10,2), DemandAmount DECIMAL(10,2), TodayPaidAmount DECIMAL(10,2), TodayNotReceived DECIMAL(10,2) ); DECLARE @CTable TABLE ( BranchName VARCHAR(50), CenterOfficerId VARCHAR(20), CenterOfficerName VARCHAR(50), CenterId VARCHAR(20), CenterName VARCHAR(50), MeetingDay VARCHAR(20), MeetingTime VARCHAR(20) ); INSERT INTO @CTable ( BranchName, CenterOfficerId, CenterOfficerName, CenterId, CenterName, MeetingDay, MeetingTime ) SELECT a.BranchName, a.CenterOfficerId, a.CenterOfficerName, a.CenterId, a.CenterName, a.MeetingDay, a.MeetingTime FROM GroupCenterMaster a WITH(nolock) WHERE a.CenterStatus='Active' AND a.MeetingType='Daily' AND a.BranchId='102' INSERT INTO @CTable ( BranchName, CenterOfficerId, CenterOfficerName, CenterId, CenterName, MeetingDay, MeetingTime ) SELECT a.BranchName, a.CenterOfficerId, a.CenterOfficerName, a.CenterId, a.CenterName, a.MeetingDay, a.MeetingTime FROM GroupCenterMaster a WITH(nolock) WHERE a.CenterStatus='Active' AND a.MeetingType IN ('Weekly','BiWeekly') AND a.MeetingDay=datename(dw, @ODate) AND a.BranchId='102' INSERT INTO @CTable ( BranchName, CenterOfficerId, CenterOfficerName, CenterId, CenterName, MeetingDay, MeetingTime ) SELECT a.BranchName, a.CenterOfficerId, a.CenterOfficerName, a.CenterId, a.CenterName, a.MeetingDay, a.MeetingTime FROM GroupCenterMaster a WITH(nolock) WHERE a.CenterStatus='Active' AND a.MeetingType='Monthly' AND a.MeetingDay=datepart(day, @ODate) AND a.BranchId='102' INSERT INTO @FTable ( BranchName, LoanOfficerId, LoanOfficerName, CenterId, CenterName, MeetingDay, MeetingTime, MeetingType, MemberId, MemberName, NomineeName, MemberMobileNo, LoanId, LoanCycle, DisburseDate, LoanAmount, LoanTerm, EMIAmount, MeetingAmount ) SELECT b.BranchName, b.CenterOfficerId, b.CenterOfficerName, b.CenterId, b.CenterName, b.MeetingDay, b.MeetingTime, a.LoanTermMode AS MeetingType, a.MemberId, a.MemberName, a.NomineeName, a.MemberMobileNo, a.LoanId, a.LoanCycle, rtrim(convert(CHAR, a.DisburseDate, 103))AS DisburseDate, a.LoanAmount, a.LoanTerm, a.EMIAmount, CASE WHEN a.CMDatedateadd(day,-1,@ODate) AND a.LoanStatus IN ('LoanDisbursed','LoanClosed' ) AND a.BranchId='102' DECLARE @TTable TABLE ( LoanId VARCHAR(50), DDate DATE, PDate DATE, DNo INT, Prin DECIMAL(10,2), Intt DECIMAL(10,2), Total DECIMAL(10,2), PStatus VARCHAR(10) ); INSERT INTO @TTable ( LoanId, DDate, PDate, DNo, Prin, Intt, Total, PStatus ) SELECT a.LoanId, a.DDate, a.PDate, a.DNo, a.Prin, a.Intt, a.Total, a.PStatus FROM GroupLoanLedger a WITH(nolock) INNER JOIN @FTable b ON a.LoanId=b.LoanId WHERE a.DNo>0 ; UPDATE ta SET ta.LastPaidDate=(SELECT Convert(char,MAX(PDate),106) FROM @TTable WHERE PStatus='Paid' AND LoanId=ta.LoanId) FROM @FTable ta; UPDATE ta SET ta.NoOfOD=(SELECT COUNT(DISTINCT DNo) FROM @TTable WHERE isnull(PDate,dateadd(day,1,@ODate))>dateadd(day,0,@ODate) AND DDate<@ODate AND LoanId=ta.LoanId) FROM @FTable ta; UPDATE ta SET ta.ODAmount=(SELECT SUM(Total) FROM @TTable WHERE isnull(PDate,dateadd(day,1,@ODate))>dateadd(day,0,@ODate) AND DDate<@ODate AND LoanId=ta.LoanId) FROM @FTable ta; UPDATE ta SET ta.DueDate=(SELECT Convert(CHAR,MIN(DDate),106) FROM @TTable WHERE isnull(PDate,dateadd(day,0,@ODate))>dateadd(day,-1,@ODate) AND LoanId=ta.LoanId) FROM @FTable ta; UPDATE ta SET ta.DueNo=(SELECT MIN(DNo) FROM @TTable WHERE isnull(PDate,dateadd(day,0,@ODate))>dateadd(day,-1,@ODate) AND LoanId=ta.LoanId) FROM @FTable ta; UPDATE ta SET ta.DueAmount=(SELECT SUM(Total) FROM @TTable WHERE isnull(PDate,dateadd(day,0,@ODate))>dateadd(day,-1,@ODate) AND DDate=dateadd(day,0,@ODate) AND LoanId=ta.LoanId) FROM @FTable ta; UPDATE ta SET ta.Outstanding=(SELECT SUM(Prin) FROM @TTable WHERE isnull(PDate,dateadd(day,0,@ODate))>dateadd(day,-1,@ODate) AND LoanId=ta.LoanId) FROM @FTable ta; UPDATE ta SET ta.BalanceAmount=(SELECT SUM(Total) FROM @TTable WHERE isnull(PDate,dateadd(day,0,@ODate))>dateadd(day,-1,@ODate) AND LoanId=ta.LoanId) FROM @FTable ta; UPDATE ta SET ta.TodayPaidAmount=(SELECT SUM(Total) FROM @TTable WHERE LoanId=ta.LoanId AND PStatus='Paid' AND PDate=@ODate) FROM @FTable ta; UPDATE ta SET ta.AdvanceAmount=(SELECT SUM(Total) FROM @TTable WHERE PStatus='Paid' AND PDatedateadd(day,0,@ODate) AND LoanId=ta.LoanId) FROM @FTable ta; UPDATE ta SET ta.PayableAmount=CASE WHEN isnull(ta.MeetingAmount,0)>0 THEN 0 ELSE isnull(ta.ODAmount,0)+isnull(ta.DueAmount, 0) END FROM @FTable ta; UPDATE ta SET ta.DemandAmount=CASE WHEN isnull(ta.DueAmount,0)>0 THEN ta.DueAmount WHEN isnull(ta.DueAmount,0)=0 AND isnull(ta.ODAmount,0)>0 THEN ta.EMIAmount ELSE isnull(ta.ODAmount,0)+isnull(ta.DueAmount,0) END FROM @FTable ta; UPDATE ta SET ta.DemandAmount=CASE WHEN isnull(ta.BalanceAmount,0)>isnull(ta.DemandAmount,0) THEN ta.DemandAmount ELSE isnull(ta.BalanceAmount,0) END FROM @FTable ta; UPDATE ta SET ta.TodayNotReceived=CASE WHEN isnull(ta.DemandAmount,0)>isnull(ta.TodayPaidAmount,0) THEN isnull(ta.DemandAmount,0)-isnull(ta.TodayPaidAmount,0) ELSE 0 END FROM @FTable ta; SELECT a.MemberId, a.MemberName, a.NomineeName, a.MemberMobileNo, a.LoanId, a.DueDate, a.DueNo, a.NoOfOD, a.ODAmount, a.DueAmount, a.BalanceAmount, a.PayableAmount, a.DemandAmount, a.TodayPaidAmount, a.TodayNotReceived, a.MeetingAmount, a.AdvanceAmount, a.Outstanding, a.EMIAmount, a.LoanAmount, a.LastPaidDate, a.DisburseDate, convert(CHAR,rtrim(a.LoanTerm))+'-'+a.MeetingType AS LoanTerm, a.CenterId, a.CenterName, a.LoanOfficerId, a.LoanOfficerName, a.BranchName FROM @FTable a WHERE isnull(a.BalanceAmount, 0)+isnull(a.TodayPaidAmount, 0)> 0 ORDER BY a.BranchName, a.LoanOfficerName, a.CenterName, a.MemberName String sql: Data: System.Collections.ListDictionaryInternal HelpLink: InnerException: Message: Object reference not set to an instance of an object. Source: App_Web_k55ywkwr StackTrace: at GroupLoan_GroupLoanCurrentStatusReport.btnSearch_Click(Object sender, EventArgs e) TargetSite: Void btnSearch_Click(System.Object, System.EventArgs) Time: 03/08/2026 05:42:59 PM PageName: Employee_PrintRDLCPage String str: SELECT (SELECT ReportValue FROM ProjectReportSetting WITH(nolock) WHERE ReportName='CompanyURL')+'ResponsiveCSS/images/EmployeeIDCardBackImage.jpg' AS C1, (SELECT ReportValue AS EmployeeIDCardBackRDLC FROM ProjectReportSetting WITH(nolock) WHERE ReportName='EmployeeIDCardBackRDLC')AS C95 FROM EmployeeRegistrationDetail a WITH(nolock) WHERE a.EmployeeId='EMP00101' ; String sql: Data: System.Collections.ListDictionaryInternal HelpLink: InnerException: Message: Thread was being aborted. Source: mscorlib StackTrace: at System.Threading.Thread.AbortInternal() at System.Threading.Thread.Abort(Object stateInfo) at System.Web.HttpResponse.AbortCurrentThread() at System.Web.HttpResponse.End() at Employee_PrintRDLCPage.EmployeeAppointmentLetter() TargetSite: Void AbortInternal() Time: 03/08/2026 05:42:59 PM PageName: Employee_PrintRDLCPage String str: SELECT (SELECT ReportValue FROM ProjectReportSetting WITH(nolock) WHERE ReportName='CompanyURL')+'ResponsiveCSS/images/EmployeeIDCardBackImage.jpg' AS C1, (SELECT ReportValue AS EmployeeIDCardBackRDLC FROM ProjectReportSetting WITH(nolock) WHERE ReportName='EmployeeIDCardBackRDLC')AS C95 FROM EmployeeRegistrationDetail a WITH(nolock) WHERE a.EmployeeId='EMP00101' ; String sql: Data: System.Collections.ListDictionaryInternal HelpLink: InnerException: Message: Thread was being aborted. Source: App_Web_iii1f5hs StackTrace: at Employee_PrintRDLCPage.EmployeeAppointmentLetter() at Employee_PrintRDLCPage.Page_Load(Object sender, EventArgs e) TargetSite: Void EmployeeAppointmentLetter() Time: 03/08/2026 06:41:59 PM PageName: DataTableResult String str: DECLARE @ApplicationId VARCHAR(25), @OnDate DATE; SET @ApplicationId='GA10100042'; DECLARE @FTable TABLE ( BranchId VARCHAR(10), BranchName VARCHAR(50), LoanOfficerId VARCHAR(20), LoanOfficerName VARCHAR(50), MemberRemark VARCHAR(150), MemberId VARCHAR(20), MemberName VARCHAR(50), GuardianName VARCHAR(50), MemberDOB VARCHAR(20), MemberAge VARCHAR(10), MobileNo VARCHAR(20), ContactNo VARCHAR(20), MemberAddress VARCHAR(250), NomineeName VARCHAR(50), NomineeDOB VARCHAR(20), NomineeAge VARCHAR(10), NomineeRelation VARCHAR(50), MemberBankName VARCHAR(50), BankBranchName VARCHAR(50), BankAccountNo VARCHAR(20), BankIFSCCode VARCHAR(20), BankAccountName VARCHAR(50), BankResponse VARCHAR(50), ApplicationRemark VARCHAR(250), ApplicationUserAndTime VARCHAR(100), ApplicationDocument1 VARCHAR(100), ApplicationDocument2 VARCHAR(100), ApplicationDate VARCHAR(20), ApplicationAmount DECIMAL(18,2), TotalAmount DECIMAL(18,2), EMIAmount DECIMAL(18,2), FirstEMIPaid VARCHAR(10), FDAmountApplied DECIMAL(18,2), RDAmountApplied DECIMAL(18,2), DownPaymentApplied DECIMAL(18,2), LoanTypeNo VARCHAR(50), LoanTypeName VARCHAR(50), InterestMethod VARCHAR(20), LoanTypeGroup VARCHAR(20), LoanTerm VARCHAR(10), LoanTermMode VARCHAR(20), LoanPurpose VARCHAR(50), InterestRate VARCHAR(10), NoPayingTerm VARCHAR(10), LoanHeadNameId VARCHAR(10), LoanHeadNameName VARCHAR(100), ProcessingFeeAmount DECIMAL(10,6), ProcessingFeePercent DECIMAL(10,6), ProcessingGSTPercent DECIMAL(10,6), AccountHeadProcessingId VARCHAR(10), AccountHeadProcessingName VARCHAR(100), InsuranceFeeAmount DECIMAL(10,6), InsuranceFeePercent DECIMAL(10,6), InsuranceGSTPercent DECIMAL(10,6), AccountHeadInsuranceId VARCHAR(10), AccountHeadInsuranceName VARCHAR(100), OtherChargeAmount DECIMAL(10,6), OtherChargePercent DECIMAL(10,6), OtherChargeGSTPercent DECIMAL(10,6), AccountHeadOtherChargeId VARCHAR(10), AccountHeadOtherChargeName VARCHAR(100), SecurityFeeAmount DECIMAL(10,6), SecurityFeePercent DECIMAL(10,6), AccountHeadSecurityId VARCHAR(10), AccountHeadSecurityName VARCHAR(100), FDAmountAmount DECIMAL(10,6), FDAmountPercent DECIMAL(10,6), AccountHeadFDAmountId VARCHAR(10), AccountHeadFDAmountName VARCHAR(100), RDAmountAmount DECIMAL(10,6), RDAmountPercent DECIMAL(10,6), AccountHeadRDAmountId VARCHAR(10), AccountHeadRDAmountName VARCHAR(100), DownPaymentAmount DECIMAL(10,6), DownPaymentPercent DECIMAL(10,6), AccountHeadDownPaymentId VARCHAR(10), AccountHeadDownPaymentName VARCHAR(100), InterestType VARCHAR(20), ManualEMIAmount VARCHAR(20), EMIAmountType VARCHAR(20), FirstInstallmentType VARCHAR(20), FirstEMIDate VARCHAR(20)); INSERT INTO @FTable ( BranchId, BranchName, LoanOfficerId, LoanOfficerName, MemberId, MemberName, MobileNo, ContactNo, NomineeName, NomineeDOB, NomineeAge, NomineeRelation, MemberBankName, BankBranchName, BankAccountNo, BankIFSCCode, ApplicationRemark, ApplicationUserAndTime, ApplicationDocument1, ApplicationDocument2, ApplicationDate, ApplicationAmount, TotalAmount, EMIAmount, FirstEMIPaid, FDAmountApplied, RDAmountApplied, DownPaymentApplied, LoanTypeNo, LoanTypeName, InterestMethod, LoanTypeGroup, LoanTerm, LoanTermMode, LoanPurpose, InterestRate ) SELECT a.BranchId, a.BranchName, a.LoanOfficerId, a.LoanOfficerName, a.MemberId, a.MemberName, a.MobileNo, a.ContactNo, a.NomineeName, convert(CHAR,a.NomineeDOB,103)AS NomineeDOB, a.NomineeAge, a.NomineeRelation, a.MemberBankName, a.BankBranchName, a.BankAccountNo, a.BankIFSCCode, a.ApplicationRemark, a.ApplicationEntryUser+' on '+rtrim(convert(CHAR,a.ApplicationEntryTime,106))+' - '+rtrim(convert(CHAR,a.ApplicationEntryTime,108))AS ApplicationUserAndTime, a.ApplicationDoc1 AS ApplicationDocument1, a.ApplicationDoc2 AS ApplicationDocument2, convert(CHAR,a.ApplicationDate,103)AS ApplicationDate, a.ApplicationAmount, a.TotalAmount, a.EMIAmount, a.FirstEMIPaid, a.FDAmount AS FDAmountApplied, a.RDAmount AS RDAmountApplied, a.DownPayment AS DownPaymentApplied, a.GLoanTypeNo AS LoanTypeNo, a.GLoanTypeName AS LoanTypeName, a.InterestMethod, a.GLoanType AS LoanTypeGroup, a.LoanTerm, a.LoanTermMode, a.LoanPurpose, a.InterestRate FROM GroupLoanAccount a WITH(nolock) WHERE a.ApplicationId=@ApplicationId ; UPDATE a SET a.GuardianName=b.MemberGuardianName, a.MemberRemark=b.MemberRemark, a.MemberDOB=b.MemberDOB, a.MemberAge=b.MemberAge, a.MemberAddress=b.MemberAddress FROM @FTable a INNER JOIN ( SELECT MemberId, MemberGuardianName, convert(char,MemberDOB,106)AS MemberDOB, MemberAge, MemberAddress, MemberRemark FROM GroupLoanMemberDetail WITH(nolock) WHERE MemberId= (SELECT MemberId FROM @FTable) )b ON a.MemberId=b.MemberId ; UPDATE a SET a.BankAccountName=b.accountName, a.BankResponse=b.bankResponse FROM @FTable a INNER JOIN ( SELECT TOP 1 AccountNo, IFSCCode, accountName, bankResponse FROM BankAccountVerification WITH(nolock) WHERE AccountNo=(SELECT BankAccountNo FROM @FTable) AND IFSCCode=(SELECT BankIFSCCode FROM @FTable) ORDER BY EntryTime DESC, bankResponse DESC )b ON a.BankAccountNo=b.AccountNo AND a.MemberId=b.IFSCCode ; UPDATE a SET a.NoPayingTerm=b.NoPayingTerm, a.LoanHeadNameId=b.AccountHeadLoanId, a.LoanHeadNameName=b.AccountHeadLoanName, a.ProcessingFeeAmount=b.ProcessingFeeAmount, a.ProcessingFeePercent=b.ProcessingFeePercent, a.ProcessingGSTPercent=b.ProcessingGSTPercent, a.AccountHeadProcessingId=b.AccountHeadProcessingId, a.AccountHeadProcessingName=b.AccountHeadProcessingName, a.InsuranceFeeAmount=b.InsuranceFeeAmount, a.InsuranceFeePercent=b.InsuranceFeePercent, a.InsuranceGSTPercent=b.InsuranceGSTPercent, a.AccountHeadInsuranceId=b.AccountHeadInsuranceId, a.AccountHeadInsuranceName=b.AccountHeadInsuranceName, a.OtherChargeAmount=b.OtherChargeAmount, a.OtherChargePercent=b.OtherChargePercent, a.OtherChargeGSTPercent=b.OtherChargeGSTPercent, a.AccountHeadOtherChargeId=b.AccountHeadOtherChargeId, a.AccountHeadOtherChargeName=b.AccountHeadOtherChargeName, a.SecurityFeeAmount=b.SecurityFeeAmount, a.SecurityFeePercent=b.SecurityFeePercent, a.AccountHeadSecurityId=b.AccountHeadSecurityId, a.AccountHeadSecurityName=b.AccountHeadSecurityName, a.FDAmountAmount=b.FDAmountAmount, a.FDAmountPercent=b.FDAmountPercent, a.AccountHeadFDAmountId=b.AccountHeadFDAmountId, a.AccountHeadFDAmountName=b.AccountHeadFDAmountName, a.RDAmountAmount=b.RDAmountAmount, a.RDAmountPercent=b.RDAmountPercent, a.AccountHeadRDAmountId=b.AccountHeadRDAmountId, a.AccountHeadRDAmountName=b.AccountHeadRDAmountName, a.DownPaymentAmount=b.DownPaymentAmount, a.DownPaymentPercent=b.DownPaymentPercent, a.AccountHeadDownPaymentId=b.AccountHeadDownPaymentId, a.AccountHeadDownPaymentName=b.AccountHeadDownPaymentName, a.InterestType=b.InterestType, a.ManualEMIAmount=b.EMIAmount, a.EMIAmountType=b.EMIAmountType, a.FirstInstallmentType=b.FirstInstallmentType FROM @FTable a INNER JOIN GroupLoanNoMaster b WITH(nolock) ON a.LoanTypeNo=b.GLoanTypeNo ; SELECT BranchId, BranchName, LoanOfficerId, LoanOfficerName, MemberId, MemberName, GuardianName, MemberRemark, MemberDOB, MemberAge, MobileNo, ContactNo, MemberAddress, NomineeName, NomineeDOB, NomineeAge, NomineeRelation, MemberBankName, BankBranchName, BankAccountNo, BankIFSCCode, BankAccountName, BankResponse, ApplicationRemark, ApplicationUserAndTime, ApplicationDocument1, ApplicationDocument2, ApplicationDate, ApplicationAmount, TotalAmount, EMIAmount, FirstEMIPaid, FDAmountApplied, RDAmountApplied, DownPaymentApplied, LoanTypeNo, LoanTypeName, InterestMethod, LoanTypeGroup, LoanTerm, LoanTermMode, LoanPurpose, InterestRate, NoPayingTerm, LoanHeadNameId, LoanHeadNameName, ProcessingFeeAmount, ProcessingFeePercent, ProcessingGSTPercent, AccountHeadProcessingId, AccountHeadProcessingName, InsuranceFeeAmount, InsuranceFeePercent, InsuranceGSTPercent, AccountHeadInsuranceId, AccountHeadInsuranceName, OtherChargeAmount, OtherChargePercent, OtherChargeGSTPercent, AccountHeadOtherChargeId, AccountHeadOtherChargeName, SecurityFeeAmount, SecurityFeePercent, AccountHeadSecurityId, AccountHeadSecurityName, FDAmountAmount, FDAmountPercent, AccountHeadFDAmountId, AccountHeadFDAmountName, RDAmountAmount, RDAmountPercent, AccountHeadRDAmountId, AccountHeadRDAmountName, DownPaymentAmount, DownPaymentPercent, AccountHeadDownPaymentId, AccountHeadDownPaymentName, InterestType, ManualEMIAmount, EMIAmountType, FirstInstallmentType, FirstEMIDate FROM @FTable ; String sql: Data: System.Collections.ListDictionaryInternal HelpLink: InnerException: Message: Invalid column name 'MobileNo'. Invalid column name 'ContactNo'. Invalid column name 'ApplicationEntryUser'. Invalid column name 'ApplicationEntryTime'. Invalid column name 'ApplicationEntryTime'. Source: .Net SqlClient Data Provider StackTrace: at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose) at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady) at System.Data.SqlClient.SqlDataReader.TryConsumeMetaData() at System.Data.SqlClient.SqlDataReader.get_MetaData() at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString, Boolean isInternal, Boolean forDescribeParameterEncryption, Boolean shouldCacheForAlwaysEncrypted) at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async, Int32 timeout, Task& task, Boolean asyncWrite, Boolean inRetry, SqlDataReader ds, Boolean describeParameterEncryptionRequest) at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, TaskCompletionSource`1 completion, Int32 timeout, Task& task, Boolean& usedCache, Boolean asyncWrite, Boolean inRetry) at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method) at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior, String method) at System.Data.SqlClient.SqlCommand.ExecuteDbDataReader(CommandBehavior behavior) at System.Data.Common.DbCommand.System.Data.IDbCommand.ExecuteReader(CommandBehavior behavior) at System.Data.Common.DbDataAdapter.FillInternal(DataSet dataset, DataTable[] datatables, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior) at System.Data.Common.DbDataAdapter.Fill(DataTable[] dataTables, Int32 startRecord, Int32 maxRecords, IDbCommand command, CommandBehavior behavior) at System.Data.Common.DbDataAdapter.Fill(DataTable dataTable) at ClassMaster.DataTableResult(String query) TargetSite: Void OnError(System.Data.SqlClient.SqlException, Boolean, System.Action`1[System.Action]) Time: 03/08/2026 06:41:59 PM PageName: IndividualLoan_IndvLoanDisbursementCorrection String str: DECLARE @ApplicationId VARCHAR(25), @OnDate DATE; SET @ApplicationId='GA10100042'; DECLARE @FTable TABLE ( BranchId VARCHAR(10), BranchName VARCHAR(50), LoanOfficerId VARCHAR(20), LoanOfficerName VARCHAR(50), MemberRemark VARCHAR(150), MemberId VARCHAR(20), MemberName VARCHAR(50), GuardianName VARCHAR(50), MemberDOB VARCHAR(20), MemberAge VARCHAR(10), MobileNo VARCHAR(20), ContactNo VARCHAR(20), MemberAddress VARCHAR(250), NomineeName VARCHAR(50), NomineeDOB VARCHAR(20), NomineeAge VARCHAR(10), NomineeRelation VARCHAR(50), MemberBankName VARCHAR(50), BankBranchName VARCHAR(50), BankAccountNo VARCHAR(20), BankIFSCCode VARCHAR(20), BankAccountName VARCHAR(50), BankResponse VARCHAR(50), ApplicationRemark VARCHAR(250), ApplicationUserAndTime VARCHAR(100), ApplicationDocument1 VARCHAR(100), ApplicationDocument2 VARCHAR(100), ApplicationDate VARCHAR(20), ApplicationAmount DECIMAL(18,2), TotalAmount DECIMAL(18,2), EMIAmount DECIMAL(18,2), FirstEMIPaid VARCHAR(10), FDAmountApplied DECIMAL(18,2), RDAmountApplied DECIMAL(18,2), DownPaymentApplied DECIMAL(18,2), LoanTypeNo VARCHAR(50), LoanTypeName VARCHAR(50), InterestMethod VARCHAR(20), LoanTypeGroup VARCHAR(20), LoanTerm VARCHAR(10), LoanTermMode VARCHAR(20), LoanPurpose VARCHAR(50), InterestRate VARCHAR(10), NoPayingTerm VARCHAR(10), LoanHeadNameId VARCHAR(10), LoanHeadNameName VARCHAR(100), ProcessingFeeAmount DECIMAL(10,6), ProcessingFeePercent DECIMAL(10,6), ProcessingGSTPercent DECIMAL(10,6), AccountHeadProcessingId VARCHAR(10), AccountHeadProcessingName VARCHAR(100), InsuranceFeeAmount DECIMAL(10,6), InsuranceFeePercent DECIMAL(10,6), InsuranceGSTPercent DECIMAL(10,6), AccountHeadInsuranceId VARCHAR(10), AccountHeadInsuranceName VARCHAR(100), OtherChargeAmount DECIMAL(10,6), OtherChargePercent DECIMAL(10,6), OtherChargeGSTPercent DECIMAL(10,6), AccountHeadOtherChargeId VARCHAR(10), AccountHeadOtherChargeName VARCHAR(100), SecurityFeeAmount DECIMAL(10,6), SecurityFeePercent DECIMAL(10,6), AccountHeadSecurityId VARCHAR(10), AccountHeadSecurityName VARCHAR(100), FDAmountAmount DECIMAL(10,6), FDAmountPercent DECIMAL(10,6), AccountHeadFDAmountId VARCHAR(10), AccountHeadFDAmountName VARCHAR(100), RDAmountAmount DECIMAL(10,6), RDAmountPercent DECIMAL(10,6), AccountHeadRDAmountId VARCHAR(10), AccountHeadRDAmountName VARCHAR(100), DownPaymentAmount DECIMAL(10,6), DownPaymentPercent DECIMAL(10,6), AccountHeadDownPaymentId VARCHAR(10), AccountHeadDownPaymentName VARCHAR(100), InterestType VARCHAR(20), ManualEMIAmount VARCHAR(20), EMIAmountType VARCHAR(20), FirstInstallmentType VARCHAR(20), FirstEMIDate VARCHAR(20)); INSERT INTO @FTable ( BranchId, BranchName, LoanOfficerId, LoanOfficerName, MemberId, MemberName, MobileNo, ContactNo, NomineeName, NomineeDOB, NomineeAge, NomineeRelation, MemberBankName, BankBranchName, BankAccountNo, BankIFSCCode, ApplicationRemark, ApplicationUserAndTime, ApplicationDocument1, ApplicationDocument2, ApplicationDate, ApplicationAmount, TotalAmount, EMIAmount, FirstEMIPaid, FDAmountApplied, RDAmountApplied, DownPaymentApplied, LoanTypeNo, LoanTypeName, InterestMethod, LoanTypeGroup, LoanTerm, LoanTermMode, LoanPurpose, InterestRate ) SELECT a.BranchId, a.BranchName, a.LoanOfficerId, a.LoanOfficerName, a.MemberId, a.MemberName, a.MobileNo, a.ContactNo, a.NomineeName, convert(CHAR,a.NomineeDOB,103)AS NomineeDOB, a.NomineeAge, a.NomineeRelation, a.MemberBankName, a.BankBranchName, a.BankAccountNo, a.BankIFSCCode, a.ApplicationRemark, a.ApplicationEntryUser+' on '+rtrim(convert(CHAR,a.ApplicationEntryTime,106))+' - '+rtrim(convert(CHAR,a.ApplicationEntryTime,108))AS ApplicationUserAndTime, a.ApplicationDoc1 AS ApplicationDocument1, a.ApplicationDoc2 AS ApplicationDocument2, convert(CHAR,a.ApplicationDate,103)AS ApplicationDate, a.ApplicationAmount, a.TotalAmount, a.EMIAmount, a.FirstEMIPaid, a.FDAmount AS FDAmountApplied, a.RDAmount AS RDAmountApplied, a.DownPayment AS DownPaymentApplied, a.GLoanTypeNo AS LoanTypeNo, a.GLoanTypeName AS LoanTypeName, a.InterestMethod, a.GLoanType AS LoanTypeGroup, a.LoanTerm, a.LoanTermMode, a.LoanPurpose, a.InterestRate FROM GroupLoanAccount a WITH(nolock) WHERE a.ApplicationId=@ApplicationId ; UPDATE a SET a.GuardianName=b.MemberGuardianName, a.MemberRemark=b.MemberRemark, a.MemberDOB=b.MemberDOB, a.MemberAge=b.MemberAge, a.MemberAddress=b.MemberAddress FROM @FTable a INNER JOIN ( SELECT MemberId, MemberGuardianName, convert(char,MemberDOB,106)AS MemberDOB, MemberAge, MemberAddress, MemberRemark FROM GroupLoanMemberDetail WITH(nolock) WHERE MemberId= (SELECT MemberId FROM @FTable) )b ON a.MemberId=b.MemberId ; UPDATE a SET a.BankAccountName=b.accountName, a.BankResponse=b.bankResponse FROM @FTable a INNER JOIN ( SELECT TOP 1 AccountNo, IFSCCode, accountName, bankResponse FROM BankAccountVerification WITH(nolock) WHERE AccountNo=(SELECT BankAccountNo FROM @FTable) AND IFSCCode=(SELECT BankIFSCCode FROM @FTable) ORDER BY EntryTime DESC, bankResponse DESC )b ON a.BankAccountNo=b.AccountNo AND a.MemberId=b.IFSCCode ; UPDATE a SET a.NoPayingTerm=b.NoPayingTerm, a.LoanHeadNameId=b.AccountHeadLoanId, a.LoanHeadNameName=b.AccountHeadLoanName, a.ProcessingFeeAmount=b.ProcessingFeeAmount, a.ProcessingFeePercent=b.ProcessingFeePercent, a.ProcessingGSTPercent=b.ProcessingGSTPercent, a.AccountHeadProcessingId=b.AccountHeadProcessingId, a.AccountHeadProcessingName=b.AccountHeadProcessingName, a.InsuranceFeeAmount=b.InsuranceFeeAmount, a.InsuranceFeePercent=b.InsuranceFeePercent, a.InsuranceGSTPercent=b.InsuranceGSTPercent, a.AccountHeadInsuranceId=b.AccountHeadInsuranceId, a.AccountHeadInsuranceName=b.AccountHeadInsuranceName, a.OtherChargeAmount=b.OtherChargeAmount, a.OtherChargePercent=b.OtherChargePercent, a.OtherChargeGSTPercent=b.OtherChargeGSTPercent, a.AccountHeadOtherChargeId=b.AccountHeadOtherChargeId, a.AccountHeadOtherChargeName=b.AccountHeadOtherChargeName, a.SecurityFeeAmount=b.SecurityFeeAmount, a.SecurityFeePercent=b.SecurityFeePercent, a.AccountHeadSecurityId=b.AccountHeadSecurityId, a.AccountHeadSecurityName=b.AccountHeadSecurityName, a.FDAmountAmount=b.FDAmountAmount, a.FDAmountPercent=b.FDAmountPercent, a.AccountHeadFDAmountId=b.AccountHeadFDAmountId, a.AccountHeadFDAmountName=b.AccountHeadFDAmountName, a.RDAmountAmount=b.RDAmountAmount, a.RDAmountPercent=b.RDAmountPercent, a.AccountHeadRDAmountId=b.AccountHeadRDAmountId, a.AccountHeadRDAmountName=b.AccountHeadRDAmountName, a.DownPaymentAmount=b.DownPaymentAmount, a.DownPaymentPercent=b.DownPaymentPercent, a.AccountHeadDownPaymentId=b.AccountHeadDownPaymentId, a.AccountHeadDownPaymentName=b.AccountHeadDownPaymentName, a.InterestType=b.InterestType, a.ManualEMIAmount=b.EMIAmount, a.EMIAmountType=b.EMIAmountType, a.FirstInstallmentType=b.FirstInstallmentType FROM @FTable a INNER JOIN GroupLoanNoMaster b WITH(nolock) ON a.LoanTypeNo=b.GLoanTypeNo ; SELECT BranchId, BranchName, LoanOfficerId, LoanOfficerName, MemberId, MemberName, GuardianName, MemberRemark, MemberDOB, MemberAge, MobileNo, ContactNo, MemberAddress, NomineeName, NomineeDOB, NomineeAge, NomineeRelation, MemberBankName, BankBranchName, BankAccountNo, BankIFSCCode, BankAccountName, BankResponse, ApplicationRemark, ApplicationUserAndTime, ApplicationDocument1, ApplicationDocument2, ApplicationDate, ApplicationAmount, TotalAmount, EMIAmount, FirstEMIPaid, FDAmountApplied, RDAmountApplied, DownPaymentApplied, LoanTypeNo, LoanTypeName, InterestMethod, LoanTypeGroup, LoanTerm, LoanTermMode, LoanPurpose, InterestRate, NoPayingTerm, LoanHeadNameId, LoanHeadNameName, ProcessingFeeAmount, ProcessingFeePercent, ProcessingGSTPercent, AccountHeadProcessingId, AccountHeadProcessingName, InsuranceFeeAmount, InsuranceFeePercent, InsuranceGSTPercent, AccountHeadInsuranceId, AccountHeadInsuranceName, OtherChargeAmount, OtherChargePercent, OtherChargeGSTPercent, AccountHeadOtherChargeId, AccountHeadOtherChargeName, SecurityFeeAmount, SecurityFeePercent, AccountHeadSecurityId, AccountHeadSecurityName, FDAmountAmount, FDAmountPercent, AccountHeadFDAmountId, AccountHeadFDAmountName, RDAmountAmount, RDAmountPercent, AccountHeadRDAmountId, AccountHeadRDAmountName, DownPaymentAmount, DownPaymentPercent, AccountHeadDownPaymentId, AccountHeadDownPaymentName, InterestType, ManualEMIAmount, EMIAmountType, FirstInstallmentType, FirstEMIDate FROM @FTable ; String sql: Data: System.Collections.ListDictionaryInternal HelpLink: InnerException: Message: Object reference not set to an instance of an object. Source: App_Web_oroze2tw StackTrace: at IndividualLoan_IndvLoanDisbursementCorrection.lbtnSelect_Click(Object sender, EventArgs e) TargetSite: Void lbtnSelect_Click(System.Object, System.EventArgs) Time: 05/08/2026 11:06:08 AM PageName: AdminLogOut String str: String sql: Data: System.Collections.ListDictionaryInternal HelpLink: InnerException: Message: Thread was being aborted. Source: mscorlib StackTrace: at System.Threading.Thread.AbortInternal() at System.Threading.Thread.Abort(Object stateInfo) at System.Web.HttpResponse.AbortCurrentThread() at System.Web.HttpResponse.End() at System.Web.HttpResponse.Redirect(String url, Boolean endResponse, Boolean permanent) at AdminLogOut.btnLogout_Click(Object sender, EventArgs e) TargetSite: Void AbortInternal() Time: 05/08/2026 11:07:09 AM PageName: AdminLogOut String str: String sql: Data: System.Collections.ListDictionaryInternal HelpLink: InnerException: Message: Thread was being aborted. Source: mscorlib StackTrace: at System.Threading.Thread.AbortInternal() at System.Threading.Thread.Abort(Object stateInfo) at System.Web.HttpResponse.AbortCurrentThread() at System.Web.HttpResponse.End() at System.Web.HttpResponse.Redirect(String url, Boolean endResponse, Boolean permanent) at AdminLogOut.btnLogout_Click(Object sender, EventArgs e) TargetSite: Void AbortInternal() Time: 05/08/2026 03:49:18 PM PageName: DataTableResult String str: SELECT a.SrNo, a.MemberId, a.MemberType, a.MemberName, a.ReqFileName, 'GroupLoan_GroupMemberCibilHighmark.aspx?SrNo='+rtrim(convert(CHAR,a.SrNo)) AS CibilScoreURL, a.ResFileName, rtrim(Convert(CHAR,a.EntryTime,106))+' '+rtrim(Convert(CHAR,a.EntryTime,108))AS EntryTime, a.EntryUser, a.ResponseStatus, a.TotalResponse, a.NoOfOtherMFI, a.NoOfDefaultAccount, a.OwnMFIIndicator, a.NoOfClosedAccount, a.NoOfActiveAccount, a.NoOfOwnMFI, a.TotalOtherDisbursed, a.TotalOtherCurrentBalance, a.TotalOtherInstallment, a.MaxWorstDeliquency FROM GroupMemberCibilHighmark a WITH(nolock) WHERE a.MemberId='M103000227' ORDER BY a.EntryTime DESC String sql: Data: System.Collections.ListDictionaryInternal HelpLink: InnerException: Message: Invalid column name 'ReqFileName'. Invalid column name 'ResFileName'. Invalid column name 'ResponseStatus'. Invalid column name 'TotalResponse'. Invalid column name 'NoOfOtherMFI'. Invalid column name 'NoOfDefaultAccount'. Invalid column name 'OwnMFIIndicator'. Invalid column name 'NoOfClosedAccount'. Invalid column name 'NoOfActiveAccount'. Invalid column name 'NoOfOwnMFI'. Invalid column name 'TotalOtherDisbursed'. Invalid column name 'TotalOtherCurrentBalance'. Invalid column name 'TotalOtherInstallment'. Invalid column name 'MaxWorstDeliquency'. Source: .Net SqlClient Data Provider StackTrace: at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose) at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady) at System.Data.SqlClient.SqlDataReader.TryConsumeMetaData() at System.Data.SqlClient.SqlDataReader.get_MetaData() at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString, Boolean isInternal, Boolean forDescribeParameterEncryption, Boolean shouldCacheForAlwaysEncrypted) at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async, Int32 timeout, Task& task, Boolean asyncWrite, Boolean inRetry, SqlDataReader ds, Boolean describeParameterEncryptionRequest) at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, TaskCompletionSource`1 completion, Int32 timeout, Task& task, Boolean& usedCache, Boolean asyncWrite, Boolean inRetry) at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method) at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior, String method) at System.Data.SqlClient.SqlCommand.ExecuteDbDataReader(CommandBehavior behavior) at System.Data.Common.DbCommand.System.Data.IDbCommand.ExecuteReader(CommandBehavior behavior) at System.Data.Common.DbDataAdapter.FillInternal(DataSet dataset, DataTable[] datatables, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior) at System.Data.Common.DbDataAdapter.Fill(DataTable[] dataTables, Int32 startRecord, Int32 maxRecords, IDbCommand command, CommandBehavior behavior) at System.Data.Common.DbDataAdapter.Fill(DataTable dataTable) at ClassMaster.DataTableResult(String query) TargetSite: Void OnError(System.Data.SqlClient.SqlException, Boolean, System.Action`1[System.Action]) Time: 05/08/2026 03:49:18 PM PageName: IndividualLoan_IndvMemberRegistrationDetail String str: SELECT a.SrNo, a.MemberId, a.MemberType, a.MemberName, a.ReqFileName, 'GroupLoan_GroupMemberCibilHighmark.aspx?SrNo='+rtrim(convert(CHAR,a.SrNo)) AS CibilScoreURL, a.ResFileName, rtrim(Convert(CHAR,a.EntryTime,106))+' '+rtrim(Convert(CHAR,a.EntryTime,108))AS EntryTime, a.EntryUser, a.ResponseStatus, a.TotalResponse, a.NoOfOtherMFI, a.NoOfDefaultAccount, a.OwnMFIIndicator, a.NoOfClosedAccount, a.NoOfActiveAccount, a.NoOfOwnMFI, a.TotalOtherDisbursed, a.TotalOtherCurrentBalance, a.TotalOtherInstallment, a.MaxWorstDeliquency FROM GroupMemberCibilHighmark a WITH(nolock) WHERE a.MemberId='M103000227' ORDER BY a.EntryTime DESC String sql: Data: System.Collections.ListDictionaryInternal HelpLink: InnerException: Message: Object reference not set to an instance of an object. Source: App_Web_wypgqzca StackTrace: at IndividualLoan_IndvMemberRegistrationDetail.FillHighmarkData() TargetSite: Void FillHighmarkData() Time: 06/08/2026 11:06:25 AM PageName: AdminLogOut String str: String sql: Data: System.Collections.ListDictionaryInternal HelpLink: InnerException: Message: Thread was being aborted. Source: mscorlib StackTrace: at System.Threading.Thread.AbortInternal() at System.Threading.Thread.Abort(Object stateInfo) at System.Web.HttpResponse.AbortCurrentThread() at System.Web.HttpResponse.End() at System.Web.HttpResponse.Redirect(String url, Boolean endResponse, Boolean permanent) at AdminLogOut.btnLogout_Click(Object sender, EventArgs e) TargetSite: Void AbortInternal() Time: 11/08/2026 10:05:28 AM PageName: DataTableResult String str: SELECT a.BranchId, a.BranchName, a.GroupOfficerId, a.GroupOfficerName, (SELECT MeetingType FROM GroupCenterMaster WHERE CenterId=a.CenterId)AS MeetingType, a.GroupName, a.MemberId, a.MemberName, a.MemberGuardianName, a.MemberMobileNo, a.NomineeMobileNo, a.MemberAddress, Convert(char, a.MemberJoinDate, 103)AS MemberJoinDate, convert(char,a.MemberDOB,103)AS MemberDOB, a.MemberAge, CASE WHEN isnull(a.DropOutDate, '01/01/1900')= '01/01/1900' THEN 'Active' ELSE 'DropOut' END AS MemberLoanStatus, a.MemberProfileStatus, a.MemberRemark, (SELECT GroupStatus FROM GroupLoanMemberNominee WHERE MemberId=a.MemberId)AS GroupStatus, b.BankAccountType, b.MemberBankId, b.MemberBankName, b.BankAccountNo, b.BankIFSCCode, b.BankBranchName, b.LoanPurpose, b.LoanAmount AS RequestAmount, a.NomineeName, Convert(char, a.NomineeDOB, 103)AS NomineeDOB, a.NomineeAge, a.NomineeRelation, c.ApplicationId, c.GLoanTypeNo, c.GLoanTypeName, rtrim(convert(CHAR,c.LoanTerm))+'-'+c.LoanTermMode AS LoanTerm, c.LoanPurpose, c.ApplicationAmount, convert(CHAR,c.ApplicationDate,103)AS ApplicationDate FROM GroupLoanMemberDetail a WITH(nolock) LEFT JOIN GroupLoanMemberNominee b WITH(nolock) ON a.MemberId = b.MemberId LEFT JOIN GroupLoanAccount c WITH(nolock) ON a.MemberId=c.MemberId WHERE a.GroupName='Individual' AND a.MemberId='M103000112' AND c.ApplicationId='GA10200527' ; String sql: Data: System.Collections.ListDictionaryInternal HelpLink: InnerException: Message: Invalid column name 'MemberBankId'. Source: .Net SqlClient Data Provider StackTrace: at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose) at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady) at System.Data.SqlClient.SqlDataReader.TryConsumeMetaData() at System.Data.SqlClient.SqlDataReader.get_MetaData() at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString, Boolean isInternal, Boolean forDescribeParameterEncryption, Boolean shouldCacheForAlwaysEncrypted) at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async, Int32 timeout, Task& task, Boolean asyncWrite, Boolean inRetry, SqlDataReader ds, Boolean describeParameterEncryptionRequest) at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, TaskCompletionSource`1 completion, Int32 timeout, Task& task, Boolean& usedCache, Boolean asyncWrite, Boolean inRetry) at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method) at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior, String method) at System.Data.SqlClient.SqlCommand.ExecuteDbDataReader(CommandBehavior behavior) at System.Data.Common.DbCommand.System.Data.IDbCommand.ExecuteReader(CommandBehavior behavior) at System.Data.Common.DbDataAdapter.FillInternal(DataSet dataset, DataTable[] datatables, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior) at System.Data.Common.DbDataAdapter.Fill(DataTable[] dataTables, Int32 startRecord, Int32 maxRecords, IDbCommand command, CommandBehavior behavior) at System.Data.Common.DbDataAdapter.Fill(DataTable dataTable) at ClassMaster.DataTableResult(String query) TargetSite: Void OnError(System.Data.SqlClient.SqlException, Boolean, System.Action`1[System.Action]) Time: 11/08/2026 10:05:28 AM PageName: IndividualLoan_IndvLoanApplicationCorrection String str: SELECT a.BranchId, a.BranchName, a.GroupOfficerId, a.GroupOfficerName, (SELECT MeetingType FROM GroupCenterMaster WHERE CenterId=a.CenterId)AS MeetingType, a.GroupName, a.MemberId, a.MemberName, a.MemberGuardianName, a.MemberMobileNo, a.NomineeMobileNo, a.MemberAddress, Convert(char, a.MemberJoinDate, 103)AS MemberJoinDate, convert(char,a.MemberDOB,103)AS MemberDOB, a.MemberAge, CASE WHEN isnull(a.DropOutDate, '01/01/1900')= '01/01/1900' THEN 'Active' ELSE 'DropOut' END AS MemberLoanStatus, a.MemberProfileStatus, a.MemberRemark, (SELECT GroupStatus FROM GroupLoanMemberNominee WHERE MemberId=a.MemberId)AS GroupStatus, b.BankAccountType, b.MemberBankId, b.MemberBankName, b.BankAccountNo, b.BankIFSCCode, b.BankBranchName, b.LoanPurpose, b.LoanAmount AS RequestAmount, a.NomineeName, Convert(char, a.NomineeDOB, 103)AS NomineeDOB, a.NomineeAge, a.NomineeRelation, c.ApplicationId, c.GLoanTypeNo, c.GLoanTypeName, rtrim(convert(CHAR,c.LoanTerm))+'-'+c.LoanTermMode AS LoanTerm, c.LoanPurpose, c.ApplicationAmount, convert(CHAR,c.ApplicationDate,103)AS ApplicationDate FROM GroupLoanMemberDetail a WITH(nolock) LEFT JOIN GroupLoanMemberNominee b WITH(nolock) ON a.MemberId = b.MemberId LEFT JOIN GroupLoanAccount c WITH(nolock) ON a.MemberId=c.MemberId WHERE a.GroupName='Individual' AND a.MemberId='M103000112' AND c.ApplicationId='GA10200527' ; String sql: Data: System.Collections.ListDictionaryInternal HelpLink: InnerException: Message: Object reference not set to an instance of an object. Source: App_Web_qecgdciy StackTrace: at IndividualLoan_IndvLoanApplicationCorrection.lbtnSelect_Click(Object sender, EventArgs e) TargetSite: Void lbtnSelect_Click(System.Object, System.EventArgs) Time: 11/08/2026 10:05:31 AM PageName: DataTableResult String str: SELECT a.BranchId, a.BranchName, a.GroupOfficerId, a.GroupOfficerName, (SELECT MeetingType FROM GroupCenterMaster WHERE CenterId=a.CenterId)AS MeetingType, a.GroupName, a.MemberId, a.MemberName, a.MemberGuardianName, a.MemberMobileNo, a.NomineeMobileNo, a.MemberAddress, Convert(char, a.MemberJoinDate, 103)AS MemberJoinDate, convert(char,a.MemberDOB,103)AS MemberDOB, a.MemberAge, CASE WHEN isnull(a.DropOutDate, '01/01/1900')= '01/01/1900' THEN 'Active' ELSE 'DropOut' END AS MemberLoanStatus, a.MemberProfileStatus, a.MemberRemark, (SELECT GroupStatus FROM GroupLoanMemberNominee WHERE MemberId=a.MemberId)AS GroupStatus, b.BankAccountType, b.MemberBankId, b.MemberBankName, b.BankAccountNo, b.BankIFSCCode, b.BankBranchName, b.LoanPurpose, b.LoanAmount AS RequestAmount, a.NomineeName, Convert(char, a.NomineeDOB, 103)AS NomineeDOB, a.NomineeAge, a.NomineeRelation, c.ApplicationId, c.GLoanTypeNo, c.GLoanTypeName, rtrim(convert(CHAR,c.LoanTerm))+'-'+c.LoanTermMode AS LoanTerm, c.LoanPurpose, c.ApplicationAmount, convert(CHAR,c.ApplicationDate,103)AS ApplicationDate FROM GroupLoanMemberDetail a WITH(nolock) LEFT JOIN GroupLoanMemberNominee b WITH(nolock) ON a.MemberId = b.MemberId LEFT JOIN GroupLoanAccount c WITH(nolock) ON a.MemberId=c.MemberId WHERE a.GroupName='Individual' AND a.MemberId='M101000017' AND c.ApplicationId='GA10200043' ; String sql: Data: System.Collections.ListDictionaryInternal HelpLink: InnerException: Message: Invalid column name 'MemberBankId'. Source: .Net SqlClient Data Provider StackTrace: at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose) at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady) at System.Data.SqlClient.SqlDataReader.TryConsumeMetaData() at System.Data.SqlClient.SqlDataReader.get_MetaData() at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString, Boolean isInternal, Boolean forDescribeParameterEncryption, Boolean shouldCacheForAlwaysEncrypted) at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async, Int32 timeout, Task& task, Boolean asyncWrite, Boolean inRetry, SqlDataReader ds, Boolean describeParameterEncryptionRequest) at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, TaskCompletionSource`1 completion, Int32 timeout, Task& task, Boolean& usedCache, Boolean asyncWrite, Boolean inRetry) at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method) at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior, String method) at System.Data.SqlClient.SqlCommand.ExecuteDbDataReader(CommandBehavior behavior) at System.Data.Common.DbCommand.System.Data.IDbCommand.ExecuteReader(CommandBehavior behavior) at System.Data.Common.DbDataAdapter.FillInternal(DataSet dataset, DataTable[] datatables, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior) at System.Data.Common.DbDataAdapter.Fill(DataTable[] dataTables, Int32 startRecord, Int32 maxRecords, IDbCommand command, CommandBehavior behavior) at System.Data.Common.DbDataAdapter.Fill(DataTable dataTable) at ClassMaster.DataTableResult(String query) TargetSite: Void OnError(System.Data.SqlClient.SqlException, Boolean, System.Action`1[System.Action]) Time: 11/08/2026 10:05:31 AM PageName: IndividualLoan_IndvLoanApplicationCorrection String str: SELECT a.BranchId, a.BranchName, a.GroupOfficerId, a.GroupOfficerName, (SELECT MeetingType FROM GroupCenterMaster WHERE CenterId=a.CenterId)AS MeetingType, a.GroupName, a.MemberId, a.MemberName, a.MemberGuardianName, a.MemberMobileNo, a.NomineeMobileNo, a.MemberAddress, Convert(char, a.MemberJoinDate, 103)AS MemberJoinDate, convert(char,a.MemberDOB,103)AS MemberDOB, a.MemberAge, CASE WHEN isnull(a.DropOutDate, '01/01/1900')= '01/01/1900' THEN 'Active' ELSE 'DropOut' END AS MemberLoanStatus, a.MemberProfileStatus, a.MemberRemark, (SELECT GroupStatus FROM GroupLoanMemberNominee WHERE MemberId=a.MemberId)AS GroupStatus, b.BankAccountType, b.MemberBankId, b.MemberBankName, b.BankAccountNo, b.BankIFSCCode, b.BankBranchName, b.LoanPurpose, b.LoanAmount AS RequestAmount, a.NomineeName, Convert(char, a.NomineeDOB, 103)AS NomineeDOB, a.NomineeAge, a.NomineeRelation, c.ApplicationId, c.GLoanTypeNo, c.GLoanTypeName, rtrim(convert(CHAR,c.LoanTerm))+'-'+c.LoanTermMode AS LoanTerm, c.LoanPurpose, c.ApplicationAmount, convert(CHAR,c.ApplicationDate,103)AS ApplicationDate FROM GroupLoanMemberDetail a WITH(nolock) LEFT JOIN GroupLoanMemberNominee b WITH(nolock) ON a.MemberId = b.MemberId LEFT JOIN GroupLoanAccount c WITH(nolock) ON a.MemberId=c.MemberId WHERE a.GroupName='Individual' AND a.MemberId='M101000017' AND c.ApplicationId='GA10200043' ; String sql: Data: System.Collections.ListDictionaryInternal HelpLink: InnerException: Message: Object reference not set to an instance of an object. Source: App_Web_qecgdciy StackTrace: at IndividualLoan_IndvLoanApplicationCorrection.lbtnSelect_Click(Object sender, EventArgs e) TargetSite: Void lbtnSelect_Click(System.Object, System.EventArgs) Time: 11/08/2026 10:07:45 AM PageName: DataTableResult String str: SELECT a.BranchId, a.BranchName, a.GroupOfficerId, a.GroupOfficerName, (SELECT MeetingType FROM GroupCenterMaster WHERE CenterId=a.CenterId)AS MeetingType, a.GroupName, a.MemberId, a.MemberName, a.MemberGuardianName, a.MemberMobileNo, a.NomineeMobileNo, a.MemberAddress, Convert(char, a.MemberJoinDate, 103)AS MemberJoinDate, convert(char,a.MemberDOB,103)AS MemberDOB, a.MemberAge, CASE WHEN isnull(a.DropOutDate, '01/01/1900')= '01/01/1900' THEN 'Active' ELSE 'DropOut' END AS MemberLoanStatus, a.MemberProfileStatus, a.MemberRemark, (SELECT GroupStatus FROM GroupLoanMemberNominee WHERE MemberId=a.MemberId)AS GroupStatus, b.BankAccountType, b.MemberBankId, b.MemberBankName, b.BankAccountNo, b.BankIFSCCode, b.BankBranchName, b.LoanPurpose, b.LoanAmount AS RequestAmount, a.NomineeName, Convert(char, a.NomineeDOB, 103)AS NomineeDOB, a.NomineeAge, a.NomineeRelation, c.ApplicationId, c.GLoanTypeNo, c.GLoanTypeName, rtrim(convert(CHAR,c.LoanTerm))+'-'+c.LoanTermMode AS LoanTerm, c.LoanPurpose, c.ApplicationAmount, convert(CHAR,c.ApplicationDate,103)AS ApplicationDate FROM GroupLoanMemberDetail a WITH(nolock) LEFT JOIN GroupLoanMemberNominee b WITH(nolock) ON a.MemberId = b.MemberId LEFT JOIN GroupLoanAccount c WITH(nolock) ON a.MemberId=c.MemberId WHERE a.GroupName='Individual' AND a.MemberId='M103000112' AND c.ApplicationId='GA10200527' ; String sql: Data: System.Collections.ListDictionaryInternal HelpLink: InnerException: Message: Invalid column name 'MemberBankId'. Source: .Net SqlClient Data Provider StackTrace: at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose) at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady) at System.Data.SqlClient.SqlDataReader.TryConsumeMetaData() at System.Data.SqlClient.SqlDataReader.get_MetaData() at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString, Boolean isInternal, Boolean forDescribeParameterEncryption, Boolean shouldCacheForAlwaysEncrypted) at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async, Int32 timeout, Task& task, Boolean asyncWrite, Boolean inRetry, SqlDataReader ds, Boolean describeParameterEncryptionRequest) at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, TaskCompletionSource`1 completion, Int32 timeout, Task& task, Boolean& usedCache, Boolean asyncWrite, Boolean inRetry) at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method) at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior, String method) at System.Data.SqlClient.SqlCommand.ExecuteDbDataReader(CommandBehavior behavior) at System.Data.Common.DbCommand.System.Data.IDbCommand.ExecuteReader(CommandBehavior behavior) at System.Data.Common.DbDataAdapter.FillInternal(DataSet dataset, DataTable[] datatables, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior) at System.Data.Common.DbDataAdapter.Fill(DataTable[] dataTables, Int32 startRecord, Int32 maxRecords, IDbCommand command, CommandBehavior behavior) at System.Data.Common.DbDataAdapter.Fill(DataTable dataTable) at ClassMaster.DataTableResult(String query) TargetSite: Void OnError(System.Data.SqlClient.SqlException, Boolean, System.Action`1[System.Action]) Time: 11/08/2026 10:07:45 AM PageName: IndividualLoan_IndvLoanApplicationCorrection String str: SELECT a.BranchId, a.BranchName, a.GroupOfficerId, a.GroupOfficerName, (SELECT MeetingType FROM GroupCenterMaster WHERE CenterId=a.CenterId)AS MeetingType, a.GroupName, a.MemberId, a.MemberName, a.MemberGuardianName, a.MemberMobileNo, a.NomineeMobileNo, a.MemberAddress, Convert(char, a.MemberJoinDate, 103)AS MemberJoinDate, convert(char,a.MemberDOB,103)AS MemberDOB, a.MemberAge, CASE WHEN isnull(a.DropOutDate, '01/01/1900')= '01/01/1900' THEN 'Active' ELSE 'DropOut' END AS MemberLoanStatus, a.MemberProfileStatus, a.MemberRemark, (SELECT GroupStatus FROM GroupLoanMemberNominee WHERE MemberId=a.MemberId)AS GroupStatus, b.BankAccountType, b.MemberBankId, b.MemberBankName, b.BankAccountNo, b.BankIFSCCode, b.BankBranchName, b.LoanPurpose, b.LoanAmount AS RequestAmount, a.NomineeName, Convert(char, a.NomineeDOB, 103)AS NomineeDOB, a.NomineeAge, a.NomineeRelation, c.ApplicationId, c.GLoanTypeNo, c.GLoanTypeName, rtrim(convert(CHAR,c.LoanTerm))+'-'+c.LoanTermMode AS LoanTerm, c.LoanPurpose, c.ApplicationAmount, convert(CHAR,c.ApplicationDate,103)AS ApplicationDate FROM GroupLoanMemberDetail a WITH(nolock) LEFT JOIN GroupLoanMemberNominee b WITH(nolock) ON a.MemberId = b.MemberId LEFT JOIN GroupLoanAccount c WITH(nolock) ON a.MemberId=c.MemberId WHERE a.GroupName='Individual' AND a.MemberId='M103000112' AND c.ApplicationId='GA10200527' ; String sql: Data: System.Collections.ListDictionaryInternal HelpLink: InnerException: Message: Object reference not set to an instance of an object. Source: App_Web_qecgdciy StackTrace: at IndividualLoan_IndvLoanApplicationCorrection.lbtnSelect_Click(Object sender, EventArgs e) TargetSite: Void lbtnSelect_Click(System.Object, System.EventArgs) Time: 11/08/2026 10:07:48 AM PageName: DataTableResult String str: SELECT a.BranchId, a.BranchName, a.GroupOfficerId, a.GroupOfficerName, (SELECT MeetingType FROM GroupCenterMaster WHERE CenterId=a.CenterId)AS MeetingType, a.GroupName, a.MemberId, a.MemberName, a.MemberGuardianName, a.MemberMobileNo, a.NomineeMobileNo, a.MemberAddress, Convert(char, a.MemberJoinDate, 103)AS MemberJoinDate, convert(char,a.MemberDOB,103)AS MemberDOB, a.MemberAge, CASE WHEN isnull(a.DropOutDate, '01/01/1900')= '01/01/1900' THEN 'Active' ELSE 'DropOut' END AS MemberLoanStatus, a.MemberProfileStatus, a.MemberRemark, (SELECT GroupStatus FROM GroupLoanMemberNominee WHERE MemberId=a.MemberId)AS GroupStatus, b.BankAccountType, b.MemberBankId, b.MemberBankName, b.BankAccountNo, b.BankIFSCCode, b.BankBranchName, b.LoanPurpose, b.LoanAmount AS RequestAmount, a.NomineeName, Convert(char, a.NomineeDOB, 103)AS NomineeDOB, a.NomineeAge, a.NomineeRelation, c.ApplicationId, c.GLoanTypeNo, c.GLoanTypeName, rtrim(convert(CHAR,c.LoanTerm))+'-'+c.LoanTermMode AS LoanTerm, c.LoanPurpose, c.ApplicationAmount, convert(CHAR,c.ApplicationDate,103)AS ApplicationDate FROM GroupLoanMemberDetail a WITH(nolock) LEFT JOIN GroupLoanMemberNominee b WITH(nolock) ON a.MemberId = b.MemberId LEFT JOIN GroupLoanAccount c WITH(nolock) ON a.MemberId=c.MemberId WHERE a.GroupName='Individual' AND a.MemberId='M101000017' AND c.ApplicationId='GA10200043' ; String sql: Data: System.Collections.ListDictionaryInternal HelpLink: InnerException: Message: Invalid column name 'MemberBankId'. Source: .Net SqlClient Data Provider StackTrace: at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose) at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady) at System.Data.SqlClient.SqlDataReader.TryConsumeMetaData() at System.Data.SqlClient.SqlDataReader.get_MetaData() at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString, Boolean isInternal, Boolean forDescribeParameterEncryption, Boolean shouldCacheForAlwaysEncrypted) at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async, Int32 timeout, Task& task, Boolean asyncWrite, Boolean inRetry, SqlDataReader ds, Boolean describeParameterEncryptionRequest) at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, TaskCompletionSource`1 completion, Int32 timeout, Task& task, Boolean& usedCache, Boolean asyncWrite, Boolean inRetry) at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method) at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior, String method) at System.Data.SqlClient.SqlCommand.ExecuteDbDataReader(CommandBehavior behavior) at System.Data.Common.DbCommand.System.Data.IDbCommand.ExecuteReader(CommandBehavior behavior) at System.Data.Common.DbDataAdapter.FillInternal(DataSet dataset, DataTable[] datatables, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior) at System.Data.Common.DbDataAdapter.Fill(DataTable[] dataTables, Int32 startRecord, Int32 maxRecords, IDbCommand command, CommandBehavior behavior) at System.Data.Common.DbDataAdapter.Fill(DataTable dataTable) at ClassMaster.DataTableResult(String query) TargetSite: Void OnError(System.Data.SqlClient.SqlException, Boolean, System.Action`1[System.Action]) Time: 11/08/2026 10:07:48 AM PageName: IndividualLoan_IndvLoanApplicationCorrection String str: SELECT a.BranchId, a.BranchName, a.GroupOfficerId, a.GroupOfficerName, (SELECT MeetingType FROM GroupCenterMaster WHERE CenterId=a.CenterId)AS MeetingType, a.GroupName, a.MemberId, a.MemberName, a.MemberGuardianName, a.MemberMobileNo, a.NomineeMobileNo, a.MemberAddress, Convert(char, a.MemberJoinDate, 103)AS MemberJoinDate, convert(char,a.MemberDOB,103)AS MemberDOB, a.MemberAge, CASE WHEN isnull(a.DropOutDate, '01/01/1900')= '01/01/1900' THEN 'Active' ELSE 'DropOut' END AS MemberLoanStatus, a.MemberProfileStatus, a.MemberRemark, (SELECT GroupStatus FROM GroupLoanMemberNominee WHERE MemberId=a.MemberId)AS GroupStatus, b.BankAccountType, b.MemberBankId, b.MemberBankName, b.BankAccountNo, b.BankIFSCCode, b.BankBranchName, b.LoanPurpose, b.LoanAmount AS RequestAmount, a.NomineeName, Convert(char, a.NomineeDOB, 103)AS NomineeDOB, a.NomineeAge, a.NomineeRelation, c.ApplicationId, c.GLoanTypeNo, c.GLoanTypeName, rtrim(convert(CHAR,c.LoanTerm))+'-'+c.LoanTermMode AS LoanTerm, c.LoanPurpose, c.ApplicationAmount, convert(CHAR,c.ApplicationDate,103)AS ApplicationDate FROM GroupLoanMemberDetail a WITH(nolock) LEFT JOIN GroupLoanMemberNominee b WITH(nolock) ON a.MemberId = b.MemberId LEFT JOIN GroupLoanAccount c WITH(nolock) ON a.MemberId=c.MemberId WHERE a.GroupName='Individual' AND a.MemberId='M101000017' AND c.ApplicationId='GA10200043' ; String sql: Data: System.Collections.ListDictionaryInternal HelpLink: InnerException: Message: Object reference not set to an instance of an object. Source: App_Web_qecgdciy StackTrace: at IndividualLoan_IndvLoanApplicationCorrection.lbtnSelect_Click(Object sender, EventArgs e) TargetSite: Void lbtnSelect_Click(System.Object, System.EventArgs) Time: 11/08/2026 10:07:51 AM PageName: DataTableResult String str: SELECT a.BranchId, a.BranchName, a.GroupOfficerId, a.GroupOfficerName, (SELECT MeetingType FROM GroupCenterMaster WHERE CenterId=a.CenterId)AS MeetingType, a.GroupName, a.MemberId, a.MemberName, a.MemberGuardianName, a.MemberMobileNo, a.NomineeMobileNo, a.MemberAddress, Convert(char, a.MemberJoinDate, 103)AS MemberJoinDate, convert(char,a.MemberDOB,103)AS MemberDOB, a.MemberAge, CASE WHEN isnull(a.DropOutDate, '01/01/1900')= '01/01/1900' THEN 'Active' ELSE 'DropOut' END AS MemberLoanStatus, a.MemberProfileStatus, a.MemberRemark, (SELECT GroupStatus FROM GroupLoanMemberNominee WHERE MemberId=a.MemberId)AS GroupStatus, b.BankAccountType, b.MemberBankId, b.MemberBankName, b.BankAccountNo, b.BankIFSCCode, b.BankBranchName, b.LoanPurpose, b.LoanAmount AS RequestAmount, a.NomineeName, Convert(char, a.NomineeDOB, 103)AS NomineeDOB, a.NomineeAge, a.NomineeRelation, c.ApplicationId, c.GLoanTypeNo, c.GLoanTypeName, rtrim(convert(CHAR,c.LoanTerm))+'-'+c.LoanTermMode AS LoanTerm, c.LoanPurpose, c.ApplicationAmount, convert(CHAR,c.ApplicationDate,103)AS ApplicationDate FROM GroupLoanMemberDetail a WITH(nolock) LEFT JOIN GroupLoanMemberNominee b WITH(nolock) ON a.MemberId = b.MemberId LEFT JOIN GroupLoanAccount c WITH(nolock) ON a.MemberId=c.MemberId WHERE a.GroupName='Individual' AND a.MemberId='M101000014' AND c.ApplicationId='GA10300268' ; String sql: Data: System.Collections.ListDictionaryInternal HelpLink: InnerException: Message: Invalid column name 'MemberBankId'. Source: .Net SqlClient Data Provider StackTrace: at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose) at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady) at System.Data.SqlClient.SqlDataReader.TryConsumeMetaData() at System.Data.SqlClient.SqlDataReader.get_MetaData() at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString, Boolean isInternal, Boolean forDescribeParameterEncryption, Boolean shouldCacheForAlwaysEncrypted) at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async, Int32 timeout, Task& task, Boolean asyncWrite, Boolean inRetry, SqlDataReader ds, Boolean describeParameterEncryptionRequest) at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, TaskCompletionSource`1 completion, Int32 timeout, Task& task, Boolean& usedCache, Boolean asyncWrite, Boolean inRetry) at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method) at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior, String method) at System.Data.SqlClient.SqlCommand.ExecuteDbDataReader(CommandBehavior behavior) at System.Data.Common.DbCommand.System.Data.IDbCommand.ExecuteReader(CommandBehavior behavior) at System.Data.Common.DbDataAdapter.FillInternal(DataSet dataset, DataTable[] datatables, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior) at System.Data.Common.DbDataAdapter.Fill(DataTable[] dataTables, Int32 startRecord, Int32 maxRecords, IDbCommand command, CommandBehavior behavior) at System.Data.Common.DbDataAdapter.Fill(DataTable dataTable) at ClassMaster.DataTableResult(String query) TargetSite: Void OnError(System.Data.SqlClient.SqlException, Boolean, System.Action`1[System.Action]) Time: 11/08/2026 10:07:51 AM PageName: IndividualLoan_IndvLoanApplicationCorrection String str: SELECT a.BranchId, a.BranchName, a.GroupOfficerId, a.GroupOfficerName, (SELECT MeetingType FROM GroupCenterMaster WHERE CenterId=a.CenterId)AS MeetingType, a.GroupName, a.MemberId, a.MemberName, a.MemberGuardianName, a.MemberMobileNo, a.NomineeMobileNo, a.MemberAddress, Convert(char, a.MemberJoinDate, 103)AS MemberJoinDate, convert(char,a.MemberDOB,103)AS MemberDOB, a.MemberAge, CASE WHEN isnull(a.DropOutDate, '01/01/1900')= '01/01/1900' THEN 'Active' ELSE 'DropOut' END AS MemberLoanStatus, a.MemberProfileStatus, a.MemberRemark, (SELECT GroupStatus FROM GroupLoanMemberNominee WHERE MemberId=a.MemberId)AS GroupStatus, b.BankAccountType, b.MemberBankId, b.MemberBankName, b.BankAccountNo, b.BankIFSCCode, b.BankBranchName, b.LoanPurpose, b.LoanAmount AS RequestAmount, a.NomineeName, Convert(char, a.NomineeDOB, 103)AS NomineeDOB, a.NomineeAge, a.NomineeRelation, c.ApplicationId, c.GLoanTypeNo, c.GLoanTypeName, rtrim(convert(CHAR,c.LoanTerm))+'-'+c.LoanTermMode AS LoanTerm, c.LoanPurpose, c.ApplicationAmount, convert(CHAR,c.ApplicationDate,103)AS ApplicationDate FROM GroupLoanMemberDetail a WITH(nolock) LEFT JOIN GroupLoanMemberNominee b WITH(nolock) ON a.MemberId = b.MemberId LEFT JOIN GroupLoanAccount c WITH(nolock) ON a.MemberId=c.MemberId WHERE a.GroupName='Individual' AND a.MemberId='M101000014' AND c.ApplicationId='GA10300268' ; String sql: Data: System.Collections.ListDictionaryInternal HelpLink: InnerException: Message: Object reference not set to an instance of an object. Source: App_Web_qecgdciy StackTrace: at IndividualLoan_IndvLoanApplicationCorrection.lbtnSelect_Click(Object sender, EventArgs e) TargetSite: Void lbtnSelect_Click(System.Object, System.EventArgs) Time: 11/08/2026 10:08:24 AM PageName: DataTableResult String str: DECLARE @ApplicationId VARCHAR(25), @OnDate DATE; SET @ApplicationId='GA10100042'; DECLARE @FTable TABLE ( BranchId VARCHAR(10), BranchName VARCHAR(50), LoanOfficerId VARCHAR(20), LoanOfficerName VARCHAR(50), MemberRemark VARCHAR(150), MemberId VARCHAR(20), MemberName VARCHAR(50), GuardianName VARCHAR(50), MemberDOB VARCHAR(20), MemberAge VARCHAR(10), MobileNo VARCHAR(20), ContactNo VARCHAR(20), MemberAddress VARCHAR(250), NomineeName VARCHAR(50), NomineeDOB VARCHAR(20), NomineeAge VARCHAR(10), NomineeRelation VARCHAR(50), MemberBankName VARCHAR(50), BankBranchName VARCHAR(50), BankAccountNo VARCHAR(20), BankIFSCCode VARCHAR(20), BankAccountName VARCHAR(50), BankResponse VARCHAR(50), ApplicationRemark VARCHAR(250), ApplicationUserAndTime VARCHAR(100), ApplicationDocument1 VARCHAR(100), ApplicationDocument2 VARCHAR(100), ApplicationDate VARCHAR(20), ApplicationAmount DECIMAL(18,2), TotalAmount DECIMAL(18,2), EMIAmount DECIMAL(18,2), FirstEMIPaid VARCHAR(10), FDAmountApplied DECIMAL(18,2), RDAmountApplied DECIMAL(18,2), DownPaymentApplied DECIMAL(18,2), LoanTypeNo VARCHAR(50), LoanTypeName VARCHAR(50), InterestMethod VARCHAR(20), LoanTypeGroup VARCHAR(20), LoanTerm VARCHAR(10), LoanTermMode VARCHAR(20), LoanPurpose VARCHAR(50), InterestRate VARCHAR(10), NoPayingTerm VARCHAR(10), LoanHeadNameId VARCHAR(10), LoanHeadNameName VARCHAR(100), ProcessingFeeAmount DECIMAL(10,6), ProcessingFeePercent DECIMAL(10,6), ProcessingGSTPercent DECIMAL(10,6), AccountHeadProcessingId VARCHAR(10), AccountHeadProcessingName VARCHAR(100), InsuranceFeeAmount DECIMAL(10,6), InsuranceFeePercent DECIMAL(10,6), InsuranceGSTPercent DECIMAL(10,6), AccountHeadInsuranceId VARCHAR(10), AccountHeadInsuranceName VARCHAR(100), OtherChargeAmount DECIMAL(10,6), OtherChargePercent DECIMAL(10,6), OtherChargeGSTPercent DECIMAL(10,6), AccountHeadOtherChargeId VARCHAR(10), AccountHeadOtherChargeName VARCHAR(100), SecurityFeeAmount DECIMAL(10,6), SecurityFeePercent DECIMAL(10,6), AccountHeadSecurityId VARCHAR(10), AccountHeadSecurityName VARCHAR(100), FDAmountAmount DECIMAL(10,6), FDAmountPercent DECIMAL(10,6), AccountHeadFDAmountId VARCHAR(10), AccountHeadFDAmountName VARCHAR(100), RDAmountAmount DECIMAL(10,6), RDAmountPercent DECIMAL(10,6), AccountHeadRDAmountId VARCHAR(10), AccountHeadRDAmountName VARCHAR(100), DownPaymentAmount DECIMAL(10,6), DownPaymentPercent DECIMAL(10,6), AccountHeadDownPaymentId VARCHAR(10), AccountHeadDownPaymentName VARCHAR(100), InterestType VARCHAR(20), ManualEMIAmount VARCHAR(20), EMIAmountType VARCHAR(20), FirstInstallmentType VARCHAR(20), FirstEMIDate VARCHAR(20)); INSERT INTO @FTable ( BranchId, BranchName, LoanOfficerId, LoanOfficerName, MemberId, MemberName, MobileNo, ContactNo, NomineeName, NomineeDOB, NomineeAge, NomineeRelation, MemberBankName, BankBranchName, BankAccountNo, BankIFSCCode, ApplicationRemark, ApplicationUserAndTime, ApplicationDocument1, ApplicationDocument2, ApplicationDate, ApplicationAmount, TotalAmount, EMIAmount, FirstEMIPaid, FDAmountApplied, RDAmountApplied, DownPaymentApplied, LoanTypeNo, LoanTypeName, InterestMethod, LoanTypeGroup, LoanTerm, LoanTermMode, LoanPurpose, InterestRate ) SELECT a.BranchId, a.BranchName, a.LoanOfficerId, a.LoanOfficerName, a.MemberId, a.MemberName, a.MobileNo, a.ContactNo, a.NomineeName, convert(CHAR,a.NomineeDOB,103)AS NomineeDOB, a.NomineeAge, a.NomineeRelation, a.MemberBankName, a.BankBranchName, a.BankAccountNo, a.BankIFSCCode, a.ApplicationRemark, a.ApplicationEntryUser+' on '+rtrim(convert(CHAR,a.ApplicationEntryTime,106))+' - '+rtrim(convert(CHAR,a.ApplicationEntryTime,108))AS ApplicationUserAndTime, a.ApplicationDoc1 AS ApplicationDocument1, a.ApplicationDoc2 AS ApplicationDocument2, convert(CHAR,a.ApplicationDate,103)AS ApplicationDate, a.ApplicationAmount, a.TotalAmount, a.EMIAmount, a.FirstEMIPaid, a.FDAmount AS FDAmountApplied, a.RDAmount AS RDAmountApplied, a.DownPayment AS DownPaymentApplied, a.GLoanTypeNo AS LoanTypeNo, a.GLoanTypeName AS LoanTypeName, a.InterestMethod, a.GLoanType AS LoanTypeGroup, a.LoanTerm, a.LoanTermMode, a.LoanPurpose, a.InterestRate FROM GroupLoanAccount a WITH(nolock) WHERE a.ApplicationId=@ApplicationId ; UPDATE a SET a.GuardianName=b.MemberGuardianName, a.MemberRemark=b.MemberRemark, a.MemberDOB=b.MemberDOB, a.MemberAge=b.MemberAge, a.MemberAddress=b.MemberAddress FROM @FTable a INNER JOIN ( SELECT MemberId, MemberGuardianName, convert(char,MemberDOB,106)AS MemberDOB, MemberAge, MemberAddress, MemberRemark FROM GroupLoanMemberDetail WITH(nolock) WHERE MemberId= (SELECT MemberId FROM @FTable) )b ON a.MemberId=b.MemberId ; UPDATE a SET a.BankAccountName=b.accountName, a.BankResponse=b.bankResponse FROM @FTable a INNER JOIN ( SELECT TOP 1 AccountNo, IFSCCode, accountName, bankResponse FROM BankAccountVerification WITH(nolock) WHERE AccountNo=(SELECT BankAccountNo FROM @FTable) AND IFSCCode=(SELECT BankIFSCCode FROM @FTable) ORDER BY EntryTime DESC, bankResponse DESC )b ON a.BankAccountNo=b.AccountNo AND a.MemberId=b.IFSCCode ; UPDATE a SET a.NoPayingTerm=b.NoPayingTerm, a.LoanHeadNameId=b.AccountHeadLoanId, a.LoanHeadNameName=b.AccountHeadLoanName, a.ProcessingFeeAmount=b.ProcessingFeeAmount, a.ProcessingFeePercent=b.ProcessingFeePercent, a.ProcessingGSTPercent=b.ProcessingGSTPercent, a.AccountHeadProcessingId=b.AccountHeadProcessingId, a.AccountHeadProcessingName=b.AccountHeadProcessingName, a.InsuranceFeeAmount=b.InsuranceFeeAmount, a.InsuranceFeePercent=b.InsuranceFeePercent, a.InsuranceGSTPercent=b.InsuranceGSTPercent, a.AccountHeadInsuranceId=b.AccountHeadInsuranceId, a.AccountHeadInsuranceName=b.AccountHeadInsuranceName, a.OtherChargeAmount=b.OtherChargeAmount, a.OtherChargePercent=b.OtherChargePercent, a.OtherChargeGSTPercent=b.OtherChargeGSTPercent, a.AccountHeadOtherChargeId=b.AccountHeadOtherChargeId, a.AccountHeadOtherChargeName=b.AccountHeadOtherChargeName, a.SecurityFeeAmount=b.SecurityFeeAmount, a.SecurityFeePercent=b.SecurityFeePercent, a.AccountHeadSecurityId=b.AccountHeadSecurityId, a.AccountHeadSecurityName=b.AccountHeadSecurityName, a.FDAmountAmount=b.FDAmountAmount, a.FDAmountPercent=b.FDAmountPercent, a.AccountHeadFDAmountId=b.AccountHeadFDAmountId, a.AccountHeadFDAmountName=b.AccountHeadFDAmountName, a.RDAmountAmount=b.RDAmountAmount, a.RDAmountPercent=b.RDAmountPercent, a.AccountHeadRDAmountId=b.AccountHeadRDAmountId, a.AccountHeadRDAmountName=b.AccountHeadRDAmountName, a.DownPaymentAmount=b.DownPaymentAmount, a.DownPaymentPercent=b.DownPaymentPercent, a.AccountHeadDownPaymentId=b.AccountHeadDownPaymentId, a.AccountHeadDownPaymentName=b.AccountHeadDownPaymentName, a.InterestType=b.InterestType, a.ManualEMIAmount=b.EMIAmount, a.EMIAmountType=b.EMIAmountType, a.FirstInstallmentType=b.FirstInstallmentType FROM @FTable a INNER JOIN GroupLoanNoMaster b WITH(nolock) ON a.LoanTypeNo=b.GLoanTypeNo ; SELECT BranchId, BranchName, LoanOfficerId, LoanOfficerName, MemberId, MemberName, GuardianName, MemberRemark, MemberDOB, MemberAge, MobileNo, ContactNo, MemberAddress, NomineeName, NomineeDOB, NomineeAge, NomineeRelation, MemberBankName, BankBranchName, BankAccountNo, BankIFSCCode, BankAccountName, BankResponse, ApplicationRemark, ApplicationUserAndTime, ApplicationDocument1, ApplicationDocument2, ApplicationDate, ApplicationAmount, TotalAmount, EMIAmount, FirstEMIPaid, FDAmountApplied, RDAmountApplied, DownPaymentApplied, LoanTypeNo, LoanTypeName, InterestMethod, LoanTypeGroup, LoanTerm, LoanTermMode, LoanPurpose, InterestRate, NoPayingTerm, LoanHeadNameId, LoanHeadNameName, ProcessingFeeAmount, ProcessingFeePercent, ProcessingGSTPercent, AccountHeadProcessingId, AccountHeadProcessingName, InsuranceFeeAmount, InsuranceFeePercent, InsuranceGSTPercent, AccountHeadInsuranceId, AccountHeadInsuranceName, OtherChargeAmount, OtherChargePercent, OtherChargeGSTPercent, AccountHeadOtherChargeId, AccountHeadOtherChargeName, SecurityFeeAmount, SecurityFeePercent, AccountHeadSecurityId, AccountHeadSecurityName, FDAmountAmount, FDAmountPercent, AccountHeadFDAmountId, AccountHeadFDAmountName, RDAmountAmount, RDAmountPercent, AccountHeadRDAmountId, AccountHeadRDAmountName, DownPaymentAmount, DownPaymentPercent, AccountHeadDownPaymentId, AccountHeadDownPaymentName, InterestType, ManualEMIAmount, EMIAmountType, FirstInstallmentType, FirstEMIDate FROM @FTable ; String sql: Data: System.Collections.ListDictionaryInternal HelpLink: InnerException: Message: Invalid column name 'MobileNo'. Invalid column name 'ContactNo'. Invalid column name 'ApplicationEntryUser'. Invalid column name 'ApplicationEntryTime'. Invalid column name 'ApplicationEntryTime'. Source: .Net SqlClient Data Provider StackTrace: at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose) at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady) at System.Data.SqlClient.SqlDataReader.TryConsumeMetaData() at System.Data.SqlClient.SqlDataReader.get_MetaData() at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString, Boolean isInternal, Boolean forDescribeParameterEncryption, Boolean shouldCacheForAlwaysEncrypted) at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async, Int32 timeout, Task& task, Boolean asyncWrite, Boolean inRetry, SqlDataReader ds, Boolean describeParameterEncryptionRequest) at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, TaskCompletionSource`1 completion, Int32 timeout, Task& task, Boolean& usedCache, Boolean asyncWrite, Boolean inRetry) at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method) at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior, String method) at System.Data.SqlClient.SqlCommand.ExecuteDbDataReader(CommandBehavior behavior) at System.Data.Common.DbCommand.System.Data.IDbCommand.ExecuteReader(CommandBehavior behavior) at System.Data.Common.DbDataAdapter.FillInternal(DataSet dataset, DataTable[] datatables, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior) at System.Data.Common.DbDataAdapter.Fill(DataTable[] dataTables, Int32 startRecord, Int32 maxRecords, IDbCommand command, CommandBehavior behavior) at System.Data.Common.DbDataAdapter.Fill(DataTable dataTable) at ClassMaster.DataTableResult(String query) TargetSite: Void OnError(System.Data.SqlClient.SqlException, Boolean, System.Action`1[System.Action]) Time: 11/08/2026 10:08:24 AM PageName: IndividualLoan_IndvLoanDisbursementCorrection String str: DECLARE @ApplicationId VARCHAR(25), @OnDate DATE; SET @ApplicationId='GA10100042'; DECLARE @FTable TABLE ( BranchId VARCHAR(10), BranchName VARCHAR(50), LoanOfficerId VARCHAR(20), LoanOfficerName VARCHAR(50), MemberRemark VARCHAR(150), MemberId VARCHAR(20), MemberName VARCHAR(50), GuardianName VARCHAR(50), MemberDOB VARCHAR(20), MemberAge VARCHAR(10), MobileNo VARCHAR(20), ContactNo VARCHAR(20), MemberAddress VARCHAR(250), NomineeName VARCHAR(50), NomineeDOB VARCHAR(20), NomineeAge VARCHAR(10), NomineeRelation VARCHAR(50), MemberBankName VARCHAR(50), BankBranchName VARCHAR(50), BankAccountNo VARCHAR(20), BankIFSCCode VARCHAR(20), BankAccountName VARCHAR(50), BankResponse VARCHAR(50), ApplicationRemark VARCHAR(250), ApplicationUserAndTime VARCHAR(100), ApplicationDocument1 VARCHAR(100), ApplicationDocument2 VARCHAR(100), ApplicationDate VARCHAR(20), ApplicationAmount DECIMAL(18,2), TotalAmount DECIMAL(18,2), EMIAmount DECIMAL(18,2), FirstEMIPaid VARCHAR(10), FDAmountApplied DECIMAL(18,2), RDAmountApplied DECIMAL(18,2), DownPaymentApplied DECIMAL(18,2), LoanTypeNo VARCHAR(50), LoanTypeName VARCHAR(50), InterestMethod VARCHAR(20), LoanTypeGroup VARCHAR(20), LoanTerm VARCHAR(10), LoanTermMode VARCHAR(20), LoanPurpose VARCHAR(50), InterestRate VARCHAR(10), NoPayingTerm VARCHAR(10), LoanHeadNameId VARCHAR(10), LoanHeadNameName VARCHAR(100), ProcessingFeeAmount DECIMAL(10,6), ProcessingFeePercent DECIMAL(10,6), ProcessingGSTPercent DECIMAL(10,6), AccountHeadProcessingId VARCHAR(10), AccountHeadProcessingName VARCHAR(100), InsuranceFeeAmount DECIMAL(10,6), InsuranceFeePercent DECIMAL(10,6), InsuranceGSTPercent DECIMAL(10,6), AccountHeadInsuranceId VARCHAR(10), AccountHeadInsuranceName VARCHAR(100), OtherChargeAmount DECIMAL(10,6), OtherChargePercent DECIMAL(10,6), OtherChargeGSTPercent DECIMAL(10,6), AccountHeadOtherChargeId VARCHAR(10), AccountHeadOtherChargeName VARCHAR(100), SecurityFeeAmount DECIMAL(10,6), SecurityFeePercent DECIMAL(10,6), AccountHeadSecurityId VARCHAR(10), AccountHeadSecurityName VARCHAR(100), FDAmountAmount DECIMAL(10,6), FDAmountPercent DECIMAL(10,6), AccountHeadFDAmountId VARCHAR(10), AccountHeadFDAmountName VARCHAR(100), RDAmountAmount DECIMAL(10,6), RDAmountPercent DECIMAL(10,6), AccountHeadRDAmountId VARCHAR(10), AccountHeadRDAmountName VARCHAR(100), DownPaymentAmount DECIMAL(10,6), DownPaymentPercent DECIMAL(10,6), AccountHeadDownPaymentId VARCHAR(10), AccountHeadDownPaymentName VARCHAR(100), InterestType VARCHAR(20), ManualEMIAmount VARCHAR(20), EMIAmountType VARCHAR(20), FirstInstallmentType VARCHAR(20), FirstEMIDate VARCHAR(20)); INSERT INTO @FTable ( BranchId, BranchName, LoanOfficerId, LoanOfficerName, MemberId, MemberName, MobileNo, ContactNo, NomineeName, NomineeDOB, NomineeAge, NomineeRelation, MemberBankName, BankBranchName, BankAccountNo, BankIFSCCode, ApplicationRemark, ApplicationUserAndTime, ApplicationDocument1, ApplicationDocument2, ApplicationDate, ApplicationAmount, TotalAmount, EMIAmount, FirstEMIPaid, FDAmountApplied, RDAmountApplied, DownPaymentApplied, LoanTypeNo, LoanTypeName, InterestMethod, LoanTypeGroup, LoanTerm, LoanTermMode, LoanPurpose, InterestRate ) SELECT a.BranchId, a.BranchName, a.LoanOfficerId, a.LoanOfficerName, a.MemberId, a.MemberName, a.MobileNo, a.ContactNo, a.NomineeName, convert(CHAR,a.NomineeDOB,103)AS NomineeDOB, a.NomineeAge, a.NomineeRelation, a.MemberBankName, a.BankBranchName, a.BankAccountNo, a.BankIFSCCode, a.ApplicationRemark, a.ApplicationEntryUser+' on '+rtrim(convert(CHAR,a.ApplicationEntryTime,106))+' - '+rtrim(convert(CHAR,a.ApplicationEntryTime,108))AS ApplicationUserAndTime, a.ApplicationDoc1 AS ApplicationDocument1, a.ApplicationDoc2 AS ApplicationDocument2, convert(CHAR,a.ApplicationDate,103)AS ApplicationDate, a.ApplicationAmount, a.TotalAmount, a.EMIAmount, a.FirstEMIPaid, a.FDAmount AS FDAmountApplied, a.RDAmount AS RDAmountApplied, a.DownPayment AS DownPaymentApplied, a.GLoanTypeNo AS LoanTypeNo, a.GLoanTypeName AS LoanTypeName, a.InterestMethod, a.GLoanType AS LoanTypeGroup, a.LoanTerm, a.LoanTermMode, a.LoanPurpose, a.InterestRate FROM GroupLoanAccount a WITH(nolock) WHERE a.ApplicationId=@ApplicationId ; UPDATE a SET a.GuardianName=b.MemberGuardianName, a.MemberRemark=b.MemberRemark, a.MemberDOB=b.MemberDOB, a.MemberAge=b.MemberAge, a.MemberAddress=b.MemberAddress FROM @FTable a INNER JOIN ( SELECT MemberId, MemberGuardianName, convert(char,MemberDOB,106)AS MemberDOB, MemberAge, MemberAddress, MemberRemark FROM GroupLoanMemberDetail WITH(nolock) WHERE MemberId= (SELECT MemberId FROM @FTable) )b ON a.MemberId=b.MemberId ; UPDATE a SET a.BankAccountName=b.accountName, a.BankResponse=b.bankResponse FROM @FTable a INNER JOIN ( SELECT TOP 1 AccountNo, IFSCCode, accountName, bankResponse FROM BankAccountVerification WITH(nolock) WHERE AccountNo=(SELECT BankAccountNo FROM @FTable) AND IFSCCode=(SELECT BankIFSCCode FROM @FTable) ORDER BY EntryTime DESC, bankResponse DESC )b ON a.BankAccountNo=b.AccountNo AND a.MemberId=b.IFSCCode ; UPDATE a SET a.NoPayingTerm=b.NoPayingTerm, a.LoanHeadNameId=b.AccountHeadLoanId, a.LoanHeadNameName=b.AccountHeadLoanName, a.ProcessingFeeAmount=b.ProcessingFeeAmount, a.ProcessingFeePercent=b.ProcessingFeePercent, a.ProcessingGSTPercent=b.ProcessingGSTPercent, a.AccountHeadProcessingId=b.AccountHeadProcessingId, a.AccountHeadProcessingName=b.AccountHeadProcessingName, a.InsuranceFeeAmount=b.InsuranceFeeAmount, a.InsuranceFeePercent=b.InsuranceFeePercent, a.InsuranceGSTPercent=b.InsuranceGSTPercent, a.AccountHeadInsuranceId=b.AccountHeadInsuranceId, a.AccountHeadInsuranceName=b.AccountHeadInsuranceName, a.OtherChargeAmount=b.OtherChargeAmount, a.OtherChargePercent=b.OtherChargePercent, a.OtherChargeGSTPercent=b.OtherChargeGSTPercent, a.AccountHeadOtherChargeId=b.AccountHeadOtherChargeId, a.AccountHeadOtherChargeName=b.AccountHeadOtherChargeName, a.SecurityFeeAmount=b.SecurityFeeAmount, a.SecurityFeePercent=b.SecurityFeePercent, a.AccountHeadSecurityId=b.AccountHeadSecurityId, a.AccountHeadSecurityName=b.AccountHeadSecurityName, a.FDAmountAmount=b.FDAmountAmount, a.FDAmountPercent=b.FDAmountPercent, a.AccountHeadFDAmountId=b.AccountHeadFDAmountId, a.AccountHeadFDAmountName=b.AccountHeadFDAmountName, a.RDAmountAmount=b.RDAmountAmount, a.RDAmountPercent=b.RDAmountPercent, a.AccountHeadRDAmountId=b.AccountHeadRDAmountId, a.AccountHeadRDAmountName=b.AccountHeadRDAmountName, a.DownPaymentAmount=b.DownPaymentAmount, a.DownPaymentPercent=b.DownPaymentPercent, a.AccountHeadDownPaymentId=b.AccountHeadDownPaymentId, a.AccountHeadDownPaymentName=b.AccountHeadDownPaymentName, a.InterestType=b.InterestType, a.ManualEMIAmount=b.EMIAmount, a.EMIAmountType=b.EMIAmountType, a.FirstInstallmentType=b.FirstInstallmentType FROM @FTable a INNER JOIN GroupLoanNoMaster b WITH(nolock) ON a.LoanTypeNo=b.GLoanTypeNo ; SELECT BranchId, BranchName, LoanOfficerId, LoanOfficerName, MemberId, MemberName, GuardianName, MemberRemark, MemberDOB, MemberAge, MobileNo, ContactNo, MemberAddress, NomineeName, NomineeDOB, NomineeAge, NomineeRelation, MemberBankName, BankBranchName, BankAccountNo, BankIFSCCode, BankAccountName, BankResponse, ApplicationRemark, ApplicationUserAndTime, ApplicationDocument1, ApplicationDocument2, ApplicationDate, ApplicationAmount, TotalAmount, EMIAmount, FirstEMIPaid, FDAmountApplied, RDAmountApplied, DownPaymentApplied, LoanTypeNo, LoanTypeName, InterestMethod, LoanTypeGroup, LoanTerm, LoanTermMode, LoanPurpose, InterestRate, NoPayingTerm, LoanHeadNameId, LoanHeadNameName, ProcessingFeeAmount, ProcessingFeePercent, ProcessingGSTPercent, AccountHeadProcessingId, AccountHeadProcessingName, InsuranceFeeAmount, InsuranceFeePercent, InsuranceGSTPercent, AccountHeadInsuranceId, AccountHeadInsuranceName, OtherChargeAmount, OtherChargePercent, OtherChargeGSTPercent, AccountHeadOtherChargeId, AccountHeadOtherChargeName, SecurityFeeAmount, SecurityFeePercent, AccountHeadSecurityId, AccountHeadSecurityName, FDAmountAmount, FDAmountPercent, AccountHeadFDAmountId, AccountHeadFDAmountName, RDAmountAmount, RDAmountPercent, AccountHeadRDAmountId, AccountHeadRDAmountName, DownPaymentAmount, DownPaymentPercent, AccountHeadDownPaymentId, AccountHeadDownPaymentName, InterestType, ManualEMIAmount, EMIAmountType, FirstInstallmentType, FirstEMIDate FROM @FTable ; String sql: Data: System.Collections.ListDictionaryInternal HelpLink: InnerException: Message: Object reference not set to an instance of an object. Source: App_Web_oroze2tw StackTrace: at IndividualLoan_IndvLoanDisbursementCorrection.lbtnSelect_Click(Object sender, EventArgs e) TargetSite: Void lbtnSelect_Click(System.Object, System.EventArgs) Time: 11/08/2026 10:08:27 AM PageName: DataTableResult String str: DECLARE @ApplicationId VARCHAR(25), @OnDate DATE; SET @ApplicationId='GA10300069'; DECLARE @FTable TABLE ( BranchId VARCHAR(10), BranchName VARCHAR(50), LoanOfficerId VARCHAR(20), LoanOfficerName VARCHAR(50), MemberRemark VARCHAR(150), MemberId VARCHAR(20), MemberName VARCHAR(50), GuardianName VARCHAR(50), MemberDOB VARCHAR(20), MemberAge VARCHAR(10), MobileNo VARCHAR(20), ContactNo VARCHAR(20), MemberAddress VARCHAR(250), NomineeName VARCHAR(50), NomineeDOB VARCHAR(20), NomineeAge VARCHAR(10), NomineeRelation VARCHAR(50), MemberBankName VARCHAR(50), BankBranchName VARCHAR(50), BankAccountNo VARCHAR(20), BankIFSCCode VARCHAR(20), BankAccountName VARCHAR(50), BankResponse VARCHAR(50), ApplicationRemark VARCHAR(250), ApplicationUserAndTime VARCHAR(100), ApplicationDocument1 VARCHAR(100), ApplicationDocument2 VARCHAR(100), ApplicationDate VARCHAR(20), ApplicationAmount DECIMAL(18,2), TotalAmount DECIMAL(18,2), EMIAmount DECIMAL(18,2), FirstEMIPaid VARCHAR(10), FDAmountApplied DECIMAL(18,2), RDAmountApplied DECIMAL(18,2), DownPaymentApplied DECIMAL(18,2), LoanTypeNo VARCHAR(50), LoanTypeName VARCHAR(50), InterestMethod VARCHAR(20), LoanTypeGroup VARCHAR(20), LoanTerm VARCHAR(10), LoanTermMode VARCHAR(20), LoanPurpose VARCHAR(50), InterestRate VARCHAR(10), NoPayingTerm VARCHAR(10), LoanHeadNameId VARCHAR(10), LoanHeadNameName VARCHAR(100), ProcessingFeeAmount DECIMAL(10,6), ProcessingFeePercent DECIMAL(10,6), ProcessingGSTPercent DECIMAL(10,6), AccountHeadProcessingId VARCHAR(10), AccountHeadProcessingName VARCHAR(100), InsuranceFeeAmount DECIMAL(10,6), InsuranceFeePercent DECIMAL(10,6), InsuranceGSTPercent DECIMAL(10,6), AccountHeadInsuranceId VARCHAR(10), AccountHeadInsuranceName VARCHAR(100), OtherChargeAmount DECIMAL(10,6), OtherChargePercent DECIMAL(10,6), OtherChargeGSTPercent DECIMAL(10,6), AccountHeadOtherChargeId VARCHAR(10), AccountHeadOtherChargeName VARCHAR(100), SecurityFeeAmount DECIMAL(10,6), SecurityFeePercent DECIMAL(10,6), AccountHeadSecurityId VARCHAR(10), AccountHeadSecurityName VARCHAR(100), FDAmountAmount DECIMAL(10,6), FDAmountPercent DECIMAL(10,6), AccountHeadFDAmountId VARCHAR(10), AccountHeadFDAmountName VARCHAR(100), RDAmountAmount DECIMAL(10,6), RDAmountPercent DECIMAL(10,6), AccountHeadRDAmountId VARCHAR(10), AccountHeadRDAmountName VARCHAR(100), DownPaymentAmount DECIMAL(10,6), DownPaymentPercent DECIMAL(10,6), AccountHeadDownPaymentId VARCHAR(10), AccountHeadDownPaymentName VARCHAR(100), InterestType VARCHAR(20), ManualEMIAmount VARCHAR(20), EMIAmountType VARCHAR(20), FirstInstallmentType VARCHAR(20), FirstEMIDate VARCHAR(20)); INSERT INTO @FTable ( BranchId, BranchName, LoanOfficerId, LoanOfficerName, MemberId, MemberName, MobileNo, ContactNo, NomineeName, NomineeDOB, NomineeAge, NomineeRelation, MemberBankName, BankBranchName, BankAccountNo, BankIFSCCode, ApplicationRemark, ApplicationUserAndTime, ApplicationDocument1, ApplicationDocument2, ApplicationDate, ApplicationAmount, TotalAmount, EMIAmount, FirstEMIPaid, FDAmountApplied, RDAmountApplied, DownPaymentApplied, LoanTypeNo, LoanTypeName, InterestMethod, LoanTypeGroup, LoanTerm, LoanTermMode, LoanPurpose, InterestRate ) SELECT a.BranchId, a.BranchName, a.LoanOfficerId, a.LoanOfficerName, a.MemberId, a.MemberName, a.MobileNo, a.ContactNo, a.NomineeName, convert(CHAR,a.NomineeDOB,103)AS NomineeDOB, a.NomineeAge, a.NomineeRelation, a.MemberBankName, a.BankBranchName, a.BankAccountNo, a.BankIFSCCode, a.ApplicationRemark, a.ApplicationEntryUser+' on '+rtrim(convert(CHAR,a.ApplicationEntryTime,106))+' - '+rtrim(convert(CHAR,a.ApplicationEntryTime,108))AS ApplicationUserAndTime, a.ApplicationDoc1 AS ApplicationDocument1, a.ApplicationDoc2 AS ApplicationDocument2, convert(CHAR,a.ApplicationDate,103)AS ApplicationDate, a.ApplicationAmount, a.TotalAmount, a.EMIAmount, a.FirstEMIPaid, a.FDAmount AS FDAmountApplied, a.RDAmount AS RDAmountApplied, a.DownPayment AS DownPaymentApplied, a.GLoanTypeNo AS LoanTypeNo, a.GLoanTypeName AS LoanTypeName, a.InterestMethod, a.GLoanType AS LoanTypeGroup, a.LoanTerm, a.LoanTermMode, a.LoanPurpose, a.InterestRate FROM GroupLoanAccount a WITH(nolock) WHERE a.ApplicationId=@ApplicationId ; UPDATE a SET a.GuardianName=b.MemberGuardianName, a.MemberRemark=b.MemberRemark, a.MemberDOB=b.MemberDOB, a.MemberAge=b.MemberAge, a.MemberAddress=b.MemberAddress FROM @FTable a INNER JOIN ( SELECT MemberId, MemberGuardianName, convert(char,MemberDOB,106)AS MemberDOB, MemberAge, MemberAddress, MemberRemark FROM GroupLoanMemberDetail WITH(nolock) WHERE MemberId= (SELECT MemberId FROM @FTable) )b ON a.MemberId=b.MemberId ; UPDATE a SET a.BankAccountName=b.accountName, a.BankResponse=b.bankResponse FROM @FTable a INNER JOIN ( SELECT TOP 1 AccountNo, IFSCCode, accountName, bankResponse FROM BankAccountVerification WITH(nolock) WHERE AccountNo=(SELECT BankAccountNo FROM @FTable) AND IFSCCode=(SELECT BankIFSCCode FROM @FTable) ORDER BY EntryTime DESC, bankResponse DESC )b ON a.BankAccountNo=b.AccountNo AND a.MemberId=b.IFSCCode ; UPDATE a SET a.NoPayingTerm=b.NoPayingTerm, a.LoanHeadNameId=b.AccountHeadLoanId, a.LoanHeadNameName=b.AccountHeadLoanName, a.ProcessingFeeAmount=b.ProcessingFeeAmount, a.ProcessingFeePercent=b.ProcessingFeePercent, a.ProcessingGSTPercent=b.ProcessingGSTPercent, a.AccountHeadProcessingId=b.AccountHeadProcessingId, a.AccountHeadProcessingName=b.AccountHeadProcessingName, a.InsuranceFeeAmount=b.InsuranceFeeAmount, a.InsuranceFeePercent=b.InsuranceFeePercent, a.InsuranceGSTPercent=b.InsuranceGSTPercent, a.AccountHeadInsuranceId=b.AccountHeadInsuranceId, a.AccountHeadInsuranceName=b.AccountHeadInsuranceName, a.OtherChargeAmount=b.OtherChargeAmount, a.OtherChargePercent=b.OtherChargePercent, a.OtherChargeGSTPercent=b.OtherChargeGSTPercent, a.AccountHeadOtherChargeId=b.AccountHeadOtherChargeId, a.AccountHeadOtherChargeName=b.AccountHeadOtherChargeName, a.SecurityFeeAmount=b.SecurityFeeAmount, a.SecurityFeePercent=b.SecurityFeePercent, a.AccountHeadSecurityId=b.AccountHeadSecurityId, a.AccountHeadSecurityName=b.AccountHeadSecurityName, a.FDAmountAmount=b.FDAmountAmount, a.FDAmountPercent=b.FDAmountPercent, a.AccountHeadFDAmountId=b.AccountHeadFDAmountId, a.AccountHeadFDAmountName=b.AccountHeadFDAmountName, a.RDAmountAmount=b.RDAmountAmount, a.RDAmountPercent=b.RDAmountPercent, a.AccountHeadRDAmountId=b.AccountHeadRDAmountId, a.AccountHeadRDAmountName=b.AccountHeadRDAmountName, a.DownPaymentAmount=b.DownPaymentAmount, a.DownPaymentPercent=b.DownPaymentPercent, a.AccountHeadDownPaymentId=b.AccountHeadDownPaymentId, a.AccountHeadDownPaymentName=b.AccountHeadDownPaymentName, a.InterestType=b.InterestType, a.ManualEMIAmount=b.EMIAmount, a.EMIAmountType=b.EMIAmountType, a.FirstInstallmentType=b.FirstInstallmentType FROM @FTable a INNER JOIN GroupLoanNoMaster b WITH(nolock) ON a.LoanTypeNo=b.GLoanTypeNo ; SELECT BranchId, BranchName, LoanOfficerId, LoanOfficerName, MemberId, MemberName, GuardianName, MemberRemark, MemberDOB, MemberAge, MobileNo, ContactNo, MemberAddress, NomineeName, NomineeDOB, NomineeAge, NomineeRelation, MemberBankName, BankBranchName, BankAccountNo, BankIFSCCode, BankAccountName, BankResponse, ApplicationRemark, ApplicationUserAndTime, ApplicationDocument1, ApplicationDocument2, ApplicationDate, ApplicationAmount, TotalAmount, EMIAmount, FirstEMIPaid, FDAmountApplied, RDAmountApplied, DownPaymentApplied, LoanTypeNo, LoanTypeName, InterestMethod, LoanTypeGroup, LoanTerm, LoanTermMode, LoanPurpose, InterestRate, NoPayingTerm, LoanHeadNameId, LoanHeadNameName, ProcessingFeeAmount, ProcessingFeePercent, ProcessingGSTPercent, AccountHeadProcessingId, AccountHeadProcessingName, InsuranceFeeAmount, InsuranceFeePercent, InsuranceGSTPercent, AccountHeadInsuranceId, AccountHeadInsuranceName, OtherChargeAmount, OtherChargePercent, OtherChargeGSTPercent, AccountHeadOtherChargeId, AccountHeadOtherChargeName, SecurityFeeAmount, SecurityFeePercent, AccountHeadSecurityId, AccountHeadSecurityName, FDAmountAmount, FDAmountPercent, AccountHeadFDAmountId, AccountHeadFDAmountName, RDAmountAmount, RDAmountPercent, AccountHeadRDAmountId, AccountHeadRDAmountName, DownPaymentAmount, DownPaymentPercent, AccountHeadDownPaymentId, AccountHeadDownPaymentName, InterestType, ManualEMIAmount, EMIAmountType, FirstInstallmentType, FirstEMIDate FROM @FTable ; String sql: Data: System.Collections.ListDictionaryInternal HelpLink: InnerException: Message: Invalid column name 'MobileNo'. Invalid column name 'ContactNo'. Invalid column name 'ApplicationEntryUser'. Invalid column name 'ApplicationEntryTime'. Invalid column name 'ApplicationEntryTime'. Source: .Net SqlClient Data Provider StackTrace: at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose) at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady) at System.Data.SqlClient.SqlDataReader.TryConsumeMetaData() at System.Data.SqlClient.SqlDataReader.get_MetaData() at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString, Boolean isInternal, Boolean forDescribeParameterEncryption, Boolean shouldCacheForAlwaysEncrypted) at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async, Int32 timeout, Task& task, Boolean asyncWrite, Boolean inRetry, SqlDataReader ds, Boolean describeParameterEncryptionRequest) at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, TaskCompletionSource`1 completion, Int32 timeout, Task& task, Boolean& usedCache, Boolean asyncWrite, Boolean inRetry) at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method) at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior, String method) at System.Data.SqlClient.SqlCommand.ExecuteDbDataReader(CommandBehavior behavior) at System.Data.Common.DbCommand.System.Data.IDbCommand.ExecuteReader(CommandBehavior behavior) at System.Data.Common.DbDataAdapter.FillInternal(DataSet dataset, DataTable[] datatables, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior) at System.Data.Common.DbDataAdapter.Fill(DataTable[] dataTables, Int32 startRecord, Int32 maxRecords, IDbCommand command, CommandBehavior behavior) at System.Data.Common.DbDataAdapter.Fill(DataTable dataTable) at ClassMaster.DataTableResult(String query) TargetSite: Void OnError(System.Data.SqlClient.SqlException, Boolean, System.Action`1[System.Action]) Time: 11/08/2026 10:08:27 AM PageName: IndividualLoan_IndvLoanDisbursementCorrection String str: DECLARE @ApplicationId VARCHAR(25), @OnDate DATE; SET @ApplicationId='GA10300069'; DECLARE @FTable TABLE ( BranchId VARCHAR(10), BranchName VARCHAR(50), LoanOfficerId VARCHAR(20), LoanOfficerName VARCHAR(50), MemberRemark VARCHAR(150), MemberId VARCHAR(20), MemberName VARCHAR(50), GuardianName VARCHAR(50), MemberDOB VARCHAR(20), MemberAge VARCHAR(10), MobileNo VARCHAR(20), ContactNo VARCHAR(20), MemberAddress VARCHAR(250), NomineeName VARCHAR(50), NomineeDOB VARCHAR(20), NomineeAge VARCHAR(10), NomineeRelation VARCHAR(50), MemberBankName VARCHAR(50), BankBranchName VARCHAR(50), BankAccountNo VARCHAR(20), BankIFSCCode VARCHAR(20), BankAccountName VARCHAR(50), BankResponse VARCHAR(50), ApplicationRemark VARCHAR(250), ApplicationUserAndTime VARCHAR(100), ApplicationDocument1 VARCHAR(100), ApplicationDocument2 VARCHAR(100), ApplicationDate VARCHAR(20), ApplicationAmount DECIMAL(18,2), TotalAmount DECIMAL(18,2), EMIAmount DECIMAL(18,2), FirstEMIPaid VARCHAR(10), FDAmountApplied DECIMAL(18,2), RDAmountApplied DECIMAL(18,2), DownPaymentApplied DECIMAL(18,2), LoanTypeNo VARCHAR(50), LoanTypeName VARCHAR(50), InterestMethod VARCHAR(20), LoanTypeGroup VARCHAR(20), LoanTerm VARCHAR(10), LoanTermMode VARCHAR(20), LoanPurpose VARCHAR(50), InterestRate VARCHAR(10), NoPayingTerm VARCHAR(10), LoanHeadNameId VARCHAR(10), LoanHeadNameName VARCHAR(100), ProcessingFeeAmount DECIMAL(10,6), ProcessingFeePercent DECIMAL(10,6), ProcessingGSTPercent DECIMAL(10,6), AccountHeadProcessingId VARCHAR(10), AccountHeadProcessingName VARCHAR(100), InsuranceFeeAmount DECIMAL(10,6), InsuranceFeePercent DECIMAL(10,6), InsuranceGSTPercent DECIMAL(10,6), AccountHeadInsuranceId VARCHAR(10), AccountHeadInsuranceName VARCHAR(100), OtherChargeAmount DECIMAL(10,6), OtherChargePercent DECIMAL(10,6), OtherChargeGSTPercent DECIMAL(10,6), AccountHeadOtherChargeId VARCHAR(10), AccountHeadOtherChargeName VARCHAR(100), SecurityFeeAmount DECIMAL(10,6), SecurityFeePercent DECIMAL(10,6), AccountHeadSecurityId VARCHAR(10), AccountHeadSecurityName VARCHAR(100), FDAmountAmount DECIMAL(10,6), FDAmountPercent DECIMAL(10,6), AccountHeadFDAmountId VARCHAR(10), AccountHeadFDAmountName VARCHAR(100), RDAmountAmount DECIMAL(10,6), RDAmountPercent DECIMAL(10,6), AccountHeadRDAmountId VARCHAR(10), AccountHeadRDAmountName VARCHAR(100), DownPaymentAmount DECIMAL(10,6), DownPaymentPercent DECIMAL(10,6), AccountHeadDownPaymentId VARCHAR(10), AccountHeadDownPaymentName VARCHAR(100), InterestType VARCHAR(20), ManualEMIAmount VARCHAR(20), EMIAmountType VARCHAR(20), FirstInstallmentType VARCHAR(20), FirstEMIDate VARCHAR(20)); INSERT INTO @FTable ( BranchId, BranchName, LoanOfficerId, LoanOfficerName, MemberId, MemberName, MobileNo, ContactNo, NomineeName, NomineeDOB, NomineeAge, NomineeRelation, MemberBankName, BankBranchName, BankAccountNo, BankIFSCCode, ApplicationRemark, ApplicationUserAndTime, ApplicationDocument1, ApplicationDocument2, ApplicationDate, ApplicationAmount, TotalAmount, EMIAmount, FirstEMIPaid, FDAmountApplied, RDAmountApplied, DownPaymentApplied, LoanTypeNo, LoanTypeName, InterestMethod, LoanTypeGroup, LoanTerm, LoanTermMode, LoanPurpose, InterestRate ) SELECT a.BranchId, a.BranchName, a.LoanOfficerId, a.LoanOfficerName, a.MemberId, a.MemberName, a.MobileNo, a.ContactNo, a.NomineeName, convert(CHAR,a.NomineeDOB,103)AS NomineeDOB, a.NomineeAge, a.NomineeRelation, a.MemberBankName, a.BankBranchName, a.BankAccountNo, a.BankIFSCCode, a.ApplicationRemark, a.ApplicationEntryUser+' on '+rtrim(convert(CHAR,a.ApplicationEntryTime,106))+' - '+rtrim(convert(CHAR,a.ApplicationEntryTime,108))AS ApplicationUserAndTime, a.ApplicationDoc1 AS ApplicationDocument1, a.ApplicationDoc2 AS ApplicationDocument2, convert(CHAR,a.ApplicationDate,103)AS ApplicationDate, a.ApplicationAmount, a.TotalAmount, a.EMIAmount, a.FirstEMIPaid, a.FDAmount AS FDAmountApplied, a.RDAmount AS RDAmountApplied, a.DownPayment AS DownPaymentApplied, a.GLoanTypeNo AS LoanTypeNo, a.GLoanTypeName AS LoanTypeName, a.InterestMethod, a.GLoanType AS LoanTypeGroup, a.LoanTerm, a.LoanTermMode, a.LoanPurpose, a.InterestRate FROM GroupLoanAccount a WITH(nolock) WHERE a.ApplicationId=@ApplicationId ; UPDATE a SET a.GuardianName=b.MemberGuardianName, a.MemberRemark=b.MemberRemark, a.MemberDOB=b.MemberDOB, a.MemberAge=b.MemberAge, a.MemberAddress=b.MemberAddress FROM @FTable a INNER JOIN ( SELECT MemberId, MemberGuardianName, convert(char,MemberDOB,106)AS MemberDOB, MemberAge, MemberAddress, MemberRemark FROM GroupLoanMemberDetail WITH(nolock) WHERE MemberId= (SELECT MemberId FROM @FTable) )b ON a.MemberId=b.MemberId ; UPDATE a SET a.BankAccountName=b.accountName, a.BankResponse=b.bankResponse FROM @FTable a INNER JOIN ( SELECT TOP 1 AccountNo, IFSCCode, accountName, bankResponse FROM BankAccountVerification WITH(nolock) WHERE AccountNo=(SELECT BankAccountNo FROM @FTable) AND IFSCCode=(SELECT BankIFSCCode FROM @FTable) ORDER BY EntryTime DESC, bankResponse DESC )b ON a.BankAccountNo=b.AccountNo AND a.MemberId=b.IFSCCode ; UPDATE a SET a.NoPayingTerm=b.NoPayingTerm, a.LoanHeadNameId=b.AccountHeadLoanId, a.LoanHeadNameName=b.AccountHeadLoanName, a.ProcessingFeeAmount=b.ProcessingFeeAmount, a.ProcessingFeePercent=b.ProcessingFeePercent, a.ProcessingGSTPercent=b.ProcessingGSTPercent, a.AccountHeadProcessingId=b.AccountHeadProcessingId, a.AccountHeadProcessingName=b.AccountHeadProcessingName, a.InsuranceFeeAmount=b.InsuranceFeeAmount, a.InsuranceFeePercent=b.InsuranceFeePercent, a.InsuranceGSTPercent=b.InsuranceGSTPercent, a.AccountHeadInsuranceId=b.AccountHeadInsuranceId, a.AccountHeadInsuranceName=b.AccountHeadInsuranceName, a.OtherChargeAmount=b.OtherChargeAmount, a.OtherChargePercent=b.OtherChargePercent, a.OtherChargeGSTPercent=b.OtherChargeGSTPercent, a.AccountHeadOtherChargeId=b.AccountHeadOtherChargeId, a.AccountHeadOtherChargeName=b.AccountHeadOtherChargeName, a.SecurityFeeAmount=b.SecurityFeeAmount, a.SecurityFeePercent=b.SecurityFeePercent, a.AccountHeadSecurityId=b.AccountHeadSecurityId, a.AccountHeadSecurityName=b.AccountHeadSecurityName, a.FDAmountAmount=b.FDAmountAmount, a.FDAmountPercent=b.FDAmountPercent, a.AccountHeadFDAmountId=b.AccountHeadFDAmountId, a.AccountHeadFDAmountName=b.AccountHeadFDAmountName, a.RDAmountAmount=b.RDAmountAmount, a.RDAmountPercent=b.RDAmountPercent, a.AccountHeadRDAmountId=b.AccountHeadRDAmountId, a.AccountHeadRDAmountName=b.AccountHeadRDAmountName, a.DownPaymentAmount=b.DownPaymentAmount, a.DownPaymentPercent=b.DownPaymentPercent, a.AccountHeadDownPaymentId=b.AccountHeadDownPaymentId, a.AccountHeadDownPaymentName=b.AccountHeadDownPaymentName, a.InterestType=b.InterestType, a.ManualEMIAmount=b.EMIAmount, a.EMIAmountType=b.EMIAmountType, a.FirstInstallmentType=b.FirstInstallmentType FROM @FTable a INNER JOIN GroupLoanNoMaster b WITH(nolock) ON a.LoanTypeNo=b.GLoanTypeNo ; SELECT BranchId, BranchName, LoanOfficerId, LoanOfficerName, MemberId, MemberName, GuardianName, MemberRemark, MemberDOB, MemberAge, MobileNo, ContactNo, MemberAddress, NomineeName, NomineeDOB, NomineeAge, NomineeRelation, MemberBankName, BankBranchName, BankAccountNo, BankIFSCCode, BankAccountName, BankResponse, ApplicationRemark, ApplicationUserAndTime, ApplicationDocument1, ApplicationDocument2, ApplicationDate, ApplicationAmount, TotalAmount, EMIAmount, FirstEMIPaid, FDAmountApplied, RDAmountApplied, DownPaymentApplied, LoanTypeNo, LoanTypeName, InterestMethod, LoanTypeGroup, LoanTerm, LoanTermMode, LoanPurpose, InterestRate, NoPayingTerm, LoanHeadNameId, LoanHeadNameName, ProcessingFeeAmount, ProcessingFeePercent, ProcessingGSTPercent, AccountHeadProcessingId, AccountHeadProcessingName, InsuranceFeeAmount, InsuranceFeePercent, InsuranceGSTPercent, AccountHeadInsuranceId, AccountHeadInsuranceName, OtherChargeAmount, OtherChargePercent, OtherChargeGSTPercent, AccountHeadOtherChargeId, AccountHeadOtherChargeName, SecurityFeeAmount, SecurityFeePercent, AccountHeadSecurityId, AccountHeadSecurityName, FDAmountAmount, FDAmountPercent, AccountHeadFDAmountId, AccountHeadFDAmountName, RDAmountAmount, RDAmountPercent, AccountHeadRDAmountId, AccountHeadRDAmountName, DownPaymentAmount, DownPaymentPercent, AccountHeadDownPaymentId, AccountHeadDownPaymentName, InterestType, ManualEMIAmount, EMIAmountType, FirstInstallmentType, FirstEMIDate FROM @FTable ; String sql: Data: System.Collections.ListDictionaryInternal HelpLink: InnerException: Message: Object reference not set to an instance of an object. Source: App_Web_oroze2tw StackTrace: at IndividualLoan_IndvLoanDisbursementCorrection.lbtnSelect_Click(Object sender, EventArgs e) TargetSite: Void lbtnSelect_Click(System.Object, System.EventArgs)