While running the OOTB Export to Excel smart service, the node fails and the following error is seen in the application server log:
INFO [stdout] (Appian Work Item - 535374 - ProcessExec01 : UnattendedJavaActivityRequest) 2018-01-22 06:30:38,869 [Appian Work Item - 535374 - P rocessExec01 : UnattendedJavaActivityRequest] ERROR com.appiancorp.process.engine.UnattendedJavaActivityRequest - An error occurred while executing activity: id=268449513, classname=com.appiancorp.process.runtime.activities.DataExportEntitySmartService5 INFO [stdout] (Appian Work Item - 535374 - ProcessExec01 : UnattendedJavaActivityRequest) com.appiancorp.suiteapi.process.exceptions.SmartServic eException: The export operation has been aborted due to insufficient memory. Consider filtering your data, or reducing the number of columns being fetched if you are trying to export a large data set.
The amount of data in the current batch being exported is larger than the currently configured query memory limit.
This limitation has been reported to the Appian Product Team as AN-100029.
Self-managed customers may increase the query memory limit to allow larger batches of data to be processed. Please take note of the memory and performance considerations mentioned in the query memory limit documentation before increasing this setting by a large amount. As noted in the Appian Cloud FAQ, this change is not possible on cloud environments:
Alternatively, customers should:
This article applies to Appian version 17.4 and later.
Last Reviewed: March 2018
© 2020 Appian. All rights reserved.