What does it show after the following lines:
Entering ExeuteCommand - Command = Render
INFO: RenderFromSession('/ReportFolder/ReportName')
Also check the ExecutionLog3 view - what is the status for the execution of that and what are the three values for the times?
Sue
it shows this:
library!ReportServer_0-2!9e4!02/22/2018-13:36:01:: i INFO: RenderForNewSession('/LiqFinal/LiqFinal')
webserver!ReportServer_0-2!9e4!02/22/2018-13:36:01:: i INFO: Processed report. Report='/LiqFinal/LiqFinal', Stream=''
library!ReportServer_0-2!f8c!02/22/2018-13:36:04:: i INFO: RenderFromSession('/LiqFinal/LiqFinal')
webserver!ReportServer_0-2!f8c!02/22/2018-13:36:04:: i INFO: Processed report. Report='/LiqFinal/LiqFinal', Stream=''
So it's saying that the report did successfully process. Unless something is in the ExecutionLog3 view, I have no idea. But check that view and make sure the status is success, check the format to make sure it was Excel and check the time rendering - maybe you did hit a timeout.
Sue
where can I see the ExecutionLog3 view ??
It's in the ReportServer database - on the server wherever you installed the Reporting Services databases (aka Catalog). Usually on the same server where the rest of SSRS was installed.
Sue
There is a table ExecutionLogStorage that in th field Format says Excel and in the Staturs:rsSuccess
<AdditionalInfo>
<ProcessingEngine>2</ProcessingEngine>
<ScalabilityTime>
<Pagination>0</Pagination>
<Rendering>0</Rendering>
<Processing>0</Processing>
</ScalabilityTime>
<EstimatedMemoryUsageKB>
<Pagination>10</Pagination>
<Rendering>26</Rendering>
<Processing>4</Processing>
</EstimatedMemoryUsageKB>
</AdditionalInfo>
That's close enough - the view is just down one more folder just beneath tables, then expand views.
Anyway that looks normal and nothing close to timing out.
That is a weird one. When you try to export from Report Manager, do you get the same prompts that you get when doing it to Word, PDF? I think one of them is a prompt to open or save...something like that.
Sue