Grouper Users - Open Discussion List

["Bryan E. Wooten" <>]

Thanks, this fixed the problem: 

DELETE FROM GROUPER_CHANGE_LOG_ENTRY WHERE STRING04 = 'jdbc'.

I had caused my own problem when I used the UI to delete all the Sample 
University Stuff in the quick install.

-Bryan

-----Original Message-----
From: Chris Hyzer 
[mailto:]
 
Sent: Tuesday, April 02, 2013 9:39 AM
To: David Langenberg; Bryan E. Wooten
Cc: Tom Zeller; 

Subject: RE: [grouper-users] Cant find source with id: 'jdbc'

Shilen and I agree with Dave that updating the source id in the change log 
entry table is a good way to go, assuming those subject ids exist in another 
source.  Another option is update the grouper_change_log_consumer table so 
the last record processed is the last one that has a bad source id.  Deleting 
the records from the change log entry shouldn't be a problem either :)

Thanks,
Chris

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

 
[mailto:]
 On Behalf Of David Langenberg
Sent: Tuesday, April 02, 2013 10:49 AM
To: Bryan E. Wooten
Cc: Tom Zeller; 

Subject: Re: [grouper-users] Cant find source with id: 'jdbc'

grouper_change_log_entry is where you'll find the bad entries.  However, I'm 
not entirely sure how well things will react when gaps start appearing in the 
change log sequence.  You may be better off fixing the change log entries 
than deleting them.

Dave

--
David Langenberg
Identity & Access Management
The University of Chicago




On Apr 2, 2013, at 8:20 AM, Bryan E. Wooten 
<>
 wrote:

> Grep returned no results:
> 
> [root@idm-6
>  conf]# pwd
> /grouper-2.1.3/grouper.apiBinary-2.1.3/conf
> [root@idm-6
>  conf]# grep jdbc psp*.xml
> [root@idm-6
>  conf]#
> 
> I believe you may be correct about an old changlog entry. I have been 
> trying all kinds of configurations.
> 
> Can I go into the DB and clean it out manually? Which table(s) should I 
> clear?
> 
> Thanks,
> 
> Bryan
> 
> -----Original Message-----
> From: 
> 
>  
> [mailto:]
>  On Behalf Of Tom Zeller
> Sent: Monday, April 01, 2013 7:21 PM
> To: 
> 
> Subject: Re: [grouper-users] Cant find source with id: 'jdbc'
> 
> Are you sure that the jdbc subject source is not referenced in your psp 
> config files ... 'grep jdbc psp*.xml' ?
> 
> Otherwise, maybe this is a bug due to an "old" changelog entry referencing 
> a no-longer-configured subject source.
> 
> Just guessing.
> 
> On Mon, Apr 1, 2013 at 1:36 PM, Bryan E. Wooten 
> <>
>  wrote:
>> All I keep getting this exception in my grouper_error.log file:
>> 
>> 
>> 
>> 2013-04-01 12:28:04,417: [DefaultQuartzScheduler_Worker-3] ERROR
>> ChangeLogHelper.processRecords(271) -  - Error: PSP Consumer 'psp' - 
>> An error occurred processing sequence number 11712, sequenceNumber:
>> 11712,
>> edu.internet2.middleware.subject.SourceUnavailableException: Cant 
>> find source with id: 'jdbc', Possible source id's: 'g:gsa', 'ldap', 
>> 'grouperEntities', 'g:isa',
>> 
>>        at
>> edu.internet2.middleware.grouper.subj.SourcesXmlResolver.getSource(So
>> u
>> rcesXmlResolver.java:434)
>> 
>> 
>> 
>> Whenever the loader runs my PSP job with the quartz cron job.
>> 
>> 
>> 
>> As far as I tell I have no PSOs configure to use jdbc. My group 
>> install is clean I have no stems or groups defined. Any ideas?
>> 
>> 
>> 
>> Thanks,
>> 
>> 
>> 
>> Bryan