Grouper Users - Open Discussion List

["Katika,Shanthi Swaroop" <>]

Good Morning,

 

Any suggestions on how might correct the config for the search parameters in the grouper UI? The database is internal grouper database.

 

 

Best,
Swaroop

 

From: <> on behalf of temp <>
Date: Tuesday, September 6, 2016 at 1:35 PM
To: "Hyzer, Chris" <>, "" <>
Subject: Re: [grouper-users] Grouper Ui error

 

It’s very likely that it might be the issue.  Below is my config for the source that’s causing the issue.

 

<source adapterClass="edu.internet2.middleware.grouper.subj.GrouperJdbcSourceAdapter">

        <id>grouper_d</id>

        <name>GROUPER_D JDBC Source Adapter</name>

        <type>member</type>

 

        <init-param>

            <param-name>jdbcConnectionProvider</param-name>

            <param-value>edu.internet2.middleware.grouper.subj.GrouperJdbcConnectionProvider</param-value>

        </init-param>

        <init-param>

            <param-name>Multiple_Results</param-name>

            <param-value>true</param-value>

        </init-param>

        <init-param>

            <param-name>SubjectID_AttributeType</param-name>

            <param-value>id</param-value>

        </init-param>

        <init-param>

            <param-name>Name_AttributeType</param-name>

            <param-value>displayName</param-value>

        </init-param>

        <init-param>

            <param-name>Description_AttributeType</param-name>

            <param-value>description</param-value>

        </init-param>

        <init-param>

            <param-name>sortAttribute0</param-name>

            <param-value>name</param-value>

        </init-param>

        <init-param>

                <param-name>subjectVirtualAttribute_0_searchAttribute0</param-name>

                <param-value>${subject.getAttributeValue('search_string0')}</param-value>

        </init-param>

        <init-param>

                 <param-name>searchAttribute0</param-name>

                 <param-value>searchAttribute0</param-value>

        </init-param>

        <!-- on a findPage() this is the most results returned -->

        <init-param>

                 <param-name>maxPageSize</param-name>

                <param-value>100</param-value>

        </init-param>

        <internal-attribute>searchAttribute0</internal-attribute>

        <init-param>

            <param-name>findSubjectByIdOnCheckConfig</param-name>

            <param-value>false</param-value>

        </init-param>

        <init-param>

            <param-name>subjectIdToFindOnCheckConfig</param-name>

            <param-value>1</param-value>

        </init-param>

        <init-param>

            <param-name>findSubjectByIdentifiedOnCheckConfig</param-name>

                <param-value>false</param-value>

        </init-param>

        <init-param>

            <param-name>subjectIdentifierToFindOnCheckConfig</param-name>

            <param-value>1</param-value>

        </init-param>

        <init-param>

            <param-name>findSubjectByStringOnCheckConfig</param-name>

            <param-value>false</param-value>

        </init-param>

        <init-param>

            <param-name>stringToFindOnCheckConfig</param-name>

            <param-value>1</param-value>

        </init-param>

       <search>

            <searchType>searchSubject</searchType>

            <param>

                <param-name>sql</param-name>

                <param-value>

                    select proData.profile_id AS id, proData.display_name AS displayName, proData.ufid AS description from profile_data AS proData where proData.profile_id = ?

                </param-value>

            </param>

        </search>

        <search>

            <searchType>searchSubjectByIdentifier</searchType>

            <param>

                <param-name>sql</param-name>

                <param-value>

                    select proData.profile_id AS id, proData.first_name, proData.last_name, proData.display_name AS displayName, proData.ufid AS description from profile_data AS proData where proData.profile_id = ?

                </param-value>

            </param>

        </search>

        <search>

            <searchType>search</searchType>

            <param>

                <param-name>sql</param-name>

                <param-value>

 

                    select proData.profile_id AS id, proData.first_name, proData.last_name, proData.ufid, proData.display_name AS displayName, proData.ufid AS description from profile_data AS proData

 

                    where

 

                    (lower(proData.first_name) like '%' || ? || '%')

 

                    or (lower(proData.last_name) like '%' || ? || '%')

 

                    or (proData.ufid like '%' || ? || '%')

 

                </param-value>

            </param>

        </search>

</source>

 

From: "Hyzer, Chris" <>
Date: Thursday, September 1, 2016 at 9:43 AM
To: temp <>, "" <>
Subject: RE: [grouper-users] Grouper Ui error

 

I think it is something in your sources.xml… is it conflgured correctly?

 

From: [mailto:] On Behalf Of Katika,Shanthi Swaroop
Sent: Thursday, September 01, 2016 7:06 AM
To:
Subject: [grouper-users] Grouper Ui error

 

Good Morning,

When I’m searching members while trying to add them to a group, I’m getting the following error:

 

Error: Exception with source: grouper_d, on query: 'abcd', Problem calling method addMemberSearch on edu.internet2.middleware.grouper.grouperUi.serviceLogic.UiV2Group

 

Is there some setting that I need to turn on?

 

Best,
Swaroop