-----------------------------------------------------------------------------------------------------------------------------------

Key: OVPMS-1105 URL: https://openvpms.atlassian.net/browse/OVPMS-1105 Project: VPMS Web Application Issue Type: Bug Components: User Interface Affects Versions: 1.5 Reporter: Tim Anderson Assignee: Tony De Keizer

From a 1.5-beta-3 error report: {noformat} org.openvpms.component.business.service.archetype.ArchetypeServiceException: Failed to execute query: {0}. at org.openvpms.component.business.service.archetype.ArchetypeService.getObjects(ArchetypeService.java:396) at sun.reflect.GeneratedMethodAccessor196.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) at java.lang.reflect.Method.invoke(Method.java:616) at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:309) at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:196) at $Proxy4.getObjects(Unknown Source) at sun.reflect.GeneratedMethodAccessor196.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) at java.lang.reflect.Method.invoke(Method.java:616) at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:309) at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:183) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:150) at org.springframework.security.access.intercept.aopalliance.MethodSecurityInterceptor.invoke(MethodSecurityInterceptor.java:67) at org.openvpms.component.business.service.security.OpenVPMSMethodSecurityInterceptor.invoke(OpenVPMSMethodSecurityInterceptor.java:50) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172) at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:202) at $Proxy5.getObjects(Unknown Source) at org.openvpms.component.business.service.archetype.rule.ArchetypeRuleService.getObjects(ArchetypeRuleService.java:397) at org.openvpms.component.system.common.query.ObjectSetQueryIterator.getPage(ObjectSetQueryIterator.java:64) at org.openvpms.component.system.common.query.QueryIterator.hasNext(QueryIterator.java:81) at org.openvpms.web.component.im.view.act.ActRelationshipResultSet.sort(ActRelationshipResultSet.java:160) at org.openvpms.web.component.im.view.act.ActRelationshipResultSet.sort(ActRelationshipResultSet.java:117) at org.openvpms.web.component.im.table.PagedIMTableModel.sort(PagedIMTableModel.java:246) at org.openvpms.web.component.im.view.IMTableCollectionViewer.populateTable(IMTableCollectionViewer.java:284) at org.openvpms.web.component.im.view.IMTableCollectionViewer.doLayout(IMTableCollectionViewer.java:186) at org.openvpms.web.component.im.view.IMTableCollectionViewer.getComponent(IMTableCollectionViewer.java:145) at org.openvpms.web.component.im.view.AbstractReadOnlyComponentFactory.getCollectionViewer(AbstractReadOnlyComponentFactory.java:187) at org.openvpms.web.component.im.view.AbstractReadOnlyComponentFactory.create(AbstractReadOnlyComponentFactory.java:84) at org.openvpms.web.component.im.layout.AbstractLayoutStrategy.createComponent(AbstractLayoutStrategy.java:544) at org.openvpms.web.component.im.view.act.ActLayoutStrategy.createItems(ActLayoutStrategy.java:150) at org.openvpms.web.component.im.view.act.ActLayoutStrategy.createComponent(ActLayoutStrategy.java:132) at org.openvpms.web.component.im.layout.AbstractLayoutStrategy.doTabLayout(AbstractLayoutStrategy.java:421) at org.openvpms.web.component.im.layout.AbstractLayoutStrategy.doTabLayout(AbstractLayoutStrategy.java:392) at org.openvpms.web.component.im.layout.AbstractLayoutStrategy.doComplexLayout(AbstractLayoutStrategy.java:225) at org.openvpms.web.component.im.layout.AbstractLayoutStrategy.doLayout(AbstractLayoutStrategy.java:188) at org.openvpms.web.component.im.layout.AbstractLayoutStrategy.apply(AbstractLayoutStrategy.java:145) at org.openvpms.web.component.im.view.AbstractIMObjectView.createComponent(AbstractIMObjectView.java:161) at org.openvpms.web.component.im.view.AbstractIMObjectView.getComponent(AbstractIMObjectView.java:107) at org.openvpms.web.app.subsystem.AbstractViewCRUDWindow.setObject(AbstractViewCRUDWindow.java:73) at org.openvpms.web.app.subsystem.ActCRUDWindow.setObject(ActCRUDWindow.java:90) at org.openvpms.web.app.subsystem.ActCRUDWindow.setObject(ActCRUDWindow.java:54) at org.openvpms.web.app.subsystem.AbstractCRUDWindow.onSaved(AbstractCRUDWindow.java:485) at org.openvpms.web.app.subsystem.ActCRUDWindow.onSaved(ActCRUDWindow.java:214) at org.openvpms.web.app.subsystem.ActCRUDWindow.onSaved(ActCRUDWindow.java:54) at org.openvpms.web.app.subsystem.AbstractCRUDWindow.onEditCompleted(AbstractCRUDWindow.java:471) at org.openvpms.web.app.subsystem.AbstractCRUDWindow$7.onClose(AbstractCRUDWindow.java:421) at org.openvpms.web.component.event.WindowPaneListener.windowPaneClosing(WindowPaneListener.java:39) at nextapp.echo2.app.WindowPane.fireWindowClosing(WindowPane.java:154) at org.openvpms.web.component.dialog.PopupWindow.fireWindowClosing(PopupWindow.java:259) at nextapp.echo2.app.WindowPane.userClose(WindowPane.java:795) at org.openvpms.web.component.dialog.PopupDialog.userClose(PopupDialog.java:226) at org.openvpms.web.component.dialog.PopupWindow.close(PopupWindow.java:183) at org.openvpms.web.component.dialog.PopupDialog.close(PopupDialog.java:362) at org.openvpms.web.component.im.edit.AbstractEditDialog.onOK(AbstractEditDialog.java:195) at org.openvpms.web.component.dialog.PopupDialog.onButton(PopupDialog.java:249) at org.openvpms.web.component.dialog.PopupDialog$2.onAction(PopupDialog.java:375) at org.openvpms.web.component.event.ActionListener.actionPerformed(ActionListener.java:41) at nextapp.echo2.app.button.AbstractButton.fireActionPerformed(AbstractButton.java:135) at echopointng.ButtonEx$1.actionPerformed(ButtonEx.java:120) at nextapp.echo2.app.button.DefaultButtonModel.fireActionPerformed(DefaultButtonModel.java:70) at echopointng.model.DefaultButtonModelEx.doAction(DefaultButtonModelEx.java:51) at echopointng.ButtonEx.processInput(ButtonEx.java:202) at nextapp.echo2.app.update.ClientUpdateManager.process(ClientUpdateManager.java:116) at nextapp.echo2.app.update.UpdateManager.processClientUpdates(UpdateManager.java:89) at nextapp.echo2.webcontainer.ContainerSynchronizeService.renderUpdate(ContainerSynchronizeService.java:471) at nextapp.echo2.webrender.service.SynchronizeService.service(SynchronizeService.java:279) at nextapp.echo2.webrender.WebRenderServlet.process(WebRenderServlet.java:273) at org.openvpms.web.servlet.SpringWebContainerServlet.process(SpringWebContainerServlet.java:148) at nextapp.echo2.webrender.WebRenderServlet.doPost(WebRenderServlet.java:189) at javax.servlet.http.HttpServlet.service(HttpServlet.java:637) at javax.servlet.http.HttpServlet.service(HttpServlet.java:717) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:343) at org.springframework.security.web.access.intercept.FilterSecurityInterceptor.invoke(FilterSecurityInterceptor.java:109) at org.springframework.security.web.access.intercept.FilterSecurityInterceptor.doFilter(FilterSecurityInterceptor.java:83) at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:355) at org.springframework.security.web.authentication.AnonymousAuthenticationFilter.doFilter(AnonymousAuthenticationFilter.java:78) at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:355) at org.springframework.security.web.authentication.AbstractAuthenticationProcessingFilter.doFilter(AbstractAuthenticationProcessingFilter.java:187) at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:355) at org.springframework.security.web.access.ExceptionTranslationFilter.doFilter(ExceptionTranslationFilter.java:97) at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:355) at org.springframework.security.web.context.SecurityContextPersistenceFilter.doFilter(SecurityContextPersistenceFilter.java:79) at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:355) at org.springframework.security.web.FilterChainProxy.doFilter(FilterChainProxy.java:149) at org.springframework.web.filter.DelegatingFilterProxy.invokeDelegate(DelegatingFilterProxy.java:237) at org.springframework.web.filter.DelegatingFilterProxy.doFilter(DelegatingFilterProxy.java:167) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109) at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:298) at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:857) at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:588) at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:489) at java.lang.Thread.run(Thread.java:636) Caused by: org.openvpms.component.business.dao.im.common.IMObjectDAOException: Failed to execute the query: select rel.id from org.openvpms.component.business.dao.hibernate.im.act.ActRelationshipDO as rel, org.openvpms.component.business.dao.hibernate.im.act.ActDO as source, org.openvpms.component.business.dao.hibernate.im.act.ActDO as target where (rel.archetypeId.shortName = :shortName0 and (source.archetypeId.shortName = :shortName1 and source.id = :id0) and target.archetypeId.shortName = :shortName2 and rel.source.id = source.id and rel.target.id = target.id) order by target.notes asc. at org.openvpms.component.business.dao.hibernate.im.IMObjectDAOHibernate.get(IMObjectDAOHibernate.java:303) at org.openvpms.component.business.dao.hibernate.im.IMObjectDAOHibernate$DefaultQueryDelegator.get(IMObjectDAOHibernate.java:1195) at org.openvpms.component.business.dao.hibernate.im.IMObjectDAOHibernate$DefaultQueryDelegator.getObjects(IMObjectDAOHibernate.java:1178) at org.openvpms.component.business.dao.hibernate.im.IMObjectDAOHibernate.getObjects(IMObjectDAOHibernate.java:262) at org.openvpms.component.business.service.archetype.ArchetypeService.getObjects(ArchetypeService.java:394) ... 100 more Caused by: org.springframework.orm.hibernate3.HibernateQueryException: could not resolve property: notes of: org.openvpms.component.business.dao.hibernate.im.act.ActDOImpl [select rel.id from org.openvpms.component.business.dao.hibernate.im.act.ActRelationshipDOImpl as rel, org.openvpms.component.business.dao.hibernate.im.act.ActDOImpl as source, org.openvpms.component.business.dao.hibernate.im.act.ActDOImpl as target where (rel.archetypeId.shortName = :shortName0 and (source.archetypeId.shortName = :shortName1 and source.id = :id0) and target.archetypeId.shortName = :shortName2 and rel.source.id = source.id and rel.target.id = target.id) order by target.notes asc]; nested exception is org.hibernate.QueryException: could not resolve property: notes of: org.openvpms.component.business.dao.hibernate.im.act.ActDOImpl [select rel.id from org.openvpms.component.business.dao.hibernate.im.act.ActRelationshipDOImpl as rel, org.openvpms.component.business.dao.hibernate.im.act.ActDOImpl as source, org.openvpms.component.business.dao.hibernate.im.act.ActDOImpl as target where (rel.archetypeId.shortName = :shortName0 and (source.archetypeId.shortName = :shortName1 and source.id = :id0) and target.archetypeId.shortName = :shortName2 and rel.source.id = source.id and rel.target.id = target.id) order by target.notes asc] at org.springframework.orm.hibernate3.SessionFactoryUtils.convertHibernateAccessException(SessionFactoryUtils.java:660) at org.springframework.orm.hibernate3.HibernateAccessor.convertHibernateAccessException(HibernateAccessor.java:412) at org.springframework.orm.hibernate3.HibernateTemplate.doExecute(HibernateTemplate.java:411) at org.springframework.orm.hibernate3.HibernateTemplate.execute(HibernateTemplate.java:339) at org.openvpms.component.business.dao.hibernate.im.IMObjectDAOHibernate.execute(IMObjectDAOHibernate.java:1115) at org.openvpms.component.business.dao.hibernate.im.IMObjectDAOHibernate.executeQuery(IMObjectDAOHibernate.java:609) at org.openvpms.component.business.dao.hibernate.im.IMObjectDAOHibernate.get(IMObjectDAOHibernate.java:299) ... 104 more Caused by: org.hibernate.QueryException: could not resolve property: notes of: org.openvpms.component.business.dao.hibernate.im.act.ActDOImpl [select rel.id from org.openvpms.component.business.dao.hibernate.im.act.ActRelationshipDOImpl as rel, org.openvpms.component.business.dao.hibernate.im.act.ActDOImpl as source, org.openvpms.component.business.dao.hibernate.im.act.ActDOImpl as target where (rel.archetypeId.shortName = :shortName0 and (source.archetypeId.shortName = :shortName1 and source.id = :id0) and target.archetypeId.shortName = :shortName2 and rel.source.id = source.id and rel.target.id = target.id) order by target.notes asc] at org.hibernate.persister.entity.AbstractPropertyMapping.propertyException(AbstractPropertyMapping.java:67) at org.hibernate.persister.entity.AbstractPropertyMapping.toType(AbstractPropertyMapping.java:61) at org.hibernate.persister.entity.AbstractEntityPersister.toType(AbstractEntityPersister.java:1375) at org.hibernate.hql.ast.tree.FromElementType.getPropertyType(FromElementType.java:304) at org.hibernate.hql.ast.tree.FromElement.getPropertyType(FromElement.java:410) at org.hibernate.hql.ast.tree.DotNode.getDataType(DotNode.java:617) at org.hibernate.hql.ast.tree.DotNode.prepareLhs(DotNode.java:263) at org.hibernate.hql.ast.tree.DotNode.resolve(DotNode.java:210) at org.hibernate.hql.ast.tree.FromReferenceNode.resolve(FromReferenceNode.java:117) at org.hibernate.hql.ast.tree.FromReferenceNode.resolve(FromReferenceNode.java:113) at org.hibernate.hql.ast.HqlSqlWalker.resolve(HqlSqlWalker.java:854) at org.hibernate.hql.antlr.HqlSqlBaseWalker.expr(HqlSqlBaseWalker.java:1293) at org.hibernate.hql.antlr.HqlSqlBaseWalker.orderExprs(HqlSqlBaseWalker.java:1642) at org.hibernate.hql.antlr.HqlSqlBaseWalker.orderClause(HqlSqlBaseWalker.java:1613) at org.hibernate.hql.antlr.HqlSqlBaseWalker.query(HqlSqlBaseWalker.java:649) at org.hibernate.hql.antlr.HqlSqlBaseWalker.selectStatement(HqlSqlBaseWalker.java:288) at org.hibernate.hql.antlr.HqlSqlBaseWalker.statement(HqlSqlBaseWalker.java:231) at org.hibernate.hql.ast.QueryTranslatorImpl.analyze(QueryTranslatorImpl.java:254) at org.hibernate.hql.ast.QueryTranslatorImpl.doCompile(QueryTranslatorImpl.java:185) at org.hibernate.hql.ast.QueryTranslatorImpl.compile(QueryTranslatorImpl.java:136) at org.hibernate.engine.query.HQLQueryPlan.(HQLQueryPlan.java:101) at org.hibernate.engine.query.HQLQueryPlan.(HQLQueryPlan.java:80) at org.hibernate.engine.query.QueryPlanCache.getHQLQueryPlan(QueryPlanCache.java:94) 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:1651) at org.openvpms.component.business.dao.hibernate.im.IMObjectDAOHibernate$6.doInHibernate(IMObjectDAOHibernate.java:624) at org.springframework.orm.hibernate3.HibernateTemplate.doExecute(HibernateTemplate.java:406) ... 108 more {noformat}

-- This message is automatically generated by JIRA. If you think it was sent incorrectly, please contact your JIRA administrators: https://openvpms.atlassian.net/secure/ContactAdministrators!default.jspa For more information on JIRA, see: http://www.atlassian.com/software/jira

_______________________________________________ OpenVPMS Developers Mailing List developers@lists.openvpms.org To unsubscribe or change your subscription visit: http://lists.openvpms.org/listinfo/developers Posts from this mailing list can be viewed online and replied to in the OpenVPMS Developer's forum- http://tinyurl.com/openvdf