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

            I did analysis for the this SP on my local machine. It was taking 2-3 seconds to execute before optimization. And now its taking less than one second

            Show
            vikas.pawar Vikas Pawar (Inactive) added a comment - I did analysis for the this SP on my local machine. It was taking 2-3 seconds to execute before optimization. And now its taking less than one second
            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 ]
            Hide
            Permalink
            vikas.pawar Vikas Pawar (Inactive) added a comment -

            Venkatesh Pujari Need to test View History and ACT reports for this change.

            Show
            vikas.pawar Vikas Pawar (Inactive) added a comment - Venkatesh Pujari Need to test View History and ACT reports for this change.
            Hide
            Permalink
            venkatesh.pujari Venkatesh Pujari (Inactive) added a comment -

            Hi Vikas,

            Server Error is being displayed on preview of ACT report on LB on LBSanityCOD company. Please find the below error log:-

            ErrorID : 0
            ErrorSource : ControllerAppTier.SaveAndGetData->BenAdminControllerAppTier.SaveAndGetData->StaticReports.SaveAndGetData->AddChangeTermReport.Save->AddChangeTermReport.CreateDataForAddChangeTermReport->AddChangeTermReport.UpdateDatabase
            ErrorMessage: Cannot bulk load because the file "\\10.0.2.160\WORKterra\Reports\BulkInsert_ywa0lnawkalu5w1yeyyni1vf.txt" could not be opened. Operating system error code 1326(Logon failure: unknown user name or bad password.).

            Thanks,
            Venkatesh

            Show
            venkatesh.pujari Venkatesh Pujari (Inactive) added a comment - Hi Vikas, Server Error is being displayed on preview of ACT report on LB on LBSanityCOD company. Please find the below error log:- ErrorID : 0 ErrorSource : ControllerAppTier.SaveAndGetData->BenAdminControllerAppTier.SaveAndGetData->StaticReports.SaveAndGetData->AddChangeTermReport.Save->AddChangeTermReport.CreateDataForAddChangeTermReport->AddChangeTermReport.UpdateDatabase ErrorMessage: Cannot bulk load because the file "\\10.0.2.160\WORKterra\Reports\BulkInsert_ywa0lnawkalu5w1yeyyni1vf.txt" could not be opened. Operating system error code 1326(Logon failure: unknown user name or bad password.). Thanks, Venkatesh
            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 ]
            Hide
            Permalink
            vikas.pawar Vikas Pawar (Inactive) added a comment -

            Hi Venkatesh Pujari,

            This was other issue on LB. This was getting crashed before call to this SP. Please check once on LB. Assigning it to you.

            Show
            vikas.pawar Vikas Pawar (Inactive) added a comment - Hi Venkatesh Pujari , This was other issue on LB. This was getting crashed before call to this SP. Please check once on LB. Assigning it to you.
            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)
            Hide
            Permalink
            venkatesh.pujari Venkatesh Pujari (Inactive) added a comment -

            Tested this on LB for LBSanityCOD company. Ready for Stage

            Show
            venkatesh.pujari Venkatesh Pujari (Inactive) added a comment - Tested this on LB for LBSanityCOD company. Ready for Stage
            Hide
            Permalink
            vikas.pawar Vikas Pawar (Inactive) added a comment -

            Checked in file on stage.

            Show
            vikas.pawar Vikas Pawar (Inactive) added a comment - Checked in file on stage.
            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)
            Hide
            Permalink
            rakeshr Rakesh Roy (Inactive) added a comment -

            Working fine

            Show
            rakeshr Rakesh Roy (Inactive) added a comment - Working fine
            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 ]
            Hide
            Permalink
            venkatesh.pujari Venkatesh Pujari (Inactive) added a comment -

            Tested this on Production on Austin for hspl company.Working fine with no issues

            Show
            venkatesh.pujari Venkatesh Pujari (Inactive) added a comment - Tested this on Production on Austin for hspl company.Working fine with no issues
            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 ]
            Transition Time In Source Status Execution Times
            Vikas Pawar (Inactive) made transition -
            New Request Pending for Approval
            		28d 6h 2m 1
            Vikas Pawar (Inactive) made transition -
            Pending for Approval Approved for Development
            		2s 1
            Vikas Pawar (Inactive) made transition -
            Approved for Development In Development
            		2s 1
            Venkatesh Pujari (Inactive) made transition -
            In LB Testing Reopen in Local
            		1d 2h 18m 1
            Rakesh Roy (Inactive) made transition -
            Reopen in Local In Development
            		53d 21h 16m 1
            Rakesh Roy (Inactive) made transition -
            In Development In LB Testing
            		33d 20h 13m 2
            Venkatesh Pujari (Inactive) made transition -
            In LB Testing Pending for Stage Approval
            		2d 21h 13m 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
            		2s 1
            Venkatesh Pujari (Inactive) made transition -
            Stage Testing Pending for Production Approval
            		3d 4h 43m 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
            		47m 35s 1
            Venkatesh Pujari (Inactive) made transition -
            Production Complete Closed
            		9s 1

              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: