-
-
-
-
-
-
Item State:
Stage QA
- Production Deployment on Hold
Unable to delete plan "PreProd test" on MATT getting below server error.
ErrorID : 0
ErrorSource : ControllerAppTier.Delete->BenAdminControllerAppTier.Delete->BenefitPlanDesign.Delete->BenefitPlanDesign.DeleteBenefitPlanDesign
ErrorMessage: The DELETE statement conflicted with the REFERENCE constraint "FK_ContingentEligibilityRules_PlanDesign". The conflict occurred in database "MATT_11878", table "dbo.ContingentEligibilityRules", column 'PlanDesignID'.
The statement has been terminated.
------------------------------------------------------------------
CC: Mandar Kulkarni, Satya, Prasad Patil, Rakesh Roy
- relates to
-
NF-5195
Preprod build deployment
-
-
Open
{"report":{"apdex":1,"isInitial":true,"journeyId":"dce1443d-8f43-440e-9fdc-7524f7cf3fea","key":"jira.project.issue.view-issue","navigationType":0,"readyForUser":829.2999997138977,"redirectCount":0,"resourceLoadedEnd":582.2999997138977,"resourceLoadedStart":248.7999997138977,"resourceTiming":[{"duration":4.900000095367432,"initiatorType":"link","name":"https://jira.workterra.net/s/3003653444a1e1a85555cab7dcfb3a21-CDN/-w431t5/805012/9a9e1fae3639050b38ac467c3aa37e79/2e46d90b5cae895c9c38649c9d510130/_/download/contextbatch/css/_super/batch.css","startTime":248.7999997138977,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":248.7999997138977,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":253.69999980926514,"responseStart":0,"secureConnectionStart":0},{"duration":4.800000190734863,"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":249.09999990463257,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":249.09999990463257,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":253.90000009536743,"responseStart":0,"secureConnectionStart":0},{"duration":5.099999904632568,"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":249.19999980926514,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":249.19999980926514,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":254.2999997138977,"responseStart":0,"secureConnectionStart":0},{"duration":5.400000095367432,"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":249.2999997138977,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":249.2999997138977,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":254.69999980926514,"responseStart":0,"secureConnectionStart":0},{"duration":5.899999618530273,"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":249.40000009536743,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":249.40000009536743,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":255.2999997138977,"responseStart":0,"secureConnectionStart":0},{"duration":219.09999990463257,"initiatorType":"script","name":"https://jira.workterra.net/s/f2623af22c15df767ec6ff268ae0b8bd-CDN/-w431t5/805012/9a9e1fae3639050b38ac467c3aa37e79/2e46d90b5cae895c9c38649c9d510130/_/download/contextbatch/js/_super/batch.js?locale=en-US","startTime":249.59999990463257,"connectEnd":249.59999990463257,"connectStart":249.59999990463257,"domainLookupEnd":249.59999990463257,"domainLookupStart":249.59999990463257,"fetchStart":249.59999990463257,"redirectEnd":0,"redirectStart":0,"requestStart":257.69999980926514,"responseEnd":468.69999980926514,"responseStart":364.5,"secureConnectionStart":249.59999990463257},{"duration":332.09999990463257,"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":250.19999980926514,"connectEnd":250.19999980926514,"connectStart":250.19999980926514,"domainLookupEnd":250.19999980926514,"domainLookupStart":250.19999980926514,"fetchStart":250.19999980926514,"redirectEnd":0,"redirectStart":0,"requestStart":258.5,"responseEnd":582.2999997138977,"responseStart":356.7999997138977,"secureConnectionStart":250.19999980926514},{"duration":160.89999961853027,"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":250.40000009536743,"connectEnd":250.40000009536743,"connectStart":250.40000009536743,"domainLookupEnd":250.40000009536743,"domainLookupStart":250.40000009536743,"fetchStart":250.40000009536743,"redirectEnd":0,"redirectStart":0,"requestStart":259.59999990463257,"responseEnd":411.2999997138977,"responseStart":410.40000009536743,"secureConnectionStart":250.40000009536743},{"duration":104.09999990463257,"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":250.5,"connectEnd":250.5,"connectStart":250.5,"domainLookupEnd":250.5,"domainLookupStart":250.5,"fetchStart":250.5,"redirectEnd":0,"redirectStart":0,"requestStart":261.19999980926514,"responseEnd":354.59999990463257,"responseStart":354,"secureConnectionStart":250.5},{"duration":161.40000009536743,"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":250.59999990463257,"connectEnd":250.59999990463257,"connectStart":250.59999990463257,"domainLookupEnd":250.59999990463257,"domainLookupStart":250.59999990463257,"fetchStart":250.59999990463257,"redirectEnd":0,"redirectStart":0,"requestStart":262.19999980926514,"responseEnd":412,"responseStart":411.40000009536743,"secureConnectionStart":250.59999990463257},{"duration":103.30000019073486,"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":250.69999980926514,"connectEnd":250.69999980926514,"connectStart":250.69999980926514,"domainLookupEnd":250.69999980926514,"domainLookupStart":250.69999980926514,"fetchStart":250.69999980926514,"redirectEnd":0,"redirectStart":0,"requestStart":263.19999980926514,"responseEnd":354,"responseStart":353.19999980926514,"secureConnectionStart":250.69999980926514},{"duration":106.09999990463257,"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":250.69999980926514,"connectEnd":250.69999980926514,"connectStart":250.69999980926514,"domainLookupEnd":250.69999980926514,"domainLookupStart":250.69999980926514,"fetchStart":250.69999980926514,"redirectEnd":0,"redirectStart":0,"requestStart":262.7999997138977,"responseEnd":356.7999997138977,"responseStart":356.19999980926514,"secureConnectionStart":250.69999980926514},{"duration":12.5,"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":250.7999997138977,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":250.7999997138977,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":263.2999997138977,"responseStart":0,"secureConnectionStart":0},{"duration":104.5,"initiatorType":"script","name":"https://jira.workterra.net/rest/api/1.0/shortcuts/805012/81da1c7492d7ee698ae1cc31902498d9/shortcuts.js?context=issuenavigation&context=issueaction","startTime":250.90000009536743,"connectEnd":250.90000009536743,"connectStart":250.90000009536743,"domainLookupEnd":250.90000009536743,"domainLookupStart":250.90000009536743,"fetchStart":250.90000009536743,"redirectEnd":0,"redirectStart":0,"requestStart":265.09999990463257,"responseEnd":355.40000009536743,"responseStart":354.69999980926514,"secureConnectionStart":250.90000009536743},{"duration":13.699999809265137,"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":251.09999990463257,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":251.09999990463257,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":264.7999997138977,"responseStart":0,"secureConnectionStart":0},{"duration":104.90000009536743,"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":251.09999990463257,"connectEnd":251.09999990463257,"connectStart":251.09999990463257,"domainLookupEnd":251.09999990463257,"domainLookupStart":251.09999990463257,"fetchStart":251.09999990463257,"redirectEnd":0,"redirectStart":0,"requestStart":267.09999990463257,"responseEnd":356,"responseStart":355.5,"secureConnectionStart":251.09999990463257},{"duration":88.7000002861023,"initiatorType":"script","name":"https://jira.workterra.net/s/d41d8cd98f00b204e9800998ecf8427e-CDN/-w431t5/805012/9a9e1fae3639050b38ac467c3aa37e79/1.0/_/download/batch/jira.webresources:bigpipe-js/jira.webresources:bigpipe-js.js","startTime":274.69999980926514,"connectEnd":274.69999980926514,"connectStart":274.69999980926514,"domainLookupEnd":274.69999980926514,"domainLookupStart":274.69999980926514,"fetchStart":274.69999980926514,"redirectEnd":0,"redirectStart":0,"requestStart":281.19999980926514,"responseEnd":363.40000009536743,"responseStart":363,"secureConnectionStart":274.69999980926514},{"duration":88.2000002861023,"initiatorType":"script","name":"https://jira.workterra.net/s/d41d8cd98f00b204e9800998ecf8427e-CDN/-w431t5/805012/9a9e1fae3639050b38ac467c3aa37e79/1.0/_/download/batch/jira.webresources:bigpipe-init/jira.webresources:bigpipe-init.js","startTime":274.69999980926514,"connectEnd":274.69999980926514,"connectStart":274.69999980926514,"domainLookupEnd":274.69999980926514,"domainLookupStart":274.69999980926514,"fetchStart":274.69999980926514,"redirectEnd":0,"redirectStart":0,"requestStart":281.2999997138977,"responseEnd":362.90000009536743,"responseStart":362.19999980926514,"secureConnectionStart":274.69999980926514},{"duration":78,"initiatorType":"xmlhttprequest","name":"https://jira.workterra.net/rest/webResources/1.0/resources","startTime":608.2999997138977,"connectEnd":608.2999997138977,"connectStart":608.2999997138977,"domainLookupEnd":608.2999997138977,"domainLookupStart":608.2999997138977,"fetchStart":608.2999997138977,"redirectEnd":0,"redirectStart":0,"requestStart":625.6999998092651,"responseEnd":686.2999997138977,"responseStart":685.2999997138977,"secureConnectionStart":608.2999997138977}],"threshold":1000,"fetchStart":0,"domainLookupStart":24,"domainLookupEnd":73,"connectStart":73,"connectEnd":135,"secureConnectionStart":105,"requestStart":140,"responseStart":220,"responseEnd":273,"domLoading":224,"domInteractive":884,"domContentLoadedEventStart":884,"domContentLoadedEventEnd":932,"domComplete":1162,"loadEventStart":1162,"loadEventEnd":1164,"userAgent":"Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)","marks":[],"measures":[],"correlationId":"a466353ffb70f3","effectiveType":"4g","downlink":10,"rtt":0,"serverDuration":47,"dbReadsTimeInMs":5,"dbConnsTimeInMs":6,"applicationHash":"156decd7d2b4272533aa6cefc8294af635e1da97","experiments":[]}}
Bug
Hi Sumeet.Kolge
NF-5459Issue resolved. Please verify after next build.Thanks,
Mukund P