[LS-709] Airtel_FTTH service routing report correction _prod - Mobinets-JIRA

Details

Type: Bug
Status: Closed (View Workflow)
Resolution: Fixed
Component/s: NEP
Labels:
- NEP_D
- Labels

Customer:

Airtel India
Defect Category:
Implementation
Classification:
Req. Tuning

Description

we need to remove the FTTH_Dummy and MW_Dummy nodes form the below mentioned DB view and NEP report .
DB VIEW NAME Related to MW IDU and Transmission Link ,

v_mw_vlan_links
v_mwlink_report
v_topology_sitecomponent
v_idu_report
v_inventory_report

NEP Report-
IDU report , board report ,cabinet report, shelf report, full configuration, inventory and Transmission link report

Attachments

MWLINKt.csv

27/Oct/25 4:52 AM

2.96 MB

Priyasha Tiwari

Activity

Ascending order - Click to sort in descending order

Permalink

Priyasha Tiwari logged work - 09/Oct/25 12:00 AM - edited

Time Spent:

2 hours

testing on test server and call with customer

Priyasha Tiwari made changes - 10/Oct/25 5:19 AM

Field	Original Value	New Value
Gantt Options		Milestone (set to milestone: having a due date but zero effort)
Planned Start		2025-10-13 24:00 (milestone: set planned start date to due date)
Planned End		2025-10-13 24:00 (milestone: set planned end date to due date)

Priyasha Tiwari made changes - 10/Oct/25 6:12 AM

Project	Airtel_Support [ 13603 ]	L3 Support [ 14300 ]
Key	~~ATS-10828~~	~~LS-709~~

Priyasha Tiwari made changes - 10/Oct/25 6:13 AM

Assignee

Ankit Bhardwaj [ abhardwaj ]

Bessem Manita [ bmanita ]

Priyasha Tiwari made changes - 10/Oct/25 6:13 AM

Component/s

NEP [ 16200 ]

Priyasha Tiwari made changes - 10/Oct/25 6:13 AM

Labels

NEP_D

Priyasha Tiwari made changes - 10/Oct/25 6:16 AM

Description

DB VIEW NAME

v_mw_vlan_links

v_mwlink_report

v_topology_sitecomponent

Priyasha Tiwari made changes - 10/Oct/25 6:16 AM

Description

DB VIEW NAME

v_mw_vlan_links

v_mwlink_report

v_topology_sitecomponent

DB VIEW NAME

v_mw_vlan_links
v_mwlink_report
v_topology_sitecomponent
v_idu_report

Priyasha Tiwari made changes - 10/Oct/25 7:01 AM

Description

DB VIEW NAME

v_mw_vlan_links
v_mwlink_report
v_topology_sitecomponent
v_idu_report

we need to remove the FTTH_Dummy and MW_Dummy nodes form the below mentioned DB view and NEP report .
DB VIEW NAME Related to MW IDU and Transmission Link ,

v_mw_vlan_links
v_mwlink_report
v_topology_sitecomponent
v_idu_report

NEP Report-
IDU report and Transmission link report

Permalink

Srishti Kashyap logged work - 13/Oct/25 12:00 AM - edited

Time Spent:

7 hours, 30 minutes

checked the issue, trying to check the ftth_dummy and mw_dummy type where need to be implemented and for IDU making changes in the db view of all the 4 dbview

Marwan Kanaan made changes - 13/Oct/25 8:13 AM

Assignee

Bessem Manita [ bmanita ]

Srishti Kashyap [ skashyap ]

Permalink

Srishti Kashyap logged work - 14/Oct/25 12:00 AM

Time Spent:

7 hours

testing for idureport dbview at test dldbclone...rest dbview dont have data..creating FFTHdummy node at local..tried for links not able to have links..for testing changing db values..testing with and without fix..release the patch

Permalink

Priyasha Tiwari logged work - 14/Oct/25 12:00 AM

Time Spent:

1 hour

Discuss for DB view report with l2

Srishti Kashyap made changes - 14/Oct/25 9:22 AM

Remaining Estimate		0 minutes [ 0 ]
Time Spent		7 hours, 30 minutes [ 27000 ]
Worklog Id	280359 [ 280359 ]

Srishti Kashyap made changes - 14/Oct/25 9:22 AM

Baseline Start		2025-10-13 24:00 (set baseline based of initial work logging)
Baseline End		2025-10-13 24:00 (set baseline based of initial work logging)

Srishti Kashyap made changes - 14/Oct/25 9:23 AM

Worklog Id

280359 [ 280359 ]

Hide

Permalink

Srishti Kashyap added a comment - 15/Oct/25 4:26 AM - edited

Hi Dear
Build 3.7.71.514 is released with removal of type FTTH_DUMMY and MW_DUMMY for IDU nodes and links from 4 dbview

Show

Srishti Kashyap added a comment - 15/Oct/25 4:26 AM - edited Hi Dear Build 3.7.71.514 is released with removal of type FTTH_DUMMY and MW_DUMMY for IDU nodes and links from 4 dbview

Srishti Kashyap made changes - 15/Oct/25 4:29 AM

Status	Open Bug [ 10108 ]	Dev Scheduled [ 10014 ]
Due Date	13/Oct/25	15/Oct/25
Planned End	13/Oct/25 12:00 AM	15/Oct/25 12:00 AM

Srishti Kashyap made changes - 15/Oct/25 4:30 AM

Status

Dev Scheduled [ 10014 ]

Implementation in progress [ 10016 ]

Srishti Kashyap made changes - 15/Oct/25 4:31 AM

Status	Implementation in progress [ 10016 ]	To Be Released [ 10400 ]
Defect Category		Implementation [ 11210 ]
Dev Verification Done		Static Analysis,Unit Testing,Code Review [ 10700, 10701, 10702 ]
Classification		Req. Tuning [ 13204 ]

Srishti Kashyap made changes - 15/Oct/25 4:31 AM

Assignee

Srishti Kashyap [ skashyap ]

Priyasha Tiwari [ ptiwari ]

Srishti Kashyap made changes - 15/Oct/25 9:04 AM

Time Spent	7 hours, 30 minutes [ 27000 ]	1 day, 6 hours, 30 minutes [ 52200 ]
Worklog Id	280427 [ 280427 ]

Khaled Khalil made changes - 15/Oct/25 11:15 AM

Assignee

Priyasha Tiwari [ ptiwari ]

Srishti Kashyap [ skashyap ]

Khaled Khalil made changes - 16/Oct/25 2:14 PM

Status	To Be Released [ 10400 ]	Ready for QA [ 10023 ]
Assignee	Srishti Kashyap [ skashyap ]	Priyasha Tiwari [ ptiwari ]

Permalink

Priyasha Tiwari logged work - 23/Oct/25 12:00 AM

Time Spent:

2 hours

aised new issue and discussion with internal team for same

Priyasha Tiwari made changes - 23/Oct/25 7:54 AM

Time Spent	1 day, 6 hours, 30 minutes [ 52200 ]	2 days, 30 minutes [ 59400 ]
Worklog Id	281305 [ 281305 ]

Priyasha Tiwari made changes - 23/Oct/25 7:59 AM

Time Spent	2 days, 30 minutes [ 59400 ]	2 days, 2 hours, 30 minutes [ 66600 ]
Worklog Id	281311 [ 281311 ]

Priyasha Tiwari made changes - 23/Oct/25 8:08 AM

Time Spent	2 days, 2 hours, 30 minutes [ 66600 ]	2 days, 3 hours, 30 minutes [ 70200 ]
Worklog Id	281321 [ 281321 ]

Priyasha Tiwari made changes - 24/Oct/25 10:00 AM

Description

we need to remove the FTTH_Dummy and MW_Dummy nodes form the below mentioned DB view and NEP report .
DB VIEW NAME Related to MW IDU and Transmission Link ,

v_mw_vlan_links
v_mwlink_report
v_topology_sitecomponent
v_idu_report
v_inventory_report

NEP Report-
IDU report and Transmission link report

Permalink

Priyasha Tiwari logged work - 27/Oct/25 12:00 AM

Time Spent:

3 hours

testing in test incluse xml import DB sync then execute SQL query and report validation and confirmation to customer

Permalink

Srishti Kashyap logged work - 27/Oct/25 12:00 AM

Time Spent:

4 hours, 30 minutes

correction done for mwlink report and checking for changes in vinventory report ...related changes been done in previous patch checking dbviews at prod asking for confirmation from telco meanwhile testing mwlinkreport creating data at local

Hide

Permalink

Priyasha Tiwari added a comment - 27/Oct/25 4:51 AM

mwlink the correction is not reflecting,..test server .177 version-DL_PROD

Show

Priyasha Tiwari added a comment - 27/Oct/25 4:51 AM mwlink the correction is not reflecting,..test server .177 version-DL_PROD

Priyasha Tiwari made changes - 27/Oct/25 4:51 AM

Status

Ready for QA [ 10023 ]

QA In Progress [ 10015 ]

Hide

Permalink

Priyasha Tiwari added a comment - 27/Oct/25 4:52 AM

FOR MWLINK CHANGES ARE NOT REFLECTING

Show

Priyasha Tiwari added a comment - 27/Oct/25 4:52 AM FOR MWLINK CHANGES ARE NOT REFLECTING

Priyasha Tiwari made changes - 27/Oct/25 4:52 AM

Status	QA In Progress [ 10015 ]	Reopened [ 4 ]
Assignee	Priyasha Tiwari [ ptiwari ]	Khaled Khalil [ kkhalil ]
Resolution		Incomplete [ 4 ]
Attachment		MWLINKt.csv [ 120601 ]

Hide

Permalink

Priyasha Tiwari added a comment - 27/Oct/25 5:02 AM

need to implement this change on v_inventory_report DB also

Show

Priyasha Tiwari added a comment - 27/Oct/25 5:02 AM need to implement this change on v_inventory_report DB also

Marwan Kanaan made changes - 27/Oct/25 6:56 AM

Assignee

Khaled Khalil [ kkhalil ]

Srishti Kashyap [ skashyap ]

Marwan Kanaan made changes - 27/Oct/25 6:56 AM

Status

Reopened [ 4 ]

Dev Scheduled [ 10014 ]

Priyasha Tiwari made changes - 27/Oct/25 11:22 AM

Worklog Id

281305 [ 281305 ]

Permalink

Srishti Kashyap logged work - 28/Oct/25 12:00 AM

Time Spent:

1 hour, 30 minutes

Did last testing and committed the code

Priyasha Tiwari made changes - 28/Oct/25 4:33 AM

Time Spent	2 days, 3 hours, 30 minutes [ 70200 ]	2 days, 6 hours, 30 minutes [ 81000 ]
Worklog Id	281808 [ 281808 ]

Permalink

Priyasha Tiwari logged work - 29/Oct/25 12:00 AM

Time Spent:

4 hours

phase 2 testing, patch applied, RB TRIGGRED, rb report check,static file check

Permalink

Priyasha Tiwari logged work - 30/Oct/25 12:00 AM

Time Spent:

1 hour

screen sharing session with customer

Priyasha Tiwari made changes - 30/Oct/25 5:31 AM

Time Spent	2 days, 6 hours, 30 minutes [ 81000 ]	3 days, 2 hours, 30 minutes [ 95400 ]
Worklog Id	282127 [ 282127 ]

Hide

Permalink

Priyasha Tiwari added a comment - 30/Oct/25 7:37 AM

correction is done, but as discussed with the airtel they are insisting to do the same changes in the NEP report also .

Show

Priyasha Tiwari added a comment - 30/Oct/25 7:37 AM correction is done, but as discussed with the airtel they are insisting to do the same changes in the NEP report also .

Srishti Kashyap made changes - 31/Oct/25 4:24 AM

Time Spent	3 days, 2 hours, 30 minutes [ 95400 ]	3 days, 7 hours [ 111600 ]
Worklog Id	282304 [ 282304 ]

Srishti Kashyap made changes - 31/Oct/25 4:25 AM

Time Spent	3 days, 7 hours [ 111600 ]	4 days, 30 minutes [ 117000 ]
Worklog Id	282305 [ 282305 ]

Priyasha Tiwari made changes - 31/Oct/25 7:54 AM

Time Spent	4 days, 30 minutes [ 117000 ]	4 days, 1 hour, 30 minutes [ 120600 ]
Worklog Id	282330 [ 282330 ]

Permalink

Srishti Kashyap logged work - 05/Nov/25 12:00 AM - edited

Time Spent:

3 hours

Doing changes for ftth in reports of NEP idu and transmissionlink and testing for same

Marwan Kanaan made changes - 05/Nov/25 8:59 AM

Status	Dev Scheduled [ 10014 ]	Implementation in progress [ 10016 ]
Assignee	Srishti Kashyap [ skashyap ]	Marwan Kanaan [ mkanaan ]

Marwan Kanaan made changes - 05/Nov/25 8:59 AM

Assignee

Marwan Kanaan [ mkanaan ]

Srishti Kashyap [ skashyap ]

Permalink

Srishti Kashyap logged work - 07/Nov/25 12:00 AM

Time Spent:

3 hours, 30 minutes

working putting ftth filter on board inventory physical conf report

Srishti Kashyap made changes - 07/Nov/25 4:54 AM

Time Spent	4 days, 1 hour, 30 minutes [ 120600 ]	4 days, 4 hours [ 129600 ]
Worklog Id	282804 [ 282804 ]

Srishti Kashyap made changes - 07/Nov/25 4:54 AM

Time Spent	4 days, 4 hours [ 129600 ]	4 days, 4 hours, 30 minutes [ 131400 ]
Worklog Id	282804 [ 282804 ]

Priyasha Tiwari made changes - 07/Nov/25 8:30 AM

Description

we need to remove the FTTH_Dummy and MW_Dummy nodes form the below mentioned DB view and NEP report .
DB VIEW NAME Related to MW IDU and Transmission Link ,

v_mw_vlan_links
v_mwlink_report
v_topology_sitecomponent
v_idu_report
v_inventory_report

NEP Report-
IDU report and Transmission link report

we need to remove the FTTH_Dummy and MW_Dummy nodes form the below mentioned DB view and NEP report .
DB VIEW NAME Related to MW IDU and Transmission Link ,

v_mw_vlan_links
v_mwlink_report
v_topology_sitecomponent
v_idu_report
v_inventory_report

NEP Report-
IDU report , board report and Transmission link report

Priyasha Tiwari made changes - 07/Nov/25 10:29 AM

Description

we need to remove the FTTH_Dummy and MW_Dummy nodes form the below mentioned DB view and NEP report .
DB VIEW NAME Related to MW IDU and Transmission Link ,

v_mw_vlan_links
v_mwlink_report
v_topology_sitecomponent
v_idu_report
v_inventory_report

NEP Report-
IDU report , board report and Transmission link report

we need to remove the FTTH_Dummy and MW_Dummy nodes form the below mentioned DB view and NEP report .
DB VIEW NAME Related to MW IDU and Transmission Link ,

v_mw_vlan_links
v_mwlink_report
v_topology_sitecomponent
v_idu_report
v_inventory_report

NEP Report-
IDU report , board report ,cabinet report, shelf report, full configuration, inventory and Transmission link report

Permalink

Srishti Kashyap logged work - 10/Nov/25 12:00 AM - edited

Time Spent:

7 hours, 30 minutes

worked on all 8 reports of physical conf and idus and transmission to put ftth filter on node on basis of auto created did changes and tested each report

Permalink

Basant Kumar logged work - 11/Nov/25 12:00 AM

Time Spent:

2 hours

Build 3.7.71.524 patch has been deployed on all test servers and also we have configured DB on .45 test vm.

Srishti Kashyap made changes - 11/Nov/25 4:43 AM

Status

Implementation in progress [ 10016 ]

To Be Released [ 10400 ]

Hide

Permalink

Srishti Kashyap added a comment - 11/Nov/25 8:43 AM

Hi Dear,
Build 3.7.71.524 has been released, containing the implemented changes for FTTH_DUMMY and MW_DUMMY in the following NEP reports:
• IDU Report
• Transmission Link Report
• Board Report
• Full Configuration Report
• Interface Report
• Inventory Report
• Cabinet Report
• Shelf Report
• Port Report
• Threshold Report

Show

Srishti Kashyap added a comment - 11/Nov/25 8:43 AM Hi Dear, Build 3.7.71.524 has been released, containing the implemented changes for FTTH_DUMMY and MW_DUMMY in the following NEP reports: • IDU Report • Transmission Link Report • Board Report • Full Configuration Report • Interface Report • Inventory Report • Cabinet Report • Shelf Report • Port Report • Threshold Report

Khaled Khalil made changes - 11/Nov/25 9:19 AM

Status	To Be Released [ 10400 ]	Ready for QA [ 10023 ]
Assignee	Srishti Kashyap [ skashyap ]	Priyasha Tiwari [ ptiwari ]

Basant Kumar made changes - 12/Nov/25 4:34 AM

Time Spent	4 days, 4 hours, 30 minutes [ 131400 ]	4 days, 6 hours, 30 minutes [ 138600 ]
Worklog Id	283110 [ 283110 ]

Permalink

Srishti Kashyap logged work - 14/Nov/25 12:00 AM - edited

Time Spent:

3 hours, 30 minutes

checked the report of autocreated idu and links report being empty

Srishti Kashyap made changes - 14/Nov/25 4:01 AM

Time Spent	4 days, 6 hours, 30 minutes [ 138600 ]	1 week, 6 hours [ 165600 ]
Worklog Id	283302 [ 283302 ]

Srishti Kashyap made changes - 14/Nov/25 4:02 AM

Worklog Id

283302 [ 283302 ]

Srishti Kashyap made changes - 14/Nov/25 4:03 AM

Time Spent	1 week, 6 hours [ 165600 ]	1 week, 1 day, 1 hour, 30 minutes [ 178200 ]
Worklog Id	283303 [ 283303 ]

Permalink

Basant Kumar logged work - 18/Nov/25 12:00 AM

Time Spent:

2 hours

we have deployed NEP_AIRTEL - Build 3.7.71.527 - Successful on all test vms and db configured to test

Basant Kumar made changes - 18/Nov/25 2:02 PM

Time Spent	1 week, 1 day, 1 hour, 30 minutes [ 178200 ]	1 week, 1 day, 3 hours, 30 minutes [ 185400 ]
Worklog Id	283736 [ 283736 ]

Permalink

Basant Kumar logged work - 21/Nov/25 12:00 AM

Time Spent:

3 hours

3.7.71.520 patch has been deployed on all prod servers .

Basant Kumar made changes - 24/Nov/25 7:25 AM

Time Spent	1 week, 1 day, 3 hours, 30 minutes [ 185400 ]	1 week, 1 day, 6 hours, 30 minutes [ 196200 ]
Worklog Id	284145 [ 284145 ]

Srishti Kashyap made changes - 25/Nov/25 8:43 AM

Time Spent	1 week, 1 day, 6 hours, 30 minutes [ 196200 ]	1 week, 2 days [ 201600 ]
Worklog Id	284256 [ 284256 ]

Srishti Kashyap made changes - 25/Nov/25 8:45 AM

Time Spent	1 week, 2 days [ 201600 ]	1 week, 2 days, 2 hours [ 208800 ]
Worklog Id	284256 [ 284256 ]

Hide

Permalink

Priyasha Tiwari added a comment - 26/Nov/25 10:18 AM

correction done for report but now the ubr nodes are showing in the idu report for this separate ticket is raised

Show

Priyasha Tiwari added a comment - 26/Nov/25 10:18 AM correction done for report but now the ubr nodes are showing in the idu report for this separate ticket is raised

Priyasha Tiwari made changes - 26/Nov/25 10:18 AM

Status

Ready for QA [ 10023 ]

QA In Progress [ 10015 ]

Hide

Permalink

Priyasha Tiwari added a comment - 26/Nov/25 10:18 AM

done

Show

Priyasha Tiwari added a comment - 26/Nov/25 10:18 AM done

Priyasha Tiwari made changes - 26/Nov/25 10:18 AM

Status	QA In Progress [ 10015 ]	Closed [ 6 ]
Resolution	Incomplete [ 4 ]	Fixed [ 1 ]

Permalink

Basant Kumar logged work - 04/Dec/25 12:00 AM

Time Spent:

2 hours

applied NEP_AIRTEL - Build 3.7.71.520 - Successful patch on all test servrs .

Basant Kumar made changes - 05/Dec/25 8:42 AM

Time Spent	1 week, 2 days, 2 hours [ 208800 ]	1 week, 2 days, 4 hours [ 216000 ]
Worklog Id	285329 [ 285329 ]

Transition

Time In Source Status

Execution Times

Last Executer

Last Execution Date

Open Bug

Dev Scheduled

4d 23h 10m

Srishti Kashyap

15/Oct/25 4:29 AM

QA In Progress

Reopened

46s

Priyasha Tiwari

27/Oct/25 4:52 AM

Reopened

Dev Scheduled

2h 4m

Marwan Kanaan

27/Oct/25 6:56 AM

Dev Scheduled

Implementation in progress

9d 2h 2m

Marwan Kanaan

05/Nov/25 8:59 AM

Implementation in progress

To Be Released

5d 19h 45m

Srishti Kashyap

11/Nov/25 4:43 AM

To Be Released

Ready for QA

1d 14h 19m

Khaled Khalil

11/Nov/25 9:19 AM

Ready for QA

QA In Progress

25d 16h 35m

Priyasha Tiwari

26/Nov/25 10:18 AM

QA In Progress

Closed

15s

Priyasha Tiwari

26/Nov/25 10:18 AM

Invalid license: EXPIRED

People

Assignee:

Priyasha Tiwari

Reporter:

Priyasha Tiwari

Votes:

0 Vote for this issue

Watchers:

2 Start watching this issue

Dates

Due:

15/Oct/25

Created:

10/Oct/25 5:19 AM

Updated:

05/Dec/25 8:42 AM

Resolved:

26/Nov/25 10:18 AM

Planned Start:

13/Oct/25 12:00 AM

Planned End:

15/Oct/25 12:00 AM

Actual Start:

14/Oct/25 12:00 AM

Date of Baselining:

14/Oct/25 9:22 AM

Time Tracking

Estimated:

Not Specified

Remaining:

Logged:

1w 2d 4h

Agile

View on Board

Drag and Drop