Missing E-Mail Feed Notifications for some users - case sensitivity problem?

[cdw]

Hello all,

we are using Alfresco Community 4.2.e on a Linux machine.
We have a strange effect. I have two accounts on that installation: one that came via LDAP sync (dWinkler) and one created locally in Alfresco (dwtest).
At midnight Alfresco starts generating those mail notifications with the recent changes (feed notifier). But: Only the local user (that did not come via LDAP) gets the email.

I switched on some debugging and saw messages like this:

2013-12-01 00:00:00,663  DEBUG [activities.feed.FeedNotifier] [FeedNotifier2] RETRY TXNS: []
2013-12-01 00:00:00,670  DEBUG [activities.feed.FeedNotifier] [FeedNotifier2] FeedNotifier2 ready to execute
2013-12-01 00:00:00,672  DEBUG [activities.feed.FeedNotifier] [FeedNotifier1] RETRY TXNS: []
2013-12-01 00:00:00,673  DEBUG [activities.feed.FeedNotifier] [FeedNotifier1] FeedNotifier1 ready to execute
…
2013-12-01 00:00:02,775  DEBUG [activities.feed.FeedNotifier] [FeedNotifier2] Get user feed entries: dwtest, 28172
2013-12-01 00:00:02,813  DEBUG [repo.activities.ActivityServiceImpl] [FeedNotifier2] Selected feed entries for user : 'dwtest',
 for site : 'null',
 excluding this user : 'false',
 excluding other users : 'false',
 with min feed id : '28172',
 with max feed items : '100
…
2013-12-01 00:00:04,960  DEBUG [activities.feed.FeedNotifier] [FeedNotifier1] Get user feed entries: dWinkler, 480581
2013-12-01 00:00:04,988  DEBUG [repo.activities.ActivityServiceImpl] [FeedNotifier1] Selected feed entries for user : 'dwinkler',
 for site : 'null',
 excluding this user : 'false',
 excluding other users : 'false',
 with min feed id : '480581',
 with max feed items : '100
…
‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍

So, I do not spot any error messages here. The lines look quite identical. So why does dwtest get an e-mail why dWinkler doesn't?

The only difference I could spot here is:
"dwtest" is always written in small letters while the other is once written with small and once with capital "W" in that log.

We did not touch any case sensitivity flags and we can log in with small and capital letters.
But, could it be the case that there is an internal mismatch so the selected feeds are not sent to the user?

Or, what can I do to get an even deeper insight into the steps here to trace the problem?

Best regards
D. Winkler

[mrogers]

Its unlikely to be anything to do with case sensitivity.   In general email addresses are not case sensitive.

It's probably due to the difference between userid and email address.    4.2 got some cloud code that confused the two.  

I thought 4.2.e was O.K.   Maybe not. 

[ramalama188]

Hi, I had a similar issue and it had to do with case sensitive.

http://injustfiveminutes.com/2014/01/24/recent-activities-emails-not-being-sent-in-alfresco-4-2-c/

Hope it helps.

[cdw]

In the meanwhile I found the reason: There is an attribute for each user that stores the ID of the last sent notification. Somehow (don't ask me why) many (older) users had an entry that was far above the highest current notification, maybe due to some cleanups in the past. So Alfresco thought, that even new notifications were already sent.
So I dropped all records (delete from alf_node_properties where qname_id = 381) and now it works again.