Grouper Users - Open Discussion List

[Shilen Patel <>]

Try running this via gsh:

 

new edu.internet2.middleware.grouper.misc.SyncPITTables().processDuplicates(GrouperDAOFactory.getFactory().getPITMember())

 

 

- Shilen

 

On 1/18/19, 12:38 PM, " on behalf of Scott Koranda" < on behalf of > wrote:

 

    Hi,

   

    I am running the TIER Docker Grouper image version 2.3.0-a109-u47-w12-p20.

   

    I am observing this failure with the change log temp to change log

    functionality:

   

    groovy:000> :load '/opt/grouper/grouper.apiBinary/conf/groovysh.profile'

    groovy:000> grouperSession = GrouperSession.startRootSession();

    ===> ffd678496f354570a905749d0504b4ce,'GrouperSystem','application'

    groovy:000> loaderRunOneJob("CHANGE_LOG_changeLogTempToChangeLog");

    ERROR java.lang.RuntimeException:

    edu.internet2.middleware.grouper.internal.dao.GrouperDAOException: Problem in HibernateSession: HibernateSession (7a8b7e11): notNew, notReadonly, READ_WRITE_NEW, activeTransaction, session (36ecf9f6),

    Exception in uniqueResult: (class edu.internet2.middleware.grouper.pit.PITMember), ByHqlStatic, query: 'select pitMember from PITMember as pitMember where pitMember.sourceId = :id and activeDb = 'T'', cacheable: true, cacheRegion: edu.internet2.middleware.grouper.internal.dao.hib3.Hib3PITMemberDAO.FindBySourceIdActive, tx type: null, tx type: nullBind var[0]: 'Param (class java.lang.String): 'id'->'ca99ceee00b44698b407c8ced5a8bddb', ,

    Problem in HibernateSession: HibernateSession (399c408c): new, notReadonly, READ_WRITE_NEW, notActiveTransaction, session (36ecf9f6)

            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)

   

    I also ran

   

    new edu.internet2.middleware.grouper.misc.SyncPITTables().syncAllPITTables()

   

    hoping that would clear up the issue, but it did not.

   

    I appreciate any input on how to resolve this issue.

   

    Thanks,

   

    Scott K