09:01:49 AM Virmati.Banking.CBS.CBSData.dDailytransactions.Proc_InsertDailyTrans_SP --> .Net SqlClient Data Provider --> Transaction (Process ID 103) 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) 09:01:49 AM Virmati.Banking.CBS.CBSData.dDailytransactions.Proc_InsertTrans_SP --> Virmati.Banking.CBS.CBSData.dDailytransactions.Proc_InsertDailyTrans_SP --> .Net SqlClient Data Provider --> Transaction (Process ID 103) 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) 09:01:54 AM Virmati.Banking.CBS.CBSData.dDailytransactions.Proc_InsertDailyTrans_SP --> .Net SqlClient Data Provider --> Transaction (Process ID 102) 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) 09:01:54 AM Virmati.Banking.CBS.CBSData.dDailytransactions.Proc_InsertTrans_SP --> Virmati.Banking.CBS.CBSData.dDailytransactions.Proc_InsertDailyTrans_SP --> .Net SqlClient Data Provider --> Transaction (Process ID 102) 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) 09:02:00 AM Virmati.Banking.CBS.CBSData.dDailytransactions.Proc_InsertDailyTrans_SP --> .Net SqlClient Data Provider --> Transaction (Process ID 120) 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) 09:02:00 AM Virmati.Banking.CBS.CBSData.dDailytransactions.Proc_InsertTrans_SP --> Virmati.Banking.CBS.CBSData.dDailytransactions.Proc_InsertDailyTrans_SP --> .Net SqlClient Data Provider --> Transaction (Process ID 120) 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) 09:02:01 AM Virmati.Banking.CBS.CBSData.dDailytransactions.Proc_InsertDailyTrans_SP --> .Net SqlClient Data Provider --> Transaction (Process ID 118) 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) 09:02:01 AM Virmati.Banking.CBS.CBSData.dDailytransactions.Proc_InsertTrans_SP --> Virmati.Banking.CBS.CBSData.dDailytransactions.Proc_InsertDailyTrans_SP --> .Net SqlClient Data Provider --> Transaction (Process ID 118) 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) 09:02:03 AM Virmati.Banking.CBS.CBSData.dDailytransactions.Proc_InsertDailyTrans_SP --> .Net SqlClient Data Provider --> Transaction (Process ID 106) 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) 09:02:03 AM Virmati.Banking.CBS.CBSData.dDailytransactions.Proc_InsertTrans_SP --> Virmati.Banking.CBS.CBSData.dDailytransactions.Proc_InsertDailyTrans_SP --> .Net SqlClient Data Provider --> Transaction (Process ID 106) 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) 09:02:03 AM Virmati.Banking.CBS.CBSData.dDailytransactions.Proc_InsertDailyTrans_SP --> .Net SqlClient Data Provider --> Transaction (Process ID 122) 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) 09:02:03 AM Virmati.Banking.CBS.CBSData.dDailytransactions.Proc_InsertTrans_SP --> Virmati.Banking.CBS.CBSData.dDailytransactions.Proc_InsertDailyTrans_SP --> .Net SqlClient Data Provider --> Transaction (Process ID 122) 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) 09:02:04 AM Virmati.Banking.CBS.CBSData.dDailytransactions.Proc_InsertDailyTrans_SP --> .Net SqlClient Data Provider --> Transaction (Process ID 113) 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) 09:02:04 AM Virmati.Banking.CBS.CBSData.dDailytransactions.Proc_InsertTrans_SP --> Virmati.Banking.CBS.CBSData.dDailytransactions.Proc_InsertDailyTrans_SP --> .Net SqlClient Data Provider --> Transaction (Process ID 113) 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) 09:02:06 AM Virmati.Banking.CBS.CBSData.dDailytransactions.Proc_InsertDailyTrans_SP --> .Net SqlClient Data Provider --> Transaction (Process ID 103) 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) 09:02:06 AM Virmati.Banking.CBS.CBSData.dDailytransactions.Proc_InsertTrans_SP --> Virmati.Banking.CBS.CBSData.dDailytransactions.Proc_InsertDailyTrans_SP --> .Net SqlClient Data Provider --> Transaction (Process ID 103) 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) 09:02:07 AM Virmati.Banking.CBS.CBSData.dDailytransactions.Proc_InsertDailyTrans_SP --> .Net SqlClient Data Provider --> Transaction (Process ID 102) 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) 09:02:07 AM Virmati.Banking.CBS.CBSData.dDailytransactions.Proc_InsertTrans_SP --> Virmati.Banking.CBS.CBSData.dDailytransactions.Proc_InsertDailyTrans_SP --> .Net SqlClient Data Provider --> Transaction (Process ID 102) 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) 09:02:08 AM Virmati.Banking.CBS.CBSData.dDailytransactions.Proc_InsertDailyTrans_SP --> .Net SqlClient Data Provider --> Transaction (Process ID 113) 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) 09:02:08 AM Virmati.Banking.CBS.CBSData.dDailytransactions.Proc_InsertTrans_SP --> Virmati.Banking.CBS.CBSData.dDailytransactions.Proc_InsertDailyTrans_SP --> .Net SqlClient Data Provider --> Transaction (Process ID 113) 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) 09:02:12 AM Virmati.Banking.CBS.CBSData.dDailytransactions.Proc_InsertDailyTrans_SP --> .Net SqlClient Data Provider --> Transaction (Process ID 122) 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) 09:02:12 AM Virmati.Banking.CBS.CBSData.dDailytransactions.Proc_InsertTrans_SP --> Virmati.Banking.CBS.CBSData.dDailytransactions.Proc_InsertDailyTrans_SP --> .Net SqlClient Data Provider --> Transaction (Process ID 122) 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) 09:02:13 AM Virmati.Banking.CBS.CBSData.dDailytransactions.Proc_InsertDailyTrans_SP --> .Net SqlClient Data Provider --> Transaction (Process ID 102) 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) 09:02:13 AM Virmati.Banking.CBS.CBSData.dDailytransactions.Proc_InsertTrans_SP --> Virmati.Banking.CBS.CBSData.dDailytransactions.Proc_InsertDailyTrans_SP --> .Net SqlClient Data Provider --> Transaction (Process ID 102) 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) 09:02:19 AM Virmati.Banking.CBS.CBSData.dDailytransactions.Proc_InsertDailyTrans_SP --> .Net SqlClient Data Provider --> Transaction (Process ID 118) 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) 09:02:19 AM Virmati.Banking.CBS.CBSData.dDailytransactions.Proc_InsertTrans_SP --> Virmati.Banking.CBS.CBSData.dDailytransactions.Proc_InsertDailyTrans_SP --> .Net SqlClient Data Provider --> Transaction (Process ID 118) 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) 09:02:19 AM Virmati.Banking.CBS.CBSData.dDailytransactions.Proc_InsertDailyTrans_SP --> .Net SqlClient Data Provider --> Transaction (Process ID 113) 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) 09:02:19 AM Virmati.Banking.CBS.CBSData.dDailytransactions.Proc_InsertTrans_SP --> Virmati.Banking.CBS.CBSData.dDailytransactions.Proc_InsertDailyTrans_SP --> .Net SqlClient Data Provider --> Transaction (Process ID 113) 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) 09:02:21 AM Virmati.Banking.CBS.CBSData.dDailytransactions.Proc_InsertDailyTrans_SP --> .Net SqlClient Data Provider --> Transaction (Process ID 106) 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) 09:02:21 AM Virmati.Banking.CBS.CBSData.dDailytransactions.Proc_InsertTrans_SP --> Virmati.Banking.CBS.CBSData.dDailytransactions.Proc_InsertDailyTrans_SP --> .Net SqlClient Data Provider --> Transaction (Process ID 106) 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) 01:02:00 PM 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() 01:02:00 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 --> 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 = "BankParameters" at Virmati.Banking.CBS.CBSData.DataCommon.cnOpen(); at Virmati.Banking.CBS.CBSData.DataCommon.OpenDataTable(String strSQL, String TableName, Boolean pCloseConn) 01:02:00 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 --> 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.dBankParameters.GetRecord(Object& sQuery) 07:31:36 PM Virmati.Banking.CBS.CBSData.dDailytransactions.InsertUpdateRecord --> .Net SqlClient Data Provider --> Violation of PRIMARY KEY constraint 'PK_Dailytransactions'. Cannot insert duplicate key in object 'dbo.Dailytransactions'. The duplicate key value is (100100016, Oct 18 2024 12:00AM, 1001). The statement has been terminated. at System.Data.Common.DbDataAdapter.UpdatedRowStatusErrors(RowUpdatedEventArgs rowUpdatedEvent, BatchCommandInfo[] batchCommands, Int32 commandCount); at System.Data.Common.DbDataAdapter.UpdatedRowStatus(RowUpdatedEventArgs rowUpdatedEvent, BatchCommandInfo[] batchCommands, Int32 commandCount); at System.Data.Common.DbDataAdapter.Update(DataRow[] dataRows, DataTableMapping tableMapping); at System.Data.Common.DbDataAdapter.UpdateFromDataTable(DataTable dataTable, DataTableMapping tableMapping); at System.Data.Common.DbDataAdapter.Update(DataTable dataTable); at Virmati.Banking.CBS.CBSData.DataCommon.UpdateDataTableWithOutCatch(DataTable& dt, Boolean UseFieldNames); at Virmati.Banking.CBS.CBSData.dDailytransactions.InsertUpdateRecord(DataTable& dt) 07:31:37 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'. The duplicate key value is (100100027, Oct 18 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) 07:31:37 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'. The duplicate key value is (100100027, Oct 18 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)