Project SimpleProject Type: software

Project Simple

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

Query Performance - OES_SP_ACTWaivedEnrollment

    Details

    • Type: Enhancement
    • Status: Closed
    • Priority: Medium
    • 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)

      For more info
      https://rpm.newrelic.com/accounts/1155082/applications/13257194_h18260974/transactions#id=5b225765625472616e73616374696f6e2f5743462f574f524b54455252412e49436f6e74726f6c6c6572417070546965722e53617665416e6447657444617461222c22225d&tab-detail_116b603-295bb804-2536-11e6-a1f2-f8bc12425d50=database_queries&app_trace_id=116b603-295bb804-2536-11e6-a1f2-f8bc12425d50

        Attachments

        1. Stage_pass.png
          Stage_pass.png
          234 kB
        2. Stage_pass2.png
          Stage_pass2.png
          134 kB

          Issue Links

          causes

          Bug - A problem which impairs or prevents the functions of the product. WT-5177 Company Down : Softchoice >> Server error while downloading Add change Term Report

          • 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
            Assignee Saurabh Sablaka [ saurabh.sablaka ]
            vikas.pawar Vikas Pawar (Inactive) made changes -
            Link This issue relates to ST-175 [ ST-175 ]
            vikas.pawar Vikas Pawar (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)


            For more info
            https://rpm.newrelic.com/accounts/1155082/applications/13257194_h18260974/transactions#id=5b225765625472616e73616374696f6e2f5743462f574f524b54455252412e49436f6e74726f6c6c6572417070546965722e53617665416e6447657444617461222c22225d&tab-detail_116b603-295bb804-2536-11e6-a1f2-f8bc12425d50=database_queries&app_trace_id=116b603-295bb804-2536-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 ]
            gokul.sonawane Gokul Sonawane (Inactive) made changes -
            Item State Parent values: LB QA(10201)Level 1 values: LB Deployed(11600)
            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 -
            Status Local Testing [ 10200 ] Reopen in Local [ 10018 ]
            venkatesh.pujari Venkatesh Pujari (Inactive) made changes -
            Item State Parent values: LB QA(10201)Level 1 values: LB Deployed(11600) Parent values: LB QA(10201)Level 1 values: Re-open(10212)
            venkatesh.pujari Venkatesh Pujari (Inactive) made changes -
            Assignee Venkatesh Pujari [ venkatesh.pujari ] Vikas Pawar [ vikas.pawar ]
            vikas.pawar Vikas Pawar (Inactive) made changes -
            Assignee Vikas Pawar [ vikas.pawar ] Venkatesh Pujari [ venkatesh.pujari ]
            rakeshr Rakesh Roy (Inactive) made changes -
            Status Reopen in Local [ 10018 ] In Development [ 10007 ]
            rakeshr Rakesh Roy (Inactive) made changes -
            Status In Development [ 10007 ] Local Testing [ 10200 ]
            rakeshr Rakesh Roy (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)
            venkatesh.pujari Venkatesh Pujari (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)
            gokul.sonawane Gokul Sonawane (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)
            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 ]
            rakeshr Rakesh Roy (Inactive) made changes -
            Attachment Stage_pass.png [ 28406 ]
            rakeshr Rakesh Roy (Inactive) made changes -
            Attachment Stage_pass2.png [ 28407 ]
            rakeshr Rakesh Roy (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)
            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 Done [ 10000 ]
            Status Production Testing [ 10202 ] Production Complete [ 10028 ]
            venkatesh.pujari Venkatesh Pujari (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)
            venkatesh.pujari Venkatesh Pujari (Inactive) made changes -
            Resolution Done [ 10000 ] Fixed [ 1 ]
            Status Production Complete [ 10028 ] Closed [ 6 ]
            prasanna Prasanna Karlekar (Inactive) made changes -
            Link This issue is caused by WT-5177 [ WT-5177 ]
            prasanna Prasanna Karlekar (Inactive) made changes -
            Link This issue is caused by WT-5177 [ WT-5177 ]
            prasanna Prasanna Karlekar (Inactive) made changes -
            Link This issue causes WT-5177 [ WT-5177 ]

              People

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

                Dates

                Created:
                Updated:
                Resolved: