Project SimpleProject Type: software

Project Simple

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

Query Performance - OES_SP_UpdateAddChangeTermDetails

    Details

    • Type: Enhancement
    • Status: Closed
    • Priority: High
    • Resolution: Done
    • Component/s: Performance
    • Labels:
      None
    • Module:
      Platform - Performance
    • Reported by:
      Support
    • Item State:
      Production Complete - Closed
    • Issue Importance:
      Good To Have

      Description

      *Call Stack *
      WORKTERRA.AddChangeTermReport.UpdateDatabase(:0)
      WORKTERRA.AddChangeTermReport.UpdateDatabase(:0)
      WORKTERRA.AddChangeTermReport.CreateDataForAddChangeTermReport(:0)
      WORKTERRA.AddChangeTermReport.Save(:0)
      WORKTERRA.AddChangeTermReport.SaveEnrollmentDataForConfirmationStatement(:0)
      WORKTERRA.BenAdmin.BenAdminControllerAppTier.SaveAndGetData(:0)
      WORKTERRA.BenAdmin.BenAdminControllerAppTier.SaveAndGetData(:0)
      WORKTERRA.ControllerAppTier.SaveAndGetData(:0)

      Link to details from 12 june load test (similar to this issue) should help :

      https://rpm.newrelic.com/accounts/1155082/applications/13257194/transactions#id=5b225765625472616e73616374696f6e2f5743462f574f524b54455252412e49436f6e74726f6c6c6572417070546965722e53617665416e6447657444617461222c22225d&app_trace_id=116b603-656786ff-306d-11e6-a1f2-f8bc12425d50

        Attachments

          Issue Links

          is blocked by

          Bug - A problem which impairs or prevents the functions of the product. WT-3547 ACT report throwing server error on Preview button on LB on For QA LB Austin Ind company.

          • High - Serious problem that could block progress.
          • Closed
          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
            vikas.pawar Vikas Pawar (Inactive) created issue -
            vikas.pawar Vikas Pawar (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 Saurabh Sablaka [ saurabh.sablaka ]
            suhas.joshi Suhas Joshi (Inactive) made changes -
            Description *Call Stack *
            WORKTERRA.AddChangeTermReport.UpdateDatabase(:0)
            WORKTERRA.AddChangeTermReport.UpdateDatabase(:0)
            WORKTERRA.AddChangeTermReport.CreateDataForAddChangeTermReport(:0)
            WORKTERRA.AddChangeTermReport.Save(:0)
            WORKTERRA.AddChangeTermReport.SaveEnrollmentDataForConfirmationStatement(:0)
            WORKTERRA.BenAdmin.BenAdminControllerAppTier.SaveAndGetData(:0)
            WORKTERRA.BenAdmin.BenAdminControllerAppTier.SaveAndGetData(:0)
            WORKTERRA.ControllerAppTier.SaveAndGetData(:0)             		*Call Stack *
            WORKTERRA.AddChangeTermReport.UpdateDatabase(:0)
            WORKTERRA.AddChangeTermReport.UpdateDatabase(:0)
            WORKTERRA.AddChangeTermReport.CreateDataForAddChangeTermReport(:0)
            WORKTERRA.AddChangeTermReport.Save(:0)
            WORKTERRA.AddChangeTermReport.SaveEnrollmentDataForConfirmationStatement(:0)
            WORKTERRA.BenAdmin.BenAdminControllerAppTier.SaveAndGetData(:0)
            WORKTERRA.BenAdmin.BenAdminControllerAppTier.SaveAndGetData(:0)
            WORKTERRA.ControllerAppTier.SaveAndGetData(:0)


            Link to details from 12 june load test (similar to this issue) should help :

            https://rpm.newrelic.com/accounts/1155082/applications/13257194/transactions#id=5b225765625472616e73616374696f6e2f5743462f574f524b54455252412e49436f6e74726f6c6c6572417070546965722e53617665416e6447657444617461222c22225d&app_trace_id=116b603-656786ff-306d-11e6-a1f2-f8bc12425d50
            vikas.pawar Vikas Pawar (Inactive) made changes -
            Assignee Saurabh Sablaka [ saurabh.sablaka ] 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 -
            Status Approved for Development [ 10003 ] In Development [ 10007 ]
            vikas.pawar Vikas Pawar (Inactive) made changes -
            Priority Medium [ 3 ] High [ 2 ]
            vikas.pawar Vikas Pawar (Inactive) made changes -
            Item State Parent values: LB QA(10201)
            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 ]
            rakeshr Rakesh Roy (Inactive) made changes -
            Assignee Rakesh Roy [ rakeshr ] Venkatesh Pujari [ venkatesh.pujari ]
            venkatesh.pujari Venkatesh Pujari (Inactive) made changes -
            Link This issue is blocked by WT-3547 [ WT-3547 ]
            venkatesh.pujari Venkatesh Pujari (Inactive) made changes -
            Item State Parent values: LB QA(10201) Parent values: LB QA(10201)Level 1 values: On Hold(10211)
            venkatesh.pujari Venkatesh Pujari (Inactive) made changes -
            Status Local Testing [ 10200 ] Pending for Stage Approval [ 10300 ]
            venkatesh.pujari Venkatesh Pujari (Inactive) made changes -
            Status Pending for Stage Approval [ 10300 ] Approved for Stage [ 10030 ]
            venkatesh.pujari Venkatesh Pujari (Inactive) made changes -
            Status Approved for Stage [ 10030 ] Stage Testing [ 10201 ]
            venkatesh.pujari Venkatesh Pujari (Inactive) made changes -
            Item State Parent values: LB QA(10201)Level 1 values: On Hold(10211) Parent values: Stage QA(10202)Level 1 values: Stage Deployed(11602)
            venkatesh.pujari Venkatesh Pujari (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)
            rakeshr Rakesh Roy (Inactive) made changes -
            Developer Vikas Pawar [ vikas.pawar ]
            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)
            venkatesh.pujari Venkatesh Pujari (Inactive) made changes -
            Status Stage Testing [ 10201 ] Pending for Production Approval [ 10301 ]
            venkatesh.pujari Venkatesh Pujari (Inactive) made changes -
            Status Pending for Production Approval [ 10301 ] Approved for production [ 10034 ]
            venkatesh.pujari Venkatesh Pujari (Inactive) made changes -
            Status Approved for production [ 10034 ] Production Testing [ 10202 ]
            venkatesh.pujari Venkatesh Pujari (Inactive) made changes -
            Resolution Fixed [ 1 ]
            Status Production Testing [ 10202 ] Production Complete [ 10028 ]
            venkatesh.pujari Venkatesh Pujari (Inactive) made changes -
            Status Production Complete [ 10028 ] Closed [ 6 ]
            rakeshr Rakesh Roy (Inactive) made changes -
            Item State Parent values: Production QA(10203)Level 1 values: Production Deployed(10221) Parent values: Production Complete(10222)Level 1 values: Closed(10223)

              People

              Assignee:
              venkatesh.pujari Venkatesh Pujari (Inactive)
              Reporter:
              vikas.pawar Vikas Pawar (Inactive)
              Developer:
              Vikas Pawar (Inactive)
              Votes:
              0 Vote for this issue
              Watchers:
              3 Start watching this issue

                Dates

                Created:
                Updated:
                Resolved: