Skip to Content.
Sympa Menu

grouper-users - Re: [grouper-users] Old PIT data?

Subject: Grouper Users - Open Discussion List

List archive

Re: [grouper-users] Old PIT data?

Chronological Thread 
  • From: Alex Poulos <>
  • To: "Hyzer, Chris" <>
  • Cc: "" <>, " Mailing List" <>, Jeffrey Williams <>
  • Subject: Re: [grouper-users] Old PIT data?
  • Date: Thu, 23 Apr 2020 08:21:40 -0400

We had lots of problems with PIT because of some records that got corrupted. I spent several weeks digging through the DB manually to figure out what the problem was (I eventually had to recreate a handful of groups and then run the PIT utils).

I'd recommend running the new edu.internet2.middleware.grouper.misc.SyncPITTables().syncAllPITTables() as detailed here from the grjouper shell:

(you'll want to turn off the daemon first).

On Thu, Apr 23, 2020 at 5:31 AM Hyzer, Chris <> wrote:

What version / patch level are you on?  Might want to get to latest 2.4 or 2.5 if not on it.  If you want to skip this record adjust the grouper_change_log_consumer record for the process.  Unless Jeff Williams has a better idea 😊




From: On Behalf Of Andre Daniels
Sent: Thursday, August 08, 2019 2:10 PM
To: Grouper-Users <>
Subject: [grouper-users] Old PIT data?





We are getting errors for a group that was deleted. 



2019-08-08 11:00:00,107: [DefaultQuartzScheduler_Worker-4] ERROR Provisioner.evaluateJexlExpression(665) - Jexl _expression_ SingleGroupSearchFilter '(&(objectclass=group)(|(gidNumber=${group.idIndex})(cn=${group.displayExtension})))' could not be evaluated for subject 'null/null' and group 'ucsc:svc:its:win:AU:AU Groups:andre-test(PIT)/null' which used variableMap '{extension=andre-test, , displayName=ucsc:svc:its:win:AU:AU Groups:andre-test, provisionerName=pspng_au2, groupSearchBaseDn=OU=grouper,OU=AU Groups,DC=au,DC=ucsc,DC=edu, groupAttributes={}, displayExtension=andre-test, userSearchBaseDn=OU=people,DC=au,DC=ucsc,DC=edu, provisionerType=LdapGroupProvisioner, groupCreationBaseDn=OU=grouper,OU=AU Groups,DC=au,DC=ucsc,DC=edu, , stemAttributes={}, name=ucsc:svc:its:win:AU:AU Groups:andre-test}'
edu.internet2.middleware.grouper.exception.ExpressionLanguageMissingVariableException: variable 'group.idIndex' is not defined in script: 'group.idIndex'


There is this row in GROUPER_PIT_GROUPS:


8f80517785cb4ff28b085877b2551b9c 322fbcd4f2354e31a916a7dafe5b6979 ucsc:svc:its:win:AU:AU Groups:andre-test f3619bc97b3247f8aeb21d57c4fe9cd6 F 1565133610847000 1565286294029000 64b4ac93c19c4591acc9d3117d4fa457 1


Do we need to manually delete this, maybe?





Andre Daniels 

Sr. Developer/Security Analyst

University of California Santa Cruz

(831) 459-1980

Archive powered by MHonArc 2.6.19.

Top of Page