Details

    • Customer:
      Ooreedo Tunisia

      Description

      I initiated a sample XML (2025-06-04-11.48.54_Ooredoo_Tunisia) import on server .102 on dated 04-06-2025, but the connection was unexpectedly refused before the import could complete.

      Following this, I requested a platform restart to Natnael Asfaw. After the restart, I attempted the XML import again, but the same issue is occurring.

      Server log & XML is attached here for reference.

      1. OT-17_Updated.rar
        25 kB
        Indrasan Yadav
      2. server.log
        7.24 MB
        Indrasan Yadav
      1. Error Snippet.jpg
        52 kB

        Activity

        Indrasan Yadav logged work - 04/Jun/25 12:00 AM - edited
        • Time Spent:
          2 hours
           

          Imported sample XML on test platform .102 but it was getting failed tried to take support from @Natnael and finally raised to NEP-DEV team.

        Indrasan Yadav made changes -
        Field Original Value New Value
        Gantt Options Milestone (set to milestone: having a due date but zero effort)
        Planned Start 2025-06-10 24:00 (milestone: set planned start date to due date)
        Planned End 2025-06-10 24:00 (milestone: set planned end date to due date)
        Indrasan Yadav made changes -
        Attachment Error Snippet.jpg [ 110600 ]
        Attachment server.log [ 110601 ]
        Indrasan Yadav made changes -
        Attachment OT-17_Updated.rar [ 110602 ]
        Hide
        Indrasan Yadav added a comment -

        Dear @Natnael Asfaw,

        As discussed over Teams, I initiated an XML import on server .102, but the connection was unexpectedly refused before the import could complete.

        Following this, I requested a platform restart. After the restart, I attempted the XML import again, but the same issue is occurring.

        Please advise on the next steps or if any further investigation is required from my end.

        Thank you
        Indrasan

        Show
        Indrasan Yadav added a comment - Dear @Natnael Asfaw, As discussed over Teams, I initiated an XML import on server .102, but the connection was unexpectedly refused before the import could complete. Following this, I requested a platform restart. After the restart, I attempted the XML import again, but the same issue is occurring. Please advise on the next steps or if any further investigation is required from my end. Thank you Indrasan
        Hide
        Indrasan Yadav added a comment -

        Dear @Indrasan Yadav

        Please note that there are errors during import which might cause connection refused. Kindly check with DEV Team

        2025-06-04 14:28:14,964 ERROR [com.mobinets.nps.bo.imtDataInput.impl.NetworkCreateManager] (Thread-137) error while flushing and clearing session saveToDatabase...: org.hibernate.exception.ConstraintViolationException: could not execute batch

        2025-06-04 14:28:14,966 ERROR [com.mobinets.nps.services.imtDataInput.impl.ImtCreateWS] (Thread-137) Unavailable Service 'Save to Database'.: org.hibernate.exception.ConstraintViolationException: could not execute statement

        2025-06-04 14:28:14,979 INFO [stdout] (AsyncAppender-Dispatcher-Thread-124) Caused by: Error : 1400, Position : 147, Sql = insert into ooredoo.LTECELL (CELLDUPLEXINGMODE, DOWNLINKEARFCN, EnodebID, MIMOCONFIGURATION, PCID, TacID, UPLINKEARFCN, CELLID) values (:1 , :2 , :3 , :4 , :5 , :6 , :7 , :8 ), OriginalSql = insert into ooredoo.LTECELL (CELLDUPLEXINGMODE, DOWNLINKEARFCN, EnodebID, MIMOCONFIGURATION, PCID, TacID, UPLINKEARFCN, CELLID) values (?, ?, ?, ?, ?, ?, ?, ?), Error Msg = ORA-01400: cannot insert NULL into ("OOREDOO"."LTECELL"."ENODEBID")

        Best,

        Show
        Indrasan Yadav added a comment - Dear @Indrasan Yadav Please note that there are errors during import which might cause connection refused. Kindly check with DEV Team 2025-06-04 14:28:14,964 ERROR [com.mobinets.nps.bo.imtDataInput.impl.NetworkCreateManager] (Thread-137) error while flushing and clearing session saveToDatabase...: org.hibernate.exception.ConstraintViolationException: could not execute batch 2025-06-04 14:28:14,966 ERROR [com.mobinets.nps.services.imtDataInput.impl.ImtCreateWS] (Thread-137) Unavailable Service 'Save to Database'.: org.hibernate.exception.ConstraintViolationException: could not execute statement 2025-06-04 14:28:14,979 INFO [stdout] (AsyncAppender-Dispatcher-Thread-124) Caused by: Error : 1400, Position : 147, Sql = insert into ooredoo.LTECELL (CELLDUPLEXINGMODE, DOWNLINKEARFCN, EnodebID, MIMOCONFIGURATION, PCID, TacID, UPLINKEARFCN, CELLID) values (:1 , :2 , :3 , :4 , :5 , :6 , :7 , :8 ), OriginalSql = insert into ooredoo.LTECELL (CELLDUPLEXINGMODE, DOWNLINKEARFCN, EnodebID, MIMOCONFIGURATION, PCID, TacID, UPLINKEARFCN, CELLID) values (?, ?, ?, ?, ?, ?, ?, ?), Error Msg = ORA-01400: cannot insert NULL into ("OOREDOO"."LTECELL"."ENODEBID") Best,
        Indrasan Yadav made changes -
        Description I initiated an XML import on server .102 on dated 04-06-2025, but the connection was unexpectedly refused before the import could complete.

        Following this, I requested a platform restart to [~nasfaw]. After the restart, I attempted the XML import again, but the same issue is occurring.


        Server log & XML is attached here for reference.
        I initiated an XML (2025-06-04-11.48.54_Ooredoo_Tunisia) import on server .102 on dated 04-06-2025, but the connection was unexpectedly refused before the import could complete.

        Following this, I requested a platform restart to [~nasfaw]. After the restart, I attempted the XML import again, but the same issue is occurring.


        Server log & XML is attached here for reference.
        Indrasan Yadav made changes -
        Description I initiated an XML (2025-06-04-11.48.54_Ooredoo_Tunisia) import on server .102 on dated 04-06-2025, but the connection was unexpectedly refused before the import could complete.

        Following this, I requested a platform restart to [~nasfaw]. After the restart, I attempted the XML import again, but the same issue is occurring.


        Server log & XML is attached here for reference.
        I initiated a sample XML (2025-06-04-11.48.54_Ooredoo_Tunisia) import on server .102 on dated 04-06-2025, but the connection was unexpectedly refused before the import could complete.

        Following this, I requested a platform restart to [~nasfaw]. After the restart, I attempted the XML import again, but the same issue is occurring.


        Server log & XML is attached here for reference.
        Indrasan Yadav made changes -
        Remaining Estimate 0 minutes [ 0 ]
        Time Spent 1 hour [ 3600 ]
        Worklog Id 268806 [ 268806 ]
        Indrasan Yadav made changes -
        Baseline Start 2025-06-10 24:00 (set baseline based of initial work logging)
        Baseline End 2025-06-10 24:00 (set baseline based of initial work logging)
        Indrasan Yadav made changes -
        Time Spent 1 hour [ 3600 ] 1 hour, 30 minutes [ 5400 ]
        Worklog Id 268806 [ 268806 ]
        Indrasan Yadav made changes -
        Time Spent 1 hour, 30 minutes [ 5400 ] 2 hours [ 7200 ]
        Worklog Id 268806 [ 268806 ]
        Diana Hamdouche logged work - 11/Jun/25 12:00 AM
        • Time Spent:
          4 hours
           

          -

        Indrasan Yadav logged work - 11/Jun/25 12:00 AM - edited
        • Time Spent:
          1 hour
           

          discuss with @Bassem and remind on same mail to NEP DEV team.

        Hide
        Diana Hamdouche added a comment -

        Dears,

        Same occurred for Omantel and we agreed with @Abir to do the following as a work around:

        Try importing the non IP XML with the import of 4g cell disabled by using the below property:
        cell4gElement=false

        After it is completed try imploring the same xml without disabling the previous property and confirm.

        Show
        Diana Hamdouche added a comment - Dears, Same occurred for Omantel and we agreed with @Abir to do the following as a work around: Try importing the non IP XML with the import of 4g cell disabled by using the below property: cell4gElement=false After it is completed try imploring the same xml without disabling the previous property and confirm.
        Diana Hamdouche made changes -
        Status Open Bug [ 10108 ] Dev Scheduled [ 10014 ]
        Diana Hamdouche made changes -
        Status Dev Scheduled [ 10014 ] Implementation in progress [ 10016 ]
        Assignee Khaled Khalil [ kkhalil ] Diana Hamdouche [ dhamdouche ]
        Diana Hamdouche made changes -
        Status Implementation in progress [ 10016 ] To Be Released [ 10400 ]
        Diana Hamdouche made changes -
        Time Spent 2 hours [ 7200 ] 6 hours [ 21600 ]
        Worklog Id 269203 [ 269203 ]
        Khaled Khalil made changes -
        Status To Be Released [ 10400 ] Ready for QA [ 10023 ]
        Assignee Diana Hamdouche [ dhamdouche ] Indrasan Yadav [ iyadav ]
        Indrasan Yadav logged work - 12/Jun/25 12:00 AM - edited
        • Time Spent:
          2 hours, 30 minutes
           

          After received mail from @Diana, again imported the same XML without ltecell and xml was imported successfully then again imported same xml including ltecell and now xml again successfully imported.

        Hide
        Indrasan Yadav added a comment -

        Dear All,

        The import has been successfully completed.

        I would like to clarify the process for future imports of the RAN XML. Should we follow the same approach next time—first importing the XML without the LTE cell information, and then importing it again with the LTE cell included?

        Thank you,
        Indrasan

        Show
        Indrasan Yadav added a comment - Dear All, The import has been successfully completed. I would like to clarify the process for future imports of the RAN XML. Should we follow the same approach next time—first importing the XML without the LTE cell information, and then importing it again with the LTE cell included? Thank you, Indrasan
        Hide
        Indrasan Yadav added a comment -

        Hi Indrasan

        Our understanding is just the first time this is required , from now on import full with LTE CELL and let us know if it will be ok

        thx
        Abir

        Show
        Indrasan Yadav added a comment - Hi Indrasan Our understanding is just the first time this is required , from now on import full with LTE CELL and let us know if it will be ok thx Abir
        Indrasan Yadav made changes -
        Status Ready for QA [ 10023 ] QA In Progress [ 10015 ]
        Indrasan Yadav made changes -
        Status QA In Progress [ 10015 ] Closed [ 6 ]
        Resolution Fixed [ 1 ]
        Indrasan Yadav made changes -
        Time Spent 6 hours [ 21600 ] 1 day, 1 hour [ 32400 ]
        Worklog Id 269600 [ 269600 ]
        Indrasan Yadav made changes -
        Time Spent 1 day, 1 hour [ 32400 ] 1 day, 4 hours [ 43200 ]
        Worklog Id 269601 [ 269601 ]
        Indrasan Yadav made changes -
        Worklog Id 269600 [ 269600 ]
        Indrasan Yadav made changes -
        Remaining Estimate 0 minutes [ 0 ] 2 hours [ 7200 ]
        Time Spent 1 day, 4 hours [ 43200 ] 1 day, 2 hours [ 36000 ]
        Worklog Id 269600 [ 269600 ]
        Indrasan Yadav made changes -
        Remaining Estimate 2 hours [ 7200 ] 2 hours, 30 minutes [ 9000 ]
        Time Spent 1 day, 2 hours [ 36000 ] 1 day, 1 hour, 30 minutes [ 34200 ]
        Worklog Id 269601 [ 269601 ]
        Transition Time In Source Status Execution Times Last Executer Last Execution Date
        Open Bug Open Bug Dev Scheduled Dev Scheduled
        6d 1h 11m 1 Diana Hamdouche 11/Jun/25 6:56 AM
        Dev Scheduled Dev Scheduled Implementation in progress Implementation in progress
        3s 1 Diana Hamdouche 11/Jun/25 6:56 AM
        Implementation in progress Implementation in progress To Be Released To Be Released
        4s 1 Diana Hamdouche 11/Jun/25 6:56 AM
        To Be Released To Be Released Ready for QA Ready for QA
        5h 22m 1 Khaled Khalil 11/Jun/25 12:18 PM
        Ready for QA Ready for QA QA In Progress QA In Progress
        16h 14m 1 Indrasan Yadav 12/Jun/25 4:32 AM
        QA In Progress QA In Progress Closed Closed
        18s 1 Indrasan Yadav 12/Jun/25 4:32 AM
        Subversion JIRA

        Links Hierarchy

         Documentation

        Invalid license: EXPIRED

          People

          • Assignee:
            Indrasan Yadav
            Reporter:
            Indrasan Yadav
          • 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:
              Time Spent - 1 day, 1 hour, 30 minutes Remaining Estimate - 2 hours, 30 minutes
              2h 30m
              Logged:
              Time Spent - 1 day, 1 hour, 30 minutes Remaining Estimate - 2 hours, 30 minutes
              1d 1h 30m

                Drag and Drop