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

          Descending order - Click to sort in ascending order
          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
          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
          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

            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