-
Type:
Support Activity
-
Status: Resolved
-
Priority:
High
-
Resolution: Done
-
Affects Version/s: None
-
Fix Version/s: None
-
Component/s: BenAdmin
-
Labels:
-
Support Task Type:Configuration
-
Environment:Production
-
Reported by:Harbinger
-
Company:St Rose
-
Module:BenAdmin - Export
-
Severity:Simple
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.
| Field | Original Value | New Value |
|---|---|---|
| Labels | Manual_Export |
| Description |
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. |
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] |
| Status | Open [ 1 ] | In Progress [ 3 ] |
| Attachment | TemplateInformation.jpg [ 70454 ] |
Hi Rakesh,
Error is not due to Enrollment provider name, see implementation of this fields ( select query), it doesn't look for provider selected on template.
The error was with other field related to provider ( provider group number ), that's from provider page and causing issues.
I have un-mapped it and re-sent the file. Please do not work on this or take this ahead. Thanks.
| Resolution | Done [ 10000 ] | |
| Status | In Progress [ 3 ] | Resolved [ 5 ] |
| Remaining Estimate | 6h [ 21600 ] | |
| Original Estimate | 6h [ 21600 ] |
| Remaining Estimate | 6h [ 21600 ] | 4h [ 14400 ] |
| Time Spent | 2h [ 7200 ] | |
| Worklog Id | 97558 [ 97558 ] |
| Remaining Estimate | 4h [ 14400 ] | 0h [ 0 ] |
| Time Spent | 2h [ 7200 ] | 6h 5m [ 21959 ] |
| Worklog Id | 97559 [ 97559 ] |
| Time Spent | 6h 5m [ 21959 ] | 8h 5m [ 29159 ] |
| Worklog Id | 98966 [ 98966 ] |
| Transition | Time In Source Status | Execution Times |
|---|
|
2m 23s | 1 |
|
1d 28m | 1 |
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