Grouper Users - Open Discussion List

[Scott Koranda <>]

Hi,

I am using Grouper 2.2.1.

Using GSH when I execute

grouperSession = GrouperSession.startRootSession();
mystem = StemFinder.findByName(grouperSession, "mystem");
RuleApi.runRulesForOwner(mystem);

(the rule has been previously attached to the stem)

I receive the following stack trace:

2016-02-02 16:12:49,768: [main] ERROR ErrorCounter.reportError(56) -  - line 
1:80: unexpected token: and
2016-02-02 16:12:49,771: [main] ERROR ShellHelper.eval(91) -  - Sourced file: 
inline evaluation of: ``RuleApi.runRulesForOwner(testFolder01);'' : Method 
Invocation RuleApi.runRulesForOwner
edu.internet2.middleware.grouper.internal.dao.GrouperDAOException: Problem in 
HibernateSession: HibernateSession (317bace8): new, readonly, READONLY_NEW, 
notActiveTransaction, session (2d1e85e8),
Exception in list: (class edu.internet2.middleware.grouper.Group), 
ByHqlStatic, query: 'select distinct theGroup from Group
theGroup  and theGroup.nameDb like :stemPattern ', cacheable: false, 
cacheRegion:
edu.internet2.middleware.grouper.internal.dao.hib3.Hib3GroupDAO.FindGroupsInStemWithoutPrivilege,
 tx type: null, options:
QueryOptions: querySort: theGroup.displayNameDb asc, , tx type: nullBind 
var[0]: 'Param (class java.lang.String): 'stemPattern'->'mystem1:%', 
    at 
edu.internet2.middleware.grouper.hibernate.HibernateSession._internal_hibernateSessionCatch(HibernateSession.java:556)
    at 
edu.internet2.middleware.grouper.hibernate.HibernateSession.callbackHibernateSession(HibernateSession.java:678)
    at 
edu.internet2.middleware.grouper.hibernate.ByHqlStatic.list(ByHqlStatic.java:372)
    at 
edu.internet2.middleware.grouper.hibernate.ByHqlStatic.listSet(ByHqlStatic.java:421)
    at 
edu.internet2.middleware.grouper.internal.dao.hib3.Hib3GroupDAO.findGroupsInStemWithoutPrivilege(Hib3GroupDAO.java:2404)
    at 
edu.internet2.middleware.grouper.privs.GrouperPrivilegeAdapter$3.callback(GrouperPrivilegeAdapter.java:279)
    at 
edu.internet2.middleware.grouper.GrouperSession.callbackGrouperSession(GrouperSession.java:974)
    at 
edu.internet2.middleware.grouper.privs.GrouperPrivilegeAdapter.internal_getGroupsWhereSubjectDoesntHavePriv(GrouperPrivilegeAdapter.java:274)
    at 
edu.internet2.middleware.grouper.privs.GrouperNonDbAccessAdapter.getGroupsWhereSubjectDoesntHavePrivilege(GrouperNonDbAccessAdapter.java:198)
    at 
edu.internet2.middleware.grouper.privs.AccessWrapper.getGroupsWhereSubjectDoesntHavePrivilege(AccessWrapper.java:117)
    at 
edu.internet2.middleware.grouper.privs.GrouperAllAccessResolver.getGroupsWhereSubjectDoesntHavePrivilege(GrouperAllAccessResolver.java:100)
    at 
edu.internet2.middleware.grouper.privs.AccessResolverDecorator.getGroupsWhereSubjectDoesntHavePrivilege(AccessResolverDecorator.java:126)
    at 
edu.internet2.middleware.grouper.privs.AccessResolverDecorator.getGroupsWhereSubjectDoesntHavePrivilege(AccessResolverDecorator.java:126)
    at 
edu.internet2.middleware.grouper.privs.AccessResolverDecorator.getGroupsWhereSubjectDoesntHavePrivilege(AccessResolverDecorator.java:126)
    at 
edu.internet2.middleware.grouper.privs.ValidatingAccessResolver.getGroupsWhereSubjectDoesntHavePrivilege(ValidatingAccessResolver.java:94)
    at 
edu.internet2.middleware.grouper.rules.RuleCheckType$8.runDaemon(RuleCheckType.java:1042)
    at 
edu.internet2.middleware.grouper.rules.RuleDefinition$1.callback(RuleDefinition.java:333)
    at 
edu.internet2.middleware.grouper.GrouperSession.callbackGrouperSession(GrouperSession.java:974)
    at 
edu.internet2.middleware.grouper.rules.RuleDefinition.runDaemonOnDefinitionIfShould(RuleDefinition.java:326)
    at 
edu.internet2.middleware.grouper.rules.RuleApi.runRulesForOwner(RuleApi.java:749)
    at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
    at 
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
    at 
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
    at java.lang.reflect.Method.invoke(Method.java:622)
    at bsh.Reflect.invokeMethod(Unknown Source)
    at bsh.Reflect.invokeStaticMethod(Unknown Source)
    at bsh.Name.invokeMethod(Unknown Source)
    at bsh.BSHMethodInvocation.eval(Unknown Source)
    at bsh.BSHPrimaryExpression.eval(Unknown Source)
    at bsh.BSHPrimaryExpression.eval(Unknown Source)
    at bsh.Interpreter.eval(Unknown Source)
    at bsh.Interpreter.eval(Unknown Source)
    at bsh.Interpreter.eval(Unknown Source)
    at 
edu.internet2.middleware.grouper.app.gsh.ShellHelper.eval(ShellHelper.java:63)
    at 
edu.internet2.middleware.grouper.app.gsh.GrouperShell.run(GrouperShell.java:429)
    at 
edu.internet2.middleware.grouper.app.gsh.GrouperShell.grouperShellHelper(GrouperShell.java:232)
    at 
edu.internet2.middleware.grouper.app.gsh.GrouperShell.main(GrouperShell.java:162)
    at 
edu.internet2.middleware.grouper.app.gsh.GrouperShellWrapper.main(GrouperShellWrapper.java:31)
Caused by: org.hibernate.hql.ast.QuerySyntaxException: unexpected token: and 
near line 1, column 80 [select distinct theGroup from 
edu.internet2.middleware.grouper.Group theGroup  and theGroup.nameDb like 
:stemPattern  order by theGroup.displayNameDb asc]
    at 
org.hibernate.hql.ast.QuerySyntaxException.convert(QuerySyntaxException.java:54)
    at 
org.hibernate.hql.ast.QuerySyntaxException.convert(QuerySyntaxException.java:47)
    at 
org.hibernate.hql.ast.ErrorCounter.throwQueryException(ErrorCounter.java:82)
    at 
org.hibernate.hql.ast.QueryTranslatorImpl.parse(QueryTranslatorImpl.java:284)
    at 
org.hibernate.hql.ast.QueryTranslatorImpl.doCompile(QueryTranslatorImpl.java:182)
    at 
org.hibernate.hql.ast.QueryTranslatorImpl.compile(QueryTranslatorImpl.java:136)
    at org.hibernate.engine.query.HQLQueryPlan.<init>(HQLQueryPlan.java:101)
    at org.hibernate.engine.query.HQLQueryPlan.<init>(HQLQueryPlan.java:80)
    at 
org.hibernate.engine.query.QueryPlanCache.getHQLQueryPlan(QueryPlanCache.java:124)
    at 
org.hibernate.impl.AbstractSessionImpl.getHQLQueryPlan(AbstractSessionImpl.java:156)
    at 
org.hibernate.impl.AbstractSessionImpl.createQuery(AbstractSessionImpl.java:135)
    at org.hibernate.impl.SessionImpl.createQuery(SessionImpl.java:1770)
    at 
edu.internet2.middleware.grouper.hibernate.ByHql.attachQueryInfo(ByHql.java:481)
    at edu.internet2.middleware.grouper.hibernate.ByHql.list(ByHql.java:347)
    at 
edu.internet2.middleware.grouper.hibernate.ByHqlStatic$2.callback(ByHqlStatic.java:382)
    at 
edu.internet2.middleware.grouper.hibernate.HibernateSession.callbackHibernateSession(HibernateSession.java:668)
    ... 36 more

Any ideas on why I am seeing the stack trace?

Note that I have a development sandbox running the same
version of Grouper and I am unable to reproduce this?

Thanks,

Scott K