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

            Activity

            Hide
            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.
            Hide
            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
            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
            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)

              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: