VAM fails to Process CSV Formatted Delete Operations, OGG-00178 VAM Client Report <Error occured in delimitedparser.c[<>]: Number of fields parsed 1 does not match definition (Doc ID 1592249.1)

Last updated on JULY 17, 2017

Applies to:

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

Symptoms

OGG Adapter VAM capture v11.2.1.0.0 is not able to capture deletes from JMS message CSV.  We tried the following two CSV contents:

The format is: <table and schema>,<optype>,<ID>,<key>

The default JavaUE sends:

SCOTT.TCUE_1,D,00000000250000048188

The primary key is missing from this operation.  Testing created a custom CSV message formatter and sent the following:

SCOTT.TCUE_1,D,00000000250000048188,13

This also didn't work with the following VAM error:

2013-08-21 14:29:34  INFO    OGG-00178  VAM Client Report <Error occured in
delimitedparser.c[951]: Number of fields parsed 1 does not match definition
203>




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