net.sf.hibernate.QueryException

unexpected token: AND [ select count(*) from com.atlassian.bamboo.resultsummary.BuildResultsSummaryImpl b AND b.buildState != 'Pending' ]

Solutions on the web37

  • via Atlassian JIRA by Belinda Teh [Atlassian], 11 months ago
    unexpected token: AND [ select count(*) from com.atlassian.bamboo.resultsummary.BuildResultsSummaryImpl b AND b.buildState != 'Pending' ]
  • via Atlassian JIRA by Belinda Teh [Atlassian], 1 year ago
    unexpected token: AND [ select count(*) from com.atlassian.bamboo.resultsummary.BuildResultsSummaryImpl b AND b.buildState != 'Pending' ]
  • unexpected token: html [from inode in class com.dotmarketing.portlets.htmlpages.model.HTMLPage html, com.dotmarketing.portlets.htmlpages.model.HTMLPageVersionInfo vv where type='htmlpage' and identifier=vv.identifier and vv.live_inode=inode and vv.deleted=0]
  • Stack trace

    • net.sf.hibernate.QueryException: unexpected token: AND [ select count(*) from com.atlassian.bamboo.resultsummary.BuildResultsSummaryImpl b AND b.buildState != 'Pending' ] at org.springframework.orm.hibernate.SessionFactoryUtils.convertHibernateAccessException(SessionFactoryUtils.java:581) at org.springframework.orm.hibernate.HibernateAccessor.convertHibernateAccessException(HibernateAccessor.java:353) at org.springframework.orm.hibernate.HibernateTemplate.execute(HibernateTemplate.java:375) at com.atlassian.bamboo.resultsummary.BuildResultsSummaryHibernateDao.countBuildResultsSummaries(BuildResultsSummaryHibernateDao.java:129) at com.atlassian.bamboo.resultsummary.BuildResultsSummaryManagerImpl.countBuildResultsSummaries(BuildResultsSummaryManagerImpl.java:274) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) at java.lang.reflect.Method.invoke(Method.java:597) at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:304) at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:182) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:149) at com.atlassian.bamboo.security.acegi.intercept.aopalliance.AuthorityOverrideMethodSecurityInterceptor.invoke(AuthorityOverrideMethodSecurityInterceptor.java:30) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171) at com.atlassian.bamboo.security.acegi.intercept.aopalliance.AuthorityOverrideMethodSecurityInterceptor.invoke(AuthorityOverrideMethodSecurityInterceptor.java:30) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171) at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:106) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171) at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:106) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171) at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:204) at $Proxy23.countBuildResultsSummaries(Unknown Source) at com.atlassian.bamboo.configuration.DefaultSystemStatisticsBean.getNumberOfResults(DefaultSystemStatisticsBean.java:45) at com.atlassian.bamboo.configuration.DefaultSystemStatisticsBean.getApproximateIndexTime(DefaultSystemStatisticsBean.java:50) Caused by: net.sf.hibernate.QueryException: unexpected token: AND [ select count(*) from com.atlassian.bamboo.resultsummary.BuildResultsSummaryImpl b AND b.buildState != 'Pending' ] at net.sf.hibernate.hql.FromParser.token(FromParser.java:101) at net.sf.hibernate.hql.ClauseParser.token(ClauseParser.java:87) at net.sf.hibernate.hql.PreprocessingParser.token(PreprocessingParser.java:123) at net.sf.hibernate.hql.ParserHelper.parse(ParserHelper.java:29) at net.sf.hibernate.hql.QueryTranslator.compile(QueryTranslator.java:149) at net.sf.hibernate.hql.QueryTranslator.compile(QueryTranslator.java:138) at net.sf.hibernate.impl.SessionFactoryImpl.getQuery(SessionFactoryImpl.java:295) at net.sf.hibernate.impl.SessionImpl.getQueries(SessionImpl.java:1572) at net.sf.hibernate.impl.SessionImpl.find(SessionImpl.java:1543) at net.sf.hibernate.impl.QueryImpl.list(QueryImpl.java:49) at net.sf.hibernate.impl.AbstractQueryImpl.uniqueResult(AbstractQueryImpl.java:550) at com.atlassian.bamboo.resultsummary.BuildResultsSummaryHibernateDao$4.doInHibernate(BuildResultsSummaryHibernateDao.java:143) at org.springframework.orm.hibernate.HibernateTemplate.execute(HibernateTemplate.java:370) ... 24 more

    Write tip

    You have a different solution? A short tip here would help you and many other users who saw this issue last week.

    Users with the same issue

    You are the first who have seen this exception. Write a tip to help other users and build your expert profile.