Troubleshooting
Problem
Receiving error: An exception occurred while processing a SingleTableNotification job. Data error at row number 0 of table dbo.ADP_PSS_REPORTS_STAGING. Error while closing the transaction..[CastIron Systems][SQLServer JDBC Driver]Object has been closed while performing a database update. The connection to the endpoint was closed unexpectedly and seen 'broken pipe' errors in the log.
Symptom
The connection to the endpoint was closed unexpectedly. Receiving error: Error while closing the transaction.[CastIron Systems][SQLServer JDBC Driver] Object has been closed.
Cause
This error message is received when some network packets are lost during communication between the appliance and an endpoint.
The packets can be lost for the following reasons:
1) Due to an MTU (Maximum Transmission Unit) that is set lower than the size of the packet being sent. This is a network setting.
2) The SQLServer (any database endpoint) has a network packet size that is configured lower than the size of the packet being sent.
For SQL server this value can be found by executing the stored procedure "sp_configure", which will report the min, max, configured, and running values for the network packet size.
3) If a Virtual Appliance is used in VMWare infrastructure, the MTU on VLAN or VSwitch is set lower than the size of the packet being sent.
Diagnosing The Problem
1) Generate the snoop and spy logs.
2) In the spy log, look for any error messages that indicates packet loss, such as the errors "TCP previous packet lost" and "TCP DUP ACK".
Resolving The Problem
To resolve the issue try one of the following:
- Work with customer network engineers to set the network MTU to a higher value based on the packet size sent from the appliance. To set the appliance’s MTU, contact IBM support.
- Note: This option is not preferred because the changes get reset every time the CIOS on the appliance is upgraded.
- If SQL server is the endpoint, set the parameter PacketSize to -1 in the database endpoint configuration of the Cast Iron Orchestration, which instructs the driver to use the maximum allowed packet size based on the server side settings.
The information contained in this document has been moved to developerWorks Answers located here. The new format will allow you to ask additional questions of the community to better understand the information. This technote will be archived in 60 days. Please bookmark the new location.
Was this topic helpful?
Document Information
Modified date:
15 June 2018
UID
swg21580220