Grouper Users - Open Discussion List

[Baron Fujimoto <>]

It's possible the error is that old. This is actually a test system so some 
of this type of housekeeping is run very irregularly or on a perceived 
as-needed basis. IIRC, this is also supposed to be handled by the grouper 
loader, which we also, admittedly, don't run regularly. We don't use the 
loader for provisioning, and the current documentation doesn't mention 
changelog maintenance I think.

I'm not sure how the entry was originally introduced, but perhaps it was due 
to a known bug in the UI (at least for our version) where you press return 
instead of tab to choose a person when adding a member.

I'm not sure what to look for for "anything odd", but the following query 
yields no results:
select * from grouper_members where subject_id = 
"069e366f7a4e4803ba9604fea154c7b2";

On Sun, Oct 14, 2018 at 03:10:08AM +0000, Shilen Patel wrote:
>Hi,
>
>I believe that change log is for a member add.  There are a couple of things 
>that seem odd.  First, the created time on that is July 16 2017.  Have you 
>been having this error for over a year?  Second, the error suggests that a 
>member was added without a subject id, which shouldn’t be possible.  The 
>member id (in the grouper_members table) should be the string01 in the 
>error.  Perhaps take a look and see if there’s anything odd there?  
>
>Thanks!
>
>- Shilen
>
>On 10/12/18, 11:22 PM, 
>"
> on behalf of Baron Fujimoto" 
><
> on behalf of 
>>
> wrote:
>
>    I feel like this may have come up before, but my google-fu is coming up 
> short.
>    
>    When I try the following from gsh, I'm encountering the following error 
> for one of our instances:
>    
>    gsh 0% loaderRunOneJob("CHANGE_LOG_changeLogTempToChangeLog");
>    // Error: unable to evaluate command: Sourced file: inline evaluation 
> of: ``loaderRunOneJob("CHANGE_LOG_changeLogTempToChangeLog");'' : Error 
> invoking compiled command: : Error in compiled command: 
> java.lang.RuntimeException: java.lang.RuntimeException: subjectId is empty 
> for change log entry: ChangeLogEntry: changeLogTypeId: 
> '9bb887a5830e427086c951e4b93bda62', contextId: '', createdOnDb: 
> '1500250492727000', hibernateVersionNumber: '-1', string01: 
> '069e366f7a4e4803ba9604fea154c7b2', string02: '', string03: 'LDAP', 
> string04: 'person', string05: '', string06: '', string07: '', string08: '', 
> string09: '', string10: '', string11: '', string12: '',
>    Problem in HibernateSession: HibernateSession (60a7e509): new, 
> notReadonly, READ_WRITE_NEW, notActiveTransaction, session (2b916808)
>    
>    This is Grouper 2.2.2. Any suggestions would be appreciated.

-- 
Baron Fujimoto 
<>
 :: UH Information Technology Services
minutas cantorum, minutas balorum, minutas carboratum desendus pantorum