08:31:28 AM
Virmati.Banking.CBS.CBSData.dDailytransactions.Proc_InsertDailyTrans_SP --> .Net SqlClient Data Provider --> Transaction (Process ID 73) 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:29 AM
Virmati.Banking.CBS.CBSData.dDailytransactions.Proc_InsertTrans_SP --> Virmati.Banking.CBS.CBSData.dDailytransactions.Proc_InsertDailyTrans_SP --> .Net SqlClient Data Provider --> Transaction (Process ID 73) 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)


10:15:41 PM
DataCommon.cnOpen --> .Net SqlClient Data Provider --> Cannot open database "VCBL_CBS" requested by the login. The login failed.
Login failed for user 'sa'.
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()


10:15:41 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 = 1002005004926 --> DataCommon.cnOpen --> .Net SqlClient Data Provider --> Cannot open database "VCBL_CBS" requested by the login. The login failed.
Login failed for user 'sa'., ConnectionString = "Server=20.130.10.91\TVCBLPROD;Database=VCBL_CBS", Table = "Accounts"
at Virmati.Banking.CBS.CBSData.DataCommon.cnOpen();   at Virmati.Banking.CBS.CBSData.DataCommon.OpenDataTable(String strSQL, String TableName, Boolean pCloseConn)


10:15:41 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 = 1002005004926 --> DataCommon.cnOpen --> .Net SqlClient Data Provider --> Cannot open database "VCBL_CBS" requested by the login. The login failed.
Login failed for user 'sa'.
at Virmati.Banking.CBS.CBSData.DataCommon.OpenDataTable(String strSQL, String TableName, Boolean pCloseConn);   at Virmati.Banking.CBS.CBSData.dAccounts.GetRecord(Int64 Acno, String& sQuery)


10:16:51 PM
DataCommon.cnOpen --> .Net SqlClient Data Provider --> Cannot open database "VCBL_CBS" requested by the login. The login failed.
Login failed for user 'sa'.
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()


10:16:51 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 = 1002005004926 --> DataCommon.cnOpen --> .Net SqlClient Data Provider --> Cannot open database "VCBL_CBS" requested by the login. The login failed.
Login failed for user 'sa'., ConnectionString = "Server=20.130.10.91\TVCBLPROD;Database=VCBL_CBS", Table = "Accounts"
at Virmati.Banking.CBS.CBSData.DataCommon.cnOpen();   at Virmati.Banking.CBS.CBSData.DataCommon.OpenDataTable(String strSQL, String TableName, Boolean pCloseConn)


10:16:51 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 = 1002005004926 --> DataCommon.cnOpen --> .Net SqlClient Data Provider --> Cannot open database "VCBL_CBS" requested by the login. The login failed.
Login failed for user 'sa'.
at Virmati.Banking.CBS.CBSData.DataCommon.OpenDataTable(String strSQL, String TableName, Boolean pCloseConn);   at Virmati.Banking.CBS.CBSData.dAccounts.GetRecord(Int64 Acno, String& sQuery)