My Oracle Support Banner

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: and later   [Release: 10.0.0 and later ]
Microsoft Windows (32-bit)
Microsoft Windows x64 (64-bit)


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 Category: Server
Event ID: 833
Date: 6/16/2010
Time: 10:45:56 AM
User: N/A
Computer: GRDO
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


Increase in the DB I/O can cause this issue


To view full details, sign in with your My Oracle Support account.

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

In this Document

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.