Skip to Content.
Sympa Menu

grouper-users - [grouper-users] Re: Organizational Structure without Members

Subject: Grouper Users - Open Discussion List

List archive

[grouper-users] Re: Organizational Structure without Members


Chronological Thread 
  • From: "Hyzer, Chris" <>
  • To: Akki Kumar <>, "" <>
  • Subject: [grouper-users] Re: Organizational Structure without Members
  • Date: Wed, 8 Mar 2017 15:43:17 +0000
  • Accept-language: en-US
  • Authentication-results: spf=none (sender IP is ) ;
  • Ironport-phdr: 9a23:AGUwxR34NiAX5xNAsmDT+DRfVm0co7zxezQtwd8ZsesWIv/xwZ3uMQTl6Ol3ixeRBMOAuq8C17ad7P6ocFdDyK7JiGoFfp1IWk1NouQttCtkPvS4D1bmJuXhdS0wEZcKflZk+3amLRodQ56mNBXdrXKo8DEdBAj0OxZrKeTpAI7SiNm82/yv95HJbQhFgDqwbal9IRi5ognctMgbipZ+J6gszRfEvmFGcPlMy2NyIlKTkRf85sOu85Nm7i9dpfEv+dNeXKvjZ6g3QqBWAzogM2Au+c3krgLDQheV5nsdSWoZjBxFCBXY4R7gX5fxtiz6tvdh2CSfIMb7Q6w4VSik4qx2ThLjlSUJOCMj8GzPisJ+kr9VoA6vqRJ8zY7bYoCVO+Zxca7GZ9wWWXZNU9xNWyBdHI+xaZYEAeobPeZfqonwv1UCoxm+BAitGuzv0CdEjWLo0K06yeQhEBrG0AI9FN8JtXTbsNX1NacTUO+r1qnF1jTDb+hK1jvn9YjIag4uofeKXb5qb8Xe1FQvGhrDg16Np4LlODaV2f4Ms2id9+dgWuWvi2koqwF1vDej3Nsjio7Mho4NxVDE7yJ5wJstJdKmUk53e8SrEINIty2CNot2RN8iTH9yuCY81LIGpYC3cDIUx5s62h7Tc+CHc4iS4h39TumePC10hGh4eLK5nxqy/lKgyurhVsmszllKtDZKncPItnAJzRPc8cyHReVn8ki9wzmP0wTT5vlKIUApiarbNoQhzaAslpUJqkTDHTX6mF/rjK+QcEgv5+um6/z/b7n4u5ORNpV4hw/gPqg0h8CyAvg0PhIOUmWb4eiwybPu8VHjTLhOk/E6iLfVvI3eKMgBu6K0AQ5Y34A+4BilFTimys4XnXwfIVJFZh2Hi4/pNknWLv3kCvmzn1qhnC52yv/EILHtG5LNIWPdn7v7erZ99lJcxxE0zdBC4ZJbF6sNIOrpWk/2qNzXEAM2MxC1w+bgDtVxzIQeWX+TAq+dN6PStlyI6vgzLOmLYY8ZoDf9K/476P7ylXI1h0IRcKiz0ZYZdny0BOlqLkaFbXb2gtoMEX8Gvg8kQ+zrjF2CXyRTZ3G3X68k4zE0FIKmDIfCR4+zmryMxya7HoZKaWxcF1CMCWnnd4OCW/sWdi2dP9JhniQeVbe9U48hyQ2utAjixrpoNOrU/TAYtYr929hv/uHTiAoy+iJuD8SGyGyNS2B0nngURz8twqxzu019ylGf0admmfxYE8Jc5+9XXgsgK5HT0vF6WJjOXVfofdSIAHW7R9y8SWU4S9sjwtkBeltwAMmjiRbYh3L1K7AQnr2PQpcz9/SYlzL+PcFg03vckbQ6gkM9aspJKWC8gKNjrU7eC5OD2xGWjaG3bakGmTPW+X2Y5WuIoExCVgNsC+PIUW1JNWXMqtGsrGPTXbK0TfwMMhFA0oTKfq5Basz7gE9uRezofsnGbmS33Wq8GEDblfu3cIP2djBFj23mA08enlVL8A==
  • Spamdiagnosticmetadata: NSPM
  • Spamdiagnosticoutput: 1:99

There are two queries available:

  • grouperLoaderQuery: This is the query to run in the DB, which must have certain columns required or optional based on the grouperLoaderType.  e.g. for SQL_SIMPLE, the SUBJECT_ID is required, and the SUBJECT_SOURCE_ID is optional.  If your DB supports views, might not be a bad idea to link query up to a view so you can easily see what it will return and change it without affecting the group attribute.  But will work with any select query.  This is required.  Note: in Grouper v2.1 you can try having SUBJECT_IDENTIFIER or SUBJECT_ID_OR_IDENTIFIER instead of SUBJECT_ID, though each is less efficient than the next since they require an extra subject lookup or multiple subject lookups per row
  • grouperLoaderGroupQuery: query (optional) for SQL_GROUP_LIST which should return cols: group_name, group_display_name (optional), group_description (optional) which if there are used for the group display and extension.  Note: the parent stem display names are only changed when creating them.  This should return all groups in the membership list, and if not there, its ok, the extension will be used as display extension, and a generated description. Note: the display name is the display path, with the display extension of each parent stem.  If there is a column named any of the following: readers, viewers, admins, updaters, optins, optouts, then the data in the column (comma separated subjectId's or subjectIdentifers (which can include group names) will be assigned to that privilege list.  Note, existing assignments to that privilege list will not be removed, so if you remove an item from the query, you will need to manually remove it from the groups.  This is a way to have a loaderJob-wide list of readers or viewers.


you cant have a blank subject_id.  but I hope if you list the group in the gruoperLoaderGroupQuery that it will work.  Can you please try it?  If not we can fix that...

thanks
Chris

From: Akki Kumar <>
Sent: Monday, March 6, 2017 4:42:28 PM
To: Hyzer, Chris;
Subject: Organizational Structure without Members
 
Hi Chris,

I am working on creating the Organizational Hierarchical Structure without members in it (https://spaces.internet2.edu/display/Grouper/Organization+hierarchies+via+the+grouper+loader). When I run the SQL loader, it's showing below error (I kept the subject_ID column empty because groups cannot have members in it). However, based on the error, it looks like Subject_ID cannot be empty. Does grouper support creating an Organizational Structure without adding members to the group?



Error: 
       at edu.internet2.middleware.grouper.app.loader.db.GrouperLoaderResultset$Row.getSubject(GrouperLoaderResultset.java:1381)
        at edu.internet2.middleware.grouper.app.loader.GrouperLoaderType.syncOneGroupMembership(GrouperLoaderType.java:2256)
        at edu.internet2.middleware.grouper.app.loader.GrouperLoaderType.syncGroupLogicForOneGroup(GrouperLoaderType.java:1466)
        at edu.internet2.middleware.grouper.app.loader.GrouperLoaderType.access$200(GrouperLoaderType.java:112)
        at edu.internet2.middleware.grouper.app.loader.GrouperLoaderType$10.callLogic(GrouperLoaderType.java:1386)
        at edu.internet2.middleware.grouper.app.loader.GrouperLoaderType$10.callLogic(GrouperLoaderType.java:1382)
        at edu.internet2.middleware.grouper.util.GrouperCallable$1.callback(GrouperCallable.java:164)
        at edu.internet2.middleware.grouper.GrouperSession.callbackGrouperSession(GrouperSession.java:974)
        at edu.internet2.middleware.grouper.util.GrouperCallable.callLogicWithSessionIfExists(GrouperCallable.java:161)
        at edu.internet2.middleware.grouper.util.GrouperCallable.call(GrouperCallable.java:132)
        at java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:334)
        at java.util.concurrent.FutureTask.run(FutureTask.java:166)
        at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1146)
        at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615)
        at java.lang.Thread.run(Thread.java:701)
2017-03-06 15:44:55,394: [pool-1-thread-37] ERROR GrouperLoaderResultset$Row.getSubject(1399) -  - Problem with null: null, subjectSourceId: ldap, in jobName: Application Roles:DIT:TestGroupOne
java.lang.RuntimeException: Loader job needs to have SUBJECT_ID, SUBJECT_IDENTIFIER, or SUBJECT_ID_OR_IDENTIFIER! Application Roles:DIT:TestGroupOne, ArrayList size: 3: [0]: GROUP_NAME
[1]: SUBJECT_ID
[2]: SUBJECT_SOURCE_ID

        at edu.internet2.middleware.grouper.app.loader.db.GrouperLoaderResultset$Row.getSubject(GrouperLoaderResultset.java:1381)
        at edu.internet2.middleware.grouper.app.loader.GrouperLoaderType.syncOneGroupMembership(GrouperLoaderType.java:2256)
        at edu.internet2.middleware.grouper.app.loader.GrouperLoaderType.syncGroupLogicForOneGroup(GrouperLoaderType.java:1466)
        at edu.internet2.middleware.grouper.app.loader.GrouperLoaderType.access$200(GrouperLoaderType.java:112)
        at edu.internet2.middleware.grouper.app.loader.GrouperLoaderType$10.callLogic(GrouperLoaderType.java:1386)
        at edu.internet2.middleware.grouper.app.loader.GrouperLoaderType$10.callLogic(GrouperLoaderType.java:1382)
        at edu.internet2.middleware.grouper.util.GrouperCallable$1.callback(GrouperCallable.java:164)
        at edu.internet2.middleware.grouper.GrouperSession.callbackGrouperSession(GrouperSession.java:974)
        at edu.internet2.middleware.grouper.util.GrouperCallable.callLogicWithSessionIfExists(GrouperCallable.java:161)
        at edu.internet2.middleware.grouper.util.GrouperCallable.call(GrouperCallable.java:132)
        at java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:334)
        at java.util.concurrent.FutureTask.run(FutureTask.java:166)
        at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1146)
        at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615)
        at java.lang.Thread.run(Thread.java:701)
2017-03-06 15:44:55,394: [pool-1-thread-37] ERROR GrouperLoaderResultset$Row.getSubject(1399) -  - Problem with null: null, subjectSourceId: ldap, in jobName: Application Roles:DIT:TestGroupTwo
java.lang.RuntimeException: Loader job needs to have SUBJECT_ID, SUBJECT_IDENTIFIER, or SUBJECT_ID_OR_IDENTIFIER! Application Roles:DIT:TestGroupTwo, ArrayList size: 3: [0]: GROUP_NAME
[1]: SUBJECT_ID
[2]: SUBJECT_SOURCE_ID


Thank you,
Akki



Archive powered by MHonArc 2.6.19.

Top of Page