Send Email node error.

Question

An error occurred while evaluating expression: =concatenate("

",rule!ruleName( caseId: pv!case.id, status: pv!case.statusTypeId, assignedTo: pv!case.assignedTo, user: pv!case.assignedTo, buttonAction: pv!buttonAction, comment: pv!publicComment.comment, taskId: pv!escalationTaskId ),"

") (Expression evaluation error in rule 'hrtm_case' (called by rule 'hrtm_ruleName') at function a!queryEntity: An error occurred while retrieving the data.) (Data Inputs). Above is the error while evaluating the rule in send email node. When I execute the rule separately with all inputs, it works fine. From the process model, this is the error. When I tried to rerun the node(without changing anything), it is working perfectly fine. Can some one please help me in finding the route cause of this issue. Thanks, Saicharan

Hema · Answer

Hi Sai, 
 
Does this error occur once in a while or every time? 
 
Could you check the execution time of Query Entity!!? That might be a timeout error. Is this a complex view? If so, if the script used to load the data in the view should be optimized. 
 
Thanks, 
Hema

Ketan Patel · Answer

Hi Saicharan,

Check the security of email node. change it to run as whoever designed the process and try to execute the node.
If not working try following to debug further. Check:
The inputs that you are passing to the rule (PV's) - are those populated correctly? Please monitor the instance and see if all inputs that are passed to rule has value.
Alternatively:
Put this rule in a script node before the email node and populate new set of PV's. Also check the time taken for script node to complete by checking the process history.

Please post the results.

Thanks,

Farnaz · Answer

Hi Sai, 
 
As you mentioned that the Node is executing as expected if the Node is restarted. 
This is not a security issue. 
As Hema mentioned, this looks to be a timeout error. 
 
Please check if the Query entity is able to retrieve data when "Run Test". 
If the same error is displayed, its definitely a Time out error. 
As Hema said, please check the script of the DB view. 
 
Thanks, 
Farnaz