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
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 Source: MSSQLSERVER
Event Category: Server
Event ID: 833
Time: 10:45:56 AM
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
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!