You marked this as a success and mentioned the duplicate entries were related to a bug in Jive 5. Can you provide some more details on what triggers the bug (when it happens) and what other symptoms someone could see. You have me paraniod, since I use the activity_fact table to compile a lot of our statistics based on views. If you have any more details to share or the JIVE JIRA bug number that would be appreciated.
I do not have a bug number for the same but can confirm that i did not found this happening in jive 7 because of Unique METADATA FIELD
In Jive 5:
1) Go to the doc https://yourdomain/docs/DOC-758315
2) Click on "Edit" link under Action List
3) Expand Collaboration Options
A) Change "People who can edit this document" from the selected option to something else
B) Change "Comment Policy" from the selected option to something else
4) Click on Publish.
5)Run ETL Process and after completion we could see duplicate records in jivedw_activity_fact table having METADATA as "status=PUBLISHED"
Vijay - Thanks for the extra details.