Kbase P155366: Intermittent error 14959 is displaying while running the ABL application using against MS SQL Server
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
6/28/2010 |
|
Status: Verified
SYMPTOM(s):
Intermittent error 14959 is displaying while running the ABL application using against MS SQL Server DataServer against MS SQL Server database
Disconnecting database due to server communication failure (14959)
FACT(s) (Environment):
No errors displayed on the dataserver log file
The TCP Chimney offload feature is disabled
The error is apparent when write caching is enabled on the Xiotech SAN for the vdisk that stores SQL databases
Turning off the write cache feature in the Xiotech SAN resolves the error
ABL clients connects to SQL server database
Windows
MS SQL DataServer
MS SQL
OpenEdge 10.1C
OpenEdge 10.2x
CAUSE:
Enabling write cache on the Xiotech SAN for the vdisk that stores SQL databases
FIX:
This DataServer error is implemented specifically for the case of a communication link failure between the ABL DataServer component and the MS SQL Server database. There are no other conditions that would make this error occur. The message simply informs the user of the link failure in a controlled way. The application is recycled, prevented from hanging and its resources and transactions are cleaned up and rolled back in response to the MS SQL Server link failure.
If this error happens very often, contact Microsoft to resolve the [Microsoft][ODBC SQL Server Driver]Communication link failure issues between the ODBC client and the MS SQL Server.
If this error causes by a specific SAN utility feature, contact the vendor of the SAN software provider to resolve this issue.