[LS-493] Insert & Update Date Is Missing In Report Created: 08/Jul/25  Updated: 30/Mar/26  Due: 14/Jul/25  Resolved: 15/Sep/25

Status: Closed
Project: L3 Support
Component/s: NEP
Affects Version/s: None
Fix Version/s: None

Type: CR Priority: Normal
Reporter: Indrasan Yadav Assignee: Indrasan Yadav
Resolution: Fixed Votes: 0
Labels: AI_All_incidents, Huawei_RAN_OO, Nokia_RAN_OO
Remaining Estimate: 0 minutes
Time Spent: 3 days, 7 hours, 30 minutes
Original Estimate: Not Specified

Attachments: HTML File 20250818_ALTER_TABLES_TO_ADD_FOLLOWED_ATTRIBUTES    
Issue Links:
Blocks
is blocked by ACE-768 Insert & update Date is missing in re... Done
Customer:
Ooreedo Tunisia
Planned Start:
Planned End:
Actual Start:
Date of Baselining:

 Description   

We need Insert/Update date in every report like below: (Same we have done in ZAIN-KSA)

1-Physical Inventory
2-Cabinet
3-Shelf
4-Board
5-Site Component
6-Radio Antenna
7-Role2g (Already available in Role4g & Role3g not imported yet)
8-IP/VLAN/Sub Interface/Loopback Interface
9-Additional Information
10-Already available in 2G/3G/4G cell import no need to add here
11-Sites report

 Comments   
Comment by Indrasan Yadav [ 15/Jul/25 ]

Dear @Khaled Khalil,

Any update on this?

Thank you
Indrasan

Comment by Indrasan Yadav [ 12/Aug/25 ]

Dear @Khaled Khalil,

I hope you are doing well.

Could you please provide an update on this matter? It would be greatly appreciated if you could investigate it as a priority.

Thank you
Indrasan

Comment by Marwan Kanaan [ 18/Aug/25 ]

Dear @Indrasan Yadav,

Please note that all the requested modifications to the following reports:
Physical Inventory
Cabinet
Shelf
Board
Site Component
Radio Antenna
Role2G
Role3G
IP
VLAN
Sub Interface
Loopback Interface (all virtual interfaces)
Additional Information
will be included in patch 3.7.0.1338.
Additionally, please note that the attached file contains the corresponding SQL script.

Best Regards,
Marwan Kanaan I Software Developer

Comment by Indrasan Yadav [ 19/Aug/25 ]

Dear @Basant Kumar,

Please deploy the given patch on .102.

patch 3.7.0.1338.

Thank you
Indrasan

Comment by Indrasan Yadav [ 19/Aug/25 ]

Dear Indrasan ,

patch 3.7.0.1338 has been deployed on 102 platform and query has bee executed .

Regards,
Basant

Comment by Marwan Kanaan [ 20/Aug/25 ]

Dears @Basant Kumar, @Indrasan Yadav,

Please make sure to apply patch 3.7.0.1340.
We found an error that was causing a fatal issue. This has now been fixed in the latest patch.
Best Regards,

Marwan Kanaan I Software Developer

Comment by Indrasan Yadav [ 22/Aug/25 ]

Dear @Basant Kumar,

Could you please deploy the below patch on platform .102?

patch 3.7.0.1340

Thank you
Indrasan

Comment by Indrasan Yadav [ 22/Aug/25 ]

Dear Indrasan ,

patch 3.7.0.1340 has been successfully deployed on .102 platform .

Regards,
Basant

Comment by Indrasan Yadav [ 03/Sep/25 ]

I checked below reports for insert update date availability and sharing the current status:

1- Inventory report (Ok except the node MRBTS-15142 as it is blank)
2- Cabinet report (Ok except the node MRBTS-15142 as it is blank)
3- Shelf report (Ok except the node MRBTS-15142 as it is blank)
4- Board report (Ok for all)
5- Site report (Ok for all)
6- Site component report (Ok for all except 1229 nodes which has "NEP NE Availability" status as "Not Available" these has only insert date)
7- Radio antenna report (Ok for all)
8- Role2g report (Ok for all)
9- Role3g report (Currently has blank report)
10- Role4g report (Ok for all)
11- IP report (Ok for all)
12- VLAN report (Ok for all)
13- Sub interface report (Currently has blank report)
14- Loopback interface report (Ok for all)
15- Additional report for radio antenna (Ok for all)

Comment by Indrasan Yadav [ 12/Sep/25 ]

Once I will import any xml for RAN then recheck it and confirm about final status.

Comment by Indrasan Yadav [ 15/Sep/25 ]

Insert & update date is available in all report.

Generated at Wed Apr 15 14:42:49 EEST 2026 using JIRA 6.1.4#6159-sha1:44eaedef2e4a625c6c7183698b2468d4719c20dc.