-
Type:
Bug
-
Status:
Closed
-
Priority:
Critical
-
Resolution:
Done
-
Affects Version/s:
None
-
Fix Version/s:
None
-
-
-
-
-
-
Item State:
Production Complete
- Closed
-
Issue Importance:
Must Have
At the time of updating SP's to make it consistent with Drop and Create syntax some of the SP's got overwritten. Its happened on 20-July-2016.
{"report":{"apdex":1,"isInitial":true,"journeyId":"45f1cc3a-c686-45b1-946e-954ee0555f66","key":"jira.project.issue.view-issue","navigationType":0,"readyForUser":943.3000000715256,"redirectCount":0,"resourceLoadedEnd":750.1000000238419,"resourceLoadedStart":235.30000007152557,"resourceTiming":[{"duration":296.6999999284744,"initiatorType":"link","name":"https://jira.workterra.net/s/3003653444a1e1a85555cab7dcfb3a21-CDN/-w431t5/805012/9a9e1fae3639050b38ac467c3aa37e79/2e46d90b5cae895c9c38649c9d510130/_/download/contextbatch/css/_super/batch.css","startTime":235.30000007152557,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":235.30000007152557,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":532,"responseStart":0,"secureConnectionStart":0},{"duration":296.60000002384186,"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":235.5,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":235.5,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":532.1000000238419,"responseStart":0,"secureConnectionStart":0},{"duration":296.60000002384186,"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":235.60000002384186,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":235.60000002384186,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":532.2000000476837,"responseStart":0,"secureConnectionStart":0},{"duration":296.60000002384186,"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":235.70000004768372,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":235.70000004768372,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":532.3000000715256,"responseStart":0,"secureConnectionStart":0},{"duration":296.59999990463257,"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":235.80000007152557,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":235.80000007152557,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":532.3999999761581,"responseStart":0,"secureConnectionStart":0},{"duration":306.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":235.89999997615814,"connectEnd":235.89999997615814,"connectStart":235.89999997615814,"domainLookupEnd":235.89999997615814,"domainLookupStart":235.89999997615814,"fetchStart":235.89999997615814,"redirectEnd":0,"redirectStart":0,"requestStart":235.89999997615814,"responseEnd":542.1000000238419,"responseStart":542.1000000238419,"secureConnectionStart":235.89999997615814},{"duration":327.7000000476837,"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":236.10000002384186,"connectEnd":236.10000002384186,"connectStart":236.10000002384186,"domainLookupEnd":236.10000002384186,"domainLookupStart":236.10000002384186,"fetchStart":236.10000002384186,"redirectEnd":0,"redirectStart":0,"requestStart":236.10000002384186,"responseEnd":563.8000000715256,"responseStart":563.8000000715256,"secureConnectionStart":236.10000002384186},{"duration":330.6999999284744,"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":236.20000004768372,"connectEnd":236.20000004768372,"connectStart":236.20000004768372,"domainLookupEnd":236.20000004768372,"domainLookupStart":236.20000004768372,"fetchStart":236.20000004768372,"redirectEnd":0,"redirectStart":0,"requestStart":236.20000004768372,"responseEnd":566.8999999761581,"responseStart":566.8999999761581,"secureConnectionStart":236.20000004768372},{"duration":331.1999999284744,"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":236.20000004768372,"connectEnd":236.20000004768372,"connectStart":236.20000004768372,"domainLookupEnd":236.20000004768372,"domainLookupStart":236.20000004768372,"fetchStart":236.20000004768372,"redirectEnd":0,"redirectStart":0,"requestStart":236.20000004768372,"responseEnd":567.3999999761581,"responseStart":567.3999999761581,"secureConnectionStart":236.20000004768372},{"duration":331.2000000476837,"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":236.5,"connectEnd":236.5,"connectStart":236.5,"domainLookupEnd":236.5,"domainLookupStart":236.5,"fetchStart":236.5,"redirectEnd":0,"redirectStart":0,"requestStart":236.5,"responseEnd":567.7000000476837,"responseStart":567.7000000476837,"secureConnectionStart":236.5},{"duration":331.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":236.5,"connectEnd":236.5,"connectStart":236.5,"domainLookupEnd":236.5,"domainLookupStart":236.5,"fetchStart":236.5,"redirectEnd":0,"redirectStart":0,"requestStart":236.5,"responseEnd":568,"responseStart":568,"secureConnectionStart":236.5},{"duration":331.6999999284744,"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":236.70000004768372,"connectEnd":236.70000004768372,"connectStart":236.70000004768372,"domainLookupEnd":236.70000004768372,"domainLookupStart":236.70000004768372,"fetchStart":236.70000004768372,"redirectEnd":0,"redirectStart":0,"requestStart":236.70000004768372,"responseEnd":568.3999999761581,"responseStart":568.3999999761581,"secureConnectionStart":236.70000004768372},{"duration":331.89999997615814,"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":236.80000007152557,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":236.80000007152557,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":568.7000000476837,"responseStart":0,"secureConnectionStart":0},{"duration":332.2000000476837,"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":236.89999997615814,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":236.89999997615814,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":569.1000000238419,"responseStart":0,"secureConnectionStart":0},{"duration":331.90000009536743,"initiatorType":"script","name":"https://jira.workterra.net/rest/api/1.0/shortcuts/805012/d86515d5f85e345261e03597bd3941f3/shortcuts.js?context=issuenavigation&context=issueaction","startTime":236.89999997615814,"connectEnd":236.89999997615814,"connectStart":236.89999997615814,"domainLookupEnd":236.89999997615814,"domainLookupStart":236.89999997615814,"fetchStart":236.89999997615814,"redirectEnd":0,"redirectStart":0,"requestStart":236.89999997615814,"responseEnd":568.8000000715256,"responseStart":568.8000000715256,"secureConnectionStart":236.89999997615814},{"duration":332.2000000476837,"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":237.10000002384186,"connectEnd":237.10000002384186,"connectStart":237.10000002384186,"domainLookupEnd":237.10000002384186,"domainLookupStart":237.10000002384186,"fetchStart":237.10000002384186,"redirectEnd":0,"redirectStart":0,"requestStart":237.10000002384186,"responseEnd":569.3000000715256,"responseStart":569.3000000715256,"secureConnectionStart":237.10000002384186},{"duration":511.6999999284744,"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":237.70000004768372,"connectEnd":237.70000004768372,"connectStart":237.70000004768372,"domainLookupEnd":237.70000004768372,"domainLookupStart":237.70000004768372,"fetchStart":237.70000004768372,"redirectEnd":0,"redirectStart":0,"requestStart":237.70000004768372,"responseEnd":749.3999999761581,"responseStart":749.3999999761581,"secureConnectionStart":237.70000004768372},{"duration":512.2999999523163,"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":237.80000007152557,"connectEnd":237.80000007152557,"connectStart":237.80000007152557,"domainLookupEnd":237.80000007152557,"domainLookupStart":237.80000007152557,"fetchStart":237.80000007152557,"redirectEnd":0,"redirectStart":0,"requestStart":237.80000007152557,"responseEnd":750.1000000238419,"responseStart":750.1000000238419,"secureConnectionStart":237.80000007152557}],"threshold":1000,"fetchStart":0,"domainLookupStart":0,"domainLookupEnd":0,"connectStart":0,"connectEnd":0,"requestStart":118,"responseStart":229,"responseEnd":230,"domLoading":232,"domInteractive":1002,"domContentLoadedEventStart":1003,"domContentLoadedEventEnd":1069,"domComplete":1741,"loadEventStart":1741,"loadEventEnd":1743,"userAgent":"Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)","marks":[],"measures":[],"correlationId":"84f1150178d9a4","effectiveType":"4g","downlink":9.3,"rtt":0,"serverDuration":78,"dbReadsTimeInMs":20,"dbConnsTimeInMs":28,"applicationHash":"156decd7d2b4272533aa6cefc8294af635e1da97","experiments":[]}}
Hi Indraprakash Tiwari,
Please use this as Parent ticket for all the SP's. I have modified dbo.OES_SP_InsertUpdate_AdminUser.StoredProcedure and OES_SP_InsertUpdate_SystemUser and checked-in into LB