Post reply

SSRS report rendering to PDF is failing. [RESOLVED]

  • June 13, 2022 at 2:54 pm

    #4048775

    This was resolved with a reboot...

    PDF rendering stopped working for no apparent reason. No changes were made. Users exported PDFs on Thur, but stopped working on Friday. Fails in Edge and Chrome. Doesn't matter what report could be 20 pages or a single record with 3 columns.

    Error from event log:

    Microsoft.ReportingServices.ReportProcessing.UnhandledReportRenderingException: An error occurred during rendering of the report. ---> Microsoft.ReportingServices.OnDemandReportRendering.ReportRenderingException: An error occurred during rendering of the report. ---> System.ArgumentException: Parameter is not valid.

     

    All other formats work fine. Could this be an Adobe licensing thing?

    MS has some explanations here but there's nothing in the config specific to any of these items.

    https://docs.microsoft.com/en-us/sql/reporting-services/troubleshooting/rrrenderingerror-reporting-services-error?view=sql-server-ver16#explanation

    Anyone have any suggestions?

    • This topic was modified 2 years, 5 months ago by  TangoVictor.
    • This topic was modified 2 years, 5 months ago by  TangoVictor.

  • June 13, 2022 at 3:51 pm

    #4048831

    Were Windows updates installed?

    Sounds like a query or data issue. Do the affected reports have anything (e.g, a parameter) in common?

    Did something change in stored procedure(s)? New data that might be inconsistent (e.g., null when null isn't expected or unexpected datatype or length)? Were reports re-deployed unbenownst?

    Do you have trace files or extended events to show the queries that were executed? If not, I'd suggest reproducing to capture the queries.

    In either case, execute the queries and look for the unexpected.

  • June 13, 2022 at 4:12 pm

    #4048842

    Tech guys said no Windows updates were installed.

    Everything I've tested works fine for other formats, it's just PDF. Maybe there was an automated update.

    The only thing I haven't tried yet is to create a new report and test it. Will be doing that shortly.

  • June 13, 2022 at 4:19 pm

    #4048844

    The query: "SELECT 1" fails to export to PDF.  It's not data related. Also there's only 2 of us that would change these reports and the other person was on vacation when it stopped working.

  • June 14, 2022 at 2:47 pm

    #4049335

    Reboot of the server resolved the issue.

  • June 14, 2022 at 2:56 pm

    #4049338

    Glad to hear it!

    First rule of tech support. 🙂

Viewing 6 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic. Login to reply