Grouper Users - Open Discussion List

[Shilen Patel <>]

That method looks for duplicates and tries to delete the newest one (with the 
assumption that the oldest one is more likely to be used).  But it’s possible 
that the one it tried to delete has foreign keys instead.  (Hopefully they 
both don’t have foreign keys.)  Your logs should confirm that assumption.

If that’s correct, then query the table:

select * From grouper_pit_members where 
source_id='ca99ceee00b44698b407c8ced5a8bddb' and active='T'

You should find 2 (or maybe more) rows.  Delete the one that isn’t 
id=639e1720af7f48c38d1940f63f4d4b7d.

See if that resolves it?  If they both managed to get foreign keys, then it 
gets a bit more complicated.  I think you’d have to go through the references 
and update from one to the other.

Thanks!

- Shilen

On 1/18/19, 12:52 PM, "Scott Koranda" 
<>
 wrote:

    > Try running this via gsh:
    > 
    > 
    > new 
edu.internet2.middleware.grouper.misc.SyncPITTables().processDuplicates(GrouperDAOFactory.getFactory().getPITMember())
    > 
    
    Thanks.
    
    I saw this:
    
    groovy:000> new 
edu.internet2.middleware.grouper.misc.SyncPITTables().processDuplicates(GrouperDAOFactory.getFactory().getPITMember())
    
    
    Hib3PITMemberDAO: Searching for point in time duplicates
    Found 1 entries that have duplicates in point in time.
    Found duplicate PIT record with 
sourceId=ca99ceee00b44698b407c8ced5a8bddb, id=639e1720af7f48c38d1940f63f4d4b7d
    Done making updates but there were 1 errors.  See logs for details.
    ===> 1
    
    How should I proceed?
    
    Thanks,
    
    Scott K