Details
-
Type:
Bug
-
Status:
Closed
(View Workflow)
-
Priority:
Normal
-
Resolution: Fixed
-
Component/s: NEP
-
Labels:None Labels
-
Customer:OMAN-Tel
-
Product:NEP
Description
Yesterday, we encountered an error during the NON IP XML import on the .180 server.
Please review the error message below and suggest a solution so we can resolve this issue.
XML name - 2025-10-07-08.16.30_NONIP_OmanTel.xml
Import Start time - 2025-10-07 21:39:08
Please find the logs during the import.
logs_180_07Oct.rar
2025-10-07 23:57:31,549 INFO [stdout] (AsyncAppender-Dispatcher-Thread-119) Caused by: Error : 1400, Position : 147, Sql = insert into NEP_181.LTECELL (CELLDUPLEXINGMO
DE, DOWNLINKEARFCN, EnodebID, MIMOCONFIGURATION, PCID, TacID, UPLINKEARFCN, CELLID) values (:1 , :2 , :3 , :4 , :5 , :6 , :7 , :8 ), OriginalSql = insert into NEP_181.L
TECELL (CELLDUPLEXINGMODE, DOWNLINKEARFCN, EnodebID, MIMOCONFIGURATION, PCID, TacID, UPLINKEARFCN, CELLID) values (?, ?, ?, ?, ?, ?, ?, ?), Error Msg = ORA-01400: canno
t insert NULL into ("NEP_181"."LTECELL"."ENODEBID")
Caused by: java.sql.SQLIntegrityConstraintViolationException: ORA-01400: cannot insert NULL into ("NEP_181"."LTECELL"."ENODEBID")
Activity
- All
- Comments
- Work Log
- History
- Activity
- Links Hierarchy
- Transitions
- Trace
Dear @Mohan Singh Rathor,
Kindly note that the issue has been addressed and was reproducible on my local environment with the same fatal error.
Furthermore, the issue has been fixed, and a patch is required.
Patch Number: 3.7.0.1360
Dear @Marwan Kanaan,
The issue persists with the non-IP XML import even after the deployment of the latest patch." "The XML import has been stuck in the 'saving to instance' phase for over 20 hours.
We used the same xml as we used last import. Please find the logs during the import.
server.log.2025-10-11.gz
Caused by: Error : 1400, Position : 147, Sql = insert into NEP_181.LTECELL (CELLDUPLEXINGMODE, DOWNLINKEARFCN, EnodebID, MIMOCONFIGURATION, PCID, TacID, UPLINKEARFCN, C
ELLID) values (:1 , :2 , :3 , :4 , :5 , :6 , :7 , :8 ), OriginalSql = insert into NEP_181.LTECELL (CELLDUPLEXINGMODE, DOWNLINKEARFCN, EnodebID, MIMOCONFIGURATION, PCID,
TacID, UPLINKEARFCN, CELLID) values (?, ?, ?, ?, ?, ?, ?, ?), Error Msg = ORA-01400: cannot insert NULL into ("NEP_181"."LTECELL"."ENODEBID")
2025-10-11 19:42:39,073 INFO [stdout] (AsyncAppender-Dispatcher-Thread-125) 19:42:39-[FATAL][SaveRunner] Error while calling saving instances to Database: [User: importer][Action: com.mobinets.nep.npt.service.AutoImportService.importNetwork(String, String, NEPBundles, ImporterParams) 037a00d4-6130-4f6d-a7ec-e9e3e0b43130]
Caused by: java.sql.SQLIntegrityConstraintViolationException: ORA-01400: cannot insert NULL into ("NEP_181"."LTECELL"."ENODEBID")
new fix in NEP_OMANTEL - Build 3.7.0.1364
https://mobinets-my.sharepoint.com/:u:/p/mohan_rathor/EfWcD8Qfcn5Lt_eoU6X9SKQBxINrdYAr0iN1-vWRha49Qg?e=xVfd3P