[ACE-734] FN-UI Testing : Load MPLS Details is having Perf. Issue Created: 10/Mar/26  Updated: 13/Apr/26  Due: 10/Mar/26  Resolved: 17/Mar/26

Status: Reopened
Project: ACE
Component/s: FN
Affects Version/s: FN 4.0.0.48
Fix Version/s: None

Type: Bug Priority: Normal
Reporter: Mbaye Lo Assignee: Zein Trabelsi
Resolution: Not Fixed Votes: 0
Labels: Milestone2
Remaining Estimate: Not Specified
Time Spent: Not Specified
Original Estimate: Not Specified

Attachments: JPEG File MPLS Details is returning empty page on .84t .jpg     JPEG File There was an exception while trying to navigate to 'request' with the exception message 'error creating bean with name .jpg    
Customer:
OMAN-Tel
Planned Start:
Planned End:
Product: NEP

 Description   


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



 Comments   
Comment by Zein Trabelsi [ 11/Mar/26 ]

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

Comment by Zein Trabelsi [ 11/Mar/26 ]

will be available on release 4.0.0.47

Comment by Mbaye Lo [ 17/Mar/26 ]

MPLS Details is returning empty page on .84t

Comment by Ayed Bada [ 30/Mar/26 ]

Fix SQLGrammarException
Patch : 4.0.0.48

Comment by Mbaye Lo [ 02/Apr/26 ]

Not fixed, Exception error

Comment by Ayed Bada [ 03/Apr/26 ]

Please retest the mentioned patch. Version 4.0.0.48 has been deployed

Comment by Mbaye Lo [ 07/Apr/26 ]

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

48s on .80 and 81s on .84

Comment by Ayed Bada [ 13/Apr/26 ]

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

Patch: 4.0.0.49

Generated at Wed Apr 15 13:45:57 EEST 2026 using JIRA 6.1.4#6159-sha1:44eaedef2e4a625c6c7183698b2468d4719c20dc.