10:01:40 AM
DataCommon.cnOpen --> .Net SqlClient Data Provider -->  --> A connection was successfully established with the server, but then an error occurred during the login process. (provider: SSL Provider, error: 0 - An existing connection was forcibly closed by the remote host.)
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:01:40 AM
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 = 607788 --> DataCommon.cnOpen --> .Net SqlClient Data Provider -->  --> A connection was successfully established with the server, but then an error occurred during the login process. (provider: SSL Provider, error: 0 - An existing connection was forcibly closed by the remote host.), ConnectionString = "Server=20.130.10.91\TVCBLPROD;Database=VCBL_CBS", Table = "Customer"
at Virmati.Banking.CBS.CBSData.DataCommon.cnOpen();   at Virmati.Banking.CBS.CBSData.DataCommon.OpenDataTable(String strSQL, String TableName, Boolean pCloseConn)


10:01:40 AM
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 = 607788 --> DataCommon.cnOpen --> .Net SqlClient Data Provider -->  --> A connection was successfully established with the server, but then an error occurred during the login process. (provider: SSL Provider, error: 0 - An existing connection was forcibly closed by the remote host.)
at Virmati.Banking.CBS.CBSData.DataCommon.OpenDataTable(String strSQL, String TableName, Boolean pCloseConn);   at Virmati.Banking.CBS.CBSData.dCustomer.GetRecord(Int32& CustomerCode, String& sQuery)


10:01:40 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'. The duplicate key value is (100100797, Sep 17 2024 12:00AM, 1001).
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:01:41 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'. The duplicate key value is (100100797, Sep 17 2024 12:00AM, 1001).
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:01:49 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'. The duplicate key value is (100100834, Sep 17 2024 12:00AM, 1001).
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:01:49 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'. The duplicate key value is (100100834, Sep 17 2024 12:00AM, 1001).
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)