Oracle GoldenGate Error Messages

The target column does not support null column values.

You can restart Replicat to skip this record with START options, or you can use a REPERROR rule to handle this type of record. Another option is to alter the target table definition to accept null values. You can use TRANLOGOPTIONS with EMPTYLOBSTRING to substitute a string value for empty (zero-length) LOB columns that are replicated to the target. By default, Oracle GoldenGate sets empty columns to NULL on the target and will abend if the target database does not permit LOB columns to be NULL. EMPTYLOBSTRING prevents Replicat from abending.

The target column does not support null column values.

You can restart Replicat to skip this record with START options, or you can use a REPERROR rule to handle this type of record. Another option is to alter the target table definition to accept null values. You can use TRANLOGOPTIONS with EMPTYLOBSTRING to substitute a string value for empty (zero-length) LOB columns that are replicated to the target. By default, Oracle GoldenGate sets empty columns to NULL on the target and will abend if the target database does not permit LOB columns to be NULL. EMPTYLOBSTRING prevents Replicat from abending.

The target column does not support null column values.

You can restart Replicat to skip this record with START options, or you can use a REPERROR rule to handle this type of record. Another option is to alter the target table definition to accept null values. You can use TRANLOGOPTIONS with EMPTYLOBSTRING to substitute a string value for empty (zero-length) LOB columns that are replicated to the target. By default, Oracle GoldenGate sets empty columns to NULL on the target and will abend if the target database does not permit LOB columns to be NULL. EMPTYLOBSTRING prevents Replicat from abending.