Grouper Users - Open Discussion List

["Hyzer, Chris" <>]

Can you please send the full stack from the logs?  And if any adjacent log 
lines are relevant, those too

Thanks
Chris

-----Original Message-----
From: 

 
<>
 On Behalf Of Scott Koranda
Sent: Friday, November 02, 2018 10:47 AM
To: grouper-users 
<>
Subject: [grouper-users] failing member.changeSubject()

Hi,

I have a call to member.changeSubject(newSubject), made through GSH,
that is failing with

ERROR edu.internet2.middleware.grouper.internal.dao.GrouperDAOException:
Problem in HibernateSession: HibernateSession (5caa30c1): notNew,
notReadonly, READ_WRITE_NEW, activeTransaction, session (41d4e24f),
Exception in uniqueResult: (class
edu.internet2.middleware.grouper.Member), ByHqlStatic, query: 'from
Member as m where m.uuid = :uuid', cacheable: false, cacheRegion: null,
tx type: null, tx type: nullBind var[0]: 'Param (class
java.lang.String): 'uuid'->'7a81e2f600974df691a6d020bdde9b02', ,
Exception in delete: edu.internet2.middleware.grouper.Membership,
edu.internet2.middleware.grouper.hibernate.ByObject@2ecc847e,
Problem in HibernateSession: HibernateSession (3ee6b17): notNew,
notReadonly, READ_WRITE_NEW, activeTransaction, session (41d4e24f),
Exception in delete: edu.internet2.middleware.grouper.Membership,
ByObjectStatic, query: ', cacheable: null, cacheRegion: null,
entityName: ImmediateMembershipEntry, tx type: null,
, this subject: null, new subject: Subject id: federated-user-451,
sourceId: comanage_registry_ldap, deleteOldMember: false, report? false,
Problem in HibernateSession: HibernateSession (52e6a54a): new,
notReadonly, READ_WRITE_NEW, notActiveTransaction, session (41d4e24f)

I also tried

member.changeSubject(newSubject,!MEMBER_DELETE_OLD_MEMBER)

as suggested on this wiki page:

https://spaces.at.internet2.edu/pages/viewpage.action?pageId=14517859

but it also fails.

If I instead run

member.changeSubjectReport(newSubject,Member.DELETE_OLD_MEMBER);

I can see a report of the intended changes. There are many (over 1500).
They are in categories

CHANGE group
CHANGE membership
CHANGE stem
CHANGE groupSet

Do I need to somehow convert those report lines into individual SQL
calls and try to execute them?

If so, what algorithm would I use to create the SQL? Is there a simple
way to translate from the output of changeSubjectReport() to SQL?

Thanks,

Scott K