ACE
  1. ACE
  2. ACE-734

FN-UI Testing : Load MPLS Details is having Perf. Issue

        Details

        • Type: Bug Bug
        • Status: Reopened Reopened (View Workflow)
        • Priority: Normal Normal
        • Resolution: Not Fixed
        • Affects Version/s: FN 4.0.0.48
        • Fix Version/s: None
        • Component/s: FN
        • Labels:
        • Customer:
          OMAN-Tel
        • Product:
          NEP

          Description


          FN-UI Testing : Load MPLS Details is having Perf. Issue 13s on OLD and 45s on New

            Activity

            Ascending order - Click to sort in descending order
            Mbaye Lo made changes -
            Field Original Value New Value
            Gantt Options Milestone (set to milestone: having a due date but zero effort)
            Planned Start 2026-03-10 24:00 (milestone: set planned start date to due date)
            Planned End 2026-03-10 24:00 (milestone: set planned end date to due date)
            Zein Trabelsi made changes -
            Status Open Bug [ 10108 ] Dev Scheduled [ 10014 ]
            Zein Trabelsi made changes -
            Status Dev Scheduled [ 10014 ] Implementation in progress [ 10016 ]
            Hide
            Permalink
            Zein Trabelsi added a comment -

            improve report loading performance by replacing costly view joins with in-memory map lookups, adding targeted DB indexes on MPLS_DETAILS, NODEINTERFACE, NODESLOT and ACCESSCONFIGURATION tables, and adding @BatchSize annotations on Subscriber and SubscriberIp entities to eliminate N+1 queries

            Show
            Zein Trabelsi added a comment - improve report loading performance by replacing costly view joins with in-memory map lookups, adding targeted DB indexes on MPLS_DETAILS, NODEINTERFACE, NODESLOT and ACCESSCONFIGURATION tables, and adding @BatchSize annotations on Subscriber and SubscriberIp entities to eliminate N+1 queries
            Zein Trabelsi made changes -
            Status Implementation in progress [ 10016 ] To Be Released [ 10400 ]
            Hide
            Permalink
            Zein Trabelsi added a comment -

            will be available on release 4.0.0.47

            Show
            Zein Trabelsi added a comment - will be available on release 4.0.0.47
            Khaled Khalil made changes -
            Status To Be Released [ 10400 ] Ready for QA [ 10023 ]
            Assignee Zein Trabelsi [ ztrabelsi ] Mbaye Lo [ mbayel ]
            Mbaye Lo made changes -
            Status Ready for QA [ 10023 ] QA In Progress [ 10015 ]
            Hide
            Permalink
            Mbaye Lo added a comment -

            MPLS Details is returning empty page on .84t

            Show
            Mbaye Lo added a comment - MPLS Details is returning empty page on .84t
            Mbaye Lo made changes -
            Status QA In Progress [ 10015 ] Reopened [ 4 ]
            Assignee Mbaye Lo [ mbayel ] Zein Trabelsi [ ztrabelsi ]
            Resolution Not Fixed [ 10200 ]
            Attachment MPLS Details is returning empty page on .84t .jpg [ 130523 ]
            Khaled Khalil made changes -
            Status Reopened [ 4 ] Dev Scheduled [ 10014 ]
            Zein Trabelsi made changes -
            Assignee Zein Trabelsi [ ztrabelsi ] Ayed Bada [ abada ]
            Ayed Bada made changes -
            Status Dev Scheduled [ 10014 ] Implementation in progress [ 10016 ]
            Ayed Bada made changes -
            Status Implementation in progress [ 10016 ] To Be Released [ 10400 ]
            Hide
            Permalink
            Ayed Bada added a comment -

            Fix SQLGrammarException
            Patch : 4.0.0.48

            Show
            Ayed Bada added a comment - Fix SQLGrammarException Patch : 4.0.0.48
            Khaled Khalil made changes -
            Status To Be Released [ 10400 ] Ready for QA [ 10023 ]
            Assignee Ayed Bada [ abada ] Mbaye Lo [ mbayel ]
            Mbaye Lo made changes -
            Assignee Mbaye Lo [ mbayel ] Zein Trabelsi [ ztrabelsi ]
            Mbaye Lo made changes -
            Status Ready for QA [ 10023 ] QA In Progress [ 10015 ]
            Assignee Zein Trabelsi [ ztrabelsi ] Mbaye Lo [ mbayel ]
            Hide
            Permalink
            Mbaye Lo added a comment -

            Not fixed, Exception error

            Show
            Mbaye Lo added a comment - Not fixed, Exception error
            Mbaye Lo made changes -
            Status QA In Progress [ 10015 ] Reopened [ 4 ]
            Assignee Mbaye Lo [ mbayel ] Zein Trabelsi [ ztrabelsi ]
            Khaled Khalil made changes -
            Status Reopened [ 4 ] Dev Scheduled [ 10014 ]
            Khaled Khalil made changes -
            Assignee Zein Trabelsi [ ztrabelsi ] Ayed Bada [ abada ]
            Hide
            Permalink
            Ayed Bada added a comment -

            Please retest the mentioned patch. Version 4.0.0.48 has been deployed

            Show
            Ayed Bada added a comment - Please retest the mentioned patch. Version 4.0.0.48 has been deployed
            Ayed Bada made changes -
            Status Dev Scheduled [ 10014 ] Implementation in progress [ 10016 ]
            Ayed Bada 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 Ayed Bada [ abada ] Mbaye Lo [ mbayel ]
            Mbaye Lo made changes -
            Status Ready for QA [ 10023 ] QA In Progress [ 10015 ]
            Hide
            Permalink
            Mbaye Lo added a comment -

            MPLS Details report is opened, but a performance issue is still pending :

            48s on .80 and 81s on .84

            Show
            Mbaye Lo added a comment - MPLS Details report is opened, but a performance issue is still pending : 48s on .80 and 81s on .84
            Mbaye Lo made changes -
            Status QA In Progress [ 10015 ] Reopened [ 4 ]
            Affects Version/s FN 4.0.0.48 [ 48401 ]
            Affects Version/s UCMDB 4.0.0.0 [ 39520 ]
            Assignee Mbaye Lo [ mbayel ] Zein Trabelsi [ ztrabelsi ]
            Hide
            Permalink
            Ayed Bada added a comment -

            Removed unnecessary calls and optimized processing by executing operations in parallel.

            Patch: 4.0.0.49

            Show
            Ayed Bada added a comment - Removed unnecessary calls and optimized processing by executing operations in parallel. Patch: 4.0.0.49
            Transition Time In Source Status Execution Times Last Executer Last Execution Date
            Open Bug Open Bug Dev Scheduled Dev Scheduled
            		20h 45m 1 Zein Trabelsi 11/Mar/26 9:29 AM
            Reopened Reopened Dev Scheduled Dev Scheduled
            		1d 8h 53m 2 Khaled Khalil 03/Apr/26 11:31 AM
            Dev Scheduled Dev Scheduled Implementation in progress Implementation in progress
            		12d 22h 24m 3 Ayed Bada 03/Apr/26 3:28 PM
            Implementation in progress Implementation in progress To Be Released To Be Released
            		1h 40m 3 Ayed Bada 03/Apr/26 3:28 PM
            To Be Released To Be Released Ready for QA Ready for QA
            		3h 7m 3 Khaled Khalil 03/Apr/26 4:08 PM
            Ready for QA Ready for QA QA In Progress QA In Progress
            		12d 12h 39m 3 Mbaye Lo 07/Apr/26 11:16 AM
            QA In Progress QA In Progress Reopened Reopened
            		3m 17s 3 Mbaye Lo 07/Apr/26 11:19 AM
            Subversion JIRA

            Links Hierarchy

            		  Documentation

            Invalid license: EXPIRED

            Cancel

              People

              • Assignee:
                Zein Trabelsi
                Reporter:
                Mbaye Lo
              • Votes:
                0 Vote for this issue
                Watchers:
                3 Start watching this issue

                Dates

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

                  Drag and Drop