Project SimpleProject Type: software

Project Simple

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

        relates to

        Enhancement - An improvement or enhancement to an existing feature or task. ST-175 Query Optimization for performance

        • High - Serious problem that could block progress.
        • New Request

          Activity

          Ascending order - Click to sort in descending order
          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 -
          Attachment WorkterraBusinessInstrumentation.xml [ 20010 ]
          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: