-
Type:
Support Activity
-
Status:
Resolved
-
Priority:
High
-
Resolution:
Done
-
Affects Version/s:
None
-
Fix Version/s:
None
-
-
-
Support Task Type:
Configuration
-
-
-
-
Module:
BenAdmin
- Export
-
Template Name: Blackout Manual Template (DHS)
Following is the Error log while exporting the template.
ErrorID : 0
ErrorSource : ControllerAppTier.Save->WORKTERRAControllerAppTier.Save->ExecuteExportDTS.ExportData_Isolated->ExecuteExportDTS.ExportData
ErrorMessage: One or more errors occurred. -> There is no row at position 0.
CC-Ganesh Sadawarte, Vinayak Kulkarni
{"report":{"apdex":1,"isInitial":true,"journeyId":"ecdd5210-efc2-4618-af38-a4244c078913","key":"jira.project.issue.view-issue","navigationType":0,"readyForUser":757.5999999046326,"redirectCount":0,"resourceLoadedEnd":974,"resourceLoadedStart":168.59999990463257,"resourceTiming":[{"duration":197.90000009536743,"initiatorType":"link","name":"https://jira.workterra.net/s/3003653444a1e1a85555cab7dcfb3a21-CDN/-w431t5/805012/9a9e1fae3639050b38ac467c3aa37e79/2e46d90b5cae895c9c38649c9d510130/_/download/contextbatch/css/_super/batch.css","startTime":168.59999990463257,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":168.59999990463257,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":366.5,"responseStart":0,"secureConnectionStart":0},{"duration":197.70000004768372,"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":168.89999985694885,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":168.89999985694885,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":366.59999990463257,"responseStart":0,"secureConnectionStart":0},{"duration":197.59999990463257,"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":169,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":169,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":366.59999990463257,"responseStart":0,"secureConnectionStart":0},{"duration":197.59999990463257,"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":169.09999990463257,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":169.09999990463257,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":366.69999980926514,"responseStart":0,"secureConnectionStart":0},{"duration":197.60000014305115,"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":169.19999980926514,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":169.19999980926514,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":366.7999999523163,"responseStart":0,"secureConnectionStart":0},{"duration":206.79999995231628,"initiatorType":"script","name":"https://jira.workterra.net/s/f2623af22c15df767ec6ff268ae0b8bd-CDN/-w431t5/805012/9a9e1fae3639050b38ac467c3aa37e79/2e46d90b5cae895c9c38649c9d510130/_/download/contextbatch/js/_super/batch.js?locale=en-US","startTime":169.29999995231628,"connectEnd":169.29999995231628,"connectStart":169.29999995231628,"domainLookupEnd":169.29999995231628,"domainLookupStart":169.29999995231628,"fetchStart":169.29999995231628,"redirectEnd":0,"redirectStart":0,"requestStart":169.29999995231628,"responseEnd":376.09999990463257,"responseStart":376,"secureConnectionStart":169.29999995231628},{"duration":250,"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":169.39999985694885,"connectEnd":169.39999985694885,"connectStart":169.39999985694885,"domainLookupEnd":169.39999985694885,"domainLookupStart":169.39999985694885,"fetchStart":169.39999985694885,"redirectEnd":0,"redirectStart":0,"requestStart":169.39999985694885,"responseEnd":419.39999985694885,"responseStart":419.39999985694885,"secureConnectionStart":169.39999985694885},{"duration":253.19999980926514,"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":169.5,"connectEnd":169.5,"connectStart":169.5,"domainLookupEnd":169.5,"domainLookupStart":169.5,"fetchStart":169.5,"redirectEnd":0,"redirectStart":0,"requestStart":169.5,"responseEnd":422.69999980926514,"responseStart":422.69999980926514,"secureConnectionStart":169.5},{"duration":253.59999990463257,"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":169.59999990463257,"connectEnd":169.59999990463257,"connectStart":169.59999990463257,"domainLookupEnd":169.59999990463257,"domainLookupStart":169.59999990463257,"fetchStart":169.59999990463257,"redirectEnd":0,"redirectStart":0,"requestStart":169.59999990463257,"responseEnd":423.19999980926514,"responseStart":423.19999980926514,"secureConnectionStart":169.59999990463257},{"duration":253.79999995231628,"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":169.79999995231628,"connectEnd":169.79999995231628,"connectStart":169.79999995231628,"domainLookupEnd":169.79999995231628,"domainLookupStart":169.79999995231628,"fetchStart":169.79999995231628,"redirectEnd":0,"redirectStart":0,"requestStart":169.79999995231628,"responseEnd":423.59999990463257,"responseStart":423.59999990463257,"secureConnectionStart":169.79999995231628},{"duration":254,"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":170,"connectEnd":170,"connectStart":170,"domainLookupEnd":170,"domainLookupStart":170,"fetchStart":170,"redirectEnd":0,"redirectStart":0,"requestStart":170,"responseEnd":424,"responseStart":424,"secureConnectionStart":170},{"duration":254.29999995231628,"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":170,"connectEnd":170,"connectStart":170,"domainLookupEnd":170,"domainLookupStart":170,"fetchStart":170,"redirectEnd":0,"redirectStart":0,"requestStart":170,"responseEnd":424.2999999523163,"responseStart":424.2999999523163,"secureConnectionStart":170},{"duration":254.60000014305115,"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":170.19999980926514,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":170.19999980926514,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":424.7999999523163,"responseStart":0,"secureConnectionStart":0},{"duration":254.89999985694885,"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":170.29999995231628,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":170.29999995231628,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":425.19999980926514,"responseStart":0,"secureConnectionStart":0},{"duration":254.5,"initiatorType":"script","name":"https://jira.workterra.net/rest/api/1.0/shortcuts/805012/81da1c7492d7ee698ae1cc31902498d9/shortcuts.js?context=issuenavigation&context=issueaction","startTime":170.29999995231628,"connectEnd":170.29999995231628,"connectStart":170.29999995231628,"domainLookupEnd":170.29999995231628,"domainLookupStart":170.29999995231628,"fetchStart":170.29999995231628,"redirectEnd":0,"redirectStart":0,"requestStart":170.29999995231628,"responseEnd":424.7999999523163,"responseStart":424.7999999523163,"secureConnectionStart":170.29999995231628},{"duration":254.89999985694885,"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":170.5,"connectEnd":170.5,"connectStart":170.5,"domainLookupEnd":170.5,"domainLookupStart":170.5,"fetchStart":170.5,"redirectEnd":0,"redirectStart":0,"requestStart":170.5,"responseEnd":425.39999985694885,"responseStart":425.2999999523163,"secureConnectionStart":170.5}],"threshold":1000,"fetchStart":0,"domainLookupStart":0,"domainLookupEnd":0,"connectStart":0,"connectEnd":0,"requestStart":69,"responseStart":163,"responseEnd":164,"domLoading":166,"domInteractive":1001,"domContentLoadedEventStart":1001,"domContentLoadedEventEnd":1041,"domComplete":1335,"loadEventStart":1335,"loadEventEnd":1337,"userAgent":"Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)","marks":[],"measures":[],"correlationId":"9a62a3b79a4694","effectiveType":"4g","downlink":9.5,"rtt":0,"serverDuration":62,"dbReadsTimeInMs":12,"dbConnsTimeInMs":14,"applicationHash":"156decd7d2b4272533aa6cefc8294af635e1da97","experiments":[]}}
Hi Vinayak Kulkarni,
We have checked this and found that on Employee, Spouse and Child SubTemplate Enrollment Provider Name Field is mapped and on Template information screen in Provider Dropdown All Provider is selected as attached
, So While exporting Provider ID is passed as null, For which 0 is selected in Query and that 0 is used to fetch the Provider name from Provider table but no Rows are present against the Provider ID 0, Because of this mentioned error is logged while exporting the template.
Please suggest the respective Approach from following
1)Can we take this for code change(Should Consider All Provider ID if All selected).
2)Handle this by customization(Provider ID needs to select on template).
CC - Ganesh Sadawarte