10-11-2024 08:33:49 AcIsValid : SUCCESS 10-11-2024 08:33:49 AcIsValid : SUCCESS 10-11-2024 08:33:49 AcIsValid : SUCCESS 10-11-2024 08:33:49 AcIsValid : SUCCESS 10-11-2024 08:33:49 AcIsValid : SUCCESS 10-11-2024 08:33:49 AcIsValid : SUCCESS 10-11-2024 08:33:49 AcIsValid : SUCCESS 10-11-2024 08:33:49 AcIsValid : SUCCESS 10-11-2024 08:33:49 AcIsValid : SUCCESS 10-11-2024 08:33:49 AcIsValid : SUCCESS 10-11-2024 08:33:49 AcIsValid : SUCCESS 10-11-2024 08:33:49 AcIsValid : SUCCESS 10-11-2024 08:33:49 AcIsValid : SUCCESS 10-11-2024 08:33:49 AcIsValid : SUCCESS 10-11-2024 08:33:49 AcIsValid : SUCCESS 10-11-2024 08:33:49 AcIsValid : SUCCESS 10-11-2024 08:33:49 AcIsValid : SUCCESS 10-11-2024 08:33:49 AcIsValid : SUCCESS 10-11-2024 08:33:50 AcIsValid : SUCCESS 10-11-2024 08:33:50 AcIsValid : SUCCESS 10-11-2024 08:33:51 AcIsValid : SUCCESS 10-11-2024 08:33:51 AcIsValid : SUCCESS 10-11-2024 08:33:52 AcIsValid : SUCCESS 10-11-2024 08:33:58 AcIsValid : SUCCESS 10-11-2024 08:33:58 AcIsValid : SUCCESS 10-11-2024 08:33:58 AcIsValid : SUCCESS 10-11-2024 08:33:59 AcIsValid : SUCCESS 10-11-2024 08:34:52 AcIsValid : SUCCESS 10-11-2024 08:34:56 AcIsValid : SUCCESS 10-11-2024 08:38:27 AcIsValid : SUCCESS 10-11-2024 08:38:29 AcIsValid : SUCCESS 10-11-2024 08:38:33 AcIsValid : SUCCESS 10-11-2024 08:38:34 AcIsValid : SUCCESS 10-11-2024 08:38:37 AcIsValid : SUCCESS 10-11-2024 08:38:42 AcIsValid : SUCCESS 10-11-2024 08:38:43 AcIsValid : SUCCESS 10-11-2024 08:43:59 AcIsValid : SUCCESS 10-11-2024 08:44:00 AcIsValid : SUCCESS 10-11-2024 08:44:01 AcIsValid : SUCCESS 10-11-2024 08:44:09 AcIsValid : SUCCESS 10-11-2024 08:44:18 AcIsValid : SUCCESS 10-11-2024 08:44:19 AcIsValid : SUCCESS 10-11-2024 08:44:19 AcIsValid : SUCCESS 10-11-2024 08:44:19 AcIsValid : SUCCESS 10-11-2024 08:44:19 AcIsValid : SUCCESS 10-11-2024 08:44:19 AcIsValid : SUCCESS 10-11-2024 08:44:20 AcIsValid : SUCCESS 10-11-2024 08:48:34 AcIsValid : SUCCESS 10-11-2024 08:48:34 AcIsValid : SUCCESS 10-11-2024 09:01:30 Starting Trn Posting 10-11-2024 09:01:30 Starting Trn Posting 10-11-2024 09:01:30 Starting Trn Posting 10-11-2024 09:01:30 Starting Trn Posting 10-11-2024 09:01:30 Starting Trn Posting 10-11-2024 09:01:30 Starting Trn Posting 10-11-2024 09:01:31 0 - Not Loan/Adv trn 10-11-2024 09:01:31 Starting Trn Posting 10-11-2024 09:01:31 Error Insert thru Sp : Violation of PRIMARY KEY constraint 'PK_Dailytransactions'. Cannot insert duplicate key in object 'dbo.Dailytransactions'. The duplicate key value is (100100312, Nov 11 2024 12:00AM, 1001). 10-11-2024 09:01:31 Error Insert thru Sp : Violation of PRIMARY KEY constraint 'PK_Dailytransactions'. Cannot insert duplicate key in object 'dbo.Dailytransactions'. The duplicate key value is (100100313, Nov 11 2024 12:00AM, 1001). 10-11-2024 09:01:31 0 - Not Loan/Adv trn 10-11-2024 09:01:31 0 - Not Loan/Adv trn 10-11-2024 09:01:31 0 - Not Loan/Adv trn 10-11-2024 09:01:31 0 - Not Loan/Adv trn 10-11-2024 09:01:31 0 - Not Loan/Adv trn 10-11-2024 09:01:31 0 - Not Loan/Adv trn 10-11-2024 09:01:31 0 - Not Loan/Adv trn 10-11-2024 09:01:46 Error Insert thru Sp : 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. 10-11-2024 09:01:48 0 - Not Loan/Adv trn 10-11-2024 09:01:48 0 - Insert thru SP Done 1 10-11-2024 09:01:49 0 - Insert thru SP done 2 10-11-2024 09:01:49 Trn Updated in Log 10-11-2024 09:01:49 InsertRTGSTrn : SUCCESS 10-11-2024 09:01:49 Starting Trn Posting 10-11-2024 09:01:49 Error Insert thru Sp : 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. 10-11-2024 09:01:49 0 - Insert thru SP Done 1 10-11-2024 09:01:49 0 - Insert thru SP done 2 10-11-2024 09:01:49 Trn Updated in Log 10-11-2024 09:01:49 InsertRTGSTrn : SUCCESS 10-11-2024 09:01:49 Starting Trn Posting 10-11-2024 09:01:50 0 - Insert thru SP Done 1 10-11-2024 09:01:50 0 - Insert thru SP done 2 10-11-2024 09:01:50 Trn Updated in Log 10-11-2024 09:01:50 InsertRTGSTrn : SUCCESS 10-11-2024 09:01:50 Starting Trn Posting 10-11-2024 09:01:51 0 - Insert thru SP Done 1 10-11-2024 09:01:51 0 - Insert thru SP Done 1 10-11-2024 09:01:51 0 - Insert thru SP done 2 10-11-2024 09:01:51 Trn Updated in Log 10-11-2024 09:01:51 InsertRTGSTrn : SUCCESS 10-11-2024 09:01:51 Starting Trn Posting 10-11-2024 09:01:51 Starting Trn Posting 10-11-2024 09:01:52 0 - Insert thru SP Done 1 10-11-2024 09:01:52 0 - Insert thru SP done 2 10-11-2024 09:01:52 Trn Updated in Log 10-11-2024 09:01:52 InsertRTGSTrn : SUCCESS 10-11-2024 09:01:52 Starting Trn Posting 10-11-2024 09:01:53 0 - Insert thru SP Done 1 10-11-2024 09:01:53 0 - Insert thru SP done 2 10-11-2024 09:01:53 Trn Updated in Log 10-11-2024 09:01:53 InsertRTGSTrn : SUCCESS 10-11-2024 09:01:53 Starting Trn Posting 10-11-2024 09:01:54 0 - Not Loan/Adv trn 10-11-2024 09:01:55 Error Insert thru Sp : Transaction (Process ID 68) 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. 10-11-2024 09:01:55 0 - Not Loan/Adv trn 10-11-2024 09:01:56 Error Insert thru Sp : 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. 10-11-2024 09:01:56 0 - Not Loan/Adv trn 10-11-2024 09:01:56 0 - Insert thru SP Done 1 10-11-2024 09:01:56 0 - Insert thru SP done 2 10-11-2024 09:01:56 Trn Updated in Log 10-11-2024 09:01:56 InsertRTGSTrn : SUCCESS 10-11-2024 09:01:56 Starting Trn Posting 10-11-2024 09:01:57 Error Insert thru Sp : Transaction (Process ID 97) 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. 10-11-2024 09:01:57 Error Insert thru Sp : 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. 10-11-2024 09:01:58 0 - Not Loan/Adv trn 10-11-2024 09:01:58 Error Insert thru Sp : 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. 10-11-2024 09:01:59 0 - Not Loan/Adv trn 10-11-2024 09:01:59 0 - Insert thru SP done 2 10-11-2024 09:01:59 Trn Updated in Log 10-11-2024 09:01:59 InsertRTGSTrn : SUCCESS 10-11-2024 09:02:00 Starting Trn Posting 10-11-2024 09:02:00 0 - Not Loan/Adv trn 10-11-2024 09:02:00 0 - Insert thru SP Done 1 10-11-2024 09:02:00 0 - Insert thru SP done 2 10-11-2024 09:02:00 Trn Updated in Log 10-11-2024 09:02:00 InsertRTGSTrn : SUCCESS 10-11-2024 09:02:00 Error Insert thru Sp : Transaction (Process ID 116) 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. 10-11-2024 09:02:00 Starting Trn Posting 10-11-2024 09:02:01 0 - Insert thru SP Done 1 10-11-2024 09:02:01 0 - Not Loan/Adv trn 10-11-2024 09:02:01 0 - Insert thru SP done 2 10-11-2024 09:02:01 Trn Updated in Log 10-11-2024 09:02:01 InsertRTGSTrn : SUCCESS 10-11-2024 09:02:01 Starting Trn Posting 10-11-2024 09:02:02 0 - Not Loan/Adv trn 10-11-2024 09:02:02 0 - Insert thru SP Done 1 10-11-2024 09:02:02 0 - Insert thru SP done 2 10-11-2024 09:02:02 Trn Updated in Log 10-11-2024 09:02:02 InsertRTGSTrn : SUCCESS 10-11-2024 09:02:02 0 - Insert thru SP done 2 10-11-2024 09:02:02 Trn Updated in Log 10-11-2024 09:02:02 InsertRTGSTrn : SUCCESS 10-11-2024 09:02:02 Starting Trn Posting 10-11-2024 09:02:02 Starting Trn Posting 10-11-2024 09:02:02 0 - Insert thru SP Done 1 10-11-2024 09:02:02 0 - Insert thru SP done 2 10-11-2024 09:02:02 Trn Updated in Log 10-11-2024 09:02:02 InsertRTGSTrn : SUCCESS 10-11-2024 09:02:03 Error Insert thru Sp : Transaction (Process ID 119) 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. 10-11-2024 09:02:03 Starting Trn Posting 10-11-2024 09:02:05 0 - Not Loan/Adv trn 10-11-2024 09:02:05 0 - Insert thru SP Done 1 10-11-2024 09:02:05 0 - Insert thru SP done 2 10-11-2024 09:02:05 Trn Updated in Log 10-11-2024 09:02:05 InsertRTGSTrn : SUCCESS 10-11-2024 09:02:05 Error Insert thru Sp : Transaction (Process ID 119) 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. 10-11-2024 09:02:05 Starting Trn Posting 10-11-2024 09:02:06 Error Insert thru Sp : 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. 10-11-2024 09:02:07 0 - Not Loan/Adv trn 10-11-2024 09:02:07 Error Insert thru Sp : Transaction (Process ID 68) 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. 10-11-2024 09:02:08 0 - Not Loan/Adv trn 10-11-2024 09:02:08 0 - Insert thru SP Done 1 10-11-2024 09:02:08 0 - Insert thru SP done 2 10-11-2024 09:02:08 Trn Updated in Log 10-11-2024 09:02:08 InsertRTGSTrn : SUCCESS 10-11-2024 09:02:08 Starting Trn Posting 10-11-2024 09:02:08 0 - Not Loan/Adv trn 10-11-2024 09:02:09 0 - Insert thru SP Done 1 10-11-2024 09:02:09 0 - Insert thru SP done 2 10-11-2024 09:02:09 Trn Updated in Log 10-11-2024 09:02:09 InsertRTGSTrn : SUCCESS 10-11-2024 09:02:09 Error Insert thru Sp : 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. 10-11-2024 09:02:09 Starting Trn Posting 10-11-2024 09:02:10 Error Insert thru Sp : Transaction (Process ID 76) 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. 10-11-2024 09:02:11 0 - Not Loan/Adv trn 10-11-2024 09:02:11 0 - Insert thru SP Done 1 10-11-2024 09:02:11 0 - Insert thru SP done 2 10-11-2024 09:02:11 Trn Updated in Log 10-11-2024 09:02:11 InsertRTGSTrn : SUCCESS 10-11-2024 09:02:11 Starting Trn Posting 10-11-2024 09:02:11 0 - Not Loan/Adv trn 10-11-2024 09:02:11 0 - Insert thru SP Done 1 10-11-2024 09:02:12 0 - Insert thru SP done 2 10-11-2024 09:02:12 Trn Updated in Log 10-11-2024 09:02:12 InsertRTGSTrn : SUCCESS 10-11-2024 09:02:12 Starting Trn Posting 10-11-2024 09:02:12 0 - Not Loan/Adv trn 10-11-2024 09:02:12 0 - Insert thru SP Done 1 10-11-2024 09:02:12 0 - Insert thru SP done 2 10-11-2024 09:02:12 Trn Updated in Log 10-11-2024 09:02:12 InsertRTGSTrn : SUCCESS 10-11-2024 09:02:12 Error Insert thru Sp : Transaction (Process ID 119) 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. 10-11-2024 09:02:13 Starting Trn Posting 10-11-2024 09:02:14 Error Insert thru Sp : 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. 10-11-2024 09:02:14 0 - Not Loan/Adv trn 10-11-2024 09:02:14 0 - Insert thru SP Done 1 10-11-2024 09:02:14 0 - Insert thru SP Done 1 10-11-2024 09:02:14 0 - Insert thru SP done 2 10-11-2024 09:02:14 Trn Updated in Log 10-11-2024 09:02:14 0 - Insert thru SP done 2 10-11-2024 09:02:14 Trn Updated in Log 10-11-2024 09:02:14 InsertRTGSTrn : SUCCESS 10-11-2024 09:02:15 Starting Trn Posting 10-11-2024 09:02:15 Starting Trn Posting 10-11-2024 09:02:15 Error Insert thru Sp : 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. 10-11-2024 09:02:16 0 - Insert thru SP Done 1 10-11-2024 09:02:16 0 - Insert thru SP done 2 10-11-2024 09:02:16 Trn Updated in Log 10-11-2024 09:02:16 InsertRTGSTrn : SUCCESS 10-11-2024 09:02:16 Error Insert thru Sp : 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. 10-11-2024 09:02:17 Starting Trn Posting 10-11-2024 09:02:18 Error Insert thru Sp : 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. 10-11-2024 09:02:18 0 - Not Loan/Adv trn 10-11-2024 09:02:18 0 - Insert thru SP Done 1 10-11-2024 09:02:18 0 - Insert thru SP done 2 10-11-2024 09:02:18 Trn Updated in Log 10-11-2024 09:02:18 InsertRTGSTrn : SUCCESS 10-11-2024 09:02:18 Error Insert thru Sp : 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. 10-11-2024 09:02:19 Starting Trn Posting 10-11-2024 09:02:20 Error Insert thru Sp : 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. 10-11-2024 09:02:20 0 - Not Loan/Adv trn 10-11-2024 09:02:20 0 - Insert thru SP Done 1 10-11-2024 09:02:20 0 - Insert thru SP done 2 10-11-2024 09:02:20 Trn Updated in Log 10-11-2024 09:02:20 InsertRTGSTrn : SUCCESS 10-11-2024 09:02:21 Error Insert thru Sp : Transaction (Process ID 116) 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. 10-11-2024 09:02:21 Starting Trn Posting 10-11-2024 09:02:21 Error Insert thru Sp : 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. 10-11-2024 09:02:23 0 - Insert thru SP Done 1 10-11-2024 09:02:23 0 - Insert thru SP done 2 10-11-2024 09:02:23 Trn Updated in Log 10-11-2024 09:02:23 InsertRTGSTrn : SUCCESS 10-11-2024 09:02:23 Starting Trn Posting 10-11-2024 09:02:23 0 - Insert thru SP Done 1 10-11-2024 09:02:23 0 - Insert thru SP done 2 10-11-2024 09:02:23 Trn Updated in Log 10-11-2024 09:02:23 InsertRTGSTrn : SUCCESS 10-11-2024 09:02:24 Starting Trn Posting 10-11-2024 09:02:24 0 - Not Loan/Adv trn 10-11-2024 09:02:24 0 - Insert thru SP Done 1 10-11-2024 09:02:24 0 - Insert thru SP done 2 10-11-2024 09:02:24 Trn Updated in Log 10-11-2024 09:02:24 InsertRTGSTrn : SUCCESS 10-11-2024 09:02:24 Error Insert thru Sp : Transaction (Process ID 76) 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. 10-11-2024 09:02:24 Starting Trn Posting 10-11-2024 09:02:26 0 - Not Loan/Adv trn 10-11-2024 09:02:26 0 - Insert thru SP done 2 10-11-2024 09:02:26 Trn Updated in Log 10-11-2024 09:02:26 InsertRTGSTrn : SUCCESS 10-11-2024 09:02:27 Error Insert thru Sp : Transaction (Process ID 76) 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. 10-11-2024 09:02:27 Starting Trn Posting 10-11-2024 09:02:27 Error Insert thru Sp : 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. 10-11-2024 09:02:28 0 - Not Loan/Adv trn 10-11-2024 09:02:29 Error Insert thru Sp : Transaction (Process ID 68) 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. 10-11-2024 09:02:29 0 - Not Loan/Adv trn 10-11-2024 09:02:29 0 - Insert thru SP Done 1 10-11-2024 09:02:29 0 - Insert thru SP done 2 10-11-2024 09:02:29 Trn Updated in Log 10-11-2024 09:02:29 InsertRTGSTrn : SUCCESS 10-11-2024 09:02:30 0 - Insert thru SP Done 1 10-11-2024 09:02:30 0 - Not Loan/Adv trn 10-11-2024 09:02:30 0 - Insert thru SP done 2 10-11-2024 09:02:30 0 - Insert thru SP Done 1 10-11-2024 09:02:30 Trn Updated in Log 10-11-2024 09:02:30 InsertRTGSTrn : SUCCESS 10-11-2024 09:02:30 0 - Insert thru SP done 2 10-11-2024 09:02:30 Trn Updated in Log 10-11-2024 09:02:30 InsertRTGSTrn : SUCCESS 10-11-2024 09:02:31 0 - Insert thru SP Done 1 10-11-2024 09:02:31 0 - Insert thru SP done 2 10-11-2024 09:02:31 Trn Updated in Log 10-11-2024 09:02:31 InsertRTGSTrn : SUCCESS 10-11-2024 09:02:31 Error Insert thru Sp : 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. 10-11-2024 09:02:32 0 - Not Loan/Adv trn 10-11-2024 09:02:32 0 - Insert thru SP Done 1 10-11-2024 09:02:32 0 - Insert thru SP done 2 10-11-2024 09:02:32 Trn Updated in Log 10-11-2024 09:02:32 InsertRTGSTrn : SUCCESS 10-11-2024 09:02:32 Error Insert thru Sp : 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. 10-11-2024 09:02:33 Error Insert thru Sp : 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. 10-11-2024 09:02:33 0 - Not Loan/Adv trn 10-11-2024 09:02:33 0 - Insert thru SP Done 1 10-11-2024 09:02:33 0 - Insert thru SP done 2 10-11-2024 09:02:33 Trn Updated in Log 10-11-2024 09:02:33 InsertRTGSTrn : SUCCESS 10-11-2024 09:02:33 0 - Not Loan/Adv trn 10-11-2024 09:02:33 0 - Insert thru SP Done 1 10-11-2024 09:02:33 0 - Insert thru SP Done 1 10-11-2024 09:02:33 0 - Insert thru SP Done 1 10-11-2024 09:02:33 0 - Insert thru SP Done 1 10-11-2024 09:02:33 0 - Insert thru SP done 2 10-11-2024 09:02:33 Trn Updated in Log 10-11-2024 09:02:33 InsertRTGSTrn : SUCCESS 10-11-2024 09:02:33 0 - Insert thru SP done 2 10-11-2024 09:02:33 Trn Updated in Log 10-11-2024 09:02:33 0 - Insert thru SP done 2 10-11-2024 09:02:33 InsertRTGSTrn : SUCCESS 10-11-2024 09:02:33 Trn Updated in Log 10-11-2024 09:02:33 InsertRTGSTrn : SUCCESS 10-11-2024 09:02:33 0 - Insert thru SP done 2 10-11-2024 09:02:33 Trn Updated in Log 10-11-2024 09:02:33 InsertRTGSTrn : SUCCESS 10-11-2024 09:02:34 Starting Trn Posting 10-11-2024 09:02:34 0 - Not Loan/Adv trn 10-11-2024 09:02:34 0 - Insert thru SP Done 1 10-11-2024 09:02:34 0 - Insert thru SP done 2 10-11-2024 09:02:34 Trn Updated in Log 10-11-2024 09:02:34 InsertRTGSTrn : SUCCESS 10-11-2024 10:38:03 AcIsValid : SUCCESS 10-11-2024 11:01:08 Starting Trn Posting 10-11-2024 11:01:08 0 - Not Loan/Adv trn 10-11-2024 11:01:08 0 - Insert thru SP Done 1 10-11-2024 11:01:09 0 - Insert thru SP done 2 10-11-2024 11:01:09 Trn Updated in Log 10-11-2024 11:01:09 InsertRTGSTrn : SUCCESS 10-11-2024 11:39:46 AcIsValid : SUCCESS 10-11-2024 12:01:12 Starting Trn Posting 10-11-2024 12:01:12 0 - Not Loan/Adv trn 10-11-2024 12:01:12 0 - Insert thru SP Done 1 10-11-2024 12:01:12 0 - Insert thru SP done 2 10-11-2024 12:01:12 Trn Updated in Log 10-11-2024 12:01:12 InsertRTGSTrn : SUCCESS 10-11-2024 12:37:08 AcIsValid : SUCCESS 10-11-2024 13:01:16 Starting Trn Posting 10-11-2024 13:01:16 0 - Not Loan/Adv trn 10-11-2024 13:01:16 0 - Insert thru SP Done 1 10-11-2024 13:01:16 0 - Insert thru SP done 2 10-11-2024 13:01:16 Trn Updated in Log 10-11-2024 13:01:16 InsertRTGSTrn : SUCCESS 10-11-2024 13:14:18 AcIsValid : SUCCESS 10-11-2024 13:14:22 AcIsValid : SUCCESS 10-11-2024 13:31:19 Starting Trn Posting 10-11-2024 13:31:19 Starting Trn Posting 10-11-2024 13:31:20 0 - Not Loan/Adv trn 10-11-2024 13:31:20 Error Insert thru Sp : Violation of PRIMARY KEY constraint 'PK_Dailytransactions'. Cannot insert duplicate key in object 'dbo.Dailytransactions'. The duplicate key value is (100100482, Nov 11 2024 12:00AM, 1001). 10-11-2024 13:31:20 0 - Not Loan/Adv trn 10-11-2024 13:31:20 0 - Insert thru SP Done 1 10-11-2024 13:31:20 0 - Insert thru SP Done 1 10-11-2024 13:31:20 0 - Insert thru SP done 2 10-11-2024 13:31:20 0 - Insert thru SP done 2 10-11-2024 13:31:20 Trn Updated in Log 10-11-2024 13:31:20 InsertRTGSTrn : SUCCESS 10-11-2024 13:31:20 Trn Updated in Log 10-11-2024 13:31:20 InsertRTGSTrn : SUCCESS 10-11-2024 15:08:40 AcIsValid : SUCCESS 10-11-2024 15:09:36 AcIsValid : SUCCESS 10-11-2024 15:10:38 AcIsValid : SUCCESS 10-11-2024 15:11:15 AcIsValid : SUCCESS 10-11-2024 15:18:21 AcIsValid : SUCCESS 10-11-2024 15:18:25 AcIsValid : SUCCESS 10-11-2024 15:18:25 AcIsValid : SUCCESS 10-11-2024 15:18:25 AcIsValid : SUCCESS 10-11-2024 15:31:17 Starting Trn Posting 10-11-2024 15:31:17 0 - Not Loan/Adv trn 10-11-2024 15:31:17 Starting Trn Posting 10-11-2024 15:31:17 0 - Insert thru SP Done 1 10-11-2024 15:31:17 0 - Not Loan/Adv trn 10-11-2024 15:31:17 0 - Insert thru SP Done 1 10-11-2024 15:31:17 0 - Insert thru SP done 2 10-11-2024 15:31:17 Trn Updated in Log 10-11-2024 15:31:17 Trn Updated in Log 10-11-2024 15:31:17 InsertRTGSTrn : SUCCESS 10-11-2024 15:31:18 Starting Trn Posting 10-11-2024 15:31:18 0 - Not Loan/Adv trn 10-11-2024 15:31:18 0 - Insert thru SP Done 1 10-11-2024 15:31:18 0 - Insert thru SP done 2 10-11-2024 15:31:18 Trn Updated in Log 10-11-2024 15:31:18 InsertRTGSTrn : SUCCESS 10-11-2024 15:31:18 Starting Trn Posting 10-11-2024 15:31:18 0 - Not Loan/Adv trn 10-11-2024 15:31:18 0 - Insert thru SP Done 1 10-11-2024 15:31:18 0 - Insert thru SP done 2 10-11-2024 15:31:18 Trn Updated in Log 10-11-2024 15:31:18 InsertRTGSTrn : SUCCESS 10-11-2024 15:31:21 Starting Trn Posting 10-11-2024 15:31:21 0 - Not Loan/Adv trn 10-11-2024 15:31:21 0 - Insert thru SP Done 1 10-11-2024 15:31:21 0 - Insert thru SP done 2 10-11-2024 15:31:21 Trn Updated in Log 10-11-2024 15:31:21 InsertRTGSTrn : SUCCESS 10-11-2024 15:31:22 Starting Trn Posting 10-11-2024 15:31:22 0 - Not Loan/Adv trn 10-11-2024 15:31:22 0 - Insert thru SP Done 1 10-11-2024 15:31:22 0 - Insert thru SP done 2 10-11-2024 15:31:22 Trn Updated in Log 10-11-2024 15:31:22 InsertRTGSTrn : SUCCESS 10-11-2024 15:31:22 Starting Trn Posting 10-11-2024 15:31:22 0 - Not Loan/Adv trn 10-11-2024 15:31:23 0 - Insert thru SP Done 1 10-11-2024 15:31:23 0 - Insert thru SP done 2 10-11-2024 15:31:23 Trn Updated in Log 10-11-2024 15:31:23 InsertRTGSTrn : SUCCESS 10-11-2024 15:31:23 Starting Trn Posting 10-11-2024 15:31:23 0 - Not Loan/Adv trn 10-11-2024 15:31:23 0 - Insert thru SP Done 1 10-11-2024 15:31:23 0 - Insert thru SP done 2 10-11-2024 15:31:23 Trn Updated in Log 10-11-2024 15:31:23 InsertRTGSTrn : SUCCESS 10-11-2024 15:34:55 AcIsValid : SUCCESS 10-11-2024 16:01:17 Starting Trn Posting 10-11-2024 16:01:17 0 - Not Loan/Adv trn 10-11-2024 16:01:17 0 - Insert thru SP Done 1 10-11-2024 16:01:17 0 - Insert thru SP done 2 10-11-2024 16:01:17 Trn Updated in Log 10-11-2024 16:01:17 InsertRTGSTrn : SUCCESS 10-11-2024 19:22:09 AcIsValid : SUCCESS 10-11-2024 19:31:37 Starting Trn Posting 10-11-2024 19:31:37 0 - Not Loan/Adv trn 10-11-2024 19:31:38 0 - Insert thru SP Done 1 10-11-2024 19:31:38 0 - Insert thru SP done 2 10-11-2024 19:31:38 Trn Updated in Log 10-11-2024 19:31:38 InsertRTGSTrn : SUCCESS