Issue Summary

Due to the number of items included in the export, when a user attempts to export a set of Epics/Stories/Features the completed file can be corrupt because of a timeout.

Steps to Reproduce

1. Export Epics/Stories/Features from their grid
2. Download file and open

Expected Results

File shows the list of exported work items.
The issue typically occurs when we hit the timeout threshold, in which case, the file should not be passed onto the end-user. In case of failure, a better way may be to indicate that the request timed out rather than producing a corrupt file.

Actual Results

File won't open says the file is corrupt

• The most affected work items are Epics, Stories, and Features.
• The export options has a more significant impact, most noticeably the (...) include child objects (...) option.
• The following Splunk logs are recurrently triggered by repro these STR:

   { [-]
     ASP_function: OOFunctionsSql.SetRSParamsCursor
     correlationid: neDG2AHL9zxackvyUEdCsvvspoyqlZ5d6peR4Ru0D9E=
     customer_db: instance_name
     error_description: Query timeout expired
     error_id: 4460
     error_number: -2147217871
     error_source: Microsoft SQL Server Native Client 11.0
     log_type: exception
     logfrom_location: Website-ASP
     sql: EXEC RPM_GET_STORY_LIST 500, 2,N' And tas.IterationGroup In (72,104,75,77,100,78,101,80,79,34,57,33,24,88,82,27,93,90,98,97,95,9,42,35,45,40,44,43,96,73,23,103,29,37,105,25,26,64,65,62,60,63,61,59,99,102,58,81,28,31,39,2,38,67,46,21,20,92,8,30,91,69,66,12,70,71,107,106,108,5,94,36) AND (ti.ReleaseID In (41,40,12,26,44,43,39,46,45,42) Or tas.ReleaseID In (41,40,12,26,44,43,39,46,45,42))', 'tas.StoryID Desc','3722',9,0,'0','0',0,0,NULL,N''
     timestamp: 2020-02-27T14:05:30.003000+00:00
     url: https://instance_name.agilecraft.com:443/ExportData.asp?Type=1
     urlverb: GET
     user: 3722
     version: 10.64.0.2340
  } 

• ExportData also throws the following error:

  Referer: https://instance_name.agilecraft.com/StoryGrid?FirstTime=True	
  cs_Referer: https://instance_name.agilecraft.com/StoryGrid?FirstTime=True	
  cs_uri_query: Type=1|284|800a0e78|Operation_is_not_allowed_when_the_object_is_closed.	
  

• The trailing of the downloaded file typically contains the following error:

  An error occurred on the server when processing the URL. Please contact the system administrator. <p/> If you are the system administrator please click here to find out more about this error.
  

Workaround

Apply context menu or page level filters to reduce the number of work items that are included in the export.