About
Pricing
Community
Teams
Start Free Trial
Log in
HKFuey
asked on
3/15/2019
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?
Microsoft SQL Server
Microsoft Server OS
SSRS
SQL
5
2
Last Comment
HKFuey
8/22/2022 - Mon
Raja Jegan R
3/15/2019
Kindly check whether the 2 reports that are failing are using a different email profile causing it to fail..
SOLUTION
lcohan
3/15/2019
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.
See Pricing Options
Start Free Trial
GET A PERSONALIZED SOLUTION
Ask your own question & get feedback from real experts
Find out why thousands trust the EE community with their toughest problems.
ASKER CERTIFIED SOLUTION
John_Vidmar
3/15/2019
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.
See Pricing Options
Start Free Trial
⚡ FREE TRIAL OFFER
Try out a week of full access for free.
Find out why thousands trust the EE community with their toughest problems.
HKFuey
3/18/2019
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?
HKFuey
3/18/2019
ASKER
Thanks John, just changing to CSV sorted it!
Experts Exchange is like having an extremely knowledgeable team sitting and waiting for your call. Couldn't do my job half as well as I do without it!
James Murphy