Details

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

      Description

      Review SRD API getIPCoreRoute
      <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:getIPCoreRoute>
      <!-Zero or more repetitions:->
      <siteIds>H0001</siteIds>
      <!-Optional:->
      <pathsNum>1</pathsNum>
      </ser:getIPCoreRoute>
      </soapenv:Body>
      </soapenv:Envelope>

        Activity

        Hide
        Ayed Bada added a comment -

        The API currently returns an empty response. To get a complete response, we need to run the following query to retrieve the siteId covered by the API:
        SELECT srv.site_id
        FROM SRD_ROUTER_VIEW srv
        INNER JOIN ELEMENTADDITIONALINFO edi
        ON srv.id = edi.ElementId
        WHERE attribute = 'NE_Network_Position'
        AND value = 'PE';

        Show
        Ayed Bada added a comment - The API currently returns an empty response. To get a complete response, we need to run the following query to retrieve the siteId covered by the API: SELECT srv.site_id FROM SRD_ROUTER_VIEW srv INNER JOIN ELEMENTADDITIONALINFO edi ON srv.id = edi.ElementId WHERE attribute = 'NE_Network_Position' AND value = 'PE';
        Hide
        Mbaye Lo added a comment - - edited

        Please provide a sample in Omantel platforms 179 and 84 and to be demoed in SRD UI

        I got below list of site IDs, but the output is still empty

        SIT IDs :
        D0100
        M0001
        48
        D0001
        Q0415
        K0001
        M0010
        M0028
        Default Site
        TB-10K-ADSL
        TRG-PE-CORE-NE80E-1
        S0001
        M0011

        REQUEST / RESPONSE :
        <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:getIPCoreRoute>
        <!-Zero or more repetitions:->
        <siteIds>TRG-PE-CORE-NE80E</siteIds>
        <!-Optional:->
        <pathsNum>50</pathsNum>
        </ser:getIPCoreRoute>
        </soapenv:Body>
        </soapenv:Envelope>

        <soap:Envelope xmlns:soap=http://schemas.xmlsoap.org/soap/envelope/>
        <soap:Body>
        <ns2:getIPCoreRouteResponse xmlns:ns2=http://server.internal.api.srd.nep.mobinets.com//>
        </soap:Body>
        </soap:Envelope>

        Show
        Mbaye Lo added a comment - - edited Please provide a sample in Omantel platforms 179 and 84 and to be demoed in SRD UI I got below list of site IDs, but the output is still empty SIT IDs : D0100 M0001 48 D0001 Q0415 K0001 M0010 M0028 Default Site TB-10K-ADSL TRG-PE-CORE-NE80E-1 S0001 M0011 REQUEST / RESPONSE : <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:getIPCoreRoute> <!- Zero or more repetitions: -> <siteIds>TRG-PE-CORE-NE80E</siteIds> <!- Optional: -> <pathsNum>50</pathsNum> </ser:getIPCoreRoute> </soapenv:Body> </soapenv:Envelope> <soap:Envelope xmlns:soap= http://schemas.xmlsoap.org/soap/envelope/ > <soap:Body> <ns2:getIPCoreRouteResponse xmlns:ns2= http://server.internal.api.srd.nep.mobinets.com// > </soap:Body> </soap:Envelope>
        Hide
        Zein Trabelsi added a comment -

        The siteIds parameter must be Site IDs of PE routers, visible in SRD UI under Inventory → Router (Site ID column). The test environment has no PE routers configured (NE_Network_Position = PE not set on any router in NEP inventory), which is why the API returns empty. Valid testing requires at least 2 PE routers configured in NEP inventory.

        Show
        Zein Trabelsi added a comment - The siteIds parameter must be Site IDs of PE routers, visible in SRD UI under Inventory → Router (Site ID column). The test environment has no PE routers configured (NE_Network_Position = PE not set on any router in NEP inventory), which is why the API returns empty. Valid testing requires at least 2 PE routers configured in NEP inventory.
        Hide
        Mbaye Lo added a comment -

        Previous list is got from the sql code shared by Ayed, which include "value = 'PE" :

        SELECT srv.site_id
        FROM SRD_ROUTER_VIEW srv
        INNER JOIN ELEMENTADDITIONALINFO edi
        ON srv.id = edi.ElementId
        WHERE attribute = 'NE_Network_Position'
        AND value = 'PE';

        Show
        Mbaye Lo added a comment - Previous list is got from the sql code shared by Ayed, which include "value = 'PE" : SELECT srv.site_id FROM SRD_ROUTER_VIEW srv INNER JOIN ELEMENTADDITIONALINFO edi ON srv.id = edi.ElementId WHERE attribute = 'NE_Network_Position' AND value = 'PE';
        Hide
        Zein Trabelsi added a comment -

        find attached sample request from 84 server :
        forget the query you must copy two site ids from the report in SRD UI, link of report : http://10.164.144.84:9189/NEP_SRD_UI/reporting/router

        Show
        Zein Trabelsi added a comment - find attached sample request from 84 server : forget the query you must copy two site ids from the report in SRD UI, link of report : http://10.164.144.84:9189/NEP_SRD_UI/reporting/router
        Hide
        Mbaye Lo added a comment -

        The output is fine now, but there is a performance issue now : 6s on OLD, versu 11s on NEW. See screenshots

        Show
        Mbaye Lo added a comment - The output is fine now, but there is a performance issue now : 6s on OLD, versu 11s on NEW. See screenshots
        Hide
        Zein Trabelsi added a comment -

        fixed available with release 53

        Show
        Zein Trabelsi added a comment - fixed available with release 53

          People

          • Assignee:
            Zein Trabelsi
            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