Export list to XLSX

[NANDAN247]

In windchill 12.0 when we try to export a large report to XLSX format, the page keeps loading and the excel sheet is not generated/downloaded. These report contains around 150000 item, but we were able to generate the report into excel format when we were using 11.0 within few minutes but now it keeps on loading endlessly.

[BenLoosli]

Is it the same version of Excel?

I would open a case with tech support as I doubt any user can solve this, unless they have also run into this issue.

[SWeiler_9940261]

Are you using a reverse proxy? I've seen the following error when exporting to XLSX:

Proxy Error. The proxy server received an invalid response from an upstream server.

If you are using a reverse proxy, did you see any errors in the Apache logs?

[NANDAN247]

Thank you for your reply.

When the export list to file window opens it keeps on loading endlessly. When I run report with less items then the XLSX export is completed this issue is only for reports with large number of items.

Yes I checked the logs there is no error information.

[SWeiler_9940261]

I looked to see if you are exceeding the limits. I found this reference:

https://www.ptc.com/en/support/article/CS52471

• The property com.ptc.jca.exportRowLimit determines the maximum number of rows that can be exported for a table
• The default value is the maximum number of rows that Microsoft Excel 2003 can handle (65535) and 1048576 max rows for Microsoft Excel 2007, 2010

[NANDAN247]

We had tried this as well before but no luck 

[NANDAN247]

Can you please let me know what did you do to fix this with reverse proxy settings? Did you increase the limit in the reverse proxy server?

[SWeiler_9940261]

Increased the limit of com.ptc.jca.exportRowLimit (It was set to the maximum of Excel 2003; 65535) and also did a dnsflush as there was a proxy error. We were seeing an error in the apache log: AH01102: error reading status line from remote server

[SWeiler_9940261]

Ran into another similar situation. Was able to solve it. See thread:
https://community.ptc.com/t5/Windchill/Proxy-error-on-Export-of-large-XLSX-file/m-p/796376#M66835