ERROR OGG-01367 Oracle GoldenGate Delivery for Oracle, rwmsn.prm: Length of CSN , 0, from input data

Hi,

One of replicat process abending with below error;

ERROR OGG-01367 Oracle GoldenGate Delivery for Oracle, rwmsn.prm: Length of CSN , 0, from input data source not equal to that of previous CSN, 13.

I would like to share you the background of it.

1. First error we got here

Column index (0) out of sequence for table WMS.SL_EO_DATA_DTL, last column index = 1

2. We followed the Metalink note (1393003.1)

Stop the Pump extract

info pall, detail

alter extract pall, etrollover

info pall, detail

alter extract pall,extseqno 2423 extrba 744332626 ( Identified here through logdump and altered)

start extract PALL

alter replicat RWMSN,extseqno 2453,extrba 0 (this was new sequnce generated after performed etrollover)