ReportPortal
ReportPortal
Home | Profile | Register | Active Topics | Members | Search | FAQ
 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:
Anti-Spam Code:
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
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 © 2000-2002 Snitz Communications Go To Top Of Page