Grouper Users - Open Discussion List

["Hyzer, Chris" <>]

Sync data to which grouper table?    Grouper_members?

Subjects will get synced when they are used.  To sync all run usdu() from gsh

https://spaces.internet2.edu/display/Grouper/Member+search+and+sort+columns

Thanks
chris

-----Original Message-----
From: Katika,Shanthi Swaroop 
[mailto:]
 
Sent: Monday, August 22, 2016 3:32 PM
To: Hyzer, Chris 
<>
Subject: Re: [grouper-users] Error with JDBC source

Chris,

How do I sync the data to grouper table from the source in sources.xml? Is 
there a command that I should run? 

Best,
Swaroop

On 8/22/16, 3:24 PM, "Katika,Shanthi Swaroop" 
<>
 wrote:

    Thanks, it solved it after I added the three source parameters. Yes, 
profile_id was an int. 
    
    
    Best,
    Swaroop
    
    On 8/22/16, 2:22 PM, "Hyzer, Chris" 
<>
 wrote:
    
        Is profile_id an int?
        
        Set something like this in sources.xml for that source:
        
            <init-param>
              <param-name>subjectIdToFindOnCheckConfig</param-name>
              <param-value>1</param-value>
            </init-param>
        
        https://bugs.internet2.edu/jira/browse/GRP-374
        
        Thanks
        Chris
        
        
        
        -----Original Message-----
        From: 

 
[mailto:]
 On Behalf Of Swaroop Katika
        Sent: Monday, August 22, 2016 2:06 PM
        To: 

        Subject: [grouper-users] Error with JDBC source
        
        Hi,
        
        I'm trying to change my database source from an external MySql 
database to the
        internal grouper MsSql database. 
        
        But when the run gsh, it's throwing me the following error. I'm not 
sure where
        grouperTestSubjectByIdOnStartupASDFGHJ is coming from and where the 
data
        conversion is happening. 
        
        Looking for advice on how to troubleshoot this. 
        
        Using GROUPER_HOME: /var/www/grouper/grouper.apiBinary-2.2.2/bin/..
        Using GROUPER_CONF: 
/var/www/grouper/grouper.apiBinary-2.2.2/bin/../conf
        Using JAVA: java
        using MEMORY: 64m-750m
        Grouper starting up: version: 2.2.2, build date: null, env: <no label
        configured>
        grouper.properties read from:
        /var/www/grouper/grouper.apiBinary-2.2.2/conf/grouper.properties
        Grouper current directory is: 
/var/www/grouper/grouper.apiBinary-2.2.2/bin
        log4j.properties read from:  
        /var/www/grouper/grouper.apiBinary-2.2.2/conf/log4j.properties
        Grouper logs are not using log4j: class
        org.apache.commons.logging.impl.SLF4JLocationAwareLog
        grouper.hibernate.properties:
        
/var/www/grouper/grouper.apiBinary-2.2.2/conf/grouper.hibernate.properties
        grouper.hibernate.properties:
        
grouper_int@jdbc:sqlserver://ahc-sdf09c.ahc.ufl.edu:1433;databaseName=grouper_
        d
        sources.xml read from:       
        /var/www/grouper/grouper.apiBinary-2.2.2/conf/sources.xml
        sources.xml groupersource id: g:gsa
        sources.xml groupersource id: grouperEntities
        sources.xml jdbc source id:   grouper_d: GrouperJdbcConnectionProvider
        Subject API error: error with subject source id: grouper_d, name: 
GROUPER_D
        JDBC Source Adapter, problem with getSubject by id, in sources.xml: 
search
        searchSubject: , 
edu.internet2.middleware.subject.SourceUnavailableException:
        SQLException occurred: Conversion failed when converting the nvarchar 
value
        'grouperTestSubjectByIdOnStartupASDFGHJ' to data type int.: select
        proData.profile_id AS id, proData.display_name AS displayName,
        proData.description AS description from profile_data AS proData where
        proData.profile_id = ?
                at
        
edu.internet2.middleware.subject.provider.JDBCSourceAdapter.createUniqueSubjec
        t(JDBCSourceAdapter.java:480)
                at
        
edu.internet2.middleware.subject.provider.JDBCSourceAdapter.uniqueSearch(JDBCS
        ourceAdapter.java:269)
                at
        
edu.internet2.middleware.subject.provider.JDBCSourceAdapter.getSubject(JDBCSou
        rceAdapter.java:193)
                at
        
edu.internet2.middleware.subject.SubjectCheckConfig.checkConfig(SubjectCheckCo
        nfig.java:111)
                at
        
edu.internet2.middleware.grouper.misc.GrouperCheckConfig$1.callback(GrouperChe
        ckConfig.java:439)
                at
        
edu.internet2.middleware.grouper.GrouperSession.callbackGrouperSession(Grouper
        Session.java:974)
                at
        
edu.internet2.middleware.grouper.misc.GrouperCheckConfig.checkConfig(GrouperCh
        eckConfig.java:435)
                at
        
edu.internet2.middleware.grouper.misc.GrouperStartup.startup(GrouperStartup.ja
        va:256)
                at
        
edu.internet2.middleware.grouper.app.gsh.GrouperShell.main(GrouperShell.java:1
        51)
                at
        
edu.internet2.middleware.grouper.app.gsh.GrouperShellWrapper.main(GrouperShell
        Wrapper.java:31)
        Caused by: com.microsoft.sqlserver.jdbc.SQLServerException: 
Conversion failed
        when converting the nvarchar value 
'grouperTestSubjectByIdOnStartupASDFGHJ' to
        data type int.
                at
        
com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDatabaseError(SQLServe
        rException.java:216)
                at
        
com.microsoft.sqlserver.jdbc.SQLServerResultSet$FetchBuffer.nextRow(SQLServerR
        esultSet.java:4853)
                at
        
com.microsoft.sqlserver.jdbc.SQLServerResultSet.fetchBufferNext(SQLServerResul
        tSet.java:1781)
                at
        
com.microsoft.sqlserver.jdbc.SQLServerResultSet.next(SQLServerResultSet.java:1
        034)
                at
        
com.mchange.v2.c3p0.impl.NewProxyResultSet.next(NewProxyResultSet.java:2859)
                at
        
edu.internet2.middleware.subject.provider.JDBCSourceAdapter.createUniqueSubjec
        t(JDBCSourceAdapter.java:468)
                ... 9 more
        
        Type help() for instructions
        Error: Cannot properly read UTF string from resource: grouperUtf8.txt:
        'ٹٺٻټكلل'
        Error: Queries in your database seem to be case insensitive, this can 
be a
        problem for Grouper, if you are using MySQL you should use a bin 
collation
        gsh 0%
        
        
        
        Best,
        Swaroop