UCMDB and UD Practitioners Forum (Previously CMS)
cancel

I/o Exception : COnnection reset error while trying to connect to MS SQL 2005 server

Highlighted
Milap
Respected Contributor.

I/o Exception : COnnection reset error while trying to connect to MS SQL 2005 server

Hi Experts,

 

Details: I/O Error: Software caused connection abort: receive failed

 

Getting above error while trying MS SQL connection by SQL job to connect MS SQL 2005 servers.Through some JTDS communities , found that it is an issue with SSL enforces tried to change SSL=OFF in connection string in Probe properties but it is not reflecting while discovering communication log it still shows the old community string.How to change the connection string.

 

Any other approach to resolve this?Find the communication log.

 

---------------------------------------------------------------------------------------------------

 

<execution jobId="MSSQL Server Connection by SQL" destinationid="c29168c5018476e0d555fc922d31bb80" max_store_sent_results="2147483647">
<destination>
<destinationData name="id">c29168c5018476e0d555fc922d31bb80</destinationData>
<destinationData name="application_ip">10.182.51.188</destinationData>
<destinationData name="sid">W8LAALDB01SQLB</destinationData>
<destinationData name="ip_address">10.182.51.188</destinationData>
<destinationData name="sa_port">1433</destinationData>
<destinationData name="application_port">1433</destinationData>
<destinationData name="sa_ip">10.182.51.188</destinationData>
</destination>
<protocol name="sql" cm_credential_id="58_1_CMS">
<object id="c3919557a74fefa75fe7d9a524993ce5" id_type="CmdbObjectID" class="sqlprotocol" isReference="false" is_anchor="false">
<attribute name="protocol_in_use" type="Boolean">false</attribute>
<attribute name="protocol_username" type="String">tcs_read</attribute>
<attribute name="protocol_netaddress" type="String">DEFAULT</attribute>
<attribute name="sqlprotocol_encryption_method" type="String">None</attribute>
<attribute name="protocol_port" type="String">1433</attribute>
<attribute name="sqlprotocol_dbsid" type="Unknown" />
<attribute name="sqlprotocol_truststore" type="Unknown" />
<attribute name="protocol_timeout" type="String">100000</attribute>
<attribute name="user_label" type="String">Generic DB Protocol (SQL) Credential 1</attribute>
<attribute name="cm_credential_id" type="String">58_1_CMS</attribute>
<attribute name="protocol_index" type="Integer">1</attribute>
<attribute name="protocol_type" type="String">sqlprotocol</attribute>
<attribute name="sqlprotocol_dbtype" type="String">MicrosoftSQLServer</attribute>
<attribute name="sqlprotocol_dbname" type="Unknown" />
</object>
</protocol>
<params>
<param param_name="maxThreadRuntime" param_value="900000" />
<param param_name="protocolType" param_value="MicrosoftSQLServer" />
<param param_name="JOB_ID" param_value="MSSQL Server Connection by SQL" />
</params>
<log start="15:55:54" severity="debug">Collecting data to connect with protocol 58_1_CMS</log>
<log start="15:55:54" severity="debug">Collecting data to connect with protocol 171_1_CMS</log>
<log start="15:55:54" severity="warn">No suitable IP address found for protocol range 10.131.195.118-10.131.195.118</log>
<log start="15:55:54" severity="debug">Collecting data to connect with protocol 182_1_CMS</log>
<log start="15:55:54" severity="warn">No suitable IP address found for protocol range 10.131.195.117-10.131.195.117</log>
<log start="15:55:54" severity="debug">Collecting data to connect with protocol 187_1_CMS</log>
<log start="15:55:54" severity="warn">No suitable IP address found for protocol range 10.131.195.119-10.131.195.119</log>
<log start="15:55:54" severity="debug">Collecting data to connect with protocol 198_1_CMS</log>
<log start="15:55:54" severity="warn">No suitable IP address found for protocol range 10.131.195.120-10.131.195.120</log>
<log start="15:55:54" severity="debug">Collecting data to connect with protocol 211_1_CMS</log>
<log start="15:55:54" severity="warn">No suitable IP address found for protocol range 10.131.195.121-10.131.195.121</log>
<log start="15:55:54" severity="debug">Collecting data to connect with protocol 226_1_CMS</log>
<log start="15:55:54" severity="warn">No suitable IP address found for protocol range 10.131.195.122-10.131.195.122</log>
<log start="15:55:54" severity="debug">Collecting data to connect with protocol 235_1_CMS</log>
<log start="15:55:54" severity="warn">No suitable IP address found for protocol range 10.145.9.101-10.145.9.101</log>
<log start="15:55:54" severity="debug">Collecting data to connect with protocol 245_1_CMS</log>
<log start="15:55:54" severity="warn">No suitable IP address found for protocol range 10.145.9.52-10.145.9.52</log>
<log start="15:55:54" severity="debug">Collecting data to connect with protocol 256_1_CMS</log>
<log start="15:55:54" severity="warn">No suitable IP address found for protocol range 10.145.9.102-10.145.9.102</log>
<log start="15:55:54" severity="debug">Collecting data to connect with protocol 268_1_CMS</log>
<log start="15:55:54" severity="warn">No suitable IP address found for protocol range 10.145.9.45-10.145.9.45</log>
<log start="15:55:54" severity="debug">Collecting data to connect with protocol 355_1_CMS</log>
<log start="15:55:54" severity="warn">No suitable IP address found for protocol range 10.131.189.124-10.131.189.124</log>
<log start="15:55:54" severity="debug">Collecting data to connect with protocol 1142_1_CMS</log>
<log start="15:55:54" severity="warn">No suitable IP address found for protocol range 10.131.189.26-10.131.189.26,10.145.9.46-10.145.9.46</log>
<log start="15:55:54" severity="debug">Collecting data to connect with protocol 1157_1_CMS</log>
<log start="15:55:54" severity="warn">No suitable IP address found for protocol range 10.131.189.34-10.131.189.34</log>
<log start="15:55:54" severity="debug">Collecting data to connect with protocol 1173_1_CMS</log>
<log start="15:55:54" severity="warn">No suitable IP address found for protocol range 10.131.189.33-10.131.189.33</log>
<log start="15:55:54" severity="debug">Collecting data to connect with protocol 1190_1_CMS</log>
<log start="15:55:54" severity="warn">No suitable IP address found for protocol range 10.131.189.32-10.131.189.32</log>
<log start="15:55:54" severity="debug">Collecting data to connect with protocol 1225_1_CMS</log>
<log start="15:55:54" severity="warn">No suitable IP address found for protocol range 10.145.9.103-10.145.9.103</log>
<log start="15:55:54" severity="debug">Connecting by protocol 1225_1_CMS</log>
<log start="15:55:54" severity="debug">Connecting to 10.182.51.188:1433@None</log>
<CONNECT start="15:55:54" duration="16" CMD="client_connect" RESULT="" IS_NULL="Y" type="sql" credentialsId="58_1_CMS">
<ERROR class="java.sql.SQLException">
<message>[CDATA&colon; I/O Error: Connection reset]</message>
<stacktrace>
<frame class="net.sourceforge.jtds.jdbc.TdsCore" method="executeSQL" file="TdsCore.java" line="1053" />
<frame class="net.sourceforge.jtds.jdbc.JtdsStatement" method="executeSQLQuery" file="JtdsStatement.java" line="465" />
<frame class="net.sourceforge.jtds.jdbc.JtdsStatement" method="executeQuery" file="JtdsStatement.java" line="1311" />
<frame class="net.sourceforge.jtds.jdbc.ConnectionJDBC2" method="&lt;init&gt;" file="ConnectionJDBC2.java" line="397" />
<frame class="net.sourceforge.jtds.jdbc.ConnectionJDBC3" method="&lt;init&gt;" file="ConnectionJDBC3.java" line="50" />
<frame class="net.sourceforge.jtds.jdbc.Driver" method="connect" file="Driver.java" line="185" />
<frame class="com.hp.ucmdb.discovery.library.clients.protocols.sql.SqlUtil$ConnectionThread" method="run" file="SqlUtil.java" line="140" />
</stacktrace>
<causeby class="java.net.SocketException">
<message>[CDATA&colon; Connection reset]</message>
<stacktrace>
<frame class="java.net.SocketInputStream" method="read" file="SocketInputStream.java" line="189" />
<frame class="java.net.SocketInputStream" method="read" file="SocketInputStream.java" line="121" />
<frame class="net.sourceforge.jtds.ssl.TdsTlsInputStream" method="read" file="TdsTlsInputStream.java" line="72" />
<frame class="sun.security.ssl.InputRecord" method="readFully" file="InputRecord.java" line="312" />
<frame class="sun.security.ssl.InputRecord" method="read" file="InputRecord.java" line="350" />
<frame class="sun.security.ssl.SSLSocketImpl" method="readRecord" file="SSLSocketImpl.java" line="893" />
<frame class="sun.security.ssl.SSLSocketImpl" method="readDataRecord" file="SSLSocketImpl.java" line="850" />
<frame class="sun.security.ssl.AppInputStream" method="read" file="AppInputStream.java" line="102" />
<frame class="java.io.DataInputStream" method="readFully" file="DataInputStream.java" line="195" />
<frame class="java.io.DataInputStream" method="readFully" file="DataInputStream.java" line="169" />
<frame class="net.sourceforge.jtds.jdbc.SharedSocket" method="readPacket" file="SharedSocket.java" line="851" />
<frame class="net.sourceforge.jtds.jdbc.SharedSocket" method="getNetPacket" file="SharedSocket.java" line="732" />
<frame class="net.sourceforge.jtds.jdbc.ResponseStream" method="getPacket" file="ResponseStream.java" line="466" />
<frame class="net.sourceforge.jtds.jdbc.ResponseStream" method="read" file="ResponseStream.java" line="103" />
<frame class="net.sourceforge.jtds.jdbc.ResponseStream" method="peek" file="ResponseStream.java" line="88" />
<frame class="net.sourceforge.jtds.jdbc.TdsCore" method="wait" file="TdsCore.java" line="3932" />
<frame class="net.sourceforge.jtds.jdbc.TdsCore" method="executeSQL" file="TdsCore.java" line="1046" />
<frame class="net.sourceforge.jtds.jdbc.JtdsStatement" method="executeSQLQuery" file="JtdsStatement.java" line="465" />
<frame class="net.sourceforge.jtds.jdbc.JtdsStatement" method="executeQuery" file="JtdsStatement.java" line="1311" />
<frame class="net.sourceforge.jtds.jdbc.ConnectionJDBC2" method="&lt;init&gt;" file="ConnectionJDBC2.java" line="397" />
<frame class="net.sourceforge.jtds.jdbc.ConnectionJDBC3" method="&lt;init&gt;" file="ConnectionJDBC3.java" line="50" />
<frame class="net.sourceforge.jtds.jdbc.Driver" method="connect" file="Driver.java" line="185" />
<frame class="com.hp.ucmdb.discovery.library.clients.protocols.sql.SqlUtil$ConnectionThread" method="run" file="SqlUtil.java" line="140" />
</stacktrace>
</causeby>
</ERROR>
<ClientProperties>
<prop name="protocol_index" value="1" />
<prop name="protocol_timeout" value="100" />
<prop name="credentialsId" value="58_1_CMS" />
<prop name="sqlprotocol_dbname" value="" />
<prop name="sqlprotocol_dbsid" value="W8LAALDB01SQLB" />
<prop name="cm_credential_id" value="58_1_CMS" />
<prop name="sqlprotocol_dbtype" value="MicrosoftSQLServer" />
<prop name="preurl" value="jdbc:jtds:sqlserver://%%ipaddress%%:%%protocol_port%%;instanceName=%%sqlprotocol_dbname%%;loginTimeout=%%protocol_timeout%%;logging=false;ssl=request" />
<prop name="protocol_type" value="sqlprotocol" />
<prop name="driver" value="net.sourceforge.jtds.jdbc.Driver" />
<prop name="protocol_netaddress" value="DEFAULT" />
<prop name="ip_address" value="10.182.51.188" />
<prop name="protocol_port" value="1433" />
<prop name="sqlprotocol_encryption_method" value="None" />
<prop name="user_label" value="Generic DB Protocol (SQL) Credential 1" />
<prop name="protocol_username" value="tcs_read" />
<prop name="sqlprotocol_truststore" value="" />
<prop name="protocol_in_use" value="false" />
</ClientProperties>
</CONNECT>
<log start="15:55:54" severity="debug">I/O Error: Connection reset</log>
<log start="15:55:54" severity="debug">
Traceback (most recent call last):
File "SQL_Connection", line 206, in connectByProtocol
SQLException: java.sql.SQLException: I/O Error: Connection reset
</log>
<log start="15:55:54" severity="debug">Connecting to 10.182.51.188:1433@W8LAALDB01SQLB</log>
<CONNECT start="15:55:54" duration="31" CMD="client_connect" RESULT="" IS_NULL="Y" type="sql" credentialsId="58_1_CMS">
<ERROR class="java.sql.SQLException">
<message>[CDATA&colon; I/O Error: Connection reset]</message>
<stacktrace>
<frame class="net.sourceforge.jtds.jdbc.TdsCore" method="executeSQL" file="TdsCore.java" line="1053" />
<frame class="net.sourceforge.jtds.jdbc.JtdsStatement" method="executeSQLQuery" file="JtdsStatement.java" line="465" />
<frame class="net.sourceforge.jtds.jdbc.JtdsStatement" method="executeQuery" file="JtdsStatement.java" line="1311" />
<frame class="net.sourceforge.jtds.jdbc.ConnectionJDBC2" method="&lt;init&gt;" file="ConnectionJDBC2.java" line="397" />
<frame class="net.sourceforge.jtds.jdbc.ConnectionJDBC3" method="&lt;init&gt;" file="ConnectionJDBC3.java" line="50" />
<frame class="net.sourceforge.jtds.jdbc.Driver" method="connect" file="Driver.java" line="185" />
<frame class="com.hp.ucmdb.discovery.library.clients.protocols.sql.SqlUtil$ConnectionThread" method="run" file="SqlUtil.java" line="140" />
</stacktrace>
<causeby class="java.net.SocketException">
<message>[CDATA&colon; Connection reset]</message>
<stacktrace>
<frame class="java.net.SocketInputStream" method="read" file="SocketInputStream.java" line="189" />
<frame class="java.net.SocketInputStream" method="read" file="SocketInputStream.java" line="121" />
<frame class="net.sourceforge.jtds.ssl.TdsTlsInputStream" method="read" file="TdsTlsInputStream.java" line="72" />
<frame class="sun.security.ssl.InputRecord" method="readFully" file="InputRecord.java" line="312" />
<frame class="sun.security.ssl.InputRecord" method="read" file="InputRecord.java" line="350" />
<frame class="sun.security.ssl.SSLSocketImpl" method="readRecord" file="SSLSocketImpl.java" line="893" />
<frame class="sun.security.ssl.SSLSocketImpl" method="readDataRecord" file="SSLSocketImpl.java" line="850" />
<frame class="sun.security.ssl.AppInputStream" method="read" file="AppInputStream.java" line="102" />
<frame class="java.io.DataInputStream" method="readFully" file="DataInputStream.java" line="195" />
<frame class="java.io.DataInputStream" method="readFully" file="DataInputStream.java" line="169" />
<frame class="net.sourceforge.jtds.jdbc.SharedSocket" method="readPacket" file="SharedSocket.java" line="851" />
<frame class="net.sourceforge.jtds.jdbc.SharedSocket" method="getNetPacket" file="SharedSocket.java" line="732" />
<frame class="net.sourceforge.jtds.jdbc.ResponseStream" method="getPacket" file="ResponseStream.java" line="466" />
<frame class="net.sourceforge.jtds.jdbc.ResponseStream" method="read" file="ResponseStream.java" line="103" />
<frame class="net.sourceforge.jtds.jdbc.ResponseStream" method="peek" file="ResponseStream.java" line="88" />
<frame class="net.sourceforge.jtds.jdbc.TdsCore" method="wait" file="TdsCore.java" line="3932" />
<frame class="net.sourceforge.jtds.jdbc.TdsCore" method="executeSQL" file="TdsCore.java" line="1046" />
<frame class="net.sourceforge.jtds.jdbc.JtdsStatement" method="executeSQLQuery" file="JtdsStatement.java" line="465" />
<frame class="net.sourceforge.jtds.jdbc.JtdsStatement" method="executeQuery" file="JtdsStatement.java" line="1311" />
<frame class="net.sourceforge.jtds.jdbc.ConnectionJDBC2" method="&lt;init&gt;" file="ConnectionJDBC2.java" line="397" />
<frame class="net.sourceforge.jtds.jdbc.ConnectionJDBC3" method="&lt;init&gt;" file="ConnectionJDBC3.java" line="50" />
<frame class="net.sourceforge.jtds.jdbc.Driver" method="connect" file="Driver.java" line="185" />
<frame class="com.hp.ucmdb.discovery.library.clients.protocols.sql.SqlUtil$ConnectionThread" method="run" file="SqlUtil.java" line="140" />
</stacktrace>
</causeby>
</ERROR>
<ClientProperties>
<prop name="protocol_index" value="1" />
<prop name="protocol_timeout" value="100" />
<prop name="credentialsId" value="58_1_CMS" />
<prop name="sqlprotocol_dbname" value="W8LAALDB01SQLB" />
<prop name="sqlprotocol_dbsid" value="W8LAALDB01SQLB" />
<prop name="cm_credential_id" value="58_1_CMS" />
<prop name="sqlprotocol_dbtype" value="MicrosoftSQLServer" />
<prop name="preurl" value="jdbc:jtds:sqlserver://%%ipaddress%%:%%protocol_port%%;instanceName=%%sqlprotocol_dbname%%;loginTimeout=%%protocol_timeout%%;logging=false;ssl=request" />
<prop name="protocol_type" value="sqlprotocol" />
<prop name="driver" value="net.sourceforge.jtds.jdbc.Driver" />
<prop name="protocol_netaddress" value="DEFAULT" />
<prop name="ip_address" value="10.182.51.188" />
<prop name="protocol_port" value="1433" />
<prop name="sqlprotocol_encryption_method" value="None" />
<prop name="user_label" value="Generic DB Protocol (SQL) Credential 1" />
<prop name="protocol_username" value="tcs_read" />
<prop name="sqlprotocol_truststore" value="" />
<prop name="protocol_in_use" value="false" />
</ClientProperties>
</CONNECT>
<log start="15:55:54" severity="debug">I/O Error: Connection reset</log>
<log start="15:55:54" severity="debug">
Traceback (most recent call last):
File "SQL_Connection", line 206, in connectByProtocol
SQLException: java.sql.SQLException: I/O Error: Connection reset
</log>
<log start="15:55:54" severity="debug">SQL: Connection refused. Details: I/O Error: Connection reset</log>
<log start="15:55:54" severity="error">Failed to connect using all protocols</log>
<log start="15:55:54" severity="debug">Reporting error code 205 to framework.</log>
<log start="15:55:54" severity="debug">Error message is: SQL: Connection refused. Details: I/O Error: Connection reset</log>
</execution>

 

Warm regards,

Milap

 

 

 

 

 

6 REPLIES
Dima Gomel
Acclaimed Contributor.

Re: I/o Exception : COnnection reset error while trying to connect to MS SQL 2005 server

Please be aware that providing of UCMDB version with CUPs and Content Pack is essential for any discovery jobs.

To troubleshoot this, I'd suggest you trying to connect with some MS SQL client from the probe machine.

Another option is to ask your DBA to check error message on the DB side...

 

Regards
-Dmitry Gomel, PMP
If you find that this or any post resolves your issue, please be sure to mark it as an accepted solution.
Click the Like button at the bottom to say 'Thanks'.
Milap
Respected Contributor.

Re: I/o Exception : COnnection reset error while trying to connect to MS SQL 2005 server

Hi Dima,

 

Thanks for the prompt response.I found that disabling SSL property should resolve the issue.

 

appilog.database.sqlServer.preurl=jdbc:jtds:sqlserver://%%ipaddress%%:%%protocol_port%%/%%sqlprotocol_dbname%%;loginTimeout=%%protocol_timeout%%;logging=false;ssl=off

 

I changed this in Probe properties but it is not reflecting.Can you let me know what I need to change for requesting without SSL.

 

Version : 10.01 (12.09.1028)

 

Refer : 

 

http://bugs.java.com/bugdatabase/view_bug.do?bug_id=7105007

https://access.redhat.com/site/solutions/66829

 

Warm regards,

Milap

Dima Gomel
Acclaimed Contributor.

Re: I/o Exception : COnnection reset error while trying to connect to MS SQL 2005 server

Please be aware that bug you found isn't relevant since 10.01 using java version 1.7.0_05.

Please note that SSL won't work without import of certificates. It should be either in probe key store or in java key store. I don't want to bother you with how-to since if HTTP is awailable all you need to do is disable it in credentials configuration dialog (see attached).

 

 

 

Regards
-Dmitry Gomel, PMP
If you find that this or any post resolves your issue, please be sure to mark it as an accepted solution.
Click the Like button at the bottom to say 'Thanks'.
Milap
Respected Contributor.

Re: I/o Exception : COnnection reset error while trying to connect to MS SQL 2005 server

Hi Dima,

 

I am getting issue for MS SQL not for Oracle.the screen shot is for Oracle not SQL.MS SQL doen't give this option in credentials configurations.

 

Already raised a case with hp but dint get much info.I would appreciate if you tell me why the property changes which I did in probe is not reflecting.

 

Warm regards,

Milap

Dima Gomel
Acclaimed Contributor.

Re: I/o Exception : COnnection reset error while trying to connect to MS SQL 2005 server

Press right click on the credentials and choose "Edit using previous interface".

New screenshot is attched...

 

Regards
-Dmitry Gomel, PMP
If you find that this or any post resolves your issue, please be sure to mark it as an accepted solution.
Click the Like button at the bottom to say 'Thanks'.
Dima Gomel
Acclaimed Contributor.

Re: I/o Exception : COnnection reset error while trying to connect to MS SQL 2005 server

I'd also recommend to check chpter 25 of attached document.

Regards
-Dmitry Gomel, PMP
If you find that this or any post resolves your issue, please be sure to mark it as an accepted solution.
Click the Like button at the bottom to say 'Thanks'.