Extract Abends With ERROR OGG-06565 On Timestamp With Timezone Of +14:00
Last updated on SEPTEMBER 14, 2016
Applies to:Oracle GoldenGate - Version 220.127.116.11.27 to 18.104.22.168.10 [Release 11.2 to 12.1]
Information in this document applies to any platform.
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.
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