Unable to send an email to a recipient after scheduling a report
Unable to send an email to a recipient after scheduling a report.
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.
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.
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.
0% found this useful