Details

    • 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

      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.

      CC-Ganesh Sadawarte, Vinayak Kulkarni

        Attachments

          Activity

          Hide
          rakesh.shahane Rakesh Shahane (Inactive) added a comment -

          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

          Show
          rakesh.shahane Rakesh Shahane (Inactive) added a comment - 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
          Hide
          Vinayak.Kulkarni Vinayak Kulkarni (Inactive) added a comment -

          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.

          Show
          Vinayak.Kulkarni Vinayak Kulkarni (Inactive) added a comment - 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.

            People

            Assignee:
            rakesh.shahane Rakesh Shahane (Inactive)
            Reporter:
            rakesh.shahane Rakesh Shahane (Inactive)
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

              Dates

              Created:
              Updated:
              Resolved:

                Time Tracking

                Estimated:
                Original Estimate - 6h Original Estimate - 6h
                6h
                Remaining:
                Remaining Estimate - 0h
                0h
                Logged:
                Time Spent - 8h 5m
                8h 5m