Details

    • Type: Bug Bug
    • Status: Rejected Rejected (View Workflow)
    • Priority: Normal Normal
    • Resolution: Done
    • Affects Version/s: None
    • Fix Version/s: None
    • Component/s: SRD
    • Labels:
    • Customer:
      OMAN-Tel
    • Product:
      NEP

      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>

        Activity

        Abdulrahman Dabboussi made changes -
        Field Original Value New Value
        Gantt Options Milestone (set to milestone: having a due date but zero effort)
        Planned Start 2026-03-17 24:00 (milestone: set planned start date to due date)
        Planned End 2026-03-17 24:00 (milestone: set planned end date to due date)
        Zein Trabelsi made changes -
        Assignee Zein Trabelsi [ ztrabelsi ] Ayed Bada [ abada ]
        Hide
        Ayed Bada added a comment -

        No exception was found in the logs.

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

        Show
        Ayed Bada added a comment - No exception was found in the logs. To get the details, a subscriber number with an existing trail should be provided.
        Ayed Bada made changes -
        Status Open Bug [ 10108 ] Rejected [ 10100 ]
        Assignee Ayed Bada [ abada ] Mbaye Lo [ mbayel ]
        Resolution Cancelled [ 10100 ]
        Mbaye Lo made changes -
        Assignee Mbaye Lo [ mbayel ] Zein Trabelsi [ ztrabelsi ]
        Hide
        Mbaye Lo added a comment - - edited

        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

        Show
        Mbaye Lo added a comment - - edited 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
        Mbaye Lo made changes -
        Resolution Cancelled [ 10100 ] Not Fixed [ 10200 ]
        Status Rejected [ 10100 ] Reopened [ 4 ]
        Mbaye Lo made changes -
        Attachment getSubscriberCurrentNetwork.jpg [ 134519 ]
        Zein Trabelsi made changes -
        Status Reopened [ 4 ] Dev Scheduled [ 10014 ]
        Zein Trabelsi made changes -
        Status Dev Scheduled [ 10014 ] Implementation in progress [ 10016 ]
        Hide
        Zein Trabelsi added a comment -

        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

        Show
        Zein Trabelsi added a comment - 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
        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 ] Mbaye Lo [ mbayel ]
        Hide
        Mbaye Lo added a comment -

        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

        Show
        Mbaye Lo added a comment - 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
        Mbaye Lo made changes -
        Status Ready for QA [ 10023 ] QA In Progress [ 10015 ]
        Mbaye Lo made changes -
        Status QA In Progress [ 10015 ] Reopened [ 4 ]
        Assignee Mbaye Lo [ mbayel ] Zein Trabelsi [ ztrabelsi ]
        Zein Trabelsi made changes -
        Attachment undefined.png [ 135006 ]
        Hide
        Zein Trabelsi added a comment -

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

        Show
        Zein Trabelsi added a comment - find attached exaple from 84 server it should return same data in staging platform
        Hide
        Zein Trabelsi added a comment -

        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;

        Show
        Zein Trabelsi added a comment - 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;
        Zein Trabelsi made changes -
        Status Reopened [ 4 ] Dev Scheduled [ 10014 ]
        Zein Trabelsi made changes -
        Status Dev Scheduled [ 10014 ] Implementation in progress [ 10016 ]
        Zein Trabelsi made changes -
        Status Implementation in progress [ 10016 ] Rejected [ 10100 ]
        Assignee Zein Trabelsi [ ztrabelsi ] Mbaye Lo [ mbayel ]
        Resolution Not Fixed [ 10200 ] Done [ 10000 ]
        Transition Time In Source Status Execution Times Last Executer Last Execution Date
        Open Bug Open Bug Rejected Rejected
        17d 4h 40m 1 Ayed Bada 27/Mar/26 1:45 PM
        Rejected Rejected Reopened Reopened
        44d 22h 30m 1 Mbaye Lo 11/May/26 1:16 PM
        Implementation in progress Implementation in progress To Be Released To Be Released
        6s 1 Zein Trabelsi 14/May/26 3:37 PM
        To Be Released To Be Released Ready for QA Ready for QA
        32m 7s 1 Khaled Khalil 14/May/26 4:09 PM
        Ready for QA Ready for QA QA In Progress QA In Progress
        3d 14h 35m 1 Mbaye Lo 18/May/26 6:45 AM
        QA In Progress QA In Progress Reopened Reopened
        12s 1 Mbaye Lo 18/May/26 6:45 AM
        Reopened Reopened Dev Scheduled Dev Scheduled
        4d 4h 39m 2 Zein Trabelsi 19/May/26 9:04 AM
        Dev Scheduled Dev Scheduled Implementation in progress Implementation in progress
        21s 2 Zein Trabelsi 19/May/26 9:04 AM
        Implementation in progress Implementation in progress Rejected Rejected
        15s 1 Zein Trabelsi 19/May/26 9:05 AM
        Subversion JIRA

        Links Hierarchy

         Documentation

        Invalid license: EXPIRED

          People

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

            Dates

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

              Drag and Drop