Grouper Users - Open Discussion List

[Nathan Weyenberg <>]

I have one entry for the first query: 

da587de67eb44468a8ef08057ab17bd8 53b265a7721f4a549ff9ccd594dc4233 5a951ba3a16943878b3e3513f79b3027 49db455cac9a46c9bc345889b73e1c90 5a951ba3a16943878b3e3513f79b3027 F 1364878800000 1365138000000 immediate edb27c16e2a5484386439da671cee5c7 1366048690528 1 53b265a7721f4a549ff9ccd594dc4233 3431b0bc686543f8bd49b62154c2f93a g:gsa group 0 d3c test admin and update u:netid:daconner:d3c_test_admin_and_update,u:netid:daconner:d3c test admin and update, u:netid:daconner:d3c_test_admin_and_update new description (3/15/13) d7a746a06d814286a2c8c6dc2b74cac5

and none for the second.

I am still working on getting the full stack trace. It looks as if we are getting errors from our web services put into grouper_error but it appears errors with the API might not be writing.

--Nathan

On Nov 12, 2013, at 8:32 AM, Shilen Patel <> wrote:

Hi,

Can you send the full stacktrace from the logs?  What do you see when you run these queries?

1.  select * from grouper_memberships ms, grouper_members m where ms.member_id = m.id and m.subject_id='3431b0bc686543f8bd49b62154c2f93a'

2.  select * from grouper_groups where id='3431b0bc686543f8bd49b62154c2f93a'

Thanks!

-- Shilen

From: Nathan Weyenberg <>
Date: Monday, November 11, 2013 12:25 PM
To: "" <>
Subject: [grouper-users] Error with Obliterate Stem

Hi,

I have been having issues trying to delete a stem and its relating groups. When using obliterate stem I get the following error: 

Obliterating stem: u:netid:daconner

Obliterating stem: u:netid:daconner:_admin

// Error: unable to evaluate command: Sourced file: inline evaluation of: ``obliterateStem("u", false, false);'' : Error invoking compiled command: : Error in compiled command: edu.internet2.middleware.grouper.exception.MemberDeleteException: Cant find group by uuid: 3431b0bc686543f8bd49b62154c2f93a,

Exception in delete: edu.internet2.middleware.grouper.Membership, edu.internet2.middleware.grouper.hibernate.ByObject@6593e3d0,

Problem in HibernateSession: HibernateSession: isNew: false, isReadonly: false, grouperTransactionType: READ_WRITE_NEW,

Exception in delete: edu.internet2.middleware.grouper.Membership, ByObjectStatic, query: ', cacheable: null, cacheRegion: null, entityName: ImmediateMembershipEntry, tx type: null,

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: 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

I have also tried using the following script for deleting stems:

grouperSession = GrouperSession.startRootSession();

stem = StemFinder.findByName(grouperSession, "u:netid:daconner");

for(child : stem.getChildGroups(Stem.Scope.SUB)) { System.out.println("deleting: " + child.getName()); child.delete();  }

stemList = new ArrayList(stem.getChildStems(Stem.Scope.SUB));

Collections.sort(stemList);

Collections.reverse(stemList);

for(childStem : stemList) { System.out.println("deleting: " + childStem.getName()); childStem.delete(); }

stem.delete();

and got the following error:

stem: name='u:netid:daconner' displayName='u:netid:daconner' uuid='f7d2964808774847a3ed9089348d2c02' 

deleting: u:netid:daconner:_admin:_group_mother_update

// Error: unable to evaluate command: Sourced file: inline evaluation of: ``for(child : stem.getChildGroups(Stem.Scope.SUB)) { System.out.println("deleting: . . . '' : Method Invocation child.delete

// See error log for full stacktrace

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

// Cant find group by uuid: 3431b0bc686543f8bd49b62154c2f93a,

Exception in delete: edu.internet2.middleware.grouper.Membership, edu.internet2.middleware.grouper.hibernate.ByObject@7a718e31,

Problem in HibernateSession: HibernateSession: isNew: false, isReadonly: false, grouperTransactionType: READ_WRITE_NEW,

Exception in delete: edu.internet2.middleware.grouper.Membership, ByObjectStatic, query: ', cacheable: null, cacheRegion: null, entityName: ImmediateMembershipEntry, tx type: null,

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: edu.internet2.middleware.grouper.exception.GroupNotFoundException:

// Cant find group by uuid: 3431b0bc686543f8bd49b62154c2f93a,

Exception in delete: edu.internet2.middleware.grouper.Membership, edu.internet2.middleware.grouper.hibernate.ByObject@7a718e31,

Problem in HibernateSession: HibernateSession: isNew: false, isReadonly: false, grouperTransactionType: READ_WRITE_NEW,

Exception in delete: edu.internet2.middleware.grouper.Membership, ByObjectStatic, query: ', cacheable: null, cacheRegion: null, entityName: ImmediateMembershipEntry, tx type: null,

Problem in HibernateSession: HibernateSession: isNew: false, isReadonly: false, grouperTransactionType: READ_WRITE_NEW

java.util.ArrayList: [Stem[displayName=u:netid:daconner:_admin,name=u:netid:daconner:_admin,uuid=3ee2e03cf9f745eeb8ce39707319abed,creator=7d5075a7291f42869c809fc385a70be8,modifier=edb27c16e2a5484386439da671cee5c7], Stem[displayName=u:netid:daconner:foo_test,name=u:netid:daconner:foo,uuid=ff1ce75d126842bfbdb2b89b2da2650f,creator=7d5075a7291f42869c809fc385a70be8,modifier=edb27c16e2a5484386439da671cee5c7], Stem[displayName=u:netid:daconner:foo_attr1,name=u:netid:daconner:foo_attr1,uuid=9ca713b91e8f4cc5bb3ad34315724bcc,creator=7d5075a7291f42869c809fc385a70be8,modifier=edb27c16e2a5484386439da671cee5c7], Stem[displayName=u:netid:daconner:foo_attr2,name=u:netid:daconner:foo_attr2,uuid=49469d8632c443acbc8c17d32a1c6e51,creator=7d5075a7291f42869c809fc385a70be8,modifier=edb27c16e2a5484386439da671cee5c7], Stem[displayName=u:netid:daconner:foo_attr3,name=u:netid:daconner:foo_attr3,uuid=bec3275dc7a44948b5814ba21021d2d5,creator=7d5075a7291f42869c809fc385a70be8,modifier=edb27c16e2a5484386439da671cee5c7], Stem[displayName=u:netid:daconner:foo_attr3:Administrative Group for foo_attr3,name=u:netid:daconner:foo_attr3:_admin,uuid=f5b987368c78471da7c26eeb72245594,creator=7d5075a7291f42869c809fc385a70be8,modifier=edb27c16e2a5484386439da671cee5c7], Stem[displayName=u:netid:daconner:foo_attr4,name=u:netid:daconner:foo_attr4,uuid=dd924eb93e4944cda4734e5952f09850,creator=7d5075a7291f42869c809fc385a70be8,modifier=edb27c16e2a5484386439da671cee5c7], Stem[displayName=u:netid:daconner:foo_attr4:Administrative Group for foo_attr4,name=u:netid:daconner:foo_attr4:_admin,uuid=ccb1f21517674c41bfbd597a0d64c8b4,creator=7d5075a7291f42869c809fc385a70be8,modifier=edb27c16e2a5484386439da671cee5c7], Stem[displayName=u:netid:daconner:foo_attr5,name=u:netid:daconner:foo_attr5,uuid=8563e0d01aec4368b768c0206d761a73,creator=7d5075a7291f42869c809fc385a70be8,modifier=edb27c16e2a5484386439da671cee5c7], Stem[displayName=u:netid:daconner:foo_attr5:Administrative Group for foo_attr5,name=u:netid:daconner:foo_attr5:_admin,uuid=53547d4f42064892be3b0c2cf6593c21,creator=7d5075a7291f42869c809fc385a70be8,modifier=edb27c16e2a5484386439da671cee5c7], Stem[displayName=u:netid:daconner:foo,name=u:netid:daconner:attributes,uuid=db5d035a235d4001b4d7a5de5afa0d88,creator=7d5075a7291f42869c809fc385a70be8,modifier=edb27c16e2a5484386439da671cee5c7], Stem[displayName=u:netid:daconner:foo:Administrative Group for foo,name=u:netid:daconner:attributes:_admin,uuid=292b43146600443c9000e387b0526285,creator=7d5075a7291f42869c809fc385a70be8,modifier=edb27c16e2a5484386439da671cee5c7], Stem[displayName=u:netid:daconner:2222,name=u:netid:daconner:attributes2,uuid=858e82596ed845cb8033d22184df90bf,creator=7d5075a7291f42869c809fc385a70be8,modifier=edb27c16e2a5484386439da671cee5c7], Stem[displayName=u:netid:daconner:2222:Administrative Group for 2222,name=u:netid:daconner:attributes2:_admin,uuid=e598bf4460674041b76708fad4ae7c9f,creator=7d5075a7291f42869c809fc385a70be8,modifier=edb27c16e2a5484386439da671cee5c7]]

deleting: u:netid:daconner:foo_attr5:_admin

// Error: unable to evaluate command: Sourced file: inline evaluation of: ``for(childStem : stemList) { System.out.println("deleting: " + childStem.getName( . . . '' : Method Invocation childStem.delete

// See error log for full stacktrace

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

// cannot delete stem with child groups,

Problem in HibernateSession: HibernateSession: isNew: true, isReadonly: false, grouperTransactionType: READ_WRITE_NEW

// Error: unable to evaluate command: Sourced file: inline evaluation of: ``stem.delete();'' : Method Invocation stem.delete

// See error log for full stacktrace

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

// cannot delete stem with child stems,

Problem in HibernateSession: HibernateSession: isNew: true, isReadonly: false, grouperTransactionType: READ_WRITE_NEW

I have run the following queries with no results:

select * from grouper_memberships_v where member_id = '3431b0bc686543f8bd49b62154c2f93a';

select * from grouper_stems_v where stem_id = '3431b0bc686543f8bd49b62154c2f93a';

select * from grouper_memberships_all_v where member_id = '3431b0bc686543f8bd49b62154c2f93a';

How can I go about deleting this?

Nathan Weyenberg

UW-Madison DoIT - Middleware

Nathan Weyenberg

UW-Madison DoIT - Middleware

Attachment: smime.p7s
Description: S/MIME cryptographic signature