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
| 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) |
| Assignee | Khaled Khalil [ kkhalil ] | Marwan Kanaan [ mkanaan ] |
| Status | Open Bug [ 10108 ] | Dev Scheduled [ 10014 ] |
| Status | Dev Scheduled [ 10014 ] | Implementation in progress [ 10016 ] |
| Status | Implementation in progress [ 10016 ] | To Be Released [ 10400 ] |
| Remaining Estimate | 0 minutes [ 0 ] | |
| Time Spent | 4 hours [ 14400 ] | |
| Worklog Id | 279856 [ 279856 ] |
| 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) |
| Status | To Be Released [ 10400 ] | Ready for QA [ 10023 ] |
| Assignee | Marwan Kanaan [ mkanaan ] | Abir Messaikeh [ amessaikeh ] |
| Status | Ready for QA [ 10023 ] | QA In Progress [ 10015 ] |
| Status | QA In Progress [ 10015 ] | Reopened [ 4 ] |
| Assignee | Marwan Kanaan [ mkanaan ] | Khaled Khalil [ kkhalil ] |
| Resolution | Not Fixed [ 10200 ] |
| Assignee | Khaled Khalil [ kkhalil ] | Marwan Kanaan [ mkanaan ] |
| Status | Reopened [ 4 ] | Dev Scheduled [ 10014 ] |
| Time Spent | 4 hours [ 14400 ] | 1 day [ 28800 ] |
| Worklog Id | 280305 [ 280305 ] |
| Time Spent | 1 day [ 28800 ] | 1 day, 7 hours [ 54000 ] |
| Worklog Id | 280307 [ 280307 ] |
| Time Spent | 1 day, 7 hours [ 54000 ] | 1 day, 7 hours, 30 minutes [ 55800 ] |
| Worklog Id | 280348 [ 280348 ] |
| Time Spent | 1 day, 7 hours, 30 minutes [ 55800 ] | 2 days [ 57600 ] |
| Worklog Id | 280349 [ 280349 ] |
| Status | Dev Scheduled [ 10014 ] | Implementation in progress [ 10016 ] |
| Status | Implementation in progress [ 10016 ] | To Be Released [ 10400 ] |
| Time Spent | 2 days [ 57600 ] | 2 days, 7 hours [ 82800 ] |
| Worklog Id | 280401 [ 280401 ] |
| Summary | ORA error related to null ENODBID during NON IP xml import | ORA error related to null ENODBID during NON IP xml import - staging |
| Status | To Be Released [ 10400 ] | Ready for QA [ 10023 ] |
| Assignee | Marwan Kanaan [ mkanaan ] | Abir Messaikeh [ amessaikeh ] |
| Status | Ready for QA [ 10023 ] | QA In Progress [ 10015 ] |
| Status | QA In Progress [ 10015 ] | Closed [ 6 ] |
| Resolution | Not Fixed [ 10200 ] | Fixed [ 1 ] |
