Hi All,
Good day.
since we upgraded Tessiura to V9.0+, we have problems with scheduled reports.
One day this report fails to email out PDF file, another day that report fails to email out PDF file.
1, it is totally random, and the scheduled task failed yesterday, without doing anything, it will still successfully send email today.
2, all scheduled reports still have a copy in the "view reports", this means all scheduled task were executed, but some of them failed to send out PDFs.
3, I re-create most of the scheduled reports, but nothing changed.
4, If I schedule a hourly report, it will send two reports in first 5 minutes.
We are planning to roll back report server v8.0.
Any suggestion?
Thank you for your time.
Ben
Hi Ben
Please submit a Support Ticket for this so we can investigate further.
Regards
Sandra
Hi Sandra,
Thank you very much for your help.
I currently opened the SQL profiler, and changed DATABSE Mail Log Level from 'Extended' to 'Verbose', also I mofied AP_MAIL_REPORT @delte_file char(1) ='Y' to 'N', try to catch something.
only thing I can see is, in the database mail log, there are
"DatabaseMail process is shutting down" and "DatabaseMail process is started".
possibly the PDFs failed to mail out were due to database mail is down.
So I restarted SQL Server Agent.
All today's reports have no problems.
I have to wait......
Thank you for your help.
This problem has been fixed, after a week testing, there are no errors again.
it is about SQL Credentials and database mail authentication.
Somehow, mail server block the reports windows account, but database mail still can manage to send some emails.
I am not fully understand what is going on, after I updated the user name and password, no errors again.