WORKTERRAProject Type: software

WORKTERRA

Uploaded image for project: 'WORKTERRA'
  1. WORKTERRA
  2. WT-10032

ACA: Performance Issue-Getting too much time to export the prime files.

    Details

    • Type: Change Request
    • Status: Production Complete
    • Priority: High
    • Resolution: Done
    • Affects Version/s: None
    • Fix Version/s: None
    • Component/s: None
    • Labels:
    • Environment:
      Production
    • Module:
      ACA
    • Reported by:
      Harbinger
    • Company:
      Prime Healthcare
    • Item State:
      Production Complete
    • Issue Importance:
      Must Have
    • Severity:
      Simple

      Attachments

        Issue Links

        is blocked by

        Bug - A problem which impairs or prevents the functions of the product. WT-9963 Prime Healthcare | Getting error while exporting ACA template.

        • High - Serious problem that could block progress.
        • Closed
        relates to

        Change Request - Change Request WT-9760 ACA: Metso- Incremental transactions on Full file when period is more than one month.

        • Medium - Has the potential to affect progress.
        • Resolution Setting

        Change Request - Change Request WT-8296 ACA Prime File Automation and change file implementation

        • High - Serious problem that could block progress.
        • Closed

          Activity

          Ascending order - Click to sort in descending order
          Permalink
          revansiddha.gaur Revansiddha Gaur (Inactive) logged work - 03/Jul/17 09:00 PM
          • Time Spent:
            8h
             

            Analysis of issue,
            Root cause find out of exporting time unexpected.

          Permalink
          revansiddha.gaur Revansiddha Gaur (Inactive) logged work - 04/Jul/17 09:00 PM
          • Time Spent:
            8h
             

            Scripting for low performance in progress.

          revansiddha.gaur Revansiddha Gaur (Inactive) created issue -
          revansiddha.gaur Revansiddha Gaur (Inactive) made changes -
          Field Original Value New Value
          Link This issue is blocked by WT-9963 [ WT-9963 ]
          revansiddha.gaur Revansiddha Gaur (Inactive) made changes -
          Assignee Vijay Siddha [ vijays ] Revansiddha Gaur [ revansiddha.gaur ]
          revansiddha.gaur Revansiddha Gaur (Inactive) made changes -
          Status New Request [ 10029 ] Pending for Approval [ 10002 ]
          revansiddha.gaur Revansiddha Gaur (Inactive) made changes -
          Status Pending for Approval [ 10002 ] Approved for Development [ 10003 ]
          revansiddha.gaur Revansiddha Gaur (Inactive) made changes -
          Status Approved for Development [ 10003 ] In Development [ 10007 ]
          revansiddha.gaur Revansiddha Gaur (Inactive) made changes -
          Item State Parent values: Development(10200) Parent values: Development(10200)Level 1 values: In Progress(10206)
          revansiddha.gaur Revansiddha Gaur (Inactive) made changes -
          Item State Parent values: Development(10200)Level 1 values: In Progress(10206) Parent values: Development(10200)Level 1 values: Ready for Review(10208)
          revansiddha.gaur Revansiddha Gaur (Inactive) made changes -
          Remaining Estimate 40h [ 144000 ] 32h [ 115200 ]
          Time Spent 8h [ 28800 ]
          Worklog Id 60847 [ 60847 ]
          revansiddha.gaur Revansiddha Gaur (Inactive) made changes -
          Remaining Estimate 32h [ 115200 ] 24h [ 86400 ]
          Time Spent 8h [ 28800 ] 16h [ 57600 ]
          Worklog Id 60848 [ 60848 ]
          revansiddha.gaur Revansiddha Gaur (Inactive) made changes -
          Worklog Id 60848 [ 60848 ]
          revansiddha.gaur Revansiddha Gaur (Inactive) made changes -
          Remaining Estimate 24h [ 86400 ] 16h [ 57600 ]
          Time Spent 16h [ 57600 ] 24h [ 86400 ]
          Worklog Id 60849 [ 60849 ]
          Permalink
          revansiddha.gaur Revansiddha Gaur (Inactive) logged work - 05/Jul/17 09:00 PM - edited
          • Time Spent:
            8h
             

            Scripting for low performance completed & Unit Testing.
            Review Requested.

          Hide
          Permalink
          revansiddha.gaur Revansiddha Gaur (Inactive) added a comment -

          Affected Files (UiRefresh & LB):
          Database Objects\MasterCompanyDB\01_DDL\590_WT-10032_WTB_ACA_NewTable_dbo.ACA_Export_MinimumCostPlan.sql

          Database Objects\MasterCompanyDB\01_DDL\591_WT-10032_WTB_ACA_NewIndex_OES_VIEW_ACA_MinimumCostPlan_TemplateID_UserID_RunDateMaintenance_EmployeeID.sql

          Database Objects\MasterCompanyDB\03_Views\dbo.OES_VIEW_ACA_MinimumCostPlan.sql

          Database Objects\MasterCompanyDB\04_Stored Procedures\dbo.OES_SP_ACA_Export_MinimumCostPlanData.sql

          Database Objects\MasterCompanyDB\04_Stored Procedures\dbo.OES_SP_ACA_GenerateACAExportData.StoredProcedure.sql

          Show
          revansiddha.gaur Revansiddha Gaur (Inactive) added a comment - Affected Files (UiRefresh & LB): Database Objects\MasterCompanyDB\01_DDL\590_ WT-10032 _WTB_ACA_NewTable_dbo.ACA_Export_MinimumCostPlan.sql Database Objects\MasterCompanyDB\01_DDL\591_ WT-10032 _WTB_ACA_NewIndex_OES_VIEW_ACA_MinimumCostPlan_TemplateID_UserID_RunDateMaintenance_EmployeeID.sql Database Objects\MasterCompanyDB\03_Views\dbo.OES_VIEW_ACA_MinimumCostPlan.sql Database Objects\MasterCompanyDB\04_Stored Procedures\dbo.OES_SP_ACA_Export_MinimumCostPlanData.sql Database Objects\MasterCompanyDB\04_Stored Procedures\dbo.OES_SP_ACA_GenerateACAExportData.StoredProcedure.sql
          revansiddha.gaur Revansiddha Gaur (Inactive) made changes -
          Code Review Date 05/Jul/2017
          Code Reviewed By Nandkumar Karlekar [ 11904 ]
          Developer Revansiddha Gaur [ revansiddha.gaur ]
          QA Smita Pawar [ smita.pawar ]
          revansiddha.gaur Revansiddha Gaur (Inactive) made changes -
          Remaining Estimate 16h [ 57600 ] 15.5h [ 55800 ]
          Time Spent 24h [ 86400 ] 24.5h [ 88200 ]
          Worklog Id 61031 [ 61031 ]
          ashwin.wankhede Ashwin Wankhede (Inactive) made changes -
          Item State Parent values: Development(10200)Level 1 values: Ready for Review(10208) Parent values: LB QA(10201)Level 1 values: LB Deployed(11600)
          revansiddha.gaur Revansiddha Gaur (Inactive) made changes -
          Assignee Revansiddha Gaur [ revansiddha.gaur ] Smita Pawar [ smita.pawar ]
          Permalink
          revansiddha.gaur Revansiddha Gaur (Inactive) logged work - 06/Jul/17 09:00 PM
          • Time Spent:
            0.5h
             

            Code Checkins - trunk/lb/uirefresh.

          revansiddha.gaur Revansiddha Gaur (Inactive) made changes -
          Remaining Estimate 15.5h [ 55800 ] 15h [ 54000 ]
          Time Spent 24.5h [ 88200 ] 25h [ 90000 ]
          Worklog Id 61723 [ 61723 ]
          Permalink
          revansiddha.gaur Revansiddha Gaur (Inactive) logged work - 07/Jul/17 09:00 PM
          • Time Spent:
            0.5h
             

            Internal discussion for build issue & corrected code checkins.

          sachin.hingole Sachin Hingole (Inactive) made changes -
          Status In Development [ 10007 ] Local Testing [ 10200 ]
          smita.pawar Smita Pawar (Inactive) made changes -
          Item State Parent values: LB QA(10201)Level 1 values: LB Deployed(11600) Parent values: LB QA(10201)Level 1 values: In Testing(10210)
          Permalink
          smita.pawar Smita Pawar (Inactive) logged work - 27/Jul/17 12:47 PM
          • Time Spent:
            5h
             

            Analysis
            Issue verification
            Jira updates
            Performance stats
            Internal discussion

          Hide
          Permalink
          smita.pawar Smita Pawar (Inactive) added a comment -

          We have verified above mentioned change request on 'Prime Healthcare' LB company,
          Now no server error is received while exporting file.

          Performance stats are as follows.

          10 min to download January file- 14000 records
          12: 30 mins 15105 records Jan to Feb file
          14:30 mins 15712 records Jan to Mar file
          16:30 mins for 16011 records Jan to Apr File
          19:00 mins for 16263 records Jan to May file
          17:30 mins for 16238 records Jan to Jun File

          Show
          smita.pawar Smita Pawar (Inactive) added a comment - We have verified above mentioned change request on 'Prime Healthcare' LB company, Now no server error is received while exporting file. Performance stats are as follows. 10 min to download January file- 14000 records 12: 30 mins 15105 records Jan to Feb file 14:30 mins 15712 records Jan to Mar file 16:30 mins for 16011 records Jan to Apr File 19:00 mins for 16263 records Jan to May file 17:30 mins for 16238 records Jan to Jun File
          smita.pawar Smita Pawar (Inactive) made changes -
          Remaining Estimate 15h [ 54000 ] 10h [ 36000 ]
          Time Spent 25h [ 90000 ] 30h [ 108000 ]
          Worklog Id 67294 [ 67294 ]
          Hide
          Permalink
          smita.pawar Smita Pawar (Inactive) added a comment - - edited

          We will move this enhancement to stage with Prime automation. As issues are open with prime automation hence couldn't update stage and Production dates

          Show
          smita.pawar Smita Pawar (Inactive) added a comment - - edited We will move this enhancement to stage with Prime automation. As issues are open with prime automation hence couldn't update stage and Production dates
          smita.pawar Smita Pawar (Inactive) made changes -
          Link This issue relates to WT-8296 [ WT-8296 ]
          smita.pawar Smita Pawar (Inactive) made changes -
          Production Due Date 07/Sep/2017
          Stage Due Date 28/Aug/17 [ 2017-08-28 ]
          smita.pawar Smita Pawar (Inactive) made changes -
          Item State Parent values: LB QA(10201)Level 1 values: In Testing(10210) Parent values: LB QA(10201)Level 1 values: On Hold(10211)
          smita.pawar Smita Pawar (Inactive) made changes -
          Stage Due Date 28/Aug/17 [ 2017-08-28 ] 20/Sep/17 [ 2017-09-20 ]
          smita.pawar Smita Pawar (Inactive) made changes -
          Stage Due Date 20/Sep/17 [ 2017-09-20 ] 18/Sep/17 [ 2017-09-18 ]
          smita.pawar Smita Pawar (Inactive) made changes -
          Production Due Date 07/Sep/2017 21/Sep/2017
          smita.pawar Smita Pawar (Inactive) made changes -
          Link This issue relates to WT-9760 [ WT-9760 ]
          smita.pawar Smita Pawar (Inactive) made changes -
          Item State Parent values: LB QA(10201)Level 1 values: On Hold(10211) Parent values: LB QA(10201)Level 1 values: Ready for Stage(10213)
          khandu.kshirsagar Khandu Kshirsagar (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)
          smita.pawar Smita Pawar (Inactive) made changes -
          Item State Parent values: Stage QA(10202)Level 1 values: Stage Deployed(11602) Parent values: Stage QA(10202)Level 1 values: In Testing(10214)
          smita.pawar Smita Pawar (Inactive) made changes -
          Production Due Date 21/Sep/2017 11/Oct/2017
          smita.pawar Smita Pawar (Inactive) made changes -
          Item State Parent values: Stage QA(10202)Level 1 values: In Testing(10214) Parent values: Stage QA(10202)Level 1 values: On Hold(10215)
          rakeshr Rakesh Roy (Inactive) made changes -
          Status Local Testing [ 10200 ] Pending for Stage Approval [ 10300 ]
          rakeshr Rakesh Roy (Inactive) made changes -
          Status Pending for Stage Approval [ 10300 ] Approved for Stage [ 10030 ]
          rakeshr Rakesh Roy (Inactive) made changes -
          Status Approved for Stage [ 10030 ] Stage Testing [ 10201 ]
          smita.pawar Smita Pawar (Inactive) made changes -
          Item State Parent values: Stage QA(10202)Level 1 values: On Hold(10215) Parent values: Stage QA(10202)Level 1 values: Ready for Production(10217)
          gaurav.sodani Gaurav Sodani (Inactive) made changes -
          Approval status Need approval for production [ 18456 ]
          Company All Clients/Multiple Clients [ 18434 ]
          Environment Production [ 18442 ]
          Production Due Date 11/Oct/2017 09/Dec/2017
          gaurav.sodani Gaurav Sodani (Inactive) made changes -
          Company All Clients/Multiple Clients [ 18434 ] Prime Healthcare [ 10517 ]
          gaurav.sodani Gaurav Sodani (Inactive) made changes -
          Labels ACA
          gaurav.sodani Gaurav Sodani (Inactive) made changes -
          Item State Parent values: Stage QA(10202)Level 1 values: Ready for Production(10217) Parent values: Stage QA(10202)Level 1 values: On Hold(10215)
          gaurav.sodani Gaurav Sodani (Inactive) made changes -
          Production Due Date 09/Dec/2017
          gaurav.sodani Gaurav Sodani (Inactive) made changes -
          Item State Parent values: Stage QA(10202)Level 1 values: On Hold(10215) Parent values: Production Complete(10222)
          gaurav.sodani Gaurav Sodani (Inactive) made changes -
          Status Stage Testing [ 10201 ] Pending for Production Approval [ 10301 ]
          gaurav.sodani Gaurav Sodani (Inactive) made changes -
          Status Pending for Production Approval [ 10301 ] Approved for production [ 10034 ]
          gaurav.sodani Gaurav Sodani (Inactive) made changes -
          Status Approved for production [ 10034 ] Production Testing [ 10202 ]
          gaurav.sodani Gaurav Sodani (Inactive) made changes -
          Resolution Done [ 10000 ]
          Status Production Testing [ 10202 ] Production Complete [ 10028 ]
          Permalink
          smita.pawar Smita Pawar (Inactive) logged work - 04/Dec/17 01:52 PM
          • Time Spent:
            1h 25m
             

            testing

          smita.pawar Smita Pawar (Inactive) made changes -
          Remaining Estimate 10h [ 36000 ] 8h 35m [ 30900 ]
          Time Spent 30h [ 108000 ] 31h 25m [ 113100 ]
          Worklog Id 99059 [ 99059 ]
          Transition Time In Source Status Execution Times
          Revansiddha Gaur (Inactive) made transition -
          New Request Pending for Approval
          		20m 23s 1
          Revansiddha Gaur (Inactive) made transition -
          Pending for Approval Approved for Development
          		4s 1
          Revansiddha Gaur (Inactive) made transition -
          Approved for Development In Development
          		4s 1
          Sachin Hingole (Inactive) made transition -
          In Development In LB Testing
          		20d 19h 21m 1
          Rakesh Roy (Inactive) made transition -
          In LB Testing Pending for Stage Approval
          		113d 3h 38m 1
          Rakesh Roy (Inactive) made transition -
          Pending for Stage Approval Approved for Stage
          		1m 11s 1
          Rakesh Roy (Inactive) made transition -
          Approved for Stage Stage Testing
          		1m 7s 1
          Gaurav Sodani (Inactive) made transition -
          Stage Testing Pending for Production Approval
          		18d 2h 23m 1
          Gaurav Sodani (Inactive) made transition -
          Pending for Production Approval Approved for production
          		4s 1
          Gaurav Sodani (Inactive) made transition -
          Approved for production In Production Testing
          		3s 1
          Gaurav Sodani (Inactive) made transition -
          In Production Testing Production Complete
          		23s 1

            People

            Assignee:
            smita.pawar Smita Pawar (Inactive)
            Reporter:
            revansiddha.gaur Revansiddha Gaur (Inactive)
            Developer:
            Revansiddha Gaur (Inactive)
            QA:
            Smita Pawar (Inactive)
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

              Dates

              Created:
              Updated:
              Resolved:
              Pre-Prod Due Date:
              Code Review Date:

                Time Tracking

                Estimated:
                Original Estimate - 40h
                40h
                Remaining:
                Time Spent - 31h 25m Remaining Estimate - 8h 35m
                8h 35m
                Logged:
                Time Spent - 31h 25m Remaining Estimate - 8h 35m
                31h 25m