You have a process that emails users the output of a SQL query. The code is in a GEL script within a process. You cannot find any errors in the bg-ca.log file.
For example, a snippet of the GEL code looks like this
<core:new className="java.io.File" var="myFile">
<core:arg value="/fs0/clarity1/share/DeactivateUsers/Users_To_Be_Deactivated.csv"/>
</core:new>
<gel:log> File Size ${myFile.length()} </gel:log>
<gel:log>${mailHost}</gel:log>
<email:email attach="${myFile}" from="[email protected]" server="${mailHost}" subject="Deactivate User Accounts" to="[email protected]"><![CDATA[
Hi,
Please find the list of user accounts those needs to be deactivated. Kindly review and do the needful.
Regards
Clarity Support
NOTE: This is an automatically generated e-mail notification and please do not REPLY.
]]></email:email>
Release : 16.1.0
You may not see an error in the logs, nor in the process instance if the directory is missing.
Check your directory structure in your SFTP location to ensure the directory path is accurate.