ReportPortal
ReportPortal
Home | Profile | Register | Active Topics | Members | Search | FAQ
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 ReportPortal General Forum
 Report Portal General Issues
 Excel export using lots of client resource
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

dbooth

United Kingdom
69 Posts

Posted - 09/12/2013 :  04:05:59  Show Profile  Reply with Quote
When exporting to Excel destination, the client machine's reporting up to 50% CPU usage and local memory in use climbs - to over 1 GB in one observed case. If left to complete, the resulting Excel file is tiny by comparison.

In Application Settings, both 'Enable Server Formatting' and 'Server side execution' are enabled. When a file is exported though, the server ticks over at very little CPU, while the client machine is locked up. Is this operating as intended?

admin

1637 Posts

Posted - 09/12/2013 :  13:04:52  Show Profile  Reply with Quote
Which version of Excel do you have selected under Admin > Settings > Excel > Version?
Go to Top of Page

dbooth

United Kingdom
69 Posts

Posted - 09/13/2013 :  00:06:02  Show Profile  Reply with Quote
Excel 97-2003, options Localize and Export Data Only set On.
Go to Top of Page

admin

1637 Posts

Posted - 09/13/2013 :  00:24:47  Show Profile  Reply with Quote
Is this an OLAP report?

Is the paging used? If no, do you experience the same problem when it is on?

Could you please try to reproduce this on the demo server?
http://www.reportportal.us
Go to Top of Page

dbooth

United Kingdom
69 Posts

Posted - 09/13/2013 :  07:27:26  Show Profile  Reply with Quote
Hi,

It's OLAP, a large report (one of those more like a data dump... but OLAP is so good at time-bound reports, it's better than raw SQL).

Paging was off, and memory and cpu was being gobbled up before the Excel export. But when the report was fully loaded and export triggered, it basically never completes, and locks up the whole browser in the meantime.

When paging is on, an error is thrown - 'View of 521 Properties Actions' (the report has 521 pages) followed by the MDX report definition. There's no explicit error code or description.

The same error is generated when the export type is csv.
Go to Top of Page

admin

1637 Posts

Posted - 09/13/2013 :  13:34:55  Show Profile  Reply with Quote
Can you please send the screenshot of the error to support@ReportPortal.com?
Go to Top of Page

dbooth

United Kingdom
69 Posts

Posted - 09/25/2013 :  11:59:56  Show Profile  Reply with Quote
This may hopefully assist. Exporting a large Excel OLAP report hangs IE 9, but very quickly is available when RP is run on Chrome. The resulting Excel file is only 6k in size.
Go to Top of Page

admin

1637 Posts

Posted - 09/25/2013 :  19:04:57  Show Profile  Reply with Quote
Thanks but it is very hard to reproduce this problem. Could you please see if you can do this on the demo server?
http://www.reportportal.us
Go to Top of Page

dbooth

United Kingdom
69 Posts

Posted - 09/27/2013 :  03:05:29  Show Profile  Reply with Quote
From testing during quiet hours, its looking like a combination of a large dataset and using OLAP to generate data dumps. Not ideal. Nothing to do with RP though I suspect.
Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
ReportPortal © 2000-2002 Snitz Communications Go To Top Of Page