Grouper Users - Open Discussion List

[Chris Hyzer <>]

Yeah, Im trying to reproduce this.

I have a group in grouper 1.6, and then I manually delete that row in the DB 
in grouper_groups_types.

Then I see the same error you see.  Then I recreate that row in 
grouper_groups_types:

#######################################
gsh 0% grouperSession = GrouperSession.startRootSession();
edu.internet2.middleware.grouper.GrouperSession: 
01c2a99386ec454e8b5e00dd2637abd6,'GrouperSystem','application'
gsh 3% group = GroupFinder.findByName(grouperSession, "test:testGroup");
group: name='test:testGroup' displayName='test:testGroup' 
uuid='e7b54e4b2c4c42e288f7b6a667ffaec3' 
gsh 4% group.delete();
// Error: unable to evaluate command: Sourced file: inline evaluation of: 
``group.delete();'' : Method Invocation group.delete
// See error log for full stacktrace
// caused by: edu.internet2.middleware.grouper.exception.GrouperException:
// unexpected condition,
Problem in HibernateSession: HibernateSession: isNew: true, isReadonly: 
false, grouperTransactionType: READ_WRITE_NEW
// caused by: edu.internet2.middleware.grouper.exception.SchemaException:
// invalid group type:  for group name: test:testGroup, 
GroupType[creatorUuid=3f68c77ab34e4563a5140306be23f3d8,createTime=1318266890386,fields=7,isAssignable=false,isInternal=false,name=base,uuid=a23b03ab173f44d9a98727faa77462ca]:admins

gsh 6% base = GroupTypeFinder.find("base");
type: 'base' 
gsh 8% GrouperDAOFactory.getFactory().getGroup().addType( group, base);
edu.internet2.middleware.grouper.GroupTypeTuple: 
GroupTypeTuple[groupUuid=e7b54e4b2c4c42e288f7b6a667ffaec3,typeUuid=a23b03ab173f44d9a98727faa77462ca]
#######################################

Then stop and start GSH to clear things out.  Try to delete the group.  I get 
an error about stale object state for hibernate.  I tried to set this for GSH 
in the grouper.properties, but I still cant delete the group... can you?

###############################
groups.updateLastMembershipTime = false

###############################
gsh 11% group.delete();
// Error: unable to evaluate command: Sourced file: inline evaluation of: 
``group.delete();'' : Method Invocation group.delete
// See error log for full stacktrace
// caused by: 
edu.internet2.middleware.grouper.exception.GrouperStaleObjectStateException:
// Problem in HibernateSession: HibernateSession: isNew: false, isReadonly: 
false, grouperTransactionType: READ_WRITE_NEW,
Problem in HibernateSession: HibernateSession: isNew: false, isReadonly: 
false, grouperTransactionType: READ_WRITE_NEW,
Problem in HibernateSession: HibernateSession: isNew: false, isReadonly: 
false, grouperTransactionType: READ_WRITE_NEW,
Problem in HibernateSession: HibernateSession: isNew: true, isReadonly: 
false, grouperTransactionType: READ_WRITE_NEW
// caused by: org.hibernate.StaleObjectStateException:
// Row was updated or deleted by another transaction (or unsaved-value 
mapping was incorrect): 
[ImmediateMembershipEntry#0503a1f152b64f7d97145e1c45d8ede0]
gsh 12%

##############################

-----Original Message-----
From: Richard James 
[mailto:]
 
Sent: Tuesday, February 19, 2013 9:52 AM
To: Chris Hyzer; 

Subject: RE: Unresolvable Group

Ive just been doing some digging around the database. I'm not sure if for 
every group created, there is an entry made in the grouper_groups_types 
table? If so, for this group there is no entry in this table, could this be 
causing the invalid Group type message? Is there any way we could create an 
entry for this group?

Thanks,
Richie

>-----Original Message-----
>From: 
>
> [
>]
> On Behalf Of Richard James
>Sent: 19 February 2013 14:28
>To: Chris Hyzer; 
>
>Subject: [grouper-users] RE: Unresolvable Group
>
>Hi Chris,
>
>I've attached the latest copy of our grouper_error log which has a useful 
>entry
>when trying to access the group from the UI, it is reporting an invalid 
>Group type.
>(See entry the entry at 14:14:50).
>
>GSH doesn't seem to be logging any really useful stack traces to the log 
>file , it's
>just outputting them within GSH, I will see if I can amend the logging level 
>for this
>to do so. Every time I try and delete the group in GSH it gives the message 
>as in
>my first email about an unexpected condition.
>
>I'll forward on anymore error stacks if I can produce any.
>
>Thanks,
>Richie
>
>
>
>>-----Original Message-----
>>From: Chris Hyzer 
>>[mailto:]
>>Sent: 19 February 2013 13:52
>>To: Richard James; 
>>
>>Subject: RE: Unresolvable Group
>>
>>There should be more info in the logs, can you send all the error stacks 
>>form the
>>UI and GSH?
>>
>>Thanks,
>>chris
>>
>>-----Original Message-----
>>From: 
>>
>> [
>>]
>> On Behalf Of Richard James
>>Sent: Tuesday, February 19, 2013 5:32 AM
>>To: 
>>
>>Subject: [grouper-users] Unresolvable Group
>>
>>Hi All,
>>
>>We are having a problem with one of our groups which was created yesterday.
>>Within the Grouper UI, we can see the group that we created in the explore
>view,
>>named PSS_SFS_Careers_Service_Intranet within its designated stem. However
>>when  you click on the group to view more details for it, the following 
>>message
>is
>>displayed.
>>
>>Error:
>>The error has been logged and the administrator notified.
>>If you continue to encounter errors, please contact technical support.
>>
>>When going to GSH, I can find the group,
>>
>>gsh 25%
>>getGroups("Applications:Filestores:PSS:Student_&_Academic_Services:Careers_
>S
>>ervice:PSS_SFS_Careers_Service_Intranet")
>>group:
>>name='Applications:Filestores:PSS:Student_&_Academic_Services:Careers_Servi
>c
>>e:PSS_SFS_Careers_Service_Intranet'
>>displayName='Applications:Filestores:PSS:Student_&_Academic_Services:Career
>s
>>_Service:PSS_SFS_Careers_Service_Intranet'
>>uuid='1af21f3c9f1a4c50abb48209ead4b624'
>>
>>However if I try to delete the group, the following is displayed;
>>
>>gsh 28%
>>delGroup("Applications:Filestores:PSS:Student_&_Academic_Services:Careers_S
>er
>>vice:PSS_SFS_Careers_Service_Intranet")
>>// Error: unable to evaluate command: Sourced file: inline evaluation of:
>>``delGroup("Applications:Filestores:PSS:Student_&_Academic_Services:Careers_
>S
>>ervic . . . '' : Error invoking compiled command: : Error in compiled 
>>command:
>>edu.internet2.middleware.grouper.exception.GrouperException: unexpected
>>condition,
>>Problem in HibernateSession: HibernateSession: isNew: true, isReadonly: 
>>false,
>>grouperTransactionType: READ_WRITE_NEW
>>
>>It appears that the Group creation transaction may not have been completed
>>correctly and has become into a bit of an orphaned state. I can see the 
>>group in
>>the groupers_group table in the database.
>>
>>Is there any way to resolve this? This is causing issues when we are trying 
>>to
>>provision our groups into the Active directory, as when it gets to this 
>>group, its
>>encountering a null error. I've attached a copy of our grouper_error log.
>>
>>Any help would be really appreciated.
>>
>>Regards,
>>Richie
>>
>>Newcastle University