ACE
  1. ACE
  2. ACE-266

checkNewActivationMplsFeasibility

        Details

        • Type: Bug Bug
        • Status: Ready for QA Ready for QA (View Workflow)
        • Priority: Normal Normal
        • Resolution: Unresolved
        • Affects Version/s: None
        • Fix Version/s: None
        • Component/s: FN
        • Labels:
          None Labels
        • Customer:
          Mobinets

          Description

          checkNewActivationMplsFeasibility
          internal API is not returning data in UI

            Activity

            Descending order - Click to sort in ascending order
            Subversion JIRA

            Links Hierarchy

            		  Documentation

            Invalid license: EXPIRED

            Transition Time In Source Status Execution Times Last Executer Last Execution Date
            Open Bug Open Bug Dev Scheduled Dev Scheduled
            		29d 9h 55m 1 Zein Trabelsi 03/Dec/25 2:29 PM
            Dev Scheduled Dev Scheduled Implementation in progress Implementation in progress
            		5s 1 Zein Trabelsi 03/Dec/25 2:29 PM
            Implementation in progress Implementation in progress To Be Released To Be Released
            		10s 1 Zein Trabelsi 03/Dec/25 2:29 PM
            To Be Released To Be Released Ready for QA Ready for QA
            		13s 1 Khaled Khalil 03/Dec/25 2:29 PM
            Khaled Khalil made changes -
            Status To Be Released [ 10400 ] Ready for QA [ 10023 ]
            Assignee Zein Trabelsi [ ztrabelsi ] Salem Dannawi [ sdannawi ]
            Hide
            Permalink
            Zein Trabelsi added a comment -

            Replace entity-based queries with DTO-based queries using QueryDSL projections. This addresses performance and lazy loading issues. The new approach uses Projections.constructor() to map query results directly to DTOs (ServiceTrailDto, ServiceTrailHopDto), avoiding eager loading of entities and slow views like FN_DETAILED_OSP_CONNECTION_V. A key change is that the refactored code no longer relies on the slow database views (FN_DETAILED_OSP_CONNECTION_V and FN_OSP_CONNECTION_VIEW) and instead queries the OspConnection entity directly from the base table, significantly improving query performance. Batch fetching was implemented to load hops and OSP connections in single queries instead of N+1 patterns, reducing database round trips from hundreds to 3–4 queries per request.

            Show
            Zein Trabelsi added a comment - Replace entity-based queries with DTO-based queries using QueryDSL projections. This addresses performance and lazy loading issues. The new approach uses Projections.constructor() to map query results directly to DTOs (ServiceTrailDto, ServiceTrailHopDto), avoiding eager loading of entities and slow views like FN_DETAILED_OSP_CONNECTION_V. A key change is that the refactored code no longer relies on the slow database views (FN_DETAILED_OSP_CONNECTION_V and FN_OSP_CONNECTION_VIEW) and instead queries the OspConnection entity directly from the base table, significantly improving query performance. Batch fetching was implemented to load hops and OSP connections in single queries instead of N+1 patterns, reducing database round trips from hundreds to 3–4 queries per request.
            Zein Trabelsi made changes -
            Status Implementation in progress [ 10016 ] To Be Released [ 10400 ]
            Zein Trabelsi made changes -
            Status Dev Scheduled [ 10014 ] Implementation in progress [ 10016 ]
            Zein Trabelsi made changes -
            Status Open Bug [ 10108 ] Dev Scheduled [ 10014 ]
            Khaled Khalil made changes -
            Customer OMAN-Tel [ 12200 ] Mobinets [ 12900 ]
            Salem Dannawi made changes -
            Assignee Hassan Abdine [ habdine ] Zein Trabelsi [ ztrabelsi ]
            Salem Dannawi made changes -
            Field Original Value New Value
            Gantt Options Milestone (set to milestone: having a due date but zero effort)
            Planned Start 2025-11-05 24:00 (milestone: set planned start date to due date)
            Planned End 2025-11-05 24:00 (milestone: set planned end date to due date)
            Cancel

              People

              • Assignee:
                Salem Dannawi
                Reporter:
                Salem Dannawi
              • Votes:
                0 Vote for this issue
                Watchers:
                2 Start watching this issue

                Dates

                • Due:
                  Created:
                  Updated:
                  Planned Start:
                  Planned End:

                  Drag and Drop