Grouper Users - Open Discussion List

["Gettes, Michael" <>]

I am trying to make use of the Real-time loader (looks really neat).

I am using the example for mySQL as documented at https://spaces.internet2.edu/display/Grouper/Grouper+loader+real+time+updates

The example SQL is broken where source_id should be subject_source_id.  I am setting subject_source_id but it doesn’t appear it is being respected as the following stack trace shows.  Yes, I understand the rules of uniqueness but this is what I have for now and if RTL could respect subject source this would be so cool.  If I am not doing something stupid, happy to submit as Jira bug.

Thanks!

/mrg

daemon_1    | 2018-07-13T12:15:30.835152680Z grouper-api;grouper_error.log;dev;build-2;2018-07-13 08:15:30,818: [DefaultQuartzScheduler_Worker-8] WARN  GrouperFuture.waitForJob(155) -  - Non fatal problem with callable.  Will try again not in thread
daemon_1    | 2018-07-13T12:15:30.835205366Z java.lang.RuntimeException: edu.internet2.middleware.subject.SubjectNotUniqueException: found multiple matching subjects: 2, '',
daemon_1    | 2018-07-13T12:15:30.835215461Z Problem in job: processOneRow
daemon_1    | 2018-07-13T12:15:30.835222117Z  at edu.internet2.middleware.grouper.app.loader.GrouperLoaderIncrementalJob.processOneRow(GrouperLoaderIncrementalJob.java:720)
daemon_1    | 2018-07-13T12:15:30.835229332Z  at edu.internet2.middleware.grouper.app.loader.GrouperLoaderIncrementalJob.access$000(GrouperLoaderIncrementalJob.java:73)
daemon_1    | 2018-07-13T12:15:30.835235791Z  at edu.internet2.middleware.grouper.app.loader.GrouperLoaderIncrementalJob$1.callLogic(GrouperLoaderIncrementalJob.java:286)
daemon_1    | 2018-07-13T12:15:30.835242340Z  at edu.internet2.middleware.grouper.app.loader.GrouperLoaderIncrementalJob$1.callLogic(GrouperLoaderIncrementalJob.java:281)
daemon_1    | 2018-07-13T12:15:30.835248836Z  at edu.internet2.middleware.grouper.util.GrouperCallable$1.callback(GrouperCallable.java:191)
daemon_1    | 2018-07-13T12:15:30.835255124Z  at edu.internet2.middleware.grouper.GrouperSession.callbackGrouperSession(GrouperSession.java:974)
daemon_1    | 2018-07-13T12:15:30.835261295Z  at edu.internet2.middleware.grouper.util.GrouperCallable.callLogicWithSessionIfExists(GrouperCallable.java:188)
daemon_1    | 2018-07-13T12:15:30.835267627Z  at edu.internet2.middleware.grouper.util.GrouperCallable.call(GrouperCallable.java:154)
daemon_1    | 2018-07-13T12:15:30.835294130Z  at java.util.concurrent.FutureTask.run(FutureTask.java:266)
daemon_1    | 2018-07-13T12:15:30.835301560Z  at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)
daemon_1    | 2018-07-13T12:15:30.835307679Z  at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)
daemon_1    | 2018-07-13T12:15:30.835314161Z  at java.lang.Thread.run(Thread.java:748)
daemon_1    | 2018-07-13T12:15:30.835320307Z Caused by: edu.internet2.middleware.subject.SubjectNotUniqueException: found multiple matching subjects: 2, ''
daemon_1    | 2018-07-13T12:15:30.835326661Z  at edu.internet2.middleware.grouper.subj.SourcesXmlResolver.thereCanOnlyBeOne(SourcesXmlResolver.java:492)
daemon_1    | 2018-07-13T12:15:30.835332933Z  at edu.internet2.middleware.grouper.subj.SourcesXmlResolver.find(SourcesXmlResolver.java:133)
daemon_1    | 2018-07-13T12:15:30.835339153Z  at edu.internet2.middleware.grouper.subj.CachingResolver.find(CachingResolver.java:125)
daemon_1    | 2018-07-13T12:15:30.835346665Z  at edu.internet2.middleware.grouper.subj.ValidatingResolver.find(ValidatingResolver.java:91)
daemon_1    | 2018-07-13T12:15:30.835352997Z  at edu.internet2.middleware.grouper.SubjectFinder.findById(SubjectFinder.java:470)
daemon_1    | 2018-07-13T12:15:30.835359154Z  at edu.internet2.middleware.grouper.app.loader.GrouperLoaderIncrementalJob.processOneRow(GrouperLoaderIncrementalJob.java:471)
daemon_1    | 2018-07-13T12:15:30.835365729Z  ... 11 more