My Oracle Support Banner

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

Last updated on MARCH 19, 2019

Applies to:

Oracle GoldenGate - Version 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:

Please see:

"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



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

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