Grouper Users - Open Discussion List

[Shilen Patel <>]

How about:  select * from grouper_members where id = 
'069e366f7a4e4803ba9604fea154c7b2';

Thanks!

- Shilen

On 10/15/18, 4:40 PM, "Baron Fujimoto" 
<>
 wrote:

    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