Extract Abends With ERROR OGG-06565 On Timestamp With Timezone Of +14:00

(Doc ID 2183021.1)

Last updated on SEPTEMBER 14, 2016

Applies to:

Oracle GoldenGate - Version 11.2.1.0.27 to 12.1.2.1.10 [Release 11.2 to 12.1]
Information in this document applies to any platform.

Symptoms

Extract abends with ERROR OGG-06565

Extract abends with below error.
2015-12-09 08:20:54 ERROR OGG-06565 Formatting error on: table name <schema>.<table>, rowid AAA2hWAAUAABcvnAAS. Error converting timestamp with timezone from Oracle to ASCII format for column <column>.

Even if INCLUDEREGIONID parameter is already included in TRANLOGOPTIONS, extract abends with above error.

<column> displayed in above error is a Timestamp column.

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