Bug #177: System allow to create new application template with duplicate app name for same device type - HPCL - Redmine

Actions

Copy link

Bug #177

closed

System allow to create new application template with duplicate app name for same device type

Added by Amit Kumar 11 days ago. Updated 10 days ago.

Status:

Closed

Priority:

Normal

Assignee:

Amit Kumar

Start date:

02/24/2026

Due date:

% Done:

Estimated time:

Spent time:

11:00 h

Deliverable:

BACKEND API

Description

System allow to create new application template with duplicate app name for same device type

steps: click on tms
click on application
go for add new application template for same device type with duplicate name
observe the application grid
expected result: should not allow to create new application template with duplicate app name

Actual result: allow to add new template for same device type in system

Files

Download all files

clipboard-202602241450-sppjz.png (21.8 KB) clipboard-202602241450-sppjz.png		Amit Kumar, 02/24/2026 09:25 AM
clipboard-202602251731-ybr0d.png (47.2 KB) clipboard-202602251731-ybr0d.png	Resolved	Amit Kumar, 02/25/2026 12:06 PM

Actions

Copy link

Updated by Kunal Chaudhary 11 days ago

Status changed from New to Resolved
Assignee changed from Kunal Chaudhary to Amit Kumar
Deliverable changed from ADMIN WEB to BACKEND API

RCA

Duplicate applications were being created for the same DeviceTypeId and ApplicationName because there was no validation in the stored procedure and no unique constraint at the database level.

Fix

Added a duplicate check in UspAddApplicationList to prevent insertion if the same DeviceTypeId and ApplicationName already exist.

Actions

Copy link