SQL Server connection timeout
666038Jul 12 2012 — edited Jul 14 2012Hello All.
I use Golden Gate to extract from MS SQL Server 2005 and replicate to Oracle 11g database.
EXTRACT works fine. But sometimes (once a day) it abends with the following message:
2012-07-11 12:15:43 INFO OGG-01517 Position of first record processed LSN: 0x0056bf51:00002895:0001, 10.07.2012 12:27:45.
TABLE resolved (entry DBO.DOCS):
TABLE DBO.DOCS;
Using the following key columns for source table DBO.DOCS: id.
<..skip..>
Source Context :
SourceModule : [ggvam.gen]
SourceID : [../gglib/ggvam/cvamgen.cpp]
SourceFunction : [com_goldengate_vam::CVamGen::vamRead]
SourceLine : [621]
CommandTimeout
2012-07-11 17:39:04 ERROR OGG-00146 VAM function VAMRead returned unexpected result: error 600 - VAM Client Report <[CTableDef::CheckName] Connection error Error (-2147217871):
How can I avoid this error?
Do I have to configure option "timeout"? How?