Skip to Content.
Sympa Menu

grouper-users - [grouper-users] RE: grouper-loader fail safe / threshold for failed connections

Subject: Grouper Users - Open Discussion List

List archive

[grouper-users] RE: grouper-loader fail safe / threshold for failed connections

Chronological Thread 
  • From: "Hyzer, Chris" <>
  • To: Emilio Recio <>, Grouper Users Mailing List <>
  • Subject: [grouper-users] RE: grouper-loader fail safe / threshold for failed connections
  • Date: Mon, 18 Sep 2017 18:08:34 +0000
  • Accept-language: en-US
  • Authentication-results: spf=none (sender IP is ) ;
  • Ironport-phdr: 9a23:5Iwo3hZwFNMTfKRClC/sSAj/LSx+4OfEezUN459isYplN5qZrsqzbnLW6fgltlLVR4KTs6sC0LuG9fi4EUU7or+5+EgYd5JNUxJXwe43pCcHRPC/NEvgMfTxZDY7FskRHHVs/nW8LFQHUJ2mPw6arXK99yMdFQviPgRpOOv1BpTSj8Oq3Oyu5pHfeQtFiT6+bL9oMBm6sRjau9ULj4dlNqs/0AbCrGFSe+RRy2NoJFaTkAj568yt4pNt8Dletuw4+cJYXqr0Y6o3TbpDDDQ7KG81/9HktQPCTQSU+HQRVHgdnwdSDAjE6BH6WYrxsjf/u+Fg1iSWIdH6QLYpUjm58axlVAHnhzsGNz4h8WHYlMpwjL5AoBm8oxBz2pPYbJ2JOPZ7eK7WYNEUSndbXstJVyJPHJ6yb5cBAeQCM+ZXrYj9qEcBoxSxHgSsGPjgxiNUinPqwaE30eIsGhzG0gw6GNIOtWzZoNv3OqYSUOG60rPIwS3eZP5I2Tf98onIcgsvrfqRWr9wdNbeyUkvFgLEkFqQs5foPzKO1usRqWSb8vJgWvypi24hsQ1+vCWgxto1h4TPm4kbyUjE+D1nzIkvOdG0VUt2bcO5HJdNsiyaOYR7Tt8+T2xtuis11LILtJ++cSUP1pgr2wDTZ+Saf4WG/h7vTuKcLSpiiH57Zb6ygwy+/VWix+D9UMS/zUxEoTBfktbWs3AAzxzT5daDSvt65kqvwSqC2QfP5u1aOEw5iKzVJ4A4zr43jZUcr17PHijrmEXql6CWcVgk+u615Oj9erXmvJicN5NqhQ7iLqQum8u/AeIiPggJQmib5eC81Lrk/U36WrlFkvo2kqzBvJDbI8QUuLK5DhdL3ok59xqzEjKr3MkFkXUaKV9Fdh2Kg5T1N1zLIv33E/iyjlWpnTpu2fzKIqPtDo3ILnfZkbfhebh961RbyAo21d1f4o5bCrEBIfPyREDxrsfVDh4iMwOo2ernFc192Z0YWWKJGKOWLr7dsUKQ6uI1P+aMfJMVuCr6K/U96P7ul3g5mUIFfaa3x5sbcW24Hu94LEWDenrhmdMBEWYRvgoiV+zmlkeOUT9VZ3auQa08/Dc7B5y6DYvdXIyinqGO3DroVqFRM01DC1SNFj/Seo6FXL9YRSeTJs5m1AYJXrmmY40s2x+jrhT9zfxqIveCvmU3r5X+zNVvr9DImAspvRl9DsCc1W7Fa2BvgitcSCUxwbhyuwlg0VqZyoB5heBVD9pe+6kPXwsnY83y1et/XprSSxDMZJPBY1a8Q87sSWU0RdIg0dIUS0dmEJO/lh3F2WynD6JDxO/DP4A97q+Jhyu5HM160XuTkfB511Q=
  • Spamdiagnosticmetadata: NSPM
  • Spamdiagnosticoutput: 1:99

Ive seen errors from db links being thrown to java. Not sure if that is
happening in your case. Might want to connect directly?

-----Original Message-----
From: Emilio Recio

Sent: Monday, September 18, 2017 1:49 PM
To: Hyzer, Chris
Grouper Users Mailing List
Subject: Re: grouper-loader fail safe / threshold for failed connections

Well, I am not sure. The query goes against a DB Link on the database.
It's using the same database that grouper uses internally. So I guess it
was connecting OK. However, there's a db link from grouper's db to the
remote db (SOR) from which loader is pulling in data. If the db link
goes down, does this count as zero rows from the SOR and hence it
deletes the members from the group?

On 09/13/17 09:14, Hyzer, Chris wrote:
> If there is an error running the query, the loader will not remove all
> members. Only if the database successfully returns no records. Are you
> sure that is what happened?
> -----Original Message-----
> From:
> [mailto:]
> On Behalf Of Emilio Recio
> Sent: Wednesday, September 13, 2017 7:20 AM
> To: Grouper Users Mailing List
> <>
> Subject: [grouper-users] grouper-loader fail safe / threshold for failed
> connections
> So we had a network outage, and the connection between grouper-loader
> and our oracle database failed. This caused zero entries to be returned
> when loader ran. When pspng provisioned out to our ldap, it undid the
> attributes for the people we expected from the back end oracle database.
> Is there a way I can tell grouper that if grouper-loader experiences a
> *connection* problem with the back end database, do not do anything;
> just exit with an appropriate rc? Is there a way I can kick off a script
> before to check for connectivity that stops the loader process based on
> its rc?
> I've seen the threshold value, but don't know if it would make sense. We
> expected only 40 peoples' data elements from the back end database. Say
> I put the threshold to 40, then as far as I've seen in the docs,
> reaching this just drops it into fullsynch mode. How does fullsynch mode
> know to apply a failsafe? Is there a property for that?
> --
> Thanks,
> E. Recio
> The information contained in this transmission contains privileged and
> confidential information. It is intended only for the use of the person
> named above. If you are not the intended recipient, you are hereby notified
> that any review, dissemination, distribution or duplication of this
> communication is strictly prohibited. If you are not the intended
> recipient, please contact the sender by reply email and destroy all copies
> of the original message.
> CAUTION: Intended recipients should NOT use email communication for
> emergent or urgent health care matters.

Archive powered by MHonArc 2.6.19.

Top of Page