Skip to Content.
Sympa Menu

grouper-users - Re: [grouper-users] Grouper Ui error

Subject: Grouper Users - Open Discussion List

List archive

Re: [grouper-users] Grouper Ui error


Chronological Thread 
  • From: "Katika,Shanthi Swaroop" <>
  • To: Shilen Patel <>
  • Cc: "Hyzer, Chris" <>, "" <>
  • Subject: Re: [grouper-users] Grouper Ui error
  • Date: Mon, 19 Sep 2016 12:45:13 +0000
  • Accept-language: en-US
  • Ironport-phdr: 9a23:8ri9ExHCaF1t3bjNpOC7+p1GYnF86YWxBRYc798ds5kLTJ75p82wAkXT6L1XgUPTWs2DsrQf1LqQ7vurADFIyK3CmU5BWaQEbwUCh8QSkl5oK+++Imq/EsTXaTcnFt9JTl5v8iLzG0FUHMHjew+a+SXqvnY6Uy/yPgttJ+nzBpWaz4Huj7jzqNXvZFBzhDu5bLU6FByqoAGZ4tIWgI9vLI491xjE5HZEZrIF63lvIAfZvB/g58S5uKVj+iJMu/NpzNFJS6L9Z+5wGadbBSgnMGkd+cPv8xTPUF3ctTMnTmwKn08QUED+5xbgU8K063Oiuw==

As you suggested, I went into the logs trace. I had an error in the sql. I moved to a different database than the one I was using when I wrote sources.xml file, but failed to adjust the sql accordingly. Thank you for the assistance!

 

Best,
Swaroop

 

From: Shilen Patel <>
Date: Thursday, September 8, 2016 at 8:05 AM
To: temp <>
Cc: "Hyzer, Chris" <>, "" <>
Subject: Re: [grouper-users] Grouper Ui error

 

Do your logs have a stack trace?

 

Thanks!

 

- Shilen

 

From: <Katika>, Shanthi Swaroop <>
Date: Thursday, September 8, 2016 at 7:09 AM
To: "Hyzer, Chris" <>, "" <>
Subject: Re: [grouper-users] Grouper Ui error

 

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: [] 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




Archive powered by MHonArc 2.6.19.

Top of Page