Grouper Users - Open Discussion List

[Richard James <>]

Quick update.

I added a group type directly in the grouper_group_types table for this 
particular group. This allowed me to then delete the group through the UI. 
Our LDAP provisioning is now working as a result.

Thanks for your help.

Richie

>-----Original Message-----
>From: 
>
> [
>]
> On Behalf Of Richard James
>Sent: 19 February 2013 15:30
>To: Chris Hyzer 
>()
>Cc: 
>
>Subject: [grouper-users] FW: Unresolvable Group
>
>Also when I tried adding the type using
>GrouperDAOFactory.getFactory().getGroup().addType( group, base); I noticed 
>the
>in table row for the new entry did not have the Context id set, it was null? 
>I
>wonder if this could cause the Stale object exception.
>
>Cheers,
>Richie
>
>-----Original Message-----
>From: Richard James
>Sent: 19 February 2013 15:22
>To: 'Chris Hyzer'
>Subject: RE: Unresolvable Group
>
>I tried exactly what you did on a test group on our dev grouper instance and 
>got
>the same behaviour as you, see messages below.
>
>Another thing I tried was adding an entry directly into the 
>grouper_groups_types
>table.
>
>I produced a UUID using the Select UUID (  ) command, which gave me 66836442-
>7aa7-11e2-b95a-0050563b0032 (I stripped out the -) to leave me with
>668364427aa711e2b95a0050563b0032.
>
>I then added the group UUID, the type UUID and the context id of the group 
>into
>the new row.
>
>This then allows me to delete the group from GSH and the UI, not sure if this
>could potentially causes issues anywhere?
>
>
> #################
>gsh 0% grouperSession = GrouperSession.startRootSession();
>edu.internet2.middleware.grouper.GrouperSession:
>583c58fc4b4e4afe88b8758a20e5ba5c,'GrouperSystem','application'
>gsh 1% group = GroupFinder.findByName(grouperSession,"Applications:test2")
>group: name='Applications:test2' displayName='Applications:test2'
>uuid='6b6c8c402d2d41e2aa42d254846656b3'
>gsh 2% 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: Applications:test2,
>GroupType[creatorUuid=2234fc40d72143a8870bc8c597e0dd47,createTime=132
>1351952067,fields=7,isAssignable=false,isInternal=false,name=base,uuid=d67c38
>ab1eb44ece90d91f6b11e39979]:admins
>gsh 3% base = GroupTypeFinder.find("base");
>type: 'base'
>gsh 4% GrouperDAOFactory.getFactory().getGroup().addType( group, base);
>edu.internet2.middleware.grouper.GroupTypeTuple:
>GroupTypeTuple[groupUuid=6b6c8c402d2d41e2aa42d254846656b3,typeUuid=d6
>7c38ab1eb44ece90d91f6b11e39979]
>
>#######
>restarted GSH
>######
>
>gsh 0% grouperSession = GrouperSession.startRootSession();
>edu.internet2.middleware.grouper.GrouperSession:
>02e347ea8eda47e6bde156a15010421b,'GrouperSystem','application'
>gsh 1%  group = GroupFinder.findByName(grouperSession,"Applications:test2")
>group: name='Applications:test2' displayName='Applications:test2'
>uuid='6b6c8c402d2d41e2aa42d254846656b3'
>gsh 2% 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#6d954ac598d6476dbc684a2bb27204f5]
>
>>-----Original Message-----
>>From: Chris Hyzer 
>>[mailto:]
>>Sent: 19 February 2013 15:01
>>To: Richard James; 
>>
>>Subject: RE: Unresolvable Group
>>
>>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=13
>1
>>8266890386,fields=7,isAssignable=false,isInternal=false,name=base,uuid=a23b0
>3
>>ab173f44d9a98727faa77462ca]: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=a2
>3
>>b03ab173f44d9a98727faa77462ca]
>>#######################################
>>
>>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.GrouperStaleObjectStateExceptio
>n:
>>// 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:Career
>s
>>_
>>>S
>>>>ervice:PSS_SFS_Careers_Service_Intranet")
>>>>group:
>>>>name='Applications:Filestores:PSS:Student_&_Academic_Services:Careers_Se
>r
>>vi
>>>c
>>>>e:PSS_SFS_Careers_Service_Intranet'
>>>>displayName='Applications:Filestores:PSS:Student_&_Academic_Services:Car
>e
>>er
>>>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:Career
>s
>>_
>>>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