Integration has to generate anew xml and validate the data in SD ... no work from AI dev so far

there is one property missing in the conf file and shared by Jharna ... integration to add the missing property and regenerate the XML and upload the CSVs

Dear @Jharna Thakur,

Please the count validation comments on the staging DB related to the initial issues.

Importer ID: 20251027105108_2025-10-27-10.51.08

Note: Detailed validation feedback for each table will be shared once the review is completed.

1. Counts Verified (OK):

The data count is correct for the following tables:

Except highlighted one remains are fixed.

Cabinet, Shelf, Slot, BSC, eNodeB, SRAN (NOK-No data updated), RNC (NOK-No data updated), Site, Role2G, Role3G.

2. Counts Not OK (Incomplete Data Uploaded):

The data count is incomplete for the following tables:

Except highlighted one remains are fixed.

Boards (NOK-count seems higher), Error Alarms (NOK-No data updated), Network Elements Dump, AddInfos.

3. No Data Uploaded:

Except highlighted one remains are fixed.

The following tables currently have no data uploaded:
eNodeB Bandwidths, GSM Cell MAIO, IP Data (NOK-No data updated), Loopback Interface (NOK-No data updated), 4G Cell, Net Status (NOK-No data updated), 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 (OK).

5. Importer Connector: (As discussed @Jharna Thakur, It will be taking care by @Sandya Sharma)

Thank you
Indrasan

I have verified and found no differences between my locally generated CSVs and the ones shared from the server. thus, I've mailed to integration to upload the CSVs in Db

Hi @Jharna Thakur,

Please find below the data validation summary on the Staging DB, based on the latest CSV upload shared by @Basant Kumar.

1. Counts OK in the below tables:
(I) BSC
(II) RNC
(III) BTS
(IV) NodeB
(V) eNodeB
(VI) SRAN
(VII) Role2G
(VIII) Role3G
(IX) Role4G
(X) Cabinet
(XI) Shelf
(XII) Radio Antenna
(XIII) 2G Cell
(XIV) 3G Cell
(XV) 4G Cell
(XVI) IP

2. Counts Not OK in the below tables:

(I) Board – 18,170 boards are getting parsed extra, while their parent Node / Cabinet / Shelf are not parsed
(II) Sites – Showing 6388, whereas expected as per static sheet is 6527

3. No data updated in below table:

(I) Loopback Interface

4. Tables where some header fields have blank values which should be parsed:

Table Name Missing / Blank Fields
Role3G: Operator / Parent RNC
Role2G: BTS / Operator (Header missing)
IP Data: Node ID / Dumps Path (blank at some places)
Radio Antenna: Supplier
4G Cell: MCC / MNC / Supplier
ENodeB: MCC / MNC / Operator
RNC: MCC / MNC / Operator
BSC: MCC / MNC / Operator
Node Cabinet: Node Type
Node Shelf: Cabinet Index / Node ID
Node Board: Dumps missing somewhere / Node ID
Node Slot: Dumps Path missing in few entries / Node ID / Node Type

Thank you
Indrasan

WL- 1.5 Days

WIP and to be delivered by 10-11 the first half

CSVS to be shared with integration to load them in SD by today

CSVs are shared with integration

Hi @Jharna Thakur,

Please find below validation remarks for latest CSV uploaded by @Basant Kumar against previous raised issue,

Consider Importer ID: 20251110014851_2025-11-10-01.48.51

Table Name Missing / Blank Fields
Role3G: Operator 12-11: Still same / Parent RNC
Role2G: BTS 12-11: Fixed / Operator (Header missing) 12-11: Still same

Note: As we discussed this will be fix once you will fix the issue for OT-110

Regarding Importer Connector where still issue persist and it should be fix once the issue related to OT-110 will be fix:

CSV-Output Table Name
ElementCellRadioBandWidth
ElementTrx
GSMCell MAIO
NetworkElementDump

Regards,
Indrasan

Dear Indrasan Yadav, As discussed, the columns operator and importerConnector are not available in the DB because they are not defined in the model class on the server side. Although these columns appear in the CSV output, the issue should be resolved once the updated code is deployed on the server.

Patch should be released and deployed ... Indrasan to validate

Dear @Basant Kumar,

Please generate Huawei RAN XML on .102 and upload the CSV output for same on S-DB.

Regards,
Indrasan

1- All data are available in staging DB correct except the table count "Node interface" where count seem very high (Count is same in CSV output & S-DB, it means issue is in generation) which to be check by Jharna Thakur.

2- Importer connector is missing some where in table "sub interface"
3- Importer connector is available in table "Radio antenna" but in query it is not finding due to spelling wrong of "ImporterConnector" it is "importorconnector" in radio antenna. (Last O should be replaced with E in word importer)

All the above points have been fixed in the CSV output received on 26-12-2025 for the micro site issue (JIRA: OT-45).

Once the file is uploaded to S-DB, I will verify the changes.
The upload to S-DB is currently pending due to the latest AI patch release, which is awaiting confirmation from Dr. Khaled. Once the patch is released, I will request the integration team to deploy it on .102, after which I will ask Jharna to share the same CSV output with the integration team for uploading to S-DB.

Latest AI patch has been deployed on .120 & requested to Basant to generate XML & CSV on server and share to me for validation and I validated for same, now issue has been fixed for point 3 but not fixed for point 1 & 2 due to code not committed for same. (Locally it is fixed we will commit the code & to be check on server for same)

Jharna Thakur, please commit the code for point 1 & 2.

code committed

Hi Jharna,

Earlier, the issue was only with the Node Interface table, where the count was mismatched. That issue is now resolved, and the count for the Node Interface table looks correct.

However, the following issues have now appeared, which were previously fixed:
Importer ID: "20251231015405_2025-12-31-01.54.05"

Below are the current issues identified during validation:

1- Boards count mismatch – Currently showing 129,061, whereas it should be 110,351.
2- Importer connector issue – I have reverted the related changes in OT-83.
3- Dump path missing in some records under the IP Data / Board table.
4- Node ID is missing in the Cabinet / Shelf / Board tables.
5- Start RU “-1” is appearing again in the Shelf table, which was already fixed in the previous cycle.
6- Supplier information is missing in Radio Antenna / 4G Cell tables.
7- MCC–MNC is parsing incorrectly (showing value 0) in 4G Cell / eNodeB / RNC / BSC tables.
8-Technology is not parsing for all nodes in SRAN, which was fixed last week but has reappeared.
9- Operator field is missing in eNodeB / Role3G / Role2G / RNC / BSC tables.
10- Also to be check the header "elementNodeId" in table "radioantenna" which is available in CSV output but missing in XML.

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 ...

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.

All highlighted issues have now been fixed as I validated the data on staging-DB, except point no. 10, which will be addressed under OT-45 as confirmed by Jharna.

The missing header elementNodeId is now available in the radio antenna table.

Jharna Thakur, please proceed with committing the code for the same.

code committed

Latest patch deployed on server, to be check data on staging-DB.

Now, all issue has been fixed.