ReportPortal: Zero-footprint OLAP client for Microsoft Analysis Services

ReportPortal

All Forums

ReportPortal General Forum

Report Portal General Issues

Unable to download large reports in Excel format

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

Check here to include your profile signature.
Check here to subscribe to this topic.

T O P I C R E V I E W
Sailesh	Posted - 05/26/2021 : 01:15:26 Hi We recently updated ReportPortal to version 6.0, Build 205. The users have reported that they are now not able to download large reports in Excel format. When I checked the Administrative Event log I can see below message: 3005 An unhandled exception has occurred. 25/05/2021 16:38:37 25/05/2021 15:38:37 ec289734b40e41d2bec2ac7f3b264029 20922 5 0 /LM/W3SVC/1/ROOT/ReportPortal-1-132663888118828880 Full /ReportPortal c:\inetpub\wwwroot\reportportal_205\ UKDANFPRD 5668 w3wp.exe IIS APPPOOL\DefaultAppPool InvalidOperationException The Writer is closed or in error state. at System.Xml.XmlWellFormedWriter.AdvanceState(Token token) at System.Xml.XmlWellFormedWriter.WriteStartElement(String prefix, String localName, String ns) at System.Xml.XmlWriter.WriteElementString(String localName, String value) at ReportPortal.Excel2007.WriteStringTable(Stream output) at ReportPortal.Excel2007.AddStringTableFile(ZipOutputStream& oZipFile) at ReportPortal.Excel2007.GetMemoryStream(String sDir, DataTable oTable) at ReportPortal.SqlReportExport.GetExcel2007(String reportId, Boolean bUserFilter, String sDir, String sJobId) at ReportPortal.ExportSql.Page_Load(Object sender, EventArgs e) at System.Web.UI.Control.OnLoad(EventArgs e) at System.Web.UI.Control.LoadRecursive() at System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) http://dan/reportportal/sql/ExportSql.aspx?mode=xls&reportType=2&reportId=20947&txt1=01/04/2021&txt2=0&txt3=31/05/2021&transpose=0 /reportportal/sql/ExportSql.aspx 180.100.20.253 SBCL\sailesh.patel True Negotiate IIS APPPOOL\DefaultAppPool 81 IIS APPPOOL\DefaultAppPool False at System.Xml.XmlWellFormedWriter.AdvanceState(Token token) at System.Xml.XmlWellFormedWriter.WriteStartElement(String prefix, String localName, String ns) at System.Xml.XmlWriter.WriteElementString(String localName, String value) at ReportPortal.Excel2007.WriteStringTable(Stream output) at ReportPortal.Excel2007.AddStringTableFile(ZipOutputStream& oZipFile) at ReportPortal.Excel2007.GetMemoryStream(String sDir, DataTable oTable) at ReportPortal.SqlReportExport.GetExcel2007(String reportId, Boolean bUserFilter, String sDir, String sJobId) at ReportPortal.ExportSql.Page_Load(Object sender, EventArgs e) at System.Web.UI.Control.OnLoad(EventArgs e) at System.Web.UI.Control.LoadRecursive() at System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) Regards Sailesh Scott Bader
2 L A T E S T R E P L I E S (Newest First)
Sailesh	Posted - 07/05/2021 : 02:17:56 Thank you the fix works. Scott Bader
admin	Posted - 05/26/2021 : 15:26:06 Please try this fix: 1. Download and unzip: https://reportportal.com/download/rp_205_Excel_RP_DLL.zip 2. Backup old file to an external folder and copy the unzipped file to: "C:\inetpub\wwwroot\ReportPortal\bin\ReportPortal.dll"

ReportPortal