Export of large tables to Excel or CSV

eazyBI for Jira

By default Jira uses Tomcat 7 server for serving HTTP requests. Tomcat by default sets maximum size of HTTP POST requests to 2MB. If you export to Excel or CSV eazyBI table report with many thousand rows then data for export are sent from browser to Jira server using POST request and the size can exceed this 2MB limit. As a result you might get an error as Tomcat server will not accept these POST request parameters.

To solve this issue you need to change Jira Tomcat configuration to allow accepting unlimited size POST requests.

In Jirainstallation directory please edit conf/server.xml file in Jira installation directory and in the <Connector> XML element add attribute maxPostSize="104857600".

As a result it will look something like this (see the last line with maxPostSize):

<Connector port="8080"

maxThreads="150"
minSpareThreads="25"
connectionTimeout="20000"

enableLookups="false"
maxHttpHeaderSize="8192"
protocol="HTTP/1.1"
useBodyEncodingForURI="true"
redirectPort="8443"
acceptCount="100"
disableUploadTimeout="true"
 
maxPostSize="104857600"
/>

After this change you need to restart Jira server.