Hi all,
I'm facing error in extract while running Golden Gate for SQL Server. The 'ADD TRANDATA' command successfully completes on the desired table. The Manager is also started. However, when the extract starts, it gives error. Following is the reported error for extract.
***************************************************************************
***********************************************************************
Oracle GoldenGate Capture for SQL Server
Version 11.2.1.0.2 OGGCORE_11.2.1.0.2T3_PLATFORMS_120724.2205
Windows x64 (optimized), Microsoft SQL Server on Jul 25 2012 04:00:23
Copyright (C) 1995, 2012, Oracle and/or its affiliates. All rights reserved.
Starting at 2013-02-13 08:50:57
***********************************************************************
Operating System Version:
Microsoft Windows Server 2008 R2 , on x64
Version 6.1 (Build 7601: Service Pack 1)
Process id: 1676
Description:
***********************************************************************
** Running with the following parameters **
***********************************************************************
2013-02-13 08:50:57 INFO OGG-03035 Operating system character set identified as windows-1252. Locale: en_US, LC_ALL:.
EXTRACT epm_echg
SOURCEDB sqldsn1 userid ggsowner password ********
2013-02-13 08:50:57 INFO OGG-03036 Database character set identified as windows-1252. Locale: en_US.
2013-02-13 08:50:57 INFO OGG-03037 Session character set identified as windows-1252.
EXTTRAIL C:\gg_for_sql\dirdat\em
TABLE efbr_rep.dbo.ePayments_Main;
2013-02-13 08:50:57 INFO OGG-01815 Virtual Memory Facilities for: COM
anon alloc: MapViewOfFile anon free: UnmapViewOfFile
file alloc: MapViewOfFile file free: UnmapViewOfFile
target directories:
C:\GG_FOR_SQL\dirtmp.
CACHEMGR virtual memory values (may have been adjusted)
CACHESIZE: 32G
CACHEPAGEOUTSIZE (normal): 8M
PROCESS VM AVAIL FROM OS (min): 46.44G
CACHESIZEMAX (strict force to disk): 42.44G
2013-02-13 08:50:58 WARNING OGG-01842 CACHESIZE PER DYNAMIC DETERMINATION (32G) LESS THAN RECOMMENDED: 64G (64bit system)
vm found: 46.44G
Check swap space. Recommended swap/extract: 128G (64bit system).
Database Version:
Microsoft SQL Server
Version 11.00.2100
ODBC Version 03.80.0000
Driver Information:
SQLSRV32.DLL
Version 06.01.7601
ODBC Version 03.52
2013-02-13 08:50:59 INFO OGG-01055 Recovery initialization completed for target file C:\gg_for_sql\dirdat\em000002, at RBA 990.
2013-02-13 08:50:59 INFO OGG-01478 Output file C:\gg_for_sql\dirdat\em is using format RELEASE 11.2.
2013-02-13 08:50:59 INFO OGG-01026 Rolling over remote file C:\gg_for_sql\dirdat\em000002.
2013-02-13 08:50:59 INFO OGG-01053 Recovery completed for target file C:\gg_for_sql\dirdat\em000003, at RBA 990.
2013-02-13 08:50:59 INFO OGG-01057 Recovery completed for all targets.
2013-02-13 08:50:59 INFO OGG-00182 VAM API running in single-threaded mode.
2013-02-13 08:50:59 INFO OGG-01515 Positioning to begin time Feb 13, 2013 5:18:31 AM.
2013-02-13 08:50:59 INFO OGG-00178 VAM Client Report <Opening files for DSN: sqldsn1, Server: WIN-LV23RF055LU\ODSSQL12, Database: eFBR_Rep>.
Source Context :
SourceModule : [ggvam.gen]
SourceID : [../gglib/ggvam/cvamgen.cpp]
SourceFunction : [com_goldengate_vam::CVamGen::vamInitialize]
SourceLine : [464]
ThreadBacktrace : [10] elements
: [C:\GG_FOR_SQL\gglog.dll(??1CContextItem@@UEAA@XZ+0x32e2) [0x0000000180109C42]]
: [C:\GG_FOR_SQL\gglog.dll(?_MSG_ERR_VAM_API_ERROR_MSG@@YAPEAVCMessage@@PEAVCSourceContext@@PEBDH1W4MessageDisposition@CMessageFactory@@@Z+0xde) [0x000000018002C00E]]
: [C:\GG_FOR_SQL\extract.exe(GGDataBufferGetNextChunk+0x523fd) [0x00000001402473AD]]
: [C:\GG_FOR_SQL\extract.exe(GGDataBufferGetNextChunk+0x1441) [0x00000001401F63F1]]
: [C:\GG_FOR_SQL\extract.exe(shutdownMonitoring+0x19d0a) [0x00000001400E05CA]]
: [C:\GG_FOR_SQL\extract.exe(shutdownMonitoring+0x19e4e) [0x00000001400E070E]]
: [C:\GG_FOR_SQL\extract.exe(shutdownMonitoring+0x1c0af) [0x00000001400E296F]]
: [C:\GG_FOR_SQL\extract.exe(VAMRead+0x92850) [0x0000000140335DB0]]
: [C:\Windows\system32\kernel32.dll(BaseThreadInitThunk+0xd) [0x0000000077A5652D]]
: [C:\Windows\SYSTEM32\ntdll.dll(RtlUserThreadStart+0x21) [0x0000000077C8C521]]
2013-02-13 08:51:31 ERROR OGG-00146 VAM function VAMInitialize returned unexpected result: error 600 - VAM Client Report <MSSqlVam: (1) [mssqlvam::CLogLayout::BuildLayout] Column name or number of supplied values does not match table definition. Error (-2147217900): Column name or number of supplied values does not match table definition.
.
2013-02-13 08:51:31 ERROR OGG-01668 PROCESS ABENDING.
***************************************************************************
The parameter file for extract is as follows.
***************************************************************************
EXTRACT epm_echg
SOURCEDB sqldsn1 userid ggsowner password ******
EXTTRAIL C:\gg_for_sql\dirdat\em
TABLE dbo.ePayments_Main;
***************************************************************************
Any help would be appreciated.
Thanks.