Grouper Users - Open Discussion List

[Shilen Patel <>]

I wonder if you have more duplicates.  If you look at the member that had issues (ca99ceee00b44698b407c8ced5a8bddb) does that give you any insight into what may have gone wrong?  Is that member a user or a group?  Try running the check on all the tables:

 

groovy:000> new edu.internet2.middleware.grouper.misc.SyncPITTables().processAllDuplicates()

 

If that doesn’t help, try running the job again and have it print the full stacktrace:

 

try { loaderRunOneJob("CHANGE_LOG_changeLogTempToChangeLog"); } catch (Exception e) { e.printStackTrace(); }

 

 

- Shilen

 

On 1/18/19, 2:30 PM, "Scott Koranda" <> wrote:

 

    > 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