[ACE-578] API changeSubscriberNo has Performance Issue when the Subscriber has a trail Created: 16/Feb/26  Updated: 17/Feb/26  Due: 16/Feb/26

Status: Ready for QA
Project: ACE
Component/s: FN
Affects Version/s: None
Fix Version/s: None

Type: Bug Priority: Normal
Reporter: Mbaye Lo Assignee: Mbaye Lo
Resolution: Unresolved Votes: 0
Labels: Milestone2
Remaining Estimate: Not Specified
Time Spent: Not Specified
Original Estimate: Not Specified

Customer:
OMAN-Tel
Planned Start:
Planned End:

 Description   

The subscriber we tested during the UAT session didn't have trail (24282815) and we had the following Time Excution on OLD and NAW :

changeSubscriberNo 0,92s 1,62s

But with subscriber with Trail (24220910), we are getting the following :

<soapenv:Envelope xmlns:soapenv="http://schemas.xmlsoap.org/soap/envelope/" xmlns:ser="http://server.api.nep.mobinets.com/">
<soapenv:Header/>
<soapenv:Body>
<ser:changeSubscriberNo>
<!-Optional:->
<oldSubscriberNo>24220910</oldSubscriberNo>
<!-Optional:->
<newSubscriberNo>24282819</newSubscriberNo>
</ser:changeSubscriberNo>
</soapenv:Body>
</soapenv:Envelope>

OLD: 0.95s
<soap:Envelope xmlns:soap="http://schemas.xmlsoap.org/soap/envelope/">
<soap:Body>
<ns2:changeSubscriberNoResponse xmlns:ns2="http://server.api.nep.mobinets.com/">
<return>
<responseCode>0</responseCode>
<responseMessage>SUCCESS</responseMessage>
</return>
</ns2:changeSubscriberNoResponse>
</soap:Body>
</soap:Envelope>

NEW : Few minutes before the following error on New
<soap:Envelope xmlns:soap="http://schemas.xmlsoap.org/soap/envelope/">
<soap:Body>
<ns2:changeSubscriberNoResponse xmlns:ns2="http://server.api.nep.mobinets.com/">
<return>
<responseCode>1</responseCode>
<responseMessage>general.exception.error.updatingError while deleting trail GPON For subscriber : 24220910 :Error unmarshaling return; nested exception is:
java.io.InvalidClassException: org.springframework.web.client.HttpServerErrorException$InternalServerError; local class incompatible: stream classdesc serialVersionUID = -3578438846357869624, local class serialVersionUID = -3839068165753821818</responseMessage>
</return>
</ns2:changeSubscriberNoResponse>
</soap:Body>
</soap:Envelope>



 Comments   
Comment by Zein Trabelsi [ 17/Feb/26 ]

instead of fetching service trails directly using hibernate (performance issue hops has relations with the ospconnection view) , fetch them using QueryDsl in Dtos

Generated at Wed Apr 15 14:50:15 EEST 2026 using JIRA 6.1.4#6159-sha1:44eaedef2e4a625c6c7183698b2468d4719c20dc.