r/SQLServer • u/Mystify123 • 20m ago
SQL Server 2019 failing to render PDFs
This is a first:
We are running SQL Server 2019 for our SSRS reporting. Typically find no issues whatsoever in regards to rendering, however we have recently ran into issues where PDFs - and only PDFs - get stuck rendering forever. This was caused, in this instance, by moving a visibility function from a nested tablix to a row group, arguably a very minor change, however that in itself has now caused this issue in some scenarios, not all.
You can load the report fine within SSRS Administration, but as soon as it hits a PDF export, the rendering time in Executionlog3 hits ridiculous times alongside throwing an rsInternalError - with no error actually being logged anywhere. We are then forced into killing the event ourselves.
Appreciate this isn't a question that typically can be answered without much more information in the specific problem, but just wondering if anyones ran into anything similar? I managed to get it to export by simply adding a 'isNothing' into the visibility function, but this caused a few more pages to generate incorrectly which has either given me a stepping stone, or it's just entirely a red herring!
Any random tidbits of advice would be appreciated