[ACE-728] Review SRD API getSubscriberCurrentNetwork Created: 10/Mar/26  Updated: 19/May/26  Due: 17/Mar/26  Resolved: 19/May/26

Status: Rejected
Project: ACE
Component/s: SRD
Affects Version/s: None
Fix Version/s: None

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

Attachments: JPEG File getSubscriberCurrentNetwork.jpg     PNG File undefined.png    
Customer:
OMAN-Tel
Planned Start:
Planned End:
Product: NEP
Rejected By: Zein Trabelsi

 Description   

Review SRD API getSubscriberCurrentNetwork
<soapenv:Envelope xmlns:soapenv="http://schemas.xmlsoap.org/soap/envelope/" xmlns:ser="http://server.internal.api.srd.nep.mobinets.com/">
<soapenv:Header/>
<soapenv:Body>
<ser:getSubscriberCurrentNetwork>
<!-Optional:->
<requestNo>12082088</requestNo>
<!-Optional:->
<subscriberNo>24220910</subscriberNo>
<!-Optional:->
<serviceType>Route_Check</serviceType>
<!-Optional:->
<bandwidth>100.0</bandwidth>
</ser:getSubscriberCurrentNetwork>
</soapenv:Body>
</soapenv:Envelope>



 Comments   
Comment by Ayed Bada [ 27/Mar/26 ]

No exception was found in the logs.

To get the details, a subscriber number with an existing trail should be provided.

Comment by Mbaye Lo [ 11/May/26 ]

Please provide a sample in Omantel platforms 179 and 84

I retried to test this API, but I can't find in SRD UI where to get the Request ID matching with the subscriber, Service Type and the Bandwidth

Comment by Zein Trabelsi [ 14/May/26 ]

What it does: Returns the current network info for a subscriber — access node ID/category, CE type, ..

Bugs fixed:
NullPointerException in ServiceTrailService.getTransferredOspConnection() when a trail hop references a node/port not found in inventory — null checks added.
ORA-01400 in saveRequestLog when requestNo is empty — guard added.

How to test:

Find a valid subscriber from SRD UI -> Subscriber report — pick one with Active status and trails visible.
Call the API with that subscriber number : requestNo must not be empty
Expected response: accessNodeId, accessNodeCategory, ceType, distanceToExchange
Verify in SRD UI: open the subscriber -> trail panel should show the same access node returned by the API
Note: serviceType and bandwidth parameters are accepted but not used by the current implementation.

fix available with version 4.0.0.5

Comment by Mbaye Lo [ 15/May/26 ]

I have been fetching for a subscriber numer with a trail and active status, but when I go to the Customer report to find the requestID, I can't find any. I tried several subscriber numbers during around 20 minutes.
Better to proceed with SQL Code

Comment by Zein Trabelsi [ 19/May/26 ]

find attached exaple from 84 server it should return same data in staging platform

Comment by Zein Trabelsi [ 19/May/26 ]

SELECT m.SUBSCRIBER_NUMBER, m.CE_NE_TYPE, m.CE_ID
FROM SRD_MPLS_DETAILS_VIEW m
WHERE NOT EXISTS (
SELECT 1 FROM SRD_NE_RELATION_VIEW r
WHERE r.SUBSCRIBER_NUMBER = m.SUBSCRIBER_NUMBER
)
FETCH FIRST 5 ROWS ONLY;

Generated at Mon Jun 15 15:59:03 EEST 2026 using JIRA 6.1.4#6159-sha1:44eaedef2e4a625c6c7183698b2468d4719c20dc.