Details
-
Type:
Task
-
Status:
Closed
(View Workflow)
-
Priority:
Normal
-
Resolution: Fixed
-
Labels:
-
Customer:Ooreedo Tunisia
Description
Dear @Driss Chibane,
Could you please confirm the following points that I observed during data validation in the staging-DB for Nokia RAN:
1. On checking randomly across some tables for nodes like BSC/RNC/SRAN/BTS/NodeB/eNodeB, I found:
o Only the RNC table exists, but its data is blank (While data is available in CSV-Output).
o BTS is available under the table “Element_Node”.
My question is: since we validated all the CSVs earlier, under which table names and locations in the staging-DB should each dataset be available?
It would be very helpful if you could share a mapping/list that clearly describes which CSV data corresponds to which tables in S-DB.
(Element_Node snippet)
(RNC snippet)
Thank you
Indrasan
Activity
| 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) |
| Assignee | Indrasan Yadav [ iyadav ] |
| Remaining Estimate | 0 minutes [ 0 ] | |
| Time Spent | 2 hours, 30 minutes [ 9000 ] | |
| Worklog Id | 279001 [ 279001 ] |
| 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) |
| Description |
Dear @Driss Chibane,
Could you please confirm the following points that I observed during data validation in the staging-DB for Nokia RAN: 1. On checking randomly across some tables for nodes like BSC/RNC/SRAN/BTS/NodeB/eNodeB, I found: o Only the RNC table exists, but its data is blank (While data is available in CSV-Output). o BTS is available under the table “Element_Node”. My question is: since we validated all the CSVs earlier, under which table names and locations in the staging-DB should each dataset be available? It would be very helpful if you could share a mapping/list that clearly describes which CSV data corresponds to which tables in S-DB. (Element_Node snippet) (RNC snippet) Thank you Indrasan |
| Attachment | (RNC snippet).png [ 118702 ] | |
| Attachment | (Element_Node snippet).png [ 118703 ] |
| Attachment | Table Comparison.xlsx [ 118704 ] |
| Assignee | Indrasan Yadav [ iyadav ] | Sandya Sharma [ ssharma ] |
| Time Spent | 2 hours, 30 minutes [ 9000 ] | 4 hours, 30 minutes [ 16200 ] |
| Worklog Id | 279025 [ 279025 ] |
| Time Spent | 4 hours, 30 minutes [ 16200 ] | 6 hours, 30 minutes [ 23400 ] |
| Worklog Id | 279168 [ 279168 ] |
| Time Spent | 6 hours, 30 minutes [ 23400 ] | 7 hours [ 25200 ] |
| Worklog Id | 279413 [ 279413 ] |
| Assignee | Sandya Sharma [ ssharma ] | Indrasan Yadav [ iyadav ] |
| Time Spent | 7 hours [ 25200 ] | 1 day, 1 hour [ 32400 ] |
| Worklog Id | 279602 [ 279602 ] |
| Time Spent | 1 day, 1 hour [ 32400 ] | 2 days [ 57600 ] |
| Worklog Id | 279821 [ 279821 ] |
| Time Spent | 2 days [ 57600 ] | 2 days, 6 hours [ 79200 ] |
| Worklog Id | 280109 [ 280109 ] |
| Status | Opened [ 1 ] | In Progress [ 3 ] |
| Time Spent | 2 days, 6 hours [ 79200 ] | 3 days, 5 hours [ 104400 ] |
| Worklog Id | 280207 [ 280207 ] |
| Assignee | Indrasan Yadav [ iyadav ] | Sandya Sharma [ ssharma ] |
| Attachment | Table Comparison.xlsx [ 118704 ] |
| Attachment | Table Comparison.xlsx [ 119703 ] |
| Time Spent | 3 days, 5 hours [ 104400 ] | 3 days, 7 hours [ 111600 ] |
| Worklog Id | 280372 [ 280372 ] |
| Time Spent | 3 days, 7 hours [ 111600 ] | 4 days, 5 hours [ 133200 ] |
| Worklog Id | 280606 [ 280606 ] |
| Attachment | Table Comparison.xlsx [ 119905 ] |
| Time Spent | 4 days, 5 hours [ 133200 ] | 4 days, 5 hours, 30 minutes [ 135000 ] |
| Worklog Id | 280654 [ 280654 ] |
| Worklog Id | 280654 [ 280654 ] |
| Time Spent | 4 days, 5 hours, 30 minutes [ 135000 ] | 1 week, 3 hours, 30 minutes [ 156600 ] |
| Worklog Id | 280718 [ 280718 ] |
| Assignee | Sandya Sharma [ ssharma ] | Indrasan Yadav [ iyadav ] |
| Time Spent | 1 week, 3 hours, 30 minutes [ 156600 ] | 1 week, 1 day, 2 hours, 30 minutes [ 181800 ] |
| Worklog Id | 280766 [ 280766 ] |
| Time Spent | 1 week, 1 day, 2 hours, 30 minutes [ 181800 ] | 1 week, 1 day, 3 hours [ 183600 ] |
| Worklog Id | 281146 [ 281146 ] |
| Attachment | Table Comparison_24-10-2025.xlsx [ 120508 ] |
| Comment |
[ Table remarks:
I am sharing my feedback regarding the doubts mentioned in the attached table. The points highlighted in yellow are still pending, while the remaining items have been cleared. __________________________________________ I have validated the data in the staging database based on the CSV output uploaded by @Basant Kumar, which you shared on 17-10-2025 here on same email (Importer ID: 20251024091640_2025-10-24-09.16.40). Please find my validation remarks below: 1. As we discussed you confirmed with Driss, the extra header will be retained as it is. 2. The issue where I had commented “Should be parse” is still not fully resolved in some places. Please refer to my first email in this thread — I have highlighted in yellow the areas where it has been fixed. ] |
| Time Spent | 1 week, 1 day, 3 hours [ 183600 ] | 1 week, 1 day, 4 hours [ 187200 ] |
| Worklog Id | 281528 [ 281528 ] |
| Time Spent | 1 week, 1 day, 4 hours [ 187200 ] | 1 week, 1 day, 6 hours [ 194400 ] |
| Worklog Id | 281544 [ 281544 ] |
| Attachment | Table Comparison_24-10-2025.xlsx [ 120604 ] |
| Assignee | Indrasan Yadav [ iyadav ] | Sandya Sharma [ ssharma ] |
| Time Spent | 1 week, 1 day, 6 hours [ 194400 ] | 1 week, 2 days, 1 hour [ 205200 ] |
| Worklog Id | 281650 [ 281650 ] |
| Time Spent | 1 week, 2 days, 1 hour [ 205200 ] | 1 week, 2 days, 2 hours, 30 minutes [ 210600 ] |
| Worklog Id | 281650 [ 281650 ] |
| Time Spent | 1 week, 2 days, 2 hours, 30 minutes [ 210600 ] | 1 week, 2 days, 3 hours, 30 minutes [ 214200 ] |
| Worklog Id | 281803 [ 281803 ] |
| Time Spent | 1 week, 2 days, 3 hours, 30 minutes [ 214200 ] | 1 week, 2 days, 5 hours, 30 minutes [ 221400 ] |
| Worklog Id | 281930 [ 281930 ] |
| Time Spent | 1 week, 2 days, 5 hours, 30 minutes [ 221400 ] | 1 week, 3 days, 3 hours, 30 minutes [ 243000 ] |
| Worklog Id | 282003 [ 282003 ] |
| Time Spent | 1 week, 3 days, 3 hours, 30 minutes [ 243000 ] | 1 week, 3 days, 4 hours, 30 minutes [ 246600 ] |
| Worklog Id | 282023 [ 282023 ] |
| Time Spent | 1 week, 3 days, 4 hours, 30 minutes [ 246600 ] | 1 week, 4 days, 2 hours, 30 minutes [ 268200 ] |
| Worklog Id | 282103 [ 282103 ] |
| Assignee | Sandya Sharma [ ssharma ] | Indrasan Yadav [ iyadav ] |
| Assignee | Indrasan Yadav [ iyadav ] | Sandya Sharma [ ssharma ] |
| Attachment | OT_NSN-RAN_FRS_4G_Logical.docx [ 121205 ] |
| Time Spent | 1 week, 4 days, 2 hours, 30 minutes [ 268200 ] | 1 week, 4 days, 3 hours, 30 minutes [ 271800 ] |
| Worklog Id | 282549 [ 282549 ] |
| Time Spent | 1 week, 4 days, 3 hours, 30 minutes [ 271800 ] | 2 weeks [ 288000 ] |
| Worklog Id | 282563 [ 282563 ] |
| Time Spent | 2 weeks [ 288000 ] | 2 weeks, 6 hours [ 309600 ] |
| Worklog Id | 282576 [ 282576 ] |
| Time Spent | 2 weeks, 6 hours [ 309600 ] | 2 weeks, 1 day, 3 hours [ 327600 ] |
| Worklog Id | 282700 [ 282700 ] |
| Time Spent | 2 weeks, 1 day, 3 hours [ 327600 ] | 2 weeks, 2 days, 1 hour [ 349200 ] |
| Worklog Id | 282801 [ 282801 ] |
| Time Spent | 2 weeks, 2 days, 1 hour [ 349200 ] | 2 weeks, 2 days, 1 hour, 30 minutes [ 351000 ] |
| Worklog Id | 282842 [ 282842 ] |
| Assignee | Sandya Sharma [ ssharma ] | Indrasan Yadav [ iyadav ] |
| Time Spent | 2 weeks, 2 days, 1 hour, 30 minutes [ 351000 ] | 2 weeks, 2 days, 2 hours, 30 minutes [ 354600 ] |
| Worklog Id | 282947 [ 282947 ] |
| Assignee | Indrasan Yadav [ iyadav ] | Sandya Sharma [ ssharma ] |
| Time Spent | 2 weeks, 2 days, 2 hours, 30 minutes [ 354600 ] | 2 weeks, 2 days, 6 hours, 30 minutes [ 369000 ] |
| Worklog Id | 283023 [ 283023 ] |
| Time Spent | 2 weeks, 2 days, 6 hours, 30 minutes [ 369000 ] | 2 weeks, 2 days, 7 hours, 30 minutes [ 372600 ] |
| Worklog Id | 283111 [ 283111 ] |
| Time Spent | 2 weeks, 2 days, 7 hours, 30 minutes [ 372600 ] | 2 weeks, 3 days, 2 hours, 30 minutes [ 383400 ] |
| Worklog Id | 283132 [ 283132 ] |
| Time Spent | 2 weeks, 3 days, 2 hours, 30 minutes [ 383400 ] | 2 weeks, 3 days, 3 hours [ 385200 ] |
| Worklog Id | 283204 [ 283204 ] |
| Time Spent | 2 weeks, 3 days, 3 hours [ 385200 ] | 2 weeks, 3 days, 4 hours [ 388800 ] |
| Worklog Id | 283211 [ 283211 ] |
| Worklog Id | 283211 [ 283211 ] |
| Time Spent | 2 weeks, 3 days, 4 hours [ 388800 ] | 2 weeks, 4 days, 1 hour [ 406800 ] |
| Worklog Id | 283212 [ 283212 ] |
| Time Spent | 2 weeks, 4 days, 1 hour [ 406800 ] | 2 weeks, 4 days, 6 hours [ 424800 ] |
| Worklog Id | 283245 [ 283245 ] |
| Assignee | Sandya Sharma [ ssharma ] | Indrasan Yadav [ iyadav ] |
| Time Spent | 2 weeks, 4 days, 6 hours [ 424800 ] | 3 weeks, 4 hours [ 446400 ] |
| Worklog Id | 283330 [ 283330 ] |
| Time Spent | 3 weeks, 4 hours [ 446400 ] | 3 weeks, 7 hours [ 457200 ] |
| Worklog Id | 283351 [ 283351 ] |
| Remaining Estimate | 0 minutes [ 0 ] | 3 hours [ 10800 ] |
| Time Spent | 3 weeks, 7 hours [ 457200 ] | 3 weeks, 4 hours [ 446400 ] |
| Worklog Id | 283351 [ 283351 ] | |
| Worklog Time Spent | 3 hours [ 10800 ] |
| Status | In Progress [ 3 ] | Opened [ 1 ] |
| Attachment | Snippet-1_26-12-2025.png [ 124901 ] | |
| Attachment | Snippet-2_26-12-2025.png [ 124902 ] |
| Assignee | Indrasan Yadav [ iyadav ] | Sandya Sharma [ ssharma ] |
| Status | Opened [ 1 ] | In Progress [ 3 ] |
| Assignee | Sandya Sharma [ ssharma ] | Bassem Sabbagh [ bsabbagh ] |
| Assignee | Bassem Sabbagh [ bsabbagh ] | Sandya Sharma [ ssharma ] |
| Remaining Estimate | 3 hours [ 10800 ] | 0 minutes [ 0 ] |
| Time Spent | 3 weeks, 4 hours [ 446400 ] | 3 weeks, 7 hours [ 457200 ] |
| Worklog Id | 287511 [ 287511 ] |
| Time Spent | 3 weeks, 7 hours [ 457200 ] | 3 weeks, 1 day [ 460800 ] |
| Worklog Id | 287517 [ 287517 ] |
| Time Spent | 3 weeks, 1 day [ 460800 ] | 3 weeks, 1 day, 1 hour [ 464400 ] |
| Worklog Id | 287517 [ 287517 ] |
| Worklog Id | 287517 [ 287517 ] |
| Time Spent | 3 weeks, 1 day, 1 hour [ 464400 ] | 3 weeks, 1 day, 1 hour, 30 minutes [ 466200 ] |
| Worklog Id | 287517 [ 287517 ] |
| Assignee | Sandya Sharma [ ssharma ] | Indrasan Yadav [ iyadav ] |
| Time Spent | 3 weeks, 1 day, 1 hour, 30 minutes [ 466200 ] | 3 weeks, 1 day, 2 hours, 30 minutes [ 469800 ] |
| Worklog Id | 287833 [ 287833 ] |
| Time Spent | 3 weeks, 1 day, 2 hours, 30 minutes [ 469800 ] | 3 weeks, 1 day, 3 hours, 30 minutes [ 473400 ] |
| Worklog Id | 287838 [ 287838 ] |
| Time Spent | 3 weeks, 1 day, 3 hours, 30 minutes [ 473400 ] | 3 weeks, 1 day, 7 hours, 30 minutes [ 487800 ] |
| Worklog Id | 287919 [ 287919 ] |
| Attachment | MIMO Snippet_Ist_05-01-2026.jpg [ 125407 ] | |
| Attachment | MIMO Snippet_IInd_05-01-2026.png [ 125408 ] |
| Assignee | Indrasan Yadav [ iyadav ] | Sandya Sharma [ ssharma ] |
| Time Spent | 3 weeks, 1 day, 7 hours, 30 minutes [ 487800 ] | 3 weeks, 2 days, 30 minutes [ 491400 ] |
| Worklog Id | 288089 [ 288089 ] |
| Time Spent | 3 weeks, 2 days, 30 minutes [ 491400 ] | 3 weeks, 2 days, 1 hour, 30 minutes [ 495000 ] |
| Worklog Id | 288091 [ 288091 ] |
| Time Spent | 3 weeks, 2 days, 1 hour, 30 minutes [ 495000 ] | 3 weeks, 2 days, 5 hours, 30 minutes [ 509400 ] |
| Worklog Id | 288111 [ 288111 ] |
| Time Spent | 3 weeks, 2 days, 5 hours, 30 minutes [ 509400 ] | 3 weeks, 3 days, 2 hours, 30 minutes [ 527400 ] |
| Worklog Id | 288312 [ 288312 ] |
| Time Spent | 3 weeks, 3 days, 2 hours, 30 minutes [ 527400 ] | 3 weeks, 3 days, 3 hours, 30 minutes [ 531000 ] |
| Worklog Id | 288319 [ 288319 ] |
| Time Spent | 3 weeks, 3 days, 3 hours, 30 minutes [ 531000 ] | 3 weeks, 3 days, 4 hours, 30 minutes [ 534600 ] |
| Worklog Id | 288323 [ 288323 ] |
| Time Spent | 3 weeks, 3 days, 4 hours, 30 minutes [ 534600 ] | 3 weeks, 3 days, 6 hours, 30 minutes [ 541800 ] |
| Worklog Id | 288336 [ 288336 ] |
| Time Spent | 3 weeks, 3 days, 6 hours, 30 minutes [ 541800 ] | 3 weeks, 3 days, 7 hours, 30 minutes [ 545400 ] |
| Worklog Id | 288355 [ 288355 ] |
| Time Spent | 3 weeks, 3 days, 7 hours, 30 minutes [ 545400 ] | 3 weeks, 4 days, 3 hours, 30 minutes [ 559800 ] |
| Worklog Id | 288505 [ 288505 ] |
| Time Spent | 3 weeks, 4 days, 3 hours, 30 minutes [ 559800 ] | 3 weeks, 4 days, 7 hours, 30 minutes [ 574200 ] |
| Worklog Id | 288809 [ 288809 ] |
| Time Spent | 3 weeks, 4 days, 7 hours, 30 minutes [ 574200 ] | 4 weeks, 3 hours, 30 minutes [ 588600 ] |
| Worklog Id | 288810 [ 288810 ] |
| Time Spent | 4 weeks, 3 hours, 30 minutes [ 588600 ] | 4 weeks, 5 hours, 30 minutes [ 595800 ] |
| Worklog Id | 288818 [ 288818 ] |
| Time Spent | 4 weeks, 5 hours, 30 minutes [ 595800 ] | 4 weeks, 7 hours, 30 minutes [ 603000 ] |
| Worklog Id | 288822 [ 288822 ] |
| Time Spent | 4 weeks, 7 hours, 30 minutes [ 603000 ] | 4 weeks, 1 day, 4 hours, 30 minutes [ 621000 ] |
| Worklog Id | 289100 [ 289100 ] |
| Assignee | Sandya Sharma [ ssharma ] | Indrasan Yadav [ iyadav ] |
| Time Spent | 4 weeks, 1 day, 4 hours, 30 minutes [ 621000 ] | 4 weeks, 1 day, 6 hours [ 626400 ] |
| Worklog Id | 289107 [ 289107 ] |
| Time Spent | 4 weeks, 1 day, 6 hours [ 626400 ] | 4 weeks, 1 day, 7 hours [ 630000 ] |
| Worklog Id | 289110 [ 289110 ] |
| Assignee | Indrasan Yadav [ iyadav ] | Sandya Sharma [ ssharma ] |
| Assignee | Sandya Sharma [ ssharma ] | Basant Kumar [ bkumar ] |
| Assignee | Basant Kumar [ bkumar ] | Indrasan Yadav [ iyadav ] |
| Time Spent | 4 weeks, 1 day, 7 hours [ 630000 ] | 4 weeks, 2 days, 2 hours [ 640800 ] |
| Worklog Id | 289238 [ 289238 ] |
| Comment |
[ A separate JIRA ( Validation for all these changes will be performed under JIRA Therefore, closing JIRA |
| Status | In Progress [ 3 ] | Opened [ 1 ] |
| Status | Opened [ 1 ] | Resolved [ 5 ] |
| Resolution | Fixed [ 1 ] |
| Status | Resolved [ 5 ] | Closed [ 6 ] |
| Resolution | Fixed [ 1 ] | |
| Status | Closed [ 6 ] | Reopened [ 4 ] |
| Time Spent | 4 weeks, 2 days, 2 hours [ 640800 ] | 4 weeks, 3 days, 1 hour, 30 minutes [ 667800 ] |
| Worklog Id | 289532 [ 289532 ] |
| Status | Reopened [ 4 ] | Resolved [ 5 ] |
| Resolution | Fixed [ 1 ] |
| Status | Resolved [ 5 ] | Closed [ 6 ] |