Clarity PPM

Expand all | Collapse all

Connection reset error in 15.3

  • 1.  Connection reset error in 15.3

    Posted 02-28-2018 03:38 AM

    Hi All,

     

    We have recently upgraded to 15.3 patch 1 version in quality environment. There is a Java Interface which uses soap call to retrieve time sheet records.

     

    After upgrade, we are continuously receiving connection reset error for execution of 10 minutes by the interface when it runs the query in PPM.

     ****************Interface Execution Started*********************

    07:24:03,293 INFO  com.philips.javainterface.common.logger.MyActualHoursLogger  - [ActualHoursCommunicatorClient] Process Mode CLARITY

    07:24:03,293 INFO  com.philips.javainterface.common.logger.MyActualHoursLogger  - [ActualHoursCommunicatorClient] processOldClarity():: Checking Clarity Failure folder for processing previous failed records

    07:24:03,298 INFO  com.philips.javainterface.common.logger.MyActualHoursLogger  - [ActualHoursCommunicatorClient] processfromClarity():: Processing of the data from Clarity started

    07:24:06,313 INFO  com.philips.javainterface.common.utils.SOAPUtilities  - [SOAPUtilities] buildExtractSOAPMsg():: Building SOAP Message for retrieving the data from Clarity

    07:24:06,318 INFO  com.philips.javainterface.common.utils.SOAPUtilities  - [SOAPUtilities] :queryData():: SOAP Message for retreiving the data :

    <SOAP-ENV:Envelope xmlns:SOAP-ENV="http://schemas.xmlsoap.org/soap/envelope/" xmlns:xog="http://www.niku.com/xog"><SOAP-ENV:Header><Auth xmlns="http://www.niku.com/xog"><SessionID>26206040__5E557DDB-15B3-48E8-8B8C-F391CE6BAFC2</SessionID></Auth></SOAP-ENV:Header><SOAP-ENV:Body><Query xmlns="http://www.niku.com/xog/Query"><Code>z_actual_hours_interface</Code><Sort><Column><Name>companycode</Name><Direction>desc</Direction></Column></Sort></Query></SOAP-ENV:Body></SOAP-ENV:Envelope>

     

    07:34:09,902 ERROR com.philips.javainterface.common.utils.SOAPUtilities  - [SOAPUtilities] :getClarityResponse() :: Failed to get Clarity response due to ioException :

    java.net.SocketException: Connection reset

            at java.net.SocketInputStream.read(SocketInputStream.java:189)

            at java.net.SocketInputStream.read(SocketInputStream.java:121)

            at sun.security.ssl.InputRecord.readFully(InputRecord.java:442)

            at sun.security.ssl.InputRecord.read(InputRecord.java:480)

           

    Kindly, let us know is there any timer introduced in 15.3.

     

    Thanks,

    Pragya Singh



  • 2.  Re: Connection reset error in 15.3

    Posted 02-28-2018 06:07 AM

    Hi

     

    Did you try to use standard XOG to export and import data form to CA PPM to test it? You can use 3rd party tool like   SOAP IU then? If you are using SSL be careful TLS v1 has been removed in 15.3.

     

    Other think is, that the class "com.philips.javainterface.common.utils.SOAPUtilities" is costume and not provided OOTB, so there should be an issue in your source code too.

     

    Regards

     

    Milos



  • 3.  Re: Connection reset error in 15.3

    Posted 03-01-2018 01:58 AM

    Hi Milos,

     

    Our Interfaces supports TLS 1.2.  The code is completing fine processing all timesheets when amount of records is less and total execution time is less than 10 minutes.

     

    The interface is terminating exactly at 10th minutes irrespective of its processing status.

     

    I am checking with network and server teams whether any timeout is introduced recently.

     

    Thanks,

    Pragya Singh



  • 4.  Re: Connection reset error in 15.3

    Posted 02-28-2018 09:48 PM

    Pragya,

    Hope this outbound interface updating your destination system, which is completing within 10 min.

     

    If that is the case, could you please check, is there any network timeout of 10 minutes is introduced recently?

     

    Best Regards,

    Agin