OGG SQL Server Extract Abends with Timestamp Out Of Range: -5545347218586719696. (Doc ID 2203996.1)

Last updated on APRIL 19, 2017

Applies to:

Oracle GoldenGate - Version 12.2.0.1.0 and later
Microsoft Windows x64 (64-bit)
Why OGG extract abend with ERROR OGG-01158 Timestamp out of range: -5545347218586719696

Goal

The issue caused by bulk operations happened when extract capturing data from log.

here is more info about bulk operations:

Please see:
http://docs.oracle.com/goldengate/c1221/gg-winux/GIMSS/GUID-6DB4C330-03E8-4F95-A821-0046A21A3BFF.htm#GIMSS187

"The log chain on the source database must not be broken at any time while Oracle GoldenGate is installed and running. The log chain is broken if the log was backed up with the no_log or truncate_only options, or if the
recovery model was set to Simple or Bulk_logged at any time after the initial . full database backup was completed. For more information, see the Microsoft SQL Server documentation on Log Chains."

And also if customer try to setup TDE in sql server build, it will see the bulk operation also after we tested in house.

Also you may see other kind error such as extract detected an unbalanced transaction. Please see the details on km note : 2204027.1


 

Solution

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