ACE
  1. ACE
  2. ACE-270

checkShiftingFiberFeasibility

        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:
        • Customer:
          Mobinets

          Description

          checkShiftingFiberFeasibility
          internal API not reflecting real data from UI

            Activity

            Ascending order - Click to sort in descending order
            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)
            Salem Dannawi made changes -
            Assignee Hassan Abdine [ habdine ] Zein Trabelsi [ ztrabelsi ]
            Khaled Khalil made changes -
            Customer OMAN-Tel [ 12200 ] Mobinets [ 12900 ]
            Permalink
            Zein Trabelsi logged work - 01/Dec/25 12:00 AM
            • Time Spent:
              1 day
               

              Refactoring checkShiftingFiberFeasibility

            Zein Trabelsi made changes -
            Remaining Estimate 0 minutes [ 0 ]
            Time Spent 1 day [ 28800 ]
            Worklog Id 285039 [ 285039 ]
            zTrabelsi made changes -
            Baseline Start 2025-11-05 24:00 (set baseline based of initial work logging)
            Baseline End 2025-11-05 24:00 (set baseline based of initial work logging)
            Zein Trabelsi made changes -
            Status Open Bug [ 10108 ] Dev Scheduled [ 10014 ]
            Zein Trabelsi made changes -
            Status Dev Scheduled [ 10014 ] Implementation in progress [ 10016 ]
            Zein Trabelsi made changes -
            Status Implementation in progress [ 10016 ] To Be Released [ 10400 ]
            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 To Be Released [ 10400 ] Implementation in progress [ 10016 ]
            Zein Trabelsi made changes -
            Status Implementation in progress [ 10016 ] To Be Released [ 10400 ]
            Zein Trabelsi made changes -
            Status To Be Released [ 10400 ] Implementation in progress [ 10016 ]
            Zein Trabelsi made changes -
            Status Implementation in progress [ 10016 ] To Be Released [ 10400 ]
            Khaled Khalil made changes -
            Status To Be Released [ 10400 ] Ready for QA [ 10023 ]
            Assignee Zein Trabelsi [ ztrabelsi ] Salem Dannawi [ sdannawi ]
            Transition Time In Source Status Execution Times Last Executer Last Execution Date
            Open Bug Open Bug Dev Scheduled Dev Scheduled
            		29d 9h 23m 1 Zein Trabelsi 03/Dec/25 2:24 PM
            Dev Scheduled Dev Scheduled Implementation in progress Implementation in progress
            		8s 1 Zein Trabelsi 03/Dec/25 2:24 PM
            To Be Released To Be Released Implementation in progress Implementation in progress
            		57s 2 Zein Trabelsi 03/Dec/25 2:25 PM
            Implementation in progress Implementation in progress To Be Released To Be Released
            		26s 3 Zein Trabelsi 03/Dec/25 2:25 PM
            To Be Released To Be Released Ready for QA Ready for QA
            		2m 43s 1 Khaled Khalil 03/Dec/25 2:28 PM
            Subversion JIRA

            Links Hierarchy

            		  Documentation

            Invalid license: EXPIRED

            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:
                  Actual Start:
                  Date of Baselining:

                  Time Tracking

                  Estimated:
                  Original Estimate - Not Specified
                  Not Specified
                  Remaining:
                  Remaining Estimate - 0 minutes
                  0m
                  Logged:
                  Time Spent - 1 day
                  1d

                    Drag and Drop