Oracle GoldenGate Error Messages

OGG-05034

Capture detected a partial JSON update operation for table '{0}' at column index '{1}' at binlog position '{2}' and record timestamp '{3}'. MySQL capture does not currently support partial JSON update operations. To proceed, specify TRANLOGOPTIONS FETCHPARTIALJSON in the Extract parameter file to fetch the full JSON document for each partial JSON value. Alternatively, you can force a full JSON document in the MySQL binary log by setting the 'binlog_row_value_options' variable to an empty string ('').


Cause

Capture detected a partial JSON record. MySQL capture does not currently support partial JSON update operations.


Action

To proceed, specify TRANLOGOPTIONS FETCHPARTIALJSON in the extract parameter file to fetch the full JSON document for each partial JSON value. Alternatively, you can force a full JSON document in the MySQL binary log by setting the 'binlog_row_value_options' variable to an empty string ('').