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 JANUARY 13, 2017

Applies to:

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

Symptoms

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.>.

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