Created attachment 414060 [details] logfile Description of problem: Upgrade JON 2.3.1 to JON 2.4 gives error after upgrade in server log. 2010-05-14 15:10:13,790 INFO [org.rhq.helpers.rtfilter.filter.RtFilter] Initialized response-time filter for webapp with context root 'installer'. 2010-05-14 15:11:07,695 ERROR [org.hibernate.hql.PARSER] <AST>:0:0: unexpected AST node: query 2010-05-14 15:11:07,695 ERROR [org.hibernate.hql.PARSER] <AST>:0:0: unexpected AST node: query 2010-05-14 15:11:07,696 ERROR [org.rhq.enterprise.server.scheduler.jobs.SavedSearchResultCountRecalculationJob] Could not calculate result count for SavedSearch[name=Downed Platforms, pattern='down platform'] 2010-05-14 15:11:07,698 ERROR [org.hibernate.hql.PARSER] <AST>:0:0: unexpected AST node: query 2010-05-14 15:11:07,698 ERROR [org.hibernate.hql.PARSER] <AST>:0:0: unexpected AST node: query 2010-05-14 15:11:07,699 ERROR [org.rhq.enterprise.server.scheduler.jobs.SavedSearchResultCountRecalculationJob] Could not calculate result count for SavedSearch[name=Downed Servers, pattern='down server'] 2010-05-14 15:11:26,594 INFO [net.hyperic.hq.common.shared.license.LicenseManager] [License owner=JBoss ON DEVELOPER ONLY!!! email=sales phone=404-467-8555 expiration=never platforms=unlimited serverIPs=any plugins=all support=3] 2010-05-14 15:12:07,568 ERROR [org.hibernate.hql.PARSER] <AST>:0:0: unexpected AST node: query 2010-05-14 15:12:07,570 ERROR [org.hibernate.hql.PARSER] <AST>:0:0: unexpected AST node: query 2010-05-14 15:12:07,571 ERROR [org.rhq.enterprise.server.scheduler.jobs.SavedSearchResultCountRecalculationJob] Could not calculate result count for SavedSearch[name=Downed Platforms, pattern='down platform'] 2010-05-14 15:12:07,577 ERROR [org.hibernate.hql.PARSER] <AST>:0:0: unexpected AST node: query 2010-05-14 15:12:07,577 ERROR [org.hibernate.hql.PARSER] <AST>:0:0: unexpected AST node: query 2010-05-14 15:12:07,577 ERROR [org.rhq.enterprise.server.scheduler.jobs.SavedSearchResultCountRecalculationJob] Could not calculate result count for SavedSearch[name=Downed Servers, pattern='down server'] 2010-05-14 15:13:07,567 ERROR [org.hibernate.hql.PARSER] <AST>:0:0: unexpected AST node: query 2010-05-14 15:13:07,568 ERROR [org.hibernate.hql.PARSER] <AST>:0:0: unexpected AST node: query 2010-05-14 15:13:07,569 ERROR [org.rhq.enterprise.server.scheduler.jobs.SavedSearchResultCountRecalculationJob] Could not calculate result count for SavedSearch[name=Downed Platforms, pattern='down platform'] 2010-05-14 15:13:07,575 ERROR [org.hibernate.hql.PARSER] <AST>:0:0: unexpected AST node: query 2010-05-14 15:13:07,575 ERROR [org.hibernate.hql.PARSER] <AST>:0:0: unexpected AST node: query 2010-05-14 15:13:07,576 ERROR [org.rhq.enterprise.server.scheduler.jobs.SavedSearchResultCountRecalculationJob] Could not calculate result count for SavedSearch[name=Downed Servers, pattern='down server'] 2010-05-14 15:14:07,557 ERROR [org.hibernate.hql.PARSER] <AST>:0:0: unexpected AST node: query 2010-05-14 15:14:07,557 ERROR [org.hibernate.hql.PARSER] <AST>:0:0: unexpected AST node: query 2010-05-14 15:14:07,558 ERROR [org.rhq.enterprise.server.scheduler.jobs.SavedSearchResultCountRecalculationJob] Could not calculate result count for SavedSearch[name=Downed Platforms, pattern='down platform'] 2010-05-14 15:14:07,560 ERROR [org.hibernate.hql.PARSER] <AST>:0:0: unexpected AST node: query 2010-05-14 15:14:07,560 ERROR [org.hibernate.hql.PARSER] <AST>:0:0: unexpected AST node: query 2010-05-14 15:14:07,561 ERROR [org.rhq.enterprise.server.scheduler.jobs.SavedSearchResultCountRecalculationJob] Could not calculate result count for SavedSearch[name=Downed Servers, pattern='down server'] Version-Release number of selected component (if applicable): JON build# 147 http://hudson-qe.rhq.rdu.redhat.com:8080/job/jon/147/ How reproducible: Always Steps to Reproduce: 1) Install JON 2.3.1 on Oracle 10g / Postgrace 8.4 2) Upgrade JON 2.3.1 to JON 2.4 (JON build #147) 3) Upload JON license (jon-license.xml) 4) Log in to JON 2.4 and goto dashboard 5) Refer JON server log Actual results: JON server log has error: ERROR [org.hibernate.hql.PARSER] <AST>:0:0: unexpected AST node: query Expected results: JON server log should not have error. Additional info:
commit cc8f2db67869ec32176c5160bc2adb195fdbb678 (April 27th, 2009) small fix to dbsetup script data. instead of using "down platform" use the advanced query form of "availability=down category=platform"
Verified on JON build #170 - Revision: 10621
Mass-closure of verified bugs against JON.