-
Bug
-
Resolution: Fixed
-
High
-
10.123.2, 10.123.3, 10.124.2, 10.125.0, 10.125.3, 10.126.3, 10.127.3
-
19
-
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
- On your Tier 1 Filter Program/Portfolios
- Turn one children and value score
- Export Epics from their grid
- Download file and open
- 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
- is related to
-
JIRAALIGN-870 [JIRAALIGN-870] Work Item Export: Export File Corrupt
- Closed
- relates to
-
JIRAALIGN-7421 Export more than 500 records
- Gathering Interest
-
HOT-106719 Loading...
-
ALIGNSP-22207 Loading...
-
PS-169246 Loading...
- mentioned in
-
Page Loading...
-
Page Loading...
-
Page Loading...
-
Page Loading...
-
Page Loading...
-
Page Loading...
-
Page Loading...
-
Page Loading...
-
Page Loading...
-
Page Loading...
-
Page Loading...
-
Page Loading...
-
Page Loading...
-
Page Loading...
-
Page Loading...
-
Page Loading...
-
Page Loading...
-
Page Loading...
-
Page Loading...
-
Page Loading...
-
Page Loading...
-
Page Loading...
-
Page Loading...
-
Page Loading...
-
Page Loading...
-
Page Loading...
-
Page Loading...
-
Page Loading...
-
Page Loading...
-
Page Loading...
-
Page Loading...
-
Page Loading...
-
Page Loading...
-
Page Loading...
-
Page Loading...
-
Page Loading...
-
Page Loading...
- resolves
-
ACE-3913 Loading...
-
ACE-3914 Loading...
-
ALIGNSP-20629 Loading...
-
ALIGNSP-20655 Loading...
-
ALIGNSP-20836 Loading...
-
ALIGNSP-21417 Loading...
-
ALIGNSP-22097 Loading...
-
ALIGNSP-22328 Loading...
-
ALIGNSP-22389 Loading...
-
ALIGNSP-22808 Loading...
-
ALIGNSP-25326 Loading...
-
ALIGNSP-25374 Loading...
-
PS-141819 Loading...
-
PS-148203 Loading...
-
PS-151059 Loading...
-
PS-158456 Loading...
-
PS-168884 Loading...