Details

    • Type: Bug Bug
    • Status: Ready for QA Ready for QA (View Workflow)
    • Priority: Normal Normal
    • Resolution: Unresolved
    • Affects Version/s: None
    • Fix Version/s: None
    • Component/s: FN
    • Labels:
    • Customer:
      OMAN-Tel

      Description

      checkNewActivationFiberFeasibility has Performance Issue

      0.8s versus 2.7s

      <soapenv:Envelope xmlns:soapenv="http://schemas.xmlsoap.org/soap/envelope/" xmlns:ser="http://server.api.nep.mobinets.com/">
      <soapenv:Header/>
      <soapenv:Body>
      <ser:checkNewActivationFiberFeasibility>
      <!-Optional:->
      <exchange>AKO2</exchange>
      <fdh>003S</fdh>
      <ap>0040</ap>
      <serviceTypeName>GPON VOICE AND DATA HP1</serviceTypeName>

      </ser:checkNewActivationFiberFeasibility>
      </soapenv:Body>
      </soapenv:Envelope>

      <soap:Envelope xmlns:soap="http://schemas.xmlsoap.org/soap/envelope/">
      <soap:Body>
      <ns2:checkNewActivationFiberFeasibilityResponse xmlns:ns2="http://server.api.nep.mobinets.com/">
      <return>
      <postErrorMessage>ATB Selection: FTP Port already reserved</postErrorMessage>
      <responseCode>0</responseCode>
      <responseMessage>SUCCESS</responseMessage>
      <trails>
      <exchange>AKO2</exchange>
      <exchange2/>
      <hops>
      <order>0</order>
      <ospConnection>
      <changedBy>System</changedBy>
      <changedDate>2024-12-01T15:55:51+04:00</changedDate>
      <info>24538407 24539036 24274748 24551959 24278245 24270291 24542760 24542787 24270349 24542687 24542694 24542568 24185433 24286960 24272681 24540853 , , 24542385, , 24278061, , , , , , , 24542865, , , , 24545013, , 45000145</info>
      <mainStatus xmlID="iP">
      <id>DF736051E7344FF7973B405FCEA7B08C</id>
      <name>Reserved pair</name>
      </mainStatus>
      <node1Code>10.126.37.1</node1Code>
      <node1Model>MA5600T</node1Model>
      <node1Name>AKO2_03_MA5600T_OLT</node1Name>
      <node1ObjectId>10.126.37.1</node1ObjectId>
      <node1Type>MultiTechnologyAccess</node1Type>
      <node1TypeCategory>OLT</node1TypeCategory>
      <node2Code>AKO2_04_MA5600T_OLT</node2Code>
      <node2Model>ODF</node2Model>
      <node2Name>AKO2_04_MA5600T_OLT_ODF</node2Name>
      <node2ObjectId>AKO2_04_MA5600T_OLT_ODF</node2ObjectId>
      <node2Type>ODF</node2Type>
      <node2TypeCategory>ODF</node2TypeCategory>
      <ospCnx xmlID="i_">
      <id>pair_6936166</id>
      <changedate>2024-12-01T15:55:51+04:00</changedate>
      <changedby>System</changedby>
      <insertBy>System</insertBy>
      <insertdate>2023-09-04T12:21:27+04:00</insertdate>
      <netStatus xmlID="iP">
      <id>DF736051E7344FF7973B405FCEA7B08C</id>
      <name>Reserved pair</name>
      </netStatus>
      <subNetStatus xmlID="i3">
      <id>1714F9599D9E4BBA88391048CBC864EF</id>
      <name>Working pair - dedicated</name>
      </subNetStatus>
      <element1End>BACK</element1End>
      <element1Id>60F32AFE71824DA59F7CAB0C3153E77A-1/0/16/0/9</element1Id>
      <element1Type>NodeInterface</element1Type>
      <element2End>BACK</element2End>
      <element2Id>op_739153</element2Id>
      <element2Type>OdfPort</element2Type>
      <info>24538407 24539036 24274748 24551959 24278245 24270291 24542760 24542787 24270349 24542687 24542694 24542568 24185433 24286960 24272681 24540853 , , 24542385, , 24278061, , , , , , , 24542865, , , , 24545013, , 45000145</info>
      <node2Id>Odf_24397</node2Id>
      <nodeId>60F32AFE71824DA59F7CAB0C3153E77A</nodeId>
      <versionId>A3AD36B6ACB149A8A1B6E5EB335A43DA</versionId>
      </ospCnx>
      <port1Key>1/0/16/0/9</port1Key>
      <port1Name>GPON 1/0/16/0/9</port1Name>
      <port1Status>AS</port1Status>
      <port2Key>10-3</port2Key>
      <port2Name>FRONT-10-3</port2Name>
      <secondaryStatus xmlID="i3">
      <id>1714F9599D9E4BBA88391048CBC864EF</id>
      <name>Working pair - dedicated</name>
      </secondaryStatus>
      <site1ObjectId>M0004</site1ObjectId>
      <site2ObjectId>M0004</site2ObjectId>
      </ospConnection>
      <versionId>A3AD36B6ACB149A8A1B6E5EB335A43DA</versionId>
      </hops>
      <hops>
      <order>1</order>
      <ospConnection>
      <changedBy>System</changedBy>
      <changedDate>2024-12-01T15:55:51+04:00</changedDate>
      <info>24542865</info>
      <mainStatus xmlID="iP">
      <id>DF736051E7344FF7973B405FCEA7B08C</id>
      <name>Reserved pair</name>
      </mainStatus>
      <node1Code>AKO2_04_MA5600T_OLT</node1Code>
      <node1Model>ODF</node1Model>
      <node1Name>AKO2_04_MA5600T_OLT_ODF</node1Name>
      <node1ObjectId>AKO2_04_MA5600T_OLT_ODF</node1ObjectId>
      <node1Type>ODF</node1Type>
      <node1TypeCategory>ODF</node1TypeCategory>
      <node2Code>003S</node2Code>
      <node2Model>Optical_Splitter_1:32_8</node2Model>
      <node2Name>AKO2_003S_FD</node2Name>
      <node2ObjectId>AKO2_003S_FD</node2ObjectId>
      <node2Type>Optical_Splitter</node2Type>
      <node2TypeCategory>FDH</node2TypeCategory>
      <ospCnx xmlID="i01">
      <id>pair_6989484</id>
      <changedate>2024-12-01T15:55:51+04:00</changedate>
      <changedby>System</changedby>
      <insertBy>System</insertBy>
      <insertdate>2024-07-29T16:20:49+04:00</insertdate>
      <netStatus xmlID="iP">
      <id>DF736051E7344FF7973B405FCEA7B08C</id>
      <name>Reserved pair</name>
      </netStatus>
      <subNetStatus xmlID="i3">
      <id>1714F9599D9E4BBA88391048CBC864EF</id>
      <name>Working pair - dedicated</name>
      </subNetStatus>
      <element1End>BACK</element1End>
      <element1Id>op_5258660</element1Id>
      <element1Type>OdfPort</element1Type>
      <element2End>BACK</element2End>
      <element2Id>FCD2E5D2BA4E4B2E9B3ED9E82C637EF8-1/1/7/0/1</element2Id>
      <element2Type>NodeInterface</element2Type>
      <info>24542865</info>
      <node2Id>FCD2E5D2BA4E4B2E9B3ED9E82C637EF8</node2Id>
      <nodeId>Odf_24397</nodeId>
      <versionId>A3AD36B6ACB149A8A1B6E5EB335A43DA</versionId>
      </ospCnx>
      <port1Key>14-16</port1Key>
      <port1Name>BACK-14-16</port1Name>
      <port2Key>1/1/7/0/1</port2Key>
      <port2Name>OLT</port2Name>
      <secondaryStatus xmlID="i3">
      <id>1714F9599D9E4BBA88391048CBC864EF</id>
      <name>Working pair - dedicated</name>
      </secondaryStatus>
      <site1ObjectId>M0004</site1ObjectId>
      <site2ObjectId>Default Site</site2ObjectId>
      </ospConnection>
      <versionId>A3AD36B6ACB149A8A1B6E5EB335A43DA</versionId>
      </hops>
      <hops>
      <order>2</order>
      <ospConnection>
      <atbName>AKO2-003S-0040-2-COIL</atbName>
      <changedBy>System</changedBy>
      <changedDate>2025-09-25T12:25:28+04:00</changedDate>
      <ftp>0040</ftp>
      <node1Code>003S</node1Code>
      <node1Model>Optical_Splitter_1:32_8</node1Model>
      <node1Name>AKO2_003S_FD</node1Name>
      <node1ObjectId>AKO2_003S_FD</node1ObjectId>
      <node1Type>Optical_Splitter</node1Type>
      <node1TypeCategory>FDH</node1TypeCategory>
      <node2Code>0040</node2Code>
      <node2Model>PILLAR TYPE</node2Model>
      <node2Name>AKO2_003S_0040_AP</node2Name>
      <node2ObjectId>AKO2_003S_0040_AP</node2ObjectId>
      <node2Type>ODF</node2Type>
      <node2TypeCategory>AP</node2TypeCategory>
      <ospCnx xmlID="i11">
      <id>pair_6998701</id>
      <changedate>2025-09-25T12:25:28+04:00</changedate>
      <changedby>System</changedby>
      <insertBy>System</insertBy>
      <insertdate>2025-09-25T12:25:28+04:00</insertdate>
      <element1End>BACK</element1End>
      <element1Id>FCD2E5D2BA4E4B2E9B3ED9E82C637EF8-1/1/7/0/26</element1Id>
      <element1Type>NodeInterface</element1Type>
      <element2End>BACK</element2End>
      <element2Id>op_216799</element2Id>
      <element2Type>OdfPort</element2Type>
      <node2Id>Odf_2292</node2Id>
      <nodeId>FCD2E5D2BA4E4B2E9B3ED9E82C637EF8</nodeId>
      <versionId>A3AD36B6ACB149A8A1B6E5EB335A43DA</versionId>
      </ospCnx>
      <port1Key>1/1/7/0/26</port1Key>
      <port1Name>ONT25</port1Name>
      <port2Key>1-2</port2Key>
      <port2Name>AP-1-2</port2Name>
      <site1ObjectId>Default Site</site1ObjectId>
      <site2ObjectId>Default Site</site2ObjectId>
      </ospConnection>
      <versionId>A3AD36B6ACB149A8A1B6E5EB335A43DA</versionId>
      </hops>
      <serviceType>FiberCombo</serviceType>
      <trailLabel>GPON</trailLabel>
      <versionId>A3AD36B6ACB149A8A1B6E5EB335A43DA</versionId>
      </trails>
      </return>
      </ns2:checkNewActivationFiberFeasibilityResponse>
      </soap:Body>
      </soap:Envelope>

        Activity

        Hide
        Zein Trabelsi added a comment -

        Modify the findConnectionsByPorts (OspConnectionRepo) query to use UNION ALL instead of OR, improving performance from 2s to 0.01s.

        Show
        Zein Trabelsi added a comment - Modify the findConnectionsByPorts (OspConnectionRepo) query to use UNION ALL instead of OR, improving performance from 2s to 0.01s.

          People

          • Assignee:
            Mbaye Lo
            Reporter:
            Mbaye Lo
          • Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

            Dates

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

              Drag and Drop