Unable to retrieve records in SM using SOAP Request

Hello Experts,

I am getting below response as error in the logs for retrieving records using SOAP UI. 

4008( 15224) 05/20/2024 15:40:34 JRTE E sendResponse() RetrieveList failed - java.io.IOException: An established connection was aborted by the software in your host machine
4008( 15224) 05/20/2024 15:40:34 JRTE E sendResponse()
org.apache.catalina.connector.ClientAbortException: java.io.IOException: An established connection was aborted by the software in your host machine

This is not occurring always, but it seems to be occurring 5 times out of 10 tries. 

Can anyone guide on this to resolve. 

  • 0  

    Hi Ahmed

    The error means the connection from client to SM server closed.

    Would you please to check how long that request takes from client sending it out till error occurs?

    Thanks

  • 0 in reply to   

    Hi Simon,

    The Error occurns randomely, mostly it appears when we use Pagination - in which even 2 nos of records are not being displayed. 

  • 0   in reply to 

    Hi Ahmed

    Thanks for your update.

    It is better to get the whole log file during the issue reproduced.

    In the pasted log, it is hard to identify the cause.

    Thanks

  • 0 in reply to   

    sm_log_ictupdTimeResponse_20MAY.txt

    Hi Simon,

    Please find the attached logs. Let me know if anything further is required.

  • 0   in reply to 

    Hi Ahmed

    In the log file, there is no data from beginning of tread: 1788:

    4008( 1788) 05/20/2024 15:41:37 JRTE I Creating new worker thread F8E911380D752BDB6898643383AE6CED t@53
    4008( 1788) 05/20/2024 15:41:37 JRTE I Webservice API session - Thread ID: F8E911380D752BDB6898643383AE6CED; Client IP: 10.19.249.31; session timeout: 1800 seconds
    4008( 1788) 05/20/2024 15:42:53 JRTE E sendResponse() failed!
    4008( 1788) 05/20/2024 15:42:53 JRTE E sendResponse() failed!
    4008( 1788) 05/20/2024 15:42:53 JRTE E sendResponse() RetrieveList failed - java.io.IOException: An established connection was aborted by the software in your host machine
    4008( 1788) 05/20/2024 15:42:53 JRTE E sendResponse()
    4008( 1788) 05/20/2024 15:42:53 JRTE W Send error response: java.io.IOException: An established connection was aborted by the software in your host machine
    4008( 1788) 05/20/2024 15:42:53 JRTE E sendSoapFaultResponse() failed - java.io.IOException: An established connection was aborted by the software in your host machine
    4008( 1788) 05/20/2024 15:42:53 JRTE E sendResponse() RetrieveList failed - java.io.IOException: An established connection was aborted by the software in your host machine

    From the information we have in log file, the issue was caused by: the connection was closed from API client so SM was unable to send response to it.

    Are we using the same session to do multiple queries?

    Thanks

  • 0 in reply to   

    Hi Simon,

    No I did not terminate the session, the session terminates by itself. To me it looks like a memory issue may be due to huge amount of records or cache is not built, but I am not sure. I have raised a support case, waiting for an update. Will update you if we are able to fix it. 

    Thanks

    WA