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
            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
            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
            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.
            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.
            Hide
            Permalink
            rakeshr Rakesh Roy (Inactive) added a comment -

            Working fine

            Show
            rakeshr Rakesh Roy (Inactive) added a comment - Working fine
            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

              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: