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!