Details
-
Type:
Bug
-
Status:
Ready for QA
(View Workflow)
-
Priority:
Urgent
-
Resolution: Unresolved
-
Affects Version/s: None
-
Fix Version/s: None
-
Component/s: FN
-
Labels:None Labels
-
Customer:OMAN-Tel
Description
reserveTrailsForSubscriber is having Performance issue 1.2s versus 2.2s
<ns3:reserveTrailsForSubscriber xmlns:ns3="http://server.api.nep.mobinets.com/">
<trails>
<exchange>AZA1</exchange>
<exchange2 />
<hops>
<order>0</order>
<ospConnection>
<bsw />
<bswPair />
<changedBy>System</changedBy>
<changedDate>2025-08-18T13:34:20+04:00</changedDate>
<info>24510463 24510669 24253130 24510258 24510865 24253800 24510362
24512186 24518477 24518625, , 24518231, 24518947, </info>
<mainStatus xmlID="i1">
<id>75F5EA9B20D94E6BB7E004B6981275F6</id>
<name>Working pair</name>
</mainStatus>
<node1Model>MA5600T</node1Model>
<node1Name>AZA1_01_MA5600T_OLT</node1Name>
<node1ObjectId>10.126.21.125</node1ObjectId>
<node1Type>MultiTechnologyAccess</node1Type>
<node1TypeCategory>OLT</node1TypeCategory>
<node2Code>AZA1_01_MA5600T_OLT</node2Code>
<node2Model>ODF</node2Model>
<node2Name>AZA1_01_MA5600T_OLT_ODF</node2Name>
<node2ObjectId>AZA1_01_MA5600T_OLT_ODF</node2ObjectId>
<node2Type>ODF</node2Type>
<node2TypeCategory>ODF</node2TypeCategory>
<ospConnection xmlID="iNM">
<id>pair_3589758</id>
<changedate>2025-08-18T13:34:20+04:00</changedate>
<changedby>System</changedby>
<insertBy>importer</insertBy>
<insertdate>2022-03-04T14:59:40+04:00</insertdate>
<netStatus>i1</netStatus>
<subNetStatus>i3</subNetStatus>
<element1End>Front</element1End>
<element1Id>A6FAD56E03C847A8830E7B19DEF78CEE-1/0/3/0/5</element1Id>
<element1Type>NodeInterface</element1Type>
<element2End>Front</element2End>
<element2Id>op_717905</element2Id>
<element2Type>OdfPort</element2Type>
<info>24510463 24510669 24253130 24510258 24510865 24253800 24510362
24512186 24518477 24518625, , 24518231, 24518947, </info>
<node2Id>Odf_24294</node2Id>
<nodeId>A6FAD56E03C847A8830E7B19DEF78CEE</nodeId>
<versionId>A3AD36B6ACB149A8A1B6E5EB335A43DA</versionId>
</ospConnection>
<port1Key>1/0/3/0/5</port1Key>
<port2Key>15-7</port2Key>
<secondaryStatus xmlID="i3">
<id>1714F9599D9E4BBA88391048CBC864EF</id>
<name>Working pair - dedicated</name>
</secondaryStatus>
<site1ObjectId>M0005</site1ObjectId>
<site2ObjectId>M0005</site2ObjectId>
</ospConnection>
<versionId>A3AD36B6ACB149A8A1B6E5EB335A43DA</versionId>
</hops>
<hops>
<order>1</order>
<ospConnection>
<bsw />
<bswPair />
<changedBy>System</changedBy>
<changedDate>2025-07-29T16:41:44+04:00</changedDate>
<info> 24510669 24253807 24510362 24512186 24341312 </info>
<mainStatus xmlID="i1">
<id>75F5EA9B20D94E6BB7E004B6981275F6</id>
<name>Working pair</name>
</mainStatus>
<node1Code>AZA1_01_MA5600T_OLT</node1Code>
<node1Model>ODF</node1Model>
<node1Name>AZA1_01_MA5600T_OLT_ODF</node1Name>
<node1ObjectId>AZA1_01_MA5600T_OLT_ODF</node1ObjectId>
<node1Type>ODF</node1Type>
<node1TypeCategory>ODF</node1TypeCategory>
<node2Code>064S</node2Code>
<node2Model>Optical_Splitter_1:32_8</node2Model>
<node2Name>AZA1_064S_FD</node2Name>
<node2ObjectId>AZA1_064S_FD</node2ObjectId>
<node2Type>Optical_Splitter</node2Type>
<node2TypeCategory>FDH</node2TypeCategory>
<ospConnection xmlID="iOM">
<id>pair_3684653</id>
<changedate>2025-07-29T16:41:44+04:00</changedate>
<changedby>System</changedby>
<insertBy>System</insertBy>
<insertdate>2022-03-13T09:56:41+04:00</insertdate>
<netStatus>i1</netStatus>
<subNetStatus>i3</subNetStatus>
<element1End>BACK</element1End>
<element1Id>op_643773</element1Id>
<element1Type>OdfPort</element1Type>
<element2End>BACK</element2End>
<element2Id>C5983082E7E94E7BA27B8723E56A40BE-1/1/1/0/1</element2Id>
<element2Type>NodeInterface</element2Type>
<info> 24510669 24253807 24510362 24512186 24341312 </info>
<node2Id>C5983082E7E94E7BA27B8723E56A40BE</node2Id>
<nodeId>Odf_24294</nodeId>
<versionId>A3AD36B6ACB149A8A1B6E5EB335A43DA</versionId>
</ospConnection>
<port1Key>13-11</port1Key>
<port2Key>1/1/1/0/1</port2Key>
<secondaryStatus xmlID="i3">
<id>1714F9599D9E4BBA88391048CBC864EF</id>
<name>Working pair - dedicated</name>
</secondaryStatus>
<site1ObjectId>M0005</site1ObjectId>
<site2ObjectId>Dummy Site</site2ObjectId>
</ospConnection>
<versionId>A3AD36B6ACB149A8A1B6E5EB335A43DA</versionId>
</hops>
<hops>
<order>2</order>
<ospConnection>
<atbName>AZA1-064S-0003-17-COIL</atbName>
<bsw />
<bswPair />
<changedBy>System</changedBy>
<changedDate>2025-07-26T17:21:32+04:00</changedDate>
<ftp>0003</ftp>
<mainStatus xmlID="iK">
<id>6345B88251724EFF9BF4D145AB0FD686</id>
<name>Spare pair</name>
</mainStatus>
<node1Code>064S</node1Code>
<node1Model>Optical_Splitter_1:32_8</node1Model>
<node1Name>AZA1_064S_FD</node1Name>
<node1ObjectId>AZA1_064S_FD</node1ObjectId>
<node1Type>Optical_Splitter</node1Type>
<node1TypeCategory>FDH</node1TypeCategory>
<node2Code>0003</node2Code>
<node2Model>INTERNAL TYPE</node2Model>
<node2Name>AZA1_064S_0003_AP</node2Name>
<node2ObjectId>AZA1_064S_0003_AP</node2ObjectId>
<node2Type>ODF</node2Type>
<node2TypeCategory>AP</node2TypeCategory>
<ospConnection xmlID="iPM">
<id>pair_3637209</id>
<changedate>2025-07-26T17:21:32+04:00</changedate>
<changedby>System</changedby>
<insertBy>importer</insertBy>
<insertdate>2022-03-11T15:26:54+04:00</insertdate>
<netStatus>iK</netStatus>
<subNetStatus>iM</subNetStatus>
<element1End>BACK</element1End>
<element1Id>C5983082E7E94E7BA27B8723E56A40BE-1/1/1/0/12</element1Id>
<element1Type>NodeInterface</element1Type>
<element2End>BACK</element2End>
<element2Id>op_22618</element2Id>
<element2Type>OdfPort</element2Type>
<node2Id>Odf_1120</node2Id>
<nodeId>C5983082E7E94E7BA27B8723E56A40BE</nodeId>
<versionId>A3AD36B6ACB149A8A1B6E5EB335A43DA</versionId>
</ospConnection>
<port1Key>1/1/1/0/12</port1Key>
<port2Key>1-17</port2Key>
<secondaryStatus xmlID="iM">
<id>30E6169FE6BD47D587063658FEDD4839</id>
<name>Free</name>
</secondaryStatus>
<site1ObjectId>Dummy Site</site1ObjectId>
<site2ObjectId>Default Site</site2ObjectId>
</ospConnection>
<versionId>A3AD36B6ACB149A8A1B6E5EB335A43DA</versionId>
</hops>
<serviceType>FiberCombo</serviceType>
<tid>A0/3/5</tid>
<trailLabel>GPON</trailLabel>
<versionId>A3AD36B6ACB149A8A1B6E5EB335A43DA</versionId>
</trails>
<subscriberNo>24510490</subscriberNo>
<woNo>I1542540818</woNo>
<override>true</override>
</ns3:reserveTrailsForSubscriber>
Activity
- All
- Comments
- Work Log
- History
- Activity
- Links Hierarchy
- Transitions
- Trace
using query dsl method eq instead equalsIgnoreCase when fetching subscriber by subscriber_number which change query from where lower(subscriber0_.SUBSCRIBER_NUMBER)= to where subscriber0_.SUBSCRIBER_NUMBER= .
Result: query time reduced from 0.3s to 0.002s.