E-Mail Notification assigned task not working

[macistda]

E-Mail Notification for an assigned task is not working at all under this circumstances:

Steps to reproduce (EspoCRM 7.4.6)

1) User Prefences the following hooks are set:
- Email notifications upon assignment
- Email notifications about mentions in posts
- Email assignment notifications (all set, including tasks)

User Prefences the following hook is not set:
- Email notifications about posts and status updates

2) Create a new task and assign it to an other user than yourself who has set the hooks as described

The "Espo\Tools\EmailNotification\Jobs\NotifyAboutAssi gnment" Job is not created for tasks.

Info: For other entities (opportunties, calls, case) it is created correctly.

If the hook for "Email notifications about posts and status updates" is set true then the Job "Espo\Tools\EmailNotification\Jobs\NotifyAboutAssi gnment" is created for tasks, too.

Workaround could be designing a BPM for sending E-Mail notification for tasks.
Same was described here I think:

https://forum.espocrm.com/forum/general/81348-email-notifications-not-working

[victor]

Could you please send screenshots of the settings from Administration > Notifications (screenshot 1) and from Preferences > User_Name > Notifications (screenshot 2)?

Info: For other entities (opportunties, calls, case) it is created correctly.

So Notifications don't work only for entity Task?

[macistda]

So Notifications don't work only for entity Task? --> Yes. It works for other entities but not for tasks.

[macistda]

FYI:
I designed a Workaround with Formula (before save), a new Boolean Field and an BPM Workflow.

Task:
ifThen(assignedUser.emailAddress!=null && entity\isAttributeChanged('assignedUserId') == true && entity\attribute('assignedUserId') != createdById && entity\attribute('assignedUserId') != modifiedById, mailsenden = true);

BPM:
Send E-Mail if "mailsenden == true", afterwards reset "mailsenden = false". Meanwhile unhide a red colored Panel with text and set write-only for field "assigned user" as field condition to inform the users while BPM is working. (Both defined if "mailsenden == true"). Because of if you change "assigned User" twice meanwhile before the BPM sends the E-Mail (every 2 Minutes), the wrong user could probably get the E-Mail. And the Workflow isn't triggered parallel if the "old" one didn't finish.

Have to wait max 2 Minutes and refresh the Browser (F5). The layout does not refresh itself because BPM doesn't support Websockets as far as I know.

[macistda]

FYI, the "Bug" is present at Espo 7.5.1, too.

[victor]

Please try step by step.

- To disable all the ticks related to notifications, also remove everywhere the entity Task (which is present on your screenshots) and save the changes -> make Rebuild -> enable all the ticks related to notifications, also remove everywhere the entity Task (which is present on your screenshots ) -> make Rebuild again.
- Check the formulas, BPMs and Workflows you use with the entity Task and Email. Try to disable them all and test the work of Email notifications.
- You can try the following:
1. Make a full backup of your current EspoCRM instance and keep it in a safe place: https://docs.espocrm.com/administrat...p-and-restore/.
2. Delete the EspoCRM files from your hosting.
3. Install clean EspoCRM v7.5.1 instance. During installation, select your old database.
4. Delete /custom and /data folders from new instance and copy these folders from backup to the new instance.
5. Run Rebuild from CLI.

[macistda]

I am pretty sure (many years of experience) that there is something missing / a bug, because "Espo\Tools\EmailNotification\Jobs\NotifyAboutAssi gnment" -Job is not created under the written circumstances and it depends on that hook(s), even for the "create" event, and that can't be the planned programming I think.
Your suggested try, especially the 2nd part is a little bit "overpowererd" for me, but thank you anyway. We have a 2nd instance for testing purposes and the behavior is the same.

[yuri]

I would not recommend to delete and re-install Espo. It's too much of a hassle to solve the minor problem. Better to figure out what causing the problem and fix.

[yuri]

Do you have multiple assigned users field created for Task?

[macistda]

yes, the "normal" one (assigned user) and one additional multiple link field.

[yuri]

Note that if in-app notification has been read by a user, and a corresponding email notification is not yet send (there's a configurable delay period), an email notification won't be sent. It's an intentional behavior.

[macistda]

Screen

[yuri]

You can try to debug here https://github.com/espocrm/espocrm/b...cessor.php#L60

Put

if ($entity->getEntityType() === 'Task') {
    $GLOBALS['log']->error('1');
} 

with incremental numbers in different places to know where code exits.

[lazovic]

Hi macistda,

I can say with confidence that this is definitely not a bug in the system. For the Task entity, in vanilla EspoCRM v7.5.1 with notification settings like yours, I checked the functionality of notifying users by email that Task was assigned to them, and everything worked correctly. I am attaching screenshots where you can see the time (you need to look at the minutes), where you can see that the job worked and the email came less than in a minute:





Feeling that it's all about some additional settings (formulas, workflows, BPM, changes in EspoCRM files).

Try installing a clean latest version of EspoCRM, without any modifications, on your server and reproduce the problem.

[macistda]

You can try to debug here https://github.com/espocrm/espocrm/b...cessor.php#L60

Put

if ($entity->getEntityType() === 'Task') {
$GLOBALS['log']->error('1');
} 

with incremental numbers in different places to know where code exits.

This variable is not filled if type == task. ($entity->isAttributeChanged('assignedUserId'))

https://github.com/espocrm/espocrm/blob/7.5.1/application/Espo/Tools/EmailNotification/HookProcessor.php#L80

Our debug code:

$userId = $entity->get('assignedUserId');

$GLOBALS['log']->error("3. Entity: {$entity->getEntityType()}, User: {$userId}, X: {$entity->isAttributeChanged('assignedUserId')}, Y: {$this->isNotSelfAssignment($entity, $userId)}");

if (
!$userId ||
!$entity->isAttributeChanged('assignedUserId') ||
!$this->isNotSelfAssignment($entity, $userId)
) {
return;
}

if ($entity->getEntityType() === 'Task') {
$GLOBALS['log']->error('Task 4');
}
​ 

Logfile:
...
[2023-06-19 11:54:27] ERROR: 3. Entity: Task, User: 60c54685991272cda, X: , Y: 1
...

We tried with a case and X was filled correctly ('1').