Uploaded image for project: 'Grouper'
  1. Grouper
  2. GRP-2735

Ui loader diagnostics for SUBJECT_ID_OR_IDENTIFIER reports error

    XMLWordPrintable

Details

    • Bug
    • Status: Resolved
    • Minor
    • Resolution: Unresolved
    • 2.4.0, 2.5.0
    • 2.5.27
    • UI
    • None

    Description

      Wiki states that a group loader can have a column for SUBJECT_ID_OR_IDENTIFIER. However, when running diagnostics in the UI, there is an error.

      SQL:

      SELECT user_id AS SUBJECT_ID_OR_IDENTIFIER  FROM training_management WHERE user_id IS NOT NULL UNION ALL SELECT internet_id AS SUBJECT_ID_OR_IDENTIFIER FROM training_management WHERE user_id IS NULL AND internet_id IS NOT NULL; 

       

      Error

      java.lang.RuntimeException: Column not found: SUBJECT_IDENTIFIER,Problem calling method loaderDiagnosticsRun on edu.internet2.middleware.grouper.grouperUi.serviceLogic.UiV2GrouperLoader    at edu.internet2.middleware.grouper.app.loader.db.GrouperLoaderResultset$Row.getCell(GrouperLoaderResultset.java:1514)    at edu.internet2.middleware.grouper.app.loader.db.GrouperLoaderResultset.getCell(GrouperLoaderResultset.java:1587)    at edu.internet2.middleware.grouper.grouperUi.serviceLogic.UiV2GrouperLoader.loaderDiagnosticsRun(UiV2GrouperLoader.java:2570)    at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)    at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)    at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)    at java.lang.reflect.Method.invoke(Method.java:498)    at edu.internet2.middleware.grouper.util.GrouperUtil.invokeMethod(GrouperUtil.java:4238)    at edu.internet2.middleware.grouper.util.GrouperUtil.callMethod(GrouperUtil.java:4189)    at edu.internet2.middleware.grouper.j2ee.GrouperUiRestServlet.doGet(GrouperUiRestServlet.java:327)    at edu.internet2.middleware.grouper.j2ee.GrouperUiRestServlet.doPost(GrouperUiRestServlet.java:198)    at javax.servlet.http.HttpServlet.service(HttpServlet.java:660)    at javax.servlet.http.HttpServlet.service(HttpServlet.java:741)    at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:231)
      ... 

       

       

      Attachments

        Activity

          People

            chad.redman@at.internet2.edu Chad Redman (unc.edu)
            chad.redman@at.internet2.edu Chad Redman (unc.edu)
            Votes:
            0 Vote for this issue
            Watchers:
            1 Start watching this issue

            Dates

              Created:
              Updated:

              Smart Checklist