Uploaded image for project: 'Jira Align'
  1. Jira Align
  2. JIRAALIGN-5356

Export Epics - Exporting Epics are getting timeout errors and generating corrupted files

XMLWordPrintable

    • 16
    • Severity 3 - Minor
    • No

      Issue Summary

      During Epics export the users receive corrupted files when exporting a large number of registers in the scope
      Also, the query which runs the export is exiting as a timeout.

      • Happens with Capabilities as well.
      • Happens with Features as well.

      This is reproducible : (yes) 

      Steps to Reproduce

      1. On your Tier 1 Filter Program/Portfolios
      2. Turn one children and value score
      3. Export Epics from their grid
      4. Download file and open
      5. Note the File is corrupted

      Expected Results

      If Jira Align has a limitation an error message should show explaining that, otherwise generates the file without issues

      Actual Results

      The below exception is thrown in the file:

      IIS Request error 500 

      2023-09-05 12:14:37 172.28.1.159 GET /ExportData Portfolios=13,4,3,11,2,6,10,5&FilterID=483&Type=4|1363|800a0e78|Operation_is_not_allowed_when_the_object_is_closed. 443 52 172.28.170.28 Mozilla/5.0+(Windows+NT+10.0;+Win64;+x64)+AppleWebKit/537.36+(KHTML,+like+Gecko)+Chrome/116.0.0.0+Safari/537.36 https://CUSTOMER.jiraalign.com/EpicGrid?FirstTime=True&Portfolios=13,4,3,11,2,6,10,5&FilterID=483 CUSTOMER.jiraalign.com 500 0 0 30248
      host = PR-US-02-WEB-Q4sc_status = 500source = C:\inetpub\logs\LogFiles\W3SVC10\u_ex230905.logsourcetype = ms:iis:auto
      

      ASP error

      { [-]
         ASP_function: OOFunctionsSql.SetRSParamsCursor
         correlationid: 7Ztz9YSnbS0IIAgLt/LC1++hBdD9HcV/bnY+FlEHRN4=
         customer_db: CUSTOMER   
         error_description: Query timeout expired
         error_id: 3808
         error_number: -2147217871
         error_source: Microsoft SQL Server Native Client 11.0
         log_type: exception
         logfrom_location: Website-ASP
         sql: EXEC RPM_GET_FEATURE_GRP_LIST 500, 1, N'%%',N' And P.State   not in (3) And (p.IterationGroup in (66,58,44,49,54,40,41,15,11,35,65,72,27,21,33,46,47,17,39,36,51,8,9,53,45,4,10,32,43,18,28,57,60,55,50,56,2,25,63,70,14,3,5,76,71,13,29,52,22,23,38,20,73,42,34,37,80,64,81,82,75) Or p.FeatureGroupID in (Select FeatureGroupID from tblFeatureGroupMultiProgramRel Where ProgramID in (66,58,44,49,54,40,41,15,11,35,65,72,27,21,33,46,47,17,39,36,51,8,9,53,45,4,10,32,43,18,28,57,60,55,50,56,2,25,63,70,14,3,5,76,71,13,29,52,22,23,38,20,73,42,34,37,80,64,81,82,75))) And ((EpicObjectID = 2) or (EpicObjectID is null and parentid is Null))','p.FeatureGroupID Asc','52',9,NULL,NULL,NULL,NULL,NULL,1,NULL,0,NULL,N'',N'FeatureGroupID,GroupName,ThemeID,State,GroupDesc,BudgetTW,uid,BubbleColor,EstimateTW,Points,TShirt,TShirtName,LifeCycleState,Fullname,Email,FeatureCount,CommentCount,CommentStatus,AcceptanceCount,DevelopmentalStep,ItemID,ColumnID,LeanTaskBoard,TotalBlockedFeatures,StateDesc,Type,Split,ParentSplit,ProgramName,ThemeName,StrategicDriver,Investment,ValueScale,MMF,ReportColor,Tags,EstimationType,EstimationPointType,ParentID,EpicObjectID,AdditionalPrograms,ExternalKey,Capitalized,Releases,Rank,StrategyGoal,Quadrant,TargetDate,StartDate,PortfolioAskDate,FundingStage,Emails,FutureState,CurrentSituation,Recomendation,SupportRequired,AnalysisSummary,Notes,Sponsors,PersonasAffected,SuccessCriteria,Budget,CapEx,CapExE,OpEx,OpExE,IRate,InitialInv,EfficiencyDividend,SpendToDate,EstimateAtCompletion,RevenueAssurance,ROI,FYears,FQuarters,FMonths,CDrop1,CDrop2,CDrop3,Company,StrategicHorizon,Customers,AffectedCountries,CDrop1Val,CDrop2Val,CDrop3Val,CDrop4Val,CDrop5Val,CText1,CText2,CArea1,ForecastYears,ForecastQuarters,ForecastMonths,BusinessImpact,RiskAppetite,ITRisk,FailureImpact,FailureProbability,HealthBudget,HealthBudgetDesc,HealthPeople,HealthPeopleDesc,HealthQuality,HealthQualityDesc,HealthRisk,HealthRiskDesc,HealthSchedule,HealthScheduleDesc,CreateDate,DemoStatusDate,ParentGoal,EngMrktScore,AbilityExec,ParentEpic,IterationGroup,TotalStories,TotalLoE,CompletedLOE,InProgressLOE,TotalReleaseDays,DaysLeft,MultiPortfolio,TotalChildItems,NotStartedChildItems,InProgressChildItems,CompletedChildItems,PortfolioID,ProgressBarType,ProgressViewType,TotalCapabilityItems,Dependencies,StoryPoints,FuncArea,JiraProject,WorkCode,WorkCodeDescription,Age',N'',2
         timestamp: 2023-09-05T08:14:38.275000-04:00
         url: https://CUSTOMER.jiraalign.com:443/ExportData.asp?Portfolios=13,4,3,11,2,6,10,5&FilterID=483&Type=4
         urlverb: GET
         user: 52
         version: 10.123.3.35317
      }
      

       

      Workaround

      Decrease the scope in the Tier 1 filter and try to export by looking at fewer Programs/Portfolios

            dfuller@atlassian.com Don Fuller
            f58471712ff6 Victor Fragoso
            Votes:
            33 Vote for this issue
            Watchers:
            59 Start watching this issue

              Created:
              Updated: