Why Does the Tableau SMTP Test Pass When Report Emails Fail?
The SMTP test is green, but finance still has no sales PDF. The meeting is approaching while everyone assumes the email system is working.
Advanced Tableau Report Scheduler (ATRS) can keep its Tableau Cloud report preparation, sending account and destination results together, making a recurring delivery easier to maintain and investigate.
- THE PROBLEM AND ANSWER Find where finance’s report stopped
- YOUR OPTIONS Make the next test match the missing email
- SET IT UP Check the sending route saved with the ATRS job
- FOR DEVELOPERS Connect the application request to the report’s result
- YOUR NEXT STEP Finish with the report in the reader’s hands
Find where finance’s report stopped
Finance calls about the missing weekly PDF. The administrator has tested SMTP successfully, so another account test seems unlikely to move the conversation forward. What happened to the report finance was waiting for?
Follow that occurrence from its preparation to the mailbox. If the view did not render, there was no finished attachment to send. If the mail service rejected the message, its error points the investigation toward the sending route. If it accepted the message, the receiving system is the next place to look.
Tableau documents a specific false positive: a connection can succeed before a mail server rejects a message for unmet TLS requirements. That is why the actual report email matters more than the connection result alone.
For a recurring Tableau Cloud delivery, ATRS can hold the report output, selected sending account and destinations in one job. Its history helps the reporting owner find which part failed rather than start every missing-PDF conversation from scratch.
The documented Tableau Server false positive
The tsm email reference says test-smtp-connection establishes a connection and reports its status and configuration. Its Postfix example succeeds at that stage but later rejects the email when TLS is required and Tableau Server is not configured to use it.
Tableau’s Server troubleshooting guide also describes an SMTP command error where Background Tasks for Non Extracts can still indicate sending. Keep the detailed error with the incident rather than closing it on that summary.
TSM is a Tableau Server administration tool. For Tableau Cloud, identify whether the subscription uses standard sending or custom SMTP and investigate that route with the site administrator. ATRS connects to Tableau Cloud only; it does not change Tableau Server’s SMTP settings.
Follow the PDF finance expected
The recipient and reporting week keep everyone investigating the same message, even when other account tests have worked.
Make the next test match the missing email
Make the next test resemble finance’s report. The missing message may use a different sender, carry a larger attachment or travel to another domain than the successful test.
The reporting and mail administrators can then investigate the same occurrence together. They have a recipient, subject and time to follow, and a reason for the next change.
A repaired native subscription may meet finance’s need. ATRS becomes useful when someone also maintains a workbook, an archive copy or related report attachments. Those preparations and their delivery can belong to the same recurring job.
TLS, sender and attachment checks
Use Tableau’s SMTP setup guide when the actual error identifies a Tableau Server transport mismatch. It documents STARTTLS support and requires a restart of Tableau Server services when SMTP configuration is changed. Have the administrator match the mail service’s requirements and retest the report after applying the change.
Check any site-specific sender override as well as the system-wide address. Changing a displayed From address does not grant permission to send as that identity.
For Tableau Cloud attachments, the subscription troubleshooting guide documents a 2 MB maximum email size for standard sending and 10 MB with custom SMTP. These are email-size limits, so compare the complete message. Separate sending and receiving services may impose their own limits.
If the message was accepted but is missing from the inbox, use the mail administrator’s trace and receiving-system evidence. Report generation, mail submission and mailbox receipt are separate outcomes.
Make the next test answer finance’s question
Use the relevant sender, attachment and receiving route so the result explains something about the missing report.
Check the sending route saved with the ATRS job
Open finance’s ATRS Email destination and find the sending account selected for that report. Use Options → Messaging for the default route, or the added SMTP account under System → SMTP Servers.
Test that account with the mail administrator’s settings. If the route uses Office 365 modern authentication, use its configured integration and Test Settings instead.
Then run the prepared report to a controlled destination and open History View. Expand the run to see whether the report failed or one of its destinations needs attention.
Once the failed step is corrected, open the actual received PDF with finance. Include the larger weekly pack if that was the source of trouble, and leave the tested configuration with the recurring job. Next week’s delivery should use the route the team has just proved useful.
Review the SMTP account selected by the report destination. The screen’s example values should be replaced with the settings supplied by your mail administrator.
Email preparation, recovery and workbook options
The Email destination guide covers HTML/text messages, subject/body inserts, To/CC/BCC and addresses from address books, database queries or text mailing lists. For embedded reports, enable Include Attachment when a file should accompany the body; embedding alone does not add one.
Use configured sending accounts rather than assuming sender customization is authorized. The Messaging options include re-sending failed emails. Review successful destinations and the existing message state before a manual retry so recovery does not create duplicate deliveries.
The History View guide shows how to expand partial successes and identify failed reports or destinations. Retain that evidence with the mail investigation.
If finance needs Excel, the Excel options include tab names, passwords, file properties and naming. Excel Data Only adds template placement, selected totals, reusable styles and typed column formats. Packages can merge Excel or PDF outputs or send several attachments; ZIP and configured PGP add protection where required. Test the finished message against mail limits and confirm the recipient can open it.
Look inside a partial success
An archive copy may be available even when the email failed. That helps the owner choose the recovery the team actually needs.
Connect the application request to the report’s result
A finance application can keep its report request with the ATRS execution reference. That gives operations a particular delivery to investigate when the attachment is missing.
The mail provider’s trace remains a separate part of the journey. Keeping those references connected helps the reporting and mail teams work on the same PDF.
API example: track the requested report delivery
Use the ATRS execution guide. This example runs an existing ordinary single-report schedule. Replace 101 with its actual UniqueId, use your ATRS HTTPS address and keep the bearer token on a backend that authorizes the report request.
POST /api/Schedule/ExecuteScheduleAsync
Authorization: Bearer <ATRS-access-token>
Content-Type: application/json
{
"ScheduleType": "report",
"UniqueId": 101,
"RunBy": "Finance application"
}
GET /api/Schedule/GetExecutionStatus?ExecutionId=<returned-id>
Authorization: Bearer <ATRS-access-token>Save ExecutionId with the request time and intended reporting job. Monitor within a defined limit and parse the JSON-encoded ResultJson. Completed can contain Result=false; retain any error details and inspect report/destination results before requesting another copy.
If reporting succeeds but finance still has no message, follow the selected sending route with the mail administrator. Store a provider trace reference separately when one is available. Do not assume the ATRS response contains every downstream mail event or proves the report was read.
This payload uses saved outputs and destinations. It does not alter Tableau Server SMTP or supply new recipients. If submission times out, reconcile earlier execution activity and destination evidence before retrying, because work may already have started.
Leave a connected investigation
Keep the application request, execution reference and available mail trace together so a colleague can pick up the same delivery.
Finish with the report in the reader’s hands
Finance should be able to start its review with the sales document, rather than another assurance that the connection test passed.
Use the real report and sending requirement to repair the missing handoff. Where the recurring work also needs prepared files and several destinations, explore how ATRS can maintain that delivery.
Contributors:
Christian Ofori-Boateng
CEO, ChristianSteven Software
