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

 All Forums
 ReportPortal General Forum
 Report Portal General Issues
 Unable to download large reports in Excel format
 New Topic  Reply to Topic
 Printer Friendly
Author  Topic Next Topic  

Sailesh

United Kingdom
25 Posts

Posted - 05/26/2021 :  01:15:26  Show Profile  Reply with Quote
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

admin

1623 Posts

Posted - 05/26/2021 :  15:26:06  Show Profile  Reply with Quote
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"
Go to Top of Page
   Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
Report Portal © RP Go To Top Of Page