Grouper Users - Open Discussion List

["Singley, Norman" <>]

Hi. 

 

Our DB admins ran those lines on the Grouper database, and so far so good. I can browse the groups now. I’ll have the owner of the folder try to create a new group to see if he gets an error doing that, but as of now, it looks like we’re back in business. 

 

Thank you for all the help. 

 

 

Norman Singley

Directory Services /  IT

(406) 243-6799

 

 

 

From: [mailto:] On Behalf Of Singley, Norman
Sent: Wednesday, January 13, 2016 3:37 PM
To: Shilen Patel <>
Cc: Trethewey, Gary <>; Chris Hyzer <>;
Subject: RE: [grouper-users] RE: Grouper UI errors

 

That makes sense to me.  Would having two groups with the same name break the UI and cause it to not be able to load the groups when you “browse groups hierarchy” ?

 

 

Norman Singley

Directory Services /  IT

(406) 243-6799

 

 

 

From: Shilen Patel []
Sent: Wednesday, January 13, 2016 2:38 PM
To: Singley, Norman <>
Cc: Trethewey, Gary <>; Chris Hyzer <>;
Subject: Re: [grouper-users] RE: Grouper UI errors

 

So I think you basically somehow added two groups with the same name.  A lot has changed since grouper 1.4, which prevents this sort of thing (I really think that's what you're running).

 

It's been a long time since I've looked at the 1.4 schema, but I think one way to fix the data would be to update the name and extension attributes of any group that has duplicates in there.  For example, for this case:

 

update grouper_attributes set value='UMT:IT:TSS:CASCADE_FORM_DATA:DEPARTMENTS_2' where group_id='989a9fba17fc4cd6aab246be7bd035cc' and field_id='f0661aa0cd34416486e8b8d74463a2aa' and value='UMT:IT:TSS:CASCADE_FORM_DATA:DEPARTMENTS';

 

update grouper_attributes set value='DEPARTMENTS_2' where group_id='989a9fba17fc4cd6aab246be7bd035cc' and field_id='74010bbda3fa4279b67815a2da87893e' and value='DEPARTMENTS';

 

If you have a test database, I'd do it there first and make sure each update statement only updates 1 row. :)

 

Thanks!

 

- Shilen

 

From: <Singley>, Norman <>
Date: Wednesday, January 13, 2016 at 4:16 PM
To: Shilen Patel <>
Cc: "Trethewey, Gary" <>, Chris Hyzer <>, "" <>
Subject: RE: [grouper-users] RE: Grouper UI errors

 

This is what we see:

 

 

Itaux:

 

SQL> select * from grouper.grouper_fields;

 

ID

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

GROUPTYPE_UUID                                                                                                                   IS_NULLABLE NAME                             READ_PRIVILEGE

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

TYPE                             WRITE_PRIVILEGE                  HIBERNATE_VERSION_NUMBER

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

74193b86983a4bd6a391cb7a688bbdf7

e80a3cc8debb44daab50c704d9b1204c                                                                                                           1 description                      read

attribute                        admin                                                   0

 

3bd7f46c0d8940d584e7a7da49facb38

e80a3cc8debb44daab50c704d9b1204c                                                                                                           0 displayExtension                 view

attribute                        admin                                                   0

 

9b8084098d404534b9f5e0eee246a6c3

e80a3cc8debb44daab50c704d9b1204c                                                                                                           0 displayName                      view

attribute                        system                                                  0

 

74010bbda3fa4279b67815a2da87893e

e80a3cc8debb44daab50c704d9b1204c                                                                                                           0 extension                        view

attribute                        admin                                                   0

 

f0661aa0cd34416486e8b8d74463a2aa

e80a3cc8debb44daab50c704d9b1204c                                                                                                           0 name                             view

attribute                        system                                                  0

 

a262c65e9b68490e92fc462904b589ad

e80a3cc8debb44daab50c704d9b1204c                                                                                                           1 members                          read

list                             update                                                  0

 

6b62abd3ef28400296225daededaa602

e80a3cc8debb44daab50c704d9b1204c                                                                                                           1 admins                           admin

access                           admin                                                   0

 

764386ab71994102a6e9c183daa6825c

e80a3cc8debb44daab50c704d9b1204c                                                                                                           1 optouts                          update

access                           update                                                  0

 

2695111e75044b79b8016690f2dbeec0

e80a3cc8debb44daab50c704d9b1204c                                                                                                           1 optins                           update

access                           update                                                  0

 

a9b21ed331a341e69a7cb1bcb7d9defd

e80a3cc8debb44daab50c704d9b1204c                                                                                                           1 readers                          admin

access                           admin                                                   0

 

1a27ad3b5510406e8f0df25fcca89575

e80a3cc8debb44daab50c704d9b1204c                                                                                                           1 updaters                         admin

access                           admin                                                   0

 

c25539be2ad34733ae173b0d4166bc9f

e80a3cc8debb44daab50c704d9b1204c                                                                                                           1 viewers                          admin

access                           admin                                                   0

 

34328834ef3c423c9833a314fa9efc96

a88cf702602e4fc2af9dd7932b914645                                                                                                           1 creators                         stem

naming                           stem                                                    0

 

1b5d3d44801e4961b44aefd2e51708f0

a88cf702602e4fc2af9dd7932b914645                                                                                                           1 stemmers                         stem

naming                           stem                                                    0

 

 

14 rows selected.

 

SQL>

 

SQL> select * from grouper.grouper_groups where id='989a9fba17fc4cd6aab246be7bd035cc' or id='3e041fe0dfbd4e6e9d9aae0b0fca8ede';

 

ID

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

PARENT_STEM

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

CREATOR_ID                                                                                                                       CREATE_TIME

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

MODIFIER_ID                                                                                                                      MODIFY_TIME HIBERNATE_VERSION_NUMBER

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

989a9fba17fc4cd6aab246be7bd035cc

45a9cc75db3d4071aa5f295b19f8cac0

c965cbfdf996465e9418fbfb84bf14a9                                                                                                  1.4521E+12

c965cbfdf996465e9418fbfb84bf14a9                                                                                                  1.4521E+12                        8

 

3e041fe0dfbd4e6e9d9aae0b0fca8ede

45a9cc75db3d4071aa5f295b19f8cac0

c965cbfdf996465e9418fbfb84bf14a9                                                                                                  1.4521E+12

c965cbfdf996465e9418fbfb84bf14a9                                                                                                  1.4521E+12                        8

 

 

SQL>

 

 

 

 

 

 

Norman Singley

Directory Services /  IT

(406) 243-6799

 

 

 

From: Shilen Patel []
Sent: Wednesday, January 13, 2016 2:08 PM
To: Singley, Norman <>
Cc: Trethewey, Gary <>; Chris Hyzer <>;
Subject: Re: [grouper-users] RE: Grouper UI errors

 

Can you also run?

 

select * from grouper_fields;

select * from grouper_groups where id='989a9fba17fc4cd6aab246be7bd035cc' or id='3e041fe0dfbd4e6e9d9aae0b0fca8ede';

 

I think you have some duplicate or bad data in grouper_attributes.

 

Thanks!

 

- Shilen

 

From: <Singley>, Norman <>
Date: Wednesday, January 13, 2016 at 3:43 PM
To: Shilen Patel <>
Cc: "Trethewey, Gary" <>, Chris Hyzer <>, "" <>
Subject: RE: [grouper-users] RE: Grouper UI errors

 

Hi there. 

 

It is possible we’re running an older version.  Maybe 1.6 ? 

 

Here is the result of that query:

 

SQL> select * from grouper.grouper_attributes where value = 'UMT:IT:TSS:CASCADE_FORM_DATA:DEPARTMENTS';

 

ID

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

GROUP_ID

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

FIELD_ID

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

VALUE

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

HIBERNATE_VERSION_NUMBER

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

8080808051d0377e015218296c3f0005

989a9fba17fc4cd6aab246be7bd035cc

f0661aa0cd34416486e8b8d74463a2aa

UMT:IT:TSS:CASCADE_FORM_DATA:DEPARTMENTS

                       0

 

8080808051d0377e015218296c410008

989a9fba17fc4cd6aab246be7bd035cc

9b8084098d404534b9f5e0eee246a6c3

UMT:IT:TSS:CASCADE_FORM_DATA:DEPARTMENTS

                       0

 

8080808051d0377e015218296c1b0001

3e041fe0dfbd4e6e9d9aae0b0fca8ede

f0661aa0cd34416486e8b8d74463a2aa

UMT:IT:TSS:CASCADE_FORM_DATA:DEPARTMENTS

                       0

 

8080808051d0377e015218296c200004

3e041fe0dfbd4e6e9d9aae0b0fca8ede

9b8084098d404534b9f5e0eee246a6c3

UMT:IT:TSS:CASCADE_FORM_DATA:DEPARTMENTS

                       0

 

 

 

 

 

 

Thanks!

 

 

Norman Singley

Directory Services /  IT

(406) 243-6799

 

 

From: [] On Behalf Of Shilen Patel
Sent: Wednesday, January 13, 2016 12:50 PM
To: Singley, Norman <>
Cc: Trethewey, Gary <>; Chris Hyzer <>;
Subject: Re: [grouper-users] RE: Grouper UI errors

 

Hi,

 

Are you sure you're not running a really old version of Grouper – perhaps v1.4.2?

 

The stack trace in the logs seem to suggest that..

 

In any case, what does this give you?

 

select * from grouper_attributes where value='UMT:IT:TSS:CASCADE_FORM_DATA:DEPARTMENTS';

 

Thanks!

 

- Shilen

 

From: <Singley>, Norman <>
Date: Wednesday, January 13, 2016 at 1:21 PM
To: Chris Hyzer <>, "" <>
Cc: "Trethewey, Gary" <>
Subject: [grouper-users] RE: Grouper UI errors

 

Hi Chris –

 

Here is the text from the Catalina.out log file for the last couple days.  The whole file is too large to email, so I just grabbed a few days worth. I restarted Tomcat yesterday, the 12^th around noon.  I hope this helps. Let me know of any other log files that would be of assistance.  This is the main log file my colleague told me about. 

 

Thanks for any help you can give, we really appreciate it.  

 

 

Norman Singley

Directory Services /  IT

(406) 243-6799

 

 

 

From: Chris Hyzer []
Sent: Wednesday, January 13, 2016 12:19 AM
To: Singley, Norman <>;
Subject: RE: Grouper UI errors

 

Can you send the full relevant logs about this issue?

 

Thanks,

Chris

 

From: [] On Behalf Of Singley, Norman
Sent: Tuesday, January 12, 2016 5:45 PM
To:
Subject: [grouper-users] Grouper UI errors

 

Hi all. 

 

I am new to managing grouper, but have taken it over from our previous admin who retired last week. We had an issue crop up before he left that I’m trying to resolve.  I believe we are running v. 2.1.?   Not sure exactly which, but we are definitely not running 2.2.0. 

 

The issue is that for one folder, which has about 30 groups under it, we cannot see the groups when we click on it in the UI.  We can search by the folder’s name, and all 30 groups will show up.  In addition, admins are getting errors trying to manage that folder – for example, if we try to add a new group to that folder, we get the error.  This user got to the folder via “my memberships”  When I log in as admin, and click on the folder, I cannot see any options to manage it or add groups.   Basically, the Browse groups hierarchy page for that folder is blank, even when I “Act as admin.”

 

I apologize if this is a known issue and there is documentation on it  - I’ve been unsuccessful in trying find some.  Thanks for any help.

 

 

 

 

Norman Singley

Directory Services /  IT

(406) 243-6799