OGG VAM Adapter Extract : Mismatch Between Message And Trails for TIMESTAMP Datatypes (Doc ID 2166398.1)

Last updated on JULY 17, 2017

Applies to:

Oracle GoldenGate Application Adapters - Version 12.1.2.1.1 and later
Information in this document applies to any platform.

Symptoms

i have a VAM extract which reads message from a JMS broker and create trail file. i am seeing mismatch for one of the timestamp columns.

Message

2015-02-12:17:39:46.000000000 +00:00
2015-02-12:17:39:46.000000000 +00:00

trails

Column 8 (x0008), Len 31 (x001f)
 0000 3230 3135 2d30 322d 3132 3a31 373a 3339 3a34 | ..2015-02-12:17:39:4
 362e 3030 3030 3030 3030 30 | 6.000000000
Column 9 (x0009), Len 31 (x001f)
 0000 3230 3135 2d30 322d 3132 3a31 373a 3339 3a34 | ..2015-02-12:17:39:4
 362e 3030 3030 3030 3030 30 | 6.000000000

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