Need to scan missing columns in history to avoid CDC error

Hi Sheetal Bodhale

As we know, we sometimes get error on EDS if CDC is activated, this is specifically for stage but could be on production as well.

We have checked this and found issue is causing due to missing columns in history table.
On JE Dunn stage, in payroll table there are two additional fields which are not present in history table. We have added those in HSPL copy and activated CDC and no error is thrown on EDS.

We need to scan all companies on stage and production and add missing columns. Going forward we will not create separate companies on stage or production to activate CDC.

Let us know if you have any questions on this, Thanks.

WT-Admin Ganesh Sadawarte