Time: 10/11/2025 11:48:42 AM PageName: LoanOfficerMobileLoginAppURL String str: String sql: Data: System.Collections.ListDictionaryInternal HelpLink: InnerException: Message: Object reference not set to an instance of an object. Source: App_Web_q3pv2aal StackTrace: at LoanOfficerMobileLoginAppURL.Page_Load(Object sender, EventArgs e) TargetSite: Void Page_Load(System.Object, System.EventArgs) Time: 10/11/2025 11:50:26 AM PageName: LoanOfficerMobileLoginAppURL String str: String sql: Data: System.Collections.ListDictionaryInternal HelpLink: InnerException: Message: Object reference not set to an instance of an object. Source: App_Web_q3pv2aal StackTrace: at LoanOfficerMobileLoginAppURL.Page_Load(Object sender, EventArgs e) TargetSite: Void Page_Load(System.Object, System.EventArgs) Time: 10/11/2025 11:58:07 AM PageName: LoanOfficerMobileMasterPage String str: String sql: Data: System.Collections.ListDictionaryInternal HelpLink: InnerException: Message: Method not found: 'System.String ClassMaster.CreateLoanOfficerMenu24(System.Data.DataTable)'. Source: App_Web_lzfl5eot StackTrace: at LoanOfficerMobileMasterPage.LoanOfficerMobileMenuList() at LoanOfficerMobileMasterPage.Page_Load(Object sender, EventArgs e) TargetSite: Void LoanOfficerMobileMenuList() Time: 10/11/2025 12:00:09 PM PageName: LoanOfficerMobileMasterPage String str: String sql: Data: System.Collections.ListDictionaryInternal HelpLink: InnerException: Message: Method not found: 'System.String ClassMaster.CreateLoanOfficerMenu24(System.Data.DataTable)'. Source: App_Web_lzfl5eot StackTrace: at LoanOfficerMobileMasterPage.LoanOfficerMobileMenuList() at LoanOfficerMobileMasterPage.Page_Load(Object sender, EventArgs e) TargetSite: Void LoanOfficerMobileMenuList() Time: 10/11/2025 12:42:18 PM PageName: CreateSingleLayerMenu String str: String sql: Data: System.Collections.ListDictionaryInternal HelpLink: InnerException: Message: Column 'MenuImage' does not belong to table Table1. Source: System.Data StackTrace: at System.Data.DataRow.GetDataColumn(String columnName) at System.Data.DataRow.get_Item(String columnName) at ClassMaster.CreateSingleLayerMenu(DataTable dtMenuList) TargetSite: System.Data.DataColumn GetDataColumn(System.String) Time: 10/11/2025 01:34:51 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.End() at System.Web.HttpResponse.Redirect(String url, Boolean endResponse, Boolean permanent) at AdminLogOut.btnLogout_Click(Object sender, EventArgs e) TargetSite: Void AbortInternal() Time: 10/11/2025 02:01:08 PM PageName: DataSetResult String str: SELECT LoanTypeName FROM LoanTypeMaster WHERE LoanTypeStatus='Active' ORDER BY LoanTypeName; SELECT FeeName FROM GroupLoanFeeMaster WITH(nolock) WHERE FeeStatus='Active' ORDER BY FeeName; SELECT LedgerId, LedgerName FROM AccountLedgerMaster WHERE LedgerId=(SELECT AccountHeadId FROM AccountHeadIdMaster WHERE AccountHeadStatus='Active' AND AccountHeadType='GoodsAndServiceTax')OR LedgerHead=(SELECT AccountHeadId FROM AccountHeadIdMaster WHERE AccountHeadStatus='Active' AND AccountHeadType='GoodsAndServiceTax') ORDER BY LedgerName; SELECT LedgerId, LedgerName FROM AccountLedgerMaster WHERE LedgerId=(SELECT AccountHeadId FROM AccountHeadIdMaster WHERE AccountHeadStatus='Active' AND AccountHeadType='GroupLoanHead')OR LedgerHead=(SELECT AccountHeadId FROM AccountHeadIdMaster WHERE AccountHeadStatus='Active' AND AccountHeadType='GroupLoanHead') ORDER BY LedgerName; SELECT LedgerId, LedgerName FROM AccountLedgerMaster WHERE LedgerId=(SELECT AccountHeadId FROM AccountHeadIdMaster WHERE AccountHeadStatus='Active' AND AccountHeadType='GroupLoanInterest')OR LedgerHead=(SELECT AccountHeadId FROM AccountHeadIdMaster WHERE AccountHeadStatus='Active' AND AccountHeadType='GroupLoanInterest') ORDER BY LedgerName; SELECT LedgerId, LedgerName FROM AccountLedgerMaster WHERE LedgerId=(SELECT AccountHeadId FROM AccountHeadIdMaster WHERE AccountHeadStatus='Active' AND AccountHeadType='GroupLoanFee')OR LedgerHead=(SELECT AccountHeadId FROM AccountHeadIdMaster WHERE AccountHeadStatus='Active' AND AccountHeadType='GroupLoanFee') ORDER BY LedgerName; SELECT LedgerId, LedgerName FROM AccountLedgerMaster WHERE LedgerId IN(SELECT AccountHeadId FROM AccountHeadIdMaster WHERE AccountHeadStatus='Active' AND AccountHeadType IN ('GroupLoanHead','GroupLoanFee','GroupLoanPayable') )OR LedgerHead IN (SELECT AccountHeadId FROM AccountHeadIdMaster WHERE AccountHeadStatus='Active' AND AccountHeadType IN ('GroupLoanHead','GroupLoanFee','GroupLoanPayable') ) ORDER BY LedgerName; String sql: Data: System.Collections.ListDictionaryInternal HelpLink: InnerException: Message: Invalid object name 'LoanTypeMaster'. 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(DataSet dataSet, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior) at System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, String srcTable) at ClassMaster.DataSetResult(String query) TargetSite: Void OnError(System.Data.SqlClient.SqlException, Boolean, System.Action`1[System.Action]) Time: 10/11/2025 02:02:04 PM PageName: DataTableResult String str: SELECT GLoanTypeId, LoanGroup, GroupLoanType, GLoanTypeNo, GLoanTypeName, GLoanNoPrefix, TermMode, MinimumTerm, MultipleTerm, MaximumTerm, NoPayingTerm, MinimumAmount, MultipleAmount, MaximumAmount, InterestMethod, InterestType, InterestRateMinimum, InterestRateAnnual, InterestRateMaximum, GracePeriod, PenaltyRateAnnual, FirstEMIPayment, EMIAmount, EMIAmountType, FirstInstallmentType, AccountHeadLoanId, AccountHeadLoanName, AccountHeadInterestId, AccountHeadInterestName, AccountHeadPenaltyId, AccountHeadPenaltyName, AccountHeadGSTId, AccountHeadGSTName, ProcessingIncludedInFee, ProcessingFee, ProcessingFeePercent, ProcessingFeeAmount, ProcessingGSTPercent, AccountHeadProcessingId, AccountHeadProcessingName, InsuranceIncludedInFee, InsuranceFee, InsuranceFeePercent, InsuranceFeeAmount, InsuranceGSTPercent, AccountHeadInsuranceId, AccountHeadInsuranceName, OtherChargeIncludedInFee, OtherCharge, OtherChargePercent, OtherChargeAmount, OtherChargeGSTPercent, AccountHeadOtherChargeId, AccountHeadOtherChargeName, SecurityIncludedInFee, SecurityFee, SecurityFeePercent, SecurityFeeAmount, AccountHeadSecurityId, AccountHeadSecurityName, FDIncludedInFee, FDAmount, FDAmountPercent, FDAmountAmount, AccountHeadFDAmountId, AccountHeadFDAmountName, RDIncludedInFee, RDAmount, RDAmountPercent, RDAmountAmount, AccountHeadRDAmountId, AccountHeadRDAmountName, DownPaymentIncludedInFee, DownPayment, DownPaymentPercent, DownPaymentAmount, AccountHeadDownPaymentId, AccountHeadDownPaymentName, LoanTypeStatus, LoanTypeRemark, EntryUser, rtrim(Convert(char,EntryTime,106))+' - '+rtrim(Convert(char,EntryTime,108))AS EntryTime FROM GroupLoanNoMaster WITH(nolock) WHERE 1=1 AND LoanTypeStatus='Active' ORDER BY LoanTypeStatus, LoanGroup, GroupLoanType, GLoanTypeNo ; String sql: Data: System.Collections.ListDictionaryInternal HelpLink: InnerException: Message: Invalid column name 'ProcessingIncludedInFee'. Invalid column name 'InsuranceIncludedInFee'. Invalid column name 'OtherChargeIncludedInFee'. Invalid column name 'SecurityIncludedInFee'. Invalid column name 'FDIncludedInFee'. Invalid column name 'RDIncludedInFee'. Invalid column name 'DownPaymentIncludedInFee'. 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: 10/11/2025 02:02:04 PM PageName: GroupLoan_GroupLoanNoMasterUpdation String str: SELECT GLoanTypeId, LoanGroup, GroupLoanType, GLoanTypeNo, GLoanTypeName, GLoanNoPrefix, TermMode, MinimumTerm, MultipleTerm, MaximumTerm, NoPayingTerm, MinimumAmount, MultipleAmount, MaximumAmount, InterestMethod, InterestType, InterestRateMinimum, InterestRateAnnual, InterestRateMaximum, GracePeriod, PenaltyRateAnnual, FirstEMIPayment, EMIAmount, EMIAmountType, FirstInstallmentType, AccountHeadLoanId, AccountHeadLoanName, AccountHeadInterestId, AccountHeadInterestName, AccountHeadPenaltyId, AccountHeadPenaltyName, AccountHeadGSTId, AccountHeadGSTName, ProcessingIncludedInFee, ProcessingFee, ProcessingFeePercent, ProcessingFeeAmount, ProcessingGSTPercent, AccountHeadProcessingId, AccountHeadProcessingName, InsuranceIncludedInFee, InsuranceFee, InsuranceFeePercent, InsuranceFeeAmount, InsuranceGSTPercent, AccountHeadInsuranceId, AccountHeadInsuranceName, OtherChargeIncludedInFee, OtherCharge, OtherChargePercent, OtherChargeAmount, OtherChargeGSTPercent, AccountHeadOtherChargeId, AccountHeadOtherChargeName, SecurityIncludedInFee, SecurityFee, SecurityFeePercent, SecurityFeeAmount, AccountHeadSecurityId, AccountHeadSecurityName, FDIncludedInFee, FDAmount, FDAmountPercent, FDAmountAmount, AccountHeadFDAmountId, AccountHeadFDAmountName, RDIncludedInFee, RDAmount, RDAmountPercent, RDAmountAmount, AccountHeadRDAmountId, AccountHeadRDAmountName, DownPaymentIncludedInFee, DownPayment, DownPaymentPercent, DownPaymentAmount, AccountHeadDownPaymentId, AccountHeadDownPaymentName, LoanTypeStatus, LoanTypeRemark, EntryUser, rtrim(Convert(char,EntryTime,106))+' - '+rtrim(Convert(char,EntryTime,108))AS EntryTime FROM GroupLoanNoMaster WITH(nolock) WHERE 1=1 AND LoanTypeStatus='Active' ORDER BY LoanTypeStatus, LoanGroup, GroupLoanType, GLoanTypeNo ; String sql: Data: System.Collections.ListDictionaryInternal HelpLink: InnerException: Message: Object reference not set to an instance of an object. Source: App_Web_k5hasjlv StackTrace: at GroupLoan_GroupLoanNoMasterUpdation.FillData() TargetSite: Void FillData() Time: 10/11/2025 02:02:08 PM PageName: DataTableResult String str: SELECT GLoanTypeId, LoanGroup, GroupLoanType, GLoanTypeNo, GLoanTypeName, GLoanNoPrefix, TermMode, MinimumTerm, MultipleTerm, MaximumTerm, NoPayingTerm, MinimumAmount, MultipleAmount, MaximumAmount, InterestMethod, InterestType, InterestRateMinimum, InterestRateAnnual, InterestRateMaximum, GracePeriod, PenaltyRateAnnual, FirstEMIPayment, EMIAmount, EMIAmountType, FirstInstallmentType, AccountHeadLoanId, AccountHeadLoanName, AccountHeadInterestId, AccountHeadInterestName, AccountHeadPenaltyId, AccountHeadPenaltyName, AccountHeadGSTId, AccountHeadGSTName, ProcessingIncludedInFee, ProcessingFee, ProcessingFeePercent, ProcessingFeeAmount, ProcessingGSTPercent, AccountHeadProcessingId, AccountHeadProcessingName, InsuranceIncludedInFee, InsuranceFee, InsuranceFeePercent, InsuranceFeeAmount, InsuranceGSTPercent, AccountHeadInsuranceId, AccountHeadInsuranceName, OtherChargeIncludedInFee, OtherCharge, OtherChargePercent, OtherChargeAmount, OtherChargeGSTPercent, AccountHeadOtherChargeId, AccountHeadOtherChargeName, SecurityIncludedInFee, SecurityFee, SecurityFeePercent, SecurityFeeAmount, AccountHeadSecurityId, AccountHeadSecurityName, FDIncludedInFee, FDAmount, FDAmountPercent, FDAmountAmount, AccountHeadFDAmountId, AccountHeadFDAmountName, RDIncludedInFee, RDAmount, RDAmountPercent, RDAmountAmount, AccountHeadRDAmountId, AccountHeadRDAmountName, DownPaymentIncludedInFee, DownPayment, DownPaymentPercent, DownPaymentAmount, AccountHeadDownPaymentId, AccountHeadDownPaymentName, LoanTypeStatus, LoanTypeRemark, EntryUser, rtrim(Convert(char,EntryTime,106))+' - '+rtrim(Convert(char,EntryTime,108))AS EntryTime FROM GroupLoanNoMaster WITH(nolock) WHERE 1=1 AND LoanGroup='Group' AND LoanTypeStatus='Active' ORDER BY LoanTypeStatus, LoanGroup, GroupLoanType, GLoanTypeNo ; String sql: Data: System.Collections.ListDictionaryInternal HelpLink: InnerException: Message: Invalid column name 'ProcessingIncludedInFee'. Invalid column name 'InsuranceIncludedInFee'. Invalid column name 'OtherChargeIncludedInFee'. Invalid column name 'SecurityIncludedInFee'. Invalid column name 'FDIncludedInFee'. Invalid column name 'RDIncludedInFee'. Invalid column name 'DownPaymentIncludedInFee'. 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: 10/11/2025 02:02:08 PM PageName: GroupLoan_GroupLoanNoMasterUpdation String str: SELECT GLoanTypeId, LoanGroup, GroupLoanType, GLoanTypeNo, GLoanTypeName, GLoanNoPrefix, TermMode, MinimumTerm, MultipleTerm, MaximumTerm, NoPayingTerm, MinimumAmount, MultipleAmount, MaximumAmount, InterestMethod, InterestType, InterestRateMinimum, InterestRateAnnual, InterestRateMaximum, GracePeriod, PenaltyRateAnnual, FirstEMIPayment, EMIAmount, EMIAmountType, FirstInstallmentType, AccountHeadLoanId, AccountHeadLoanName, AccountHeadInterestId, AccountHeadInterestName, AccountHeadPenaltyId, AccountHeadPenaltyName, AccountHeadGSTId, AccountHeadGSTName, ProcessingIncludedInFee, ProcessingFee, ProcessingFeePercent, ProcessingFeeAmount, ProcessingGSTPercent, AccountHeadProcessingId, AccountHeadProcessingName, InsuranceIncludedInFee, InsuranceFee, InsuranceFeePercent, InsuranceFeeAmount, InsuranceGSTPercent, AccountHeadInsuranceId, AccountHeadInsuranceName, OtherChargeIncludedInFee, OtherCharge, OtherChargePercent, OtherChargeAmount, OtherChargeGSTPercent, AccountHeadOtherChargeId, AccountHeadOtherChargeName, SecurityIncludedInFee, SecurityFee, SecurityFeePercent, SecurityFeeAmount, AccountHeadSecurityId, AccountHeadSecurityName, FDIncludedInFee, FDAmount, FDAmountPercent, FDAmountAmount, AccountHeadFDAmountId, AccountHeadFDAmountName, RDIncludedInFee, RDAmount, RDAmountPercent, RDAmountAmount, AccountHeadRDAmountId, AccountHeadRDAmountName, DownPaymentIncludedInFee, DownPayment, DownPaymentPercent, DownPaymentAmount, AccountHeadDownPaymentId, AccountHeadDownPaymentName, LoanTypeStatus, LoanTypeRemark, EntryUser, rtrim(Convert(char,EntryTime,106))+' - '+rtrim(Convert(char,EntryTime,108))AS EntryTime FROM GroupLoanNoMaster WITH(nolock) WHERE 1=1 AND LoanGroup='Group' AND LoanTypeStatus='Active' ORDER BY LoanTypeStatus, LoanGroup, GroupLoanType, GLoanTypeNo ; String sql: Data: System.Collections.ListDictionaryInternal HelpLink: InnerException: Message: Object reference not set to an instance of an object. Source: App_Web_k5hasjlv StackTrace: at GroupLoan_GroupLoanNoMasterUpdation.FillData() TargetSite: Void FillData() Time: 10/11/2025 02:03:34 PM PageName: GroupLoan_GroupLoanEMIList 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 GroupLoan_GroupLoanEMIList.btnExport_Click(Object sender, EventArgs e) TargetSite: Void AbortInternal() Time: 10/11/2025 02:07:41 PM PageName: DataSetResult String str: SELECT LoanTypeName FROM LoanTypeMaster WHERE LoanTypeStatus='Active' ORDER BY LoanTypeName; SELECT FeeName FROM GroupLoanFeeMaster WITH(nolock) WHERE FeeStatus='Active' ORDER BY FeeName; SELECT LedgerId, LedgerName FROM AccountLedgerMaster WHERE LedgerId=(SELECT AccountHeadId FROM AccountHeadIdMaster WHERE AccountHeadStatus='Active' AND AccountHeadType='GoodsAndServiceTax')OR LedgerHead=(SELECT AccountHeadId FROM AccountHeadIdMaster WHERE AccountHeadStatus='Active' AND AccountHeadType='GoodsAndServiceTax') ORDER BY LedgerName; SELECT LedgerId, LedgerName FROM AccountLedgerMaster WHERE LedgerId=(SELECT AccountHeadId FROM AccountHeadIdMaster WHERE AccountHeadStatus='Active' AND AccountHeadType='GroupLoanHead')OR LedgerHead=(SELECT AccountHeadId FROM AccountHeadIdMaster WHERE AccountHeadStatus='Active' AND AccountHeadType='GroupLoanHead') ORDER BY LedgerName; SELECT LedgerId, LedgerName FROM AccountLedgerMaster WHERE LedgerId=(SELECT AccountHeadId FROM AccountHeadIdMaster WHERE AccountHeadStatus='Active' AND AccountHeadType='GroupLoanInterest')OR LedgerHead=(SELECT AccountHeadId FROM AccountHeadIdMaster WHERE AccountHeadStatus='Active' AND AccountHeadType='GroupLoanInterest') ORDER BY LedgerName; SELECT LedgerId, LedgerName FROM AccountLedgerMaster WHERE LedgerId=(SELECT AccountHeadId FROM AccountHeadIdMaster WHERE AccountHeadStatus='Active' AND AccountHeadType='GroupLoanFee')OR LedgerHead=(SELECT AccountHeadId FROM AccountHeadIdMaster WHERE AccountHeadStatus='Active' AND AccountHeadType='GroupLoanFee') ORDER BY LedgerName; SELECT LedgerId, LedgerName FROM AccountLedgerMaster WHERE LedgerId IN(SELECT AccountHeadId FROM AccountHeadIdMaster WHERE AccountHeadStatus='Active' AND AccountHeadType IN ('GroupLoanHead','GroupLoanFee','GroupLoanPayable') )OR LedgerHead IN (SELECT AccountHeadId FROM AccountHeadIdMaster WHERE AccountHeadStatus='Active' AND AccountHeadType IN ('GroupLoanHead','GroupLoanFee','GroupLoanPayable') ) ORDER BY LedgerName; String sql: Data: System.Collections.ListDictionaryInternal HelpLink: InnerException: Message: Invalid object name 'LoanTypeMaster'. 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(DataSet dataSet, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior) at System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, String srcTable) at ClassMaster.DataSetResult(String query) TargetSite: Void OnError(System.Data.SqlClient.SqlException, Boolean, System.Action`1[System.Action]) Time: 10/11/2025 02:08:25 PM PageName: DataTableResult String str: SELECT GLoanTypeId, LoanGroup, GroupLoanType, GLoanTypeNo, GLoanTypeName, GLoanNoPrefix, TermMode, MinimumTerm, MultipleTerm, MaximumTerm, NoPayingTerm, MinimumAmount, MultipleAmount, MaximumAmount, InterestMethod, InterestType, InterestRateMinimum, InterestRateAnnual, InterestRateMaximum, GracePeriod, PenaltyRateAnnual, FirstEMIPayment, EMIAmount, EMIAmountType, FirstInstallmentType, AccountHeadLoanId, AccountHeadLoanName, AccountHeadInterestId, AccountHeadInterestName, AccountHeadPenaltyId, AccountHeadPenaltyName, AccountHeadGSTId, AccountHeadGSTName, ProcessingIncludedInFee, ProcessingFee, ProcessingFeePercent, ProcessingFeeAmount, ProcessingGSTPercent, AccountHeadProcessingId, AccountHeadProcessingName, InsuranceIncludedInFee, InsuranceFee, InsuranceFeePercent, InsuranceFeeAmount, InsuranceGSTPercent, AccountHeadInsuranceId, AccountHeadInsuranceName, OtherChargeIncludedInFee, OtherCharge, OtherChargePercent, OtherChargeAmount, OtherChargeGSTPercent, AccountHeadOtherChargeId, AccountHeadOtherChargeName, SecurityIncludedInFee, SecurityFee, SecurityFeePercent, SecurityFeeAmount, AccountHeadSecurityId, AccountHeadSecurityName, FDIncludedInFee, FDAmount, FDAmountPercent, FDAmountAmount, AccountHeadFDAmountId, AccountHeadFDAmountName, RDIncludedInFee, RDAmount, RDAmountPercent, RDAmountAmount, AccountHeadRDAmountId, AccountHeadRDAmountName, DownPaymentIncludedInFee, DownPayment, DownPaymentPercent, DownPaymentAmount, AccountHeadDownPaymentId, AccountHeadDownPaymentName, LoanTypeStatus, LoanTypeRemark, EntryUser, rtrim(Convert(char,EntryTime,106))+' - '+rtrim(Convert(char,EntryTime,108))AS EntryTime FROM GroupLoanNoMaster WITH(nolock) WHERE 1=1 AND TermMode='Weekly' AND LoanGroup='Group' AND LoanTypeStatus='Active' ORDER BY LoanTypeStatus, LoanGroup, GroupLoanType, GLoanTypeNo ; String sql: Data: System.Collections.ListDictionaryInternal HelpLink: InnerException: Message: Invalid column name 'ProcessingIncludedInFee'. Invalid column name 'InsuranceIncludedInFee'. Invalid column name 'OtherChargeIncludedInFee'. Invalid column name 'SecurityIncludedInFee'. Invalid column name 'FDIncludedInFee'. Invalid column name 'RDIncludedInFee'. Invalid column name 'DownPaymentIncludedInFee'. 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: 10/11/2025 02:08:25 PM PageName: GroupLoan_GroupLoanNoMasterUpdation String str: SELECT GLoanTypeId, LoanGroup, GroupLoanType, GLoanTypeNo, GLoanTypeName, GLoanNoPrefix, TermMode, MinimumTerm, MultipleTerm, MaximumTerm, NoPayingTerm, MinimumAmount, MultipleAmount, MaximumAmount, InterestMethod, InterestType, InterestRateMinimum, InterestRateAnnual, InterestRateMaximum, GracePeriod, PenaltyRateAnnual, FirstEMIPayment, EMIAmount, EMIAmountType, FirstInstallmentType, AccountHeadLoanId, AccountHeadLoanName, AccountHeadInterestId, AccountHeadInterestName, AccountHeadPenaltyId, AccountHeadPenaltyName, AccountHeadGSTId, AccountHeadGSTName, ProcessingIncludedInFee, ProcessingFee, ProcessingFeePercent, ProcessingFeeAmount, ProcessingGSTPercent, AccountHeadProcessingId, AccountHeadProcessingName, InsuranceIncludedInFee, InsuranceFee, InsuranceFeePercent, InsuranceFeeAmount, InsuranceGSTPercent, AccountHeadInsuranceId, AccountHeadInsuranceName, OtherChargeIncludedInFee, OtherCharge, OtherChargePercent, OtherChargeAmount, OtherChargeGSTPercent, AccountHeadOtherChargeId, AccountHeadOtherChargeName, SecurityIncludedInFee, SecurityFee, SecurityFeePercent, SecurityFeeAmount, AccountHeadSecurityId, AccountHeadSecurityName, FDIncludedInFee, FDAmount, FDAmountPercent, FDAmountAmount, AccountHeadFDAmountId, AccountHeadFDAmountName, RDIncludedInFee, RDAmount, RDAmountPercent, RDAmountAmount, AccountHeadRDAmountId, AccountHeadRDAmountName, DownPaymentIncludedInFee, DownPayment, DownPaymentPercent, DownPaymentAmount, AccountHeadDownPaymentId, AccountHeadDownPaymentName, LoanTypeStatus, LoanTypeRemark, EntryUser, rtrim(Convert(char,EntryTime,106))+' - '+rtrim(Convert(char,EntryTime,108))AS EntryTime FROM GroupLoanNoMaster WITH(nolock) WHERE 1=1 AND TermMode='Weekly' AND LoanGroup='Group' AND LoanTypeStatus='Active' ORDER BY LoanTypeStatus, LoanGroup, GroupLoanType, GLoanTypeNo ; String sql: Data: System.Collections.ListDictionaryInternal HelpLink: InnerException: Message: Object reference not set to an instance of an object. Source: App_Web_k5hasjlv StackTrace: at GroupLoan_GroupLoanNoMasterUpdation.FillData() TargetSite: Void FillData() Time: 10/11/2025 02:24:25 PM PageName: GroupLoan_GroupLoanRepaymentSingle String str: 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_GroupLoanRepaymentSingle.Validation() TargetSite: Void StringToNumber(System.String, System.Globalization.NumberStyles, NumberBuffer ByRef, System.Globalization.NumberFormatInfo, Boolean) Time: 10/11/2025 02:49:24 PM PageName: GroupLoan_GroupLoanNoMasterList 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 GroupLoan_GroupLoanNoMasterList.ExportToExcel(DataTable DT, String fileName) TargetSite: Void AbortInternal() Time: 10/11/2025 02:49:24 PM PageName: GroupLoan_GroupLoanNoMasterList String str: String sql: Data: System.Collections.ListDictionaryInternal HelpLink: InnerException: Message: Thread was being aborted. Source: App_Web_1jokebd4 StackTrace: at GroupLoan_GroupLoanNoMasterList.ExportToExcel(DataTable DT, String fileName) at GroupLoan_GroupLoanNoMasterList.btnExcel_Click(Object sender, EventArgs e) TargetSite: Void ExportToExcel(System.Data.DataTable, System.String) Time: 10/11/2025 02:49:37 PM PageName: GroupLoan_GroupLoanNoMasterList 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 GroupLoan_GroupLoanNoMasterList.btnExport_Click(Object sender, EventArgs e) TargetSite: Void AbortInternal() Time: 10/11/2025 02:52:20 PM PageName: GroupLoan_GroupLoanApplicationVerification String str: String sql: Data: System.Collections.ListDictionaryInternal HelpLink: InnerException: Message: Value was either too large or too small for an Int32. Source: mscorlib StackTrace: at System.Convert.ToInt32(Double value) at GroupLoan_GroupLoanApplicationVerification.txtLoanAmount_SelectedIndexChanged(Object sender, EventArgs e) TargetSite: Int32 ToInt32(Double) Time: 10/11/2025 03:01:15 PM PageName: GroupLoan_GroupLoanNoMasterList String str: String sql: Data: System.Collections.ListDictionaryInternal HelpLink: InnerException: Message: Object reference not set to an instance of an object. Source: App_Web_1jokebd4 StackTrace: at GroupLoan_GroupLoanNoMasterList.btnExport_Click(Object sender, EventArgs e) TargetSite: Void btnExport_Click(System.Object, System.EventArgs) Time: 10/11/2025 03:02:32 PM PageName: GroupLoan_GroupLoanNoMasterList 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 GroupLoan_GroupLoanNoMasterList.btnExport_Click(Object sender, EventArgs e) TargetSite: Void AbortInternal() Time: 10/11/2025 04:15:19 PM PageName: GroupLoan_GroupMemberCibilVerificationList 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 GroupLoan_GroupMemberCibilVerificationList.ExportToExcel(DataTable DT, String fileName) TargetSite: Void AbortInternal() Time: 10/11/2025 04:15:19 PM PageName: GroupLoan_GroupMemberCibilVerificationList String str: String sql: Data: System.Collections.ListDictionaryInternal HelpLink: InnerException: Message: Thread was being aborted. Source: App_Web_t0g0khha StackTrace: at GroupLoan_GroupMemberCibilVerificationList.ExportToExcel(DataTable DT, String fileName) at GroupLoan_GroupMemberCibilVerificationList.btnExcel_Click(Object sender, EventArgs e) TargetSite: Void ExportToExcel(System.Data.DataTable, System.String) Time: 10/11/2025 05:21:07 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.End() at System.Web.HttpResponse.Redirect(String url, Boolean endResponse, Boolean permanent) at AdminLogOut.btnLogout_Click(Object sender, EventArgs e) TargetSite: Void AbortInternal() Time: 10/11/2025 05:29:31 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.End() at System.Web.HttpResponse.Redirect(String url, Boolean endResponse, Boolean permanent) at AdminLogOut.btnLogout_Click(Object sender, EventArgs e) TargetSite: Void AbortInternal() Time: 10/11/2025 05:30:06 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.End() at System.Web.HttpResponse.Redirect(String url, Boolean endResponse, Boolean permanent) at AdminLogOut.btnLogout_Click(Object sender, EventArgs e) TargetSite: Void AbortInternal() Time: 10/11/2025 05:36:42 PM PageName: AdminEXELoginURL String str: SELECT ( SELECT ReportValue FROM ProjectReportSetting WITH(nolock) WHERE ReportName='CompanyURL' )AS CompanyURL, (SELECT ReportValue FROM ProjectReportSetting WITH(nolock) WHERE ReportName='MobileAppURL')AS MobileAppURL, (SELECT convert(int,DataValue) FROM ProjectDataSetting WITH(nolock) WHERE DataName='UserLoginTokenAge')AS UserLoginTokenAge, tt.UserLoginId, tt.UserName, tt.UserLoginStatus, tt.UserWebLogin, tt.UserRole, tt.AdminControl, tt.UserLocation, tt.TokenValue, tt.TokenAge, tt.UserBranch, tt.UserImage, tb.TableName, Convert(CHAR,tt.UserWorkingDate,103)AS UserWorkingDate, Convert(CHAR,tb.FromDate,103)AS FromDate, Convert(CHAR,tb.ToDate,103)AS ToDate FROM ( SELECT a.UserLoginId, a.UserName, a.UserRole, isnull(a.UserLoginStatus,'InActive')AS UserLoginStatus, isnull(a.UserWebLogin,'InActive')AS UserWebLogin, isnull(a.AdminControl,'InActive')AS AdminControl, isnull(a.UserLocation,'InActive')AS UserLocation, a.BranchId AS UserBranch, a.TokenValue, datediff(minute, a.TokenTime, GETDATE())AS TokenAge, (SELECT ReportValue FROM ProjectReportSetting WITH(nolock) WHERE ReportName='CompanyURL')+'UploadedDocs/UserLoginPhoto/'+CASE WHEN len(a.UserImage)>5 THEN a.UserImage ELSE 'CompanyLogo.png' END AS UserImage, CASE WHEN rtrim(convert(CHAR,a.UserLoginDate,106))=rtrim(convert(CHAR,GETDATE(),106)) THEN isnull(a.UserWorkingDate,GETDATE()) ELSE GETDATE() END AS UserWorkingDate FROM UserLoginDetail a with(nolock) WHERE 1=1 AND a.UserLoginId='swf00009' )tt LEFT JOIN FinancialYearMaster tb WITH(nolock) ON tt.UserWorkingDate>=tb.FromDate AND tt.UserWorkingDate5 THEN a.UserImage ELSE 'CompanyLogo.png' END AS UserImage, CASE WHEN rtrim(convert(CHAR,a.UserLoginDate,106))=rtrim(convert(CHAR,GETDATE(),106)) THEN isnull(a.UserWorkingDate,GETDATE()) ELSE GETDATE() END AS UserWorkingDate FROM UserLoginDetail a with(nolock) WHERE 1=1 AND a.UserLoginId='swf00009' )tt LEFT JOIN FinancialYearMaster tb WITH(nolock) ON tt.UserWorkingDate>=tb.FromDate AND tt.UserWorkingDate5 THEN a.UserImage ELSE 'CompanyLogo.png' END AS UserImage, CASE WHEN rtrim(convert(CHAR,a.UserLoginDate,106))=rtrim(convert(CHAR,GETDATE(),106)) THEN isnull(a.UserWorkingDate,GETDATE()) ELSE GETDATE() END AS UserWorkingDate FROM UserLoginDetail a with(nolock) WHERE 1=1 AND a.UserLoginId='swf00009' )tt LEFT JOIN FinancialYearMaster tb WITH(nolock) ON tt.UserWorkingDate>=tb.FromDate AND tt.UserWorkingDate5 THEN a.UserImage ELSE 'CompanyLogo.png' END AS UserImage, CASE WHEN rtrim(convert(CHAR,a.UserLoginDate,106))=rtrim(convert(CHAR,GETDATE(),106)) THEN isnull(a.UserWorkingDate,GETDATE()) ELSE GETDATE() END AS UserWorkingDate FROM UserLoginDetail a with(nolock) WHERE 1=1 AND a.UserLoginId='swf00009' )tt LEFT JOIN FinancialYearMaster tb WITH(nolock) ON tt.UserWorkingDate>=tb.FromDate AND tt.UserWorkingDate5 THEN a.UserImage ELSE 'CompanyLogo.png' END AS UserImage, CASE WHEN rtrim(convert(CHAR,a.UserLoginDate,106))=rtrim(convert(CHAR,GETDATE(),106)) THEN isnull(a.UserWorkingDate,GETDATE()) ELSE GETDATE() END AS UserWorkingDate FROM UserLoginDetail a with(nolock) WHERE 1=1 AND a.UserLoginId='swf00010' )tt LEFT JOIN FinancialYearMaster tb WITH(nolock) ON tt.UserWorkingDate>=tb.FromDate AND tt.UserWorkingDate5 THEN a.UserImage ELSE 'CompanyLogo.png' END AS UserImage, CASE WHEN rtrim(convert(CHAR,a.UserLoginDate,106))=rtrim(convert(CHAR,GETDATE(),106)) THEN isnull(a.UserWorkingDate,GETDATE()) ELSE GETDATE() END AS UserWorkingDate FROM UserLoginDetail a with(nolock) WHERE 1=1 AND a.UserLoginId='swf00009' )tt LEFT JOIN FinancialYearMaster tb WITH(nolock) ON tt.UserWorkingDate>=tb.FromDate AND tt.UserWorkingDate5 THEN a.UserImage ELSE 'CompanyLogo.png' END AS UserImage, CASE WHEN rtrim(convert(CHAR,a.UserLoginDate,106))=rtrim(convert(CHAR,GETDATE(),106)) THEN isnull(a.UserWorkingDate,GETDATE()) ELSE GETDATE() END AS UserWorkingDate FROM UserLoginDetail a with(nolock) WHERE 1=1 AND a.UserLoginId='SWF00009' )tt LEFT JOIN FinancialYearMaster tb WITH(nolock) ON tt.UserWorkingDate>=tb.FromDate AND tt.UserWorkingDate5 THEN a.UserImage ELSE 'CompanyLogo.png' END AS UserImage, CASE WHEN rtrim(convert(CHAR,a.UserLoginDate,106))=rtrim(convert(CHAR,GETDATE(),106)) THEN isnull(a.UserWorkingDate,GETDATE()) ELSE GETDATE() END AS UserWorkingDate FROM UserLoginDetail a with(nolock) WHERE 1=1 AND a.UserLoginId='swf00009' )tt LEFT JOIN FinancialYearMaster tb WITH(nolock) ON tt.UserWorkingDate>=tb.FromDate AND tt.UserWorkingDate5 THEN a.UserImage ELSE 'CompanyLogo.png' END AS UserImage, CASE WHEN rtrim(convert(CHAR,a.UserLoginDate,106))=rtrim(convert(CHAR,GETDATE(),106)) THEN isnull(a.UserWorkingDate,GETDATE()) ELSE GETDATE() END AS UserWorkingDate FROM UserLoginDetail a with(nolock) WHERE 1=1 AND a.UserLoginId='swf00009' )tt LEFT JOIN FinancialYearMaster tb WITH(nolock) ON tt.UserWorkingDate>=tb.FromDate AND tt.UserWorkingDate5 THEN a.UserImage ELSE 'CompanyLogo.png' END AS UserImage, CASE WHEN rtrim(convert(CHAR,a.UserLoginDate,106))=rtrim(convert(CHAR,GETDATE(),106)) THEN isnull(a.UserWorkingDate,GETDATE()) ELSE GETDATE() END AS UserWorkingDate FROM UserLoginDetail a with(nolock) WHERE 1=1 AND a.UserLoginId='swf00009' )tt LEFT JOIN FinancialYearMaster tb WITH(nolock) ON tt.UserWorkingDate>=tb.FromDate AND tt.UserWorkingDate5 THEN a.UserImage ELSE 'CompanyLogo.png' END AS UserImage, CASE WHEN rtrim(convert(CHAR,a.UserLoginDate,106))=rtrim(convert(CHAR,GETDATE(),106)) THEN isnull(a.UserWorkingDate,GETDATE()) ELSE GETDATE() END AS UserWorkingDate FROM UserLoginDetail a with(nolock) WHERE 1=1 AND a.UserLoginId='swf00009' )tt LEFT JOIN FinancialYearMaster tb WITH(nolock) ON tt.UserWorkingDate>=tb.FromDate AND tt.UserWorkingDate5 THEN a.UserImage ELSE 'CompanyLogo.png' END AS UserImage, CASE WHEN rtrim(convert(CHAR,a.UserLoginDate,106))=rtrim(convert(CHAR,GETDATE(),106)) THEN isnull(a.UserWorkingDate,GETDATE()) ELSE GETDATE() END AS UserWorkingDate FROM UserLoginDetail a with(nolock) WHERE 1=1 AND a.UserLoginId='swf00009' )tt LEFT JOIN FinancialYearMaster tb WITH(nolock) ON tt.UserWorkingDate>=tb.FromDate AND tt.UserWorkingDate5 THEN a.UserImage ELSE 'CompanyLogo.png' END AS UserImage, CASE WHEN rtrim(convert(CHAR,a.UserLoginDate,106))=rtrim(convert(CHAR,GETDATE(),106)) THEN isnull(a.UserWorkingDate,GETDATE()) ELSE GETDATE() END AS UserWorkingDate FROM UserLoginDetail a with(nolock) WHERE 1=1 AND a.UserLoginId='swf00009' )tt LEFT JOIN FinancialYearMaster tb WITH(nolock) ON tt.UserWorkingDate>=tb.FromDate AND tt.UserWorkingDate5 THEN a.UserImage ELSE 'CompanyLogo.png' END AS UserImage, CASE WHEN rtrim(convert(CHAR,a.UserLoginDate,106))=rtrim(convert(CHAR,GETDATE(),106)) THEN isnull(a.UserWorkingDate,GETDATE()) ELSE GETDATE() END AS UserWorkingDate FROM UserLoginDetail a with(nolock) WHERE 1=1 AND a.UserLoginId='swf00009' )tt LEFT JOIN FinancialYearMaster tb WITH(nolock) ON tt.UserWorkingDate>=tb.FromDate AND tt.UserWorkingDate5 THEN a.UserImage ELSE 'CompanyLogo.png' END AS UserImage, CASE WHEN rtrim(convert(CHAR,a.UserLoginDate,106))=rtrim(convert(CHAR,GETDATE(),106)) THEN isnull(a.UserWorkingDate,GETDATE()) ELSE GETDATE() END AS UserWorkingDate FROM UserLoginDetail a with(nolock) WHERE 1=1 AND a.UserLoginId='swf00009' )tt LEFT JOIN FinancialYearMaster tb WITH(nolock) ON tt.UserWorkingDate>=tb.FromDate AND tt.UserWorkingDate5 THEN a.UserImage ELSE 'CompanyLogo.png' END AS UserImage, CASE WHEN rtrim(convert(CHAR,a.UserLoginDate,106))=rtrim(convert(CHAR,GETDATE(),106)) THEN isnull(a.UserWorkingDate,GETDATE()) ELSE GETDATE() END AS UserWorkingDate FROM UserLoginDetail a with(nolock) WHERE 1=1 AND a.UserLoginId='swf00009' )tt LEFT JOIN FinancialYearMaster tb WITH(nolock) ON tt.UserWorkingDate>=tb.FromDate AND tt.UserWorkingDate5 THEN a.UserImage ELSE 'CompanyLogo.png' END AS UserImage, CASE WHEN rtrim(convert(CHAR,a.UserLoginDate,106))=rtrim(convert(CHAR,GETDATE(),106)) THEN isnull(a.UserWorkingDate,GETDATE()) ELSE GETDATE() END AS UserWorkingDate FROM UserLoginDetail a with(nolock) WHERE 1=1 AND a.UserLoginId='swf00009' )tt LEFT JOIN FinancialYearMaster tb WITH(nolock) ON tt.UserWorkingDate>=tb.FromDate AND tt.UserWorkingDate5 THEN a.UserImage ELSE 'CompanyLogo.png' END AS UserImage, CASE WHEN rtrim(convert(CHAR,a.UserLoginDate,106))=rtrim(convert(CHAR,GETDATE(),106)) THEN isnull(a.UserWorkingDate,GETDATE()) ELSE GETDATE() END AS UserWorkingDate FROM UserLoginDetail a with(nolock) WHERE 1=1 AND a.UserLoginId='swf00009' )tt LEFT JOIN FinancialYearMaster tb WITH(nolock) ON tt.UserWorkingDate>=tb.FromDate AND tt.UserWorkingDate5 THEN a.UserImage ELSE 'CompanyLogo.png' END AS UserImage, CASE WHEN rtrim(convert(CHAR,a.UserLoginDate,106))=rtrim(convert(CHAR,GETDATE(),106)) THEN isnull(a.UserWorkingDate,GETDATE()) ELSE GETDATE() END AS UserWorkingDate FROM UserLoginDetail a with(nolock) WHERE 1=1 AND a.UserLoginId='swf00009' )tt LEFT JOIN FinancialYearMaster tb WITH(nolock) ON tt.UserWorkingDate>=tb.FromDate AND tt.UserWorkingDate5 THEN a.UserImage ELSE 'CompanyLogo.png' END AS UserImage, CASE WHEN rtrim(convert(CHAR,a.UserLoginDate,106))=rtrim(convert(CHAR,GETDATE(),106)) THEN isnull(a.UserWorkingDate,GETDATE()) ELSE GETDATE() END AS UserWorkingDate FROM UserLoginDetail a with(nolock) WHERE 1=1 AND a.UserLoginId='swf00009' )tt LEFT JOIN FinancialYearMaster tb WITH(nolock) ON tt.UserWorkingDate>=tb.FromDate AND tt.UserWorkingDate5 THEN a.UserImage ELSE 'CompanyLogo.png' END AS UserImage, CASE WHEN rtrim(convert(CHAR,a.UserLoginDate,106))=rtrim(convert(CHAR,GETDATE(),106)) THEN isnull(a.UserWorkingDate,GETDATE()) ELSE GETDATE() END AS UserWorkingDate FROM UserLoginDetail a with(nolock) WHERE 1=1 AND a.UserLoginId='swf00009' )tt LEFT JOIN FinancialYearMaster tb WITH(nolock) ON tt.UserWorkingDate>=tb.FromDate AND tt.UserWorkingDate5 THEN a.UserImage ELSE 'CompanyLogo.png' END AS UserImage, CASE WHEN rtrim(convert(CHAR,a.UserLoginDate,106))=rtrim(convert(CHAR,GETDATE(),106)) THEN isnull(a.UserWorkingDate,GETDATE()) ELSE GETDATE() END AS UserWorkingDate FROM UserLoginDetail a with(nolock) WHERE 1=1 AND a.UserLoginId='swf00009' )tt LEFT JOIN FinancialYearMaster tb WITH(nolock) ON tt.UserWorkingDate>=tb.FromDate AND tt.UserWorkingDate5 THEN a.UserImage ELSE 'CompanyLogo.png' END AS UserImage, CASE WHEN rtrim(convert(CHAR,a.UserLoginDate,106))=rtrim(convert(CHAR,GETDATE(),106)) THEN isnull(a.UserWorkingDate,GETDATE()) ELSE GETDATE() END AS UserWorkingDate FROM UserLoginDetail a with(nolock) WHERE 1=1 AND a.UserLoginId='swf00009' )tt LEFT JOIN FinancialYearMaster tb WITH(nolock) ON tt.UserWorkingDate>=tb.FromDate AND tt.UserWorkingDate5 THEN a.UserImage ELSE 'CompanyLogo.png' END AS UserImage, CASE WHEN rtrim(convert(CHAR,a.UserLoginDate,106))=rtrim(convert(CHAR,GETDATE(),106)) THEN isnull(a.UserWorkingDate,GETDATE()) ELSE GETDATE() END AS UserWorkingDate FROM UserLoginDetail a with(nolock) WHERE 1=1 AND a.UserLoginId='swf00009' )tt LEFT JOIN FinancialYearMaster tb WITH(nolock) ON tt.UserWorkingDate>=tb.FromDate AND tt.UserWorkingDate5 THEN a.UserImage ELSE 'CompanyLogo.png' END AS UserImage, CASE WHEN rtrim(convert(CHAR,a.UserLoginDate,106))=rtrim(convert(CHAR,GETDATE(),106)) THEN isnull(a.UserWorkingDate,GETDATE()) ELSE GETDATE() END AS UserWorkingDate FROM UserLoginDetail a with(nolock) WHERE 1=1 AND a.UserLoginId='swf00009' )tt LEFT JOIN FinancialYearMaster tb WITH(nolock) ON tt.UserWorkingDate>=tb.FromDate AND tt.UserWorkingDate5 THEN a.UserImage ELSE 'CompanyLogo.png' END AS UserImage, CASE WHEN rtrim(convert(CHAR,a.UserLoginDate,106))=rtrim(convert(CHAR,GETDATE(),106)) THEN isnull(a.UserWorkingDate,GETDATE()) ELSE GETDATE() END AS UserWorkingDate FROM UserLoginDetail a with(nolock) WHERE 1=1 AND a.UserLoginId='swf00009' )tt LEFT JOIN FinancialYearMaster tb WITH(nolock) ON tt.UserWorkingDate>=tb.FromDate AND tt.UserWorkingDate5 THEN a.UserImage ELSE 'CompanyLogo.png' END AS UserImage, CASE WHEN rtrim(convert(CHAR,a.UserLoginDate,106))=rtrim(convert(CHAR,GETDATE(),106)) THEN isnull(a.UserWorkingDate,GETDATE()) ELSE GETDATE() END AS UserWorkingDate FROM UserLoginDetail a with(nolock) WHERE 1=1 AND a.UserLoginId='swf00009' )tt LEFT JOIN FinancialYearMaster tb WITH(nolock) ON tt.UserWorkingDate>=tb.FromDate AND tt.UserWorkingDate5 THEN a.UserImage ELSE 'CompanyLogo.png' END AS UserImage, CASE WHEN rtrim(convert(CHAR,a.UserLoginDate,106))=rtrim(convert(CHAR,GETDATE(),106)) THEN isnull(a.UserWorkingDate,GETDATE()) ELSE GETDATE() END AS UserWorkingDate FROM UserLoginDetail a with(nolock) WHERE 1=1 AND a.UserLoginId='SWF00008' )tt LEFT JOIN FinancialYearMaster tb WITH(nolock) ON tt.UserWorkingDate>=tb.FromDate AND tt.UserWorkingDate5 THEN a.UserImage ELSE 'CompanyLogo.png' END AS UserImage, CASE WHEN rtrim(convert(CHAR,a.UserLoginDate,106))=rtrim(convert(CHAR,GETDATE(),106)) THEN isnull(a.UserWorkingDate,GETDATE()) ELSE GETDATE() END AS UserWorkingDate FROM UserLoginDetail a with(nolock) WHERE 1=1 AND a.UserLoginId='swf00009' )tt LEFT JOIN FinancialYearMaster tb WITH(nolock) ON tt.UserWorkingDate>=tb.FromDate AND tt.UserWorkingDate5 THEN a.UserImage ELSE 'CompanyLogo.png' END AS UserImage, CASE WHEN rtrim(convert(CHAR,a.UserLoginDate,106))=rtrim(convert(CHAR,GETDATE(),106)) THEN isnull(a.UserWorkingDate,GETDATE()) ELSE GETDATE() END AS UserWorkingDate FROM UserLoginDetail a with(nolock) WHERE 1=1 AND a.UserLoginId='SWF00009' )tt LEFT JOIN FinancialYearMaster tb WITH(nolock) ON tt.UserWorkingDate>=tb.FromDate AND tt.UserWorkingDate5 THEN a.UserImage ELSE 'CompanyLogo.png' END AS UserImage, CASE WHEN rtrim(convert(CHAR,a.UserLoginDate,106))=rtrim(convert(CHAR,GETDATE(),106)) THEN isnull(a.UserWorkingDate,GETDATE()) ELSE GETDATE() END AS UserWorkingDate FROM UserLoginDetail a with(nolock) WHERE 1=1 AND a.UserLoginId='SWF00009' )tt LEFT JOIN FinancialYearMaster tb WITH(nolock) ON tt.UserWorkingDate>=tb.FromDate AND tt.UserWorkingDate5 THEN a.UserImage ELSE 'CompanyLogo.png' END AS UserImage, CASE WHEN rtrim(convert(CHAR,a.UserLoginDate,106))=rtrim(convert(CHAR,GETDATE(),106)) THEN isnull(a.UserWorkingDate,GETDATE()) ELSE GETDATE() END AS UserWorkingDate FROM UserLoginDetail a with(nolock) WHERE 1=1 AND a.UserLoginId='SWF00009' )tt LEFT JOIN FinancialYearMaster tb WITH(nolock) ON tt.UserWorkingDate>=tb.FromDate AND tt.UserWorkingDate5 THEN a.UserImage ELSE 'CompanyLogo.png' END AS UserImage, CASE WHEN rtrim(convert(CHAR,a.UserLoginDate,106))=rtrim(convert(CHAR,GETDATE(),106)) THEN isnull(a.UserWorkingDate,GETDATE()) ELSE GETDATE() END AS UserWorkingDate FROM UserLoginDetail a with(nolock) WHERE 1=1 AND a.UserLoginId='SWF00008' )tt LEFT JOIN FinancialYearMaster tb WITH(nolock) ON tt.UserWorkingDate>=tb.FromDate AND tt.UserWorkingDate5 THEN a.UserImage ELSE 'CompanyLogo.png' END AS UserImage, CASE WHEN rtrim(convert(CHAR,a.UserLoginDate,106))=rtrim(convert(CHAR,GETDATE(),106)) THEN isnull(a.UserWorkingDate,GETDATE()) ELSE GETDATE() END AS UserWorkingDate FROM UserLoginDetail a with(nolock) WHERE 1=1 AND a.UserLoginId='SWF00008' )tt LEFT JOIN FinancialYearMaster tb WITH(nolock) ON tt.UserWorkingDate>=tb.FromDate AND tt.UserWorkingDate0 ; UPDATE ta SET ta.MeetingDay=(SELECT MeetingDay FROM GroupCenterMaster WITH(nolock) WHERE CenterId=ta.CenterId) FROM @FTable ta; UPDATE ta SET ta.MeetingTime=(SELECT MeetingTime FROM GroupCenterMaster WITH(nolock) WHERE CenterId=ta.CenterId) FROM @FTable ta; UPDATE ta SET ta.GuardianName=(SELECT MemberGuardianName FROM GroupLoanMemberDetail WITH(nolock) WHERE MemberId=ta.MemberId) FROM @FTable ta; UPDATE ta SET ta.ContactNo=(SELECT NomineeMobileNo FROM GroupLoanMemberDetail WITH(nolock) WHERE MemberId=ta.MemberId) FROM @FTable ta; UPDATE ta SET ta.MobileNo=(SELECT MemberMobileNo FROM GroupLoanMemberDetail WITH(nolock) WHERE MemberId=ta.MemberId) FROM @FTable ta; UPDATE ta SET ta.DueDate=(SELECT rtrim(Convert(CHAR,MIN(DDate),103)) FROM @TTable WHERE LoanId=ta.LoanId AND PStatus='Due') FROM @FTable ta; UPDATE ta SET ta.DueNo=(SELECT MIN(DNo) FROM @TTable WHERE LoanId=ta.LoanId AND PStatus='Due') FROM @FTable ta; UPDATE ta SET ta.LastPaidDate=(SELECT rtrim(Convert(char,MAX(PDate),103)) FROM @TTable WHERE LoanId=ta.LoanId AND PStatus='Paid') FROM @FTable ta; UPDATE ta SET ta.ODAmount=(SELECT SUM(Total) FROM @TTable WHERE LoanId=ta.LoanId AND PStatus='Due' AND DDate<@ODate) FROM @FTable ta; UPDATE ta SET ta.DueAmount=(SELECT SUM(Total) FROM @TTable WHERE LoanId=ta.LoanId AND PStatus='Due' AND DDate=@ODate) FROM @FTable ta; UPDATE ta SET ta.BalanceAmount=(SELECT SUM(Total) FROM @TTable WHERE LoanId=ta.LoanId AND PStatus='Due') FROM @FTable ta; SELECT replace(a.OnDate,' ','-')AS C0, a.BranchName AS C1, a.LoanOfficerId AS C2, a.LoanOfficerName AS C3, a.CenterId AS C4, a.CenterName AS C5, a.MemberId AS C6, a.MemberName AS C7, a.GuardianName AS C8, a.MobileNo AS C9, a.ContactNo AS C10, a.LoanId AS C11, replace(a.DueDate,'/20','/')AS C12, a.DueNo AS C13, replace(isnull(a.ODAmount,0.00),'.00','')AS C14, replace(isnull(a.DueAmount,0),'.00','')AS C15, replace(a.BalanceAmount,'.00','') AS C16, CASE WHEN isnull(a.MeetingAmount,0)>0 THEN 0 ELSE isnull(a.ODAmount,0)+isnull(a.DueAmount,0) END AS C17, isnull(a.MeetingAmount,0)AS C18, replace(a.EMIAmount,'.00','') AS C19, replace(a.LoanAmount,'.00','')AS C20, replace(a.LastPaidDate,'/20','/')AS C21, replace(a.DisburseDate,'/20','/')AS C22, a.LoanTerm AS C23, a.MeetingTime AS C24, (SELECT CompanyName FROM ProjectReportSettingMaster WITH(nolock) WHERE 1=1)AS C99, (SELECT CompanyDetail1 FROM ProjectReportSettingMaster WITH(nolock) WHERE 1=1)AS C98, (SELECT CompanyDetail2 FROM ProjectReportSettingMaster WITH(nolock) WHERE 1=1)AS C97, (SELECT CompanyDetail3 FROM ProjectReportSettingMaster WITH(nolock) WHERE 1=1)AS C96, (SELECT GroupLoanDemandSheetRDLC FROM ProjectReportSettingMaster WITH(nolock) WHERE 1=1)AS C95 FROM @FTable a WHERE 1=1 AND isnull(a.BalanceAmount,0)>0 ORDER BY a.BranchName, a.LoanOfficerName, a.CenterName, a.MemberName String sql: Data: System.Collections.ListDictionaryInternal HelpLink: InnerException: Microsoft.Reporting.DefinitionInvalidException: The definition of the report 'Main Report' is invalid. ---> Microsoft.ReportingServices.ReportProcessing.ReportProcessingException: The report definition is not valid. Details: The report definition has an invalid target namespace 'http://schemas.microsoft.com/sqlserver/reporting/2008/01/reportdefinition' which cannot be upgraded. Message: An error occurred during local report processing. Source: Microsoft.ReportViewer.WebForms StackTrace: at Microsoft.Reporting.WebForms.LocalReport.CompileReport() at Microsoft.Reporting.WebForms.LocalReport.InternalRender(String format, Boolean allowInternalRenderers, String deviceInfo, CreateAndRegisterStream createStreamCallback, Warning[]& warnings) at Microsoft.Reporting.WebForms.LocalReport.InternalRender(String format, Boolean allowInternalRenderers, String deviceInfo, String& mimeType, String& encoding, String& fileNameExtension, String[]& streams, Warning[]& warnings) at Microsoft.Reporting.WebForms.LocalReport.Render(String format, String deviceInfo, String& mimeType, String& encoding, String& fileNameExtension, String[]& streams, Warning[]& warnings) at GroupLoan_PrintRDLCPage.GroupLoanDemandSheet() TargetSite: Void CompileReport() Time: 18/11/2025 09:32:53 AM PageName: GroupLoan_GroupLoanNEFTReport 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 GroupLoan_GroupLoanNEFTReport.ExportToExcel(DataTable DT, String fileName) TargetSite: Void AbortInternal() Time: 18/11/2025 09:32:53 AM PageName: GroupLoan_GroupLoanNEFTReport String str: String sql: Data: System.Collections.ListDictionaryInternal HelpLink: InnerException: Message: Thread was being aborted. Source: App_Web_kajqpxws StackTrace: at GroupLoan_GroupLoanNEFTReport.ExportToExcel(DataTable DT, String fileName) at GroupLoan_GroupLoanNEFTReport.btnExcel_Click(Object sender, EventArgs e) TargetSite: Void ExportToExcel(System.Data.DataTable, System.String) Time: 18/11/2025 09:33:06 AM PageName: GroupLoan_PrintRDLCPage String str: DECLARE @ODate DATE; SET @ODate='11/18/2025 12:00:00 AM'; DECLARE @FTable TABLE ( OnDate VARCHAR(20), BranchName VARCHAR(50), LoanOfficerId VARCHAR(20), LoanOfficerName VARCHAR(50), CenterId VARCHAR(20), CenterName VARCHAR(50), MeetingDay VARCHAR(20), MeetingTime VARCHAR(20), MemberId VARCHAR(20), MemberName VARCHAR(60), GuardianName VARCHAR(60), ContactNo varchar(20), MobileNo varchar(20), LoanId VARCHAR(50), LoanCycle VARCHAR(2), DisburseDate VARCHAR(20), LoanAmount DECIMAL(10,2), EMIAmount DECIMAL(10,2), DueDate VARCHAR(20), LoanTerm INT, DueNo INT, LastPaidDate varchar(20), MeetingAmount DECIMAL(10,2), ODAmount DECIMAL(10,2), DueAmount DECIMAL(10,2), BalanceAmount DECIMAL(10,2) ); DECLARE @CTable TABLE ( CenterId VARCHAR(20) ); INSERT INTO @CTable ( CenterId ) SELECT a.CenterId FROM GroupCenterMaster a WITH(nolock) WHERE a.MeetingDay=datename(dw,@ODate) AND a.BranchId='101' AND a.CenterOfficerId='SWF00009' AND a.CenterId='1010021' ; INSERT INTO @FTable ( OnDate, BranchName, LoanOfficerId, LoanOfficerName, CenterId, CenterName, MemberId, MemberName, LoanId, LoanCycle, DisburseDate, LoanAmount, LoanTerm, EMIAmount, MeetingAmount ) SELECT rtrim(Convert(char,@ODate,106))AS ODate, ld.BranchName, ld.LoanOfficerId, ld.LoanOfficerName, ld.CenterId, ld.CenterName, ld.MemberId, ld.MemberName, ld.LoanId, ld.LoanCycle, rtrim(convert(CHAR,ld.DisburseDate,103))AS DisburseDate, ld.LoanAmount, ld.LoanTerm, ld.EMIAmount, ld.CMEMI AS MeetingAmount FROM GroupLoanAccount ld WITH(nolock) INNER JOIN @CTable b ON ld.CenterId=b.CenterId WHERE ld.LoanStatus='LoanDisbursed'; DECLARE @TTable TABLE ( LoanId VARCHAR(50), DDate DATE, PDate DATE, DNo INT, Total DECIMAL(10,2), PStatus VARCHAR(10) ); INSERT INTO @TTable ( LoanId, DDate, PDate, DNo, Total, PStatus ) SELECT a.LoanId, a.DDate, a.PDate, a.DNo, 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.MeetingDay=(SELECT MeetingDay FROM GroupCenterMaster WITH(nolock) WHERE CenterId=ta.CenterId) FROM @FTable ta; UPDATE ta SET ta.MeetingTime=(SELECT MeetingTime FROM GroupCenterMaster WITH(nolock) WHERE CenterId=ta.CenterId) FROM @FTable ta; UPDATE ta SET ta.GuardianName=(SELECT MemberGuardianName FROM GroupLoanMemberDetail WITH(nolock) WHERE MemberId=ta.MemberId) FROM @FTable ta; UPDATE ta SET ta.ContactNo=(SELECT NomineeMobileNo FROM GroupLoanMemberDetail WITH(nolock) WHERE MemberId=ta.MemberId) FROM @FTable ta; UPDATE ta SET ta.MobileNo=(SELECT MemberMobileNo FROM GroupLoanMemberDetail WITH(nolock) WHERE MemberId=ta.MemberId) FROM @FTable ta; UPDATE ta SET ta.DueDate=(SELECT rtrim(Convert(CHAR,MIN(DDate),103)) FROM @TTable WHERE LoanId=ta.LoanId AND PStatus='Due') FROM @FTable ta; UPDATE ta SET ta.DueNo=(SELECT MIN(DNo) FROM @TTable WHERE LoanId=ta.LoanId AND PStatus='Due') FROM @FTable ta; UPDATE ta SET ta.LastPaidDate=(SELECT rtrim(Convert(char,MAX(PDate),103)) FROM @TTable WHERE LoanId=ta.LoanId AND PStatus='Paid') FROM @FTable ta; UPDATE ta SET ta.ODAmount=(SELECT SUM(Total) FROM @TTable WHERE LoanId=ta.LoanId AND PStatus='Due' AND DDate<@ODate) FROM @FTable ta; UPDATE ta SET ta.DueAmount=(SELECT SUM(Total) FROM @TTable WHERE LoanId=ta.LoanId AND PStatus='Due' AND DDate=@ODate) FROM @FTable ta; UPDATE ta SET ta.BalanceAmount=(SELECT SUM(Total) FROM @TTable WHERE LoanId=ta.LoanId AND PStatus='Due') FROM @FTable ta; SELECT replace(a.OnDate,' ','-')AS C0, a.BranchName AS C1, a.LoanOfficerId AS C2, a.LoanOfficerName AS C3, a.CenterId AS C4, a.CenterName AS C5, a.MemberId AS C6, a.MemberName AS C7, a.GuardianName AS C8, a.MobileNo AS C9, a.ContactNo AS C10, a.LoanId AS C11, replace(a.DueDate,'/20','/')AS C12, a.DueNo AS C13, replace(isnull(a.ODAmount,0.00),'.00','')AS C14, replace(isnull(a.DueAmount,0),'.00','')AS C15, replace(a.BalanceAmount,'.00','') AS C16, CASE WHEN isnull(a.MeetingAmount,0)>0 THEN 0 ELSE isnull(a.ODAmount,0)+isnull(a.DueAmount,0) END AS C17, isnull(a.MeetingAmount,0)AS C18, replace(a.EMIAmount,'.00','') AS C19, replace(a.LoanAmount,'.00','')AS C20, replace(a.LastPaidDate,'/20','/')AS C21, replace(a.DisburseDate,'/20','/')AS C22, a.LoanTerm AS C23, a.MeetingTime AS C24, (SELECT CompanyName FROM ProjectReportSettingMaster WITH(nolock) WHERE 1=1)AS C99, (SELECT CompanyDetail1 FROM ProjectReportSettingMaster WITH(nolock) WHERE 1=1)AS C98, (SELECT CompanyDetail2 FROM ProjectReportSettingMaster WITH(nolock) WHERE 1=1)AS C97, (SELECT CompanyDetail3 FROM ProjectReportSettingMaster WITH(nolock) WHERE 1=1)AS C96, (SELECT GroupLoanDemandSheetRDLC FROM ProjectReportSettingMaster WITH(nolock) WHERE 1=1)AS C95 FROM @FTable a WHERE 1=1 AND isnull(a.BalanceAmount,0)>0 ORDER BY a.BranchName, a.LoanOfficerName, a.CenterName, a.MemberName String sql: Data: System.Collections.ListDictionaryInternal HelpLink: InnerException: Microsoft.Reporting.DefinitionInvalidException: The definition of the report 'Main Report' is invalid. ---> Microsoft.ReportingServices.ReportProcessing.ReportProcessingException: The report definition is not valid. Details: The report definition has an invalid target namespace 'http://schemas.microsoft.com/sqlserver/reporting/2008/01/reportdefinition' which cannot be upgraded. Message: An error occurred during local report processing. Source: Microsoft.ReportViewer.WebForms StackTrace: at Microsoft.Reporting.WebForms.LocalReport.CompileReport() at Microsoft.Reporting.WebForms.LocalReport.InternalRender(String format, Boolean allowInternalRenderers, String deviceInfo, CreateAndRegisterStream createStreamCallback, Warning[]& warnings) at Microsoft.Reporting.WebForms.LocalReport.InternalRender(String format, Boolean allowInternalRenderers, String deviceInfo, String& mimeType, String& encoding, String& fileNameExtension, String[]& streams, Warning[]& warnings) at Microsoft.Reporting.WebForms.LocalReport.Render(String format, String deviceInfo, String& mimeType, String& encoding, String& fileNameExtension, String[]& streams, Warning[]& warnings) at GroupLoan_PrintRDLCPage.GroupLoanDemandSheet() TargetSite: Void CompileReport() Time: 18/11/2025 09:43:42 AM PageName: GroupLoan_GroupDemandCollectionReport 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 GroupLoan_GroupDemandCollectionReport.ExportToExcel(DataTable DT, String fileName) TargetSite: Void AbortInternal() Time: 18/11/2025 09:43:42 AM PageName: GroupLoan_GroupDemandCollectionReport String str: String sql: Data: System.Collections.ListDictionaryInternal HelpLink: InnerException: Message: Thread was being aborted. Source: App_Web_wcljl4oq StackTrace: at GroupLoan_GroupDemandCollectionReport.ExportToExcel(DataTable DT, String fileName) at GroupLoan_GroupDemandCollectionReport.btnExcel_Click(Object sender, EventArgs e) TargetSite: Void ExportToExcel(System.Data.DataTable, System.String) Time: 18/11/2025 10:00:09 AM PageName: GroupLoan_GroupLoanOutstandingReport 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 GroupLoan_GroupLoanOutstandingReport.ExportToExcel(DataTable DT, String fileName) TargetSite: Void AbortInternal() Time: 18/11/2025 10:00:09 AM PageName: GroupLoan_GroupLoanOutstandingReport String str: String sql: Data: System.Collections.ListDictionaryInternal HelpLink: InnerException: Message: Thread was being aborted. Source: App_Web_vsaec2xh StackTrace: at GroupLoan_GroupLoanOutstandingReport.ExportToExcel(DataTable DT, String fileName) at GroupLoan_GroupLoanOutstandingReport.btnExcel_Click(Object sender, EventArgs e) TargetSite: Void ExportToExcel(System.Data.DataTable, System.String) Time: 18/11/2025 10:16:18 AM PageName: GroupLoan_GroupLoanDemandReport String str: String sql: Data: System.Collections.ListDictionaryInternal HelpLink: InnerException: Message: Object reference not set to an instance of an object. Source: App_Web_dpfm1cse StackTrace: at GroupLoan_GroupLoanDemandReport.ExportToExcel(DataTable DT, String fileName) TargetSite: Void ExportToExcel(System.Data.DataTable, System.String) Time: 18/11/2025 10:19:27 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: 18/11/2025 10:25:13 AM PageName: GroupLoan_GroupDemandCollectionReport 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 GroupLoan_GroupDemandCollectionReport.ExportToExcel(DataTable DT, String fileName) TargetSite: Void AbortInternal() Time: 18/11/2025 10:25:13 AM PageName: GroupLoan_GroupDemandCollectionReport String str: String sql: Data: System.Collections.ListDictionaryInternal HelpLink: InnerException: Message: Thread was being aborted. Source: App_Web_wcljl4oq StackTrace: at GroupLoan_GroupDemandCollectionReport.ExportToExcel(DataTable DT, String fileName) at GroupLoan_GroupDemandCollectionReport.btnExcel_Click(Object sender, EventArgs e) TargetSite: Void ExportToExcel(System.Data.DataTable, System.String) Time: 18/11/2025 11:18:55 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: 18/11/2025 11:29:00 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: 18/11/2025 11:48:51 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: 18/11/2025 11:50:30 AM PageName: GroupLoan_GroupMemberCibilVerificationList 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 GroupLoan_GroupMemberCibilVerificationList.ExportToExcel(DataTable DT, String fileName) TargetSite: Void AbortInternal() Time: 18/11/2025 11:50:30 AM PageName: GroupLoan_GroupMemberCibilVerificationList String str: String sql: Data: System.Collections.ListDictionaryInternal HelpLink: InnerException: Message: Thread was being aborted. Source: App_Web_t0g0khha StackTrace: at GroupLoan_GroupMemberCibilVerificationList.ExportToExcel(DataTable DT, String fileName) at GroupLoan_GroupMemberCibilVerificationList.btnExcel_Click(Object sender, EventArgs e) TargetSite: Void ExportToExcel(System.Data.DataTable, System.String) Time: 18/11/2025 01:27:15 PM PageName: DataTableResult String str: DECLARE @Table TABLE ( MemberId VARCHAR(20), LoanId VARCHAR(50), LoanCycle TINYINT, LoanStatus VARCHAR(20) ); INSERT INTO @Table ( MemberId, LoanId, LoanCycle, LoanStatus ) SELECT MemberId, LoanId, LoanCycle, LoanStatus FROM GroupLoanAccount WITH(nolock) WHERE 1=1 AND LoanOfficerId='SWF00009' ORDER BY MemberId ; SELECT a.CenterId, a.CenterName, a.GroupName, Convert(CHAR,a.MemberJoinDate,106)AS MemberJoinDate, a.MemberId, a.MemberName, a.MemberGuardianName, a.MemberProfileStatus, a.GroupStatus, c1.LoanId AS LoanId1, c1.LoanId+'-'+c1.LoanStatus AS LoanStatus1, c2.LoanId AS LoanId2, c2.LoanId+'-'+c2.LoanStatus AS LoanStatus2, c3.LoanId AS LoanId3, c3.LoanId+'-'+c3.LoanStatus AS LoanStatus3, c4.LoanId AS LoanId4, c4.LoanId+'-'+c4.LoanStatus AS LoanStatus4, c5.LoanId AS LoanId5, c5.LoanId+'-'+c5.LoanStatus AS LoanStatus5, c6.LoanId AS LoanId6, c6.LoanId+'-'+c6.LoanStatus AS LoanStatus6, c7.LoanId AS LoanId7, c7.LoanId+'-'+c7.LoanStatus AS LoanStatus7, c8.LoanId AS LoanId8, c8.LoanId+'-'+c8.LoanStatus AS LoanStatus8, c9.LoanId AS LoanId9, c9.LoanId+'-'+c9.LoanStatus AS LoanStatus9 FROM GroupLoanMemberDetail a WITH(nolock) LEFT JOIN @Table c1 ON a.MemberId=c1.MemberId AND c1.LoanCycle=1 LEFT JOIN @Table c2 ON a.MemberId=c2.MemberId AND c2.LoanCycle=2 LEFT JOIN @Table c3 ON a.MemberId=c3.MemberId AND c3.LoanCycle=3 LEFT JOIN @Table c4 ON a.MemberId=c4.MemberId AND c4.LoanCycle=4 LEFT JOIN @Table c5 ON a.MemberId=c5.MemberId AND c5.LoanCycle=5 LEFT JOIN @Table c6 ON a.MemberId=c6.MemberId AND c6.LoanCycle=6 LEFT JOIN @Table c7 ON a.MemberId=c7.MemberId AND c7.LoanCycle=7 LEFT JOIN @Table c8 ON a.MemberId=c8.MemberId AND c8.LoanCycle=8 LEFT JOIN @Table c9 ON a.MemberId=c9.MemberId AND c9.LoanCycle=9 WHERE 1=1 AND a.GroupOfficerId='SWF00009' AND a.MemberJoinDate>='11/18/2025 12:00:00 AM' AND a.MemberJoinDate<'11/19/2025 12:00:00 AM' ORDER BY a.CenterName, a.GroupName, a.MemberName String sql: Data: System.Collections.ListDictionaryInternal HelpLink: InnerException: Message: Invalid column name 'GroupStatus'. 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: 18/11/2025 01:27:15 PM PageName: LoanOfficerMobile_GroupMemberCurrentStatus String str: DECLARE @Table TABLE ( MemberId VARCHAR(20), LoanId VARCHAR(50), LoanCycle TINYINT, LoanStatus VARCHAR(20) ); INSERT INTO @Table ( MemberId, LoanId, LoanCycle, LoanStatus ) SELECT MemberId, LoanId, LoanCycle, LoanStatus FROM GroupLoanAccount WITH(nolock) WHERE 1=1 AND LoanOfficerId='SWF00009' ORDER BY MemberId ; SELECT a.CenterId, a.CenterName, a.GroupName, Convert(CHAR,a.MemberJoinDate,106)AS MemberJoinDate, a.MemberId, a.MemberName, a.MemberGuardianName, a.MemberProfileStatus, a.GroupStatus, c1.LoanId AS LoanId1, c1.LoanId+'-'+c1.LoanStatus AS LoanStatus1, c2.LoanId AS LoanId2, c2.LoanId+'-'+c2.LoanStatus AS LoanStatus2, c3.LoanId AS LoanId3, c3.LoanId+'-'+c3.LoanStatus AS LoanStatus3, c4.LoanId AS LoanId4, c4.LoanId+'-'+c4.LoanStatus AS LoanStatus4, c5.LoanId AS LoanId5, c5.LoanId+'-'+c5.LoanStatus AS LoanStatus5, c6.LoanId AS LoanId6, c6.LoanId+'-'+c6.LoanStatus AS LoanStatus6, c7.LoanId AS LoanId7, c7.LoanId+'-'+c7.LoanStatus AS LoanStatus7, c8.LoanId AS LoanId8, c8.LoanId+'-'+c8.LoanStatus AS LoanStatus8, c9.LoanId AS LoanId9, c9.LoanId+'-'+c9.LoanStatus AS LoanStatus9 FROM GroupLoanMemberDetail a WITH(nolock) LEFT JOIN @Table c1 ON a.MemberId=c1.MemberId AND c1.LoanCycle=1 LEFT JOIN @Table c2 ON a.MemberId=c2.MemberId AND c2.LoanCycle=2 LEFT JOIN @Table c3 ON a.MemberId=c3.MemberId AND c3.LoanCycle=3 LEFT JOIN @Table c4 ON a.MemberId=c4.MemberId AND c4.LoanCycle=4 LEFT JOIN @Table c5 ON a.MemberId=c5.MemberId AND c5.LoanCycle=5 LEFT JOIN @Table c6 ON a.MemberId=c6.MemberId AND c6.LoanCycle=6 LEFT JOIN @Table c7 ON a.MemberId=c7.MemberId AND c7.LoanCycle=7 LEFT JOIN @Table c8 ON a.MemberId=c8.MemberId AND c8.LoanCycle=8 LEFT JOIN @Table c9 ON a.MemberId=c9.MemberId AND c9.LoanCycle=9 WHERE 1=1 AND a.GroupOfficerId='SWF00009' AND a.MemberJoinDate>='11/18/2025 12:00:00 AM' AND a.MemberJoinDate<'11/19/2025 12:00:00 AM' ORDER BY a.CenterName, a.GroupName, a.MemberName String sql: Data: System.Collections.ListDictionaryInternal HelpLink: InnerException: Message: Object reference not set to an instance of an object. Source: App_Web_ddccg3qg StackTrace: at LoanOfficerMobile_GroupMemberCurrentStatus.btnSearch_Click(Object sender, EventArgs e) TargetSite: Void btnSearch_Click(System.Object, System.EventArgs) Time: 18/11/2025 01:27:20 PM PageName: DataTableResult String str: DECLARE @Table TABLE ( MemberId VARCHAR(20), LoanId VARCHAR(50), LoanCycle TINYINT, LoanStatus VARCHAR(20) ); INSERT INTO @Table ( MemberId, LoanId, LoanCycle, LoanStatus ) SELECT MemberId, LoanId, LoanCycle, LoanStatus FROM GroupLoanAccount WITH(nolock) WHERE 1=1 AND LoanOfficerId='SWF00009' ORDER BY MemberId ; SELECT a.CenterId, a.CenterName, a.GroupName, Convert(CHAR,a.MemberJoinDate,106)AS MemberJoinDate, a.MemberId, a.MemberName, a.MemberGuardianName, a.MemberProfileStatus, a.GroupStatus, c1.LoanId AS LoanId1, c1.LoanId+'-'+c1.LoanStatus AS LoanStatus1, c2.LoanId AS LoanId2, c2.LoanId+'-'+c2.LoanStatus AS LoanStatus2, c3.LoanId AS LoanId3, c3.LoanId+'-'+c3.LoanStatus AS LoanStatus3, c4.LoanId AS LoanId4, c4.LoanId+'-'+c4.LoanStatus AS LoanStatus4, c5.LoanId AS LoanId5, c5.LoanId+'-'+c5.LoanStatus AS LoanStatus5, c6.LoanId AS LoanId6, c6.LoanId+'-'+c6.LoanStatus AS LoanStatus6, c7.LoanId AS LoanId7, c7.LoanId+'-'+c7.LoanStatus AS LoanStatus7, c8.LoanId AS LoanId8, c8.LoanId+'-'+c8.LoanStatus AS LoanStatus8, c9.LoanId AS LoanId9, c9.LoanId+'-'+c9.LoanStatus AS LoanStatus9 FROM GroupLoanMemberDetail a WITH(nolock) LEFT JOIN @Table c1 ON a.MemberId=c1.MemberId AND c1.LoanCycle=1 LEFT JOIN @Table c2 ON a.MemberId=c2.MemberId AND c2.LoanCycle=2 LEFT JOIN @Table c3 ON a.MemberId=c3.MemberId AND c3.LoanCycle=3 LEFT JOIN @Table c4 ON a.MemberId=c4.MemberId AND c4.LoanCycle=4 LEFT JOIN @Table c5 ON a.MemberId=c5.MemberId AND c5.LoanCycle=5 LEFT JOIN @Table c6 ON a.MemberId=c6.MemberId AND c6.LoanCycle=6 LEFT JOIN @Table c7 ON a.MemberId=c7.MemberId AND c7.LoanCycle=7 LEFT JOIN @Table c8 ON a.MemberId=c8.MemberId AND c8.LoanCycle=8 LEFT JOIN @Table c9 ON a.MemberId=c9.MemberId AND c9.LoanCycle=9 WHERE 1=1 AND a.GroupOfficerId='SWF00009' AND a.MemberJoinDate<'11/19/2025 12:00:00 AM' ORDER BY a.CenterName, a.GroupName, a.MemberName String sql: Data: System.Collections.ListDictionaryInternal HelpLink: InnerException: Message: Invalid column name 'GroupStatus'. 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: 18/11/2025 01:27:20 PM PageName: LoanOfficerMobile_GroupMemberCurrentStatus String str: DECLARE @Table TABLE ( MemberId VARCHAR(20), LoanId VARCHAR(50), LoanCycle TINYINT, LoanStatus VARCHAR(20) ); INSERT INTO @Table ( MemberId, LoanId, LoanCycle, LoanStatus ) SELECT MemberId, LoanId, LoanCycle, LoanStatus FROM GroupLoanAccount WITH(nolock) WHERE 1=1 AND LoanOfficerId='SWF00009' ORDER BY MemberId ; SELECT a.CenterId, a.CenterName, a.GroupName, Convert(CHAR,a.MemberJoinDate,106)AS MemberJoinDate, a.MemberId, a.MemberName, a.MemberGuardianName, a.MemberProfileStatus, a.GroupStatus, c1.LoanId AS LoanId1, c1.LoanId+'-'+c1.LoanStatus AS LoanStatus1, c2.LoanId AS LoanId2, c2.LoanId+'-'+c2.LoanStatus AS LoanStatus2, c3.LoanId AS LoanId3, c3.LoanId+'-'+c3.LoanStatus AS LoanStatus3, c4.LoanId AS LoanId4, c4.LoanId+'-'+c4.LoanStatus AS LoanStatus4, c5.LoanId AS LoanId5, c5.LoanId+'-'+c5.LoanStatus AS LoanStatus5, c6.LoanId AS LoanId6, c6.LoanId+'-'+c6.LoanStatus AS LoanStatus6, c7.LoanId AS LoanId7, c7.LoanId+'-'+c7.LoanStatus AS LoanStatus7, c8.LoanId AS LoanId8, c8.LoanId+'-'+c8.LoanStatus AS LoanStatus8, c9.LoanId AS LoanId9, c9.LoanId+'-'+c9.LoanStatus AS LoanStatus9 FROM GroupLoanMemberDetail a WITH(nolock) LEFT JOIN @Table c1 ON a.MemberId=c1.MemberId AND c1.LoanCycle=1 LEFT JOIN @Table c2 ON a.MemberId=c2.MemberId AND c2.LoanCycle=2 LEFT JOIN @Table c3 ON a.MemberId=c3.MemberId AND c3.LoanCycle=3 LEFT JOIN @Table c4 ON a.MemberId=c4.MemberId AND c4.LoanCycle=4 LEFT JOIN @Table c5 ON a.MemberId=c5.MemberId AND c5.LoanCycle=5 LEFT JOIN @Table c6 ON a.MemberId=c6.MemberId AND c6.LoanCycle=6 LEFT JOIN @Table c7 ON a.MemberId=c7.MemberId AND c7.LoanCycle=7 LEFT JOIN @Table c8 ON a.MemberId=c8.MemberId AND c8.LoanCycle=8 LEFT JOIN @Table c9 ON a.MemberId=c9.MemberId AND c9.LoanCycle=9 WHERE 1=1 AND a.GroupOfficerId='SWF00009' AND a.MemberJoinDate<'11/19/2025 12:00:00 AM' ORDER BY a.CenterName, a.GroupName, a.MemberName String sql: Data: System.Collections.ListDictionaryInternal HelpLink: InnerException: Message: Object reference not set to an instance of an object. Source: App_Web_ddccg3qg StackTrace: at LoanOfficerMobile_GroupMemberCurrentStatus.btnSearch_Click(Object sender, EventArgs e) TargetSite: Void btnSearch_Click(System.Object, System.EventArgs) Time: 18/11/2025 01:29:35 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.End() at System.Web.HttpResponse.Redirect(String url, Boolean endResponse, Boolean permanent) at AdminLogOut.btnLogout_Click(Object sender, EventArgs e) TargetSite: Void AbortInternal() Time: 18/11/2025 01:30:20 PM PageName: GroupLoan_PrintRDLCPage String str: SELECT a.DNo AS C0, Convert(CHAR,a.DDate,106)AS C1, replace(convert(CHAR,a.Prin),'.00','')AS C2, replace(convert(CHAR,a.Intt),'.00','')AS C3, replace(convert(CHAR,a.Total),'.00','')AS C4, a.PStatus AS C5, Convert(CHAR,a.PDate,106)AS C6, b.LoanId AS C7, b.LoanAmount AS C8, b.EMIAmount AS C9, convert(CHAR,b.DisburseDate,106)AS C10, b.MemberId AS C11, b.MemberName AS C12, b.NomineeName AS C13, b.NomineeRelation AS C14, b.CenterName+' ( '+b.CenterId+' )' AS C15, b.GroupName AS C16, b.LoanOfficerName+' ( '+b.LoanOfficerId+' )' AS C17, b.BranchName+' ( '+b.BranchId+' )' AS C18, b.LoanCycle AS C19, b.GLoanTypeNo+' ( '+b.GLoanTypeName+' )' AS C20, rtrim(convert(CHAR,b.LoanTerm))+' - '+b.LoanTermMode AS C21, b.LoanPurpose AS C22, b.LoanFunder AS C23 FROM GroupLoanLedger a WITH(nolock) INNER JOIN GroupLoanAccount b WITH(nolock) ON a.LoanId=b.LoanId WHERE a.Total>0 AND b.LoanId='GL10100002' ORDER BY a.DNo, a.PNo ; String sql: Data: System.Collections.ListDictionaryInternal HelpLink: InnerException: Message: Column 'C95' does not belong to table . Source: System.Data StackTrace: at System.Data.DataRow.GetDataColumn(String columnName) at System.Data.DataRow.get_Item(String columnName) at GroupLoan_PrintRDLCPage.GroupLoanFullDetail() TargetSite: System.Data.DataColumn GetDataColumn(System.String) Time: 18/11/2025 01:30:46 PM PageName: GroupLoan_GroupLoanSettlement 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 GroupLoan_GroupLoanSettlement.txtWorkingDate_TextChanged(Object sender, EventArgs e) TargetSite: System.DateTime Parse(System.String, System.Globalization.DateTimeFormatInfo, System.Globalization.DateTimeStyles) Time: 18/11/2025 01:31:43 PM PageName: GroupLoan_GroupLoanSettlement 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 GroupLoan_GroupLoanSettlement.txtWorkingDate_TextChanged(Object sender, EventArgs e) TargetSite: System.DateTime Parse(System.String, System.Globalization.DateTimeFormatInfo, System.Globalization.DateTimeStyles) Time: 18/11/2025 05:44:39 PM PageName: AdminEXELoginURL String str: SELECT ( SELECT ReportValue FROM ProjectReportSetting WITH(nolock) WHERE ReportName='CompanyURL' )AS CompanyURL, (SELECT ReportValue FROM ProjectReportSetting WITH(nolock) WHERE ReportName='MobileAppURL')AS MobileAppURL, (SELECT convert(int,DataValue) FROM ProjectDataSetting WITH(nolock) WHERE DataName='UserLoginTokenAge')AS UserLoginTokenAge, tt.UserLoginId, tt.UserName, tt.UserLoginStatus, tt.UserWebLogin, tt.UserRole, tt.AdminControl, tt.UserLocation, tt.TokenValue, tt.TokenAge, tt.UserBranch, tt.UserImage, tb.TableName, Convert(CHAR,tt.UserWorkingDate,103)AS UserWorkingDate, Convert(CHAR,tb.FromDate,103)AS FromDate, Convert(CHAR,tb.ToDate,103)AS ToDate FROM ( SELECT a.UserLoginId, a.UserName, a.UserRole, isnull(a.UserLoginStatus,'InActive')AS UserLoginStatus, isnull(a.UserWebLogin,'InActive')AS UserWebLogin, isnull(a.AdminControl,'InActive')AS AdminControl, isnull(a.UserLocation,'InActive')AS UserLocation, a.BranchId AS UserBranch, a.TokenValue, datediff(minute, a.TokenTime, GETDATE())AS TokenAge, (SELECT ReportValue FROM ProjectReportSetting WITH(nolock) WHERE ReportName='CompanyURL')+'UploadedDocs/UserLoginPhoto/'+CASE WHEN len(a.UserImage)>5 THEN a.UserImage ELSE 'CompanyLogo.png' END AS UserImage, CASE WHEN rtrim(convert(CHAR,a.UserLoginDate,106))=rtrim(convert(CHAR,GETDATE(),106)) THEN isnull(a.UserWorkingDate,GETDATE()) ELSE GETDATE() END AS UserWorkingDate FROM UserLoginDetail a with(nolock) WHERE 1=1 AND a.UserLoginId='swf00009' )tt LEFT JOIN FinancialYearMaster tb WITH(nolock) ON tt.UserWorkingDate>=tb.FromDate AND tt.UserWorkingDate5 THEN a.UserImage ELSE 'CompanyLogo.png' END AS UserImage, CASE WHEN rtrim(convert(CHAR,a.UserLoginDate,106))=rtrim(convert(CHAR,GETDATE(),106)) THEN isnull(a.UserWorkingDate,GETDATE()) ELSE GETDATE() END AS UserWorkingDate FROM UserLoginDetail a with(nolock) WHERE 1=1 AND a.UserLoginId='swf00009' )tt LEFT JOIN FinancialYearMaster tb WITH(nolock) ON tt.UserWorkingDate>=tb.FromDate AND tt.UserWorkingDate5 THEN a.UserImage ELSE 'CompanyLogo.png' END AS UserImage, CASE WHEN rtrim(convert(CHAR,a.UserLoginDate,106))=rtrim(convert(CHAR,GETDATE(),106)) THEN isnull(a.UserWorkingDate,GETDATE()) ELSE GETDATE() END AS UserWorkingDate FROM UserLoginDetail a with(nolock) WHERE 1=1 AND a.UserLoginId='swf00009' )tt LEFT JOIN FinancialYearMaster tb WITH(nolock) ON tt.UserWorkingDate>=tb.FromDate AND tt.UserWorkingDate5 THEN a.UserImage ELSE 'CompanyLogo.png' END AS UserImage, CASE WHEN rtrim(convert(CHAR,a.UserLoginDate,106))=rtrim(convert(CHAR,GETDATE(),106)) THEN isnull(a.UserWorkingDate,GETDATE()) ELSE GETDATE() END AS UserWorkingDate FROM UserLoginDetail a with(nolock) WHERE 1=1 AND a.UserLoginId='swf00009' )tt LEFT JOIN FinancialYearMaster tb WITH(nolock) ON tt.UserWorkingDate>=tb.FromDate AND tt.UserWorkingDate5 THEN a.UserImage ELSE 'CompanyLogo.png' END AS UserImage, CASE WHEN rtrim(convert(CHAR,a.UserLoginDate,106))=rtrim(convert(CHAR,GETDATE(),106)) THEN isnull(a.UserWorkingDate,GETDATE()) ELSE GETDATE() END AS UserWorkingDate FROM UserLoginDetail a with(nolock) WHERE 1=1 AND a.UserLoginId='swf00009' )tt LEFT JOIN FinancialYearMaster tb WITH(nolock) ON tt.UserWorkingDate>=tb.FromDate AND tt.UserWorkingDate5 THEN a.UserImage ELSE 'CompanyLogo.png' END AS UserImage, CASE WHEN rtrim(convert(CHAR,a.UserLoginDate,106))=rtrim(convert(CHAR,GETDATE(),106)) THEN isnull(a.UserWorkingDate,GETDATE()) ELSE GETDATE() END AS UserWorkingDate FROM UserLoginDetail a with(nolock) WHERE 1=1 AND a.UserLoginId='swf00009' )tt LEFT JOIN FinancialYearMaster tb WITH(nolock) ON tt.UserWorkingDate>=tb.FromDate AND tt.UserWorkingDate5 THEN a.UserImage ELSE 'CompanyLogo.png' END AS UserImage, CASE WHEN rtrim(convert(CHAR,a.UserLoginDate,106))=rtrim(convert(CHAR,GETDATE(),106)) THEN isnull(a.UserWorkingDate,GETDATE()) ELSE GETDATE() END AS UserWorkingDate FROM UserLoginDetail a with(nolock) WHERE 1=1 AND a.UserLoginId='SWF00009' )tt LEFT JOIN FinancialYearMaster tb WITH(nolock) ON tt.UserWorkingDate>=tb.FromDate AND tt.UserWorkingDate5 THEN a.UserImage ELSE 'CompanyLogo.png' END AS UserImage, CASE WHEN rtrim(convert(CHAR,a.UserLoginDate,106))=rtrim(convert(CHAR,GETDATE(),106)) THEN isnull(a.UserWorkingDate,GETDATE()) ELSE GETDATE() END AS UserWorkingDate FROM UserLoginDetail a with(nolock) WHERE 1=1 AND a.UserLoginId='swf00009' )tt LEFT JOIN FinancialYearMaster tb WITH(nolock) ON tt.UserWorkingDate>=tb.FromDate AND tt.UserWorkingDate5 THEN a.UserImage ELSE 'CompanyLogo.png' END AS UserImage, CASE WHEN rtrim(convert(CHAR,a.UserLoginDate,106))=rtrim(convert(CHAR,GETDATE(),106)) THEN isnull(a.UserWorkingDate,GETDATE()) ELSE GETDATE() END AS UserWorkingDate FROM UserLoginDetail a with(nolock) WHERE 1=1 AND a.UserLoginId='swf00009' )tt LEFT JOIN FinancialYearMaster tb WITH(nolock) ON tt.UserWorkingDate>=tb.FromDate AND tt.UserWorkingDate5 THEN a.UserImage ELSE 'CompanyLogo.png' END AS UserImage, CASE WHEN rtrim(convert(CHAR,a.UserLoginDate,106))=rtrim(convert(CHAR,GETDATE(),106)) THEN isnull(a.UserWorkingDate,GETDATE()) ELSE GETDATE() END AS UserWorkingDate FROM UserLoginDetail a with(nolock) WHERE 1=1 AND a.UserLoginId='swf00009' )tt LEFT JOIN FinancialYearMaster tb WITH(nolock) ON tt.UserWorkingDate>=tb.FromDate AND tt.UserWorkingDate5 THEN a.UserImage ELSE 'CompanyLogo.png' END AS UserImage, CASE WHEN rtrim(convert(CHAR,a.UserLoginDate,106))=rtrim(convert(CHAR,GETDATE(),106)) THEN isnull(a.UserWorkingDate,GETDATE()) ELSE GETDATE() END AS UserWorkingDate FROM UserLoginDetail a with(nolock) WHERE 1=1 AND a.UserLoginId='swf00009' )tt LEFT JOIN FinancialYearMaster tb WITH(nolock) ON tt.UserWorkingDate>=tb.FromDate AND tt.UserWorkingDate5 THEN a.UserImage ELSE 'CompanyLogo.png' END AS UserImage, CASE WHEN rtrim(convert(CHAR,a.UserLoginDate,106))=rtrim(convert(CHAR,GETDATE(),106)) THEN isnull(a.UserWorkingDate,GETDATE()) ELSE GETDATE() END AS UserWorkingDate FROM UserLoginDetail a with(nolock) WHERE 1=1 AND a.UserLoginId='swf00009' )tt LEFT JOIN FinancialYearMaster tb WITH(nolock) ON tt.UserWorkingDate>=tb.FromDate AND tt.UserWorkingDate5 THEN a.UserImage ELSE 'CompanyLogo.png' END AS UserImage, CASE WHEN rtrim(convert(CHAR,a.UserLoginDate,106))=rtrim(convert(CHAR,GETDATE(),106)) THEN isnull(a.UserWorkingDate,GETDATE()) ELSE GETDATE() END AS UserWorkingDate FROM UserLoginDetail a with(nolock) WHERE 1=1 AND a.UserLoginId='swf00009' )tt LEFT JOIN FinancialYearMaster tb WITH(nolock) ON tt.UserWorkingDate>=tb.FromDate AND tt.UserWorkingDate5 THEN a.UserImage ELSE 'CompanyLogo.png' END AS UserImage, CASE WHEN rtrim(convert(CHAR,a.UserLoginDate,106))=rtrim(convert(CHAR,GETDATE(),106)) THEN isnull(a.UserWorkingDate,GETDATE()) ELSE GETDATE() END AS UserWorkingDate FROM UserLoginDetail a with(nolock) WHERE 1=1 AND a.UserLoginId='swf00009' )tt LEFT JOIN FinancialYearMaster tb WITH(nolock) ON tt.UserWorkingDate>=tb.FromDate AND tt.UserWorkingDate5 THEN a.UserImage ELSE 'CompanyLogo.png' END AS UserImage, CASE WHEN rtrim(convert(CHAR,a.UserLoginDate,106))=rtrim(convert(CHAR,GETDATE(),106)) THEN isnull(a.UserWorkingDate,GETDATE()) ELSE GETDATE() END AS UserWorkingDate FROM UserLoginDetail a with(nolock) WHERE 1=1 AND a.UserLoginId='swf00009' )tt LEFT JOIN FinancialYearMaster tb WITH(nolock) ON tt.UserWorkingDate>=tb.FromDate AND tt.UserWorkingDate5 THEN a.UserImage ELSE 'CompanyLogo.png' END AS UserImage, CASE WHEN rtrim(convert(CHAR,a.UserLoginDate,106))=rtrim(convert(CHAR,GETDATE(),106)) THEN isnull(a.UserWorkingDate,GETDATE()) ELSE GETDATE() END AS UserWorkingDate FROM UserLoginDetail a with(nolock) WHERE 1=1 AND a.UserLoginId='swf00009' )tt LEFT JOIN FinancialYearMaster tb WITH(nolock) ON tt.UserWorkingDate>=tb.FromDate AND tt.UserWorkingDate5 THEN a.UserImage ELSE 'CompanyLogo.png' END AS UserImage, CASE WHEN rtrim(convert(CHAR,a.UserLoginDate,106))=rtrim(convert(CHAR,GETDATE(),106)) THEN isnull(a.UserWorkingDate,GETDATE()) ELSE GETDATE() END AS UserWorkingDate FROM UserLoginDetail a with(nolock) WHERE 1=1 AND a.UserLoginId='swf00009' )tt LEFT JOIN FinancialYearMaster tb WITH(nolock) ON tt.UserWorkingDate>=tb.FromDate AND tt.UserWorkingDate5 THEN a.UserImage ELSE 'CompanyLogo.png' END AS UserImage, CASE WHEN rtrim(convert(CHAR,a.UserLoginDate,106))=rtrim(convert(CHAR,GETDATE(),106)) THEN isnull(a.UserWorkingDate,GETDATE()) ELSE GETDATE() END AS UserWorkingDate FROM UserLoginDetail a with(nolock) WHERE 1=1 AND a.UserLoginId='swf00009' )tt LEFT JOIN FinancialYearMaster tb WITH(nolock) ON tt.UserWorkingDate>=tb.FromDate AND tt.UserWorkingDate5 THEN a.UserImage ELSE 'CompanyLogo.png' END AS UserImage, CASE WHEN rtrim(convert(CHAR,a.UserLoginDate,106))=rtrim(convert(CHAR,GETDATE(),106)) THEN isnull(a.UserWorkingDate,GETDATE()) ELSE GETDATE() END AS UserWorkingDate FROM UserLoginDetail a with(nolock) WHERE 1=1 AND a.UserLoginId='swf00009' )tt LEFT JOIN FinancialYearMaster tb WITH(nolock) ON tt.UserWorkingDate>=tb.FromDate AND tt.UserWorkingDate5 THEN a.UserImage ELSE 'CompanyLogo.png' END AS UserImage, CASE WHEN rtrim(convert(CHAR,a.UserLoginDate,106))=rtrim(convert(CHAR,GETDATE(),106)) THEN isnull(a.UserWorkingDate,GETDATE()) ELSE GETDATE() END AS UserWorkingDate FROM UserLoginDetail a with(nolock) WHERE 1=1 AND a.UserLoginId='swf00009' )tt LEFT JOIN FinancialYearMaster tb WITH(nolock) ON tt.UserWorkingDate>=tb.FromDate AND tt.UserWorkingDate0 ; UPDATE ta SET ta.MeetingDay=(SELECT MeetingDay FROM GroupCenterMaster WITH(nolock) WHERE CenterId=ta.CenterId) FROM @FTable ta; UPDATE ta SET ta.MeetingTime=(SELECT MeetingTime FROM GroupCenterMaster WITH(nolock) WHERE CenterId=ta.CenterId) FROM @FTable ta; UPDATE ta SET ta.GuardianName=(SELECT MemberGuardianName FROM GroupLoanMemberDetail WITH(nolock) WHERE MemberId=ta.MemberId) FROM @FTable ta; UPDATE ta SET ta.ContactNo=(SELECT NomineeMobileNo FROM GroupLoanMemberDetail WITH(nolock) WHERE MemberId=ta.MemberId) FROM @FTable ta; UPDATE ta SET ta.MobileNo=(SELECT MemberMobileNo FROM GroupLoanMemberDetail WITH(nolock) WHERE MemberId=ta.MemberId) FROM @FTable ta; UPDATE ta SET ta.DueDate=(SELECT rtrim(Convert(CHAR,MIN(DDate),103)) FROM @TTable WHERE LoanId=ta.LoanId AND PStatus='Due') FROM @FTable ta; UPDATE ta SET ta.DueNo=(SELECT MIN(DNo) FROM @TTable WHERE LoanId=ta.LoanId AND PStatus='Due') FROM @FTable ta; UPDATE ta SET ta.LastPaidDate=(SELECT rtrim(Convert(char,MAX(PDate),103)) FROM @TTable WHERE LoanId=ta.LoanId AND PStatus='Paid') FROM @FTable ta; UPDATE ta SET ta.ODAmount=(SELECT SUM(Total) FROM @TTable WHERE LoanId=ta.LoanId AND PStatus='Due' AND DDate<@ODate) FROM @FTable ta; UPDATE ta SET ta.DueAmount=(SELECT SUM(Total) FROM @TTable WHERE LoanId=ta.LoanId AND PStatus='Due' AND DDate=@ODate) FROM @FTable ta; UPDATE ta SET ta.BalanceAmount=(SELECT SUM(Total) FROM @TTable WHERE LoanId=ta.LoanId AND PStatus='Due') FROM @FTable ta; SELECT replace(a.OnDate,' ','-')AS C0, a.BranchName AS C1, a.LoanOfficerId AS C2, a.LoanOfficerName AS C3, a.CenterId AS C4, a.CenterName AS C5, a.MemberId AS C6, a.MemberName AS C7, a.GuardianName AS C8, a.MobileNo AS C9, a.ContactNo AS C10, a.LoanId AS C11, replace(a.DueDate,'/20','/')AS C12, a.DueNo AS C13, replace(isnull(a.ODAmount,0.00),'.00','')AS C14, replace(isnull(a.DueAmount,0),'.00','')AS C15, replace(a.BalanceAmount,'.00','') AS C16, CASE WHEN isnull(a.MeetingAmount,0)>0 THEN 0 ELSE isnull(a.ODAmount,0)+isnull(a.DueAmount,0) END AS C17, isnull(a.MeetingAmount,0)AS C18, replace(a.EMIAmount,'.00','') AS C19, replace(a.LoanAmount,'.00','')AS C20, replace(a.LastPaidDate,'/20','/')AS C21, replace(a.DisburseDate,'/20','/')AS C22, a.LoanTerm AS C23, a.MeetingTime AS C24, (SELECT CompanyName FROM ProjectReportSettingMaster WITH(nolock) WHERE 1=1)AS C99, (SELECT CompanyDetail1 FROM ProjectReportSettingMaster WITH(nolock) WHERE 1=1)AS C98, (SELECT CompanyDetail2 FROM ProjectReportSettingMaster WITH(nolock) WHERE 1=1)AS C97, (SELECT CompanyDetail3 FROM ProjectReportSettingMaster WITH(nolock) WHERE 1=1)AS C96, (SELECT GroupLoanDemandSheetRDLC FROM ProjectReportSettingMaster WITH(nolock) WHERE 1=1)AS C95 FROM @FTable a WHERE 1=1 AND isnull(a.BalanceAmount,0)>0 ORDER BY a.BranchName, a.LoanOfficerName, a.CenterName, a.MemberName String sql: Data: System.Collections.ListDictionaryInternal HelpLink: InnerException: Microsoft.Reporting.DefinitionInvalidException: The definition of the report 'Main Report' is invalid. ---> Microsoft.ReportingServices.ReportProcessing.ReportProcessingException: The report definition is not valid. Details: The report definition has an invalid target namespace 'http://schemas.microsoft.com/sqlserver/reporting/2008/01/reportdefinition' which cannot be upgraded. Message: An error occurred during local report processing. Source: Microsoft.ReportViewer.WebForms StackTrace: at Microsoft.Reporting.WebForms.LocalReport.CompileReport() at Microsoft.Reporting.WebForms.LocalReport.InternalRender(String format, Boolean allowInternalRenderers, String deviceInfo, CreateAndRegisterStream createStreamCallback, Warning[]& warnings) at Microsoft.Reporting.WebForms.LocalReport.InternalRender(String format, Boolean allowInternalRenderers, String deviceInfo, String& mimeType, String& encoding, String& fileNameExtension, String[]& streams, Warning[]& warnings) at Microsoft.Reporting.WebForms.LocalReport.Render(String format, String deviceInfo, String& mimeType, String& encoding, String& fileNameExtension, String[]& streams, Warning[]& warnings) at GroupLoan_PrintRDLCPage.GroupLoanDemandSheet() TargetSite: Void CompileReport() Time: 01/12/2025 04:10:19 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.End() at System.Web.HttpResponse.Redirect(String url, Boolean endResponse, Boolean permanent) at AdminLogOut.btnLogout_Click(Object sender, EventArgs e) TargetSite: Void AbortInternal() Time: 02/12/2025 08:34:28 AM PageName: GroupLoan_GroupDemandCollectionReport 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 GroupLoan_GroupDemandCollectionReport.ExportToExcel(DataTable DT, String fileName) TargetSite: Void AbortInternal() Time: 02/12/2025 08:34:28 AM PageName: GroupLoan_GroupDemandCollectionReport String str: String sql: Data: System.Collections.ListDictionaryInternal HelpLink: InnerException: Message: Thread was being aborted. Source: App_Web_wcljl4oq StackTrace: at GroupLoan_GroupDemandCollectionReport.ExportToExcel(DataTable DT, String fileName) at GroupLoan_GroupDemandCollectionReport.btnExcel_Click(Object sender, EventArgs e) TargetSite: Void ExportToExcel(System.Data.DataTable, System.String) Time: 02/12/2025 08:40:14 AM PageName: GroupLoan_GroupLoanOutstandingReport 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 GroupLoan_GroupLoanOutstandingReport.ExportToExcel(DataTable DT, String fileName) TargetSite: Void AbortInternal() Time: 02/12/2025 08:40:14 AM PageName: GroupLoan_GroupLoanOutstandingReport String str: String sql: Data: System.Collections.ListDictionaryInternal HelpLink: InnerException: Message: Thread was being aborted. Source: App_Web_vsaec2xh StackTrace: at GroupLoan_GroupLoanOutstandingReport.ExportToExcel(DataTable DT, String fileName) at GroupLoan_GroupLoanOutstandingReport.btnExcel_Click(Object sender, EventArgs e) TargetSite: Void ExportToExcel(System.Data.DataTable, System.String) Time: 02/12/2025 08:47:10 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: 02/12/2025 09:33:50 AM PageName: AdminEXELoginURL String str: SELECT ( SELECT ReportValue FROM ProjectReportSetting WITH(nolock) WHERE ReportName='CompanyURL' )AS CompanyURL, (SELECT ReportValue FROM ProjectReportSetting WITH(nolock) WHERE ReportName='MobileAppURL')AS MobileAppURL, (SELECT convert(int,DataValue) FROM ProjectDataSetting WITH(nolock) WHERE DataName='UserLoginTokenAge')AS UserLoginTokenAge, tt.UserLoginId, tt.UserName, tt.UserLoginStatus, tt.UserWebLogin, tt.UserRole, tt.AdminControl, tt.UserLocation, tt.TokenValue, tt.TokenAge, tt.UserBranch, tt.UserImage, tb.TableName, Convert(CHAR,tt.UserWorkingDate,103)AS UserWorkingDate, Convert(CHAR,tb.FromDate,103)AS FromDate, Convert(CHAR,tb.ToDate,103)AS ToDate FROM ( SELECT a.UserLoginId, a.UserName, a.UserRole, isnull(a.UserLoginStatus,'InActive')AS UserLoginStatus, isnull(a.UserWebLogin,'InActive')AS UserWebLogin, isnull(a.AdminControl,'InActive')AS AdminControl, isnull(a.UserLocation,'InActive')AS UserLocation, a.BranchId AS UserBranch, a.TokenValue, datediff(minute, a.TokenTime, GETDATE())AS TokenAge, (SELECT ReportValue FROM ProjectReportSetting WITH(nolock) WHERE ReportName='CompanyURL')+'UploadedDocs/UserLoginPhoto/'+CASE WHEN len(a.UserImage)>5 THEN a.UserImage ELSE 'CompanyLogo.png' END AS UserImage, CASE WHEN rtrim(convert(CHAR,a.UserLoginDate,106))=rtrim(convert(CHAR,GETDATE(),106)) THEN isnull(a.UserWorkingDate,GETDATE()) ELSE GETDATE() END AS UserWorkingDate FROM UserLoginDetail a with(nolock) WHERE 1=1 AND a.UserLoginId='swf00009' )tt LEFT JOIN FinancialYearMaster tb WITH(nolock) ON tt.UserWorkingDate>=tb.FromDate AND tt.UserWorkingDate5 THEN a.UserImage ELSE 'CompanyLogo.png' END AS UserImage, CASE WHEN rtrim(convert(CHAR,a.UserLoginDate,106))=rtrim(convert(CHAR,GETDATE(),106)) THEN isnull(a.UserWorkingDate,GETDATE()) ELSE GETDATE() END AS UserWorkingDate FROM UserLoginDetail a with(nolock) WHERE 1=1 AND a.UserLoginId='swf00009' )tt LEFT JOIN FinancialYearMaster tb WITH(nolock) ON tt.UserWorkingDate>=tb.FromDate AND tt.UserWorkingDate5 THEN a.UserImage ELSE 'CompanyLogo.png' END AS UserImage, CASE WHEN rtrim(convert(CHAR,a.UserLoginDate,106))=rtrim(convert(CHAR,GETDATE(),106)) THEN isnull(a.UserWorkingDate,GETDATE()) ELSE GETDATE() END AS UserWorkingDate FROM UserLoginDetail a with(nolock) WHERE 1=1 AND a.UserLoginId='swf00009' )tt LEFT JOIN FinancialYearMaster tb WITH(nolock) ON tt.UserWorkingDate>=tb.FromDate AND tt.UserWorkingDate5 THEN a.UserImage ELSE 'CompanyLogo.png' END AS UserImage, CASE WHEN rtrim(convert(CHAR,a.UserLoginDate,106))=rtrim(convert(CHAR,GETDATE(),106)) THEN isnull(a.UserWorkingDate,GETDATE()) ELSE GETDATE() END AS UserWorkingDate FROM UserLoginDetail a with(nolock) WHERE 1=1 AND a.UserLoginId='swf00009' )tt LEFT JOIN FinancialYearMaster tb WITH(nolock) ON tt.UserWorkingDate>=tb.FromDate AND tt.UserWorkingDate5 THEN a.UserImage ELSE 'CompanyLogo.png' END AS UserImage, CASE WHEN rtrim(convert(CHAR,a.UserLoginDate,106))=rtrim(convert(CHAR,GETDATE(),106)) THEN isnull(a.UserWorkingDate,GETDATE()) ELSE GETDATE() END AS UserWorkingDate FROM UserLoginDetail a with(nolock) WHERE 1=1 AND a.UserLoginId='swf00009' )tt LEFT JOIN FinancialYearMaster tb WITH(nolock) ON tt.UserWorkingDate>=tb.FromDate AND tt.UserWorkingDate5 THEN a.UserImage ELSE 'CompanyLogo.png' END AS UserImage, CASE WHEN rtrim(convert(CHAR,a.UserLoginDate,106))=rtrim(convert(CHAR,GETDATE(),106)) THEN isnull(a.UserWorkingDate,GETDATE()) ELSE GETDATE() END AS UserWorkingDate FROM UserLoginDetail a with(nolock) WHERE 1=1 AND a.UserLoginId='swf00009' )tt LEFT JOIN FinancialYearMaster tb WITH(nolock) ON tt.UserWorkingDate>=tb.FromDate AND tt.UserWorkingDate5 THEN a.UserImage ELSE 'CompanyLogo.png' END AS UserImage, CASE WHEN rtrim(convert(CHAR,a.UserLoginDate,106))=rtrim(convert(CHAR,GETDATE(),106)) THEN isnull(a.UserWorkingDate,GETDATE()) ELSE GETDATE() END AS UserWorkingDate FROM UserLoginDetail a with(nolock) WHERE 1=1 AND a.UserLoginId='swf00009' )tt LEFT JOIN FinancialYearMaster tb WITH(nolock) ON tt.UserWorkingDate>=tb.FromDate AND tt.UserWorkingDate5 THEN a.UserImage ELSE 'CompanyLogo.png' END AS UserImage, CASE WHEN rtrim(convert(CHAR,a.UserLoginDate,106))=rtrim(convert(CHAR,GETDATE(),106)) THEN isnull(a.UserWorkingDate,GETDATE()) ELSE GETDATE() END AS UserWorkingDate FROM UserLoginDetail a with(nolock) WHERE 1=1 AND a.UserLoginId='swf00009' )tt LEFT JOIN FinancialYearMaster tb WITH(nolock) ON tt.UserWorkingDate>=tb.FromDate AND tt.UserWorkingDate5 THEN a.UserImage ELSE 'CompanyLogo.png' END AS UserImage, CASE WHEN rtrim(convert(CHAR,a.UserLoginDate,106))=rtrim(convert(CHAR,GETDATE(),106)) THEN isnull(a.UserWorkingDate,GETDATE()) ELSE GETDATE() END AS UserWorkingDate FROM UserLoginDetail a with(nolock) WHERE 1=1 AND a.UserLoginId='swf00009' )tt LEFT JOIN FinancialYearMaster tb WITH(nolock) ON tt.UserWorkingDate>=tb.FromDate AND tt.UserWorkingDate5 THEN a.UserImage ELSE 'CompanyLogo.png' END AS UserImage, CASE WHEN rtrim(convert(CHAR,a.UserLoginDate,106))=rtrim(convert(CHAR,GETDATE(),106)) THEN isnull(a.UserWorkingDate,GETDATE()) ELSE GETDATE() END AS UserWorkingDate FROM UserLoginDetail a with(nolock) WHERE 1=1 AND a.UserLoginId='swf00009' )tt LEFT JOIN FinancialYearMaster tb WITH(nolock) ON tt.UserWorkingDate>=tb.FromDate AND tt.UserWorkingDate5 THEN a.UserImage ELSE 'CompanyLogo.png' END AS UserImage, CASE WHEN rtrim(convert(CHAR,a.UserLoginDate,106))=rtrim(convert(CHAR,GETDATE(),106)) THEN isnull(a.UserWorkingDate,GETDATE()) ELSE GETDATE() END AS UserWorkingDate FROM UserLoginDetail a with(nolock) WHERE 1=1 AND a.UserLoginId='swf00009' )tt LEFT JOIN FinancialYearMaster tb WITH(nolock) ON tt.UserWorkingDate>=tb.FromDate AND tt.UserWorkingDate5 THEN a.UserImage ELSE 'CompanyLogo.png' END AS UserImage, CASE WHEN rtrim(convert(CHAR,a.UserLoginDate,106))=rtrim(convert(CHAR,GETDATE(),106)) THEN isnull(a.UserWorkingDate,GETDATE()) ELSE GETDATE() END AS UserWorkingDate FROM UserLoginDetail a with(nolock) WHERE 1=1 AND a.UserLoginId='swf00009' )tt LEFT JOIN FinancialYearMaster tb WITH(nolock) ON tt.UserWorkingDate>=tb.FromDate AND tt.UserWorkingDate5 THEN a.UserImage ELSE 'CompanyLogo.png' END AS UserImage, CASE WHEN rtrim(convert(CHAR,a.UserLoginDate,106))=rtrim(convert(CHAR,GETDATE(),106)) THEN isnull(a.UserWorkingDate,GETDATE()) ELSE GETDATE() END AS UserWorkingDate FROM UserLoginDetail a with(nolock) WHERE 1=1 AND a.UserLoginId='swf00009' )tt LEFT JOIN FinancialYearMaster tb WITH(nolock) ON tt.UserWorkingDate>=tb.FromDate AND tt.UserWorkingDate5 THEN a.UserImage ELSE 'CompanyLogo.png' END AS UserImage, CASE WHEN rtrim(convert(CHAR,a.UserLoginDate,106))=rtrim(convert(CHAR,GETDATE(),106)) THEN isnull(a.UserWorkingDate,GETDATE()) ELSE GETDATE() END AS UserWorkingDate FROM UserLoginDetail a with(nolock) WHERE 1=1 AND a.UserLoginId='swf00009' )tt LEFT JOIN FinancialYearMaster tb WITH(nolock) ON tt.UserWorkingDate>=tb.FromDate AND tt.UserWorkingDate5 THEN a.UserImage ELSE 'CompanyLogo.png' END AS UserImage, CASE WHEN rtrim(convert(CHAR,a.UserLoginDate,106))=rtrim(convert(CHAR,GETDATE(),106)) THEN isnull(a.UserWorkingDate,GETDATE()) ELSE GETDATE() END AS UserWorkingDate FROM UserLoginDetail a with(nolock) WHERE 1=1 AND a.UserLoginId='swf00009' )tt LEFT JOIN FinancialYearMaster tb WITH(nolock) ON tt.UserWorkingDate>=tb.FromDate AND tt.UserWorkingDate5 THEN a.UserImage ELSE 'CompanyLogo.png' END AS UserImage, CASE WHEN rtrim(convert(CHAR,a.UserLoginDate,106))=rtrim(convert(CHAR,GETDATE(),106)) THEN isnull(a.UserWorkingDate,GETDATE()) ELSE GETDATE() END AS UserWorkingDate FROM UserLoginDetail a with(nolock) WHERE 1=1 AND a.UserLoginId='swf00009' )tt LEFT JOIN FinancialYearMaster tb WITH(nolock) ON tt.UserWorkingDate>=tb.FromDate AND tt.UserWorkingDate5 THEN a.UserImage ELSE 'CompanyLogo.png' END AS UserImage, CASE WHEN rtrim(convert(CHAR,a.UserLoginDate,106))=rtrim(convert(CHAR,GETDATE(),106)) THEN isnull(a.UserWorkingDate,GETDATE()) ELSE GETDATE() END AS UserWorkingDate FROM UserLoginDetail a with(nolock) WHERE 1=1 AND a.UserLoginId='swf00009' )tt LEFT JOIN FinancialYearMaster tb WITH(nolock) ON tt.UserWorkingDate>=tb.FromDate AND tt.UserWorkingDate5 THEN a.UserImage ELSE 'CompanyLogo.png' END AS UserImage, CASE WHEN rtrim(convert(CHAR,a.UserLoginDate,106))=rtrim(convert(CHAR,GETDATE(),106)) THEN isnull(a.UserWorkingDate,GETDATE()) ELSE GETDATE() END AS UserWorkingDate FROM UserLoginDetail a with(nolock) WHERE 1=1 AND a.UserLoginId='swf00009' )tt LEFT JOIN FinancialYearMaster tb WITH(nolock) ON tt.UserWorkingDate>=tb.FromDate AND tt.UserWorkingDate