[
http://mifosforge.jira.com/browse/MIFOS-3953?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=62054#action_62054
]
Lukasz Chudy commented on MIFOS-3953:
-------------------------------------
Verified on 18.11.2010
Bug properly fixed.
Commit: ab1c57edfb5ecc9acbff2267a426b3849a12b264
Build Number: hudson-head-1.7.x-264
Branch Name: origin/1.7.x
> loan officer cannot login unless a role is specified
> ----------------------------------------------------
>
> Key: MIFOS-3953
> URL: http://mifosforge.jira.com/browse/MIFOS-3953
> Project: mifos
> Issue Type: Bug
> Components: Personnel
> Affects Versions: Release E - Iteration 9
> Reporter: Adam Monsen
> Assignee: mifosqa
> Priority: Major
> Fix For: Release E
>
>
> h2. repro
> # login as admin user
> # create loan officer -- do not assign any roles
> # logout
> # login as newly created loan officer
> h2. expected result
> Login succeeds.
> h2. actual result
> HTTP 500 error: {{MifosRuntimeException:
> org.hibernate.hql.ast.QuerySyntaxException: unexpected end of subtree}}
> h2. additional information
> Full Exception:
> {noformat}
> org.mifos.core.MifosRuntimeException:
> org.hibernate.hql.ast.QuerySyntaxException: unexpected end of subtree [
> select distinct ra.activity.id from
> org.mifos.security.rolesandpermission.business.RoleActivityEntity ra where
> ra.role.id IN ()
> ]
>
> org.mifos.accounts.savings.persistence.GenericDaoHibernate.executeNamedQuery(GenericDaoHibernate.java:78)
>
> org.mifos.customers.personnel.persistence.PersonnelDaoHibernate.findAuthenticatedUserByUsername(PersonnelDaoHibernate.java:111)
>
> org.mifos.security.AuthenticationAuthorizationServiceFacadeImpl.loadUserByUsername(AuthenticationAuthorizationServiceFacadeImpl.java:34)
>
> org.springframework.security.authentication.dao.DaoAuthenticationProvider.retrieveUser(DaoAuthenticationProvider.java:82)
>
> org.springframework.security.authentication.dao.AbstractUserDetailsAuthenticationProvider.authenticate(AbstractUserDetailsAuthenticationProvider.java:124)
>
> org.springframework.security.authentication.ProviderManager.doAuthentication(ProviderManager.java:120)
>
> org.springframework.security.authentication.AbstractAuthenticationManager.authenticate(AbstractAuthenticationManager.java:48)
>
> org.springframework.security.web.authentication.UsernamePasswordAuthenticationFilter.attemptAuthentication(UsernamePasswordAuthenticationFilter.java:97)
>
> org.springframework.security.web.authentication.AbstractAuthenticationProcessingFilter.doFilter(AbstractAuthenticationProcessingFilter.java:200)
>
> org.mifos.security.authentication.MifosLegacyUsernamePasswordAuthenticationFilter.doFilter(MifosLegacyUsernamePasswordAuthenticationFilter.java:102)
>
> org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:355)
>
> org.springframework.security.web.authentication.logout.LogoutFilter.doFilter(LogoutFilter.java:105)
>
> org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:355)
>
> org.springframework.security.web.context.SecurityContextPersistenceFilter.doFilter(SecurityContextPersistenceFilter.java:79)
>
> org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:355)
>
> org.springframework.security.web.FilterChainProxy.doFilter(FilterChainProxy.java:149)
>
> org.springframework.web.filter.DelegatingFilterProxy.invokeDelegate(DelegatingFilterProxy.java:237)
>
> org.springframework.web.filter.DelegatingFilterProxy.doFilter(DelegatingFilterProxy.java:167)
> {noformat}
> Root cause:
> {noformat}
> org.hibernate.hql.ast.QuerySyntaxException: unexpected end of subtree [
> select distinct ra.activity.id from
> org.mifos.security.rolesandpermission.business.RoleActivityEntity ra where
> ra.role.id IN ()
> ]
>
> org.hibernate.hql.ast.QuerySyntaxException.convert(QuerySyntaxException.java:54)
>
> org.hibernate.hql.ast.QuerySyntaxException.convert(QuerySyntaxException.java:47)
>
> org.hibernate.hql.ast.ErrorCounter.throwQueryException(ErrorCounter.java:82)
>
> org.hibernate.hql.ast.QueryTranslatorImpl.analyze(QueryTranslatorImpl.java:261)
>
> org.hibernate.hql.ast.QueryTranslatorImpl.doCompile(QueryTranslatorImpl.java:185)
>
> org.hibernate.hql.ast.QueryTranslatorImpl.compile(QueryTranslatorImpl.java:136)
> org.hibernate.engine.query.HQLQueryPlan.<init>(HQLQueryPlan.java:101)
> org.hibernate.engine.query.HQLQueryPlan.<init>(HQLQueryPlan.java:80)
>
> org.hibernate.engine.query.QueryPlanCache.getHQLQueryPlan(QueryPlanCache.java:98)
>
> org.hibernate.impl.AbstractSessionImpl.getHQLQueryPlan(AbstractSessionImpl.java:156)
> org.hibernate.impl.SessionImpl.list(SessionImpl.java:1250)
> org.hibernate.impl.QueryImpl.list(QueryImpl.java:102)
>
> org.mifos.accounts.savings.persistence.GenericDaoHibernate.executeNamedQuery(GenericDaoHibernate.java:76)
>
> org.mifos.customers.personnel.persistence.PersonnelDaoHibernate.findAuthenticatedUserByUsername(PersonnelDaoHibernate.java:111)
>
> org.mifos.security.AuthenticationAuthorizationServiceFacadeImpl.loadUserByUsername(AuthenticationAuthorizationServiceFacadeImpl.java:34)
>
> org.springframework.security.authentication.dao.DaoAuthenticationProvider.retrieveUser(DaoAuthenticationProvider.java:82)
>
> org.springframework.security.authentication.dao.AbstractUserDetailsAuthenticationProvider.authenticate(AbstractUserDetailsAuthenticationProvider.java:124)
>
> org.springframework.security.authentication.ProviderManager.doAuthentication(ProviderManager.java:120)
>
> org.springframework.security.authentication.AbstractAuthenticationManager.authenticate(AbstractAuthenticationManager.java:48)
>
> org.springframework.security.web.authentication.UsernamePasswordAuthenticationFilter.attemptAuthentication(UsernamePasswordAuthenticationFilter.java:97)
>
> org.springframework.security.web.authentication.AbstractAuthenticationProcessingFilter.doFilter(AbstractAuthenticationProcessingFilter.java:200)
>
> org.mifos.security.authentication.MifosLegacyUsernamePasswordAuthenticationFilter.doFilter(MifosLegacyUsernamePasswordAuthenticationFilter.java:102)
>
> org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:355)
>
> org.springframework.security.web.authentication.logout.LogoutFilter.doFilter(LogoutFilter.java:105)
>
> org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:355)
>
> org.springframework.security.web.context.SecurityContextPersistenceFilter.doFilter(SecurityContextPersistenceFilter.java:79)
>
> org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:355)
>
> org.springframework.security.web.FilterChainProxy.doFilter(FilterChainProxy.java:149)
>
> org.springframework.web.filter.DelegatingFilterProxy.invokeDelegate(DelegatingFilterProxy.java:237)
>
> org.springframework.web.filter.DelegatingFilterProxy.doFilter(DelegatingFilterProxy.java:167)
> {noformat}
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
http://mifosforge.jira.com/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
------------------------------------------------------------------------------
Beautiful is writing same markup. Internet Explorer 9 supports
standards for HTML5, CSS3, SVG 1.1, ECMAScript5, and DOM L2 & L3.
Spend less time writing and rewriting code and more time creating great
experiences on the web. Be a part of the beta today
http://p.sf.net/sfu/msIE9-sfdev2dev
_______________________________________________
Mifos-issues mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/mifos-issues
