Project SimpleProject Type: software

Project Simple

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

Query Performance- OES_SP_Get_ACAIRS1095CData

    Details

    • Type: Enhancement
    • Status: Closed
    • Priority: Medium
    • Resolution: Done
    • Component/s: Performance
    • Labels:
      None
    • Module:
      Platform - Performance
    • Reported by:
      Support
    • Item State:
      Development - On Hold
    • Issue Importance:
      Must Have

      Attachments

        Issue Links

        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
          saurabh.sablaka Saurabh Sablaka (Inactive) created issue -
          saurabh.sablaka Saurabh Sablaka (Inactive) made changes -
          Field Original Value New Value
          Component/s Performance [ 10105 ]
          Issue Importance Must Have [ 11800 ]
          Item State Parent values: Development(10200)Level 1 values: Development Backlog(10205)
          Module Parent values: BenAdmin(10100) Parent values: Platform(10106)Level 1 values: Performance(10114)
          Priority Medium [ 3 ] High [ 2 ]
          saurabh.sablaka Saurabh Sablaka (Inactive) made changes -
          Link This issue relates to ST-175 [ ST-175 ]
          vikas.pawar Vikas Pawar (Inactive) made changes -
          Summary Query Performance- GenerateDataForPDFService Query Performance- OES_SP_Get_ACAIRS1095CData
          vikas.pawar Vikas Pawar (Inactive) made changes -
          Description Call Stack:
          WORKTERRA.IRS1095C.GenerateDataForPDFService(:0)
          WORKTERRA.IRSReport.ProcessIRSReport(:0)
          WORKTERRA.IRSReport.SaveAndGetData(:0)
          WORKTERRA.BenAdmin.BenAdminControllerAppTier.SaveAndGetData(:0)

          Stored Proc: OES_SP_Get_ACAIRS1095CData
          		 Call Stack:
          WORKTERRA.IRS1095C.GenerateDataForPDFService(:0)
          WORKTERRA.IRSReport.ProcessIRSReport(:0)
          WORKTERRA.IRSReport.SaveAndGetData(:0)
          WORKTERRA.BenAdmin.BenAdminControllerAppTier.SaveAndGetData(:0)

          For More info
          [https://rpm.newrelic.com/accounts/1155082/applications/13257194_h18260974/transactions#id=5b225765625472616e73616374696f6e2f5743462f574f524b54455252412e49436f6e74726f6c6c6572417070546965722e53617665416e6447657444617461222c22225d&tab-detail_116b603-c137886c-2bcd-11e6-a1f2-f8bc12425d50=database_queries&app_trace_id=116b603-c137886c-2bcd-11e6-a1f2-f8bc12425d50]
          vikas.pawar Vikas Pawar (Inactive) made changes -
          Assignee Saurabh Sablaka [ saurabh.sablaka ]
          vikas.pawar Vikas Pawar (Inactive) made changes -
          Description Call Stack:
          WORKTERRA.IRS1095C.GenerateDataForPDFService(:0)
          WORKTERRA.IRSReport.ProcessIRSReport(:0)
          WORKTERRA.IRSReport.SaveAndGetData(:0)
          WORKTERRA.BenAdmin.BenAdminControllerAppTier.SaveAndGetData(:0)

          For More info
          [https://rpm.newrelic.com/accounts/1155082/applications/13257194_h18260974/transactions#id=5b225765625472616e73616374696f6e2f5743462f574f524b54455252412e49436f6e74726f6c6c6572417070546965722e53617665416e6447657444617461222c22225d&tab-detail_116b603-c137886c-2bcd-11e6-a1f2-f8bc12425d50=database_queries&app_trace_id=116b603-c137886c-2bcd-11e6-a1f2-f8bc12425d50]           		Call Stack:
          WORKTERRA.IRS1095C.GenerateDataForPDFService(:0)
          WORKTERRA.IRSReport.ProcessIRSReport(:0)
          WORKTERRA.IRSReport.SaveAndGetData(:0)
          WORKTERRA.BenAdmin.BenAdminControllerAppTier.SaveAndGetData(:0)

          For More info
          [https://rpm.newrelic.com/accounts/1155082/applications/13257194_h18260974/transactions#id=5b225765625472616e73616374696f6e2f5743462f574f524b54455252412e49436f6e74726f6c6c6572417070546965722e53617665416e6447657444617461222c22225d&tab-detail_116b603-c137886c-2bcd-11e6-a1f2-f8bc12425d50=database_queries&app_trace_id=116b603-c137886c-2bcd-11e6-a1f2-f8bc12425d50]


          [https://rpm.newrelic.com/accounts/1155082/applications/13257194_h18260974/transactions#id=5b225765625472616e73616374696f6e2f5743462f574f524b54455252412e49436f6e74726f6c6c6572417070546965722e53617665416e6447657444617461222c22225d&tab-detail_116b603-ec6f5f0c-2bba-11e6-a1f2-f8bc12425d50=database_queries&app_trace_id=116b603-ec6f5f0c-2bba-11e6-a1f2-f8bc12425d50]
          saurabh.sablaka Saurabh Sablaka (Inactive) made changes -
          Item State Parent values: Development(10200)Level 1 values: Development Backlog(10205) Parent values: Development(10200)Level 1 values: On Hold(10207)
          Priority High [ 2 ] Medium [ 3 ]
          saurabh.sablaka Saurabh Sablaka (Inactive) made changes -
          Assignee Saurabh Sablaka [ saurabh.sablaka ] Nandkumar [ satyap ]
          nandkumar Nandkumar Prabhakar Karlekar (Inactive) made changes -
          Status New Request [ 10029 ] Pending for Approval [ 10002 ]
          nandkumar Nandkumar Prabhakar Karlekar (Inactive) made changes -
          Status Pending for Approval [ 10002 ] Rejected [ 10004 ]
          nandkumar Nandkumar Prabhakar Karlekar (Inactive) made changes -
          Resolution Done [ 10000 ]
          Status Rejected [ 10004 ] Closed [ 6 ]

            People

            Assignee:
            nandkumar Nandkumar Prabhakar Karlekar (Inactive)
            Reporter:
            saurabh.sablaka Saurabh Sablaka (Inactive)
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

              Dates

              Created:
              Updated:
              Resolved: