Details
-
Type:
Bug
-
Status:
Closed
(View Workflow)
-
Priority:
Normal
-
Resolution: Fixed
-
Component/s: NEP
-
Labels:
-
Customer:Azerconnect
-
Complexity:Medium
-
Severity:Critical
-
Product:NEP
-
REQUESTER:INTERNAL
Description
It is found that there are IPs in NEP IP data where IP address is available without Object ID or the IP is not assigned to any Object ID.
So need a cleanup script to remove those IP addresses from NEP IP data.
Attachments
Activity
-
- Time Spent:
- 1 hour, 30 minutes
-
IPs without Object ID found in NEP IP data Report. ticket raised for cleanup.
| Field | Original Value | New Value |
|---|---|---|
| Gantt Options | Milestone (set to milestone: having a due date but zero effort) | |
| Planned Start | 2025-12-02 24:00 (milestone: set planned start date to due date) | |
| Planned End | 2025-12-02 24:00 (milestone: set planned end date to due date) |
| Remaining Estimate | 0 minutes [ 0 ] | |
| Time Spent | 1 hour, 30 minutes [ 5400 ] | |
| Worklog Id | 284844 [ 284844 ] |
| Baseline Start | 2025-12-02 24:00 (set baseline based of initial work logging) | |
| Baseline End | 2025-12-02 24:00 (set baseline based of initial work logging) |
| Assignee | Khaled Khalil [ kkhalil ] | Mustapha Al-Hage [ malhage ] |
| Status | Open Bug [ 10108 ] | Dev Scheduled [ 10014 ] |
| Status | Dev Scheduled [ 10014 ] | Implementation in progress [ 10016 ] |
| Status | Implementation in progress [ 10016 ] | To Be Released [ 10400 ] |
| Attachment | IPDATA_CLEANUP_SCRIPT_20251128.sql [ 123009 ] |
| Status | To Be Released [ 10400 ] | Ready for QA [ 10023 ] |
| Assignee | Mustapha Al-Hage [ malhage ] | Aurobinda Panda [ apanda ] |
| Time Spent | 1 hour, 30 minutes [ 5400 ] | 2 hours [ 7200 ] |
| Worklog Id | 285430 [ 285430 ] |
-
- Time Spent:
- 45 minutes
-
IP data report checked post script run.
| Assignee | Aurobinda Panda [ apanda ] | Manjit Kumar [ manjit.kumar ] |
Dear Mustapha, as checked in test server the IPs without Object ID where status is not "used by network" is removed post script run.
this will be done on prod and will let you know the result.
Show
Aurobinda Panda
added a comment - Dear Mustapha, as checked in test server the IPs without Object ID where status is not "used by network" is removed post script run.
this will be done on prod and will let you know the result.
| Time Spent | 2 hours [ 7200 ] | 2 hours, 45 minutes [ 9900 ] |
| Worklog Id | 285612 [ 285612 ] |
-
- Time Spent:
- 2 hours
-
Sanity check application and log and in evening time apply script and restart the nep application.
| Time Spent | 2 hours, 45 minutes [ 9900 ] | 4 hours, 45 minutes [ 17100 ] |
| Worklog Id | 285915 [ 285915 ] |
| Status | Ready for QA [ 10023 ] | QA In Progress [ 10015 ] |
| Assignee | Manjit Kumar [ manjit.kumar ] | Aurobinda Panda [ apanda ] |
| Status | QA In Progress [ 10015 ] | Closed [ 6 ] |
| Resolution | Fixed [ 1 ] |
| Transition | Time In Source Status | Execution Times | Last Executer | Last Execution Date | |||||
|---|---|---|---|---|---|---|---|---|---|
|
6h 30m | 1 | Mustapha Al-Hage | 28/Nov/25 12:38 PM | |||||
|
4s | 1 | Mustapha Al-Hage | 28/Nov/25 12:38 PM | |||||
|
31s | 1 | Mustapha Al-Hage | 28/Nov/25 12:39 PM | |||||
|
39m 3s | 1 | Khaled Khalil | 28/Nov/25 1:18 PM | |||||
|
60d 21h 57m | 1 | Aurobinda Panda | 28/Jan/26 11:16 AM | |||||
|
9s | 1 | Aurobinda Panda | 28/Jan/26 11:16 AM |
|
Links Hierarchy |
 Documentation
|
Dear @Aurobinda Panda,
The requested script to delete all ip addresses without object id is attached to this email.
Please note that after applying the script, a restart to NEP is required.
Regards,
Mustapha