Grouper Users - Open Discussion List

["Biernath, Jutta" <>]

ok, it worked! I’ve taken the „context_id“ of the group in grouper_groups and have made it active in grouper_pit_members again.

 

I could delete it then, and the group disappeared from grouper_groups. However it was still in both grouper_pit_members and grouper_pit_groups as “active”. I’ve updated it both into active=’F’ and end_time = ‘1519738028000’.

 

Thanks again,

 

Jutta

 

 

 

 

 

--------------------

 

Freie Universität Berlin

Zentraleinrichtung Datenverarbeitung

FU Directory and Identity Service

Fabeckstr. 32

14195 Berlin, Germany

 

Telefon +49 30 838-58385

https://www.zedat.fu-berlin.de/FUDIS

 

Von: [mailto:] Im Auftrag von Biernath, Jutta
Gesendet: Dienstag, 27. Februar 2018 09:20
An: 'Hyzer, Chris' <>;
Betreff: AW: [grouper-users] Database problem with group

 

Hi, Chris,

 

The record I’ve found in grouper_pit_members is inactive and has an end date.  I think this must be changed?!

 

There’s also a column “context_id” in grouper_members. I don’t have a clue what to insert in there.

 

Thank you for your help!

 

Jutta

 

--------------------

 

Freie Universität Berlin

Zentraleinrichtung Datenverarbeitung

FU Directory and Identity Service

Fabeckstr. 32

14195 Berlin, Germany

 

Telefon +49 30 838-58385

https://www.zedat.fu-berlin.de/FUDIS

 

Von: Hyzer, Chris []
Gesendet: Montag, 26. Februar 2018 19:35
An: Biernath, Jutta <>;
Betreff: RE: [grouper-users] Database problem with group

 

Yes, try adding a dummy record I guess.  Look at an existing group to see how things line up with other tables.

 

See the group in grouper_groups (in this case assume name is test:testGroup)

 

select id from grouper_groups where name = 'test:testGroup';

 

In my case its: dbfa18c3-a025-47b6-a9a0-be5ac02e8270

 

The id column of the group is the subject_id in grouper_members.  So in my case the grouper_members.subject_id is “dbfa18c3-a025-47b6-a9a0-be5ac02e8270”

 

The id column of grouper_members is the source_id in grouper_pit_members where the subject_id is the thing above (in my case dbfa18c3-a025-47b6-a9a0-be5ac02e8270):

 

select source_id from grouper_pit_members gpm where GPM.subject_id = 'dbfa18c3-a025-47b6-a9a0-be5ac02e8270';

 

Note, when you select the record from grouper_pit_members, does it have an end date, and/or active ‘F’?

 

Subject_source is “g:gsa”

Subject_type is “group”

Hibernate_version_number is 1

For the rest of the cols, look at an existing group and make it similar

 

Thanks

Chris

 

 

 

 

 

-----Original Message-----
From: [] On Behalf Of Jutta Biernath
Sent: Monday, February 26, 2018 12:59 PM
To:
Subject: [grouper-users] Database problem with group

 

Hi, all,

 

I have a big problem with a group with was created and filled via web

services. Everything worked ok, but a few days ago the according dataset in

grouper_members was seemingly deleted.

 

Unfortunately I just can guess that from the (meanwhile overwritten) log files

and from the fact that there are records in grouper_members for the other

groups, but not for this one.

 

Now this group is absolutely unhandle-able, I can neither rename nor move nor

delete it, neither in UI nor in gsh. And even worse: there's no bulkSync

possible, for it crashes each time when the sync touches this group.

 

I have no idea why this record is missing in grouper_members. It must have

been there before, for the provisioning once worked, the group was exported to

ldap as expected, but was not updated fo a few days now.

 

Error in log file when provisioning:

****************************************

ERROR Group.toMember(5289) -  - could not convert group to member: null

ERROR BaseSpmlProvider.execute(139) -  -

Response[status=failure,error=unsupportedOperation,errorMessages={},requestID=

2018/02/26-17:32:04.111]

 

Error in log file when trying to delete:

**********************************************

ERROR ShellHelper.eval(91) -  - Sourced file: inline evaluation of:

``g.delete();'' : Method Invocation g.delete

edu.internet2.middleware.grouper.exception.GrouperException: could not convert

group to member: null,

 

Error in UI when trying to delete:

*****************************************

Error: could not convert group to member: null, Problem in HibernateSession:

HibernateSession (236e7bf1): notNew, notReadonly, READ_WRITE_NEW,

activeTransaction, session (45e96b86), Problem in HibernateSession:

HibernateSession (77a7eb74): new, notReadonly, READ_WRITE_NEW,

notActiveTransaction, session (45e96b86), Problem calling method

groupDeleteSubmit on

edu.internet2.middleware.grouper.grouperUi.serviceLogic.UiV2Group

 

 

Error in UI when trying to rename:

******************************************

Error editing group: could not convert group to member: null, Exception in

update: edu.internet2.middleware.grouper.Group,

, Problem in

HibernateSession: HibernateSession (1e7bfff9): notNew, notReadonly,

READ_WRITE_NEW, activeTransaction, session (2aebcae1), Exception in update:

edu.internet2.middleware.grouper.Group, ByObjectStatic, query: ', cacheable:

null, cacheRegion: null, entityName: null, tx type: null, Problem in

HibernateSession: HibernateSession (1f03989c): notNew, notReadonly,

READ_WRITE_NEW, activeTransaction, session (2aebcae1), Problem in

HibernateSession: HibernateSession (296d75d5): new, notReadonly,

READ_WRITE_NEW, notActiveTransaction, session (2aebcae1), Problem saving

group: xxx, thread: 5df7bb64

 

 

I already thought of simply adding a dummy record in grouper_members, but I

don't know if that causes unresolvable inconsistencies.

 

Please help!

 

 

 

Thank you,

 

Jutta