-
Type:
Support Activity
-
Status:
Closed
-
Priority:
Critical
-
Resolution:
Done
-
Affects Version/s:
None
-
Fix Version/s:
None
-
-
-
Support Task Type:
Data Correction
-
-
-
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.
Satya Ganesh Sadawarte
- relates to
-
WT-9141
Remove CDC dependency from Employee Data Screens
-
-
Closed
{"report":{"apdex":1,"isInitial":true,"journeyId":"746f1b67-a78e-408c-9693-17ac61615a9b","key":"jira.project.issue.view-issue","navigationType":0,"readyForUser":899.6000000238419,"redirectCount":0,"resourceLoadedEnd":1069.1000000238419,"resourceLoadedStart":99.5,"resourceTiming":[{"duration":385.10000002384186,"initiatorType":"link","name":"https://jira.workterra.net/s/3003653444a1e1a85555cab7dcfb3a21-CDN/-w431t5/805012/9a9e1fae3639050b38ac467c3aa37e79/2e46d90b5cae895c9c38649c9d510130/_/download/contextbatch/css/_super/batch.css","startTime":99.5,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":99.5,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":484.60000002384186,"responseStart":0,"secureConnectionStart":0},{"duration":384.89999997615814,"initiatorType":"link","name":"https://jira.workterra.net/s/dd6a0911920485696ac20493290df627-CDN/-w431t5/805012/9a9e1fae3639050b38ac467c3aa37e79/3abe50d469404b639745df44b51476b6/_/download/contextbatch/css/jira.browse.project,jira.view.issue,project.issue.navigator,jira.global,atl.general,-_super/batch.css?agile_global_admin_condition=true&jag=true&jira.create.linked.issue=true&richediton=true","startTime":99.79999995231628,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":99.79999995231628,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":484.6999999284744,"responseStart":0,"secureConnectionStart":0},{"duration":384.6999999284744,"initiatorType":"link","name":"https://jira.workterra.net/s/d41d8cd98f00b204e9800998ecf8427e-CDN/-w431t5/805012/9a9e1fae3639050b38ac467c3aa37e79/8.5.0/_/download/batch/com.atlassian.auiplugin:split_aui.pattern.label/com.atlassian.auiplugin:split_aui.pattern.label.css","startTime":100,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":100,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":484.6999999284744,"responseStart":0,"secureConnectionStart":0},{"duration":384.7999999523163,"initiatorType":"link","name":"https://jira.workterra.net/s/bd548f27bbf8f278bd83b60dd3284ed8-CDN/-w431t5/805012/9a9e1fae3639050b38ac467c3aa37e79/1.0/_/download/batch/jira.webresources:global-static-adgs/jira.webresources:global-static-adgs.css","startTime":100.10000002384186,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":100.10000002384186,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":484.89999997615814,"responseStart":0,"secureConnectionStart":0},{"duration":384.7000000476837,"initiatorType":"link","name":"https://jira.workterra.net/s/70725731a158a7140f19ddbd4201ba27-CDN/-w431t5/805012/9a9e1fae3639050b38ac467c3aa37e79/1.0/_/download/batch/jira.webresources:global-static/jira.webresources:global-static.css","startTime":100.19999992847443,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":100.19999992847443,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":484.89999997615814,"responseStart":0,"secureConnectionStart":0},{"duration":396.2000000476837,"initiatorType":"script","name":"https://jira.workterra.net/s/f2623af22c15df767ec6ff268ae0b8bd-CDN/-w431t5/805012/9a9e1fae3639050b38ac467c3aa37e79/2e46d90b5cae895c9c38649c9d510130/_/download/contextbatch/js/_super/batch.js?locale=en-US","startTime":100.29999995231628,"connectEnd":100.29999995231628,"connectStart":100.29999995231628,"domainLookupEnd":100.29999995231628,"domainLookupStart":100.29999995231628,"fetchStart":100.29999995231628,"redirectEnd":0,"redirectStart":0,"requestStart":100.29999995231628,"responseEnd":496.5,"responseStart":496.5,"secureConnectionStart":100.29999995231628},{"duration":453.60000002384186,"initiatorType":"script","name":"https://jira.workterra.net/s/6ce676f2a5bcc9651cef6e7956f05def-CDN/-w431t5/805012/9a9e1fae3639050b38ac467c3aa37e79/3abe50d469404b639745df44b51476b6/_/download/contextbatch/js/jira.browse.project,jira.view.issue,project.issue.navigator,jira.global,atl.general,-_super/batch.js?agile_global_admin_condition=true&jag=true&jira.create.linked.issue=true&locale=en-US&richediton=true","startTime":100.39999997615814,"connectEnd":100.39999997615814,"connectStart":100.39999997615814,"domainLookupEnd":100.39999997615814,"domainLookupStart":100.39999997615814,"fetchStart":100.39999997615814,"redirectEnd":0,"redirectStart":0,"requestStart":100.39999997615814,"responseEnd":554,"responseStart":554,"secureConnectionStart":100.39999997615814},{"duration":456.1999999284744,"initiatorType":"script","name":"https://jira.workterra.net/s/ecf7ec549751ae117b778f0525d6d371-CDN/-w431t5/805012/9a9e1fae3639050b38ac467c3aa37e79/4.1.5/_/download/resources/com.atlassian.plugins.atlassian-chaperone:hotspot-tour/hotspot-tour.js?batch=false&locale=en-US","startTime":100.60000002384186,"connectEnd":100.60000002384186,"connectStart":100.60000002384186,"domainLookupEnd":100.60000002384186,"domainLookupStart":100.60000002384186,"fetchStart":100.60000002384186,"redirectEnd":0,"redirectStart":0,"requestStart":100.60000002384186,"responseEnd":556.7999999523163,"responseStart":556.7999999523163,"secureConnectionStart":100.60000002384186},{"duration":457.39999997615814,"initiatorType":"script","name":"https://jira.workterra.net/s/6aa3fcf1fac5fd551eee0b69077524e6-CDN/-w431t5/805012/9a9e1fae3639050b38ac467c3aa37e79/aae1242f5fc81cc6a5bb8bc963ccda29/_/download/contextbatch/js/atl.global,-_super/batch.js?locale=en-US","startTime":100.60000002384186,"connectEnd":100.60000002384186,"connectStart":100.60000002384186,"domainLookupEnd":100.60000002384186,"domainLookupStart":100.60000002384186,"fetchStart":100.60000002384186,"redirectEnd":0,"redirectStart":0,"requestStart":100.60000002384186,"responseEnd":558,"responseStart":558,"secureConnectionStart":100.60000002384186},{"duration":458.5,"initiatorType":"script","name":"https://jira.workterra.net/s/d41d8cd98f00b204e9800998ecf8427e-CDN/-w431t5/805012/9a9e1fae3639050b38ac467c3aa37e79/1.0/_/download/batch/jira.webresources:calendar-en/jira.webresources:calendar-en.js","startTime":100.69999992847443,"connectEnd":100.69999992847443,"connectStart":100.69999992847443,"domainLookupEnd":100.69999992847443,"domainLookupStart":100.69999992847443,"fetchStart":100.69999992847443,"redirectEnd":0,"redirectStart":0,"requestStart":100.69999992847443,"responseEnd":559.1999999284744,"responseStart":559.1999999284744,"secureConnectionStart":100.69999992847443},{"duration":459.2000000476837,"initiatorType":"script","name":"https://jira.workterra.net/s/d41d8cd98f00b204e9800998ecf8427e-CDN/-w431t5/805012/9a9e1fae3639050b38ac467c3aa37e79/1.0/_/download/batch/jira.webresources:calendar-localisation-moment/jira.webresources:calendar-localisation-moment.js","startTime":100.89999997615814,"connectEnd":100.89999997615814,"connectStart":100.89999997615814,"domainLookupEnd":100.89999997615814,"domainLookupStart":100.89999997615814,"fetchStart":100.89999997615814,"redirectEnd":0,"redirectStart":0,"requestStart":100.89999997615814,"responseEnd":560.1000000238419,"responseStart":560.1000000238419,"secureConnectionStart":100.89999997615814},{"duration":460.39999997615814,"initiatorType":"link","name":"https://jira.workterra.net/s/05c862146699bb029ceb0a489075e63b-CDN/-w431t5/805012/9a9e1fae3639050b38ac467c3aa37e79/bcd66e9a133a1b9f5fd14b56841e1c5b/_/download/contextbatch/css/jira.global.look-and-feel,-_super/batch.css","startTime":101.10000002384186,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":101.10000002384186,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":561.5,"responseStart":0,"secureConnectionStart":0},{"duration":459.5,"initiatorType":"script","name":"https://jira.workterra.net/s/ecf7ec549751ae117b778f0525d6d371-CDN/-w431t5/805012/9a9e1fae3639050b38ac467c3aa37e79/8.5.0/_/download/batch/com.atlassian.auiplugin:split_aui.pattern.label/com.atlassian.auiplugin:split_aui.pattern.label.js?locale=en-US","startTime":101.10000002384186,"connectEnd":101.10000002384186,"connectStart":101.10000002384186,"domainLookupEnd":101.10000002384186,"domainLookupStart":101.10000002384186,"fetchStart":101.10000002384186,"redirectEnd":0,"redirectStart":0,"requestStart":101.10000002384186,"responseEnd":560.6000000238419,"responseStart":560.6000000238419,"secureConnectionStart":101.10000002384186},{"duration":461.10000002384186,"initiatorType":"link","name":"https://jira.workterra.net/s/9095228fa10daa2d3e3d7d5760c95e91-CDN/-w431t5/805012/9a9e1fae3639050b38ac467c3aa37e79/72477c22780abda5f51fe696920d843f/_/download/contextbatch/css/com.atlassian.jira.projects.sidebar.init,-_super,-jira.view.issue,-project.issue.navigator/batch.css?jira.create.linked.issue=true&richediton=true","startTime":101.29999995231628,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":101.29999995231628,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":562.3999999761581,"responseStart":0,"secureConnectionStart":0},{"duration":460.2000000476837,"initiatorType":"script","name":"https://jira.workterra.net/rest/api/1.0/shortcuts/805012/81da1c7492d7ee698ae1cc31902498d9/shortcuts.js?context=issuenavigation&context=issueaction","startTime":101.29999995231628,"connectEnd":101.29999995231628,"connectStart":101.29999995231628,"domainLookupEnd":101.29999995231628,"domainLookupStart":101.29999995231628,"fetchStart":101.29999995231628,"redirectEnd":0,"redirectStart":0,"requestStart":101.29999995231628,"responseEnd":561.5,"responseStart":561.5,"secureConnectionStart":101.29999995231628},{"duration":461.10000002384186,"initiatorType":"script","name":"https://jira.workterra.net/s/c19a1b46e985d7fb85efaf27c8febfdd-CDN/-w431t5/805012/9a9e1fae3639050b38ac467c3aa37e79/72477c22780abda5f51fe696920d843f/_/download/contextbatch/js/com.atlassian.jira.projects.sidebar.init,-_super,-jira.view.issue,-project.issue.navigator/batch.js?jira.create.linked.issue=true&locale=en-US&richediton=true","startTime":101.5,"connectEnd":101.5,"connectStart":101.5,"domainLookupEnd":101.5,"domainLookupStart":101.5,"fetchStart":101.5,"redirectEnd":0,"redirectStart":0,"requestStart":101.5,"responseEnd":562.6000000238419,"responseStart":562.6000000238419,"secureConnectionStart":101.5}],"threshold":1000,"fetchStart":0,"domainLookupStart":0,"domainLookupEnd":0,"connectStart":0,"connectEnd":0,"requestStart":19,"responseStart":94,"responseEnd":94,"domLoading":97,"domInteractive":1098,"domContentLoadedEventStart":1098,"domContentLoadedEventEnd":1142,"domComplete":1556,"loadEventStart":1556,"loadEventEnd":1558,"userAgent":"Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)","marks":[],"measures":[],"correlationId":"125419e88f23b7","effectiveType":"4g","downlink":9,"rtt":0,"serverDuration":47,"dbReadsTimeInMs":13,"dbConnsTimeInMs":15,"applicationHash":"156decd7d2b4272533aa6cefc8294af635e1da97","experiments":[]}}
Sheetal Bodhale (Inactive)
added a comment - Due to other priority task ,not able to work on it.so marking it as on Hold. 
Akshay Mukkawar (Inactive)
added a comment - There is no separate patch required for this. It has been deployed along with WT-9141 JIRA ticket, So mark this Support Activity as Closed
Thanks,
Akshay Mukkawar
-----------------------------
CC: Sheetal Bodhale , Swapnil Pandhare , Satya , Vinayak Kulkarni 
Hi Vinayak Kulkarni/Satya,
Regenerated employee payroll history table on JE dunn stage company.
Scanning across all over company is in progress
Thanks,
Sheetal Bodhale