Grouper Users - Open Discussion List

[Scott Koranda <>]

> 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? 

I was able to delete the row.

The error message is now different:

groovy:000> loaderRunOneJob("CHANGE_LOG_changeLogTempToChangeLog");
ERROR java.lang.RuntimeException:
edu.internet2.middleware.grouper.internal.dao.GrouperDAOException: Problem in 
HibernateSession: HibernateSession (259647f2): notNew, notReadonly, 
READ_WRITE_NEW, activeTransaction, session (6ed2aa8a),
Exception in saveOrUpdate: edu.internet2.middleware.grouper.pit.PITGroupSet, 
ByObjectStatic, query: ', cacheable: null, cacheRegion: null, entityName: 
null, tx type: null,
Exception in save: edu.internet2.middleware.grouper.pit.PITGroupSet, 
edu.internet2.middleware.grouper.hibernate.ByObject@53ec379a,
Problem in HibernateSession: HibernateSession (7a7fdc1a): notNew, 
notReadonly, READ_WRITE_NEW, activeTransaction, session (6ed2aa8a),
Exception in saveOrUpdate: edu.internet2.middleware.grouper.pit.PITGroupSet, 
ByObjectStatic, query: ', cacheable: null, cacheRegion: null, entityName: 
null, tx type: null,
Exception in save: edu.internet2.middleware.grouper.pit.PITMembership, 
edu.internet2.middleware.grouper.hibernate.ByObject@5f6dd89c,
Problem in HibernateSession: HibernateSession (609f136b): notNew, 
notReadonly, READ_WRITE_NEW, activeTransaction, session (6ed2aa8a),
Exception in saveOrUpdate: 
edu.internet2.middleware.grouper.pit.PITMembership, ByObjectStatic, query: ', 
cacheable: null, cacheRegion: null, entityName: null, tx type: null,
Problem in HibernateSession: HibernateSession (7a7698f4): new, notReadonly, 
READ_WRITE_NEW, notActiveTransaction, session (6ed2aa8a)
        at 
edu.internet2.middleware.grouper.app.loader.GrouperLoader.runOnceByJobName 
(GrouperLoader.java:1625)
        at edu.internet2.middleware.grouper.app.gsh.loaderRunOneJob.invoke 
(loaderRunOneJob.java:95)
        at 
edu.internet2.middleware.grouper.app.gsh.loaderRunOneJob$invoke.call (Unknown 
Source)
        at groovysh_evaluate.loaderRunOneJob (groovysh_evaluate:4)

Thanks,

Scott K