WORKTERRAProject Type: software

WORKTERRA

Uploaded image for project: 'WORKTERRA'
  1. WORKTERRA
  2. WT-1669

WT -> SEO -> Import New Rates ->Error while importing a rate with "Cobra Rate" set to Yes.

    Details

    • Type: Bug
    • Status: Reopened in Stage
    • Priority: Medium
    • Resolution: Unresolved
    • Affects Version/s: None
    • Fix Version/s: None
    • Component/s: Xpress
    • Labels:
      None
    • Environment:
      QA
    • Module:
      Xpress
    • Reported by:
      Harbinger
    • Item State:
      Stage QA - Re-open
    • Issue Importance:
      Can Wait

      Description

      1] Login to the application on local environment using following URL:
      https://wt-stage.harbinger.in
      2] From Home page search and select a company for which testing needs to be carried out using "Search Company" section.
      3] Click on "Ben Admin" menu.
      4] Click on "Customizer" icon from left navigation menu.
      5] Click on "Rates" link which is submenu of "Customizer", user gets navigate to "Rates" details page.
      6] Click on "Import" button displaying at top right hand side of the "Rates" page, the "Rate Import" window gets poped up, click on “Add New Rate” tab.
      7] Download "Health" template from benefit template dropdown.
      8] Set COBRA rate value to Yes in the excel sheet.
      9] Upload and try to import this rate.

      Actual Result:
      Error pop up "Server encountered an internal error....." is displaying.
      Expected Result:
      Rate should be get imported without any error when COBRA Rate value is set to Yes.
      Refer attached screenshot for more details.

        Attachments

          Issue Links

          relates to

          Enhancement - An improvement or enhancement to an existing feature or task. WT-1478 SEO -> Import Rate (Self Insured Rate)

          • Medium - Has the potential to affect progress.
          • Resolution Setting

            Activity

            Descending order - Click to sort in ascending order
            Hide
            Permalink
            kunal.kedari Kunal Kedari (Inactive) added a comment -

            This issue is reproducible on Stage, hence reopening.
            Error log for Stage:
            ErrorID : 0
            ErrorSource : ControllerAppTier.SaveAndGetData->BenAdminControllerAppTier.SaveAndGetData->RatesImportExportExcel.ImportRatesFromExcel->RatesImportExportExcel.ImportHealthRates->RatesImportExportExcel.ReadStandardRate->RatesImportExportExcel.SaveRatePlanMapping->RatePlanDesignMapping.Save
            ErrorMessage: Incorrect syntax near ')'.
            StackTrace: at WORKTERRA.BenAdmin.BenAdminControllerAppTier.SaveAndGetData(BenAdminControllerWebTierEntity objBenAdminControllerWebTierEntity) in d:\Branches\Stage\App\ControllerAppTier\ControllerAppTier\BenAdminControllerAppTier.cs:line 2531
            at WORKTERRA.ControllerAppTier.SaveAndGetData(Int32 intProjectsId, String strInput) in d:\Branches\Stage\App\ControllerAppTier\ControllerAppTier\ControllerAppTier.svc.cs:line 429
            TargetSite: System.String SaveAndGetData(ValueObjects.BenAdminControllerWebTierEntity)

            Show
            kunal.kedari Kunal Kedari (Inactive) added a comment - This issue is reproducible on Stage, hence reopening. Error log for Stage: ErrorID : 0 ErrorSource : ControllerAppTier.SaveAndGetData->BenAdminControllerAppTier.SaveAndGetData->RatesImportExportExcel.ImportRatesFromExcel->RatesImportExportExcel.ImportHealthRates->RatesImportExportExcel.ReadStandardRate->RatesImportExportExcel.SaveRatePlanMapping->RatePlanDesignMapping.Save ErrorMessage: Incorrect syntax near ')'. StackTrace: at WORKTERRA.BenAdmin.BenAdminControllerAppTier.SaveAndGetData(BenAdminControllerWebTierEntity objBenAdminControllerWebTierEntity) in d:\Branches\Stage\App\ControllerAppTier\ControllerAppTier\BenAdminControllerAppTier.cs:line 2531 at WORKTERRA.ControllerAppTier.SaveAndGetData(Int32 intProjectsId, String strInput) in d:\Branches\Stage\App\ControllerAppTier\ControllerAppTier\ControllerAppTier.svc.cs:line 429 TargetSite: System.String SaveAndGetData(ValueObjects.BenAdminControllerWebTierEntity)
            Hide
            Permalink
            kunal.kedari Kunal Kedari (Inactive) added a comment -

            The fix for this issue will get uploaded to Production with Production build upload.

            Show
            kunal.kedari Kunal Kedari (Inactive) added a comment - The fix for this issue will get uploaded to Production with Production build upload.
            Hide
            Permalink
            kunal.kedari Kunal Kedari (Inactive) added a comment -

            SEO is on hold and we are not working on any enhancement or fix verification related to it.

            Show
            kunal.kedari Kunal Kedari (Inactive) added a comment - SEO is on hold and we are not working on any enhancement or fix verification related to it.
            Hide
            Permalink
            harshawardhan Harshawardhan Phalake (Inactive) added a comment -

            Hi Kunal,
            The above issue Error while importing a rate with "Cobra Rate" set to Yes. is Fixed.
            Concern - Not able to Upload rate if IsCobraRate is set Yes.
            Cause - This issue is due to map the wrong rate to wrong plan.
            Correction- Restrict the user by giving only those plans which are associated with that rate.
            ex- If Rate Template is Life the user can see only Life Plans.

            Show
            harshawardhan Harshawardhan Phalake (Inactive) added a comment - Hi Kunal, The above issue Error while importing a rate with "Cobra Rate" set to Yes. is Fixed. Concern - Not able to Upload rate if IsCobraRate is set Yes. Cause - This issue is due to map the wrong rate to wrong plan. Correction- Restrict the user by giving only those plans which are associated with that rate. ex- If Rate Template is Life the user can see only Life Plans.

              People

              Assignee:
              harshawardhan Harshawardhan Phalake (Inactive)
              Reporter:
              kunal.kedari Kunal Kedari (Inactive)
              QA:
              Kunal Kedari (Inactive)
              Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

                Dates

                Created:
                Updated:
                Resolved: