I posted this question in the Application Development Framework first but got no answers so I will try my luck here.
I've written and installed a repository webscript onto a server running Alfresco Community v5.2.0 (r133656-b12).
When accessed, this webscript displays a table containing activity feed events (file-previewed, file-created, file-added etc.) pertaining to a specific document identified by its nodeRef. It gets the activity events by accessing the alf_activity_feed table directly using:
Connection db = DriverManager.getConnection(dbUrl, dbUsername, dbPassword);
It seemed to work fine but I recently noticed that sometimes the activity (when I preview a document, for example) doesn't register. If I repeat the same activity, with the same user, on the same unaltered document later (from minutes to hours later), at some point, it registers.
I followed the logs and database when it occured and nothing happens...no errors and the activity doesn't show up in either alf_activity_post or alf_activity_feed tables. While this is happening, other activities, users, documents get registered continuously.
Unfortunately, I'm stumped. I haven't found any predictable pattern to it. I was thinking there may be some sort of limit on the number of entries per user/site/time interval but haven't found anything.
I would greatly apreciate any help, idea that can point me in the right direction.