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
          Permalink
          avnish.yadav Avnish Yadav (Inactive) logged work - 06/Dec/16 04:39 PM
          • Time Spent:
            2h
             
            <No comment>
          avnish.yadav Avnish Yadav (Inactive) created issue -
          avnish.yadav Avnish Yadav (Inactive) made changes -
          Field Original Value New Value
          Attachment ScreenShot.jpg [ 34544 ]
          satyap Satya made changes -
          Attachment FW RCPS - Form Description Not Valid Message in PROD.msg [ 34585 ]
          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
          jyoti.mayne Jyoti Mayne made changes -
          Assignee Jyoti Mayne [ jyoti.mayne ] Vinanti Yadav [ vinanti.yadav ]
          Permalink
          vinanti.yadav Vinanti Yadav (Inactive) logged work - 07/Dec/16 06:00 AM
          • Time Spent:
            1.5h
             

            Initial Analysis

          vinanti.yadav Vinanti Yadav (Inactive) made changes -
          Status Open [ 1 ] In Development [ 10007 ]
          vinanti.yadav Vinanti Yadav (Inactive) made changes -
          Item State Parent values: Development(10200)Level 1 values: In Analysis(10204)
          Permalink
          vinanti.yadav Vinanti Yadav (Inactive) logged work - 07/Dec/16 08:15 AM
          • Time Spent:
            2.25h
             

            Initial Analysis

          Permalink
          vinanti.yadav Vinanti Yadav (Inactive) logged work - 07/Dec/16 10:45 AM - edited
          • Time Spent:
            3.25h
             

            Coding & Unittesting

          vinanti.yadav Vinanti Yadav (Inactive) made changes -
          Remaining Estimate 11h [ 39600 ]
          Original Estimate 11h [ 39600 ]
          vinanti.yadav Vinanti Yadav (Inactive) made changes -
          Item State Parent values: Development(10200)Level 1 values: In Analysis(10204) Parent values: Development(10200)Level 1 values: In Progress(10206)
          Permalink
          umesh.kadam Umesh Kadam (Inactive) logged work - 07/Dec/16 12:00 PM - edited
          • Time Spent:
            1h
             

            Worked with Vinanti for validation of PlanDesignHealthTierPolicyMappingName and PolicyNumber

          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
          vinanti.yadav Vinanti Yadav (Inactive) made changes -
          Item State Parent values: Development(10200)Level 1 values: In Progress(10206) Parent values: Development(10200)Level 1 values: Ready for Review(10208)
          vinanti.yadav Vinanti Yadav (Inactive) made changes -
          Remaining Estimate 11h [ 39600 ] 9.5h [ 34200 ]
          Time Spent 1.5h [ 5400 ]
          Worklog Id 12007 [ 12007 ]
          vinanti.yadav Vinanti Yadav (Inactive) made changes -
          Remaining Estimate 9.5h [ 34200 ] 7.25h [ 26100 ]
          Time Spent 1.5h [ 5400 ] 3.75h [ 13500 ]
          Worklog Id 12008 [ 12008 ]
          vinanti.yadav Vinanti Yadav (Inactive) made changes -
          Remaining Estimate 7.25h [ 26100 ] 4.25h [ 15300 ]
          Time Spent 3.75h [ 13500 ] 6.75h [ 24300 ]
          Worklog Id 12009 [ 12009 ]
          vinanti.yadav Vinanti Yadav (Inactive) made changes -
          Worklog Id 12009 [ 12009 ]
          vinanti.yadav Vinanti Yadav (Inactive) made changes -
          Remaining Estimate 4.25h [ 15300 ] 4h [ 14400 ]
          Time Spent 6.75h [ 24300 ] 7h [ 25200 ]
          Worklog Id 12009 [ 12009 ]
          Permalink
          vinanti.yadav Vinanti Yadav (Inactive) logged work - 08/Dec/16 04:15 AM
          • Time Spent:
            2.25h
             

            Unit Testing, Code Review, Code check in LB branch.

          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
          vinanti.yadav Vinanti Yadav (Inactive) made changes -
          Item State Parent values: Development(10200)Level 1 values: Ready for Review(10208) Parent values: Development(10200)Level 1 values: Ready for Local Testing(10209)
          vinanti.yadav Vinanti Yadav (Inactive) made changes -
          Remaining Estimate 4h [ 14400 ] 1.75h [ 6300 ]
          Time Spent 7h [ 25200 ] 9.25h [ 33300 ]
          Worklog Id 12057 [ 12057 ]
          khandu.kshirsagar Khandu Kshirsagar (Inactive) made changes -
          Item State Parent values: Development(10200)Level 1 values: Ready for Local Testing(10209) Parent values: LB QA(10201)Level 1 values: LB Deployed(11600)
          vinanti.yadav Vinanti Yadav (Inactive) made changes -
          Assignee Vinanti Yadav [ vinanti.yadav ] Rakesh Roy [ rakeshr ]
          umesh.kadam Umesh Kadam (Inactive) made changes -
          Remaining Estimate 1.75h [ 6300 ] 0.75h [ 2700 ]
          Time Spent 9.25h [ 33300 ] 10.25h [ 36900 ]
          Worklog Id 12094 [ 12094 ]
          rakeshr Rakesh Roy (Inactive) made changes -
          Status In Development [ 10007 ] Local Testing [ 10200 ]
          rakeshr Rakesh Roy (Inactive) made changes -
          Assignee Rakesh Roy [ rakeshr ] Prasad Pise [ prasadp ]
          prasadp Prasad Pise (Inactive) made changes -
          Assignee Prasad Pise [ prasadp ] Jayshree Nagpure [ jayshree.nagpure ]
          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
          Permalink
          jayshree.nagpure Jayshree Nagpure (Inactive) logged work - 09/Dec/16 12:18 PM - edited
          • Time Spent:
            3h
             

            Discussion,Analysis,Test case writing,Test execution.

          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
          prasadp Prasad Pise (Inactive) made changes -
          Original Estimate 11h [ 39600 ] 21h [ 75600 ]
          jayshree.nagpure Jayshree Nagpure (Inactive) made changes -
          Attachment Updated WT-6901-Plan design health mapping.xls [ 34811 ]
          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
          jayshree.nagpure Jayshree Nagpure (Inactive) made changes -
          Remaining Estimate 0.75h [ 2700 ] 0h [ 0 ]
          Time Spent 10.25h [ 36900 ] 13.25h [ 47700 ]
          Worklog Id 12352 [ 12352 ]
          Permalink
          prasadp Prasad Pise (Inactive) logged work - 09/Dec/16 01:49 PM
          • Time Spent:
            2h
             

            Task Discussion, High level verification on LB

          jayshree.nagpure Jayshree Nagpure (Inactive) made changes -
          Item State Parent values: LB QA(10201)Level 1 values: LB Deployed(11600) Parent values: LB QA(10201)Level 1 values: Ready for Stage(10213)
          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.
          vinanti.yadav Vinanti Yadav (Inactive) made changes -
          Time Spent 13.25h [ 47700 ] 13.5h [ 48600 ]
          Worklog Id 12427 [ 12427 ]
          khandu.kshirsagar Khandu Kshirsagar (Inactive) made changes -
          Item State Parent values: LB QA(10201)Level 1 values: Ready for Stage(10213) Parent values: Stage QA(10202)Level 1 values: Stage Deployed(11602)
          rakeshr Rakesh Roy (Inactive) made changes -
          Status Local Testing [ 10200 ] Stage Testing [ 10201 ]
          jayshree.nagpure Jayshree Nagpure (Inactive) made changes -
          Item State Parent values: Stage QA(10202)Level 1 values: Stage Deployed(11602) Parent values: Stage QA(10202)Level 1 values: Ready for Production(10217)
          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.
          Permalink
          jayshree.nagpure Jayshree Nagpure (Inactive) logged work - 12/Dec/16 12:45 PM
          • Time Spent:
            1h
             

            Test execution for stage

          jayshree.nagpure Jayshree Nagpure (Inactive) made changes -
          Time Spent 13.5h [ 48600 ] 14.5h [ 52200 ]
          Worklog Id 12519 [ 12519 ]
          Permalink
          vinanti.yadav Vinanti Yadav (Inactive) logged work - 12/Dec/16 06:15 PM - edited
          • Time Spent:
            0.25h
             

            Code Check in (Stage Branch)

          umesh.kadam Umesh Kadam (Inactive) made changes -
          Worklog Id 12094 [ 12094 ]
          ashwin.wankhede Ashwin Wankhede (Inactive) made changes -
          Item State Parent values: Stage QA(10202)Level 1 values: Ready for Production(10217) Parent values: Production QA(10203)Level 1 values: Production Deployed(10221)
          jayshree.nagpure Jayshree Nagpure (Inactive) made changes -
          Status Stage Testing [ 10201 ] Production Testing [ 10202 ]
          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.
          jayshree.nagpure Jayshree Nagpure (Inactive) made changes -
          Resolution Fixed [ 1 ]
          Status Production Testing [ 10202 ] Production Complete [ 10028 ]
          jayshree.nagpure Jayshree Nagpure (Inactive) made changes -
          Worklog Id 12352 [ 12352 ]
          jayshree.nagpure Jayshree Nagpure (Inactive) made changes -
          Worklog Id 12352 [ 12352 ]
          Permalink
          jayshree.nagpure Jayshree Nagpure (Inactive) logged work - 13/Dec/16 10:10 AM - edited
          • Time Spent:
            1h
             

            Verification on Production Environment.

          jayshree.nagpure Jayshree Nagpure (Inactive) made changes -
          Time Spent 14.5h [ 52200 ] 15.5h [ 55800 ]
          Worklog Id 12721 [ 12721 ]
          jayshree.nagpure Jayshree Nagpure (Inactive) made changes -
          Time Spent 15.5h [ 55800 ] 15.75h [ 56700 ]
          Worklog Id 12721 [ 12721 ]
          jayshree.nagpure Jayshree Nagpure (Inactive) made changes -
          Remaining Estimate 0h [ 0 ] 0.25h [ 900 ]
          Time Spent 15.75h [ 56700 ] 15.5h [ 55800 ]
          Worklog Id 12721 [ 12721 ]
          vinanti.yadav Vinanti Yadav (Inactive) made changes -
          Worklog Id 12427 [ 12427 ]
          prasadp Prasad Pise (Inactive) made changes -
          Remaining Estimate 0.25h [ 900 ] 0h [ 0 ]
          Time Spent 15.5h [ 55800 ] 17.5h [ 63000 ]
          Worklog Id 13773 [ 13773 ]
          avnish.yadav Avnish Yadav (Inactive) made changes -
          Time Spent 17.5h [ 63000 ] 19.5h [ 70200 ]
          Worklog Id 14111 [ 14111 ]
          prasadp Prasad Pise (Inactive) made changes -
          Item State Parent values: Production QA(10203)Level 1 values: Production Deployed(10221) Parent values: Production Complete(10222)
          satyap Satya made changes -
          Environment_New Production [ 18442 ]
          Transition Time In Source Status Execution Times
          Vinanti Yadav (Inactive) made transition -
          Open In Development
          		11h 2m 1
          Rakesh Roy (Inactive) made transition -
          In Development In LB Testing
          		1d 6h 36m 1
          Rakesh Roy (Inactive) made transition -
          In LB Testing Stage Testing
          		3d 20h 9m 1
          Jayshree Nagpure (Inactive) made transition -
          Stage Testing In Production Testing
          		1d 2m 1
          Jayshree Nagpure (Inactive) made transition -
          In Production Testing Production Complete
          		27m 46s 1

            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