Grouper Users - Open Discussion List

[Shilen Patel <>]

A fix is available for this in API patch 74.

Thanks!

- Shilen

From: <Hyzer>, Chris <>
Date: Thursday, June 15, 2017 at 3:10 PM
To: " Mailing List" <>
Subject: [grouper-users] RE: problems with PIT

An update, Shilen helped me with this, turns out my WS servers did not have synchronized clocks.  Some were 20 seconds off.  Ugh.  Grouper relies on servers have sync’ed clocks.

 

There is a wiki that might help people if they have the same problem:

 

https://spaces.internet2.edu/display/Grouper/Change+log+and+point+in+time+ordering+issue

 

I didn’t discuss this with him about the feasibility of this, but here is a jira that might help:

 

https://bugs.internet2.edu/jira/browse/GRP-1568

 

Thanks

Chris

 

From: Hyzer, Chris
Sent: Thursday, June 15, 2017 10:27 AM
To: Mailing List <>
Subject: problems with PIT

 

Shilen,

 

Im getting this error:

 

'' : Error invoking compiled command: : Error in compiled command: java.lang.RuntimeException: java.lang.RuntimeException: Active PITMember with sourceId=c5c3a39cd7b84aada804b76c4641df5a not found,

 

I run this: select count(1) from grouper_members gm where not exists (select * from grouper_pit_members gpm where gm.id = gpm.source_id);

Get 102

 

I run sync PIT and get this:

 

gsh 0%  loaderRunOneJob("CHANGE_LOG_changeLogTempToChangeLog")

// Error: unable to evaluate command: Sourced file: inline evaluation of: `` loaderRunOneJob("CHANGE_LOG_changeLogTempToChangeLog");'' : Error invoking compiled command: : Error in compiled command: java.lang.RuntimeException: java.lang.RuntimeException: Active PITMember with sourceId=c5c3a39cd7b84aada804b76c4641df5a not found,

Problem in HibernateSession: HibernateSession (70e04b5f): new, notReadonly, READ_WRITE_NEW, notActiveTransaction, session (658a2984)

gsh 1%  new edu.internet2.middleware.grouper.misc.SyncPITTables().syncAllPITTables()

Number of entries in grouper_change_log_entry_temp: 3585

For best results, run loaderRunOneJob("CHANGE_LOG_changeLogTempToChangeLog") first.

 

 

Searching for missing active point in time fields

Found 0 missing active point in time fields

 

 

Searching for missing active point in time members

Found 0 missing active point in time members

 

 

Searching for missing active point in time stems

Found 0 missing active point in time stems

 

 

Searching for missing active point in time groups

Found 0 missing active point in time groups

 

 

Searching for missing active point in time role sets

Found 0 missing active point in time role sets

 

 

Searching for missing active point in time attribute defs

Found 0 missing active point in time attribute defs

 

 

Searching for missing active point in time attribute def names

Found 0 missing active point in time attribute def names

 

 

Searching for missing active point in time attribute def name sets

Found 0 missing active point in time attribute def name sets

 

 

Searching for missing active point in time actions

Found 0 missing active point in time actions

 

 

Searching for missing active point in time action sets

Found 0 missing active point in time action sets

 

 

Searching for missing active point in time group sets

Found 0 missing active point in time group sets

 

 

Searching for missing active point in time memberships

Found 0 missing active point in time memberships

 

 

Searching for missing active point in time group sets (second pass)

Found 0 missing active point in time group sets

 

 

Searching for missing active point in time attribute assigns

Found 0 missing active point in time attribute assigns

 

 

Searching for missing active point in time attribute assign values

Found 0 missing active point in time attribute assign values

 

 

Searching for point in time attribute assign values that should be inactive

Found 0 active point in time attribute assign values that should be inactive

 

 

Searching for point in time attribute assigns that should be inactive

Found 401 active point in time attribute assigns that should be inactive

// Error: unable to evaluate command: Sourced file: inline evaluation of: `` new edu.internet2.middleware.grouper.misc.SyncPITTables().syncAllPITTables();'' : Method Invocation syncAllPITTables

// See error log for full stacktrace

// caused by: edu.internet2.middleware.grouper.exception.GrouperStaleObjectStateException:

// Problem in HibernateSession: HibernateSession (90497ef): new, notReadonly, READ_WRITE_NEW, notActiveTransaction, session (3a3e5f05)

// caused by: org.hibernate.StaleObjectStateException:

// Row was updated or deleted by another transaction (or unsaved-value mapping was incorrect) : [edu.internet2.middleware.grouper.pit.PITAttributeAssign#7b0eb22ac8e546dbaf1187189d5c4f43],

Exception in save: edu.internet2.middleware.grouper.pit.PITAttributeAssign, : [edu.internet2.middleware.grouper.pit.PITAttributeAssign#7b0eb22ac8e546dbaf1187189d5c4f43]

gsh 2%