3 Replies Latest reply on Aug 7, 2014 10:33 AM by mnevill

    Why would there be multiple duplicate entry in JIVEDW_ACTIVITY_FACT table.

    vijayora

      Hi All,

       

      When i execute following in my DB i see multiple duplicate records in JIVEDW_ACTIVITY_FACT . why would this happen ?

       

      select count(*), ACTIVITY_TS, DAY_ID, USER_ID, ACTIVITY_TYPE, DIRECT_OBJECT_TYPE, DIRECT_DW_OBJECT_ID, INDIRECT_OBJECT_TYPE, INDIRECT_DW_OBJECT_ID, DW_CONTAINER_ID, METADATA 

      from jivedw_activity_fact

      group by ACTIVITY_TS, DAY_ID, USER_ID, ACTIVITY_TYPE, DIRECT_OBJECT_TYPE, DIRECT_DW_OBJECT_ID, INDIRECT_OBJECT_TYPE, INDIRECT_DW_OBJECT_ID, DW_CONTAINER_ID, METADATA  

      having count (*) > 1

       

      These duplicates are for activity_type 10,140,190,160,170,40,140,190  and for DIRECT_OBJECT_TYPE 1,3,14,102,109. How do we uniquely identify these entries ? 

       

      For Example:I see dups for 102 OBJECT_TYPE

       

        2 30-JAN-14 04.37.06.004000000 PM 973 557595 40 102 13896901 Null Null 895 status=PUBLISHED
      3 30-JAN-14 06.45.07.310000000 PM 973 557595 40 102 13893518 Null Null 895 status=PUBLISHED - Three Modifications by same user at the same time on one document ???
      3 30-JAN-14 06.44.22.511000000 PM 973 557595 40 102 13896657 Null Null 895 status=PUBLISHED
      2 30-JAN-14 06.41.42.781000000 PM 973 557595 40 102 13896805 Null Null 895 status=PUBLISHED
      3 30-JAN-14 09.23.24.981000000 PM 973 762629 40 102 13896901 Null Null 895 status=PUBLISHED
      2 30-JAN-14 06.43.06.963000000 PM 973 557595 40 102 13896847 Null Null 895 status=PUBLISHED

       

      Please advise.

       

      Regards,

      Vijay