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:
-
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
- All
- Comments
- Work Log
- History
- Activity
- Links Hierarchy
- Transitions
- Trace
Modify the findConnectionsByPorts (OspConnectionRepo) query to use UNION ALL instead of OR, improving performance from 2s to 0.01s.