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

            Ascending order - Click to sort in descending order
            kunal.kedari Kunal Kedari (Inactive) created issue -
            kunal.kedari Kunal Kedari (Inactive) made changes -
            Field Original Value New Value
            Assignee Sujit Chopade [ sujit.chopade ] Harshawardhan Phalake [ harshawardhan ]
            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.
            harshawardhan Harshawardhan Phalake (Inactive) made changes -
            Status Open [ 1 ] In Development [ 10007 ]
            harshawardhan Harshawardhan Phalake (Inactive) made changes -
            Status In Development [ 10007 ] Local Testing [ 10200 ]
            harshawardhan Harshawardhan Phalake (Inactive) made changes -
            Item State Parent values: LB QA(10201) Parent values: LB QA(10201)Level 1 values: LB Deployed(11600)
            harshawardhan Harshawardhan Phalake (Inactive) made changes -
            Assignee Harshawardhan Phalake [ harshawardhan ] Kunal Kedari [ kunal.kedari ]
            satyap Satya made changes -
            Issue Importance Can Wait [ 11801 ]
            rakeshr Rakesh Roy (Inactive) made changes -
            Item State Parent values: LB QA(10201)Level 1 values: LB Deployed(11600) Parent values: LB QA(10201)Level 1 values: On Hold(10211)
            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
            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.
            rakeshr Rakesh Roy (Inactive) made changes -
            Status Local Testing [ 10200 ] Stage Testing [ 10201 ]
            rakeshr Rakesh Roy (Inactive) made changes -
            Item State Parent values: LB QA(10201)Level 1 values: On Hold(10211) Parent values: Stage QA(10202)Level 1 values: Stage Deployed(11602)
            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)
            kunal.kedari Kunal Kedari (Inactive) made changes -
            Item State Parent values: Stage QA(10202)Level 1 values: Stage Deployed(11602) Parent values: Stage QA(10202)Level 1 values: Re-open(10216)
            QA Kunal Kedari [ kunal.kedari ]
            kunal.kedari Kunal Kedari (Inactive) made changes -
            Resolution Unresolved [ 10200 ]
            Status Stage Testing [ 10201 ] Reopen in Stage [ 10023 ]
            kunal.kedari Kunal Kedari (Inactive) made changes -
            Assignee Kunal Kedari [ kunal.kedari ] Harshawardhan Phalake [ harshawardhan ]
            kunal.kedari Kunal Kedari (Inactive) made changes -
            Link This issue relates to WT-1478 [ WT-1478 ]
            satyap Satya made changes -
            Environment_New LB [ 18444 ]
            Transition Time In Source Status Execution Times
            Harshawardhan Phalake (Inactive) made transition -
            Open In Development
            		8d 23h 32m 1
            Harshawardhan Phalake (Inactive) made transition -
            In Development In LB Testing
            		7s 1
            Rakesh Roy (Inactive) made transition -
            In LB Testing Stage Testing
            		121d 20h 49m 1
            Kunal Kedari (Inactive) made transition -
            Stage Testing Reopened in Stage
            		4d 1h 40m 1

              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: