08:31:33 AM Virmati.Banking.CBS.CBSData.dDailytransactions.Proc_InsertDailyTrans_SP --> .Net SqlClient Data Provider --> Violation of PRIMARY KEY constraint 'PK_Dailytransactions'. Cannot insert duplicate key in object 'dbo.Dailytransactions'. at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction); at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose); at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady); at System.Data.SqlClient.SqlCommand.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.InternalExecuteNonQuery(TaskCompletionSource`1 completion, String methodName, Boolean sendToPipe, Int32 timeout, Boolean& usedCache, Boolean asyncWrite, Boolean inRetry); at System.Data.SqlClient.SqlCommand.ExecuteNonQuery(); at Virmati.Banking.CBS.CBSData.dDailytransactions.Proc_InsertDailyTrans_SP(dTransactions& pobjDB, DbConnection& cnSP, DbTransaction& objBeginTrnObj) 08:31:33 AM Virmati.Banking.CBS.CBSData.dDailytransactions.Proc_InsertTrans_SP --> Virmati.Banking.CBS.CBSData.dDailytransactions.Proc_InsertDailyTrans_SP --> .Net SqlClient Data Provider --> Violation of PRIMARY KEY constraint 'PK_Dailytransactions'. Cannot insert duplicate key in object 'dbo.Dailytransactions'. at Virmati.Banking.CBS.CBSData.dDailytransactions.Proc_InsertDailyTrans_SP(dTransactions& pobjDB, DbConnection& cnSP, DbTransaction& objBeginTrnObj); at Virmati.Banking.CBS.CBSData.dDailytransactions.Proc_InsertTrans_SP(dTransactions& pobjDB, Int64 pCardTrnAuto, dTrnFinInc objdTrnFinInc) 08:31:34 AM Virmati.Banking.CBS.CBSData.dDailytransactions.Proc_InsertDailyTrans_SP --> .Net SqlClient Data Provider --> Transaction (Process ID 115) was deadlocked on lock resources with another process and has been chosen as the deadlock victim. Rerun the transaction. Transaction count after EXECUTE indicates a mismatching number of BEGIN and COMMIT statements. Previous count = 1, current count = 2. Uncommittable transaction is detected at the end of the batch. The transaction is rolled back. at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction); at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose); at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady); at System.Data.SqlClient.SqlCommand.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.InternalExecuteNonQuery(TaskCompletionSource`1 completion, String methodName, Boolean sendToPipe, Int32 timeout, Boolean& usedCache, Boolean asyncWrite, Boolean inRetry); at System.Data.SqlClient.SqlCommand.ExecuteNonQuery(); at Virmati.Banking.CBS.CBSData.dDailytransactions.Proc_InsertDailyTrans_SP(dTransactions& pobjDB, DbConnection& cnSP, DbTransaction& objBeginTrnObj) 08:31:34 AM Virmati.Banking.CBS.CBSData.dDailytransactions.Proc_InsertTrans_SP --> Virmati.Banking.CBS.CBSData.dDailytransactions.Proc_InsertDailyTrans_SP --> .Net SqlClient Data Provider --> Transaction (Process ID 115) was deadlocked on lock resources with another process and has been chosen as the deadlock victim. Rerun the transaction. Transaction count after EXECUTE indicates a mismatching number of BEGIN and COMMIT statements. Previous count = 1, current count = 2. Uncommittable transaction is detected at the end of the batch. The transaction is rolled back. at Virmati.Banking.CBS.CBSData.dDailytransactions.Proc_InsertDailyTrans_SP(dTransactions& pobjDB, DbConnection& cnSP, DbTransaction& objBeginTrnObj); at Virmati.Banking.CBS.CBSData.dDailytransactions.Proc_InsertTrans_SP(dTransactions& pobjDB, Int64 pCardTrnAuto, dTrnFinInc objdTrnFinInc) 07:33:10 PM DataCommon.ExecuteScalar - SELECT count(*) FROM RTGSNEFTInTrn WHERE TrnRefNo = 'IDIBH24156408555' --> .Net SqlClient Data Provider --> --> Execution Timeout Expired. The timeout period elapsed prior to completion of the operation or the server is not responding. at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction); at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose); at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady); at System.Data.SqlClient.SqlDataReader.TryConsumeMetaData(); at System.Data.SqlClient.SqlDataReader.get_MetaData(); at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString, Boolean isInternal, Boolean forDescribeParameterEncryption, Boolean shouldCacheForAlwaysEncrypted); at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async, Int32 timeout, Task& task, Boolean asyncWrite, Boolean inRetry, SqlDataReader ds, Boolean describeParameterEncryptionRequest); at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, TaskCompletionSource`1 completion, Int32 timeout, Task& task, Boolean& usedCache, Boolean asyncWrite, Boolean inRetry); at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method); at System.Data.SqlClient.SqlCommand.ExecuteScalar(); at Virmati.Banking.CBS.CBSData.DataCommon.ExecuteScalar(String strQuery, Boolean CloseTheConnection) 07:34:20 PM DataCommon.OpenDataTable - select isnull(t.tdlinkaccount, 0) as flexiacno, isnull((select sum((isnull(d.DepositAmount, 0) - isnull(d.PartWithdrawal, 0) + isnull(d.InterestAmount, 0) - isnull(d.PartwithdrawalDue, 0) - isnull(d.InterestPaid, 0) + isnull(d.PartwithdrawalPaid, 0) - isnull(d.CummulativeTax, 0) + isnull(d.PartwithdrawalTax, 0) + isnull(d.ExcessInterest, 0))) from depositmaster d where d.acno = t.TDLinkAccount and IsNull(d.status,0) <> 9 group by d.acno), 0) as flexibalance from accountmaster a, tdlink t Where a.Acno = t.Acno and a.acno = 1002005014470 and a.branchcode = 1002 and t.branchcode = 1002 and t.acno = 1002005014470 order by t.acno --> .Net SqlClient Data Provider --> --> Execution Timeout Expired. The timeout period elapsed prior to completion of the operation or the server is not responding., ConnectionString = "Server=VCBDB3\VCBLDB;Database=newcbsvcb", Table = "AccountMaster" at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction); at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose); at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady); at System.Data.SqlClient.SqlDataReader.TryConsumeMetaData(); at System.Data.SqlClient.SqlDataReader.get_MetaData(); at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString, Boolean isInternal, Boolean forDescribeParameterEncryption, Boolean shouldCacheForAlwaysEncrypted); at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async, Int32 timeout, Task& task, Boolean asyncWrite, Boolean inRetry, SqlDataReader ds, Boolean describeParameterEncryptionRequest); at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, TaskCompletionSource`1 completion, Int32 timeout, Task& task, Boolean& usedCache, Boolean asyncWrite, Boolean inRetry); at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method); at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior, String method); at System.Data.Common.DbDataAdapter.FillInternal(DataSet dataset, DataTable[] datatables, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior); at System.Data.Common.DbDataAdapter.Fill(DataTable[] dataTables, Int32 startRecord, Int32 maxRecords, IDbCommand command, CommandBehavior behavior); at System.Data.Common.DbDataAdapter.Fill(DataTable dataTable); at Virmati.Banking.CBS.CBSData.DataCommon.OpenDataTable(String strSQL, String TableName, Boolean pCloseConn) 07:34:20 PM Virmati.Banking.CBS.CBSData.dAccountMaster.GetFlexiDetails --> DataCommon.OpenDataTable - select isnull(t.tdlinkaccount, 0) as flexiacno, isnull((select sum((isnull(d.DepositAmount, 0) - isnull(d.PartWithdrawal, 0) + isnull(d.InterestAmount, 0) - isnull(d.PartwithdrawalDue, 0) - isnull(d.InterestPaid, 0) + isnull(d.PartwithdrawalPaid, 0) - isnull(d.CummulativeTax, 0) + isnull(d.PartwithdrawalTax, 0) + isnull(d.ExcessInterest, 0))) from depositmaster d where d.acno = t.TDLinkAccount and IsNull(d.status,0) <> 9 group by d.acno), 0) as flexibalance from accountmaster a, tdlink t Where a.Acno = t.Acno and a.acno = 1002005014470 and a.branchcode = 1002 and t.branchcode = 1002 and t.acno = 1002005014470 order by t.acno --> .Net SqlClient Data Provider --> --> Execution Timeout Expired. The timeout period elapsed prior to completion of the operation or the server is not responding. at Virmati.Banking.CBS.CBSData.DataCommon.OpenDataTable(String strSQL, String TableName, Boolean pCloseConn); at Virmati.Banking.CBS.CBSData.dAccountMaster.GetFlexiDetails(Int64 AcNo) 07:35:33 PM DataCommon.OpenDataTable -SELECT Code,BranchCode,CustomerType,Title,Name,ShortName,BirthDate,AnniversaryDate,Sex,ResAddress1,ResAddress2,ResAddress3,ResCity,ResPin,ResPhone1,ResPhone2,ResFax,Office,Designation,OfficeAddress1,OfficeAddress2,OfficeAddress3,OffCity,OffPin,OffPhone1,OffPhone2,OffFax,EmailID,Web,CellPhone,Membertype,GroupNo,PAN,BSRCode,Limit,Category,Country,Constitution,NRI,Classification,Occupation,Location,Minor,Staff,ITCode,Joint,PassportNumber,PassportIssueDate,PassportExpiryDate,PassportIssuePlace,ContactPerson,ContactAddress1,ContactAddress2,ContactAddress3,ContactCity,ContactPin,ContactPhoneNo,VIP,Status,EnqTerminalAllowed,EnqTerminalPassword,TeleBankingAllowed,TeleBankingPassword,EBankAllowed,EBankPassword,ATMAllowed,ATMPassword,WAPAllowed,WAPPassword,RATAllowed,RATPassword,CreditCardAllowed,CreditCardType,CreditCardIssueBy,CreditCardExpiryDate,TDSGroup,ModifyDate,Operator,Supervisor,Authorised,IntGracePrd,EmpID,RegistrationNo,RegistrationDate,CreditGrade,CapAdqCode,GuardianCustNo,GuardianName,IsMember,MemberNo,NoofShares,Death,DeathDate,DeathCertRcd,DeathRemarks,DeathInstrOpr,Insolvent,InsolventDate,InsolventInstrOpr,IsNPA,NPADate,NPARevDate,LicenceNo,IdentityNo,TDS,TDSReason,StatementInd,StatementFrq,CorrEmail,BaseType,AuthorityToOperate,ReqdCapital,TotalValueOfShares,ShareCapitalPattern,FundedCapital,NonFundedCapital,OpenDate,CustomerRemarks,CorrectionOpr,CorrectionSpr,Religion,Caste,ResCityCode,CorrCityCode,SeniorCitizen,RefAcno,MembershipDate,MemberFees,BiLingApplicable,DefaultLanguage,TotalMember,FatherName,AppointmentDate,RetirementDate,EmpStatus,LegalStatus,Nature,Term,Period,SocietyCustNo,COPMode,AreaCode,TalukaCode,DistrictCode,StateCode,ExRBICode,ImRBICode,PREFIBUSERID,ExpImpCode,HighNetWrt,CellProvider1,CellProvider2,CellNo1,CellNo2,TransEmailID,NPACode,CustNameType,Marital,AnnualIncome,CitizenID,FirmBranch,PlaceIncorporated,PlaceRegistration,STaxRegistration,ExciseTaxRegistration,DateOfRegistration,IsBlackListed,RelationMinor,ElectroCard,MemorandumArticles,ManageBy,IsSeniorCitizen,SeniorCitizenMarkDate,GRANDFATHER,CAMSCustNo,MajharaCode,SBTaxRatePattern,CustStatus,Purpose,Sector,CHealth,ChmName,ChmAdd1,ChmAdd2,ChmAdd3,ChmCity,ChmPin,ChmFromDate,ChmToDate,SecName,SecAdd1,SecAdd2,SecAdd3,SecCity,SecPin,SecFromDate,SecToDate,VisaNo,VisaCountry,VisaIsuueDate,VisaExpiryDate,VisaType,IsInoperative,InOperativeDate,LastAcCloseDate,CustAge,BussinessRegType,BussinessRegNo,CustHealth,IsMemberNominal,EmpStaffCategory,NPAProjectedCode,NRIType,CitizenIdIssuePlace,CitizenIdIssueDate,CitizenIdIssueExpireDate,RegistrationAuthority,turnover, Landmark, Perlandmark, Officelandmark,PEP,AnnualIncomeCurrency,TurnOverCurrency,TurnOverFreq,ReferenceBy,RiskCategory,EmailAllowed,IsSuspicious,lifestyle,MotherMaidenName,CommunicationLanguage,AadharNumber,RiskScore FROM Customer WHERE Code = 633226 --> .Net SqlClient Data Provider --> --> Execution Timeout Expired. The timeout period elapsed prior to completion of the operation or the server is not responding., ConnectionString = "Server=VCBDB3\VCBLDB;Database=newcbsvcb", Table = "Customer" 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.TdsParserStateObject.ReadSniError(TdsParserStateObject stateObj, UInt32 error); at System.Data.SqlClient.TdsParserStateObject.ReadSniSyncOverAsync(); at System.Data.SqlClient.TdsParserStateObject.TryReadNetworkPacket(); at System.Data.SqlClient.TdsParserStateObject.TryPrepareBuffer(); at System.Data.SqlClient.TdsParserStateObject.TryReadByte(Byte& value); at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady); at System.Data.SqlClient.SqlDataReader.TryConsumeMetaData(); at System.Data.SqlClient.SqlDataReader.get_MetaData(); at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString, Boolean isInternal, Boolean forDescribeParameterEncryption, Boolean shouldCacheForAlwaysEncrypted); at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async, Int32 timeout, Task& task, Boolean asyncWrite, Boolean inRetry, SqlDataReader ds, Boolean describeParameterEncryptionRequest); at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, TaskCompletionSource`1 completion, Int32 timeout, Task& task, Boolean& usedCache, Boolean asyncWrite, Boolean inRetry); at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method); at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior, String method); at System.Data.Common.DbDataAdapter.FillInternal(DataSet dataset, DataTable[] datatables, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior); at System.Data.Common.DbDataAdapter.Fill(DataTable[] dataTables, Int32 startRecord, Int32 maxRecords, IDbCommand command, CommandBehavior behavior); at System.Data.Common.DbDataAdapter.Fill(DataTable dataTable); at Virmati.Banking.CBS.CBSData.DataCommon.OpenDataTable(String strSQL, String TableName, Boolean pCloseConn) 07:35:33 PM Virmati.Banking.CBS.CBSData.dCustomer.GetRecord --> DataCommon.OpenDataTable -SELECT Code,BranchCode,CustomerType,Title,Name,ShortName,BirthDate,AnniversaryDate,Sex,ResAddress1,ResAddress2,ResAddress3,ResCity,ResPin,ResPhone1,ResPhone2,ResFax,Office,Designation,OfficeAddress1,OfficeAddress2,OfficeAddress3,OffCity,OffPin,OffPhone1,OffPhone2,OffFax,EmailID,Web,CellPhone,Membertype,GroupNo,PAN,BSRCode,Limit,Category,Country,Constitution,NRI,Classification,Occupation,Location,Minor,Staff,ITCode,Joint,PassportNumber,PassportIssueDate,PassportExpiryDate,PassportIssuePlace,ContactPerson,ContactAddress1,ContactAddress2,ContactAddress3,ContactCity,ContactPin,ContactPhoneNo,VIP,Status,EnqTerminalAllowed,EnqTerminalPassword,TeleBankingAllowed,TeleBankingPassword,EBankAllowed,EBankPassword,ATMAllowed,ATMPassword,WAPAllowed,WAPPassword,RATAllowed,RATPassword,CreditCardAllowed,CreditCardType,CreditCardIssueBy,CreditCardExpiryDate,TDSGroup,ModifyDate,Operator,Supervisor,Authorised,IntGracePrd,EmpID,RegistrationNo,RegistrationDate,CreditGrade,CapAdqCode,GuardianCustNo,GuardianName,IsMember,MemberNo,NoofShares,Death,DeathDate,DeathCertRcd,DeathRemarks,DeathInstrOpr,Insolvent,InsolventDate,InsolventInstrOpr,IsNPA,NPADate,NPARevDate,LicenceNo,IdentityNo,TDS,TDSReason,StatementInd,StatementFrq,CorrEmail,BaseType,AuthorityToOperate,ReqdCapital,TotalValueOfShares,ShareCapitalPattern,FundedCapital,NonFundedCapital,OpenDate,CustomerRemarks,CorrectionOpr,CorrectionSpr,Religion,Caste,ResCityCode,CorrCityCode,SeniorCitizen,RefAcno,MembershipDate,MemberFees,BiLingApplicable,DefaultLanguage,TotalMember,FatherName,AppointmentDate,RetirementDate,EmpStatus,LegalStatus,Nature,Term,Period,SocietyCustNo,COPMode,AreaCode,TalukaCode,DistrictCode,StateCode,ExRBICode,ImRBICode,PREFIBUSERID,ExpImpCode,HighNetWrt,CellProvider1,CellProvider2,CellNo1,CellNo2,TransEmailID,NPACode,CustNameType,Marital,AnnualIncome,CitizenID,FirmBranch,PlaceIncorporated,PlaceRegistration,STaxRegistration,ExciseTaxRegistration,DateOfRegistration,IsBlackListed,RelationMinor,ElectroCard,MemorandumArticles,ManageBy,IsSeniorCitizen,SeniorCitizenMarkDate,GRANDFATHER,CAMSCustNo,MajharaCode,SBTaxRatePattern,CustStatus,Purpose,Sector,CHealth,ChmName,ChmAdd1,ChmAdd2,ChmAdd3,ChmCity,ChmPin,ChmFromDate,ChmToDate,SecName,SecAdd1,SecAdd2,SecAdd3,SecCity,SecPin,SecFromDate,SecToDate,VisaNo,VisaCountry,VisaIsuueDate,VisaExpiryDate,VisaType,IsInoperative,InOperativeDate,LastAcCloseDate,CustAge,BussinessRegType,BussinessRegNo,CustHealth,IsMemberNominal,EmpStaffCategory,NPAProjectedCode,NRIType,CitizenIdIssuePlace,CitizenIdIssueDate,CitizenIdIssueExpireDate,RegistrationAuthority,turnover, Landmark, Perlandmark, Officelandmark,PEP,AnnualIncomeCurrency,TurnOverCurrency,TurnOverFreq,ReferenceBy,RiskCategory,EmailAllowed,IsSuspicious,lifestyle,MotherMaidenName,CommunicationLanguage,AadharNumber,RiskScore FROM Customer WHERE Code = 633226 --> .Net SqlClient Data Provider --> --> Execution Timeout Expired. The timeout period elapsed prior to completion of the operation or the server is not responding. at Virmati.Banking.CBS.CBSData.DataCommon.OpenDataTable(String strSQL, String TableName, Boolean pCloseConn); at Virmati.Banking.CBS.CBSData.dCustomer.GetRecord(Int32& CustomerCode, String& sQuery) 07:36:51 PM DataCommon.OpenDataTable -Select TOP 1 YearEndDate,QuarterEndingDate,HalfYearEndingDate,SIChgRecAcno,Chqpg1,Chqpg2,Chqpg3,Chqpg4,Chqpg5,DrBalanceTransferToGL,LapseBCTransferToHO,NoOfDayForFdToSbTransfer,LastBalTransferDate,NextBalTransferDate,IBRPrinting,ScheduleAsperTable,IBITAsperTable,GenerateCOTTrn,SIMinimumCharges,InwardClgRetGLAc,BillsRecvGLAc,ClearingType1GLAc,ClearingType2GLAc,ClearingType3GLAc,ClearingType4GLAc,ClearingType5GLAc,ClearingType6GLAc,HomeClgGLAc,ReturnChgPLAc,HOGLAc,TDCashLimit,LoanRepPattern,WorkingDate,TotalLimitForSanction,PenalCapRate,SystemLock,MutipleCreditGLAcForClg,FDStockInventoryInd,PANCashAmount,PANNoRequired,SeniorCitizenAge,PLRAutoPick,ABBGLAccount,DBBackupPath,DraftInitYearEndGLAcno,PLInitYearEndGLAcno,BaseCurrency,TellerGLAcEntryReqd,CustGuaranteeLineReqd,FirstMthTrnTableName,FirstMthTrnLastTrnDate,EbankingPinDuration,SIPriority,CustomerKYC,ShowSecondDate,IsTransactionImageRequired,CustAditionalInfo,BrReqdForHOChqStkIssue,BankNature,CustAuthoNotReq,custcrline,onlinevoucherprint,DPChkRenewal,RBICode,ECSMandateReq,AllowTrnWithoutChqNo,TellerLimitmaintenance,EmptyCashier,VaultMaintenanceReqd,UserMaxLoginAttempts,OtherDepInTDCashLimit,showplintrialbalance,npaonline ,InwClgMultipleAcInvalid,AllowCashDepCharge,ExcludeChgVchForMinBalChg,MinBalChgOnDebitOnly,MinBalOnDayBegin,SIExecuteOn,LimitGracePeriod,UseReportServer,NotDispIntProVch,UseMobileServer,AllowInCompleteTrfBatch,CalcNPAAcTypeWise,DPChkStockRenewal,DoNotReverseDeletedChqBook,CrPatternCompWithCust,RTGSInterfaceBranch,CustLimit,SecurePer,UnSecurePer,NPAIntvoucherNotReq,AcTypeWisechg,ChequeAlphaRequired,DormantNotAllowed,CustDocumentCheck,NotDispLimitExp,TreasuryDayEndApplicable,TreasurySystemLock,ECSFromServiceBr,ISMASLive,SigWithCust,photosignsizelmt,ValidateBlackListedCust,GLPLCashTranDivertReq,ScheduleNoAsPerMaster,directAcOpen,NotUpdMinBalOnChqIss,ForexDayEndApplicable,ForexSystemLock,CheckBalForPendChrg ,AckForTelToTelTrf,DualAuthoReq,ALLOWSBForRDPost,DualAuthoReqFORGLPLTRF,chqValidPeriod,UserDisabPeriod,StaticTerminals,AMLOnline,dualauthoReqForSuspTrn,CAMSSystemLock,CAMSDayEndApplicable,InsuranceSystemLock,InsuranceDayEndApplicable,ChangeRiskCategory,ChqpgList From BankParameters --> .Net SqlClient Data Provider --> --> Execution Timeout Expired. The timeout period elapsed prior to completion of the operation or the server is not responding., ConnectionString = "Server=VCBDB3\VCBLDB;Database=newcbsvcb", Table = "BankParameters" 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.TdsParserStateObject.ReadSniError(TdsParserStateObject stateObj, UInt32 error); at System.Data.SqlClient.TdsParserStateObject.ReadSniSyncOverAsync(); at System.Data.SqlClient.TdsParserStateObject.TryReadNetworkPacket(); at System.Data.SqlClient.TdsParserStateObject.TryPrepareBuffer(); at System.Data.SqlClient.TdsParserStateObject.TryReadByte(Byte& value); at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady); at System.Data.SqlClient.SqlDataReader.TryConsumeMetaData(); at System.Data.SqlClient.SqlDataReader.get_MetaData(); at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString, Boolean isInternal, Boolean forDescribeParameterEncryption, Boolean shouldCacheForAlwaysEncrypted); at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async, Int32 timeout, Task& task, Boolean asyncWrite, Boolean inRetry, SqlDataReader ds, Boolean describeParameterEncryptionRequest); at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, TaskCompletionSource`1 completion, Int32 timeout, Task& task, Boolean& usedCache, Boolean asyncWrite, Boolean inRetry); at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method); at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior, String method); at System.Data.Common.DbDataAdapter.FillInternal(DataSet dataset, DataTable[] datatables, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior); at System.Data.Common.DbDataAdapter.Fill(DataTable[] dataTables, Int32 startRecord, Int32 maxRecords, IDbCommand command, CommandBehavior behavior); at System.Data.Common.DbDataAdapter.Fill(DataTable dataTable); at Virmati.Banking.CBS.CBSData.DataCommon.OpenDataTable(String strSQL, String TableName, Boolean pCloseConn) 07:36:51 PM Virmati.Banking.CBS.CBSData.dBankParameters.GetRecord --> DataCommon.OpenDataTable -Select TOP 1 YearEndDate,QuarterEndingDate,HalfYearEndingDate,SIChgRecAcno,Chqpg1,Chqpg2,Chqpg3,Chqpg4,Chqpg5,DrBalanceTransferToGL,LapseBCTransferToHO,NoOfDayForFdToSbTransfer,LastBalTransferDate,NextBalTransferDate,IBRPrinting,ScheduleAsperTable,IBITAsperTable,GenerateCOTTrn,SIMinimumCharges,InwardClgRetGLAc,BillsRecvGLAc,ClearingType1GLAc,ClearingType2GLAc,ClearingType3GLAc,ClearingType4GLAc,ClearingType5GLAc,ClearingType6GLAc,HomeClgGLAc,ReturnChgPLAc,HOGLAc,TDCashLimit,LoanRepPattern,WorkingDate,TotalLimitForSanction,PenalCapRate,SystemLock,MutipleCreditGLAcForClg,FDStockInventoryInd,PANCashAmount,PANNoRequired,SeniorCitizenAge,PLRAutoPick,ABBGLAccount,DBBackupPath,DraftInitYearEndGLAcno,PLInitYearEndGLAcno,BaseCurrency,TellerGLAcEntryReqd,CustGuaranteeLineReqd,FirstMthTrnTableName,FirstMthTrnLastTrnDate,EbankingPinDuration,SIPriority,CustomerKYC,ShowSecondDate,IsTransactionImageRequired,CustAditionalInfo,BrReqdForHOChqStkIssue,BankNature,CustAuthoNotReq,custcrline,onlinevoucherprint,DPChkRenewal,RBICode,ECSMandateReq,AllowTrnWithoutChqNo,TellerLimitmaintenance,EmptyCashier,VaultMaintenanceReqd,UserMaxLoginAttempts,OtherDepInTDCashLimit,showplintrialbalance,npaonline ,InwClgMultipleAcInvalid,AllowCashDepCharge,ExcludeChgVchForMinBalChg,MinBalChgOnDebitOnly,MinBalOnDayBegin,SIExecuteOn,LimitGracePeriod,UseReportServer,NotDispIntProVch,UseMobileServer,AllowInCompleteTrfBatch,CalcNPAAcTypeWise,DPChkStockRenewal,DoNotReverseDeletedChqBook,CrPatternCompWithCust,RTGSInterfaceBranch,CustLimit,SecurePer,UnSecurePer,NPAIntvoucherNotReq,AcTypeWisechg,ChequeAlphaRequired,DormantNotAllowed,CustDocumentCheck,NotDispLimitExp,TreasuryDayEndApplicable,TreasurySystemLock,ECSFromServiceBr,ISMASLive,SigWithCust,photosignsizelmt,ValidateBlackListedCust,GLPLCashTranDivertReq,ScheduleNoAsPerMaster,directAcOpen,NotUpdMinBalOnChqIss,ForexDayEndApplicable,ForexSystemLock,CheckBalForPendChrg ,AckForTelToTelTrf,DualAuthoReq,ALLOWSBForRDPost,DualAuthoReqFORGLPLTRF,chqValidPeriod,UserDisabPeriod,StaticTerminals,AMLOnline,dualauthoReqForSuspTrn,CAMSSystemLock,CAMSDayEndApplicable,InsuranceSystemLock,InsuranceDayEndApplicable,ChangeRiskCategory,ChqpgList From BankParameters --> .Net SqlClient Data Provider --> --> Execution Timeout Expired. The timeout period elapsed prior to completion of the operation or the server is not responding. at Virmati.Banking.CBS.CBSData.DataCommon.OpenDataTable(String strSQL, String TableName, Boolean pCloseConn); at Virmati.Banking.CBS.CBSData.dBankParameters.GetRecord(Object& sQuery)