Golden Gate Extract In SQL Server Is Not Extracting Records From The Transaction Log Backup (Doc ID 1956291.1)

Last updated on MAY 01, 2017

Applies to:

Oracle GoldenGate - Version 12.1.2.0.1 to 11.2.1.0.39 [Release 12.1 to 11.2]
Microsoft Windows x64 (64-bit)
Check for relevancy 05/01/2017

Symptoms

Using Golden Gate version 12.1.2.0.1, running on a R2008 R2 64 bit platform, EXTRACT fails to start when given a date and time.
No errors or abends occur . The trace file shows the following.

vamRead: return status: GG_STATUS_NO_OP
10/20 20:04:06.111 [processloop.cpp:1023] READ_EXTRACT_RECORD return status: 520
10/20 20:04:06.111 [extcheckpoint.cpp:37] check_extract_chkpt: last rec ended ext trans flag (0/1): 0
10/20 20:04:06.111 [processloop.cpp:597] process_extract_loop: main loop ----------------------------------------------*
10/20 20:04:06.111 [LogBlock.cpp:156] Slot Offset: 1392
10/20 20:04:06.111 [LogBlock.cpp:156] Slot Offset: 1392
10/20 20:04:06.111 [LogBlock.cpp:131] Number Of Records: 16
10/20 20:04:06.111 [LogBlock.cpp:132] Requested Number: 15
10/20 20:04:06.111 [LogBlock.cpp:156] Slot Offset: 1392
10/20 20:04:06.111 [LogBlock.cpp:137] Offset: 1216
10/20 20:04:06.111 [cvamgen.cpp:631] [0x0000000008f90040] vamRead: return status: 16013
10/20 20:04:06.111 [cvamses.h:295] [0x0000000008f90068] isTimestampModeJulian: time stamp mode: 17501
10/20 20:04:06.111 [cvampos.h:164] [0x0000000007b2a080] CVamPos::isPositionUpdated
10/20 20:04:06.111 [cvampos.h:176] [0x0000000007b2a080] CVamPos::isPositionUpdated: false
10/20 20:04:06.111 [cvamrdr.cpp:1596] [0x0000000008f90040] checkForFlush: ok to checkpoint flag (0/1): 1
10/20 20:04:06.111 [cvamses.h:218] [0x0000000008f90068] getFlushMode: 7002
10/20 20:04:06.111 [cvamgen.cpp:810] [0x0000000008f90040] vamRead: return status: GG_STATUS_NO_OP
10/20 20:04:06.111 [processloop.cpp:1023] READ_EXTRACT_RECORD return status: 520
10/20 20:04:06.111 [extcheckpoint.cpp:37] check_extract_chkpt: last rec ended ext trans flag (0/1): 0
10/20 20:04:06.111 [processloop.cpp:597] process_extract_loop: main loop ----------------------------------------------*
10/20 20:04:06.111 [LogBlock.cpp:156] Slot Offset: 1392
10/20 20:04:06.111 [LogBlock.cpp:131] Number Of Records: 16
10/20 20:04:06.111 [LogBlock.cpp:132] Requested Number: 16
10/20 20:04:06.111 [LogBlock.cpp:156] Slot Offset: 1392

This issue is an isolated issue. No other reports of this specific issue has been reported.

Cause

Sign In with your My Oracle Support account

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

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms