-
Type:
Bug
-
Status:
In QA Testing
-
Priority:
Medium
-
Resolution:
Unresolved
-
Affects Version/s:
None
-
Fix Version/s:
None
-
-
Company:
All Clients/Multiple Clients
-
Sprint:
March 2021 Release - Sprint 2, April 2021 Release - Sprint 1, April 2021 Release - Sprint 2
Hi team,
CCSg (https://ccsgroup.luceosolutions.com/) is having issues with the candidate table on the home page.
It shows a DMS error issue.
I have tested it with the SA user and I got the same error.
Can you please investigate why and fix it?
Thank you!
{"report":{"apdex":1,"isInitial":true,"journeyId":"fd60dceb-5bcc-417e-af1e-2f57c6f147f0","key":"jira.project.issue.view-issue","navigationType":0,"readyForUser":706.7000007629395,"redirectCount":0,"resourceLoadedEnd":975.1000003814697,"resourceLoadedStart":155.60000038146973,"resourceTiming":[{"duration":49.80000019073486,"initiatorType":"link","name":"https://jira.workterra.net/s/3003653444a1e1a85555cab7dcfb3a21-CDN/-w431t5/805012/9a9e1fae3639050b38ac467c3aa37e79/2e46d90b5cae895c9c38649c9d510130/_/download/contextbatch/css/_super/batch.css","startTime":155.60000038146973,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":155.60000038146973,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":205.4000005722046,"responseStart":0,"secureConnectionStart":0},{"duration":49.89999961853027,"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":155.9000005722046,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":155.9000005722046,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":205.80000019073486,"responseStart":0,"secureConnectionStart":0},{"duration":50.09999942779541,"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":156.20000076293945,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":156.20000076293945,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":206.30000019073486,"responseStart":0,"secureConnectionStart":0},{"duration":65.19999980926514,"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":156.30000019073486,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":156.30000019073486,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":221.5,"responseStart":0,"secureConnectionStart":0},{"duration":65.10000038146973,"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":156.5,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":156.5,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":221.60000038146973,"responseStart":0,"secureConnectionStart":0},{"duration":109.30000019073486,"initiatorType":"script","name":"https://jira.workterra.net/s/f2623af22c15df767ec6ff268ae0b8bd-CDN/-w431t5/805012/9a9e1fae3639050b38ac467c3aa37e79/2e46d90b5cae895c9c38649c9d510130/_/download/contextbatch/js/_super/batch.js?locale=en-US","startTime":156.80000019073486,"connectEnd":156.80000019073486,"connectStart":156.80000019073486,"domainLookupEnd":156.80000019073486,"domainLookupStart":156.80000019073486,"fetchStart":156.80000019073486,"redirectEnd":0,"redirectStart":0,"requestStart":156.80000019073486,"responseEnd":266.1000003814697,"responseStart":266.1000003814697,"secureConnectionStart":156.80000019073486},{"duration":144.69999980926514,"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":156.9000005722046,"connectEnd":156.9000005722046,"connectStart":156.9000005722046,"domainLookupEnd":156.9000005722046,"domainLookupStart":156.9000005722046,"fetchStart":156.9000005722046,"redirectEnd":0,"redirectStart":0,"requestStart":156.9000005722046,"responseEnd":301.6000003814697,"responseStart":301.6000003814697,"secureConnectionStart":156.9000005722046},{"duration":147.69999980926514,"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":157.10000038146973,"connectEnd":157.10000038146973,"connectStart":157.10000038146973,"domainLookupEnd":157.10000038146973,"domainLookupStart":157.10000038146973,"fetchStart":157.10000038146973,"redirectEnd":0,"redirectStart":0,"requestStart":157.10000038146973,"responseEnd":304.80000019073486,"responseStart":304.80000019073486,"secureConnectionStart":157.10000038146973},{"duration":148.10000038146973,"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":157.30000019073486,"connectEnd":157.30000019073486,"connectStart":157.30000019073486,"domainLookupEnd":157.30000019073486,"domainLookupStart":157.30000019073486,"fetchStart":157.30000019073486,"redirectEnd":0,"redirectStart":0,"requestStart":157.30000019073486,"responseEnd":305.4000005722046,"responseStart":305.4000005722046,"secureConnectionStart":157.30000019073486},{"duration":148.30000019073486,"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":157.4000005722046,"connectEnd":157.4000005722046,"connectStart":157.4000005722046,"domainLookupEnd":157.4000005722046,"domainLookupStart":157.4000005722046,"fetchStart":157.4000005722046,"redirectEnd":0,"redirectStart":0,"requestStart":157.4000005722046,"responseEnd":305.70000076293945,"responseStart":305.70000076293945,"secureConnectionStart":157.4000005722046},{"duration":148.5,"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":157.60000038146973,"connectEnd":157.60000038146973,"connectStart":157.60000038146973,"domainLookupEnd":157.60000038146973,"domainLookupStart":157.60000038146973,"fetchStart":157.60000038146973,"redirectEnd":0,"redirectStart":0,"requestStart":157.60000038146973,"responseEnd":306.1000003814697,"responseStart":306.1000003814697,"secureConnectionStart":157.60000038146973},{"duration":148.69999980926514,"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":157.80000019073486,"connectEnd":157.80000019073486,"connectStart":157.80000019073486,"domainLookupEnd":157.80000019073486,"domainLookupStart":157.80000019073486,"fetchStart":157.80000019073486,"redirectEnd":0,"redirectStart":0,"requestStart":157.80000019073486,"responseEnd":306.5,"responseStart":306.5,"secureConnectionStart":157.80000019073486},{"duration":256.80000019073486,"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":158,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":158,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":414.80000019073486,"responseStart":0,"secureConnectionStart":0},{"duration":148.79999923706055,"initiatorType":"script","name":"https://jira.workterra.net/rest/api/1.0/shortcuts/805012/9b4bc78b7cc5c86b31ff012e5c329c28/shortcuts.js?context=issuenavigation&context=issueaction","startTime":158.20000076293945,"connectEnd":158.20000076293945,"connectStart":158.20000076293945,"domainLookupEnd":158.20000076293945,"domainLookupStart":158.20000076293945,"fetchStart":158.20000076293945,"redirectEnd":0,"redirectStart":0,"requestStart":158.20000076293945,"responseEnd":307,"responseStart":307,"secureConnectionStart":158.20000076293945},{"duration":256.5999994277954,"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":158.4000005722046,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":158.4000005722046,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":415,"responseStart":0,"secureConnectionStart":0},{"duration":149,"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":158.5,"connectEnd":158.5,"connectStart":158.5,"domainLookupEnd":158.5,"domainLookupStart":158.5,"fetchStart":158.5,"redirectEnd":0,"redirectStart":0,"requestStart":158.5,"responseEnd":307.5,"responseStart":307.5,"secureConnectionStart":158.5}],"threshold":1000,"fetchStart":0,"domainLookupStart":0,"domainLookupEnd":0,"connectStart":0,"connectEnd":0,"requestStart":82,"responseStart":149,"responseEnd":150,"domLoading":153,"domInteractive":1032,"domContentLoadedEventStart":1032,"domContentLoadedEventEnd":1091,"domComplete":1307,"loadEventStart":1307,"loadEventEnd":1309,"userAgent":"Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)","marks":[],"measures":[],"correlationId":"8cd188ee0cabd1","effectiveType":"4g","downlink":9.5,"rtt":0,"serverDuration":47,"dbReadsTimeInMs":3,"dbConnsTimeInMs":3,"applicationHash":"156decd7d2b4272533aa6cefc8294af635e1da97","experiments":[]}}
DB queries on DMS DB server were running slow, because of high CPU utilization. CPU utilization was coming from communication DB server. I was able to fix it by adding an index.