Replicats fails with Intermitant ODBC error: SQLSTATE 01000 native database error 10054 (Doc ID 1172584.1)

Last updated on JANUARY 13, 2017

Applies to:

Oracle GoldenGate - Version: 10.0.0.11 and later   [Release: 10.0.0 and later ]
Microsoft Windows (32-bit)
Microsoft Windows x64 (64-bit)

Symptoms

Replicat had been running fine and now it started to have the random occurrences of the same error.

In the report file the following is reported

2010-06-16 10:54:23 GGS ERROR 118 Database operation failed: Retrieving column information for R3_STG_S_LST_OF_VAL. ODBC error: SQLSTATE 01000 native database error 10054. [Microsoft][ODBC SQL Server Driver][DBNETLIB]ConnectionWrite (send()).

There are no unique entries in the OS logs. There was and observation of high tempdb usage again on the database server during this time. It even resulted in some IO bottleneck messages in the SQL Server logs:

Event Type: Information
Event Source: MSSQLSERVER
Event Category: Server
Event ID: 833
Date: 6/16/2010
Time: 10:45:56 AM
User: N/A
Computer: GRDO
Description:
SQL Server has encountered 42 occurrence(s) of I/O requests taking longer than 15 seconds to complete on file [H:\sql_dat\tempdev2.ndf] in database [tempdb] (2). The OS file handle is 0x0000000000000B1C. The offset of the latest long I/O is: 0x0000007d2f0000

There was also noticed several messages in our SQL Server error logs related to high I/O

Changes

Increase in the DB I/O can cause this issue

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms