For one of our projects, we upgraded Goldengate version to 18.104.22.168. After upgrading to newer version, I am able to successfully add new replicats. But when I tried starting the replicat, I encountered the following error:
2016-09-04 11:50:58 ERROR OGG-00446 Supplemental checkpoint table does not exist. Create a supplemental checkpoint table with the UPGRADE CHECKPOINTTABLE command in GGSCI if you have upgraded from release 22.214.171.124.0 or earlier.
As per recommendation provided in the error message, I did run the following command successfully:
GGSCI> UPGRADE CHECKPOINTTABLE
I was hoping the above command resolves the issues. When I tried attempting to restart replicat, unfortunately I encountered the same error with the same recommendation – UPGRADE CHECKPOINTTABLE. At this stage, I decided to Delete and Add checkpoint table. Luckily, deleting and adding check point table resolved the issue and I was able to start the replicat process.
GGSCI> DELETE CHECKPOINTTABLE
GGSCI> ADD CHECKPOINTTABLE
Above command uses the CHECKPOINTTABLE name given in GLOBALS.