asked on SQL SSRS Failure sending mail: An error occurred during rendering of the report.Mail will not be resent
SQL SSRS subscription fails with "Failure sending mail: An error occurred during rendering of the report.Mail will not be resent."
SQL Standard edition Version 11.3.6020.0
I have 40 SSRS reports that are working and just 2 that give this error, can anyone help?
SQL Standard edition Version 11.3.6020.0
I have 40 SSRS reports that are working and just 2 that give this error, can anyone help?
Microsoft SQL ServerMicrosoft Server OSSSRSSQL
Last Comment
HKFuey
Kindly check whether the 2 reports that are failing are using a different email profile causing it to fail..
SOLUTION
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
ASKER CERTIFIED SOLUTION
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
ASKER
Hi Icohan
This is quite a large report (27,000 lines). If I change the view to just one invoice (3 lines) the subscription works.
So it is something to do with the data?
This is quite a large report (27,000 lines). If I change the view to just one invoice (3 lines) the subscription works.
So it is something to do with the data?
ASKER
Thanks John, just changing to CSV sorted it!