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 ]
            Hide
            Permalink
            vikas.pawar Vikas Pawar (Inactive) added a comment -

            OES_SP_UpdateAddChangeTermDetails SP optimized and added indexes on AddChangeTermReport and Employee_Enrollment_Intermediate_History

            Show
            vikas.pawar Vikas Pawar (Inactive) added a comment - OES_SP_UpdateAddChangeTermDetails SP optimized and added indexes on AddChangeTermReport and Employee_Enrollment_Intermediate_History
            Hide
            Permalink
            vikas.pawar Vikas Pawar (Inactive) added a comment -

            Committed into LB

            Show
            vikas.pawar Vikas Pawar (Inactive) added a comment - Committed into LB
            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 ]
            Hide
            Permalink
            venkatesh.pujari Venkatesh Pujari (Inactive) added a comment -

            Once the linked ticket will be resolved I will be able to test this.

            Show
            venkatesh.pujari Venkatesh Pujari (Inactive) added a comment - Once the linked ticket will be resolved I will be able to test this.
            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)
            Hide
            Permalink
            venkatesh.pujari Venkatesh Pujari (Inactive) added a comment -

            Tested this on stage on City of Denton for hspl.

            Add Change Term report working fine with no issues.

            Ready for Production.

            Show
            venkatesh.pujari Venkatesh Pujari (Inactive) added a comment - Tested this on stage on City of Denton for hspl. Add Change Term report working fine with no issues. Ready for Production.
            rakeshr Rakesh Roy (Inactive) made changes -
            Developer Vikas Pawar [ vikas.pawar ]
            Hide
            Permalink
            vikas.pawar Vikas Pawar (Inactive) added a comment -

            Committed on Production

            Show
            vikas.pawar Vikas Pawar (Inactive) added a comment - Committed on Production
            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)
            Hide
            Permalink
            venkatesh.pujari Venkatesh Pujari (Inactive) added a comment -

            Tested this on Production on Employbridge for hspl company.

            Add Change Term report working fine with no issues.

            Show
            venkatesh.pujari Venkatesh Pujari (Inactive) added a comment - Tested this on Production on Employbridge for hspl company. Add Change Term report working fine with no issues.
            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)
            Hide
            Permalink
            vikas.pawar Vikas Pawar (Inactive) added a comment - - edited

            This SP is reverted from all branches due to WT-5482 this issue. As Performance optimization was wrong because of that WT-5482 issue occurs on production and we can't optimize this SP further. So reverted this SP from all the branches

            Show
            vikas.pawar Vikas Pawar (Inactive) added a comment - - edited This SP is reverted from all branches due to WT-5482 this issue. As Performance optimization was wrong because of that WT-5482 issue occurs on production and we can't optimize this SP further. So reverted this SP from all the branches
            Transition Time In Source Status Execution Times
            Vikas Pawar (Inactive) made transition -
            New Request Pending for Approval
            		39d 1h 52m 1
            Vikas Pawar (Inactive) made transition -
            Pending for Approval Approved for Development
            		1s 1
            Vikas Pawar (Inactive) made transition -
            Approved for Development In Development
            		1s 1
            Vikas Pawar (Inactive) made transition -
            In Development In LB Testing
            		2d 4h 26m 1
            Venkatesh Pujari (Inactive) made transition -
            In LB Testing Pending for Stage Approval
            		12d 22h 58m 1
            Venkatesh Pujari (Inactive) made transition -
            Pending for Stage Approval Approved for Stage
            		3s 1
            Venkatesh Pujari (Inactive) made transition -
            Approved for Stage Stage Testing
            		3s 1
            Venkatesh Pujari (Inactive) made transition -
            Stage Testing Pending for Production Approval
            		1d 21h 38m 1
            Venkatesh Pujari (Inactive) made transition -
            Pending for Production Approval Approved for production
            		2s 1
            Venkatesh Pujari (Inactive) made transition -
            Approved for production In Production Testing
            		2s 1
            Venkatesh Pujari (Inactive) made transition -
            In Production Testing Production Complete
            		5s 1
            Venkatesh Pujari (Inactive) made transition -
            Production Complete Closed
            		3s 1

              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: