My Oracle Support Banner

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

Last updated on FEBRUARY 21, 2019

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

To view full details, sign in with your My Oracle Support account.

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


In this Document
Symptoms
Cause
Solution
References


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