Details
-
Type:
Bug
-
Status:
Closed
(View Workflow)
-
Priority:
Normal
-
Resolution: Fixed
-
Component/s: NEP
-
Customer:Airtel India
-
Defect Category:Integration
-
Classification:Query
Description
deletion script for deleting the ubr node from report where the object id is showing blank
Attachments
Activity
-
- Time Spent:
- 2 hours, 30 minutes
-
checked the prod report locally checked and tested also checked in prod db by requesting permission shared the script
-
- Time Spent:
- 1 hour, 30 minutes
-
Executed the SQL script on the GJ circle, restarted the NEP services, and monitored the logs.
| Field | Original Value | New Value |
|---|---|---|
| Gantt Options | Milestone (set to milestone: having a due date but zero effort) | |
| Planned Start | 2026-01-23 24:00 (milestone: set planned start date to due date) | |
| Planned End | 2026-01-23 24:00 (milestone: set planned end date to due date) |
| Labels | nep_dev |
| Component/s | NEP [ 16200 ] |
| Description | deletion script for deleting the ubr node from report where the object id is showing blank |
| Assignee | Khaled Khalil [ kkhalil ] | Srishti Kashyap [ skashyap ] |
| Status | Open Bug [ 10108 ] | Dev Scheduled [ 10014 ] |
| Status | Dev Scheduled [ 10014 ] | Implementation in progress [ 10016 ] |
| Status | Implementation in progress [ 10016 ] | To Be Released [ 10400 ] |
| Defect Category | Integration [ 11212 ] | |
| Dev Verification Done | Static Analysis,Unit Testing,Code Review [ 10700, 10701, 10702 ] | |
| Classification | Query [ 13700 ] |
| Attachment | 20260123_deleteUBRblankneid.txt [ 126806 ] |
| Remaining Estimate | 0 minutes [ 0 ] | |
| Time Spent | 2 hours, 30 minutes [ 9000 ] | |
| Worklog Id | 289514 [ 289514 ] |
| Baseline Start | 2026-01-23 24:00 (set baseline based of initial work logging) | |
| Baseline End | 2026-01-23 24:00 (set baseline based of initial work logging) |
| Status | To Be Released [ 10400 ] | Ready for QA [ 10023 ] |
| Assignee | Srishti Kashyap [ skashyap ] | Priyasha Tiwari [ ptiwari ] |
| Time Spent | 2 hours, 30 minutes [ 9000 ] | 4 hours [ 14400 ] |
| Worklog Id | 289741 [ 289741 ] |
SCRIPT OK
Show
Priyasha Tiwari
added a comment - SCRIPT OK
| Status | Ready for QA [ 10023 ] | QA In Progress [ 10015 ] |
OK
Show
Priyasha Tiwari
added a comment - OK
| Status | QA In Progress [ 10015 ] | Closed [ 6 ] |
| Resolution | Fixed [ 1 ] |
-
- Time Spent:
- 3 hours
-
Executed the SQL script on the all prod circles, restarted the NEP services, and monitored the logs.
| Time Spent | 4 hours [ 14400 ] | 7 hours [ 25200 ] |
| Worklog Id | 290127 [ 290127 ] |
| Transition | Time In Source Status | Execution Times | Last Executer | Last Execution Date | |||||
|---|---|---|---|---|---|---|---|---|---|
|
4h 23m | 1 | Srishti Kashyap | 23/Jan/26 9:29 AM | |||||
|
8s | 1 | Srishti Kashyap | 23/Jan/26 9:29 AM | |||||
|
30s | 1 | Srishti Kashyap | 23/Jan/26 9:29 AM | |||||
|
25m 19s | 1 | Khaled Khalil | 23/Jan/26 9:55 AM | |||||
|
4d 2h 26m | 1 | Priyasha Tiwari | 27/Jan/26 12:21 PM | |||||
|
19s | 1 | Priyasha Tiwari | 27/Jan/26 12:21 PM |
|
Links Hierarchy |
 Documentation
|
provided the script attaching same