Grouper Users - Open Discussion List

["Bryan E. Wooten" <>]

I crossed subject_id and subject_identifier in the view, and then borked the loader query column name. All the other sql was correct.

 

And yeah version control, I really should know better.

 

Thanks!

 

Bryan

 

From: Chris Hyzer [mailto:]
Sent: Monday, March 24, 2014 2:08 PM
To: Bryan E. Wooten;
Subject: RE: Broke my loader job

 

Mmmm, keep your views in version control?  J

 

Basically to troubleshoot this, you need to be able to resolve the entries in the subject API.  (e.g. in GSH)

 

It looks like you are using group name, which is the subject_identifier, not the subject_id, so maybe you just need to change the column name of the query (and/or the view column name)

 

Thanks,

Chris

 

From: [] On Behalf Of Bryan E. Wooten
Sent: Monday, March 24, 2014 4:04 PM
To:
Subject: [grouper-users] Broke my loader job

 

Well this is embarrassing. I had 3 loader jobs that were working perfectly, but then I went and accidently over wrote one of my views.

 

So the 1^st 2 jobs created course in enrollments and instructors. The 3^rd job created an all group whose members were the 1^st 2 groups. I broke the 3^rd job.

 

My query looks like this:

 

select group_name, subject_id, 'g:gsa' from UUIDM.UU_IDM_COURSES_ALL

 

Now I get this error:

 

2014-03-24 13:12:03,930: [main] ERROR GrouperLoaderResultset$Row.getSubject(1197) -  - Problem with subjectId: students, subjectSourceId: , in jobName: uofu:campus:courses:currTerm:SB:PSYCH:PSY:Quantitative Methds II:5510:001:all

edu.internet2.middleware.subject.SubjectNotFoundException: subject not found: students

 

I’ve tried changing the results of the view so that “students” looks like the fully qualified group name (uofu:campus:courses:currTerm:SB:PSYCH:PSY:Quantitative Methds II:5510:001:students), but I get the same error.

 

I guess I’ve broken how to create loader jobs that have groups as members and regular people. Mondays….

 

Insight appreciated,

 

Bryan