After GoldenGate upgrade GoldenGate from 12.1 to 12.2, replicat abend with error:
ERROR OGG-00446 No data selecting position from checkpoint table GGATE.CHECKPOINTTABLE for group ‘R_CRM’, key 2028080425 (0x78e20d29), SQL .
ERROR OGG-01668 PROCESS ABENDING.
It appears replicat is not registered on CHECKPOINTTABLE (is’t true, it’s registered)
Try below:
As a workaround you can ALTER the replicat to the same checkpoint location when you do an INFO REP , DETAIL and then START.
Ex:
GGSCI (labp.grepora.net) 27> info R_CRM
REPLICAT R_CRM Last Started 2017-05-09 13:03 Status STOPPED
Checkpoint Lag 00:00:00 (updated 02:40:11 ago)
Log Read Checkpoint File ./dirdat/s5000609
2017-07-04 10:51:44.035765 RBA 98381832
GGSCI (labp.grepora.net) 28> alter R_CRM extseqno 00609 extrba 98381832
2017-07-04 14:44:39 INFO OGG-06594 Replicat R_CRMhas been altered through GGSCI. Even the start up position might be updated, duplicate suppression remains active in next startup. To override duplicate suppression, start R_CRM with NOFILTERDUPTRANSACTIONS option.
REPLICAT altered.
GGSCI (labp.grepora.net) 29> start R_CRM
Sending START request to MANAGER ...
REPLICAT R_CRM starting
Cheers!