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

Subject: Grouper Users - Open Discussion List

List archive

[grouper-users] Organizational Structure without Members

From: Akki Kumar <>
To: "Hyzer, Chris" <>,
Subject: [grouper-users] Organizational Structure without Members
Date: Mon, 6 Mar 2017 16:42:28 -0500
Ironport-phdr: 9a23:AFOJcRBtte/QDIz5sTugUyQJP3N1i/DPJgcQr6AfoPdwSP37pMqwAkXT6L1XgUPTWs2DsrQf2reQ7/irADFaqb+681k6OKRWUBEEjchE1ycBO+WiTXPBEfjxciYhF95DXlI2t1uyMExSBdqsLwaK+i764jEdAAjwOhRoLerpBIHSk9631+ev8JHPfglEnjSwbLdyIRmsogjdqsYajZZiJ6ov1xDEvmZGd+NKyG1yOFmdhQz85sC+/J5i9yRfpfcs/NNeXKv5Yqo1U6VWACwpPG4p6sLrswLDTRaU6XsHTmoWiBtIDBPb4xz8Q5z8rzH1tut52CmdIM32UbU5Uims4qt3VBPljjoMOjgk+2/Vl8NwlrpWrhKvqRJ83oDafp2aOeFkca/BZ94XX3ZNUtpTWiFHH4iyb5EPD+0EPetAs4T9pFgOrRqjDgepGePvzyVHhmXr1qA9yeshFBvJ3Q0hH9IIv3TUtcj1O7kJUeCpzanIyjPDb+hK1Tvh6oXFaR8hofSWUrJxdcrd01UgFwTAjliJr4HuIj2b1uMIs2eB7upgU/qii2EgqwF2rTivwtkjhpPViYISz1DI7Sp5wJwyJd2lUE50f8SkHIFKuCGCL4t6WsIiQ2d0uCkk0L0Gv4C0fDQUxJg92RHQduGHf5CU4hLjTuaePy13i29/dLKlmhay91CsyuLmVsmzzVZKtjRKksPQuX8X0xzT7tKIReB5/ki/wzqAyxrc6uVAIUwsm6rbNoIhwqMqlpUNrUTMBDT2mEbsgK+Ma0Uk/O6l4PnkbLX+vpKQKY55hh38P6krlMyyAv83PhQLUmWU5eiwyLPu8EjlT7lWgP07l6zUvI7EKckfoKOyHhVb3Zw56xmlCjeryNQYkmcDLFJCYB+HipLmO1DKIPzhCve/n0ignC5kxvzYILHsBo/BLnfEkLfmcrZ971BTxBAvwtBY4pJYErABIPTtVU/trNHUEB40PxC2zuviBtVw1ZgRVX6KD6KWLK/erVGF6+czLOWQao8YvTPwJ+Y76/PqlXM5nEUSfait3ZsZcnC4GfFmLl2DbnrpmNgAEGYKvgwxTOzzlV2NTyVTZ2qzX6I74DE7E56qAZvBS422j7yB2T20HpxSZmxcFl+MFnLoe52eW/gQcCKSPtNhkjscWLiuUY8h0gyutBfkxLp9N+bU5zYYuoz51Nhu/ODTkRAy9SdoD8SGzW2BVWB0nmUURzAoxqB/p1Jyykud3aRinfNXCMFTtLt1VVJwFY/OwvY+Q/vyQAPaNJ/dTV2mU8erGxkwVdl33scDZUA7Ftm/2FSL0DCtHqcYjfmWH5Eu6Yrd2WT8PcBw1yyA2aU83Hc8Rc4aHG6lh+Zc6g3aHcadmkCQhaeser0B0TXR9WCF1jLW42lXVQdxVePOWnVJNRielsjw+k6XF+zmMr8gKAYUkcM=

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?

Loader Setting Screenshot: https://drive.google.com/drive/folders/0BwgGnZC7vA-6MEJ5RzJ3aWJ3eTA

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