ReportPortal: Zero-footprint OLAP client for Microsoft Analysis Services

ReportPortal

All Forums

ReportPortal General Forum

Report Portal General Issues

Subscriptions crash for ContentType=Excel, No Data

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

[quote][i]Originally posted by fdranguet[/i]
[br]Hello,

we recently migrated to build 202 (from build 199); since then we noticed a number of issues with subscriptions. After investigations, we found that if the content type is excel, and there is no data, the subscription will crash with the following error:

"Excel2007.GetMemoryStreamFromXml() could not load an XML: No Data" (see full stack trace at the end of this message).

We have an environment where we use the VB script to manually execute the schedule queues; thus for us, if one of those queues is having a subscription with those circumstances, the full queue execution will crash and all the subsequent subscriptions in the queue after the one affected will not be executed, which is a serious enough issue.

Could you please check this bug asap and provide us with an hotfix? Many thanks.

Full Stack Trace:
<code><pre>[Exception: Excel2007.GetMemoryStreamFromXml() could not load an XML: No Data]
   ReportPortal.Excel2007.#8236;#8207;#8235;#8236;#8299;#8207;#8204;#8204;#8207;#8237;#8206;#8235;#8236;#8207;#8235;#8207;#8238;#8203;#8203;#8300;#8303;#8235;#8299;#8205;#8206;#8206;#8302;#8234;#8205;#8302;#8207;#8234;#8299;#8302;#8236;#8299;#8238;#8234;#8236;#8238;(String , Int32 ) +7125
   ReportPortal.Excel2007.GetMemoryStreamFromXml(String sDir, String sXml) +163
   ReportPortal.Scheduler.#8234;#8204;#8205;#8302;#8298;#8236;#8238;#8207;#8236;#8206;#8298;#8299;#8298;#8298;#8300;#8237;#8300;#8204;#8299;#8237;#8206;#8207;#8302;#8301;#8236;#8303;#8300;#8238;#8203;#8301;#8207;#8300;#8303;#8203;#8207;#8206;#8206;#8235;#8207;#8206;#8238;(String , String , Int32 , String , String ) +1010
   ReportPortal.Scheduler.#8205;#8300;#8303;#8303;#8235;#8302;#8234;#8235;#8238;#8302;#8206;#8303;#8238;#8302;#8299;#8203;#8234;#8204;#8235;#8298;#8234;#8207;#8299;#8300;#8204;#8298;#8300;#8299;#8303;#8301;#8302;#8299;#8203;#8300;#8204;#8300;#8206;#8238;#8235;#8207;#8238;(String , String , String , String , String , String , String , String , String , String , String , String , String , String , String , String , String& , String& , String& , String& , String& , String& , String& , Boolean& , String& , String , String , String& , String , String& , Int32 , String , String& , String , String& ) +4440
   ReportPortal.Scheduler.#8237;#8204;#8237;#8203;#8302;#8234;#8236;#8207;#8299;#8236;#8300;#8303;#8236;#8303;#8298;#8235;#8206;#8238;#8303;#8301;#8302;#8204;#8300;#8203;#8235;#8203;#8238;#8206;#8203;#8234;#8237;#8301;#8205;#8236;#8237;#8301;#8298;#8204;#8207;#8206;#8238;(String , String ) +16466
   ReportPortal.UrlTrigger.#8237;#8298;#8204;#8205;#8236;#8203;#8207;#8236;#8236;#8238;#8204;#8234;#8236;#8235;#8298;#8205;#8206;#8204;#8205;#8204;#8238;#8302;#8299;#8237;#8204;#8303;#8204;#8204;#8206;#8206;#8238;#8298;#8301;#8298;#8299;#8235;#8300;#8235;#8300;#8206;#8238;(Object , EventArgs ) +675
   System.Web.UI.Control.OnLoad(EventArgs e) +106
   System.Web.UI.Control.LoadRecursive() +68
   System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +3785

</code></pre>
Regards,
Fran�ois Dranguet
Information Manager
Scott Bader SAS
T�l: +33 (0)3 22 66 27 60
[/quote]

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
fdranguet	Posted - 06/24/2019 : 06:45:51 Hello, we recently migrated to build 202 (from build 199); since then we noticed a number of issues with subscriptions. After investigations, we found that if the content type is excel, and there is no data, the subscription will crash with the following error: "Excel2007.GetMemoryStreamFromXml() could not load an XML: No Data" (see full stack trace at the end of this message). We have an environment where we use the VB script to manually execute the schedule queues; thus for us, if one of those queues is having a subscription with those circumstances, the full queue execution will crash and all the subsequent subscriptions in the queue after the one affected will not be executed, which is a serious enough issue. Could you please check this bug asap and provide us with an hotfix? Many thanks. Full Stack Trace: [Exception: Excel2007.GetMemoryStreamFromXml() could not load an XML: No Data] ReportPortal.Excel2007.#8236;#8207;#8235;#8236;#8299;#8207;#8204;#8204;#8207;#8237;#8206;#8235;#8236;#8207;#8235;#8207;#8238;#8203;#8203;#8300;#8303;#8235;#8299;#8205;#8206;#8206;#8302;#8234;#8205;#8302;#8207;#8234;#8299;#8302;#8236;#8299;#8238;#8234;#8236;#8238;(String , Int32 ) +7125 ReportPortal.Excel2007.GetMemoryStreamFromXml(String sDir, String sXml) +163 ReportPortal.Scheduler.#8234;#8204;#8205;#8302;#8298;#8236;#8238;#8207;#8236;#8206;#8298;#8299;#8298;#8298;#8300;#8237;#8300;#8204;#8299;#8237;#8206;#8207;#8302;#8301;#8236;#8303;#8300;#8238;#8203;#8301;#8207;#8300;#8303;#8203;#8207;#8206;#8206;#8235;#8207;#8206;#8238;(String , String , Int32 , String , String ) +1010 ReportPortal.Scheduler.#8205;#8300;#8303;#8303;#8235;#8302;#8234;#8235;#8238;#8302;#8206;#8303;#8238;#8302;#8299;#8203;#8234;#8204;#8235;#8298;#8234;#8207;#8299;#8300;#8204;#8298;#8300;#8299;#8303;#8301;#8302;#8299;#8203;#8300;#8204;#8300;#8206;#8238;#8235;#8207;#8238;(String , String , String , String , String , String , String , String , String , String , String , String , String , String , String , String , String& , String& , String& , String& , String& , String& , String& , Boolean& , String& , String , String , String& , String , String& , Int32 , String , String& , String , String& ) +4440 ReportPortal.Scheduler.#8237;#8204;#8237;#8203;#8302;#8234;#8236;#8207;#8299;#8236;#8300;#8303;#8236;#8303;#8298;#8235;#8206;#8238;#8303;#8301;#8302;#8204;#8300;#8203;#8235;#8203;#8238;#8206;#8203;#8234;#8237;#8301;#8205;#8236;#8237;#8301;#8298;#8204;#8207;#8206;#8238;(String , String ) +16466 ReportPortal.UrlTrigger.#8237;#8298;#8204;#8205;#8236;#8203;#8207;#8236;#8236;#8238;#8204;#8234;#8236;#8235;#8298;#8205;#8206;#8204;#8205;#8204;#8238;#8302;#8299;#8237;#8204;#8303;#8204;#8204;#8206;#8206;#8238;#8298;#8301;#8298;#8299;#8235;#8300;#8235;#8300;#8206;#8238;(Object , EventArgs ) +675 System.Web.UI.Control.OnLoad(EventArgs e) +106 System.Web.UI.Control.LoadRecursive() +68 System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +3785 Regards, Fran�ois Dranguet Information Manager Scott Bader SAS T�l: +33 (0)3 22 66 27 60
2 L A T E S T R E P L I E S (Newest First)
fdranguet	Posted - 06/26/2019 : 01:56:21 Hello, I confirm the fix you provided above resolved this issue. Thanks for your fast answer on this! Regards, Fran�ois Dranguet Information Manager Scott Bader SAS T�l: +33 (0)3 22 66 27 60
admin	Posted - 06/25/2019 : 01:28:27 Please try this patch: 1. Download: http://www.reportportal.com/download/rp_202_URL_Trigger_DLL.zip 2. Backup old file to an external folder and copy unzipped to: "C:\inetpub\wwwroot\ReportPortal\bin\ReportPortal.dll"

ReportPortal