My Oracle Support Banner

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

Last updated on MAY 11, 2022

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

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
Symptoms
Cause
Solution
References


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