• Sue_H - Thursday, February 22, 2018 11:08 AM

    sistemas_casinomnes - Thursday, February 22, 2018 11:03 AM

    Sue_H - Thursday, February 22, 2018 10:56 AM

    sistemas_casinomnes - Thursday, February 22, 2018 9:40 AM

    Sue_H - Thursday, February 22, 2018 7:42 AM

    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>