Grouper Users - Open Discussion List

[Andre Daniels <>]

Shilen,

I can try that after I restore the dev database and try the upgrade steps that I have planned.

Thanks for the documentation link!

Andre

On Thu, Sep 23, 2021 at 2:06 PM Shilen Patel <> wrote:

Does running this correct the PIT tables (using gsh)?

 

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

 

https://spaces.at.internet2.edu/display/Grouper/Point+in+Time+Auditing

 

- Shilen

 

From: <> on behalf of Andre Daniels <>
Reply-To: "" <>
Date: Thursday, September 23, 2021 at 3:39 PM
To: Grouper-Users <>
Subject: [grouper-users] Error running CHANGE_LOG_changeLogTempToChangeLog

 

Hello,

 

We have run into an issue while trying to upgrade to Grouper 2.5. Does anyone know how we should go about fixing this?

 

select * from grouper_pit_attribute_assign where source_id like 'd291f448d463445f90a2dd1630518f78'; returns now rows

 

Are there some docs somewhere where I can read about how the PIT tables are used?

 

Thanks,

Andre

 

Here is section of the stack trace

 

2021-09-23 18:16:03,505: [DefaultQuartzScheduler_Worker-6] ERROR GrouperLoaderJob.runJob(500) -  - Error on job: CHANGE_LOG_changeLogTempToChangeLog
java.lang.RuntimeException: PITAttributeAssign with sourceId=d291f448d463445f90a2dd1630518f78 not found,
Problem in HibernateSession: HibernateSession (679253ae): new, notReadonly, READ_WRITE_NEW, notActiveTransaction, session (3ab2d079)
        at edu.internet2.middleware.grouper.internal.dao.hib3.Hib3PITAttributeAssignDAO.findBySourceIdMostRecent(Hib3PITAttributeAssignDAO.java:145)
        at edu.internet2.middleware.grouper.changeLog.ChangeLogTempToEntity.processAttributeAssignAdd(ChangeLogTempToEntity.java:1356)
        at edu.internet2.middleware.grouper.changeLog.ChangeLogTempToEntity.access$2100(ChangeLogTempToEntity.java:71)
        at edu.internet2.middleware.grouper.changeLog.ChangeLogTempToEntity$1.callback(ChangeLogTempToEntity.java:208)
        at edu.internet2.middleware.grouper.hibernate.HibernateSession.callbackHibernateSession(HibernateSession.java:703)
        at edu.internet2.middleware.grouper.changeLog.ChangeLogTempToEntity.convertRecordsOnePage(ChangeLogTempToEntity.java:122)
        at edu.internet2.middleware.grouper.changeLog.ChangeLogTempToEntity.convertRecords(ChangeLogTempToEntity.java:95)
        at edu.internet2.middleware.grouper.app.loader.GrouperLoaderType$6.runJob(GrouperLoaderType.java:638)
        at edu.internet2.middleware.grouper.app.loader.GrouperLoaderJob.runJob(GrouperLoaderJob.java:480)
        at edu.internet2.middleware.grouper.app.loader.GrouperLoaderJob.execute(GrouperLoaderJob.java:344)
        at org.quartz.core.JobRunShell.run(JobRunShell.java:202)
        at org.quartz.simpl.SimpleThreadPool$WorkerThread.run(SimpleThreadPool.java:573)
2021-09-23 18:16:03,559: [DefaultQuartzScheduler_Worker-6] ERROR GrouperLoaderJob.execute(347) -  - Error running up job
java.lang.RuntimeException: PITAttributeAssign with sourceId=d291f448d463445f90a2dd1630518f78 not found,
Problem in HibernateSession: HibernateSession (679253ae): new, notReadonly, READ_WRITE_NEW, notActiveTransaction, session (3ab2d079),

 

--

Andre Daniels 

Sr. Developer/Security Analyst

University of California Santa Cruz

(831) 459-1980

--

Andre Daniels 

Sr. Developer/Security Analyst

University of California Santa Cruz

(831) 459-1980