[OT-85] Huawei RAN Data Validation In Staging-DB - Mobinets-JIRA

Details

Type: Task
Status: Closed (View Workflow)
Priority: Normal
Resolution: Fixed
Labels:
- AI_All_incidents
- Huawei_RAN_OO

Customer:

Ooreedo Tunisia

Description

Dear @Jharna Thakur,

As I requested to @Basant Kumar yesterday to generate the XML for Huawei RAN and upload the CSV output on staging DB (IMPORTERID='20251015115622_2025-10-15-11.56.22'), after upload done I checked the data on staging DB.

Could you please review the following points identified during data validation in the staging database for Huawei RAN:

1. Counts Verified (OK):

The data count is correct for the following tables:
Cabinet, Shelf, Slot, BSC, eNodeB, SRAN, RNC, Site, Role2G, Role3G.

2. Counts Not OK (Incomplete Data Uploaded):

The data count is incomplete for the following tables:
Boards, Error Alarms, Network Elements Dump, AddInfos.

3. No Data Uploaded:

The following tables currently have no data uploaded:
eNodeB Bandwidths, GSM Cell MAIO, IP Data, Loopback Interface, 4G Cell, Net Status, 2G Cell, 3G Cell, TRX, Radio Antenna, Sub Interfaces, 3G Carrier, TRX ARFCN, Virtual Interfaces, Cell Radio Bandwidths, Cell Tracking Area.

4. Extra Data Observed:

Extra/unexpected data is appearing in the following table:
Node Interfaces.

5. Importer Connector:

The importer connector is still not appearing as per given in FRS as mentioned in ~~OT-83~~. You may coordinate with @Sandya Sharma to resolve this issue.

6. Remaining Validation Points:

The remaining common points for confirmation have already been raised under ~~OT-84~~ (being handled by Sandya).

Thank you,
Indrasan

Activity

Ascending order - Click to sort in descending order

Indrasan Yadav made changes - 29/Sep/25 11:39 AM

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

Indrasan Yadav made changes - 29/Sep/25 11:41 AM

Assignee

Indrasan Yadav [ iyadav ]

Indrasan Yadav made changes - 15/Oct/25 1:49 PM

Remaining Estimate		0 minutes [ 0 ]
Time Spent		4 hours [ 14400 ]
Worklog Id	280483 [ 280483 ]

Indrasan Yadav made changes - 15/Oct/25 1:49 PM

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

Indrasan Yadav made changes - 16/Oct/25 1:43 PM

Assignee

Indrasan Yadav [ iyadav ]

Jharna Thakur [ jthakur ]

Indrasan Yadav made changes - 16/Oct/25 1:44 PM

Description

Dear @Jharna Thakur,

As I requested to @Basant Kumar yesterday to generate the XML for Huawei RAN and upload the CSV output on staging DB (IMPORTERID='20251015115622_2025-10-15-11.56.22'), after upload done I checked the data on staging DB.

Could you please review the following points identified during data validation in the staging database for Huawei RAN:

1. Counts Verified (OK):

The data count is correct for the following tables:
Cabinet, Shelf, Slot, BSC, eNodeB, SRAN, RNC, Site, Role2G, Role3G.

2. Counts Not OK (Incomplete Data Uploaded):

The data count is incomplete for the following tables:
Boards, Error Alarms, Network Elements Dump, AddInfos.

3. No Data Uploaded:

The following tables currently have no data uploaded:
eNodeB Bandwidths, GSM Cell MAIO, IP Data, Loopback Interface, 4G Cell, Net Status, 2G Cell, 3G Cell, TRX, Radio Antenna, Sub Interfaces, 3G Carrier, TRX ARFCN, Virtual Interfaces, Cell Radio Bandwidths, Cell Tracking Area.

4. Extra Data Observed:

Extra/unexpected data is appearing in the following table:
Node Interfaces.

5. Importer Connector:

The importer connector is still not appearing as per given in FRS as mentioned in ~~OT-83~~. You may coordinate with @Sandya Sharma to resolve this issue.

6. Remaining Validation Points:

The remaining common points for confirmation have already been raised under ~~OT-84~~ (being handled by Sandya).

Thank you,
Indrasan

Indrasan Yadav made changes - 16/Oct/25 1:45 PM

Time Spent	4 hours [ 14400 ]	1 day [ 28800 ]
Worklog Id	280672 [ 280672 ]

Indrasan Yadav made changes - 22/Oct/25 10:44 AM

Time Spent	1 day [ 28800 ]	1 day, 1 hour, 30 minutes [ 34200 ]
Worklog Id	281145 [ 281145 ]

Basant Kumar made changes - 22/Oct/25 11:28 AM

Time Spent	1 day, 1 hour, 30 minutes [ 34200 ]	1 day, 2 hours, 30 minutes [ 37800 ]
Worklog Id	281161 [ 281161 ]

Indrasan Yadav made changes - 24/Oct/25 7:02 AM

Time Spent	1 day, 2 hours, 30 minutes [ 37800 ]	1 day, 3 hours, 30 minutes [ 41400 ]
Worklog Id	281428 [ 281428 ]

Basant Kumar made changes - 24/Oct/25 1:42 PM

Time Spent	1 day, 3 hours, 30 minutes [ 41400 ]	1 day, 4 hours, 30 minutes [ 45000 ]
Worklog Id	281520 [ 281520 ]

Jharna Thakur made changes - 27/Oct/25 4:40 AM

Time Spent	1 day, 4 hours, 30 minutes [ 45000 ]	1 day, 5 hours, 30 minutes [ 48600 ]
Worklog Id	281614 [ 281614 ]

Sanju Yadav made changes - 27/Oct/25 4:45 AM

Time Spent	1 day, 5 hours, 30 minutes [ 48600 ]	1 day, 5 hours, 40 minutes [ 49200 ]
Worklog Id	281621 [ 281621 ]

Bassem Sabbagh made changes - 27/Oct/25 6:11 AM

Assignee

Jharna Thakur [ jthakur ]

Indrasan Yadav [ iyadav ]

Sanju Yadav made changes - 27/Oct/25 8:08 AM

Time Spent	1 day, 5 hours, 40 minutes [ 49200 ]	1 day, 7 hours, 40 minutes [ 56400 ]
Worklog Id	281651 [ 281651 ]

Basant Kumar made changes - 28/Oct/25 4:25 AM

Time Spent	1 day, 7 hours, 40 minutes [ 56400 ]	2 days, 1 hour, 40 minutes [ 63600 ]
Worklog Id	281805 [ 281805 ]

Basant Kumar made changes - 28/Oct/25 4:26 AM

Worklog Id

281805 [ 281805 ]

Indrasan Yadav made changes - 28/Oct/25 9:30 AM

Time Spent	2 days, 1 hour, 40 minutes [ 63600 ]	2 days, 4 hours, 10 minutes [ 72600 ]
Worklog Id	281898 [ 281898 ]

Indrasan Yadav made changes - 28/Oct/25 9:52 AM

Assignee

Indrasan Yadav [ iyadav ]

Jharna Thakur [ jthakur ]

Jharna Thakur made changes - 28/Oct/25 10:59 AM

Time Spent	2 days, 4 hours, 10 minutes [ 72600 ]	2 days, 7 hours, 10 minutes [ 83400 ]
Worklog Id	281909 [ 281909 ]

Indrasan Yadav made changes - 28/Oct/25 12:23 PM

Worklog Id

281898 [ 281898 ]

Indrasan Yadav made changes - 28/Oct/25 12:23 PM

Time Spent	2 days, 7 hours, 10 minutes [ 83400 ]	3 days, 10 minutes [ 87000 ]
Worklog Id	281898 [ 281898 ]

Indrasan Yadav made changes - 28/Oct/25 12:24 PM

Worklog Id

281898 [ 281898 ]

Indrasan Yadav made changes - 28/Oct/25 12:24 PM

Time Spent	3 days, 10 minutes [ 87000 ]	3 days, 1 hour, 10 minutes [ 90600 ]
Worklog Id	281898 [ 281898 ]

Indrasan Yadav made changes - 29/Oct/25 8:49 AM

Time Spent	3 days, 1 hour, 10 minutes [ 90600 ]	3 days, 2 hours, 40 minutes [ 96000 ]
Worklog Id	282022 [ 282022 ]

Jharna Thakur made changes - 30/Oct/25 4:59 AM

Time Spent	3 days, 2 hours, 40 minutes [ 96000 ]	3 days, 4 hours, 40 minutes [ 103200 ]
Worklog Id	282119 [ 282119 ]

Jharna Thakur made changes - 03/Nov/25 7:04 AM

Time Spent	3 days, 4 hours, 40 minutes [ 103200 ]	4 days, 10 minutes [ 115800 ]
Worklog Id	282437 [ 282437 ]

Basant Kumar made changes - 04/Nov/25 11:45 AM

Time Spent	4 days, 10 minutes [ 115800 ]	4 days, 1 hour, 10 minutes [ 119400 ]
Worklog Id	282562 [ 282562 ]

Bassem Sabbagh made changes - 05/Nov/25 5:15 AM

Status	Opened [ 1 ]	In Progress [ 3 ]
Assignee	Jharna Thakur [ jthakur ]	Bassem Sabbagh [ bsabbagh ]

Bassem Sabbagh made changes - 05/Nov/25 5:16 AM

Assignee

Bassem Sabbagh [ bsabbagh ]

Jharna Thakur [ jthakur ]

Jharna Thakur made changes - 05/Nov/25 6:03 AM

Assignee

Jharna Thakur [ jthakur ]

Indrasan Yadav [ iyadav ]

Basant Kumar made changes - 05/Nov/25 10:41 AM

Time Spent	4 days, 1 hour, 10 minutes [ 119400 ]	4 days, 2 hours, 10 minutes [ 123000 ]
Worklog Id	282640 [ 282640 ]

Jharna Thakur made changes - 06/Nov/25 4:12 AM

Time Spent	4 days, 2 hours, 10 minutes [ 123000 ]	4 days, 5 hours, 40 minutes [ 135600 ]
Worklog Id	282710 [ 282710 ]

Indrasan Yadav made changes - 06/Nov/25 7:17 AM

Assignee

Indrasan Yadav [ iyadav ]

Jharna Thakur [ jthakur ]

Jharna Thakur made changes - 07/Nov/25 10:36 AM

Time Spent	4 days, 5 hours, 40 minutes [ 135600 ]	4 days, 7 hours, 10 minutes [ 141000 ]
Worklog Id	282816 [ 282816 ]

Jharna Thakur made changes - 07/Nov/25 10:38 AM

Time Spent	4 days, 7 hours, 10 minutes [ 141000 ]	1 week, 4 hours, 40 minutes [ 160800 ]
Worklog Id	282820 [ 282820 ]

Indrasan Yadav made changes - 07/Nov/25 11:38 AM

Time Spent	1 week, 4 hours, 40 minutes [ 160800 ]	1 week, 1 day, 1 hour, 10 minutes [ 177000 ]
Worklog Id	282839 [ 282839 ]

Indrasan Yadav made changes - 07/Nov/25 11:39 AM

Time Spent	1 week, 1 day, 1 hour, 10 minutes [ 177000 ]	1 week, 1 day, 2 hours, 10 minutes [ 180600 ]
Worklog Id	282839 [ 282839 ]

Indrasan Yadav made changes - 07/Nov/25 11:40 AM

Time Spent	1 week, 1 day, 2 hours, 10 minutes [ 180600 ]	1 week, 1 day, 2 hours, 40 minutes [ 182400 ]
Worklog Id	282841 [ 282841 ]

Jharna Thakur made changes - 10/Nov/25 9:05 AM

Assignee

Jharna Thakur [ jthakur ]

Indrasan Yadav [ iyadav ]

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

Time Spent	1 week, 1 day, 2 hours, 40 minutes [ 182400 ]	1 week, 1 day, 3 hours, 40 minutes [ 186000 ]
Worklog Id	283100 [ 283100 ]

Jharna Thakur made changes - 12/Nov/25 4:25 AM

Time Spent	1 week, 1 day, 3 hours, 40 minutes [ 186000 ]	1 week, 1 day, 6 hours, 40 minutes [ 196800 ]
Worklog Id	283106 [ 283106 ]

Indrasan Yadav made changes - 12/Nov/25 10:32 AM

Assignee

Indrasan Yadav [ iyadav ]

Jharna Thakur [ jthakur ]

Indrasan Yadav made changes - 12/Nov/25 11:28 AM

Time Spent	1 week, 1 day, 6 hours, 40 minutes [ 196800 ]	1 week, 2 days, 3 hours, 40 minutes [ 214800 ]
Worklog Id	283160 [ 283160 ]

Indrasan Yadav made changes - 12/Nov/25 11:30 AM

Time Spent	1 week, 2 days, 3 hours, 40 minutes [ 214800 ]	1 week, 2 days, 7 hours, 40 minutes [ 229200 ]
Worklog Id	283162 [ 283162 ]

Indrasan Yadav made changes - 12/Nov/25 11:30 AM

Remaining Estimate	0 minutes [ 0 ]	5 hours [ 18000 ]
Time Spent	1 week, 2 days, 7 hours, 40 minutes [ 229200 ]	1 week, 2 days, 2 hours, 40 minutes [ 211200 ]
Worklog Id	283160 [ 283160 ]
Worklog Time Spent	5 hours [ 18000 ]

Bassem Sabbagh made changes - 13/Nov/25 5:46 AM

Assignee

Jharna Thakur [ jthakur ]

Indrasan Yadav [ iyadav ]

Sanju Yadav made changes - 13/Nov/25 6:14 AM

Remaining Estimate	5 hours [ 18000 ]	4 hours, 45 minutes [ 17100 ]
Time Spent	1 week, 2 days, 2 hours, 40 minutes [ 211200 ]	1 week, 2 days, 2 hours, 55 minutes [ 212100 ]
Worklog Id	283213 [ 283213 ]

Basant Kumar made changes - 13/Nov/25 10:17 AM

Remaining Estimate	4 hours, 45 minutes [ 17100 ]	3 hours, 45 minutes [ 13500 ]
Time Spent	1 week, 2 days, 2 hours, 55 minutes [ 212100 ]	1 week, 2 days, 3 hours, 55 minutes [ 215700 ]
Worklog Id	283240 [ 283240 ]

Indrasan Yadav made changes - 14/Nov/25 11:31 AM

Remaining Estimate	3 hours, 45 minutes [ 13500 ]	2 hours, 45 minutes [ 9900 ]
Time Spent	1 week, 2 days, 3 hours, 55 minutes [ 215700 ]	1 week, 2 days, 4 hours, 55 minutes [ 219300 ]
Worklog Id	283350 [ 283350 ]

Jharna Thakur made changes - 17/Nov/25 3:48 AM

Remaining Estimate	2 hours, 45 minutes [ 9900 ]	0 minutes [ 0 ]
Time Spent	1 week, 2 days, 4 hours, 55 minutes [ 219300 ]	1 week, 3 days, 1 hour, 25 minutes [ 235500 ]
Worklog Id	283500 [ 283500 ]

Jharna Thakur made changes - 17/Nov/25 3:52 AM

Time Spent	1 week, 3 days, 1 hour, 25 minutes [ 235500 ]	1 week, 3 days, 6 hours, 25 minutes [ 253500 ]
Worklog Id	283503 [ 283503 ]

Basant Kumar made changes - 18/Nov/25 1:58 PM

Time Spent	1 week, 3 days, 6 hours, 25 minutes [ 253500 ]	1 week, 4 days, 25 minutes [ 260700 ]
Worklog Id	283733 [ 283733 ]

Jharna Thakur made changes - 20/Nov/25 11:09 AM

Time Spent	1 week, 4 days, 25 minutes [ 260700 ]	1 week, 4 days, 3 hours, 55 minutes [ 273300 ]
Worklog Id	283925 [ 283925 ]

Jharna Thakur made changes - 20/Nov/25 11:09 AM

Time Spent	1 week, 4 days, 3 hours, 55 minutes [ 273300 ]	1 week, 4 days, 4 hours, 25 minutes [ 275100 ]
Worklog Id	283925 [ 283925 ]

Jharna Thakur made changes - 25/Nov/25 6:21 AM

Time Spent	1 week, 4 days, 4 hours, 25 minutes [ 275100 ]	1 week, 4 days, 6 hours, 25 minutes [ 282300 ]
Worklog Id	284234 [ 284234 ]

Jharna Thakur made changes - 01/Dec/25 5:42 AM

Time Spent	1 week, 4 days, 6 hours, 25 minutes [ 282300 ]	2 weeks, 40 minutes [ 290400 ]
Worklog Id	284906 [ 284906 ]

Indrasan Yadav made changes - 09/Dec/25 5:02 AM

Status

In Progress [ 3 ]

Opened [ 1 ]

Indrasan Yadav made changes - 30/Dec/25 3:54 AM

Assignee

Indrasan Yadav [ iyadav ]

Jharna Thakur [ jthakur ]

Jharna Thakur made changes - 30/Dec/25 4:25 AM

Assignee

Jharna Thakur [ jthakur ]

Indrasan Yadav [ iyadav ]

Indrasan Yadav made changes - 30/Dec/25 6:23 AM

Time Spent	2 weeks, 40 minutes [ 290400 ]	2 weeks, 2 hours, 40 minutes [ 297600 ]
Worklog Id	287518 [ 287518 ]

Indrasan Yadav made changes - 31/Dec/25 10:16 AM

Time Spent	2 weeks, 2 hours, 40 minutes [ 297600 ]	2 weeks, 4 hours, 10 minutes [ 303000 ]
Worklog Id	287832 [ 287832 ]

Indrasan Yadav made changes - 31/Dec/25 10:22 AM

Time Spent	2 weeks, 4 hours, 10 minutes [ 303000 ]	2 weeks, 5 hours, 10 minutes [ 306600 ]
Worklog Id	287839 [ 287839 ]

Indrasan Yadav made changes - 31/Dec/25 10:39 AM

Status

Opened [ 1 ]

In Progress [ 3 ]

Indrasan Yadav made changes - 02/Jan/26 5:14 AM

Assignee

Indrasan Yadav [ iyadav ]

Jharna Thakur [ jthakur ]

Jharna Thakur made changes - 07/Jan/26 4:35 AM

Assignee

Jharna Thakur [ jthakur ]

Indrasan Yadav [ iyadav ]

Jharna Thakur made changes - 07/Jan/26 4:35 AM

Comment

[ I have checked the staging database and issues have now been resolved.
Previously, the Omantel connector was executed instead of the Ooredoo Huawei RAN connector, which caused the discrepancy. This has been corrected. ]

Basant Kumar made changes - 07/Jan/26 7:55 AM

Time Spent	2 weeks, 5 hours, 10 minutes [ 306600 ]	2 weeks, 6 hours, 10 minutes [ 310200 ]
Worklog Id	288320 [ 288320 ]

Indrasan Yadav made changes - 07/Jan/26 10:25 AM

Status

In Progress [ 3 ]

Opened [ 1 ]

Indrasan Yadav made changes - 07/Jan/26 10:25 AM

Status	Opened [ 1 ]	Resolved [ 5 ]
Resolution		Fixed [ 1 ]

Indrasan Yadav made changes - 07/Jan/26 10:26 AM

Status

Resolved [ 5 ]

Closed [ 6 ]

Indrasan Yadav made changes - 07/Jan/26 10:49 AM

Resolution	Fixed [ 1 ]
Status	Closed [ 6 ]	Reopened [ 4 ]

Indrasan Yadav made changes - 07/Jan/26 10:50 AM

Status	Reopened [ 4 ]	Resolved [ 5 ]
Resolution		Fixed [ 1 ]

Indrasan Yadav made changes - 07/Jan/26 10:53 AM

Time Spent	2 weeks, 6 hours, 10 minutes [ 310200 ]	2 weeks, 1 day, 2 hours, 40 minutes [ 326400 ]
Worklog Id	288343 [ 288343 ]

Indrasan Yadav made changes - 07/Jan/26 11:11 AM

Worklog Id

288343 [ 288343 ]

Basant Kumar made changes - 07/Jan/26 2:43 PM

Time Spent	2 weeks, 1 day, 2 hours, 40 minutes [ 326400 ]	2 weeks, 1 day, 3 hours, 40 minutes [ 330000 ]
Worklog Id	288354 [ 288354 ]

Jharna Thakur made changes - 08/Jan/26 4:05 AM

Time Spent	2 weeks, 1 day, 3 hours, 40 minutes [ 330000 ]	2 weeks, 1 day, 5 hours, 40 minutes [ 337200 ]
Worklog Id	288402 [ 288402 ]

Jharna Thakur made changes - 08/Jan/26 4:07 AM

Time Spent	2 weeks, 1 day, 5 hours, 40 minutes [ 337200 ]	2 weeks, 1 day, 7 hours, 10 minutes [ 342600 ]
Worklog Id	288403 [ 288403 ]

Jharna Thakur made changes - 08/Jan/26 4:07 AM

Time Spent	2 weeks, 1 day, 7 hours, 10 minutes [ 342600 ]	2 weeks, 1 day, 7 hours, 40 minutes [ 344400 ]
Worklog Id	288402 [ 288402 ]

Indrasan Yadav made changes - 09/Jan/26 8:59 AM

Assignee

Indrasan Yadav [ iyadav ]

Jharna Thakur [ jthakur ]

Indrasan Yadav made changes - 09/Jan/26 11:27 AM

Time Spent	2 weeks, 1 day, 7 hours, 40 minutes [ 344400 ]	2 weeks, 2 days, 3 hours, 10 minutes [ 357000 ]
Worklog Id	288551 [ 288551 ]

Bassem Sabbagh made changes - 12/Jan/26 7:15 AM

Assignee

Jharna Thakur [ jthakur ]

Indrasan Yadav [ iyadav ]

Indrasan Yadav made changes - 13/Jan/26 11:07 AM

Status

Resolved [ 5 ]

Closed [ 6 ]

Indrasan Yadav made changes - 13/Jan/26 12:02 PM

Resolution	Fixed [ 1 ]
Status	Closed [ 6 ]	Reopened [ 4 ]

Indrasan Yadav made changes - 13/Jan/26 12:03 PM

Time Spent	2 weeks, 2 days, 3 hours, 10 minutes [ 357000 ]	2 weeks, 2 days, 6 hours, 10 minutes [ 367800 ]
Worklog Id	288723 [ 288723 ]

Indrasan Yadav made changes - 13/Jan/26 12:03 PM

Remaining Estimate	0 minutes [ 0 ]	30 minutes [ 1800 ]
Time Spent	2 weeks, 2 days, 6 hours, 10 minutes [ 367800 ]	2 weeks, 2 days, 5 hours, 40 minutes [ 366000 ]
Worklog Id	288723 [ 288723 ]

Indrasan Yadav made changes - 13/Jan/26 12:06 PM

Status	Reopened [ 4 ]	Resolved [ 5 ]
Resolution		Fixed [ 1 ]

Indrasan Yadav made changes - 13/Jan/26 12:07 PM

Status

Resolved [ 5 ]

Closed [ 6 ]

People

Assignee:

Indrasan Yadav

Reporter:

Indrasan Yadav

Votes:

1 Vote for this issue

Watchers:

3 Start watching this issue

Dates

Due:

30/Nov/25

Created:

29/Sep/25 11:39 AM

Updated:

13/Jan/26 12:07 PM

Resolved:

13/Jan/26 12:06 PM

Planned Start:

30/Nov/25 12:00 AM

Planned End:

30/Nov/25 12:00 AM

Actual Start:

15/Oct/25 12:00 AM

Actual End:

13/Jan/26 12:06 PM

Date of Baselining:

15/Oct/25 1:49 PM

Time Tracking

Estimated:

Not Specified

Remaining:

30m

Logged:

2w 2d 5h 40m

Agile

View on Board