WORKTERRAProject Type: software

WORKTERRA

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

WT -> Server Error on SA Utility if health tier policy no is of longer length and characters

    Details

    • Type: Bug
    • Status: Closed
    • Priority: Medium
    • Resolution: Done
    • Affects Version/s: None
    • Fix Version/s: None
    • Component/s: BenAdmin
    • Labels:
      None
    • Environment:
      QA
    • Bug Severity:
      Medium
    • Module:
      BenAdmin - Enrollment
    • Reported by:
      Harbinger
    • Item State:
      Production Complete - Closed

      Description

      ZCC company

      • Just to test the max length of health tier policy no - i entered a policy no as 'Alan_Dental-A+ (AA) / W lon policy name for testing the policy max length problem in SA utility server error'
      • employee enrolled in respective plan
      • when I tried recalculating healthcare policy no though SA utility - a server error appeared [it worked well with the smaller length policy nos]

      With the client JIRA WT-7819 we have allowed to put Number, alphanumeric letters (a-z, A-Z, 0-9) with white space and only few special characters like - Plus ( + ), Hypen ( - ) , Rounded Brackets ( ( ) ), Forward Slash ( / ) and Underscore (_) for policy nos

      CC - Prasad Pise Hrishikesh Deshpande Sachin Hingole Rakesh Roy Umesh Kadam

        Attachments

        1. Long Length Ser Err.png
          144 kB
          Alankar Chavan
        2. WT-7902 Affected_Files.txt
          0.5 kB
          Abhilash Warkari
        3. WT-7902 Code Review Checklist.doc
          26 kB
          Abhilash Warkari

          Issue Links

          relates to

          Bug - A problem which impairs or prevents the functions of the product. WT-7031 Max Length validation is not applied in Mapping Name and Policy Number fields of Mapping Details in Plan design health mapping page.

          • Medium - Has the potential to affect progress.
          • Production Complete

          Bug - A problem which impairs or prevents the functions of the product. WT-7819 Production > Sunnyvale School District > Issue with Adding or Changing Health Tier Mapping Value

          • Medium - Has the potential to affect progress.
          • Closed

            Activity

            Ascending order - Click to sort in descending order
            Hide
            Permalink
            alankar.chavan Alankar Chavan (Inactive) added a comment -

            related to WT-7819

            Show
            alankar.chavan Alankar Chavan (Inactive) added a comment - related to WT-7819
            Hide
            Permalink
            alankar.chavan Alankar Chavan (Inactive) added a comment -

            Error Log

            Exception : String or binary data would be truncated.The statement has been terminated.
            App Error Log : ControllerAppTier.Save->BenAdminControllerAppTier.Save->SAUtilityToolBox.Save->PlanDesignHealthTierMapping.HealthTierPolicyNoCalculation->PlanDesignHealthTierMapping.RecalculateHealthTierPolicyNo->PlanDesignHealthTierMapping.UpdatePolicyNo_logValues
            Employee ID : 0
            Action Name : ProcessData
            Model : System.Web.Mvc.HandleErrorInfo
            Controller : Customization
            Web Error Log : at WORKTERRA.BenAdmin.BenAdminControllerWebTier.Save(ObjectType I_objectType, Object objInputObject, Object I_context, Boolean I_mode) in d:\WT\branches\LB\Web\ControllerWebTier\ControllerWebTier\BenAdminControllerWebTier.cs:line 65
            at WORKTERRA.BenAdmin.Areas.Customization.Models.SAUtilityToolboxModel.RecalculateHealthTierPolicy() in d:\WT\branches\LB\Web\Web Projects\BenAdmin\Areas\Customization\Models\SAUtilityToolbox\SAUtilityToolboxModel.cs:line 1673
            at WORKTERRA.BenAdmin.Areas.Customization.Models.SAUtilityToolboxModel.ProcessData() in d:\WT\branches\LB\Web\Web Projects\BenAdmin\Areas\Customization\Models\SAUtilityToolbox\SAUtilityToolboxModel.cs:line 629
            at WORKTERRA.BenAdmin.Areas.Customization.Controllers.CustomizationController.ProcessData(SAUtilityToolboxModel objToolBoxModel) in d:\WT\branches\LB\Web\Web Projects\BenAdmin\Areas\Customization\Controllers\SAUtilityToolbox\SAUtilityToolboxController.cs:line 32
            at lambda_method(Closure , ControllerBase , Object[] )

            Show
            alankar.chavan Alankar Chavan (Inactive) added a comment - Error Log Exception : String or binary data would be truncated.The statement has been terminated. App Error Log : ControllerAppTier.Save->BenAdminControllerAppTier.Save->SAUtilityToolBox.Save->PlanDesignHealthTierMapping.HealthTierPolicyNoCalculation->PlanDesignHealthTierMapping.RecalculateHealthTierPolicyNo->PlanDesignHealthTierMapping.UpdatePolicyNo_logValues Employee ID : 0 Action Name : ProcessData Model : System.Web.Mvc.HandleErrorInfo Controller : Customization Web Error Log : at WORKTERRA.BenAdmin.BenAdminControllerWebTier.Save(ObjectType I_objectType, Object objInputObject, Object I_context, Boolean I_mode) in d:\WT\branches\LB\Web\ControllerWebTier\ControllerWebTier\BenAdminControllerWebTier.cs:line 65 at WORKTERRA.BenAdmin.Areas.Customization.Models.SAUtilityToolboxModel.RecalculateHealthTierPolicy() in d:\WT\branches\LB\Web\Web Projects\BenAdmin\Areas\Customization\Models\SAUtilityToolbox\SAUtilityToolboxModel.cs:line 1673 at WORKTERRA.BenAdmin.Areas.Customization.Models.SAUtilityToolboxModel.ProcessData() in d:\WT\branches\LB\Web\Web Projects\BenAdmin\Areas\Customization\Models\SAUtilityToolbox\SAUtilityToolboxModel.cs:line 629 at WORKTERRA.BenAdmin.Areas.Customization.Controllers.CustomizationController.ProcessData(SAUtilityToolboxModel objToolBoxModel) in d:\WT\branches\LB\Web\Web Projects\BenAdmin\Areas\Customization\Controllers\SAUtilityToolbox\SAUtilityToolboxController.cs:line 32 at lambda_method(Closure , ControllerBase , Object[] )
            Hide
            Permalink
            abhilash.warkari Abhilash Warkari (Inactive) added a comment - - edited

            Hi Alankar Chavan,

            Please find below 3Cs :

            Concern Server Error on SA Utility if health tier policy no is of longer length and characters.
            Cause As per current table structure, lenght of policy number allowed in DB is 50 characters only.
            Hence code to insert / update policy number having length greater than 50 characters is failing.
            Correction We have changed size of a policy number column in a DB to allow length up to 250 characters.
            Impacted Areas
            • Health Tier Plan Design Mapping Screens
            • SA Utility : Policy Number Recalculation

            Thanks and Regards,
            Abhilash Warkari

            CC : Jyoti Mayne, Umesh Kadam, Vinanti Yadav

            Show
            abhilash.warkari Abhilash Warkari (Inactive) added a comment - - edited Hi Alankar Chavan , Please find below 3Cs : Concern Server Error on SA Utility if health tier policy no is of longer length and characters. Cause As per current table structure, lenght of policy number allowed in DB is 50 characters only. Hence code to insert / update policy number having length greater than 50 characters is failing. Correction We have changed size of a policy number column in a DB to allow length up to 250 characters. Impacted Areas Health Tier Plan Design Mapping Screens SA Utility : Policy Number Recalculation Thanks and Regards, Abhilash Warkari CC : Jyoti Mayne , Umesh Kadam , Vinanti Yadav
            Hide
            Permalink
            priya.handepatil Priya Handepatil (Inactive) added a comment -

            As Discussed with Alankar ;
            Assigning this issue to Alankar Chavan

            Show
            priya.handepatil Priya Handepatil (Inactive) added a comment - As Discussed with Alankar ; Assigning this issue to Alankar Chavan
            Hide
            Permalink
            alankar.chavan Alankar Chavan (Inactive) added a comment -

            This is tested on WT Stage - Worked Well

            Mapped a Health Tier Policy (with allowed special characters and longer length) - EE enrolled in the respective plan - Recalculated the policy from SA Utility - No Server Error while recalculation

            Ready for Stage

            CC - Prasad Pise Rakesh Roy Priya Handepatil

            Show
            alankar.chavan Alankar Chavan (Inactive) added a comment - This is tested on WT Stage - Worked Well Mapped a Health Tier Policy (with allowed special characters and longer length) - EE enrolled in the respective plan - Recalculated the policy from SA Utility - No Server Error while recalculation Ready for Stage CC - Prasad Pise Rakesh Roy Priya Handepatil
            Hide
            Permalink
            alankar.chavan Alankar Chavan (Inactive) added a comment -

            This is tested on Stage - Worked Well

            Mapped a Health Tier Policy (with allowed special characters and longer length) - EE enrolled in the respective plan - Recalculated the policy from SA Utility - No Server Error while recalculation

            Ready for Production

            CC - Rakesh Roy Prasad Pise

            Show
            alankar.chavan Alankar Chavan (Inactive) added a comment - This is tested on Stage - Worked Well Mapped a Health Tier Policy (with allowed special characters and longer length) - EE enrolled in the respective plan - Recalculated the policy from SA Utility - No Server Error while recalculation Ready for Production CC - Rakesh Roy Prasad Pise
            Hide
            Permalink
            alankar.chavan Alankar Chavan (Inactive) added a comment -

            This is tested on Production - Worked Well

            Mapped a Health Tier Policy (with allowed special characters and longer length) - EE enrolled in the respective plan - Recalculated the policy from SA Utility - No Server Error while recalculation

            CC - Prasad Pise Rakesh Roy

            Show
            alankar.chavan Alankar Chavan (Inactive) added a comment - This is tested on Production - Worked Well Mapped a Health Tier Policy (with allowed special characters and longer length) - EE enrolled in the respective plan - Recalculated the policy from SA Utility - No Server Error while recalculation CC - Prasad Pise Rakesh Roy

              People

              Assignee:
              alankar.chavan Alankar Chavan (Inactive)
              Reporter:
              alankar.chavan Alankar Chavan (Inactive)
              Developer:
              Abhilash Warkari (Inactive)
              Votes:
              0 Vote for this issue
              Watchers:
              3 Start watching this issue

                Dates

                Created:
                Updated:
                Resolved:
                Dev Due Date:
                Code Review Date:

                  Time Tracking

                  Estimated:
                  Original Estimate - 10h Original Estimate - 10h
                  10h
                  Remaining:
                  Remaining Estimate - 0h
                  0h
                  Logged:
                  Time Spent - 14.5h
                  14.5h