My Oracle Support Banner

Extract Abends With Error OGG-00146 Oracle GoldenGate Capture for ODBC,VAM function VAMRead Returned Unexpected Result: Error 600 - VAM Client Report (Doc ID 1343206.1)

Last updated on MARCH 19, 2019

Applies to:

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


When extract was running and trandata for a table had been resolved by the extract,
user deleted trandata.
When a subsequent update for the table occurs, the extract will ABEND with the error

ERROR OGG-00146 Oracle GoldenGate Capture for ODBC, ENAOLTP.prm: VAM function VAMRead returned unexpected result: error 600 - VAM Client Report <[CGGSApi::PartialUpdateOperation] Updates are not supported on tables that do not have TRANDATA added. TranId: 0006:61adda0b, Table: [dbo].[test]>.

NOTE : If the transaction was an INSERT or DELETE the message is as follows (so the update abend is not consistent with the other messages)

OGG-00178 VAM Client Report <WARNING: Trandata has not been added for table [dbo].[test]. No records will be processed for this table.>.


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.