L3 Support
  1. L3 Support
  2. LS-706

ORA error related to null ENODBID during NON IP xml import - staging

        Details

        • Type: Bug Bug
        • Status: Closed Closed (View Workflow)
        • Priority: Normal 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

            Ascending order - Click to sort in descending order
            Permalink
            Marwan Kanaan logged work - 09/Oct/25 12:00 AM
            • Time Spent:
              4 hours
               

              reproduce the issue locally and added for handling for avoiding saving lte without enodebid

            Abir Messaikeh made changes -
            Field Original Value New Value
            Gantt Options Milestone (set to milestone: having a due date but zero effort)
            Planned Start 2025-10-17 24:00 (milestone: set planned start date to due date)
            Planned End 2025-10-17 24:00 (milestone: set planned end date to due date)
            Marwan Kanaan made changes -
            Assignee Khaled Khalil [ kkhalil ] Marwan Kanaan [ mkanaan ]
            Hide
            Permalink
            Abir Messaikeh added a comment -

            https://mobinets-my.sharepoint.com/:u:/p/mohan_rathor/EfWcD8Qfcn5Lt_eoU6X9SKQBxINrdYAr0iN1-vWRha49Qg?e=xVfd3P

            Show
            Abir Messaikeh added a comment - https://mobinets-my.sharepoint.com/:u:/p/mohan_rathor/EfWcD8Qfcn5Lt_eoU6X9SKQBxINrdYAr0iN1-vWRha49Qg?e=xVfd3P
            Marwan Kanaan made changes -
            Status Open Bug [ 10108 ] Dev Scheduled [ 10014 ]
            Marwan Kanaan made changes -
            Status Dev Scheduled [ 10014 ] Implementation in progress [ 10016 ]
            Marwan Kanaan made changes -
            Status Implementation in progress [ 10016 ] To Be Released [ 10400 ]
            Hide
            Permalink
            Marwan Kanaan added a comment -

            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

            Show
            Marwan Kanaan added a comment - 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
            Marwan Kanaan made changes -
            Remaining Estimate 0 minutes [ 0 ]
            Time Spent 4 hours [ 14400 ]
            Worklog Id 279856 [ 279856 ]
            Marwan Kanaan made changes -
            Baseline Start 2025-10-17 24:00 (set baseline based of initial work logging)
            Baseline End 2025-10-17 24:00 (set baseline based of initial work logging)
            Permalink
            Marwan Kanaan logged work - 10/Oct/25 12:00 AM
            • Time Spent:
              4 hours
               

              Continuing to investigate the LTE issue, as the problem remains unpredictable and does not follow any logical or consistent scenario so far. Further analysis is ongoing to identify the root cause and determine a stable reproduction pattern.

            Khaled Khalil made changes -
            Status To Be Released [ 10400 ] Ready for QA [ 10023 ]
            Assignee Marwan Kanaan [ mkanaan ] Abir Messaikeh [ amessaikeh ]
            Permalink
            Marwan Kanaan logged work - 13/Oct/25 12:00 AM
            • Time Spent:
              7 hours
               

              Continuing to investigate the LTE issue, as the problem remains unpredictable and does not follow any logical or consistent scenario so far. Further analysis is ongoing to identify the root cause and determine a stable reproduction pattern.

            Permalink
            Malek Ibrahim logged work - 13/Oct/25 12:00 AM
            • Time Spent:
              30 minutes
               

              followup

            Permalink
            Malek Ibrahim logged work - 13/Oct/25 12:00 AM
            • Time Spent:
              30 minutes
               

              followup

            Abir Messaikeh made changes -
            Status Ready for QA [ 10023 ] QA In Progress [ 10015 ]
            Abir Messaikeh made changes -
            Status QA In Progress [ 10015 ] Reopened [ 4 ]
            Assignee Marwan Kanaan [ mkanaan ] Khaled Khalil [ kkhalil ]
            Resolution Not Fixed [ 10200 ]
            Hide
            Permalink
            Abir Messaikeh added a comment -

            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")

            logs below
            https://mobinets-my.sharepoint.com/:u:/p/mohan_rathor/EXw4WDE3WUhGpem1hZZN39wBE2EQlW1ZlmGWkSBlLDJNXw?e=my5deK

            Show
            Abir Messaikeh added a comment - 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") logs below https://mobinets-my.sharepoint.com/:u:/p/mohan_rathor/EXw4WDE3WUhGpem1hZZN39wBE2EQlW1ZlmGWkSBlLDJNXw?e=my5deK
            Abir Messaikeh made changes -
            Assignee Khaled Khalil [ kkhalil ] Marwan Kanaan [ mkanaan ]
            Hassan Abdine made changes -
            Status Reopened [ 4 ] Dev Scheduled [ 10014 ]
            Permalink
            Marwan Kanaan logged work - 14/Oct/25 12:00 AM
            • Time Spent:
              7 hours
               

              The root cause was that the LTE ENodeB reference was being incorrectly set or overridden from the XML with invalid data, leading to a fatal error during database saving. The logic was reviewed and corrected to ensure that the LTE ENodeB is properly validated and not overridden by incomplete XML data, aligning the ENodeB reference with the real network object to prevent future inconsistencies.

            Marwan Kanaan made changes -
            Time Spent 4 hours [ 14400 ] 1 day [ 28800 ]
            Worklog Id 280305 [ 280305 ]
            Marwan Kanaan made changes -
            Time Spent 1 day [ 28800 ] 1 day, 7 hours [ 54000 ]
            Worklog Id 280307 [ 280307 ]
            Malek Ibrahim made changes -
            Time Spent 1 day, 7 hours [ 54000 ] 1 day, 7 hours, 30 minutes [ 55800 ]
            Worklog Id 280348 [ 280348 ]
            Malek Ibrahim made changes -
            Time Spent 1 day, 7 hours, 30 minutes [ 55800 ] 2 days [ 57600 ]
            Worklog Id 280349 [ 280349 ]
            Marwan Kanaan made changes -
            Status Dev Scheduled [ 10014 ] Implementation in progress [ 10016 ]
            Marwan Kanaan made changes -
            Status Implementation in progress [ 10016 ] To Be Released [ 10400 ]
            Marwan Kanaan made changes -
            Time Spent 2 days [ 57600 ] 2 days, 7 hours [ 82800 ]
            Worklog Id 280401 [ 280401 ]
            Abir Messaikeh made changes -
            Summary ORA error related to null ENODBID during NON IP xml import ORA error related to null ENODBID during NON IP xml import - staging
            Hide
            Permalink
            Abir Messaikeh added a comment -

            new fix in NEP_OMANTEL - Build 3.7.0.1364

            Show
            Abir Messaikeh added a comment - new fix in NEP_OMANTEL - Build 3.7.0.1364
            Abir Messaikeh made changes -
            Status To Be Released [ 10400 ] Ready for QA [ 10023 ]
            Assignee Marwan Kanaan [ mkanaan ] Abir Messaikeh [ amessaikeh ]
            Abir Messaikeh made changes -
            Status Ready for QA [ 10023 ] QA In Progress [ 10015 ]
            Abir Messaikeh made changes -
            Status QA In Progress [ 10015 ] Closed [ 6 ]
            Resolution Not Fixed [ 10200 ] Fixed [ 1 ]
            Transition Time In Source Status Execution Times Last Executer Last Execution Date
            Open Bug Open Bug Dev Scheduled Dev Scheduled
            		12m 1 Marwan Kanaan 09/Oct/25 10:50 AM
            QA In Progress QA In Progress Reopened Reopened
            		15s 1 Abir Messaikeh 13/Oct/25 7:29 AM
            Reopened Reopened Dev Scheduled Dev Scheduled
            		8h 31m 1 Hassan Abdine 13/Oct/25 4:00 PM
            Dev Scheduled Dev Scheduled Implementation in progress Implementation in progress
            		1d 12h 37m 2 Marwan Kanaan 15/Oct/25 4:38 AM
            Implementation in progress Implementation in progress To Be Released To Be Released
            		12m 2 Marwan Kanaan 15/Oct/25 4:38 AM
            To Be Released To Be Released Ready for QA Ready for QA
            		1d 8h 20m 2 Abir Messaikeh 15/Oct/25 4:00 PM
            Ready for QA Ready for QA QA In Progress QA In Progress
            		93d 17h 5m 2 Abir Messaikeh 14/Jan/26 8:38 AM
            QA In Progress QA In Progress Closed Closed
            		6s 1 Abir Messaikeh 14/Jan/26 8:38 AM
            Subversion JIRA

            Links Hierarchy

            		  Documentation

            Invalid license: EXPIRED

            Cancel

              People

              • Assignee:
                Abir Messaikeh
                Reporter:
                Abir Messaikeh
              • Votes:
                0 Vote for this issue
                Watchers:
                2 Start watching this issue

                Dates

                • Due:
                  Created:
                  Updated:
                  Resolved:
                  Planned Start:
                  Planned End:
                  Actual Start:
                  Date of Baselining:

                  Time Tracking

                  Estimated:
                  Original Estimate - Not Specified
                  Not Specified
                  Remaining:
                  Remaining Estimate - 0 minutes
                  0m
                  Logged:
                  Time Spent - 2 days, 7 hours
                  2d 7h

                    Drag and Drop