OGG SQL Server Extract Abends with Timestamp Out Of Range: -5545347218586719696.
Last updated on APRIL 19, 2017
Applies to:Oracle GoldenGate - Version 188.8.131.52.0 and later
Microsoft Windows x64 (64-bit)
Why OGG extract abend with ERROR OGG-01158 Timestamp out of range: -5545347218586719696
The issue caused by bulk operations happened when extract capturing data from log.
here is more info about bulk operations:
"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
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