08:06:09 PM DataCommon.cnOpen --> .Net SqlClient Data Provider --> --> Connection Timeout Expired. The timeout period elapsed while attempting to consume the pre-login handshake acknowledgement. This could be because the pre-login handshake failed or the server was unable to respond back in time. The duration spent while attempting to connect to this server was - [Pre-Login] initialization=840; handshake=14273; at System.Data.SqlClient.SqlInternalConnectionTds..ctor(DbConnectionPoolIdentity identity, SqlConnectionString connectionOptions, SqlCredential credential, Object providerInfo, String newPassword, SecureString newSecurePassword, Boolean redirectedUserInstance, SqlConnectionString userConnectionOptions, SessionData reconnectSessionData, DbConnectionPool pool, String accessToken, Boolean applyTransientFaultHandling, SqlAuthenticationProviderManager sqlAuthProviderManager); at System.Data.SqlClient.SqlConnectionFactory.CreateConnection(DbConnectionOptions options, DbConnectionPoolKey poolKey, Object poolGroupProviderInfo, DbConnectionPool pool, DbConnection owningConnection, DbConnectionOptions userOptions); at System.Data.ProviderBase.DbConnectionFactory.CreatePooledConnection(DbConnectionPool pool, DbConnection owningObject, DbConnectionOptions options, DbConnectionPoolKey poolKey, DbConnectionOptions userOptions); at System.Data.ProviderBase.DbConnectionPool.CreateObject(DbConnection owningObject, DbConnectionOptions userOptions, DbConnectionInternal oldConnection); at System.Data.ProviderBase.DbConnectionPool.UserCreateRequest(DbConnection owningObject, DbConnectionOptions userOptions, DbConnectionInternal oldConnection); at System.Data.ProviderBase.DbConnectionPool.TryGetConnection(DbConnection owningObject, UInt32 waitForMultipleObjectsTimeout, Boolean allowCreate, Boolean onlyOneCheckConnection, DbConnectionOptions userOptions, DbConnectionInternal& connection); at System.Data.ProviderBase.DbConnectionPool.TryGetConnection(DbConnection owningObject, TaskCompletionSource`1 retry, DbConnectionOptions userOptions, DbConnectionInternal& connection); at System.Data.ProviderBase.DbConnectionFactory.TryGetConnection(DbConnection owningConnection, TaskCompletionSource`1 retry, DbConnectionOptions userOptions, DbConnectionInternal oldConnection, DbConnectionInternal& connection); at System.Data.ProviderBase.DbConnectionInternal.TryOpenConnectionInternal(DbConnection outerConnection, DbConnectionFactory connectionFactory, TaskCompletionSource`1 retry, DbConnectionOptions userOptions); at System.Data.SqlClient.SqlConnection.TryOpenInner(TaskCompletionSource`1 retry); at System.Data.SqlClient.SqlConnection.TryOpen(TaskCompletionSource`1 retry); at System.Data.SqlClient.SqlConnection.Open(); at Virmati.Banking.CBS.CBSData.DataCommon.cnOpen() 08:06:09 PM DataCommon.OpenDataTable -SELECT BranchCode,Acno,Actype,BaseType,CustomerNumber,Name,OpeningDate,Ledger,Status,OperationMode,OpeningBalance,StatementFrequency,StatementDate,Operator,Supervisor,Authorised,ClosingDate,StatementInd,IsInActive,InActiveDate,InActiveUptoDate,AutoReActive,ReActiveDate,GeneralDetProccess,JointProcess,NomineesProcess,SignatoriesProcess,RemarksProcess,PowerofAttProcess,StatCodesProcess,LimitSecProcess,SuretyProcess,LoanDetailsProcess,DisbProcess,RepaySchProcess,TDLinkProcess,ChargesProcess,DrIntProcess,CrIntProcess,PenalIntProcess,PenalIntCalcProcess,AgClgIntProcess,ProcessOver,LastProcess,LastCorrectedProcess,NextStmtDate,LastCorrectionOpr,ClosingAmount,ClosingCrDr,ClosingChequeNo,ClosingChequeDate,ClosingOperator,ClosingSupervisor,ClosingTrsfAcNo,IsClosingAuthorised,OldStatus,ClosingBranch,DailyTrnNo,DailyDepositProcess,AllowAccessFromOtherBranch,ShortName,SocietyMember,SocietyAcno,CurrencyCode,IsForexAppl,EefcaCurr,EefcaPer,NetBankingAllow,NetBankingTransAllow,CombinedLimitFlag,AcnoCardNo,EntryNode,OpeningTime,AuthoNode,AuthoDateTime,IMFCode,NRBCode,IsMOF,IsMultiCurrency,BalanceVisibleLevel,SignAtAccount,isacssmof,BalanceHideForOtherBranch,CapitalAmount,BankShare,closingReason,StmtMode,DefContact,IsKYC FROM Accounts WHERE AcNo = 1004005005455 --> DataCommon.cnOpen --> .Net SqlClient Data Provider --> --> Connection Timeout Expired. The timeout period elapsed while attempting to consume the pre-login handshake acknowledgement. This could be because the pre-login handshake failed or the server was unable to respond back in time. The duration spent while attempting to connect to this server was - [Pre-Login] initialization=840; handshake=14273; , ConnectionString = "Server=VCBDB3\VCBLDB;Database=newcbsvcb", Table = "Accounts" at Virmati.Banking.CBS.CBSData.DataCommon.cnOpen(); at Virmati.Banking.CBS.CBSData.DataCommon.OpenDataTable(String strSQL, String TableName, Boolean pCloseConn) 08:06:09 PM Virmati.Banking.CBS.CBSData.dAccounts.GetRecord --> DataCommon.OpenDataTable -SELECT BranchCode,Acno,Actype,BaseType,CustomerNumber,Name,OpeningDate,Ledger,Status,OperationMode,OpeningBalance,StatementFrequency,StatementDate,Operator,Supervisor,Authorised,ClosingDate,StatementInd,IsInActive,InActiveDate,InActiveUptoDate,AutoReActive,ReActiveDate,GeneralDetProccess,JointProcess,NomineesProcess,SignatoriesProcess,RemarksProcess,PowerofAttProcess,StatCodesProcess,LimitSecProcess,SuretyProcess,LoanDetailsProcess,DisbProcess,RepaySchProcess,TDLinkProcess,ChargesProcess,DrIntProcess,CrIntProcess,PenalIntProcess,PenalIntCalcProcess,AgClgIntProcess,ProcessOver,LastProcess,LastCorrectedProcess,NextStmtDate,LastCorrectionOpr,ClosingAmount,ClosingCrDr,ClosingChequeNo,ClosingChequeDate,ClosingOperator,ClosingSupervisor,ClosingTrsfAcNo,IsClosingAuthorised,OldStatus,ClosingBranch,DailyTrnNo,DailyDepositProcess,AllowAccessFromOtherBranch,ShortName,SocietyMember,SocietyAcno,CurrencyCode,IsForexAppl,EefcaCurr,EefcaPer,NetBankingAllow,NetBankingTransAllow,CombinedLimitFlag,AcnoCardNo,EntryNode,OpeningTime,AuthoNode,AuthoDateTime,IMFCode,NRBCode,IsMOF,IsMultiCurrency,BalanceVisibleLevel,SignAtAccount,isacssmof,BalanceHideForOtherBranch,CapitalAmount,BankShare,closingReason,StmtMode,DefContact,IsKYC FROM Accounts WHERE AcNo = 1004005005455 --> DataCommon.cnOpen --> .Net SqlClient Data Provider --> --> Connection Timeout Expired. The timeout period elapsed while attempting to consume the pre-login handshake acknowledgement. This could be because the pre-login handshake failed or the server was unable to respond back in time. The duration spent while attempting to connect to this server was - [Pre-Login] initialization=840; handshake=14273; at Virmati.Banking.CBS.CBSData.DataCommon.OpenDataTable(String strSQL, String TableName, Boolean pCloseConn); at Virmati.Banking.CBS.CBSData.dAccounts.GetRecord(Int64 Acno, String& sQuery) 08:07:23 PM DataCommon.cnOpen --> .Net SqlClient Data Provider --> --> Connection Timeout Expired. The timeout period elapsed while attempting to consume the pre-login handshake acknowledgement. This could be because the pre-login handshake failed or the server was unable to respond back in time. The duration spent while attempting to connect to this server was - [Pre-Login] initialization=137; handshake=14975; at System.Data.SqlClient.SqlInternalConnectionTds..ctor(DbConnectionPoolIdentity identity, SqlConnectionString connectionOptions, SqlCredential credential, Object providerInfo, String newPassword, SecureString newSecurePassword, Boolean redirectedUserInstance, SqlConnectionString userConnectionOptions, SessionData reconnectSessionData, DbConnectionPool pool, String accessToken, Boolean applyTransientFaultHandling, SqlAuthenticationProviderManager sqlAuthProviderManager); at System.Data.SqlClient.SqlConnectionFactory.CreateConnection(DbConnectionOptions options, DbConnectionPoolKey poolKey, Object poolGroupProviderInfo, DbConnectionPool pool, DbConnection owningConnection, DbConnectionOptions userOptions); at System.Data.ProviderBase.DbConnectionFactory.CreatePooledConnection(DbConnectionPool pool, DbConnection owningObject, DbConnectionOptions options, DbConnectionPoolKey poolKey, DbConnectionOptions userOptions); at System.Data.ProviderBase.DbConnectionPool.CreateObject(DbConnection owningObject, DbConnectionOptions userOptions, DbConnectionInternal oldConnection); at System.Data.ProviderBase.DbConnectionPool.UserCreateRequest(DbConnection owningObject, DbConnectionOptions userOptions, DbConnectionInternal oldConnection); at System.Data.ProviderBase.DbConnectionPool.TryGetConnection(DbConnection owningObject, UInt32 waitForMultipleObjectsTimeout, Boolean allowCreate, Boolean onlyOneCheckConnection, DbConnectionOptions userOptions, DbConnectionInternal& connection); at System.Data.ProviderBase.DbConnectionPool.TryGetConnection(DbConnection owningObject, TaskCompletionSource`1 retry, DbConnectionOptions userOptions, DbConnectionInternal& connection); at System.Data.ProviderBase.DbConnectionFactory.TryGetConnection(DbConnection owningConnection, TaskCompletionSource`1 retry, DbConnectionOptions userOptions, DbConnectionInternal oldConnection, DbConnectionInternal& connection); at System.Data.ProviderBase.DbConnectionInternal.TryOpenConnectionInternal(DbConnection outerConnection, DbConnectionFactory connectionFactory, TaskCompletionSource`1 retry, DbConnectionOptions userOptions); at System.Data.SqlClient.SqlConnection.TryOpenInner(TaskCompletionSource`1 retry); at System.Data.SqlClient.SqlConnection.TryOpen(TaskCompletionSource`1 retry); at System.Data.SqlClient.SqlConnection.Open(); at Virmati.Banking.CBS.CBSData.DataCommon.cnOpen() 08:07:23 PM DataCommon.OpenDataTable -SELECT BranchCode,Acno,Actype,BaseType,CustomerNumber,Name,OpeningDate,Ledger,Status,OperationMode,OpeningBalance,StatementFrequency,StatementDate,Operator,Supervisor,Authorised,ClosingDate,StatementInd,IsInActive,InActiveDate,InActiveUptoDate,AutoReActive,ReActiveDate,GeneralDetProccess,JointProcess,NomineesProcess,SignatoriesProcess,RemarksProcess,PowerofAttProcess,StatCodesProcess,LimitSecProcess,SuretyProcess,LoanDetailsProcess,DisbProcess,RepaySchProcess,TDLinkProcess,ChargesProcess,DrIntProcess,CrIntProcess,PenalIntProcess,PenalIntCalcProcess,AgClgIntProcess,ProcessOver,LastProcess,LastCorrectedProcess,NextStmtDate,LastCorrectionOpr,ClosingAmount,ClosingCrDr,ClosingChequeNo,ClosingChequeDate,ClosingOperator,ClosingSupervisor,ClosingTrsfAcNo,IsClosingAuthorised,OldStatus,ClosingBranch,DailyTrnNo,DailyDepositProcess,AllowAccessFromOtherBranch,ShortName,SocietyMember,SocietyAcno,CurrencyCode,IsForexAppl,EefcaCurr,EefcaPer,NetBankingAllow,NetBankingTransAllow,CombinedLimitFlag,AcnoCardNo,EntryNode,OpeningTime,AuthoNode,AuthoDateTime,IMFCode,NRBCode,IsMOF,IsMultiCurrency,BalanceVisibleLevel,SignAtAccount,isacssmof,BalanceHideForOtherBranch,CapitalAmount,BankShare,closingReason,StmtMode,DefContact,IsKYC FROM Accounts WHERE AcNo = 1004005005455 --> DataCommon.cnOpen --> .Net SqlClient Data Provider --> --> Connection Timeout Expired. The timeout period elapsed while attempting to consume the pre-login handshake acknowledgement. This could be because the pre-login handshake failed or the server was unable to respond back in time. The duration spent while attempting to connect to this server was - [Pre-Login] initialization=137; handshake=14975; , ConnectionString = "Server=VCBDB3\VCBLDB;Database=newcbsvcb", Table = "Accounts" at Virmati.Banking.CBS.CBSData.DataCommon.cnOpen(); at Virmati.Banking.CBS.CBSData.DataCommon.OpenDataTable(String strSQL, String TableName, Boolean pCloseConn) 08:07:23 PM Virmati.Banking.CBS.CBSData.dAccounts.GetRecord --> DataCommon.OpenDataTable -SELECT BranchCode,Acno,Actype,BaseType,CustomerNumber,Name,OpeningDate,Ledger,Status,OperationMode,OpeningBalance,StatementFrequency,StatementDate,Operator,Supervisor,Authorised,ClosingDate,StatementInd,IsInActive,InActiveDate,InActiveUptoDate,AutoReActive,ReActiveDate,GeneralDetProccess,JointProcess,NomineesProcess,SignatoriesProcess,RemarksProcess,PowerofAttProcess,StatCodesProcess,LimitSecProcess,SuretyProcess,LoanDetailsProcess,DisbProcess,RepaySchProcess,TDLinkProcess,ChargesProcess,DrIntProcess,CrIntProcess,PenalIntProcess,PenalIntCalcProcess,AgClgIntProcess,ProcessOver,LastProcess,LastCorrectedProcess,NextStmtDate,LastCorrectionOpr,ClosingAmount,ClosingCrDr,ClosingChequeNo,ClosingChequeDate,ClosingOperator,ClosingSupervisor,ClosingTrsfAcNo,IsClosingAuthorised,OldStatus,ClosingBranch,DailyTrnNo,DailyDepositProcess,AllowAccessFromOtherBranch,ShortName,SocietyMember,SocietyAcno,CurrencyCode,IsForexAppl,EefcaCurr,EefcaPer,NetBankingAllow,NetBankingTransAllow,CombinedLimitFlag,AcnoCardNo,EntryNode,OpeningTime,AuthoNode,AuthoDateTime,IMFCode,NRBCode,IsMOF,IsMultiCurrency,BalanceVisibleLevel,SignAtAccount,isacssmof,BalanceHideForOtherBranch,CapitalAmount,BankShare,closingReason,StmtMode,DefContact,IsKYC FROM Accounts WHERE AcNo = 1004005005455 --> DataCommon.cnOpen --> .Net SqlClient Data Provider --> --> Connection Timeout Expired. The timeout period elapsed while attempting to consume the pre-login handshake acknowledgement. This could be because the pre-login handshake failed or the server was unable to respond back in time. The duration spent while attempting to connect to this server was - [Pre-Login] initialization=137; handshake=14975; at Virmati.Banking.CBS.CBSData.DataCommon.OpenDataTable(String strSQL, String TableName, Boolean pCloseConn); at Virmati.Banking.CBS.CBSData.dAccounts.GetRecord(Int64 Acno, String& sQuery) 08:08:45 PM DataCommon.cnOpen --> .Net SqlClient Data Provider --> --> Connection Timeout Expired. The timeout period elapsed while attempting to consume the pre-login handshake acknowledgement. This could be because the pre-login handshake failed or the server was unable to respond back in time. The duration spent while attempting to connect to this server was - [Pre-Login] initialization=128; handshake=14976; at System.Data.SqlClient.SqlInternalConnectionTds..ctor(DbConnectionPoolIdentity identity, SqlConnectionString connectionOptions, SqlCredential credential, Object providerInfo, String newPassword, SecureString newSecurePassword, Boolean redirectedUserInstance, SqlConnectionString userConnectionOptions, SessionData reconnectSessionData, DbConnectionPool pool, String accessToken, Boolean applyTransientFaultHandling, SqlAuthenticationProviderManager sqlAuthProviderManager); at System.Data.SqlClient.SqlConnectionFactory.CreateConnection(DbConnectionOptions options, DbConnectionPoolKey poolKey, Object poolGroupProviderInfo, DbConnectionPool pool, DbConnection owningConnection, DbConnectionOptions userOptions); at System.Data.ProviderBase.DbConnectionFactory.CreatePooledConnection(DbConnectionPool pool, DbConnection owningObject, DbConnectionOptions options, DbConnectionPoolKey poolKey, DbConnectionOptions userOptions); at System.Data.ProviderBase.DbConnectionPool.CreateObject(DbConnection owningObject, DbConnectionOptions userOptions, DbConnectionInternal oldConnection); at System.Data.ProviderBase.DbConnectionPool.UserCreateRequest(DbConnection owningObject, DbConnectionOptions userOptions, DbConnectionInternal oldConnection); at System.Data.ProviderBase.DbConnectionPool.TryGetConnection(DbConnection owningObject, UInt32 waitForMultipleObjectsTimeout, Boolean allowCreate, Boolean onlyOneCheckConnection, DbConnectionOptions userOptions, DbConnectionInternal& connection); at System.Data.ProviderBase.DbConnectionPool.TryGetConnection(DbConnection owningObject, TaskCompletionSource`1 retry, DbConnectionOptions userOptions, DbConnectionInternal& connection); at System.Data.ProviderBase.DbConnectionFactory.TryGetConnection(DbConnection owningConnection, TaskCompletionSource`1 retry, DbConnectionOptions userOptions, DbConnectionInternal oldConnection, DbConnectionInternal& connection); at System.Data.ProviderBase.DbConnectionInternal.TryOpenConnectionInternal(DbConnection outerConnection, DbConnectionFactory connectionFactory, TaskCompletionSource`1 retry, DbConnectionOptions userOptions); at System.Data.SqlClient.SqlConnection.TryOpenInner(TaskCompletionSource`1 retry); at System.Data.SqlClient.SqlConnection.TryOpen(TaskCompletionSource`1 retry); at System.Data.SqlClient.SqlConnection.Open(); at Virmati.Banking.CBS.CBSData.DataCommon.cnOpen() 08:08:45 PM DataCommon.OpenDataTable -SELECT BranchCode,Acno,Actype,BaseType,CustomerNumber,Name,OpeningDate,Ledger,Status,OperationMode,OpeningBalance,StatementFrequency,StatementDate,Operator,Supervisor,Authorised,ClosingDate,StatementInd,IsInActive,InActiveDate,InActiveUptoDate,AutoReActive,ReActiveDate,GeneralDetProccess,JointProcess,NomineesProcess,SignatoriesProcess,RemarksProcess,PowerofAttProcess,StatCodesProcess,LimitSecProcess,SuretyProcess,LoanDetailsProcess,DisbProcess,RepaySchProcess,TDLinkProcess,ChargesProcess,DrIntProcess,CrIntProcess,PenalIntProcess,PenalIntCalcProcess,AgClgIntProcess,ProcessOver,LastProcess,LastCorrectedProcess,NextStmtDate,LastCorrectionOpr,ClosingAmount,ClosingCrDr,ClosingChequeNo,ClosingChequeDate,ClosingOperator,ClosingSupervisor,ClosingTrsfAcNo,IsClosingAuthorised,OldStatus,ClosingBranch,DailyTrnNo,DailyDepositProcess,AllowAccessFromOtherBranch,ShortName,SocietyMember,SocietyAcno,CurrencyCode,IsForexAppl,EefcaCurr,EefcaPer,NetBankingAllow,NetBankingTransAllow,CombinedLimitFlag,AcnoCardNo,EntryNode,OpeningTime,AuthoNode,AuthoDateTime,IMFCode,NRBCode,IsMOF,IsMultiCurrency,BalanceVisibleLevel,SignAtAccount,isacssmof,BalanceHideForOtherBranch,CapitalAmount,BankShare,closingReason,StmtMode,DefContact,IsKYC FROM Accounts WHERE AcNo = 1004005005455 --> DataCommon.cnOpen --> .Net SqlClient Data Provider --> --> Connection Timeout Expired. The timeout period elapsed while attempting to consume the pre-login handshake acknowledgement. This could be because the pre-login handshake failed or the server was unable to respond back in time. The duration spent while attempting to connect to this server was - [Pre-Login] initialization=128; handshake=14976; , ConnectionString = "Server=VCBDB3\VCBLDB;Database=newcbsvcb", Table = "Accounts" at Virmati.Banking.CBS.CBSData.DataCommon.cnOpen(); at Virmati.Banking.CBS.CBSData.DataCommon.OpenDataTable(String strSQL, String TableName, Boolean pCloseConn) 08:08:45 PM Virmati.Banking.CBS.CBSData.dAccounts.GetRecord --> DataCommon.OpenDataTable -SELECT BranchCode,Acno,Actype,BaseType,CustomerNumber,Name,OpeningDate,Ledger,Status,OperationMode,OpeningBalance,StatementFrequency,StatementDate,Operator,Supervisor,Authorised,ClosingDate,StatementInd,IsInActive,InActiveDate,InActiveUptoDate,AutoReActive,ReActiveDate,GeneralDetProccess,JointProcess,NomineesProcess,SignatoriesProcess,RemarksProcess,PowerofAttProcess,StatCodesProcess,LimitSecProcess,SuretyProcess,LoanDetailsProcess,DisbProcess,RepaySchProcess,TDLinkProcess,ChargesProcess,DrIntProcess,CrIntProcess,PenalIntProcess,PenalIntCalcProcess,AgClgIntProcess,ProcessOver,LastProcess,LastCorrectedProcess,NextStmtDate,LastCorrectionOpr,ClosingAmount,ClosingCrDr,ClosingChequeNo,ClosingChequeDate,ClosingOperator,ClosingSupervisor,ClosingTrsfAcNo,IsClosingAuthorised,OldStatus,ClosingBranch,DailyTrnNo,DailyDepositProcess,AllowAccessFromOtherBranch,ShortName,SocietyMember,SocietyAcno,CurrencyCode,IsForexAppl,EefcaCurr,EefcaPer,NetBankingAllow,NetBankingTransAllow,CombinedLimitFlag,AcnoCardNo,EntryNode,OpeningTime,AuthoNode,AuthoDateTime,IMFCode,NRBCode,IsMOF,IsMultiCurrency,BalanceVisibleLevel,SignAtAccount,isacssmof,BalanceHideForOtherBranch,CapitalAmount,BankShare,closingReason,StmtMode,DefContact,IsKYC FROM Accounts WHERE AcNo = 1004005005455 --> DataCommon.cnOpen --> .Net SqlClient Data Provider --> --> Connection Timeout Expired. The timeout period elapsed while attempting to consume the pre-login handshake acknowledgement. This could be because the pre-login handshake failed or the server was unable to respond back in time. The duration spent while attempting to connect to this server was - [Pre-Login] initialization=128; handshake=14976; at Virmati.Banking.CBS.CBSData.DataCommon.OpenDataTable(String strSQL, String TableName, Boolean pCloseConn); at Virmati.Banking.CBS.CBSData.dAccounts.GetRecord(Int64 Acno, String& sQuery) 08:10:01 PM DataCommon.cnOpen --> .Net SqlClient Data Provider --> --> Connection Timeout Expired. The timeout period elapsed while attempting to consume the pre-login handshake acknowledgement. This could be because the pre-login handshake failed or the server was unable to respond back in time. The duration spent while attempting to connect to this server was - [Pre-Login] initialization=64; handshake=14972; at System.Data.SqlClient.SqlInternalConnectionTds..ctor(DbConnectionPoolIdentity identity, SqlConnectionString connectionOptions, SqlCredential credential, Object providerInfo, String newPassword, SecureString newSecurePassword, Boolean redirectedUserInstance, SqlConnectionString userConnectionOptions, SessionData reconnectSessionData, DbConnectionPool pool, String accessToken, Boolean applyTransientFaultHandling, SqlAuthenticationProviderManager sqlAuthProviderManager); at System.Data.SqlClient.SqlConnectionFactory.CreateConnection(DbConnectionOptions options, DbConnectionPoolKey poolKey, Object poolGroupProviderInfo, DbConnectionPool pool, DbConnection owningConnection, DbConnectionOptions userOptions); at System.Data.ProviderBase.DbConnectionFactory.CreatePooledConnection(DbConnectionPool pool, DbConnection owningObject, DbConnectionOptions options, DbConnectionPoolKey poolKey, DbConnectionOptions userOptions); at System.Data.ProviderBase.DbConnectionPool.CreateObject(DbConnection owningObject, DbConnectionOptions userOptions, DbConnectionInternal oldConnection); at System.Data.ProviderBase.DbConnectionPool.UserCreateRequest(DbConnection owningObject, DbConnectionOptions userOptions, DbConnectionInternal oldConnection); at System.Data.ProviderBase.DbConnectionPool.TryGetConnection(DbConnection owningObject, UInt32 waitForMultipleObjectsTimeout, Boolean allowCreate, Boolean onlyOneCheckConnection, DbConnectionOptions userOptions, DbConnectionInternal& connection); at System.Data.ProviderBase.DbConnectionPool.TryGetConnection(DbConnection owningObject, TaskCompletionSource`1 retry, DbConnectionOptions userOptions, DbConnectionInternal& connection); at System.Data.ProviderBase.DbConnectionFactory.TryGetConnection(DbConnection owningConnection, TaskCompletionSource`1 retry, DbConnectionOptions userOptions, DbConnectionInternal oldConnection, DbConnectionInternal& connection); at System.Data.ProviderBase.DbConnectionInternal.TryOpenConnectionInternal(DbConnection outerConnection, DbConnectionFactory connectionFactory, TaskCompletionSource`1 retry, DbConnectionOptions userOptions); at System.Data.SqlClient.SqlConnection.TryOpenInner(TaskCompletionSource`1 retry); at System.Data.SqlClient.SqlConnection.TryOpen(TaskCompletionSource`1 retry); at System.Data.SqlClient.SqlConnection.Open(); at Virmati.Banking.CBS.CBSData.DataCommon.cnOpen() 08:10:01 PM DataCommon.OpenDataTable -SELECT BranchCode,Acno,Actype,BaseType,CustomerNumber,Name,OpeningDate,Ledger,Status,OperationMode,OpeningBalance,StatementFrequency,StatementDate,Operator,Supervisor,Authorised,ClosingDate,StatementInd,IsInActive,InActiveDate,InActiveUptoDate,AutoReActive,ReActiveDate,GeneralDetProccess,JointProcess,NomineesProcess,SignatoriesProcess,RemarksProcess,PowerofAttProcess,StatCodesProcess,LimitSecProcess,SuretyProcess,LoanDetailsProcess,DisbProcess,RepaySchProcess,TDLinkProcess,ChargesProcess,DrIntProcess,CrIntProcess,PenalIntProcess,PenalIntCalcProcess,AgClgIntProcess,ProcessOver,LastProcess,LastCorrectedProcess,NextStmtDate,LastCorrectionOpr,ClosingAmount,ClosingCrDr,ClosingChequeNo,ClosingChequeDate,ClosingOperator,ClosingSupervisor,ClosingTrsfAcNo,IsClosingAuthorised,OldStatus,ClosingBranch,DailyTrnNo,DailyDepositProcess,AllowAccessFromOtherBranch,ShortName,SocietyMember,SocietyAcno,CurrencyCode,IsForexAppl,EefcaCurr,EefcaPer,NetBankingAllow,NetBankingTransAllow,CombinedLimitFlag,AcnoCardNo,EntryNode,OpeningTime,AuthoNode,AuthoDateTime,IMFCode,NRBCode,IsMOF,IsMultiCurrency,BalanceVisibleLevel,SignAtAccount,isacssmof,BalanceHideForOtherBranch,CapitalAmount,BankShare,closingReason,StmtMode,DefContact,IsKYC FROM Accounts WHERE AcNo = 1004005005455 --> DataCommon.cnOpen --> .Net SqlClient Data Provider --> --> Connection Timeout Expired. The timeout period elapsed while attempting to consume the pre-login handshake acknowledgement. This could be because the pre-login handshake failed or the server was unable to respond back in time. The duration spent while attempting to connect to this server was - [Pre-Login] initialization=64; handshake=14972; , ConnectionString = "Server=VCBDB3\VCBLDB;Database=newcbsvcb", Table = "Accounts" at Virmati.Banking.CBS.CBSData.DataCommon.cnOpen(); at Virmati.Banking.CBS.CBSData.DataCommon.OpenDataTable(String strSQL, String TableName, Boolean pCloseConn) 08:10:01 PM Virmati.Banking.CBS.CBSData.dAccounts.GetRecord --> DataCommon.OpenDataTable -SELECT BranchCode,Acno,Actype,BaseType,CustomerNumber,Name,OpeningDate,Ledger,Status,OperationMode,OpeningBalance,StatementFrequency,StatementDate,Operator,Supervisor,Authorised,ClosingDate,StatementInd,IsInActive,InActiveDate,InActiveUptoDate,AutoReActive,ReActiveDate,GeneralDetProccess,JointProcess,NomineesProcess,SignatoriesProcess,RemarksProcess,PowerofAttProcess,StatCodesProcess,LimitSecProcess,SuretyProcess,LoanDetailsProcess,DisbProcess,RepaySchProcess,TDLinkProcess,ChargesProcess,DrIntProcess,CrIntProcess,PenalIntProcess,PenalIntCalcProcess,AgClgIntProcess,ProcessOver,LastProcess,LastCorrectedProcess,NextStmtDate,LastCorrectionOpr,ClosingAmount,ClosingCrDr,ClosingChequeNo,ClosingChequeDate,ClosingOperator,ClosingSupervisor,ClosingTrsfAcNo,IsClosingAuthorised,OldStatus,ClosingBranch,DailyTrnNo,DailyDepositProcess,AllowAccessFromOtherBranch,ShortName,SocietyMember,SocietyAcno,CurrencyCode,IsForexAppl,EefcaCurr,EefcaPer,NetBankingAllow,NetBankingTransAllow,CombinedLimitFlag,AcnoCardNo,EntryNode,OpeningTime,AuthoNode,AuthoDateTime,IMFCode,NRBCode,IsMOF,IsMultiCurrency,BalanceVisibleLevel,SignAtAccount,isacssmof,BalanceHideForOtherBranch,CapitalAmount,BankShare,closingReason,StmtMode,DefContact,IsKYC FROM Accounts WHERE AcNo = 1004005005455 --> DataCommon.cnOpen --> .Net SqlClient Data Provider --> --> Connection Timeout Expired. The timeout period elapsed while attempting to consume the pre-login handshake acknowledgement. This could be because the pre-login handshake failed or the server was unable to respond back in time. The duration spent while attempting to connect to this server was - [Pre-Login] initialization=64; handshake=14972; at Virmati.Banking.CBS.CBSData.DataCommon.OpenDataTable(String strSQL, String TableName, Boolean pCloseConn); at Virmati.Banking.CBS.CBSData.dAccounts.GetRecord(Int64 Acno, String& sQuery) 08:33:58 PM DataCommon.ExecuteScalar - SELECT count(*) FROM RTGSNEFTInTrn WHERE TrnRefNo = 'AXOMB21369283377' --> .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) 08:36:07 PM Virmati.Banking.CBS.CBSData.dDailytransactions.Proc_InsertDailyTrans_SP --> .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.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:36:09 PM Virmati.Banking.CBS.CBSData.dDailytransactions.Proc_InsertTrans_SP --> Virmati.Banking.CBS.CBSData.dDailytransactions.Proc_InsertDailyTrans_SP --> .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.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:36:39 PM DataCommon.OpenDataTable -select workingdate from branchmaster where code=1004 --> System.Data --> Thread was being aborted., ConnectionString = "Server=VCBDB3\VCBLDB;Database=newcbsvcb", Table = "BranchMaster" at SNIReadSyncOverAsync(SNI_ConnWrapper* , SNI_Packet** , Int32 ); at SNINativeMethodWrapper.SNIReadSyncOverAsync(SafeHandle pConn, IntPtr& packet, Int32 timeout); 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) 08:36:39 PM Virmati.Banking.CBS.CBSData.dBranchMaster.GetRecord --> DataCommon.OpenDataTable -select workingdate from branchmaster where code=1004 --> System.Data --> Thread was being aborted. at Virmati.Banking.CBS.CBSData.DataCommon.OpenDataTable(String strSQL, String TableName, Boolean pCloseConn); at Virmati.Banking.CBS.CBSData.dBranchMaster.GetRecord(Int32& BranchCode, Object& sQuery) 08:36:39 PM Virmati.Banking.CBS.CBSData.dLimitAccount.GetLimitDetailsList --> Virmati.Banking.CBS.CBSData.dBranchMaster.GetRecord --> DataCommon.OpenDataTable -select workingdate from branchmaster where code=1004 --> System.Data --> Thread was being aborted. at Virmati.Banking.CBS.CBSData.dBranchMaster.GetRecord(Int32& BranchCode, Object& sQuery); at Virmati.Banking.CBS.CBSData.dLimitAccount.GetLimitDetailsList(Double pAcno, Int32 pBranchId, Object& ForDate, Boolean mShowSecondDate, Boolean mBankNature, Boolean pDoNotCheckRenewCond) 10:31:40 PM 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) 10:31:40 PM 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)