[LS-493] Insert & Update Date Is Missing In Report - Mobinets-JIRA

Details

Type: CR
Status: Closed (View Workflow)
Priority: Normal
Resolution: Fixed
Component/s: NEP
Labels:

Customer:

Ooreedo Tunisia

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

Attachments

20250818_ALTER_TABLES_TO_ADD_FOLLOWED_ATTRIBUTES

18/Aug/25 1:48 PM

0.8 kB

Marwan Kanaan

Add Link

Issue Links

is blocked by

ACE-768 Insert & update Date is missing in report

Delete this link

Activity

Ascending order - Click to sort in descending order

Permalink

Indrasan Yadav logged work - 08/Jul/25 12:00 AM

Time Spent:

30 minutes

Found this issue & raised to NEP DEV.

Indrasan Yadav made changes - 08/Jul/25 6:50 AM

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

Indrasan Yadav made changes - 09/Jul/25 4:36 AM

Remaining Estimate		0 minutes [ 0 ]
Time Spent		30 minutes [ 1800 ]
Worklog Id	271406 [ 271406 ]

Indrasan Yadav made changes - 09/Jul/25 4:36 AM

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

Permalink

Indrasan Yadav logged work - 14/Jul/25 12:00 AM

Time Spent:

30 minutes

Take an overview & send an email to NEP DEV team to update on same.

Hide

Permalink

Indrasan Yadav added a comment - 15/Jul/25 4:44 AM

Dear @Khaled Khalil,

Any update on this?

Thank you
Indrasan

Show

Indrasan Yadav added a comment - 15/Jul/25 4:44 AM Dear @Khaled Khalil, Any update on this? Thank you Indrasan

Indrasan Yadav made changes - 15/Jul/25 6:57 AM

Time Spent	30 minutes [ 1800 ]	1 hour [ 3600 ]
Worklog Id	271808 [ 271808 ]

Khaled Khalil made changes - 06/Aug/25 8:20 AM

Component/s

NEP [ 16200 ]

Indrasan Yadav made changes - 07/Aug/25 6:29 AM

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

Hide

Permalink

Indrasan Yadav added a comment - 12/Aug/25 5:31 AM

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

Show

Indrasan Yadav added a comment - 12/Aug/25 5:31 AM 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

Permalink

Marwan Kanaan logged work - 13/Aug/25 12:00 AM

Time Spent:

4 hours

Create a script to add the missing columns to the shelf and cabinet tables. Implement the insert and update logic for both cabinet and shelf entities, then proceed with testing.

Hassan Abdine made changes - 13/Aug/25 7:37 AM

Status

Opened [ 1 ]

Pending Requirements [ 10300 ]

Hassan Abdine made changes - 13/Aug/25 7:37 AM

Status

Pending Requirements [ 10300 ]

Pending Design Session [ 10112 ]

Hassan Abdine made changes - 13/Aug/25 7:37 AM

Status	Pending Design Session [ 10112 ]	Dev Scheduled [ 10014 ]
Assignee	Khaled Khalil [ kkhalil ]	Marwan Kanaan [ mkanaan ]

Marwan Kanaan made changes - 13/Aug/25 8:04 AM

Status

Dev Scheduled [ 10014 ]

Implementation in progress [ 10016 ]

Marwan Kanaan made changes - 13/Aug/25 1:39 PM

Time Spent	1 hour [ 3600 ]	5 hours [ 18000 ]
Worklog Id	274222 [ 274222 ]

Permalink

Marwan Kanaan logged work - 14/Aug/25 12:00 AM

Time Spent:

1 day, 1 hour

Continued the work from yesterday and successfully tested the Shelf and Cabinet reports.
Implemented the required changes for the Physical Inventory, Board, Radio Antenna, and Sites reports, as well as for IP, VLAN, Subnet, and Loopback reports (covering all virtual interfaces).
Additionally, added the Info Reports.

Only the Role2G and Site Components remain to be completed.

Marwan Kanaan made changes - 14/Aug/25 2:08 PM

Time Spent	5 hours [ 18000 ]	1 day, 6 hours [ 50400 ]
Worklog Id	274563 [ 274563 ]

Permalink

Marwan Kanaan logged work - 18/Aug/25 12:00 AM

Time Spent:

1 day

Finished implementing Role2G, Role3G, and Site Component. Completed testing across all reports and committed the changes successfully.

Marwan Kanaan made changes - 18/Aug/25 1:48 PM

Attachment

20250818_ALTER_TABLES_TO_ADD_FOLLOWED_ATTRIBUTES [ 115601 ]

Hide

Permalink

Marwan Kanaan added a comment - 18/Aug/25 1:48 PM

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

Show

Marwan Kanaan added a comment - 18/Aug/25 1:48 PM 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

Marwan Kanaan made changes - 18/Aug/25 1:48 PM

Status

Implementation in progress [ 10016 ]

To Be Released [ 10400 ]

Marwan Kanaan made changes - 18/Aug/25 1:49 PM

Time Spent	1 day, 6 hours [ 50400 ]	2 days, 6 hours [ 79200 ]
Worklog Id	274734 [ 274734 ]

Hide

Permalink

Indrasan Yadav added a comment - 19/Aug/25 8:57 AM

Dear @Basant Kumar,

Please deploy the given patch on .102.

patch 3.7.0.1338.

Thank you
Indrasan

Show

Indrasan Yadav added a comment - 19/Aug/25 8:57 AM Dear @Basant Kumar, Please deploy the given patch on .102. patch 3.7.0.1338. Thank you Indrasan

Khaled Khalil made changes - 19/Aug/25 10:01 AM

Status	To Be Released [ 10400 ]	Ready for QA [ 10023 ]
Assignee	Marwan Kanaan [ mkanaan ]	Indrasan Yadav [ iyadav ]

Hide

Permalink

Indrasan Yadav added a comment - 19/Aug/25 10:21 AM

Dear Indrasan ,

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

Regards,
Basant

Show

Indrasan Yadav added a comment - 19/Aug/25 10:21 AM Dear Indrasan , patch 3.7.0.1338 has been deployed on 102 platform and query has bee executed . Regards, Basant

Permalink

Marwan Kanaan logged work - 20/Aug/25 12:00 AM

Time Spent:

6 hours

I found an issue in the previous patch that was causing a fatal error. After debugging, the problem was identified and has now been resolved

Permalink

Aurobinda Panda logged work - 20/Aug/25 12:00 AM

Time Spent:

1 hour

Implementation is checked in NEP for various project of OmanTel. Found OK.

Permalink

Basant Kumar logged work - 20/Aug/25 12:00 AM

Time Spent:

1 hour

Need To Add Insert & Update Date In Reports for patch deployed .

Hide

Permalink

Marwan Kanaan added a comment - 20/Aug/25 12:26 PM

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

Show

Marwan Kanaan added a comment - 20/Aug/25 12:26 PM 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

Marwan Kanaan made changes - 20/Aug/25 12:28 PM

Time Spent	2 days, 6 hours [ 79200 ]	3 days, 4 hours [ 100800 ]
Worklog Id	275005 [ 275005 ]

Aurobinda Panda made changes - 20/Aug/25 12:36 PM

Time Spent	3 days, 4 hours [ 100800 ]	3 days, 5 hours [ 104400 ]
Worklog Id	275006 [ 275006 ]

Permalink

Indrasan Yadav logged work - 21/Aug/25 12:00 AM

Time Spent:

30 minutes

Mail received from NEP DEV for latest patch which will cover this issue, aske to Integration to deploy the patch on .102 and follow the same.

Hide

Permalink

Indrasan Yadav added a comment - 22/Aug/25 11:07 AM

Dear @Basant Kumar,

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

patch 3.7.0.1340

Thank you
Indrasan

Show

Indrasan Yadav added a comment - 22/Aug/25 11:07 AM Dear @Basant Kumar, Could you please deploy the below patch on platform .102? patch 3.7.0.1340 Thank you Indrasan

Hide

Permalink

Indrasan Yadav added a comment - 22/Aug/25 11:08 AM

Dear Indrasan ,

patch 3.7.0.1340 has been successfully deployed on .102 platform .

Regards,
Basant

Show

Indrasan Yadav added a comment - 22/Aug/25 11:08 AM Dear Indrasan , patch 3.7.0.1340 has been successfully deployed on .102 platform . Regards, Basant

Indrasan Yadav made changes - 22/Aug/25 11:56 AM

Time Spent	3 days, 5 hours [ 104400 ]	3 days, 5 hours, 30 minutes [ 106200 ]
Worklog Id	275238 [ 275238 ]

Basant Kumar made changes - 25/Aug/25 5:59 AM

Time Spent	3 days, 5 hours, 30 minutes [ 106200 ]	3 days, 6 hours, 30 minutes [ 109800 ]
Worklog Id	275336 [ 275336 ]

Hide

Permalink

Indrasan Yadav added a comment - 03/Sep/25 8:49 AM

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)

Show

Indrasan Yadav added a comment - 03/Sep/25 8:49 AM 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)

Hide

Permalink

Indrasan Yadav added a comment - 12/Sep/25 9:44 AM

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

Show

Indrasan Yadav added a comment - 12/Sep/25 9:44 AM Once I will import any xml for RAN then recheck it and confirm about final status.

Permalink

Indrasan Yadav logged work - 15/Sep/25 12:00 AM

Time Spent:

1 hour

Checked & validate for this issue and now it is fixed.

Hide

Permalink

Indrasan Yadav added a comment - 15/Sep/25 5:44 AM

Insert & update date is available in all report.

Show

Indrasan Yadav added a comment - 15/Sep/25 5:44 AM Insert & update date is available in all report.

Indrasan Yadav made changes - 15/Sep/25 5:45 AM

Status

Ready for QA [ 10023 ]

QA In Progress [ 10015 ]

Indrasan Yadav made changes - 15/Sep/25 5:46 AM

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

Indrasan Yadav made changes - 15/Sep/25 6:04 AM

Time Spent	3 days, 6 hours, 30 minutes [ 109800 ]	3 days, 7 hours, 30 minutes [ 113400 ]
Worklog Id	277407 [ 277407 ]

Maher Ben Nacef made changes - 30/Mar/26 9:15 AM

Link

This issue is blocked by ACE-768 [ ACE-768 ]

Transition

Time In Source Status

Execution Times

Last Executer

Last Execution Date

Opened

Pending Requirements

36d 46m

Hassan Abdine

13/Aug/25 7:37 AM

Pending Requirements

Pending Design Session

Hassan Abdine

13/Aug/25 7:37 AM

Pending Design Session

Dev Scheduled

13s

Hassan Abdine

13/Aug/25 7:37 AM

Dev Scheduled

Implementation in progress

26m 31s

Marwan Kanaan

13/Aug/25 8:04 AM

Implementation in progress

To Be Released

5d 5h 44m

Marwan Kanaan

18/Aug/25 1:48 PM

To Be Released

Ready for QA

20h 13m

Khaled Khalil

19/Aug/25 10:01 AM

Ready for QA

QA In Progress

26d 19h 44m

Indrasan Yadav

15/Sep/25 5:45 AM

QA In Progress

Closed

17s

Indrasan Yadav

15/Sep/25 5:46 AM

Invalid license: EXPIRED

People

Assignee:

Indrasan Yadav

Reporter:

Indrasan Yadav

Votes:

0 Vote for this issue

Watchers:

2 Start watching this issue

Dates

Due:

14/Jul/25

Created:

08/Jul/25 6:50 AM

Updated:

30/Mar/26 9:15 AM

Resolved:

15/Sep/25 5:46 AM

Planned Start:

14/Jul/25 12:00 AM

Planned End:

14/Jul/25 12:00 AM

Actual Start:

08/Jul/25 12:00 AM

Date of Baselining:

09/Jul/25 4:36 AM

Time Tracking

Estimated:

Not Specified

Remaining:

Logged:

3d 7h 30m

Agile

View on Board

Drag and Drop