Details
-
Type:
Bug
-
Status:
Ready for QA
(View Workflow)
-
Priority:
Normal
-
Resolution: Unresolved
-
Affects Version/s: None
-
Fix Version/s: None
-
Component/s: FN
-
Labels:None Labels
-
Customer:Mobinets
Description
checkNewActivationFiberFeasibility
internal API not getting data from FN UI
Activity
| Field | Original Value | New Value |
|---|---|---|
| Gantt Options | Milestone (set to milestone: having a due date but zero effort) | |
| Planned Start | 2025-11-07 24:00 (milestone: set planned start date to due date) | |
| Planned End | 2025-11-07 24:00 (milestone: set planned end date to due date) |
| Component/s | FN [ 16303 ] |
| Assignee | Hassan Abdine [ habdine ] | Zein Trabelsi [ ztrabelsi ] |
| Customer | OMAN-Tel [ 12200 ] | Mobinets [ 12900 ] |
-
- Time Spent:
- 1 day
-
checkNewActivationFiberFeasibility
| Status | Open Bug [ 10108 ] | Dev Scheduled [ 10014 ] |
| Status | Dev Scheduled [ 10014 ] | Implementation in progress [ 10016 ] |
-
- Time Spent:
- 6 hours
-
ACE-264 - checkNewActivationFiberFeasibility
| Remaining Estimate | 0 minutes [ 0 ] | |
| Time Spent | 1 day [ 28800 ] | |
| Worklog Id | 283700 [ 283700 ] |
| Baseline Start | 2025-11-07 24:00 (set baseline based of initial work logging) | |
| Baseline End | 2025-11-07 24:00 (set baseline based of initial work logging) |
| Time Spent | 1 day [ 28800 ] | 2 days [ 57600 ] |
| Worklog Id | 283701 [ 283701 ] |
| Remaining Estimate | 0 minutes [ 0 ] | 1 day [ 28800 ] |
| Time Spent | 2 days [ 57600 ] | 1 day [ 28800 ] |
| Worklog Id | 283700 [ 283700 ] | |
| Worklog Time Spent | 1 day [ 28800 ] |
| Remaining Estimate | 1 day [ 28800 ] | 2 hours [ 7200 ] |
| Time Spent | 1 day [ 28800 ] | 1 day, 6 hours [ 50400 ] |
| Worklog Id | 283741 [ 283741 ] |
| Status | Implementation in progress [ 10016 ] | To Be Released [ 10400 ] |
| 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 | |||||
|---|---|---|---|---|---|---|---|---|---|
|
13d 17h 54m | 1 | Zein Trabelsi | 17/Nov/25 7:06 AM | |||||
|
4s | 1 | Zein Trabelsi | 17/Nov/25 7:06 AM | |||||
|
16d 7h 20m | 1 | Zein Trabelsi | 03/Dec/25 2:26 PM | |||||
|
3m 14s | 1 | Khaled Khalil | 03/Dec/25 2:29 PM |
|
Links Hierarchy |
 Documentation
|
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.