Scheduled reports configured to send attachments with in an Email Notification may fail to add the attachments if they are executed simultaneously. When the issue occurs, the email log shows the attachments as processed, but the recipient user does not actually get the attachment in the email.

The Java exception reported in the instance node log is the following:

SEVERE *** ERROR *** Could not create temporary directory
'../tmp/poifiles' (org.apache.poi.xssf.streaming.SXSSFWorkbook.createAndRegisterSXSSFSheet)

Steps to Reproduce

This behaviour is a timing issue, not easy to reproduce, caused by a race condition where two scheduled jobs for a report run close together.

The first scheduled job creates the temp table and generates the report, then the second one runs and sees the temp table already, so it starts using it. As the first one finishes, it drops the temp table and affects the second scheduled job still running. 



This problem is under review and targeted to be fixed in an upcoming release. You can Subscribe to this article to receive notifications when more information will become available.

As a workaround, avoid having scheduled reports running at the same time. Please set them to run in a scheduled sequence, never in parallel.

Related Problem: PRB1307775

Seen In

There is no data to report.

Fixed In

New York

Associated Community Threads

There is no data to report.

Article Information

Last Updated:2019-10-10 14:58:28