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

Query Performance - OES_SP_Get_EnrollmentModesForEmployee

    Details

    • Type: Enhancement
    • Status: New Request
    • Priority: High
    • Resolution: Unresolved
    • Component/s: Performance
    • Labels:
      None
    • Module:
      Platform - Performance
    • Reported by:
      Support
    • Item State:
      Development - Development Backlog
    • Issue Importance:
      Must Have

      Attachments

        Issue Links

          Activity

          saurabh.sablaka Saurabh Sablaka (Inactive) created issue -
          saurabh.sablaka Saurabh Sablaka (Inactive) made changes -
          Field Original Value New Value
          Link This issue relates to ST-175 [ ST-175 ]
          vikas.pawar Vikas Pawar (Inactive) made changes -
          Assignee Prasanna Karlekar [ prasanna ]
          suhas.joshi Suhas Joshi (Inactive) made changes -
          Description Call Stack:
          WORKTERRA.Employee_Enrollment.GetEnrollmentModeForEmployeeForMainPage(:0)
          WORKTERRA.Employee_Enrollment.GetEnrollmentModeForEmployee(:0)
          WORKTERRA.Employee_Enrollment.GetData(:0)
          WORKTERRA.Employee_Enrollment.GetData(:0)
          WORKTERRA.BenAdmin.BenAdminControllerAppTier.GetData(:0)

          StoredProc: OES_SP_Get_EnrollmentModesForEmployee
          Call Stack:
          WORKTERRA.Employee_Enrollment.GetEnrollmentModeForEmployeeForMainPage(:0)
          WORKTERRA.Employee_Enrollment.GetEnrollmentModeForEmployee(:0)
          WORKTERRA.Employee_Enrollment.GetData(:0)
          WORKTERRA.Employee_Enrollment.GetData(:0)
          WORKTERRA.BenAdmin.BenAdminControllerAppTier.GetData(:0)

          StoredProc: OES_SP_Get_EnrollmentModesForEmployee


          See this link for getting application code areas for select benefit type portion of the enrollment workflow (this is not exactly the same flow as the stack trace above though)

          https://rpm.newrelic.com/accounts/1155082/applications/13257194/transactions#id=5b225765625472616e73616374696f6e2f4d56432f5573657244657461696c73436f6e74726f6c6c65722f456e726f6c6c4e6f7750616765222c22225d&tab-detail_ca4a02-a465b3b4-3069-11e6-a1f2-f8bc12425d50=trace_details&app_trace_id=ca4a02-a465b3b4-3069-11e6-a1f2-f8bc12425d50

          suhas.joshi Suhas Joshi (Inactive) made changes -
          Description Call Stack:
          WORKTERRA.Employee_Enrollment.GetEnrollmentModeForEmployeeForMainPage(:0)
          WORKTERRA.Employee_Enrollment.GetEnrollmentModeForEmployee(:0)
          WORKTERRA.Employee_Enrollment.GetData(:0)
          WORKTERRA.Employee_Enrollment.GetData(:0)
          WORKTERRA.BenAdmin.BenAdminControllerAppTier.GetData(:0)

          StoredProc: OES_SP_Get_EnrollmentModesForEmployee


          See this link for getting application code areas for select benefit type portion of the enrollment workflow (this is not exactly the same flow as the stack trace above though)

          https://rpm.newrelic.com/accounts/1155082/applications/13257194/transactions#id=5b225765625472616e73616374696f6e2f4d56432f5573657244657461696c73436f6e74726f6c6c65722f456e726f6c6c4e6f7750616765222c22225d&tab-detail_ca4a02-a465b3b4-3069-11e6-a1f2-f8bc12425d50=trace_details&app_trace_id=ca4a02-a465b3b4-3069-11e6-a1f2-f8bc12425d50

          Call Stack:
          WORKTERRA.Employee_Enrollment.GetEnrollmentModeForEmployeeForMainPage(:0)
          WORKTERRA.Employee_Enrollment.GetEnrollmentModeForEmployee(:0)
          WORKTERRA.Employee_Enrollment.GetData(:0)
          WORKTERRA.Employee_Enrollment.GetData(:0)
          WORKTERRA.BenAdmin.BenAdminControllerAppTier.GetData(:0)

          StoredProc: OES_SP_Get_EnrollmentModesForEmployee


          See this link for getting application code areas for select benefit type portion of the enrollment workflow (this is not exactly the same flow as the stack trace above though)

          https://rpm.newrelic.com/accounts/1155082/applications/13257194/transactions#id=5b225765625472616e73616374696f6e2f4d56432f5573657244657461696c73436f6e74726f6c6c65722f456e726f6c6c4e6f7750616765222c22225d&tab-detail_ca4a02-a465b3b4-3069-11e6-a1f2-f8bc12425d50=trace_details&app_trace_id=ca4a02-a465b3b4-3069-11e6-a1f2-f8bc12425d50


          https://rpm.newrelic.com/accounts/1155082/applications/13257194_h13531008/transactions#id=5b225765625472616e73616374696f6e2f4d56432f5573657244657461696c73436f6e74726f6c6c65722f456e726f6c6c4e6f7750616765222c22225d&app_trace_id=ce7782-c4ce30bf-3067-11e6-a1f2-f8bc12425d50&tab-detail_ce7782-c4ce30bf-3067-11e6-a1f2-f8bc12425d50=trace_details


          prasanna Prasanna Karlekar (Inactive) made changes -
          Hide
          prasanna Prasanna Karlekar (Inactive) added a comment -

          Suhas Joshi, Saurabh Sablaka,Vikas Pawar

          Traces related to Enroll Now routines on Employee Data Change and Plan Enrollment are added in the file WorkterraBusinessInstrumentation.xml
          We need to update "WorkterraBusinessInstrumentation" file on Local Performance machine to get more details on this.

          Show
          prasanna Prasanna Karlekar (Inactive) added a comment - Suhas Joshi , Saurabh Sablaka , Vikas Pawar Traces related to Enroll Now routines on Employee Data Change and Plan Enrollment are added in the file WorkterraBusinessInstrumentation.xml We need to update "WorkterraBusinessInstrumentation" file on Local Performance machine to get more details on this.
          Hide
          suhas.joshi Suhas Joshi (Inactive) added a comment -

          Vikas, Please check with Saurabh about accessing local load test machines, and let him know where to put this instrumentation file and what should be its name be. It will be better to put it there today.

          Show
          suhas.joshi Suhas Joshi (Inactive) added a comment - Vikas, Please check with Saurabh about accessing local load test machines, and let him know where to put this instrumentation file and what should be its name be. It will be better to put it there today.
          Hide
          saurabh.sablaka Saurabh Sablaka (Inactive) added a comment -

          Suhas Joshi Prasanna Karlekar Vikas Pawar
          Instrumentation file is deployed on both app servers for Load Test environment.

          Show
          saurabh.sablaka Saurabh Sablaka (Inactive) added a comment - Suhas Joshi Prasanna Karlekar Vikas Pawar Instrumentation file is deployed on both app servers for Load Test environment.
          vikas.pawar Vikas Pawar (Inactive) made changes -
          Description Call Stack:
          WORKTERRA.Employee_Enrollment.GetEnrollmentModeForEmployeeForMainPage(:0)
          WORKTERRA.Employee_Enrollment.GetEnrollmentModeForEmployee(:0)
          WORKTERRA.Employee_Enrollment.GetData(:0)
          WORKTERRA.Employee_Enrollment.GetData(:0)
          WORKTERRA.BenAdmin.BenAdminControllerAppTier.GetData(:0)

          StoredProc: OES_SP_Get_EnrollmentModesForEmployee


          See this link for getting application code areas for select benefit type portion of the enrollment workflow (this is not exactly the same flow as the stack trace above though)

          https://rpm.newrelic.com/accounts/1155082/applications/13257194/transactions#id=5b225765625472616e73616374696f6e2f4d56432f5573657244657461696c73436f6e74726f6c6c65722f456e726f6c6c4e6f7750616765222c22225d&tab-detail_ca4a02-a465b3b4-3069-11e6-a1f2-f8bc12425d50=trace_details&app_trace_id=ca4a02-a465b3b4-3069-11e6-a1f2-f8bc12425d50


          https://rpm.newrelic.com/accounts/1155082/applications/13257194_h13531008/transactions#id=5b225765625472616e73616374696f6e2f4d56432f5573657244657461696c73436f6e74726f6c6c65722f456e726f6c6c4e6f7750616765222c22225d&app_trace_id=ce7782-c4ce30bf-3067-11e6-a1f2-f8bc12425d50&tab-detail_ce7782-c4ce30bf-3067-11e6-a1f2-f8bc12425d50=trace_details


          Call Stack:
          WORKTERRA.Employee_Enrollment.GetEnrollmentModeForEmployeeForMainPage(:0)
          WORKTERRA.Employee_Enrollment.GetEnrollmentModeForEmployee(:0)
          WORKTERRA.Employee_Enrollment.GetData(:0)
          WORKTERRA.Employee_Enrollment.GetData(:0)
          WORKTERRA.BenAdmin.BenAdminControllerAppTier.GetData(:0)

          StoredProc: OES_SP_Get_EnrollmentModesForEmployee


          See this link for getting application code areas for select benefit type portion of the enrollment workflow (this is not exactly the same flow as the stack trace above though)

          https://rpm.newrelic.com/accounts/1155082/applications/13257194/transactions#id=5b225765625472616e73616374696f6e2f4d56432f5573657244657461696c73436f6e74726f6c6c65722f456e726f6c6c4e6f7750616765222c22225d&tab-detail_ca4a02-a465b3b4-3069-11e6-a1f2-f8bc12425d50=trace_details&app_trace_id=ca4a02-a465b3b4-3069-11e6-a1f2-f8bc12425d50


          https://rpm.newrelic.com/accounts/1155082/applications/13257194_h13531008/transactions#id=5b225765625472616e73616374696f6e2f4d56432f5573657244657461696c73436f6e74726f6c6c65722f456e726f6c6c4e6f7750616765222c22225d&app_trace_id=ce7782-c4ce30bf-3067-11e6-a1f2-f8bc12425d50&tab-detail_ce7782-c4ce30bf-3067-11e6-a1f2-f8bc12425d50=trace_details


          https://rpm.newrelic.com/accounts/1155082/applications/13257194_h18260974/transactions#id=5b225765625472616e73616374696f6e2f5743462f574f524b54455252412e49436f6e74726f6c6c6572417070546965722e47657444617461222c22225d&app_trace_id=116b603-e90e7676-4122-11e6-9cf7-f8bc12425d50
          prasanna Prasanna Karlekar (Inactive) made changes -
          Item State Parent values: Development(10200)Level 1 values: Development Backlog(10205) Parent values: Development(10200)
          prasanna Prasanna Karlekar (Inactive) made changes -
          Item State Parent values: Development(10200) Parent values: Development(10200)Level 1 values: Development Backlog(10205)
          vikas.pawar Vikas Pawar (Inactive) made changes -
          Summary Query Performance - GetEnrollmentModeForEmployeeForMainPage Query Performance - OES_SP_Get_EnrollmentModesForEmployee
          prasanna Prasanna Karlekar (Inactive) made changes -
          Assignee Prasanna Karlekar [ prasanna ] Vikas Pawar [ vikas.pawar ]

            People

            Assignee:
            vikas.pawar Vikas Pawar (Inactive)
            Reporter:
            saurabh.sablaka Saurabh Sablaka (Inactive)
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

              Dates

              Created:
              Updated: