Details
-
Type:
Task
-
Status:
Closed
(View Workflow)
-
Priority:
Normal
-
Resolution: Fixed
-
Customer:Ooreedo Tunisia
Description
Dear All,
As discussed, the connector names need to be parsed exactly as defined in the FRS, and they should remain unique per project for both Nokia_RAN and Huawei_RAN.
I have updated the FRS accordingly, and the finalized connector names are as follows (Which is generally parse under header “importerConnector”):
• Huawei RAN: Huawei_RAN_Ooredoo_TUN
• Nokia RAN: NSN_RAN_Ooredoo_TUN
Currently, it is parsing as below:
Huawei RAN: Huawei_M2000 (Snippet attached)
Nokia RAN: Header is missing
@Bassem Sabbagh, please advise if these names need to be revised and guide us further on this.
Best regards,
Indrasan
Activity
-
- Time Spent:
- 30 minutes
-
Added a updated connector name in FRS and created a JIRA for same and discussed with Sadnay & Jharna for same.
| Field | Original Value | New Value |
|---|---|---|
| Gantt Options | Milestone (set to milestone: having a due date but zero effort) | |
| Planned Start | 2025-10-03 24:00 (milestone: set planned start date to due date) | |
| Planned End | 2025-10-03 24:00 (milestone: set planned end date to due date) |
| Attachment | OT_NSN_RAN_FRS_All Node Type_Physical.docx [ 118611 ] |
| Attachment | OT_Huawei_RAN All Nodes_Physical.docx [ 118612 ] |
| Assignee | Bassem Sabbagh [ bsabbagh ] |
| Description |
Dear All,
As discussed, the connector names need to be parsed exactly as defined in the FRS, and they should remain unique per project for both Nokia_RAN and Huawei_RAN. I have updated the FRS accordingly, and the finalized connector names are as follows (Which is generally parse under header “importerConnector”): • Huawei RAN: Huawei_RAN_Ooredoo_TUN • Nokia RAN: NSN_RAN_Ooredoo_TUN Currently, it is parsing as below: Huawei RAN: Huawei_M2000 (Snippet attached) Nokia RAN: Header is missing @Bassem Sabbagh, please advise if these names need to be revised and guide us further on this. Best regards, Indrasan |
| Attachment | Huawei RAN_Connector Name.png [ 118613 ] |
| Remaining Estimate | 0 minutes [ 0 ] | |
| Time Spent | 30 minutes [ 1800 ] | |
| Worklog Id | 278867 [ 278867 ] |
| Baseline Start | 2025-10-03 24:00 (set baseline based of initial work logging) | |
| Baseline End | 2025-10-03 24:00 (set baseline based of initial work logging) |
-
- Time Spent:
- 5 hours
-
Issue fixed and csv shared
| Assignee | Bassem Sabbagh [ bsabbagh ] | Ashutosh Shendye [ ashendye ] |
Assigned to Ashutosh to define the WL ... WIP
| Attachment | csv-output_huawei-ran.rar [ 118705 ] |
| Attachment | csv-output_nsn-ran.rar [ 118706 ] |
Both Huawei and NSN ran csv-outputs attached with suggested names.
Note: I have only changed the existing importer connector nothing else.
| Assignee | Ashutosh Shendye [ ashendye ] | Indrasan Yadav [ iyadav ] |
| Time Spent | 30 minutes [ 1800 ] | 5 hours, 30 minutes [ 19800 ] |
| Worklog Id | 279012 [ 279012 ] |
-
- Time Spent:
- 1 hour
-
Checked for Importer ID/Importer Connector are still missing in all tables in CSV Output files for Nokia RAN. & discussed with Sandya for the same.
Hi Sandya,
As discussed, the Importer ID and Importer Connector are still missing in almost all tables in the CSV output.
| Assignee | Indrasan Yadav [ iyadav ] | Sandya Sharma [ ssharma ] |
| Time Spent | 5 hours, 30 minutes [ 19800 ] | 6 hours [ 21600 ] |
| Worklog Id | 279400 [ 279400 ] |
XML shared.
| Assignee | Sandya Sharma [ ssharma ] | Indrasan Yadav [ iyadav ] |
| Time Spent | 6 hours [ 21600 ] | 6 hours, 30 minutes [ 23400 ] |
| Worklog Id | 279400 [ 279400 ] |
| Worklog Id | 279400 [ 279400 ] |
Hi Sandya,
Please check the attached excel sheet where I have mentioned the parsing connector name and need to check where it is parsing incorrect.
| Attachment | OT-83.xlsx [ 119602 ] |
| Assignee | Indrasan Yadav [ iyadav ] | Sandya Sharma [ ssharma ] |
| Attachment |
|
| Attachment | OT-83 (Nokia RAN).xlsx [ 119603 ] |
Sandhya to define the WL
WL is half day.
to be delivered in 14-10 the first half
| Status | Opened [ 1 ] | In Progress [ 3 ] |
| Assignee | Sandya Sharma [ ssharma ] | Bassem Sabbagh [ bsabbagh ] |
| Assignee | Bassem Sabbagh [ bsabbagh ] | Sandya Sharma [ ssharma ] |
It is done , but as discussed with indrasan he said that upload the csv after fix all the issue related to jira OT-84.
| Time Spent | 6 hours, 30 minutes [ 23400 ] | 1 day, 4 hours, 30 minutes [ 45000 ] |
| Worklog Id | 280407 [ 280407 ] |
ticket to be assigned to Indrasan and CSVs to be shared with integration and to be loaded in SD
-
- Time Spent:
- 1 hour
-
I have uploaded the CSV output provided by Sandya and generated the csv2db. After verification, the data is reflecting properly in SD.
csv-output shared with integration and uploaded in staging db.
| Assignee | Sandya Sharma [ ssharma ] | Indrasan Yadav [ iyadav ] |
importor connector name is not mendatory for each csv , it is discussed with driss sir, and for addinfo or error alarm we are using the common code for each connector, there is error coming for others connector while i change the code for addinfo , we can fix it by change in each connnector seperatly.
| Time Spent | 1 day, 4 hours, 30 minutes [ 45000 ] | 1 day, 5 hours, 30 minutes [ 48600 ] |
| Worklog Id | 280657 [ 280657 ] |
-
- Time Spent:
- 1 hour
-
Checked the data on staging-DB related to Iporter Connector as CSV Output was shared by Sandhya. and feedback shared over an email.
| Attachment | OT-83 (Nokia RAN).xlsx [ 120312 ] |
Dear @Sandya Sharma,
Please find the validation remarks: (Green-Fixed, Blue-Ignore, without any colour-To be check)
I consider the latest one Importer Id=’20251016091426_2025-10-16-09.14.26’
Updated list (OT-83 (Nokia RAN) is attached for your reference.
| Assignee | Indrasan Yadav [ iyadav ] | Sandya Sharma [ ssharma ] |
| Attachment |
|
| Time Spent | 1 day, 5 hours, 30 minutes [ 48600 ] | 1 day, 6 hours, 30 minutes [ 52200 ] |
| Worklog Id | 281150 [ 281150 ] |
to be fixed by 29-10
csv output shared with integration
| Assignee | Sandya Sharma [ ssharma ] | Indrasan Yadav [ iyadav ] |
-
- Time Spent:
- 3 hours
-
working on importer connector
Hi Sandya, could you please confirm if Integration has uploaded it? I am unable to find any email regarding this.
| Assignee | Indrasan Yadav [ iyadav ] | Sandya Sharma [ ssharma ] |
As confirmed this is included in the CSV output which is shared for OT-84.
Bassem Sabbagh in meantime please assign this to Jharna Thakur to fix for Huawei RAN.
| Assignee | Sandya Sharma [ ssharma ] | Jharna Thakur [ jthakur ] |
Jharna to define the WL ... started on 4-11
-
- Time Spent:
- 3 hours
-
Validated the tables regarding this issue in staging DB for Nokia RAN and shared feedback over an email.
Again updated the sheet as suggested by @Bassem and shared over an email.
Discussed with @Jharna regarding same issue in Huawei RAN to fix this & checked in local CSV Output still issue persist in some tables.
| Time Spent | 1 day, 6 hours, 30 minutes [ 52200 ] | 2 days, 30 minutes [ 59400 ] |
| Worklog Id | 282608 [ 282608 ] |
WIP and to be delivered by 5-11
| Worklog Id | 282608 [ 282608 ] |
| Time Spent | 2 days, 30 minutes [ 59400 ] | 2 days, 1 hour [ 61200 ] |
| Worklog Id | 282608 [ 282608 ] |
| Worklog Id | 282608 [ 282608 ] |
| Worklog Id | 282608 [ 282608 ] |
| Time Spent | 2 days, 1 hour [ 61200 ] | 2 days, 1 hour, 30 minutes [ 63000 ] |
| Worklog Id | 282608 [ 282608 ] |
-
- Time Spent:
- 2 hours, 30 minutes
-
Checked importer connector details in each tables for Huawei RAN, and shared feedback to Jharna over an email.
| Time Spent | 2 days, 1 hour, 30 minutes [ 63000 ] | 2 days, 4 hours, 30 minutes [ 73800 ] |
| Worklog Id | 282707 [ 282707 ] |
| Time Spent | 2 days, 4 hours, 30 minutes [ 73800 ] | 2 days, 7 hours, 30 minutes [ 84600 ] |
| Worklog Id | 282708 [ 282708 ] |
Done with this, will share the CSV output with the resolution for OT-85.
| Time Spent | 2 days, 7 hours, 30 minutes [ 84600 ] | 3 days, 2 hours [ 93600 ] |
| Worklog Id | 282835 [ 282835 ] |
CSVs are shared with integration
| Assignee | Jharna Thakur [ jthakur ] | Indrasan Yadav [ iyadav ] |
-
- Time Spent:
- 1 hour
-
Validated the each tables for Importer Connector and shared feedback to Sandya over an email.
| Time Spent | 3 days, 2 hours [ 93600 ] | 3 days, 3 hours [ 97200 ] |
| Worklog Id | 283024 [ 283024 ] |
Hi @Sandya Sharma,
Please find latest validation feedback for Importer Connector for Nokia RAN:
Consider Importer ID: 20251107090325_2025-11-07-09.03.25
Still Importer Connector is not correct for below tables:
CSV-Output Table Name
NodeInterface
RadioAntenna
SubInterface
ElementCell5g
ElementCellRadioBandWidth
ElementTrx
LogicalInterface
| Assignee | Indrasan Yadav [ iyadav ] | Sandya Sharma [ ssharma ] |
-
- Time Spent:
- 2 hours
-
Validated the Importer Connector for Huawei RAN & shared feedback in JIRA
OT-85.
Please check the updated data and confirm.
| Assignee | Sandya Sharma [ ssharma ] | Indrasan Yadav [ iyadav ] |
| Time Spent | 3 days, 3 hours [ 97200 ] | 3 days, 5 hours [ 104400 ] |
| Worklog Id | 283161 [ 283161 ] |
-
- Time Spent:
- 1 hour, 30 minutes
-
Checked for Importer Connector issue for Nokia RAN & reverted to Sandya (Validation is based on latest Importer ID-Shared by Basant)
| Assignee | Indrasan Yadav [ iyadav ] | Sandya Sharma [ ssharma ] |
Hi @Sandya Sharma,
Please find below validation feedback for latest importer id: 20251111023300_2025-11-11-02.33.00
Still Importer Connector is not correct for below tables:
CSV-Output Table Name
NodeInterface
SubInterface
ElementCell5g
ElementTrx
WIP and to be fixed by 13-11
| Time Spent | 3 days, 5 hours [ 104400 ] | 3 days, 6 hours, 30 minutes [ 109800 ] |
| Worklog Id | 283244 [ 283244 ] |
-
- Time Spent:
- 1 hour
-
I have uploaded the CSV output after applying the patch and verified the record counts. The CSV counts before upload and the SD counts after upload are matching correctly for all tables
CSV output shared with integration.
| Assignee | Sandya Sharma [ ssharma ] | Indrasan Yadav [ iyadav ] |
-
- Time Spent:
- 1 hour
-
shared huweai ran logs from 102 to sandya
| Time Spent | 3 days, 6 hours, 30 minutes [ 109800 ] | 3 days, 7 hours, 30 minutes [ 113400 ] |
| Worklog Id | 283711 [ 283711 ] |
| Time Spent | 3 days, 7 hours, 30 minutes [ 113400 ] | 4 days, 30 minutes [ 117000 ] |
| Worklog Id | 283732 [ 283732 ] |
| Status | In Progress [ 3 ] | Opened [ 1 ] |
| Comment | [ For Nokia RAN, connector name is available in all require tables. ] |
-
- Time Spent:
- 30 minutes
-
Validated the data in staging-DB for connector name.
1- Nokia RAN:
Connector name is parsing OK in all possible tables except below which can be ignored:
(II) Site
(III) Error alarm
2- Huawei RAN:
Connector name is parsing OK in all possible tables except below:
(II) Site
(III) Error alarm
(IV) Sub interface: Missing somewhere in table (To be check by Jharna Thakur
| Time Spent | 4 days, 30 minutes [ 117000 ] | 4 days, 1 hour [ 118800 ] |
| Worklog Id | 287516 [ 287516 ] |
Hi Jharna Thakur please commit the code for connector name missing issue in Huawei RAN for table "Sub interface" as it is fixed now withing OT-45 CSV output.
| Time Spent | 4 days, 1 hour [ 118800 ] | 4 days, 2 hours [ 122400 ] |
| Worklog Id | 287834 [ 287834 ] |
| Status | Opened [ 1 ] | In Progress [ 3 ] |
-
- Time Spent:
- 2 hours
-
Check & found issue related to importer connector in Huawei RAN which was fixed for all tables almost and raised to Jharna.
Hi Jharna,
The issue was initially identified in the Sub Interface table, where the importer connector was missing. You had fixed this earlier. However, while validating the latest data on the server using the importer ID 20251231015405_2025-12-31-01.54.05 (shared by Basant on 31-12-2025), I noticed that the importer connector issue is now appearing in additional tables as well either it is missing or incorrect 'Huawei_M2000'.
The following tables are affected, even though they were previously fixed (except for Sub Interface):
1- BATCH_ELEMENT_CELL_RADIO_BAND_WIDTH
2- BATCH_ELEMENT_GSM_CELL_MAIO
3- BATCH_ELEMENT_TRX
4- BATCH_ELEMENT_TRX_ARFCN
5- BATCH_IP_DATA
6- BATCH_LOGICAL_INTERFACE
7- BATCH_NETWORK_ELEMENT_DUMP
8- BATCH_NODE_INTERFACE
9- BATCH_RADIO_ANTENNA
10- BATCH_SUB_INTERFACE
11- BATCH_VIRTUAL_INTERFACE
Kindly review and fix the importer connector issue for the above tables as well.
| Assignee | Indrasan Yadav [ iyadav ] | Jharna Thakur [ jthakur ] |
| Time Spent | 4 days, 2 hours [ 122400 ] | 4 days, 4 hours [ 129600 ] |
| Worklog Id | 287918 [ 287918 ] |
XML and CSVs are generated with no issues on local laptop of Jharna ... it could be integration issue ... L2 to generate again the XML and share it for validation ...
-
- Time Spent:
- 1 hour, 30 minutes
-
Now, issue has been fixed for both connector Nokia RAN (Already fixed earlier) & Huawei RAN (Now fixed):
Connector name is parsing OK in all possible tables except below which can be ignored:
(II) Site
(III) Error alarm2- Huawei RAN:
Connector name is parsing OK in all possible tables except below:
(II) Site
(III) Error alarm
I have checked the staging database and the 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.
| Assignee | Jharna Thakur [ jthakur ] | Indrasan Yadav [ iyadav ] |
| Status | In Progress [ 3 ] | Opened [ 1 ] |
| Status | Opened [ 1 ] | Resolved [ 5 ] |
| Resolution | Fixed [ 1 ] |
| Comment | [ Now, the issues related to parse the connector name is fixed for both connector Huawei RAN & Nokia RAN. ] |
Now, issue has been fixed for both connector Nokia RAN (Already fixed earlier) & Huawei RAN (Now fixed):
Connector name is parsing OK in all possible tables except below which can be ignored:
(II) Site
(III) Error alarm
2- Huawei RAN:
Connector name is parsing OK in all possible tables except below:
(II) Site
(III) Error alarm
| Status | Resolved [ 5 ] | Closed [ 6 ] |
| Resolution | Fixed [ 1 ] | |
| Status | Closed [ 6 ] | Reopened [ 4 ] |
| Status | Reopened [ 4 ] | Resolved [ 5 ] |
| Resolution | Fixed [ 1 ] |
| Time Spent | 4 days, 4 hours [ 129600 ] | 4 days, 5 hours, 30 minutes [ 135000 ] |
| Worklog Id | 288342 [ 288342 ] |
| Status | Resolved [ 5 ] | Closed [ 6 ] |
| Transition | Time In Source Status | Execution Times | Last Executer | Last Execution Date | |||||
|---|---|---|---|---|---|---|---|---|---|
|
37d 1h 4m | 2 | Indrasan Yadav | 31/Dec/25 10:39 AM | |||||
|
62d 23h 2m | 2 | Indrasan Yadav | 07/Jan/26 10:19 AM | |||||
|
17s | 1 | Indrasan Yadav | 07/Jan/26 10:19 AM | |||||
|
28m 55s | 1 | Indrasan Yadav | 07/Jan/26 10:50 AM | |||||
|
15s | 1 | Indrasan Yadav | 07/Jan/26 10:50 AM | |||||
|
35m 12s | 2 | Indrasan Yadav | 07/Jan/26 11:23 AM |
|
Links Hierarchy |
 Documentation
|
Dear Bassem Sabbagh,
I have created a common JIRA for this issue. Kindly assign an AI DEV resource to investigate and resolve it.