Seemingly random activities not getting posted to alf_activity_post, alf_activity_feed tables

lex91 — Tue, 14 Jan 2020 15:48:38 GMT

Hello,

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.

Alex.

Re: Seemingly random activities not getting posted to alf_activity_post, alf_activity_feed tables

lex91 — Wed, 29 Jan 2020 06:36:33 GMT

Solution in this post.

topic Re: Seemingly random activities not getting posted to alf_activity_post, alf_activity_feed tables in Alfresco Forum

Seemingly random activities not getting posted to alf_activity_post, alf_activity_feed tables

Re: Seemingly random activities not getting posted to alf_activity_post, alf_activity_feed tables