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.

Intended Fix Version

New York

Safe Harbor Statement

This "Intended Fix Version" information is meant to outline ServiceNow's general product direction and should not be relied upon in making a purchasing decision. The information provided here is for information purposes only and may not be incorporated into any contract. It is not a commitment, promise, or legal obligation to deliver any material, code, or functionality. The development, release, and timing of any features or functionality described for our products remains at ServiceNow's sole discretion.

Associated Community Threads

There is no data to report.

Article Information

Last Updated:2019-05-21 11:44:32