Grouper Users - Open Discussion List

[Baron Fujimoto <>]

Ahh, thanks. That yields:

'069e366f7a4e4803ba9604fea154c7b2','','UH core 
LDAP','person','0','Firstplaceholder 
LastPlaceholder',NULL,NULL,NULL,NULL,',firstplaceholder 
lastplaceholder,',NULL,NULL,NULL,NULL,'Firstplaceholder 
LastPlaceholder','Firstplaceholder LastPlaceholder',NULL

And the subject_id column is empty for that query.

On Mon, Oct 15, 2018 at 08:42:08PM +0000, Shilen Patel wrote:
>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
>    
>

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