For more information, please refer to this announcement explaining best practices for getting answers to questions.
OTBI bursting via agent for high volume email notifications inconsistent / sporadic
Summary:
Classic use case: Managers are receiving emails regarding outstanding actions. Of the 1132 expected emails, 1014 succeed. 118 emails still successfully send, but contain an error code in email body.
Upon revising the OTBI analysis slightly to a smaller sample of the 118 failures (to replicate the issue on a smaller scale), they succeed.
Any guidance on troubleshooting root cause welcome.
Content (please ensure you mask any confidential information):
About the Agent:
The agent has [Get Recipients from the Analysis Used in the Agent Condition —> Manager User Name] and [Only Return Rows Relevant to the User Running the Agent]. Happy to provide the screenshots, but we are confident the agent is set up correctly because it is working when testing in smaller volumes and working for the majority of cases.