Project

General

Profile

Actions
Copy link

Bug #148

closed

Backend API|UAT| Getting multiple entries for a single transaction

Added by Vaishali Tomar 19 days ago. Updated 17 days ago.

Status:
Closed
Priority:
Urgent
Assignee:
Vaishali Tomar
Start date:
02/16/2026
Due date:
% Done:

0%

Estimated time:
Spent time:
2:00 h
Deliverable:
BACKEND API

Description

Getting multiple entries for a single transaction
Merchant ID - 8523054217
Serial Number- 26220N7M3838,26220N7M3833
Device ID-10500052, 10500039
Terminal Number- 10400023, 10400014
VPA- CV130009017

Do transaction for single VPA which is attached with 2 device and two terminal has creating 4 entries at a single time with same order ID

Files

Download all files
clipboard-202602161747-hqpne.png (127 KB) clipboard-202602161747-hqpne.png Vaishali Tomar, 02/16/2026 12:17 PM
clipboard-202602181719-7fscy.png (112 KB) clipboard-202602181719-7fscy.png Vaishali Tomar, 02/18/2026 11:56 AM
Actions
Copy link
 #1

Updated by Ayush Tyagi 18 days ago

  • Assignee changed from Ayush Tyagi to Kunal Chaudhary
Actions
Copy link
 #2

Updated by Kunal Chaudhary 17 days ago

  • Status changed from New to Resolved
  • Assignee changed from Kunal Chaudhary to Vaishali Tomar

join query issue fix in transaction report API

transaction api report RCA :

The issue occurred due to multiple notification message records
existing for the same transaction in UAT, combined with multiple
active terminal mappings for the same VPA.

During execution, the stored procedure joined both terminal and
notification tables without restricting duplicate notification entries,
which resulted in row multiplication (2 terminals × 2 notifications = 4 rows)

Actions
Copy link
 #3

Updated by Vaishali Tomar 17 days ago

Issue has been fixed in latest Release, but it is related to VPA confirmation that VPA has to be unique for every device so as of now when single VPA is connected with two device it will create two entries only but in original data user can use single VPA for diff devices. closing this issue on the behalf of this status

Actions
Copy link

Also available in: Atom PDF