Uploaded image for project: 'Project Simple'
  1. Project Simple
  2. ST-227

Query Performance - OES_SP_GENERIC_EFFECTIVEDATE_CALCULATION

    Details

    • Type: Enhancement
    • Status: Closed
    • Priority: High
    • Resolution: Done
    • Component/s: Performance
    • Labels:
      None
    • Reported by:
      Support
    • Item State:
      Production QA
    • Issue Importance:
      Must Have

      Attachments

      1. 227Employees.txt
        0.9 kB
      2. OEMODE_EffectiveDateCalls.xlsx
        19 kB
      3. Scenarios_Production.xls
        73 kB
      4. Scenarios_Stage.xls
        66 kB
      5. Scenarios.xls
        52 kB
      6. Test Cases.xlsx
        17 kB
      7. Test Cases.xlsx
        17 kB

        Issue Links

          Activity

          prasanna Prasanna Karlekar (Inactive) created issue -
          prasanna Prasanna Karlekar (Inactive) made changes -
          Field Original Value New Value
          Issue Importance Must Have [ 11800 ]
          prasanna Prasanna Karlekar (Inactive) made changes -
          Link This issue relates to ST-175 [ ST-175 ]
          Show
          prasanna Prasanna Karlekar (Inactive) added a comment - New Relic Log for Load Test carried on Local Performance machine on 16 June 2016 : https://rpm.newrelic.com/accounts/1353506/applications/24434194/transactions#id=5b225765625472616e73616374696f6e2f5743462f574f524b54455252412e49436f6e74726f6c6c6572417070546965722e476574436f6c6c656374696f6e222c22225d&tab-detail_177be78-4bd03df4-33d5-11e6-8eb5-f8bc12425d4c=database_queries&app_trace_id=177be78-4bd03df4-33d5-11e6-8eb5-f8bc12425d4c
          vikas.pawar Vikas Pawar (Inactive) made changes -
          Assignee Vikas Pawar [ vikas.pawar ]
          vikas.pawar Vikas Pawar (Inactive) made changes -
          Status New Request [ 10029 ] Pending for Approval [ 10002 ]
          vikas.pawar Vikas Pawar (Inactive) made changes -
          Status Pending for Approval [ 10002 ] Approved for Development [ 10003 ]
          vikas.pawar Vikas Pawar (Inactive) made changes -
          Item State Parent values: Development(10200)Level 1 values: In Analysis(10204)
          vikas.pawar Vikas Pawar (Inactive) made changes -
          Status Approved for Development [ 10003 ] In Development [ 10007 ]
          amruta.lohiya Amruta Lohiya made changes -
          Assignee Vikas Pawar [ vikas.pawar ] Amruta Lohiya [ amruta.baheti ]
          vikas.pawar Vikas Pawar (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)
          vikas.pawar Vikas Pawar (Inactive) made changes -
          Assignee Amruta Lohiya [ amruta.baheti ] Vikas Pawar [ vikas.pawar ]
          vikas.pawar Vikas Pawar (Inactive) made changes -
          Attachment OEMODE_EffectiveDateCalls.xlsx [ 26995 ]
          Hide
          vikas.pawar Vikas Pawar (Inactive) added a comment - - edited

          Hi Saurabh Sablaka,

          As per my analysis, this SP is getting called from multiple pages from multiple times. I have attached excel sheet for different calls and reasons for that. OEMODE_EffectiveDateCalls.xlsx

          There are unnecessary calls from landing page for benifit types and for different plans. We can reduce these calls by only selecting those benifit types which are selected on EDS instead of all benifit types and calls for different plans by checking whether plan level rule is set or not.

          Show
          vikas.pawar Vikas Pawar (Inactive) added a comment - - edited Hi Saurabh Sablaka , As per my analysis, this SP is getting called from multiple pages from multiple times. I have attached excel sheet for different calls and reasons for that. OEMODE_EffectiveDateCalls.xlsx There are unnecessary calls from landing page for benifit types and for different plans. We can reduce these calls by only selecting those benifit types which are selected on EDS instead of all benifit types and calls for different plans by checking whether plan level rule is set or not.
          vikas.pawar Vikas Pawar (Inactive) made changes -
          Status In Development [ 10007 ] Local Testing [ 10200 ]
          vikas.pawar Vikas Pawar (Inactive) made changes -
          Assignee Vikas Pawar [ vikas.pawar ] Rakesh Roy [ rakeshr ]
          vikas.pawar Vikas Pawar (Inactive) made changes -
          Attachment Test Cases.xlsx [ 27420 ]
          Hide
          vikas.pawar Vikas Pawar (Inactive) added a comment -

          Hi Rakesh Roy,

          I have checked in Generic Effective Date SP changes into LB. On landing Page there were almost 102 calls for this SP, now we have reduced it to the 12 calls. I have attached different Test cases Test Cases.xlsx which i Have verified during Unit testing. Cobra Enrollment unit testing is remaining because of some problems but i have verified for other enrollment modes.

          As this is the major change for workflow, Please make sure that it should be tested thoroughly. We need to test attached test cases and following mentioned scenarios.

          1. Qualifying and Plan Wise enrollment mode running at a time for a user
          2. Different Plan wise enrollment for different benefit Types.

          CC: Satya Saurabh SablakaSamirVijayendra ShindeAmruta LohiyaPrasanna Karlekar

          Show
          vikas.pawar Vikas Pawar (Inactive) added a comment - Hi Rakesh Roy , I have checked in Generic Effective Date SP changes into LB. On landing Page there were almost 102 calls for this SP, now we have reduced it to the 12 calls. I have attached different Test cases Test Cases.xlsx which i Have verified during Unit testing. Cobra Enrollment unit testing is remaining because of some problems but i have verified for other enrollment modes. As this is the major change for workflow, Please make sure that it should be tested thoroughly. We need to test attached test cases and following mentioned scenarios. Qualifying and Plan Wise enrollment mode running at a time for a user Different Plan wise enrollment for different benefit Types. CC: Satya Saurabh Sablaka Samir Vijayendra Shinde Amruta Lohiya Prasanna Karlekar
          vikas.pawar Vikas Pawar (Inactive) made changes -
          Item State Parent values: Development(10200)Level 1 values: In Progress(10206) Parent values: Development(10200)Level 1 values: Ready for Local Testing(10209)
          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)
          rakeshr Rakesh Roy (Inactive) made changes -
          Assignee Rakesh Roy [ rakeshr ] Alankar Chavan [ alankar.chavan ]
          Hide
          vikas.pawar Vikas Pawar (Inactive) added a comment - - edited

          Hi Rakesh Roy,

          Cobra Enrollment Unit testing is also done locally. It is working as expected. I have attached updated test cases for it.

          Test Cases.xlsx

          CC: Saurabh Sablaka Prasanna Karlekar Samir Satya Suhas Joshi

          Show
          vikas.pawar Vikas Pawar (Inactive) added a comment - - edited Hi Rakesh Roy , Cobra Enrollment Unit testing is also done locally. It is working as expected. I have attached updated test cases for it. Test Cases.xlsx CC: Saurabh Sablaka Prasanna Karlekar Samir Satya Suhas Joshi
          vikas.pawar Vikas Pawar (Inactive) made changes -
          Attachment Test Cases.xlsx [ 27624 ]
          vikas.pawar Vikas Pawar (Inactive) made changes -
          Link This issue relates to WT-4998 [ WT-4998 ]
          rakeshr Rakesh Roy (Inactive) made changes -
          Assignee Alankar Chavan [ alankar.chavan ] Priya Dhamande [ priya.dhamande ]
          Hide
          priya.dhamande Priya Dhamande (Inactive) added a comment -

          Will be able to start the testing once the company is taken down on LB for testing.

          Show
          priya.dhamande Priya Dhamande (Inactive) added a comment - Will be able to start the testing once the company is taken down on LB for testing.
          priya.dhamande Priya Dhamande (Inactive) made changes -
          Item State Parent values: LB QA(10201)Level 1 values: LB Deployed(11600) Parent values: LB QA(10201)Level 1 values: In Testing(10210)
          Hide
          priya.dhamande Priya Dhamande (Inactive) added a comment -

          Hi Vikas,

          I have downloaded ASMl from Stage to LB and created scenarios on both Stage and LB.
          Scenarios covered:
          1. New Hire Employee
          2. Open Enrollment Employee

          For both cases the stage and LB workflow pages mismatched.
          New Hire: Stage | LB 9 | 165
          OE: Stage | LB 5 | 10

          Company Name: On LB: DONOTUSE_CALLSTESTING and Stage: Asml for Hspl

          As there is inconsistency in both scenarios assigning to you. Please assign back to me once the issue is resolved.

          Show
          priya.dhamande Priya Dhamande (Inactive) added a comment - Hi Vikas, I have downloaded ASMl from Stage to LB and created scenarios on both Stage and LB. Scenarios covered: 1. New Hire Employee 2. Open Enrollment Employee For both cases the stage and LB workflow pages mismatched. New Hire: Stage | LB 9 | 165 OE: Stage | LB 5 | 10 Company Name: On LB: DONOTUSE_CALLSTESTING and Stage: Asml for Hspl As there is inconsistency in both scenarios assigning to you. Please assign back to me once the issue is resolved.
          priya.dhamande Priya Dhamande (Inactive) made changes -
          Item State Parent values: LB QA(10201)Level 1 values: In Testing(10210) Parent values: LB QA(10201)Level 1 values: Re-open(10212)
          priya.dhamande Priya Dhamande (Inactive) made changes -
          Assignee Priya Dhamande [ priya.dhamande ] Vikas Pawar [ vikas.pawar ]
          Hide
          vikas.pawar Vikas Pawar (Inactive) added a comment -

          Hi Priya,

          This was due to EDS screen was not saved on Stage. I have saved it. Please check now.
          Assigning ticket back to you.

          Show
          vikas.pawar Vikas Pawar (Inactive) added a comment - Hi Priya, This was due to EDS screen was not saved on Stage. I have saved it. Please check now. Assigning ticket back to you.
          vikas.pawar Vikas Pawar (Inactive) made changes -
          Assignee Vikas Pawar [ vikas.pawar ] Priya Dhamande [ priya.dhamande ]
          priya.dhamande Priya Dhamande (Inactive) made changes -
          Item State Parent values: LB QA(10201)Level 1 values: Re-open(10212) Parent values: LB QA(10201)Level 1 values: In Testing(10210)
          priya.dhamande Priya Dhamande (Inactive) made changes -
          Attachment Scenarios.xls [ 28613 ]
          priya.dhamande Priya Dhamande (Inactive) made changes -
          Attachment 227Employees.txt [ 28614 ]
          Hide
          priya.dhamande Priya Dhamande (Inactive) added a comment -

          The above enhancement is tested by Partner, Admin and Employee work flow on LB. The before patch work flow and plans are noted from Stage.

          Before Testing Readings
          Environment: Stage
          Company: ASML for Hspl
          Workflow Testing by Partner, Admin and Employe

          After Testing Readings
          Environment: LB
          Company: DONOTUSE_CALLSTESTING
          Workflow Testing by Partner, Admin and Employe

          Scenarios tested for OE, New Hire, ReHire, Classwise OE, Planwise (checked for Medical Plan only), COBRA and Dependent Audit.

          Attached are the scenarios [work flow] covered during testing and also a text doc is attached which has list of employees with UserID, Password and SSN.

          As per the testing all the work flow tested are having same Plan and no. of pages in tunnel. So, moving the jira on Stage.

          Show
          priya.dhamande Priya Dhamande (Inactive) added a comment - The above enhancement is tested by Partner, Admin and Employee work flow on LB. The before patch work flow and plans are noted from Stage. Before Testing Readings Environment: Stage Company: ASML for Hspl Workflow Testing by Partner, Admin and Employe After Testing Readings Environment: LB Company: DONOTUSE_CALLSTESTING Workflow Testing by Partner, Admin and Employe Scenarios tested for OE, New Hire, ReHire, Classwise OE, Planwise (checked for Medical Plan only), COBRA and Dependent Audit. Attached are the scenarios [work flow] covered during testing and also a text doc is attached which has list of employees with UserID, Password and SSN. As per the testing all the work flow tested are having same Plan and no. of pages in tunnel. So, moving the jira on Stage.
          priya.dhamande Priya Dhamande (Inactive) made changes -
          Item State Parent values: LB QA(10201)Level 1 values: In Testing(10210) Parent values: LB QA(10201)Level 1 values: Ready for Stage(10213)
          priya.dhamande Priya Dhamande (Inactive) made changes -
          Status Local Testing [ 10200 ] Pending for Stage Approval [ 10300 ]
          priya.dhamande Priya Dhamande (Inactive) made changes -
          Status Pending for Stage Approval [ 10300 ] Approved for Stage [ 10030 ]
          rakeshr Rakesh Roy (Inactive) made changes -
          Developer Vikas Pawar [ vikas.pawar ]
          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)
          priya.dhamande Priya Dhamande (Inactive) made changes -
          Item State Parent values: Stage QA(10202)Level 1 values: Stage Deployed(11602) Parent values: Stage QA(10202)Level 1 values: In Testing(10214)
          priya.dhamande Priya Dhamande (Inactive) made changes -
          Status Approved for Stage [ 10030 ] Stage Testing [ 10201 ]
          Hide
          priya.dhamande Priya Dhamande (Inactive) added a comment -

          The enhancement is verified on Stage Hspl company.

          Environment: Stage
          Company: ASML for Hspl
          Workflow Testing by Partner, Admin and Employee

          Scenarios tested for OE, New Hire, ReHire, Classwise OE, Planwise (checked for Medical Plan only), COBRA and Dependent Audit.

          The before patch ratings for Production are noted.

          The excel for the same is attached with jira. As workflow pages and plans are matched. We are moving the jira on Production.

          Show
          priya.dhamande Priya Dhamande (Inactive) added a comment - The enhancement is verified on Stage Hspl company. Environment: Stage Company: ASML for Hspl Workflow Testing by Partner, Admin and Employee Scenarios tested for OE, New Hire, ReHire, Classwise OE, Planwise (checked for Medical Plan only), COBRA and Dependent Audit. The before patch ratings for Production are noted. The excel for the same is attached with jira. As workflow pages and plans are matched. We are moving the jira on Production.
          priya.dhamande Priya Dhamande (Inactive) made changes -
          Attachment Scenarios_Stage.xls [ 28937 ]
          priya.dhamande Priya Dhamande (Inactive) made changes -
          Item State Parent values: Stage QA(10202)Level 1 values: In Testing(10214) Parent values: Stage QA(10202)Level 1 values: Ready for Production(10217)
          priya.dhamande Priya Dhamande (Inactive) made changes -
          Status Stage Testing [ 10201 ] Pending for Production Approval [ 10301 ]
          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)
          vikas.pawar Vikas Pawar (Inactive) made changes -
          Code Reviewed By Satya Prakash,Saurabh Sablaka [ 12300, 11909 ]
          rakeshr Rakesh Roy (Inactive) made changes -
          Status Pending for Production Approval [ 10301 ] Approved for production [ 10034 ]
          rakeshr Rakesh Roy (Inactive) made changes -
          Status Approved for production [ 10034 ] Production Testing [ 10202 ]
          priya.dhamande Priya Dhamande (Inactive) made changes -
          Item State Parent values: Production QA(10203)Level 1 values: Production Deployed(10221) Parent values: Production QA(10203)Level 1 values: In Testing(10218)
          Hide
          priya.dhamande Priya Dhamande (Inactive) added a comment -

          I have started testing the patch on Production for ASML for Hspl company.

          Environment: Production
          Company: ASML for Hspl
          Workflow tested for OE and New Hire Employee

          for workflow number of pages and plans available for enrollment are exactly same. Will be continuing testing for other workflows tomorrow.

          Show
          priya.dhamande Priya Dhamande (Inactive) added a comment - I have started testing the patch on Production for ASML for Hspl company. Environment: Production Company: ASML for Hspl Workflow tested for OE and New Hire Employee for workflow number of pages and plans available for enrollment are exactly same. Will be continuing testing for other workflows tomorrow.
          rakeshr Rakesh Roy (Inactive) made changes -
          Resolution Fixed [ 1 ]
          Status Production Testing [ 10202 ] Production Complete [ 10028 ]
          rakeshr Rakesh Roy (Inactive) made changes -
          Item State Parent values: Production QA(10203)Level 1 values: In Testing(10218) Parent values: Production Complete(10222)Level 1 values: Closed(10223)
          priya.dhamande Priya Dhamande (Inactive) made changes -
          Item State Parent values: Production Complete(10222)Level 1 values: Closed(10223) Parent values: Production QA(10203)Level 1 values: In Testing(10218)
          priya.dhamande Priya Dhamande (Inactive) made changes -
          Attachment Scenarios_Production.xls [ 30616 ]
          Hide
          priya.dhamande Priya Dhamande (Inactive) added a comment -

          Environment: Production
          Company: ASML
          Workflow Tested: QE, Plan wise, ReHire, Classswise and Dependent Audit

          For all the work flow tested number of pages and the plans eligible were same. Flows covered on Production are listed on excel and attached with the jira.

          The before patch readings are same as that after patch reading on production. So, closing the jira on Production.

          Show
          priya.dhamande Priya Dhamande (Inactive) added a comment - Environment: Production Company: ASML Workflow Tested: QE, Plan wise, ReHire, Classswise and Dependent Audit For all the work flow tested number of pages and the plans eligible were same. Flows covered on Production are listed on excel and attached with the jira. The before patch readings are same as that after patch reading on production. So, closing the jira on Production.
          priya.dhamande Priya Dhamande (Inactive) made changes -
          Item State Parent values: Production QA(10203)Level 1 values: In Testing(10218) Parent values: Production QA(10203)
          priya.dhamande Priya Dhamande (Inactive) made changes -
          Status Production Complete [ 10028 ] Closed [ 6 ]
          Transition Time In Source Status Execution Times
          Vikas Pawar (Inactive) made transition -
          New Request Pending for Approval
          78d 20h 47m 1
          Vikas Pawar (Inactive) made transition -
          Pending for Approval Approved for Development
          2s 1
          Vikas Pawar (Inactive) made transition -
          Approved for Development In Development
          5d 43m 1
          Vikas Pawar (Inactive) made transition -
          In Development In LB Testing
          8d 23h 3m 1
          Priya Dhamande (Inactive) made transition -
          In LB Testing Pending for Stage Approval
          11d 6h 28m 1
          Priya Dhamande (Inactive) made transition -
          Pending for Stage Approval Approved for Stage
          3s 1
          Priya Dhamande (Inactive) made transition -
          Approved for Stage Stage Testing
          3d 30m 1
          Priya Dhamande (Inactive) made transition -
          Stage Testing Pending for Production Approval
          1d 52m 1
          Rakesh Roy (Inactive) made transition -
          Pending for Production Approval Approved for production
          4d 19h 32m 1
          Rakesh Roy (Inactive) made transition -
          Approved for production In Production Testing
          4s 1
          Rakesh Roy (Inactive) made transition -
          In Production Testing Production Complete
          6d 9h 17m 1
          Priya Dhamande (Inactive) made transition -
          Production Complete Closed
          7d 17h 45m 1

            People

            Assignee:
            priya.dhamande Priya Dhamande (Inactive)
            Reporter:
            prasanna Prasanna Karlekar (Inactive)
            Developer:
            Vikas Pawar (Inactive)
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

              Dates

              Created:
              Updated:
              Resolved: