Support Article
Unable to send an email to a recipient after scheduling a report
SA-43004
Summary
Unable to send an email to a recipient after scheduling a report.
Error Messages
There was a problem getting a list code: 0 SQLState: 57014 Message:
ERROR: canceling statement due to user request
Steps to Reproduce
- Schedule a report.
- Send an email to the recipient of that report.
Root Cause
The issue occurred because the query packaging was slow and crossed the threshold time and the SQL generated was different for different reports based on:
- Columns to be retrieved
- Format of output
- Number of rows in the report.
Resolution
Perform the following local-change:
- Adjust the threshold in each report definition rule in the 'Data Access' tab.
- Modify or Increase the value of the 'Maximum elapsed time in seconds for export' to increase the threshold limit to export the data.
Published December 9, 2017 - Updated October 8, 2020
Have a question? Get answers now.
Visit the Collaboration Center to ask questions, engage in discussions, share ideas, and help others.