Skip to Content.
Sympa Menu

grouper-users - [grouper-users] RE: Troubles with the Grouper Loader

Subject: Grouper Users - Open Discussion List

List archive

[grouper-users] RE: Troubles with the Grouper Loader


Chronological Thread 
  • From: "Hyzer, Chris" <>
  • To: Sean Mason <>, "" <>
  • Subject: [grouper-users] RE: Troubles with the Grouper Loader
  • Date: Thu, 9 Jun 2016 14:08:33 +0000
  • Accept-language: en-US
  • Authentication-results: spf=none (sender IP is ) ;
  • Spamdiagnosticmetadata: NSPM
  • Spamdiagnosticoutput: 1:99

Is there whitespace around the subject_ids in the query or something weird like that?   i.e. try to select the subject_id concatenated with single quotes.

 

Can you get a loader job working like: select ‘abc’ from dual where abc is a subject_id?

 

Do any other loader jobs work there?  If so whats the difference?  Does setting debug logs in the loader package help?

 

Thanks

Chris

 

 

From: [mailto:] On Behalf Of Sean Mason
Sent: Thursday, June 09, 2016 9:33 AM
To:
Subject: [grouper-users] Troubles with the Grouper Loader

 

Hi There,

 

I’ve been experimenting with Grouper for some time with some success.  Recently a small production use case to fill a need that arose suddenly that I’m looking to fill with Grouper, and I’m having a very difficult time.  Time is now tight, and I will have to move to another strategy to make deadlines, but I would like to know where I’ve gone wrong.   I will break the two issues I’m having into two email to hopefully keep any offered help focused.

 

I’m running Grouper 2.3.0, on RHEL 7, Oracle JDK 1.8.0_91.  The repository is Postgres 9.2.14.

 

I have a single SQL_SIMPLE load job. 

Parameters:

grouperLoaderDbName: CSPR

grouperLoaderQuartzCron: 0 0 * * * ?

grouperLoaderQuery:  select uid as SUBJECT_ID from sysadm.firsttimeundergrad_vw

grouperLoaderScheduleType: CRON

grouperLoaderType: SQL_SIMPLE

 

When I run loaderRunOneJob(group) from gsh, I see:

loader ran successfully, inserted 8307 memberships, deleted 8307 memberships, total membership count: 8307, unresolvable subjects: 0

If I run the loaderRunOneJob(group) from gsh once again, I see:

loader ran successfully, inserted 8307 memberships, deleted 8307 memberships, total membership count: 8307, unresolvable subjects: 0

I know the contents of the view have not changed between runs.

 

If I set loader.failsafe.use = true, loader.failsafe.maxPercentRemove = 30, the load fails as it’s trying to remove the entire population before re-adding.

 

Surely this isn’t the expected behavior.  I’m at a loss where else to turn.  Is there another configuration step that is required?  Is something amiss?

 

Please advise,

Sean.




Archive powered by MHonArc 2.6.16.

Top of Page