WORKTERRAProject Type: software

WORKTERRA

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

RCPS - Sever Encountered An Error Message on Plan Design Health Tier Mappingin PROD

    Details

    • Type: Bug
    • Status: Production Complete
    • Priority: Critical
    • Resolution: Done
    • Affects Version/s: None
    • Fix Version/s: None
    • Component/s: None
    • Labels:
      None
    • Environment:
      Production
    • Module:
      BenAdmin - Enrollment
    • Reported by:
      White Label
    • Item State:
      Production Complete

      Description

      Mapping Name consists of special character Single quote (‘) because of this it is giving error while saving Plan design Health Tier Mapping.

      Abhijeet Khandagale fixed this issue on 08/12/2014, after this we not allowing following special character in "Mapping Name". Please refer attached screen shot for more detils.

      Special Character [ ^ < > ' \ " = + $ ~ @ @ % * ( ) ! ? \ ] $

      CC-Amruta Lohiya,Satya,Samir

        Attachments

          Activity

          Ascending order - Click to sort in descending order
          Hide
          Permalink
          satyap Satya added a comment -

          Hrishikesh Deshpande Can you please share details for validation message regarding attached message FW RCPS - Form Description Not Valid Message in PROD.msg

          Show
          satyap Satya added a comment - Hrishikesh Deshpande Can you please share details for validation message regarding attached message FW RCPS - Form Description Not Valid Message in PROD.msg
          Hide
          Permalink
          vinanti.yadav Vinanti Yadav (Inactive) added a comment -

          Please Refer following 3C's :

          Concern : Special characters not allowing for Policy Number and server error during updating Health Tier Policy Mapping .

          Cause : code is only allowing alpha numeric values not any symbol like +, (, ) for Policy Number and
          Server error is due to PolicyHealthTierMappingName contains special symbol like ' (single quote) and this name is used in database query and due to this sql throws an exception server error get occurred.

          Correction : code fix is done for adding symbol like (, ), +,-, for Policy Number Textbox. Java script Validation for PolicyHealthTierName is also corrected.

          Thanks & Ragards,
          Vinanti R. Yadav

          CC: Amruta Lohiya,Jyoti Mayne

          Show
          vinanti.yadav Vinanti Yadav (Inactive) added a comment - Please Refer following 3C's : Concern : Special characters not allowing for Policy Number and server error during updating Health Tier Policy Mapping . Cause : code is only allowing alpha numeric values not any symbol like +, (, ) for Policy Number and Server error is due to PolicyHealthTierMappingName contains special symbol like ' (single quote) and this name is used in database query and due to this sql throws an exception server error get occurred. Correction : code fix is done for adding symbol like (, ), +,-, for Policy Number Textbox. Java script Validation for PolicyHealthTierName is also corrected. Thanks & Ragards, Vinanti R. Yadav CC: Amruta Lohiya , Jyoti Mayne
          Hide
          Permalink
          vinanti.yadav Vinanti Yadav (Inactive) added a comment -

          Hi all,

          Validation is Implemented as below :

          For PlanDesignHealthTierMappingName, only alphanumeric letters (a-z, A-Z, 0-9) with white space are allowed.
          For Policy Number, only alphanumeric letters (a-z, A-Z, 0-9) with white space and few special characters like - Plus ( + ), Hypen ( - ) , Rounded Brackets ( ( ) ) and Forward Slash ( / ) are allowed.

          CC:Amruta Lohiya,Satya,Jyoti Mayne,Umesh Kadam

          Show
          vinanti.yadav Vinanti Yadav (Inactive) added a comment - Hi all, Validation is Implemented as below : For PlanDesignHealthTierMappingName, only alphanumeric letters (a-z, A-Z, 0-9) with white space are allowed. For Policy Number, only alphanumeric letters (a-z, A-Z, 0-9) with white space and few special characters like - Plus ( + ), Hypen ( - ) , Rounded Brackets ( ( ) ) and Forward Slash ( / ) are allowed. CC: Amruta Lohiya , Satya , Jyoti Mayne , Umesh Kadam
          Hide
          Permalink
          prasadp Prasad Pise (Inactive) added a comment -

          Hi Jayshree,

          Can you please verify this issue on LB. Let me know in case of any queries.

          Thanks

          • Prasad
          Show
          prasadp Prasad Pise (Inactive) added a comment - Hi Jayshree, Can you please verify this issue on LB. Let me know in case of any queries. Thanks Prasad
          Hide
          Permalink
          prasadp Prasad Pise (Inactive) added a comment -

          Added QA Estimates:
          LB: 6h ( Analysis, Discussion, Test Case writing, Review, Execution)
          Stage:2h
          Prod:2h

          Show
          prasadp Prasad Pise (Inactive) added a comment - Added QA Estimates: LB: 6h ( Analysis, Discussion, Test Case writing, Review, Execution) Stage:2h Prod:2h
          Hide
          Permalink
          jayshree.nagpure Jayshree Nagpure (Inactive) added a comment -

          hi Vinanti Yadav

          Testing is completed on LB.
          While testing mapping name and policy number i have encountered max length related issue.
          Please refer WT-7031.

          Attached here with test cases. Updated WT-6901-Plan design health mapping.xls

          cc:Prasad Pise Avnish Yadav Satya

          Show
          jayshree.nagpure Jayshree Nagpure (Inactive) added a comment - hi Vinanti Yadav Testing is completed on LB. While testing mapping name and policy number i have encountered max length related issue. Please refer WT-7031 . Attached here with test cases. Updated WT-6901-Plan design health mapping.xls cc: Prasad Pise Avnish Yadav Satya
          Hide
          Permalink
          jayshree.nagpure Jayshree Nagpure (Inactive) added a comment -

          Hi

          As per discussion with Vinanti WT-7031 will be fixed later. Hence updating the item state as ready for stage.

          Show
          jayshree.nagpure Jayshree Nagpure (Inactive) added a comment - Hi As per discussion with Vinanti WT-7031 will be fixed later. Hence updating the item state as ready for stage.
          Hide
          Permalink
          jayshree.nagpure Jayshree Nagpure (Inactive) added a comment -

          Hi,

          Testing is Completed on stage.
          Max length related WT-7031 same issue exits on stage environment.
          And updating the item state as ready for production.

          Show
          jayshree.nagpure Jayshree Nagpure (Inactive) added a comment - Hi, Testing is Completed on stage. Max length related WT-7031 same issue exits on stage environment. And updating the item state as ready for production.
          Hide
          Permalink
          jayshree.nagpure Jayshree Nagpure (Inactive) added a comment -

          Hi,

          Testing is done on production environment.
          Verification done for "RCPS for HSPL" company.
          Issue is fixed.

          Show
          jayshree.nagpure Jayshree Nagpure (Inactive) added a comment - Hi, Testing is done on production environment. Verification done for "RCPS for HSPL" company. Issue is fixed.

            People

            Assignee:
            jayshree.nagpure Jayshree Nagpure (Inactive)
            Reporter:
            avnish.yadav Avnish Yadav (Inactive)
            Account Executive:
            Jennifer Leugers
            Votes:
            0 Vote for this issue
            Watchers:
            5 Start watching this issue

              Dates

              Created:
              Updated:
              Resolved:

                Time Tracking

                Estimated:
                Original Estimate - 21h
                21h
                Remaining:
                Remaining Estimate - 0h
                0h
                Logged:
                Time Spent - 19.5h Time Not Required
                19.5h