IBM Support

[Microsoft][ODBC SQL Server Driver]Communication link failure' errors are being logged in the Process Engine elogs, how can they be corrected?

Troubleshooting


Problem

Process Engine 4.5.1.x running on Windows using Microsoft SQL Server database will intermittently log the following errors: 2012/06/05 10:06:38.492 121,0,41 VW/Process (1288.7084.64 0x508.1bac) ... [CRITICAL] Error in GDBY_logoff: SQLEndTran DBC, hdbc=13038296 (&01d3e0d0), COMMIT (..\src\GDBY.c, VERSION 4.1.1.1, @2628). SQLSTATE = 08S01, NativeError = 0, ErrorMsg = '[Microsoft][ODBC SQL Server Driver]Communication link failure'

Symptom

The following errors are logged in the Process Engine 4.5.1.x elog or in the Windows application event log:

    2012/06/05 10:06:38.476 121,0,41 <S103092> VW/Process  (1288.7084.64 0x508.1bac) ... [CRITICAL]
    Error in GDBY_fetch: SQLFetch, STMT 31792776 (&01d3e410) (..\src\GDBY.c, VERSION 4.1.1.1, @3680).
    SQLSTATE = 08S01, NativeError = 11,
    ErrorMsg = '[Microsoft][ODBC SQL Server Driver][DBNETLIB]General network error. Check your network documentation.'

    2012/06/05 10:06:38.492 121,0,41 <S103092> VW/Process  (1288.7084.64 0x508.1bac) ... [CRITICAL]
    Error in GDBY_logoff: SQLEndTran DBC, hdbc=13038296 (&01d3e0d0), COMMIT (..\src\GDBY.c, VERSION 4.1.1.1, @2628).
    SQLSTATE = 08S01, NativeError = 0,
    ErrorMsg = '[Microsoft][ODBC SQL Server Driver]Communication link failure'

Microsoft SQL Server will log a corresponding entry in the SQL Server error log
    Error: 7886, Severity: 20, State: 1.
    A read operation on a large object failed while sending data to the client. A common cause for this is if the application is running in READ UNCOMMITTED isolation level. This connection will be terminated.

This can occur on Microsoft SQL Server 2003 or 2008.

[{"Product":{"code":"SSTHRT","label":"IBM Case Foundation"},"Business Unit":{"code":"BU048","label":"IBM Software"},"Component":"Process Engine","Platform":[{"code":"PF033","label":"Windows"}],"Version":"4.5.1","Edition":"","Line of Business":{"code":"LOB76","label":"Data Platform"}}]

Log InLog in to view more of this document

This document has the abstract of a technical article that is available to authorized users once you have logged on. Please use Log in button above to access the full document. After log in, if you do not have the right authorization for this document, there will be instructions on what to do next.

Document Information

Modified date:
17 June 2018

UID

swg21609058

Page Feedback