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
Oracle GoldenGate - Version 184.108.40.206.0 to 220.127.116.11.1 [Release 18.104.22.168 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.>.
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