ReportPortal
ReportPortal
Home | Profile | Register | Active Topics | Members | Search | FAQ
 All Forums
 ReportPortal General Forum
 Report Portal General Issues
 Excel export using lots of client resource

Note: You must be registered in order to post a reply.
To register, click here. Registration is FREE!

Screensize:
UserName:
Password:
Message:

* HTML is ON
* Forum Code is OFF
Smilies
Smile [:)] Big Smile [:D] Cool [8D] Blush [:I]
Tongue [:P] Evil [):] Wink [;)] Clown [:o)]
Black Eye [B)] Eight Ball [8] Frown [:(] Shy [8)]
Shocked [:0] Angry [:(!] Dead [xx(] Sleepy [|)]
Kisses [:X] Approve [^] Disapprove [V] Question [?]

 
Check here to subscribe to this topic.
   

T O P I C    R E V I E W
dbooth Posted - 09/12/2013 : 04:05:59
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?
8   L A T E S T    R E P L I E S    (Newest First)
dbooth Posted - 09/27/2013 : 03:05:29
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.
admin Posted - 09/25/2013 : 19:04:57
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
dbooth Posted - 09/25/2013 : 11:59:56
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.
admin Posted - 09/13/2013 : 13:34:55
Can you please send the screenshot of the error to support@ReportPortal.com?
dbooth Posted - 09/13/2013 : 07:27:26
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.
admin Posted - 09/13/2013 : 00:24:47
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
dbooth Posted - 09/13/2013 : 00:06:02
Excel 97-2003, options Localize and Export Data Only set On.
admin Posted - 09/12/2013 : 13:04:52
Which version of Excel do you have selected under Admin > Settings > Excel > Version?

ReportPortal © 2000-2002 Snitz Communications Go To Top Of Page