Goldengate Extract Abends With ERROR OGG-00212 Invalid option for MAP: XXXXXXX. (Doc ID 2118658.1)

Last updated on APRIL 04, 2023

Applies to:

Symptoms

Database: SQL Server 2008SP1

Goldengate Extract abends with :


Source Context :
 SourceModule : [er.main]
 SourceID : [er/rep.c]
 SourceFunction : [get_map_entry]
 SourceLine : [8776]
 ThreadBacktrace : [26] elements
  : [<GGHOME>\extract.exe(GGDataBufferGetNextChunk+0xae5c4) [0x0000000140248654]]
  : [<GGHOME>\extract.exe(GGDataBufferGetNextChunk+0x6d84a) [0x00000001402078DA]]
  : [<GGHOME>\extract.exe(<GDataBufferGetNextChunk+0x6d84a) [0x000000014008191F]]
  : [<GGHOME>\extract.exe(ERCALLBACK+0x729fe) [0x0000000140146C4E]]
  : [<GGHOME>\extract.exe(ERCALLBACK+0x73246) [0x0000000140147496]]
  : [<GGHOME>\extract.exe(GGDataBufferGetNextChunk+0x2881c) [0x00000001401C28AC]]
  : [<GGHOME>\extract.exe(GGDataBufferGetNextChunk+0x27bbf) [0x00000001401C1C4F]]
  : [<GGHOME>\extract.exe(GGDataBufferGetNextChunk+0x218ce) [0x00000001401BB95E]]
  : [<GGHOME>\extract.exe(GGDataBufferGetNextChunk+0x19867) [0x00000001401B38F7]]
  : [<GGHOME>\extract.exe(GGAttrSet+0x93) [0x0000000140198C03]]
  : [<GGHOME>\extract.exe(VAMControl+0xa39f) [0x00000001402D03BF]]
  : [<GGHOME>\extract.exe(VAMControl+0xad40) [0x00000001402D0D60]]
  : [<GGHOME>\extract.exe(VAMControl+0x3c21b) [0x000000014030223B]]
  : [<GGHOME>\extract.exe(VAMControl+0x3327f) [0x00000001402F929F]]
  : [<GGHOME>\extract.exe(VAMControl+0x336e6) [0x00000001402F9706]]
  : [<GGHOME>\extract.exe(VAMControl+0x182e8) [0x00000001402DE308]]
  : [<GGHOME>\extract.exe(VAMControl+0x20abe) [0x00000001402E6ADE]]
  : [<GGHOME>\extract.exe(VAMRead+0xa2) [0x00000001402C2142]]
  : [<GGHOME>\extract.exe(GGDataBufferGetNextChunk+0x3b575) [0x00000001401D5605]]
  : [<GGHOME>\extract.exe(GGDataBufferGetNextChunk+0xd6d) [0x000000014019ADFD]]
  : [<GGHOME>\extract.exe(<GDataBufferGetNextChunk+0xd6d) [0x000000014000B07E]]
  : [<GGHOME>\extract.exe(<GDataBufferGetNextChunk+0xd6d) [0x00000001400AA386]]
  : [<GGHOME>\extract.exe(<GDataBufferGetNextChunk+0xd6d) [0x00000001400B6451]]
  : [<GGHOME>\extract.exe(VAMControl+0x829a0) [0x00000001403489C0]]
  : [C:\Windows\system32\kernel32.dll(BaseThreadInitThunk+0xd) [0x000000007692652D]]
  : [C:\Windows\SYSTEM32\ntdll.dll(RtlUserThreadStart+0x21) [0x0000000076ECC521]]

2016-03-14 07:44:36 ERROR OGG-00212 Invalid option for MAP: EXTRACT.

2016-03-14 07:44:36 INFO OGG-00178 VAM Client Report Open Transactions
-----------------
0000:029ba571 (2016/03/11 01:00:00.540) @ 00015bbb:0000987a:0001: Upd(Comp) = 0(0), Row(comp) = 1(0)
>.

2016-03-14 07:44:36 INFO OGG-00178 VAM Client Report
ERROR
-----------------------
OGG-00212, OGG-00178

Below messages can be seen in report file:

2016-03-14 07:44:36 INFO OGG-01517 Position of first record processed LSN: 0x00015bbb:00009878:0003, 11 Mar 2016 00:59:48.
TABLEWildcard resolved (entry <USER>.XXX*):
TABLE <USER>.<XXX XXXXXXX>, TOKENS (TKN-COMMIT-TS = @GETENV("GGHEADER","COMMITTIMESTAMP"));

2016-03-14 07:44:36 ERROR OGG-00212 Invalid option for MAP: XXXXXXX.

2016-03-14 07:44:36 INFO OGG-00178 VAM Client Report <Last LSN Read: 00015bbb:0000987a:0002

Cause

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