HKFuey
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?
Kindly check whether the 2 reports that are failing are using a different email profile causing it to fail..
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
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!