issues when raising invoice

Submitted by Guest on Tue, 18/02/2020 - 08:45

General User's Discussion

Hello,

Got an issue when raising a invoice and adding the product, once the product is selcted the following error comes up but then still works

Failed to execute query: ArchetypeQuery[firstResult=0,maxResults=20,count=false,constraints=ShortNameConstraint[constraints={CollectionNodeConstraint[archetypeConstraint=ArchetypeConstraint[constraints={ObjectRefNodeConstraint[alias=<null>,nodeName=target,operator=EQ,parameters={product.medication:3319:98c13f06-f180-11e9-b8ca-93a7046cd39b}],OrConstraint[constraints={NodeConstraint[alias=<null>,nodeName=activeEndTime,operator=GTE,parameters={Tue Feb 18 00:00:00 AEDT 2020}],NodeConstraint[alias=<null>,nodeName=activeEndTime,operator=IS_NULL,parameters={}]}],NodeSortConstraint[alias=product,ascending=true,nodeName=activeEndTime]},alias=product,state=BOTH,primaryOnly=false]],NodeSortConstraint[alias=<null>,ascending=true,nodeName=name],NodeSortConstraint[alias=<null>,ascending=true,nodeName=id]},alias=b,state=ACTIVE,primaryOnly=false,shortNames={entity.productBatch}]].

Re: issues when raising invoice

Submitted by tanderson on Tue, 18/02/2020 - 09:16.

There should be more in the stack trace to indicate the cause of the problem. Can you post that as well?

Re: issues when raising invoice

Submitted by ones4tech (not verified) on Tue, 18/02/2020 - 17:57.

<error-report>
<version>2.1.2</version>
<revision>20191220-171642.dc0c3ca</revision>
<message>Failed to execute query: ArchetypeQuery[firstResult=0,maxResults=20,count=false,constraints=ShortNameConstraint[constraints={CollectionNodeConstraint[archetypeConstraint=ArchetypeConstraint[constraints={ObjectRefNodeConstraint[alias=<null>,nodeName=target,operator=EQ,parameters={product.medication:2423:608a71b3-1ebc-11e7-bdfe-af39bd4e36fe}],OrConstraint[constraints={NodeConstraint[alias=<null>,nodeName=activeEndTime,operator=GTE,parameters={Tue Feb 18 00:00:00 AEDT 2020}],NodeConstraint[alias=<null>,nodeName=activeEndTime,operator=IS_NULL,parameters={}]}],NodeSortConstraint[alias=product,ascending=true,nodeName=activeEndTime]},alias=product,state=BOTH,primaryOnly=false]],NodeSortConstraint[alias=<null>,ascending=true,nodeName=name],NodeSortConstraint[alias=<null>,ascending=true,nodeName=id]},alias=b,state=ACTIVE,primaryOnly=false,shortNames={entity.productBatch}]].</message>
<exception>
<type>org.openvpms.component.business.service.archetype.ArchetypeServiceException</type>
<message>Failed to execute query: ArchetypeQuery[firstResult=0,maxResults=20,count=false,constraints=ShortNameConstraint[constraints={CollectionNodeConstraint[archetypeConstraint=ArchetypeConstraint[constraints={ObjectRefNodeConstraint[alias=<null>,nodeName=target,operator=EQ,parameters={product.medication:2423:608a71b3-1ebc-11e7-bdfe-af39bd4e36fe}],OrConstraint[constraints={NodeConstraint[alias=<null>,nodeName=activeEndTime,operator=GTE,parameters={Tue Feb 18 00:00:00 AEDT 2020}],NodeConstraint[alias=<null>,nodeName=activeEndTime,operator=IS_NULL,parameters={}]}],NodeSortConstraint[alias=product,ascending=true,nodeName=activeEndTime]},alias=product,state=BOTH,primaryOnly=false]],NodeSortConstraint[alias=<null>,ascending=true,nodeName=name],NodeSortConstraint[alias=<null>,ascending=true,nodeName=id]},alias=b,state=ACTIVE,primaryOnly=false,shortNames={entity.productBatch}]].</message>
<stackTrace>
<trace>org.openvpms.component.business.service.archetype.ArchetypeService.get(ArchetypeService.java:382)</trace>
<trace>sun.reflect.GeneratedMethodAccessor170.invoke(Unknown Source)</trace>
<trace>sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)</trace>
<trace>java.lang.reflect.Method.invoke(Method.java:498)</trace>
<trace>org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:302)</trace>
<trace>org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:190)</trace>
<trace>org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:157)</trace>
<trace>org.springframework.security.access.intercept.aopalliance.MethodSecurityInterceptor.invoke(MethodSecurityInterceptor.java:68)</trace>
<trace>org.openvpms.component.business.service.security.OpenVPMSMethodSecurityInterceptor.invoke(OpenVPMSMethodSecurityInterceptor.java:50)</trace>
<trace>org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:179)</trace>
<trace>org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:207)</trace>
<trace>com.sun.proxy.$Proxy55.get(Unknown Source)</trace>
<trace>org.openvpms.component.business.service.archetype.DelegatingArchetypeService.get(DelegatingArchetypeService.java:301)</trace>
<trace>org.openvpms.web.component.im.query.DefaultQueryExecutor.query(DefaultQueryExecutor.java:51)</trace>
<trace>org.openvpms.web.component.im.query.AbstractArchetypeServiceResultSet.query(AbstractArchetypeServiceResultSet.java:265)</trace>
<trace>org.openvpms.web.component.im.query.AbstractCachingResultSet.query(AbstractCachingResultSet.java:186)</trace>
<trace>org.openvpms.web.component.im.query.AbstractCachingResultSet.get(AbstractCachingResultSet.java:163)</trace>
<trace>org.openvpms.web.component.im.query.AbstractResultSet.hasNext(AbstractResultSet.java:168)</trace>
<trace>org.openvpms.web.component.im.product.BatchReferenceEditor.updateBatches(BatchReferenceEditor.java:329)</trace>
<trace>org.openvpms.web.component.im.product.BatchReferenceEditor.setProduct(BatchReferenceEditor.java:148)</trace>
<trace>org.openvpms.web.component.im.product.BatchParticipationEditor.setProduct(BatchParticipationEditor.java:56)</trace>
<trace>org.openvpms.web.workspace.customer.charge.CustomerChargeActItemEditor.updateBatch(CustomerChargeActItemEditor.java:1453)</trace>
<trace>org.openvpms.web.workspace.customer.charge.CustomerChargeActItemEditor.productModified(CustomerChargeActItemEditor.java:874)</trace>
<trace>org.openvpms.web.component.im.edit.act.ActItemEditor.productModified(ActItemEditor.java:496)</trace>
<trace>org.openvpms.web.component.im.edit.act.ActItemEditor.productModified(ActItemEditor.java:476)</trace>
<trace>org.openvpms.web.component.im.edit.act.ActItemEditor$1.modified(ActItemEditor.java:161)</trace>
<trace>org.openvpms.web.component.property.ModifiableListeners.notifyListeners(ModifiableListeners.java:92)</trace>
<trace>org.openvpms.web.component.edit.Editors.onModified(Editors.java:412)</trace>
<trace>org.openvpms.web.component.property.ModifiableListeners.notifyListeners(ModifiableListeners.java:92)</trace>
<trace>org.openvpms.web.component.property.AbstractProperty.refresh(AbstractProperty.java:552)</trace>
<trace>org.openvpms.web.component.property.IMObjectProperty.setValue(IMObjectProperty.java:126)</trace>
<trace>org.openvpms.web.component.property.DelegatingProperty.setValue(DelegatingProperty.java:155)</trace>
<trace>org.openvpms.web.component.im.edit.AbstractIMObjectReferenceEditor.updateProperty(AbstractIMObjectReferenceEditor.java:278)</trace>
<trace>org.openvpms.web.component.im.edit.AbstractIMObjectReferenceEditor.updateProperty(AbstractIMObjectReferenceEditor.java:52)</trace>
<trace>org.openvpms.web.component.im.edit.AbstractSelectorPropertyEditor.updateProperty(AbstractSelectorPropertyEditor.java:235)</trace>
<trace>org.openvpms.web.component.im.edit.AbstractSelectorPropertyEditor.setObject(AbstractSelectorPropertyEditor.java:137)</trace>
<trace>org.openvpms.web.component.im.product.ProductReferenceEditor.setProduct(ProductReferenceEditor.java:205)</trace>
<trace>org.openvpms.web.component.im.product.ProductReferenceEditor.onSelected(ProductReferenceEditor.java:98)</trace>
<trace>org.openvpms.web.component.im.product.ProductReferenceEditor.onSelected(ProductReferenceEditor.java:62)</trace>
<trace>org.openvpms.web.component.im.edit.AbstractSelectorPropertyEditor.onSelected(AbstractSelectorPropertyEditor.java:205)</trace>
<trace>org.openvpms.web.component.im.edit.AbstractSelectorPropertyEditor$1.selected(AbstractSelectorPropertyEditor.java:98)</trace>
<trace>org.openvpms.web.component.im.select.AbstractQuerySelector.onSelected(AbstractQuerySelector.java:311)</trace>
<trace>org.openvpms.web.component.im.select.AbstractQuerySelector$4.onClose(AbstractQuerySelector.java:287)</trace>
<trace>org.openvpms.web.echo.event.WindowPaneListener.windowPaneClosing(WindowPaneListener.java:37)</trace>
<trace>nextapp.echo2.app.WindowPane.fireWindowClosing(WindowPane.java:154)</trace>
<trace>org.openvpms.web.echo.dialog.PopupWindow.fireWindowClosing(PopupWindow.java:229)</trace>
<trace>nextapp.echo2.app.WindowPane.userClose(WindowPane.java:795)</trace>
<trace>org.openvpms.web.echo.dialog.PopupDialog.userClose(PopupDialog.java:282)</trace>
<trace>org.openvpms.web.echo.dialog.PopupWindow.close(PopupWindow.java:158)</trace>
<trace>org.openvpms.web.echo.dialog.PopupDialog.close(PopupDialog.java:302)</trace>
<trace>org.openvpms.web.component.im.query.BrowserDialog.close(BrowserDialog.java:215)</trace>
<trace>org.openvpms.web.echo.dialog.PopupDialog.onOK(PopupDialog.java:353)</trace>
<trace>org.openvpms.web.component.im.query.BrowserDialog.onOK(BrowserDialog.java:269)</trace>
<trace>org.openvpms.web.component.im.query.BrowserDialog.onSelected(BrowserDialog.java:291)</trace>
<trace>org.openvpms.web.component.im.query.BrowserDialog$2.selected(BrowserDialog.java:252)</trace>
<trace>org.openvpms.web.component.im.query.AbstractBrowser.notifySelected(AbstractBrowser.java:109)</trace>
<trace>org.openvpms.web.component.im.query.AbstractTableBrowser.onSelect(AbstractTableBrowser.java:363)</trace>
<trace>org.openvpms.web.component.im.query.AbstractTableBrowser.access$000(AbstractTableBrowser.java:48)</trace>
<trace>org.openvpms.web.component.im.query.AbstractTableBrowser$1.onAction(AbstractTableBrowser.java:254)</trace>
<trace>org.openvpms.web.echo.event.ActionListener.actionPerformed(ActionListener.java:40)</trace>
<trace>nextapp.echo2.app.Table.fireActionEvent(Table.java:332)</trace>
<trace>nextapp.echo2.app.Table.processInput(Table.java:586)</trace>
<trace>org.openvpms.web.echo.table.KeyTable.processInput(KeyTable.java:131)</trace>
<trace>nextapp.echo2.app.update.ClientUpdateManager.process(ClientUpdateManager.java:116)</trace>
<trace>nextapp.echo2.app.update.UpdateManager.processClientUpdates(UpdateManager.java:89)</trace>
<trace>nextapp.echo2.webcontainer.ContainerSynchronizeService.renderUpdate(ContainerSynchronizeService.java:471)</trace>
<trace>nextapp.echo2.webrender.service.SynchronizeService.service(SynchronizeService.java:279)</trace>
<trace>nextapp.echo2.webrender.WebRenderServlet.process(WebRenderServlet.java:273)</trace>
<trace>org.openvpms.web.echo.servlet.SpringWebContainerServlet.processRequest(SpringWebContainerServlet.java:234)</trace>
<trace>org.openvpms.web.echo.servlet.SpringWebContainerServlet.process(SpringWebContainerServlet.java:173)</trace>
<trace>nextapp.echo2.webrender.WebRenderServlet.doPost(WebRenderServlet.java:189)</trace>
<trace>javax.servlet.http.HttpServlet.service(HttpServlet.java:650)</trace>
<trace>javax.servlet.http.HttpServlet.service(HttpServlet.java:731)</trace>
<trace>org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:303)</trace>
<trace>org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)</trace>
<trace>org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52)</trace>
<trace>org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241)</trace>
<trace>org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)</trace>
<trace>org.openvpms.web.echo.servlet.Log4JMDCUserFilter.doFilter(Log4JMDCUserFilter.java:58)</trace>
<trace>org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241)</trace>
<trace>org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)</trace>
<trace>org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:316)</trace>
<trace>org.springframework.security.web.access.intercept.FilterSecurityInterceptor.invoke(FilterSecurityInterceptor.java:126)</trace>
<trace>org.springframework.security.web.access.intercept.FilterSecurityInterceptor.doFilter(FilterSecurityInterceptor.java:90)</trace>
<trace>org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:330)</trace>
<trace>org.springframework.security.web.access.ExceptionTranslationFilter.doFilter(ExceptionTranslationFilter.java:114)</trace>
<trace>org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:330)</trace>
<trace>org.springframework.security.web.session.SessionManagementFilter.doFilter(SessionManagementFilter.java:122)</trace>
<trace>org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:330)</trace>
<trace>org.springframework.security.web.authentication.AnonymousAuthenticationFilter.doFilter(AnonymousAuthenticationFilter.java:111)</trace>
<trace>org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:330)</trace>
<trace>org.springframework.security.web.servletapi.SecurityContextHolderAwareRequestFilter.doFilter(SecurityContextHolderAwareRequestFilter.java:169)</trace>
<trace>org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:330)</trace>
<trace>org.springframework.security.web.savedrequest.RequestCacheAwareFilter.doFilter(RequestCacheAwareFilter.java:48)</trace>
<trace>org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:330)</trace>
<trace>org.springframework.security.web.authentication.AbstractAuthenticationProcessingFilter.doFilter(AbstractAuthenticationProcessingFilter.java:205)</trace>
<trace>org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:330)</trace>
<trace>org.springframework.security.web.header.HeaderWriterFilter.doFilterInternal(HeaderWriterFilter.java:64)</trace>
<trace>org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107)</trace>
<trace>org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:330)</trace>
<trace>org.springframework.security.web.context.request.async.WebAsyncManagerIntegrationFilter.doFilterInternal(WebAsyncManagerIntegrationFilter.java:53)</trace>
<trace>org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107)</trace>
<trace>org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:330)</trace>
<trace>org.springframework.security.web.context.SecurityContextPersistenceFilter.doFilter(SecurityContextPersistenceFilter.java:91)</trace>
<trace>org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:330)</trace>
<trace>org.springframework.security.web.FilterChainProxy.doFilterInternal(FilterChainProxy.java:213)</trace>
<trace>org.springframework.security.web.FilterChainProxy.doFilter(FilterChainProxy.java:176)</trace>
<trace>org.springframework.web.filter.DelegatingFilterProxy.invokeDelegate(DelegatingFilterProxy.java:346)</trace>
<trace>org.springframework.web.filter.DelegatingFilterProxy.doFilter(DelegatingFilterProxy.java:262)</trace>
<trace>org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241)</trace>
<trace>org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)</trace>
<trace>org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:221)</trace>
<trace>org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:122)</trace>
<trace>org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:505)</trace>
<trace>org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:169)</trace>
<trace>org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:103)</trace>
<trace>org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:956)</trace>
<trace>org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:116)</trace>
<trace>org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:436)</trace>
<trace>org.apache.coyote.http11.AbstractHttp11Processor.process(AbstractHttp11Processor.java:1078)</trace>
<trace>org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:625)</trace>
<trace>org.apache.tomcat.util.net.JIoEndpoint$SocketProcessor.run(JIoEndpoint.java:318)</trace>
<trace>java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)</trace>
<trace>java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)</trace>
<trace>org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)</trace>
<trace>java.lang.Thread.run(Thread.java:748)</trace>
</stackTrace>
<cause>
<type>org.openvpms.component.business.dao.im.common.IMObjectDAOException</type>
<message>Failed to execute the query: select distinct b from org.openvpms.component.business.dao.hibernate.im.entity.EntityDO as b inner join b.entityLinks as product where (b.archetypeId.shortName = :shortName0 and b.active = :active0 and (product.archetypeId.shortName = :shortName1 and product.target.id = :id0 and (product.activeEndTime >= :activeEndTime0 or product.activeEndTime is NULL))) order by product.activeEndTime asc, b.name asc, b.id asc.</message>
<stackTrace>
<trace>org.openvpms.component.business.dao.hibernate.im.IMObjectDAOHibernate$DefaultQueryDelegator.get(IMObjectDAOHibernate.java:1040)</trace>
<trace>org.openvpms.component.business.dao.hibernate.im.IMObjectDAOHibernate$DefaultQueryDelegator.get(IMObjectDAOHibernate.java:1023)</trace>
<trace>org.openvpms.component.business.dao.hibernate.im.IMObjectDAOHibernate$QueryDelegator.get(IMObjectDAOHibernate.java:984)</trace>
<trace>org.openvpms.component.business.dao.hibernate.im.IMObjectDAOHibernate.get(IMObjectDAOHibernate.java:225)</trace>
<trace>org.openvpms.component.business.dao.hibernate.im.IMObjectDAOHibernate$$FastClassBySpringCGLIB$$69c8dab2.invoke(<generated>)</trace>
<trace>org.springframework.cglib.proxy.MethodProxy.invoke(MethodProxy.java:204)</trace>
<trace>org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.invokeJoinpoint(CglibAopProxy.java:717)</trace>
<trace>org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:157)</trace>
<trace>org.springframework.transaction.interceptor.TransactionInterceptor$1.proceedWithInvocation(TransactionInterceptor.java:99)</trace>
<trace>org.springframework.transaction.interceptor.TransactionAspectSupport.invokeWithinTransaction(TransactionAspectSupport.java:281)</trace>
<trace>org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:96)</trace>
<trace>org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:179)</trace>
<trace>org.springframework.aop.framework.CglibAopProxy$DynamicAdvisedInterceptor.intercept(CglibAopProxy.java:653)</trace>
<trace>org.openvpms.component.business.dao.hibernate.im.IMObjectDAOHibernate$$EnhancerBySpringCGLIB$$979c0208.get(<generated>)</trace>
<trace>org.openvpms.component.business.service.archetype.ArchetypeService.get(ArchetypeService.java:379)</trace>
<trace>sun.reflect.GeneratedMethodAccessor170.invoke(Unknown Source)</trace>
<trace>sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)</trace>
<trace>java.lang.reflect.Method.invoke(Method.java:498)</trace>
<trace>org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:302)</trace>
<trace>org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:190)</trace>
<trace>org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:157)</trace>
<trace>org.springframework.security.access.intercept.aopalliance.MethodSecurityInterceptor.invoke(MethodSecurityInterceptor.java:68)</trace>
<trace>org.openvpms.component.business.service.security.OpenVPMSMethodSecurityInterceptor.invoke(OpenVPMSMethodSecurityInterceptor.java:50)</trace>
<trace>org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:179)</trace>
<trace>org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:207)</trace>
<trace>com.sun.proxy.$Proxy55.get(Unknown Source)</trace>
<trace>org.openvpms.component.business.service.archetype.DelegatingArchetypeService.get(DelegatingArchetypeService.java:301)</trace>
<trace>org.openvpms.web.component.im.query.DefaultQueryExecutor.query(DefaultQueryExecutor.java:51)</trace>
<trace>org.openvpms.web.component.im.query.AbstractArchetypeServiceResultSet.query(AbstractArchetypeServiceResultSet.java:265)</trace>
<trace>org.openvpms.web.component.im.query.AbstractCachingResultSet.query(AbstractCachingResultSet.java:186)</trace>
<trace>org.openvpms.web.component.im.query.AbstractCachingResultSet.get(AbstractCachingResultSet.java:163)</trace>
<trace>org.openvpms.web.component.im.query.AbstractResultSet.hasNext(AbstractResultSet.java:168)</trace>
<trace>org.openvpms.web.component.im.product.BatchReferenceEditor.updateBatches(BatchReferenceEditor.java:329)</trace>
<trace>org.openvpms.web.component.im.product.BatchReferenceEditor.setProduct(BatchReferenceEditor.java:148)</trace>
<trace>org.openvpms.web.component.im.product.BatchParticipationEditor.setProduct(BatchParticipationEditor.java:56)</trace>
<trace>org.openvpms.web.workspace.customer.charge.CustomerChargeActItemEditor.updateBatch(CustomerChargeActItemEditor.java:1453)</trace>
<trace>org.openvpms.web.workspace.customer.charge.CustomerChargeActItemEditor.productModified(CustomerChargeActItemEditor.java:874)</trace>
<trace>org.openvpms.web.component.im.edit.act.ActItemEditor.productModified(ActItemEditor.java:496)</trace>
<trace>org.openvpms.web.component.im.edit.act.ActItemEditor.productModified(ActItemEditor.java:476)</trace>
<trace>org.openvpms.web.component.im.edit.act.ActItemEditor$1.modified(ActItemEditor.java:161)</trace>
<trace>org.openvpms.web.component.property.ModifiableListeners.notifyListeners(ModifiableListeners.java:92)</trace>
<trace>org.openvpms.web.component.edit.Editors.onModified(Editors.java:412)</trace>
<trace>org.openvpms.web.component.property.ModifiableListeners.notifyListeners(ModifiableListeners.java:92)</trace>
<trace>org.openvpms.web.component.property.AbstractProperty.refresh(AbstractProperty.java:552)</trace>
<trace>org.openvpms.web.component.property.IMObjectProperty.setValue(IMObjectProperty.java:126)</trace>
<trace>org.openvpms.web.component.property.DelegatingProperty.setValue(DelegatingProperty.java:155)</trace>
<trace>org.openvpms.web.component.im.edit.AbstractIMObjectReferenceEditor.updateProperty(AbstractIMObjectReferenceEditor.java:278)</trace>
<trace>org.openvpms.web.component.im.edit.AbstractIMObjectReferenceEditor.updateProperty(AbstractIMObjectReferenceEditor.java:52)</trace>
<trace>org.openvpms.web.component.im.edit.AbstractSelectorPropertyEditor.updateProperty(AbstractSelectorPropertyEditor.java:235)</trace>
<trace>org.openvpms.web.component.im.edit.AbstractSelectorPropertyEditor.setObject(AbstractSelectorPropertyEditor.java:137)</trace>
<trace>org.openvpms.web.component.im.product.ProductReferenceEditor.setProduct(ProductReferenceEditor.java:205)</trace>
<trace>org.openvpms.web.component.im.product.ProductReferenceEditor.onSelected(ProductReferenceEditor.java:98)</trace>
<trace>org.openvpms.web.component.im.product.ProductReferenceEditor.onSelected(ProductReferenceEditor.java:62)</trace>
<trace>org.openvpms.web.component.im.edit.AbstractSelectorPropertyEditor.onSelected(AbstractSelectorPropertyEditor.java:205)</trace>
<trace>org.openvpms.web.component.im.edit.AbstractSelectorPropertyEditor$1.selected(AbstractSelectorPropertyEditor.java:98)</trace>
<trace>org.openvpms.web.component.im.select.AbstractQuerySelector.onSelected(AbstractQuerySelector.java:311)</trace>
<trace>org.openvpms.web.component.im.select.AbstractQuerySelector$4.onClose(AbstractQuerySelector.java:287)</trace>
<trace>org.openvpms.web.echo.event.WindowPaneListener.windowPaneClosing(WindowPaneListener.java:37)</trace>
<trace>nextapp.echo2.app.WindowPane.fireWindowClosing(WindowPane.java:154)</trace>
<trace>org.openvpms.web.echo.dialog.PopupWindow.fireWindowClosing(PopupWindow.java:229)</trace>
<trace>nextapp.echo2.app.WindowPane.userClose(WindowPane.java:795)</trace>
<trace>org.openvpms.web.echo.dialog.PopupDialog.userClose(PopupDialog.java:282)</trace>
<trace>org.openvpms.web.echo.dialog.PopupWindow.close(PopupWindow.java:158)</trace>
<trace>org.openvpms.web.echo.dialog.PopupDialog.close(PopupDialog.java:302)</trace>
<trace>org.openvpms.web.component.im.query.BrowserDialog.close(BrowserDialog.java:215)</trace>
<trace>org.openvpms.web.echo.dialog.PopupDialog.onOK(PopupDialog.java:353)</trace>
<trace>org.openvpms.web.component.im.query.BrowserDialog.onOK(BrowserDialog.java:269)</trace>
<trace>org.openvpms.web.component.im.query.BrowserDialog.onSelected(BrowserDialog.java:291)</trace>
<trace>org.openvpms.web.component.im.query.BrowserDialog$2.selected(BrowserDialog.java:252)</trace>
<trace>org.openvpms.web.component.im.query.AbstractBrowser.notifySelected(AbstractBrowser.java:109)</trace>
<trace>org.openvpms.web.component.im.query.AbstractTableBrowser.onSelect(AbstractTableBrowser.java:363)</trace>
<trace>org.openvpms.web.component.im.query.AbstractTableBrowser.access$000(AbstractTableBrowser.java:48)</trace>
<trace>org.openvpms.web.component.im.query.AbstractTableBrowser$1.onAction(AbstractTableBrowser.java:254)</trace>
<trace>org.openvpms.web.echo.event.ActionListener.actionPerformed(ActionListener.java:40)</trace>
<trace>nextapp.echo2.app.Table.fireActionEvent(Table.java:332)</trace>
<trace>nextapp.echo2.app.Table.processInput(Table.java:586)</trace>
<trace>org.openvpms.web.echo.table.KeyTable.processInput(KeyTable.java:131)</trace>
<trace>nextapp.echo2.app.update.ClientUpdateManager.process(ClientUpdateManager.java:116)</trace>
<trace>nextapp.echo2.app.update.UpdateManager.processClientUpdates(UpdateManager.java:89)</trace>
<trace>nextapp.echo2.webcontainer.ContainerSynchronizeService.renderUpdate(ContainerSynchronizeService.java:471)</trace>
<trace>nextapp.echo2.webrender.service.SynchronizeService.service(SynchronizeService.java:279)</trace>
<trace>nextapp.echo2.webrender.WebRenderServlet.process(WebRenderServlet.java:273)</trace>
<trace>org.openvpms.web.echo.servlet.SpringWebContainerServlet.processRequest(SpringWebContainerServlet.java:234)</trace>
<trace>org.openvpms.web.echo.servlet.SpringWebContainerServlet.process(SpringWebContainerServlet.java:173)</trace>
<trace>nextapp.echo2.webrender.WebRenderServlet.doPost(WebRenderServlet.java:189)</trace>
<trace>javax.servlet.http.HttpServlet.service(HttpServlet.java:650)</trace>
<trace>javax.servlet.http.HttpServlet.service(HttpServlet.java:731)</trace>
<trace>org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:303)</trace>
<trace>org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)</trace>
<trace>org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52)</trace>
<trace>org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241)</trace>
<trace>org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)</trace>
<trace>org.openvpms.web.echo.servlet.Log4JMDCUserFilter.doFilter(Log4JMDCUserFilter.java:58)</trace>
<trace>org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241)</trace>
<trace>org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)</trace>
<trace>org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:316)</trace>
<trace>org.springframework.security.web.access.intercept.FilterSecurityInterceptor.invoke(FilterSecurityInterceptor.java:126)</trace>
<trace>org.springframework.security.web.access.intercept.FilterSecurityInterceptor.doFilter(FilterSecurityInterceptor.java:90)</trace>
<trace>org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:330)</trace>
<trace>org.springframework.security.web.access.ExceptionTranslationFilter.doFilter(ExceptionTranslationFilter.java:114)</trace>
<trace>org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:330)</trace>
<trace>org.springframework.security.web.session.SessionManagementFilter.doFilter(SessionManagementFilter.java:122)</trace>
<trace>org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:330)</trace>
<trace>org.springframework.security.web.authentication.AnonymousAuthenticationFilter.doFilter(AnonymousAuthenticationFilter.java:111)</trace>
<trace>org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:330)</trace>
<trace>org.springframework.security.web.servletapi.SecurityContextHolderAwareRequestFilter.doFilter(SecurityContextHolderAwareRequestFilter.java:169)</trace>
<trace>org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:330)</trace>
<trace>org.springframework.security.web.savedrequest.RequestCacheAwareFilter.doFilter(RequestCacheAwareFilter.java:48)</trace>
<trace>org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:330)</trace>
<trace>org.springframework.security.web.authentication.AbstractAuthenticationProcessingFilter.doFilter(AbstractAuthenticationProcessingFilter.java:205)</trace>
<trace>org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:330)</trace>
<trace>org.springframework.security.web.header.HeaderWriterFilter.doFilterInternal(HeaderWriterFilter.java:64)</trace>
<trace>org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107)</trace>
<trace>org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:330)</trace>
<trace>org.springframework.security.web.context.request.async.WebAsyncManagerIntegrationFilter.doFilterInternal(WebAsyncManagerIntegrationFilter.java:53)</trace>
<trace>org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107)</trace>
<trace>org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:330)</trace>
<trace>org.springframework.security.web.context.SecurityContextPersistenceFilter.doFilter(SecurityContextPersistenceFilter.java:91)</trace>
<trace>org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:330)</trace>
<trace>org.springframework.security.web.FilterChainProxy.doFilterInternal(FilterChainProxy.java:213)</trace>
<trace>org.springframework.security.web.FilterChainProxy.doFilter(FilterChainProxy.java:176)</trace>
<trace>org.springframework.web.filter.DelegatingFilterProxy.invokeDelegate(DelegatingFilterProxy.java:346)</trace>
<trace>org.springframework.web.filter.DelegatingFilterProxy.doFilter(DelegatingFilterProxy.java:262)</trace>
<trace>org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241)</trace>
<trace>org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)</trace>
<trace>org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:221)</trace>
<trace>org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:122)</trace>
<trace>org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:505)</trace>
<trace>org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:169)</trace>
<trace>org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:103)</trace>
<trace>org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:956)</trace>
<trace>org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:116)</trace>
<trace>org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:436)</trace>
<trace>org.apache.coyote.http11.AbstractHttp11Processor.process(AbstractHttp11Processor.java:1078)</trace>
<trace>org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:625)</trace>
<trace>org.apache.tomcat.util.net.JIoEndpoint$SocketProcessor.run(JIoEndpoint.java:318)</trace>
<trace>java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)</trace>
<trace>java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)</trace>
<trace>org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)</trace>
<trace>java.lang.Thread.run(Thread.java:748)</trace>
</stackTrace>
<cause>
<type>javax.persistence.PersistenceException</type>
<message>org.hibernate.exception.GenericJDBCException: could not extract ResultSet</message>
<stackTrace>
<trace>org.hibernate.internal.ExceptionConverterImpl.convert(ExceptionConverterImpl.java:154)</trace>
<trace>org.hibernate.internal.ExceptionConverterImpl.convert(ExceptionConverterImpl.java:181)</trace>
<trace>org.hibernate.query.internal.AbstractProducedQuery.list(AbstractProducedQuery.java:1514)</trace>
<trace>org.openvpms.component.business.dao.hibernate.im.IMObjectDAOHibernate.executeQuery(IMObjectDAOHibernate.java:624)</trace>
<trace>org.openvpms.component.business.dao.hibernate.im.IMObjectDAOHibernate.access$400(IMObjectDAOHibernate.java:94)</trace>
<trace>org.openvpms.component.business.dao.hibernate.im.IMObjectDAOHibernate$DefaultQueryDelegator.get(IMObjectDAOHibernate.java:1037)</trace>
<trace>org.openvpms.component.business.dao.hibernate.im.IMObjectDAOHibernate$DefaultQueryDelegator.get(IMObjectDAOHibernate.java:1023)</trace>
<trace>org.openvpms.component.business.dao.hibernate.im.IMObjectDAOHibernate$QueryDelegator.get(IMObjectDAOHibernate.java:984)</trace>
<trace>org.openvpms.component.business.dao.hibernate.im.IMObjectDAOHibernate.get(IMObjectDAOHibernate.java:225)</trace>
<trace>org.openvpms.component.business.dao.hibernate.im.IMObjectDAOHibernate$$FastClassBySpringCGLIB$$69c8dab2.invoke(<generated>)</trace>
<trace>org.springframework.cglib.proxy.MethodProxy.invoke(MethodProxy.java:204)</trace>
<trace>org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.invokeJoinpoint(CglibAopProxy.java:717)</trace>
<trace>org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:157)</trace>
<trace>org.springframework.transaction.interceptor.TransactionInterceptor$1.proceedWithInvocation(TransactionInterceptor.java:99)</trace>
<trace>org.springframework.transaction.interceptor.TransactionAspectSupport.invokeWithinTransaction(TransactionAspectSupport.java:281)</trace>
<trace>org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:96)</trace>
<trace>org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:179)</trace>
<trace>org.springframework.aop.framework.CglibAopProxy$DynamicAdvisedInterceptor.intercept(CglibAopProxy.java:653)</trace>
<trace>org.openvpms.component.business.dao.hibernate.im.IMObjectDAOHibernate$$EnhancerBySpringCGLIB$$979c0208.get(<generated>)</trace>
<trace>org.openvpms.component.business.service.archetype.ArchetypeService.get(ArchetypeService.java:379)</trace>
<trace>sun.reflect.GeneratedMethodAccessor170.invoke(Unknown Source)</trace>
<trace>sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)</trace>
<trace>java.lang.reflect.Method.invoke(Method.java:498)</trace>
<trace>org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:302)</trace>
<trace>org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:190)</trace>
<trace>org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:157)</trace>
<trace>org.springframework.security.access.intercept.aopalliance.MethodSecurityInterceptor.invoke(MethodSecurityInterceptor.java:68)</trace>
<trace>org.openvpms.component.business.service.security.OpenVPMSMethodSecurityInterceptor.invoke(OpenVPMSMethodSecurityInterceptor.java:50)</trace>
<trace>org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:179)</trace>
<trace>org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:207)</trace>
<trace>com.sun.proxy.$Proxy55.get(Unknown Source)</trace>
<trace>org.openvpms.component.business.service.archetype.DelegatingArchetypeService.get(DelegatingArchetypeService.java:301)</trace>
<trace>org.openvpms.web.component.im.query.DefaultQueryExecutor.query(DefaultQueryExecutor.java:51)</trace>
<trace>org.openvpms.web.component.im.query.AbstractArchetypeServiceResultSet.query(AbstractArchetypeServiceResultSet.java:265)</trace>
<trace>org.openvpms.web.component.im.query.AbstractCachingResultSet.query(AbstractCachingResultSet.java:186)</trace>
<trace>org.openvpms.web.component.im.query.AbstractCachingResultSet.get(AbstractCachingResultSet.java:163)</trace>
<trace>org.openvpms.web.component.im.query.AbstractResultSet.hasNext(AbstractResultSet.java:168)</trace>
<trace>org.openvpms.web.component.im.product.BatchReferenceEditor.updateBatches(BatchReferenceEditor.java:329)</trace>
<trace>org.openvpms.web.component.im.product.BatchReferenceEditor.setProduct(BatchReferenceEditor.java:148)</trace>
<trace>org.openvpms.web.component.im.product.BatchParticipationEditor.setProduct(BatchParticipationEditor.java:56)</trace>
<trace>org.openvpms.web.workspace.customer.charge.CustomerChargeActItemEditor.updateBatch(CustomerChargeActItemEditor.java:1453)</trace>
<trace>org.openvpms.web.workspace.customer.charge.CustomerChargeActItemEditor.productModified(CustomerChargeActItemEditor.java:874)</trace>
<trace>org.openvpms.web.component.im.edit.act.ActItemEditor.productModified(ActItemEditor.java:496)</trace>
<trace>org.openvpms.web.component.im.edit.act.ActItemEditor.productModified(ActItemEditor.java:476)</trace>
<trace>org.openvpms.web.component.im.edit.act.ActItemEditor$1.modified(ActItemEditor.java:161)</trace>
<trace>org.openvpms.web.component.property.ModifiableListeners.notifyListeners(ModifiableListeners.java:92)</trace>
<trace>org.openvpms.web.component.edit.Editors.onModified(Editors.java:412)</trace>
<trace>org.openvpms.web.component.property.ModifiableListeners.notifyListeners(ModifiableListeners.java:92)</trace>
<trace>org.openvpms.web.component.property.AbstractProperty.refresh(AbstractProperty.java:552)</trace>
<trace>org.openvpms.web.component.property.IMObjectProperty.setValue(IMObjectProperty.java:126)</trace>
<trace>org.openvpms.web.component.property.DelegatingProperty.setValue(DelegatingProperty.java:155)</trace>
<trace>org.openvpms.web.component.im.edit.AbstractIMObjectReferenceEditor.updateProperty(AbstractIMObjectReferenceEditor.java:278)</trace>
<trace>org.openvpms.web.component.im.edit.AbstractIMObjectReferenceEditor.updateProperty(AbstractIMObjectReferenceEditor.java:52)</trace>
<trace>org.openvpms.web.component.im.edit.AbstractSelectorPropertyEditor.updateProperty(AbstractSelectorPropertyEditor.java:235)</trace>
<trace>org.openvpms.web.component.im.edit.AbstractSelectorPropertyEditor.setObject(AbstractSelectorPropertyEditor.java:137)</trace>
<trace>org.openvpms.web.component.im.product.ProductReferenceEditor.setProduct(ProductReferenceEditor.java:205)</trace>
<trace>org.openvpms.web.component.im.product.ProductReferenceEditor.onSelected(ProductReferenceEditor.java:98)</trace>
<trace>org.openvpms.web.component.im.product.ProductReferenceEditor.onSelected(ProductReferenceEditor.java:62)</trace>
<trace>org.openvpms.web.component.im.edit.AbstractSelectorPropertyEditor.onSelected(AbstractSelectorPropertyEditor.java:205)</trace>
<trace>org.openvpms.web.component.im.edit.AbstractSelectorPropertyEditor$1.selected(AbstractSelectorPropertyEditor.java:98)</trace>
<trace>org.openvpms.web.component.im.select.AbstractQuerySelector.onSelected(AbstractQuerySelector.java:311)</trace>
<trace>org.openvpms.web.component.im.select.AbstractQuerySelector$4.onClose(AbstractQuerySelector.java:287)</trace>
<trace>org.openvpms.web.echo.event.WindowPaneListener.windowPaneClosing(WindowPaneListener.java:37)</trace>
<trace>nextapp.echo2.app.WindowPane.fireWindowClosing(WindowPane.java:154)</trace>
<trace>org.openvpms.web.echo.dialog.PopupWindow.fireWindowClosing(PopupWindow.java:229)</trace>
<trace>nextapp.echo2.app.WindowPane.userClose(WindowPane.java:795)</trace>
<trace>org.openvpms.web.echo.dialog.PopupDialog.userClose(PopupDialog.java:282)</trace>
<trace>org.openvpms.web.echo.dialog.PopupWindow.close(PopupWindow.java:158)</trace>
<trace>org.openvpms.web.echo.dialog.PopupDialog.close(PopupDialog.java:302)</trace>
<trace>org.openvpms.web.component.im.query.BrowserDialog.close(BrowserDialog.java:215)</trace>
<trace>org.openvpms.web.echo.dialog.PopupDialog.onOK(PopupDialog.java:353)</trace>
<trace>org.openvpms.web.component.im.query.BrowserDialog.onOK(BrowserDialog.java:269)</trace>
<trace>org.openvpms.web.component.im.query.BrowserDialog.onSelected(BrowserDialog.java:291)</trace>
<trace>org.openvpms.web.component.im.query.BrowserDialog$2.selected(BrowserDialog.java:252)</trace>
<trace>org.openvpms.web.component.im.query.AbstractBrowser.notifySelected(AbstractBrowser.java:109)</trace>
<trace>org.openvpms.web.component.im.query.AbstractTableBrowser.onSelect(AbstractTableBrowser.java:363)</trace>
<trace>org.openvpms.web.component.im.query.AbstractTableBrowser.access$000(AbstractTableBrowser.java:48)</trace>
<trace>org.openvpms.web.component.im.query.AbstractTableBrowser$1.onAction(AbstractTableBrowser.java:254)</trace>
<trace>org.openvpms.web.echo.event.ActionListener.actionPerformed(ActionListener.java:40)</trace>
<trace>nextapp.echo2.app.Table.fireActionEvent(Table.java:332)</trace>
<trace>nextapp.echo2.app.Table.processInput(Table.java:586)</trace>
<trace>org.openvpms.web.echo.table.KeyTable.processInput(KeyTable.java:131)</trace>
<trace>nextapp.echo2.app.update.ClientUpdateManager.process(ClientUpdateManager.java:116)</trace>
<trace>nextapp.echo2.app.update.UpdateManager.processClientUpdates(UpdateManager.java:89)</trace>
<trace>nextapp.echo2.webcontainer.ContainerSynchronizeService.renderUpdate(ContainerSynchronizeService.java:471)</trace>
<trace>nextapp.echo2.webrender.service.SynchronizeService.service(SynchronizeService.java:279)</trace>
<trace>nextapp.echo2.webrender.WebRenderServlet.process(WebRenderServlet.java:273)</trace>
<trace>org.openvpms.web.echo.servlet.SpringWebContainerServlet.processRequest(SpringWebContainerServlet.java:234)</trace>
<trace>org.openvpms.web.echo.servlet.SpringWebContainerServlet.process(SpringWebContainerServlet.java:173)</trace>
<trace>nextapp.echo2.webrender.WebRenderServlet.doPost(WebRenderServlet.java:189)</trace>
<trace>javax.servlet.http.HttpServlet.service(HttpServlet.java:650)</trace>
<trace>javax.servlet.http.HttpServlet.service(HttpServlet.java:731)</trace>
<trace>org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:303)</trace>
<trace>org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)</trace>
<trace>org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52)</trace>
<trace>org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241)</trace>
<trace>org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)</trace>
<trace>org.openvpms.web.echo.servlet.Log4JMDCUserFilter.doFilter(Log4JMDCUserFilter.java:58)</trace>
<trace>org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241)</trace>
<trace>org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)</trace>
<trace>org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:316)</trace>
<trace>org.springframework.security.web.access.intercept.FilterSecurityInterceptor.invoke(FilterSecurityInterceptor.java:126)</trace>
<trace>org.springframework.security.web.access.intercept.FilterSecurityInterceptor.doFilter(FilterSecurityInterceptor.java:90)</trace>
<trace>org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:330)</trace>
<trace>org.springframework.security.web.access.ExceptionTranslationFilter.doFilter(ExceptionTranslationFilter.java:114)</trace>
<trace>org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:330)</trace>
<trace>org.springframework.security.web.session.SessionManagementFilter.doFilter(SessionManagementFilter.java:122)</trace>
<trace>org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:330)</trace>
<trace>org.springframework.security.web.authentication.AnonymousAuthenticationFilter.doFilter(AnonymousAuthenticationFilter.java:111)</trace>
<trace>org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:330)</trace>
<trace>org.springframework.security.web.servletapi.SecurityContextHolderAwareRequestFilter.doFilter(SecurityContextHolderAwareRequestFilter.java:169)</trace>
<trace>org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:330)</trace>
<trace>org.springframework.security.web.savedrequest.RequestCacheAwareFilter.doFilter(RequestCacheAwareFilter.java:48)</trace>
<trace>org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:330)</trace>
<trace>org.springframework.security.web.authentication.AbstractAuthenticationProcessingFilter.doFilter(AbstractAuthenticationProcessingFilter.java:205)</trace>
<trace>org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:330)</trace>
<trace>org.springframework.security.web.header.HeaderWriterFilter.doFilterInternal(HeaderWriterFilter.java:64)</trace>
<trace>org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107)</trace>
<trace>org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:330)</trace>
<trace>org.springframework.security.web.context.request.async.WebAsyncManagerIntegrationFilter.doFilterInternal(WebAsyncManagerIntegrationFilter.java:53)</trace>
<trace>org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107)</trace>
<trace>org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:330)</trace>
<trace>org.springframework.security.web.context.SecurityContextPersistenceFilter.doFilter(SecurityContextPersistenceFilter.java:91)</trace>
<trace>org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:330)</trace>
<trace>org.springframework.security.web.FilterChainProxy.doFilterInternal(FilterChainProxy.java:213)</trace>
<trace>org.springframework.security.web.FilterChainProxy.doFilter(FilterChainProxy.java:176)</trace>
<trace>org.springframework.web.filter.DelegatingFilterProxy.invokeDelegate(DelegatingFilterProxy.java:346)</trace>
<trace>org.springframework.web.filter.DelegatingFilterProxy.doFilter(DelegatingFilterProxy.java:262)</trace>
<trace>org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241)</trace>
<trace>org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)</trace>
<trace>org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:221)</trace>
<trace>org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:122)</trace>
<trace>org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:505)</trace>
<trace>org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:169)</trace>
<trace>org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:103)</trace>
<trace>org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:956)</trace>
<trace>org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:116)</trace>
<trace>org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:436)</trace>
<trace>org.apache.coyote.http11.AbstractHttp11Processor.process(AbstractHttp11Processor.java:1078)</trace>
<trace>org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:625)</trace>
<trace>org.apache.tomcat.util.net.JIoEndpoint$SocketProcessor.run(JIoEndpoint.java:318)</trace>
<trace>java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)</trace>
<trace>java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)</trace>
<trace>org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)</trace>
<trace>java.lang.Thread.run(Thread.java:748)</trace>
</stackTrace>
<cause>
<type>org.hibernate.exception.GenericJDBCException</type>
<message>could not extract ResultSet</message>
<stackTrace>
<trace>org.hibernate.exception.internal.StandardSQLExceptionConverter.convert(StandardSQLExceptionConverter.java:47)</trace>
<trace>org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(SqlExceptionHelper.java:113)</trace>
<trace>org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(SqlExceptionHelper.java:99)</trace>
<trace>org.hibernate.engine.jdbc.internal.ResultSetReturnImpl.extract(ResultSetReturnImpl.java:69)</trace>
<trace>org.hibernate.loader.Loader.getResultSet(Loader.java:2167)</trace>
<trace>org.hibernate.loader.Loader.executeQueryStatement(Loader.java:1930)</trace>
<trace>org.hibernate.loader.Loader.executeQueryStatement(Loader.java:1892)</trace>
<trace>org.hibernate.loader.Loader.doQuery(Loader.java:937)</trace>
<trace>org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:340)</trace>
<trace>org.hibernate.loader.Loader.doList(Loader.java:2689)</trace>
<trace>org.hibernate.loader.Loader.doList(Loader.java:2672)</trace>
<trace>org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2506)</trace>
<trace>org.hibernate.loader.Loader.list(Loader.java:2501)</trace>
<trace>org.hibernate.loader.hql.QueryLoader.list(QueryLoader.java:504)</trace>
<trace>org.hibernate.hql.internal.ast.QueryTranslatorImpl.list(QueryTranslatorImpl.java:395)</trace>
<trace>org.hibernate.engine.query.spi.HQLQueryPlan.performList(HQLQueryPlan.java:220)</trace>
<trace>org.hibernate.internal.SessionImpl.list(SessionImpl.java:1508)</trace>
<trace>org.hibernate.query.internal.AbstractProducedQuery.doList(AbstractProducedQuery.java:1537)</trace>
<trace>org.hibernate.query.internal.AbstractProducedQuery.list(AbstractProducedQuery.java:1505)</trace>
<trace>org.openvpms.component.business.dao.hibernate.im.IMObjectDAOHibernate.executeQuery(IMObjectDAOHibernate.java:624)</trace>
<trace>org.openvpms.component.business.dao.hibernate.im.IMObjectDAOHibernate.access$400(IMObjectDAOHibernate.java:94)</trace>
<trace>org.openvpms.component.business.dao.hibernate.im.IMObjectDAOHibernate$DefaultQueryDelegator.get(IMObjectDAOHibernate.java:1037)</trace>
<trace>org.openvpms.component.business.dao.hibernate.im.IMObjectDAOHibernate$DefaultQueryDelegator.get(IMObjectDAOHibernate.java:1023)</trace>
<trace>org.openvpms.component.business.dao.hibernate.im.IMObjectDAOHibernate$QueryDelegator.get(IMObjectDAOHibernate.java:984)</trace>
<trace>org.openvpms.component.business.dao.hibernate.im.IMObjectDAOHibernate.get(IMObjectDAOHibernate.java:225)</trace>
<trace>org.openvpms.component.business.dao.hibernate.im.IMObjectDAOHibernate$$FastClassBySpringCGLIB$$69c8dab2.invoke(<generated>)</trace>
<trace>org.springframework.cglib.proxy.MethodProxy.invoke(MethodProxy.java:204)</trace>
<trace>org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.invokeJoinpoint(CglibAopProxy.java:717)</trace>
<trace>org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:157)</trace>
<trace>org.springframework.transaction.interceptor.TransactionInterceptor$1.proceedWithInvocation(TransactionInterceptor.java:99)</trace>
<trace>org.springframework.transaction.interceptor.TransactionAspectSupport.invokeWithinTransaction(TransactionAspectSupport.java:281)</trace>
<trace>org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:96)</trace>
<trace>org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:179)</trace>
<trace>org.springframework.aop.framework.CglibAopProxy$DynamicAdvisedInterceptor.intercept(CglibAopProxy.java:653)</trace>
<trace>org.openvpms.component.business.dao.hibernate.im.IMObjectDAOHibernate$$EnhancerBySpringCGLIB$$979c0208.get(<generated>)</trace>
<trace>org.openvpms.component.business.service.archetype.ArchetypeService.get(ArchetypeService.java:379)</trace>
<trace>sun.reflect.GeneratedMethodAccessor170.invoke(Unknown Source)</trace>
<trace>sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)</trace>
<trace>java.lang.reflect.Method.invoke(Method.java:498)</trace>
<trace>org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:302)</trace>
<trace>org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:190)</trace>
<trace>org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:157)</trace>
<trace>org.springframework.security.access.intercept.aopalliance.MethodSecurityInterceptor.invoke(MethodSecurityInterceptor.java:68)</trace>
<trace>org.openvpms.component.business.service.security.OpenVPMSMethodSecurityInterceptor.invoke(OpenVPMSMethodSecurityInterceptor.java:50)</trace>
<trace>org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:179)</trace>
<trace>org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:207)</trace>
<trace>com.sun.proxy.$Proxy55.get(Unknown Source)</trace>
<trace>org.openvpms.component.business.service.archetype.DelegatingArchetypeService.get(DelegatingArchetypeService.java:301)</trace>
<trace>org.openvpms.web.component.im.query.DefaultQueryExecutor.query(DefaultQueryExecutor.java:51)</trace>
<trace>org.openvpms.web.component.im.query.AbstractArchetypeServiceResultSet.query(AbstractArchetypeServiceResultSet.java:265)</trace>
<trace>org.openvpms.web.component.im.query.AbstractCachingResultSet.query(AbstractCachingResultSet.java:186)</trace>
<trace>org.openvpms.web.component.im.query.AbstractCachingResultSet.get(AbstractCachingResultSet.java:163)</trace>
<trace>org.openvpms.web.component.im.query.AbstractResultSet.hasNext(AbstractResultSet.java:168)</trace>
<trace>org.openvpms.web.component.im.product.BatchReferenceEditor.updateBatches(BatchReferenceEditor.java:329)</trace>
<trace>org.openvpms.web.component.im.product.BatchReferenceEditor.setProduct(BatchReferenceEditor.java:148)</trace>
<trace>org.openvpms.web.component.im.product.BatchParticipationEditor.setProduct(BatchParticipationEditor.java:56)</trace>
<trace>org.openvpms.web.workspace.customer.charge.CustomerChargeActItemEditor.updateBatch(CustomerChargeActItemEditor.java:1453)</trace>
<trace>org.openvpms.web.workspace.customer.charge.CustomerChargeActItemEditor.productModified(CustomerChargeActItemEditor.java:874)</trace>
<trace>org.openvpms.web.component.im.edit.act.ActItemEditor.productModified(ActItemEditor.java:496)</trace>
<trace>org.openvpms.web.component.im.edit.act.ActItemEditor.productModified(ActItemEditor.java:476)</trace>
<trace>org.openvpms.web.component.im.edit.act.ActItemEditor$1.modified(ActItemEditor.java:161)</trace>
<trace>org.openvpms.web.component.property.ModifiableListeners.notifyListeners(ModifiableListeners.java:92)</trace>
<trace>org.openvpms.web.component.edit.Editors.onModified(Editors.java:412)</trace>
<trace>org.openvpms.web.component.property.ModifiableListeners.notifyListeners(ModifiableListeners.java:92)</trace>
<trace>org.openvpms.web.component.property.AbstractProperty.refresh(AbstractProperty.java:552)</trace>
<trace>org.openvpms.web.component.property.IMObjectProperty.setValue(IMObjectProperty.java:126)</trace>
<trace>org.openvpms.web.component.property.DelegatingProperty.setValue(DelegatingProperty.java:155)</trace>
<trace>org.openvpms.web.component.im.edit.AbstractIMObjectReferenceEditor.updateProperty(AbstractIMObjectReferenceEditor.java:278)</trace>
<trace>org.openvpms.web.component.im.edit.AbstractIMObjectReferenceEditor.updateProperty(AbstractIMObjectReferenceEditor.java:52)</trace>
<trace>org.openvpms.web.component.im.edit.AbstractSelectorPropertyEditor.updateProperty(AbstractSelectorPropertyEditor.java:235)</trace>
<trace>org.openvpms.web.component.im.edit.AbstractSelectorPropertyEditor.setObject(AbstractSelectorPropertyEditor.java:137)</trace>
<trace>org.openvpms.web.component.im.product.ProductReferenceEditor.setProduct(ProductReferenceEditor.java:205)</trace>
<trace>org.openvpms.web.component.im.product.ProductReferenceEditor.onSelected(ProductReferenceEditor.java:98)</trace>
<trace>org.openvpms.web.component.im.product.ProductReferenceEditor.onSelected(ProductReferenceEditor.java:62)</trace>
<trace>org.openvpms.web.component.im.edit.AbstractSelectorPropertyEditor.onSelected(AbstractSelectorPropertyEditor.java:205)</trace>
<trace>org.openvpms.web.component.im.edit.AbstractSelectorPropertyEditor$1.selected(AbstractSelectorPropertyEditor.java:98)</trace>
<trace>org.openvpms.web.component.im.select.AbstractQuerySelector.onSelected(AbstractQuerySelector.java:311)</trace>
<trace>org.openvpms.web.component.im.select.AbstractQuerySelector$4.onClose(AbstractQuerySelector.java:287)</trace>
<trace>org.openvpms.web.echo.event.WindowPaneListener.windowPaneClosing(WindowPaneListener.java:37)</trace>
<trace>nextapp.echo2.app.WindowPane.fireWindowClosing(WindowPane.java:154)</trace>
<trace>org.openvpms.web.echo.dialog.PopupWindow.fireWindowClosing(PopupWindow.java:229)</trace>
<trace>nextapp.echo2.app.WindowPane.userClose(WindowPane.java:795)</trace>
<trace>org.openvpms.web.echo.dialog.PopupDialog.userClose(PopupDialog.java:282)</trace>
<trace>org.openvpms.web.echo.dialog.PopupWindow.close(PopupWindow.java:158)</trace>
<trace>org.openvpms.web.echo.dialog.PopupDialog.close(PopupDialog.java:302)</trace>
<trace>org.openvpms.web.component.im.query.BrowserDialog.close(BrowserDialog.java:215)</trace>
<trace>org.openvpms.web.echo.dialog.PopupDialog.onOK(PopupDialog.java:353)</trace>
<trace>org.openvpms.web.component.im.query.BrowserDialog.onOK(BrowserDialog.java:269)</trace>
<trace>org.openvpms.web.component.im.query.BrowserDialog.onSelected(BrowserDialog.java:291)</trace>
<trace>org.openvpms.web.component.im.query.BrowserDialog$2.selected(BrowserDialog.java:252)</trace>
<trace>org.openvpms.web.component.im.query.AbstractBrowser.notifySelected(AbstractBrowser.java:109)</trace>
<trace>org.openvpms.web.component.im.query.AbstractTableBrowser.onSelect(AbstractTableBrowser.java:363)</trace>
<trace>org.openvpms.web.component.im.query.AbstractTableBrowser.access$000(AbstractTableBrowser.java:48)</trace>
<trace>org.openvpms.web.component.im.query.AbstractTableBrowser$1.onAction(AbstractTableBrowser.java:254)</trace>
<trace>org.openvpms.web.echo.event.ActionListener.actionPerformed(ActionListener.java:40)</trace>
<trace>nextapp.echo2.app.Table.fireActionEvent(Table.java:332)</trace>
<trace>nextapp.echo2.app.Table.processInput(Table.java:586)</trace>
<trace>org.openvpms.web.echo.table.KeyTable.processInput(KeyTable.java:131)</trace>
<trace>nextapp.echo2.app.update.ClientUpdateManager.process(ClientUpdateManager.java:116)</trace>
<trace>nextapp.echo2.app.update.UpdateManager.processClientUpdates(UpdateManager.java:89)</trace>
<trace>nextapp.echo2.webcontainer.ContainerSynchronizeService.renderUpdate(ContainerSynchronizeService.java:471)</trace>
<trace>nextapp.echo2.webrender.service.SynchronizeService.service(SynchronizeService.java:279)</trace>
<trace>nextapp.echo2.webrender.WebRenderServlet.process(WebRenderServlet.java:273)</trace>
<trace>org.openvpms.web.echo.servlet.SpringWebContainerServlet.processRequest(SpringWebContainerServlet.java:234)</trace>
<trace>org.openvpms.web.echo.servlet.SpringWebContainerServlet.process(SpringWebContainerServlet.java:173)</trace>
<trace>nextapp.echo2.webrender.WebRenderServlet.doPost(WebRenderServlet.java:189)</trace>
<trace>javax.servlet.http.HttpServlet.service(HttpServlet.java:650)</trace>
<trace>javax.servlet.http.HttpServlet.service(HttpServlet.java:731)</trace>
<trace>org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:303)</trace>
<trace>org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)</trace>
<trace>org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52)</trace>
<trace>org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241)</trace>
<trace>org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)</trace>
<trace>org.openvpms.web.echo.servlet.Log4JMDCUserFilter.doFilter(Log4JMDCUserFilter.java:58)</trace>
<trace>org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241)</trace>
<trace>org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)</trace>
<trace>org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:316)</trace>
<trace>org.springframework.security.web.access.intercept.FilterSecurityInterceptor.invoke(FilterSecurityInterceptor.java:126)</trace>
<trace>org.springframework.security.web.access.intercept.FilterSecurityInterceptor.doFilter(FilterSecurityInterceptor.java:90)</trace>
<trace>org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:330)</trace>
<trace>org.springframework.security.web.access.ExceptionTranslationFilter.doFilter(ExceptionTranslationFilter.java:114)</trace>
<trace>org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:330)</trace>
<trace>org.springframework.security.web.session.SessionManagementFilter.doFilter(SessionManagementFilter.java:122)</trace>
<trace>org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:330)</trace>
<trace>org.springframework.security.web.authentication.AnonymousAuthenticationFilter.doFilter(AnonymousAuthenticationFilter.java:111)</trace>
<trace>org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:330)</trace>
<trace>org.springframework.security.web.servletapi.SecurityContextHolderAwareRequestFilter.doFilter(SecurityContextHolderAwareRequestFilter.java:169)</trace>
<trace>org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:330)</trace>
<trace>org.springframework.security.web.savedrequest.RequestCacheAwareFilter.doFilter(RequestCacheAwareFilter.java:48)</trace>
<trace>org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:330)</trace>
<trace>org.springframework.security.web.authentication.AbstractAuthenticationProcessingFilter.doFilter(AbstractAuthenticationProcessingFilter.java:205)</trace>
<trace>org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:330)</trace>
<trace>org.springframework.security.web.header.HeaderWriterFilter.doFilterInternal(HeaderWriterFilter.java:64)</trace>
<trace>org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107)</trace>
<trace>org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:330)</trace>
<trace>org.springframework.security.web.context.request.async.WebAsyncManagerIntegrationFilter.doFilterInternal(WebAsyncManagerIntegrationFilter.java:53)</trace>
<trace>org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107)</trace>
<trace>org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:330)</trace>
<trace>org.springframework.security.web.context.SecurityContextPersistenceFilter.doFilter(SecurityContextPersistenceFilter.java:91)</trace>
<trace>org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:330)</trace>
<trace>org.springframework.security.web.FilterChainProxy.doFilterInternal(FilterChainProxy.java:213)</trace>
<trace>org.springframework.security.web.FilterChainProxy.doFilter(FilterChainProxy.java:176)</trace>
<trace>org.springframework.web.filter.DelegatingFilterProxy.invokeDelegate(DelegatingFilterProxy.java:346)</trace>
<trace>org.springframework.web.filter.DelegatingFilterProxy.doFilter(DelegatingFilterProxy.java:262)</trace>
<trace>org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241)</trace>
<trace>org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)</trace>
<trace>org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:221)</trace>
<trace>org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:122)</trace>
<trace>org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:505)</trace>
<trace>org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:169)</trace>
<trace>org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:103)</trace>
<trace>org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:956)</trace>
<trace>org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:116)</trace>
<trace>org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:436)</trace>
<trace>org.apache.coyote.http11.AbstractHttp11Processor.process(AbstractHttp11Processor.java:1078)</trace>
<trace>org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:625)</trace>
<trace>org.apache.tomcat.util.net.JIoEndpoint$SocketProcessor.run(JIoEndpoint.java:318)</trace>
<trace>java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)</trace>
<trace>java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)</trace>
<trace>org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)</trace>
<trace>java.lang.Thread.run(Thread.java:748)</trace>
</stackTrace>
<cause>
<type>java.sql.SQLException</type>
<message>Expression #1 of ORDER BY clause is not in SELECT list, references column 'openvpms.entitylink1_.active_end_time' which is not in SELECT list; this is incompatible with DISTINCT</message>
<stackTrace>
<trace>com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1056)</trace>
<trace>com.mysql.jdbc.SQLError.createSQLException(SQLError.java:957)</trace>
<trace>com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3376)</trace>
<trace>com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3308)</trace>
<trace>com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1837)</trace>
<trace>com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1961)</trace>
<trace>com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2543)</trace>
<trace>com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:1737)</trace>
<trace>com.mysql.jdbc.PreparedStatement.executeQuery(PreparedStatement.java:1888)</trace>
<trace>org.apache.commons.dbcp2.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:83)</trace>
<trace>org.apache.commons.dbcp2.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:83)</trace>
<trace>org.hibernate.engine.jdbc.internal.ResultSetReturnImpl.extract(ResultSetReturnImpl.java:60)</trace>
<trace>org.hibernate.loader.Loader.getResultSet(Loader.java:2167)</trace>
<trace>org.hibernate.loader.Loader.executeQueryStatement(Loader.java:1930)</trace>
<trace>org.hibernate.loader.Loader.executeQueryStatement(Loader.java:1892)</trace>
<trace>org.hibernate.loader.Loader.doQuery(Loader.java:937)</trace>
<trace>org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:340)</trace>
<trace>org.hibernate.loader.Loader.doList(Loader.java:2689)</trace>
<trace>org.hibernate.loader.Loader.doList(Loader.java:2672)</trace>
<trace>org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2506)</trace>
<trace>org.hibernate.loader.Loader.list(Loader.java:2501)</trace>
<trace>org.hibernate.loader.hql.QueryLoader.list(QueryLoader.java:504)</trace>
<trace>org.hibernate.hql.internal.ast.QueryTranslatorImpl.list(QueryTranslatorImpl.java:395)</trace>
<trace>org.hibernate.engine.query.spi.HQLQueryPlan.performList(HQLQueryPlan.java:220)</trace>
<trace>org.hibernate.internal.SessionImpl.list(SessionImpl.java:1508)</trace>
<trace>org.hibernate.query.internal.AbstractProducedQuery.doList(AbstractProducedQuery.java:1537)</trace>
<trace>org.hibernate.query.internal.AbstractProducedQuery.list(AbstractProducedQuery.java:1505)</trace>
<trace>org.openvpms.component.business.dao.hibernate.im.IMObjectDAOHibernate.executeQuery(IMObjectDAOHibernate.java:624)</trace>
<trace>org.openvpms.component.business.dao.hibernate.im.IMObjectDAOHibernate.access$400(IMObjectDAOHibernate.java:94)</trace>
<trace>org.openvpms.component.business.dao.hibernate.im.IMObjectDAOHibernate$DefaultQueryDelegator.get(IMObjectDAOHibernate.java:1037)</trace>
<trace>org.openvpms.component.business.dao.hibernate.im.IMObjectDAOHibernate$DefaultQueryDelegator.get(IMObjectDAOHibernate.java:1023)</trace>
<trace>org.openvpms.component.business.dao.hibernate.im.IMObjectDAOHibernate$QueryDelegator.get(IMObjectDAOHibernate.java:984)</trace>
<trace>org.openvpms.component.business.dao.hibernate.im.IMObjectDAOHibernate.get(IMObjectDAOHibernate.java:225)</trace>
<trace>org.openvpms.component.business.dao.hibernate.im.IMObjectDAOHibernate$$FastClassBySpringCGLIB$$69c8dab2.invoke(<generated>)</trace>
<trace>org.springframework.cglib.proxy.MethodProxy.invoke(MethodProxy.java:204)</trace>
<trace>org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.invokeJoinpoint(CglibAopProxy.java:717)</trace>
<trace>org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:157)</trace>
<trace>org.springframework.transaction.interceptor.TransactionInterceptor$1.proceedWithInvocation(TransactionInterceptor.java:99)</trace>
<trace>org.springframework.transaction.interceptor.TransactionAspectSupport.invokeWithinTransaction(TransactionAspectSupport.java:281)</trace>
<trace>org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:96)</trace>
<trace>org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:179)</trace>
<trace>org.springframework.aop.framework.CglibAopProxy$DynamicAdvisedInterceptor.intercept(CglibAopProxy.java:653)</trace>
<trace>org.openvpms.component.business.dao.hibernate.im.IMObjectDAOHibernate$$EnhancerBySpringCGLIB$$979c0208.get(<generated>)</trace>
<trace>org.openvpms.component.business.service.archetype.ArchetypeService.get(ArchetypeService.java:379)</trace>
<trace>sun.reflect.GeneratedMethodAccessor170.invoke(Unknown Source)</trace>
<trace>sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)</trace>
<trace>java.lang.reflect.Method.invoke(Method.java:498)</trace>
<trace>org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:302)</trace>
<trace>org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:190)</trace>
<trace>org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:157)</trace>
<trace>org.springframework.security.access.intercept.aopalliance.MethodSecurityInterceptor.invoke(MethodSecurityInterceptor.java:68)</trace>
<trace>org.openvpms.component.business.service.security.OpenVPMSMethodSecurityInterceptor.invoke(OpenVPMSMethodSecurityInterceptor.java:50)</trace>
<trace>org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:179)</trace>
<trace>org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:207)</trace>
<trace>com.sun.proxy.$Proxy55.get(Unknown Source)</trace>
<trace>org.openvpms.component.business.service.archetype.DelegatingArchetypeService.get(DelegatingArchetypeService.java:301)</trace>
<trace>org.openvpms.web.component.im.query.DefaultQueryExecutor.query(DefaultQueryExecutor.java:51)</trace>
<trace>org.openvpms.web.component.im.query.AbstractArchetypeServiceResultSet.query(AbstractArchetypeServiceResultSet.java:265)</trace>
<trace>org.openvpms.web.component.im.query.AbstractCachingResultSet.query(AbstractCachingResultSet.java:186)</trace>
<trace>org.openvpms.web.component.im.query.AbstractCachingResultSet.get(AbstractCachingResultSet.java:163)</trace>
<trace>org.openvpms.web.component.im.query.AbstractResultSet.hasNext(AbstractResultSet.java:168)</trace>
<trace>org.openvpms.web.component.im.product.BatchReferenceEditor.updateBatches(BatchReferenceEditor.java:329)</trace>
<trace>org.openvpms.web.component.im.product.BatchReferenceEditor.setProduct(BatchReferenceEditor.java:148)</trace>
<trace>org.openvpms.web.component.im.product.BatchParticipationEditor.setProduct(BatchParticipationEditor.java:56)</trace>
<trace>org.openvpms.web.workspace.customer.charge.CustomerChargeActItemEditor.updateBatch(CustomerChargeActItemEditor.java:1453)</trace>
<trace>org.openvpms.web.workspace.customer.charge.CustomerChargeActItemEditor.productModified(CustomerChargeActItemEditor.java:874)</trace>
<trace>org.openvpms.web.component.im.edit.act.ActItemEditor.productModified(ActItemEditor.java:496)</trace>
<trace>org.openvpms.web.component.im.edit.act.ActItemEditor.productModified(ActItemEditor.java:476)</trace>
<trace>org.openvpms.web.component.im.edit.act.ActItemEditor$1.modified(ActItemEditor.java:161)</trace>
<trace>org.openvpms.web.component.property.ModifiableListeners.notifyListeners(ModifiableListeners.java:92)</trace>
<trace>org.openvpms.web.component.edit.Editors.onModified(Editors.java:412)</trace>
<trace>org.openvpms.web.component.property.ModifiableListeners.notifyListeners(ModifiableListeners.java:92)</trace>
<trace>org.openvpms.web.component.property.AbstractProperty.refresh(AbstractProperty.java:552)</trace>
<trace>org.openvpms.web.component.property.IMObjectProperty.setValue(IMObjectProperty.java:126)</trace>
<trace>org.openvpms.web.component.property.DelegatingProperty.setValue(DelegatingProperty.java:155)</trace>
<trace>org.openvpms.web.component.im.edit.AbstractIMObjectReferenceEditor.updateProperty(AbstractIMObjectReferenceEditor.java:278)</trace>
<trace>org.openvpms.web.component.im.edit.AbstractIMObjectReferenceEditor.updateProperty(AbstractIMObjectReferenceEditor.java:52)</trace>
<trace>org.openvpms.web.component.im.edit.AbstractSelectorPropertyEditor.updateProperty(AbstractSelectorPropertyEditor.java:235)</trace>
<trace>org.openvpms.web.component.im.edit.AbstractSelectorPropertyEditor.setObject(AbstractSelectorPropertyEditor.java:137)</trace>
<trace>org.openvpms.web.component.im.product.ProductReferenceEditor.setProduct(ProductReferenceEditor.java:205)</trace>
<trace>org.openvpms.web.component.im.product.ProductReferenceEditor.onSelected(ProductReferenceEditor.java:98)</trace>
<trace>org.openvpms.web.component.im.product.ProductReferenceEditor.onSelected(ProductReferenceEditor.java:62)</trace>
<trace>org.openvpms.web.component.im.edit.AbstractSelectorPropertyEditor.onSelected(AbstractSelectorPropertyEditor.java:205)</trace>
<trace>org.openvpms.web.component.im.edit.AbstractSelectorPropertyEditor$1.selected(AbstractSelectorPropertyEditor.java:98)</trace>
<trace>org.openvpms.web.component.im.select.AbstractQuerySelector.onSelected(AbstractQuerySelector.java:311)</trace>
<trace>org.openvpms.web.component.im.select.AbstractQuerySelector$4.onClose(AbstractQuerySelector.java:287)</trace>
<trace>org.openvpms.web.echo.event.WindowPaneListener.windowPaneClosing(WindowPaneListener.java:37)</trace>
<trace>nextapp.echo2.app.WindowPane.fireWindowClosing(WindowPane.java:154)</trace>
<trace>org.openvpms.web.echo.dialog.PopupWindow.fireWindowClosing(PopupWindow.java:229)</trace>
<trace>nextapp.echo2.app.WindowPane.userClose(WindowPane.java:795)</trace>
<trace>org.openvpms.web.echo.dialog.PopupDialog.userClose(PopupDialog.java:282)</trace>
<trace>org.openvpms.web.echo.dialog.PopupWindow.close(PopupWindow.java:158)</trace>
<trace>org.openvpms.web.echo.dialog.PopupDialog.close(PopupDialog.java:302)</trace>
<trace>org.openvpms.web.component.im.query.BrowserDialog.close(BrowserDialog.java:215)</trace>
<trace>org.openvpms.web.echo.dialog.PopupDialog.onOK(PopupDialog.java:353)</trace>
<trace>org.openvpms.web.component.im.query.BrowserDialog.onOK(BrowserDialog.java:269)</trace>
<trace>org.openvpms.web.component.im.query.BrowserDialog.onSelected(BrowserDialog.java:291)</trace>
<trace>org.openvpms.web.component.im.query.BrowserDialog$2.selected(BrowserDialog.java:252)</trace>
<trace>org.openvpms.web.component.im.query.AbstractBrowser.notifySelected(AbstractBrowser.java:109)</trace>
<trace>org.openvpms.web.component.im.query.AbstractTableBrowser.onSelect(AbstractTableBrowser.java:363)</trace>
<trace>org.openvpms.web.component.im.query.AbstractTableBrowser.access$000(AbstractTableBrowser.java:48)</trace>
<trace>org.openvpms.web.component.im.query.AbstractTableBrowser$1.onAction(AbstractTableBrowser.java:254)</trace>
<trace>org.openvpms.web.echo.event.ActionListener.actionPerformed(ActionListener.java:40)</trace>
<trace>nextapp.echo2.app.Table.fireActionEvent(Table.java:332)</trace>
<trace>nextapp.echo2.app.Table.processInput(Table.java:586)</trace>
<trace>org.openvpms.web.echo.table.KeyTable.processInput(KeyTable.java:131)</trace>
<trace>nextapp.echo2.app.update.ClientUpdateManager.process(ClientUpdateManager.java:116)</trace>
<trace>nextapp.echo2.app.update.UpdateManager.processClientUpdates(UpdateManager.java:89)</trace>
<trace>nextapp.echo2.webcontainer.ContainerSynchronizeService.renderUpdate(ContainerSynchronizeService.java:471)</trace>
<trace>nextapp.echo2.webrender.service.SynchronizeService.service(SynchronizeService.java:279)</trace>
<trace>nextapp.echo2.webrender.WebRenderServlet.process(WebRenderServlet.java:273)</trace>
<trace>org.openvpms.web.echo.servlet.SpringWebContainerServlet.processRequest(SpringWebContainerServlet.java:234)</trace>
<trace>org.openvpms.web.echo.servlet.SpringWebContainerServlet.process(SpringWebContainerServlet.java:173)</trace>
<trace>nextapp.echo2.webrender.WebRenderServlet.doPost(WebRenderServlet.java:189)</trace>
<trace>javax.servlet.http.HttpServlet.service(HttpServlet.java:650)</trace>
<trace>javax.servlet.http.HttpServlet.service(HttpServlet.java:731)</trace>
<trace>org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:303)</trace>
<trace>org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)</trace>
<trace>org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52)</trace>
<trace>org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241)</trace>
<trace>org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)</trace>
<trace>org.openvpms.web.echo.servlet.Log4JMDCUserFilter.doFilter(Log4JMDCUserFilter.java:58)</trace>
<trace>org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241)</trace>
<trace>org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)</trace>
<trace>org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:316)</trace>
<trace>org.springframework.security.web.access.intercept.FilterSecurityInterceptor.invoke(FilterSecurityInterceptor.java:126)</trace>
<trace>org.springframework.security.web.access.intercept.FilterSecurityInterceptor.doFilter(FilterSecurityInterceptor.java:90)</trace>
<trace>org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:330)</trace>
<trace>org.springframework.security.web.access.ExceptionTranslationFilter.doFilter(ExceptionTranslationFilter.java:114)</trace>
<trace>org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:330)</trace>
<trace>org.springframework.security.web.session.SessionManagementFilter.doFilter(SessionManagementFilter.java:122)</trace>
<trace>org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:330)</trace>
<trace>org.springframework.security.web.authentication.AnonymousAuthenticationFilter.doFilter(AnonymousAuthenticationFilter.java:111)</trace>
<trace>org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:330)</trace>
<trace>org.springframework.security.web.servletapi.SecurityContextHolderAwareRequestFilter.doFilter(SecurityContextHolderAwareRequestFilter.java:169)</trace>
<trace>org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:330)</trace>
<trace>org.springframework.security.web.savedrequest.RequestCacheAwareFilter.doFilter(RequestCacheAwareFilter.java:48)</trace>
<trace>org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:330)</trace>
<trace>org.springframework.security.web.authentication.AbstractAuthenticationProcessingFilter.doFilter(AbstractAuthenticationProcessingFilter.java:205)</trace>
<trace>org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:330)</trace>
<trace>org.springframework.security.web.header.HeaderWriterFilter.doFilterInternal(HeaderWriterFilter.java:64)</trace>
<trace>org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107)</trace>
<trace>org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:330)</trace>
<trace>org.springframework.security.web.context.request.async.WebAsyncManagerIntegrationFilter.doFilterInternal(WebAsyncManagerIntegrationFilter.java:53)</trace>
<trace>org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107)</trace>
<trace>org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:330)</trace>
<trace>org.springframework.security.web.context.SecurityContextPersistenceFilter.doFilter(SecurityContextPersistenceFilter.java:91)</trace>
<trace>org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:330)</trace>
<trace>org.springframework.security.web.FilterChainProxy.doFilterInternal(FilterChainProxy.java:213)</trace>
<trace>org.springframework.security.web.FilterChainProxy.doFilter(FilterChainProxy.java:176)</trace>
<trace>org.springframework.web.filter.DelegatingFilterProxy.invokeDelegate(DelegatingFilterProxy.java:346)</trace>
<trace>org.springframework.web.filter.DelegatingFilterProxy.doFilter(DelegatingFilterProxy.java:262)</trace>
<trace>org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241)</trace>
<trace>org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)</trace>
<trace>org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:221)</trace>
<trace>org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:122)</trace>
<trace>org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:505)</trace>
<trace>org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:169)</trace>
<trace>org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:103)</trace>
<trace>org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:956)</trace>
<trace>org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:116)</trace>
<trace>org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:436)</trace>
<trace>org.apache.coyote.http11.AbstractHttp11Processor.process(AbstractHttp11Processor.java:1078)</trace>
<trace>org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:625)</trace>
<trace>org.apache.tomcat.util.net.JIoEndpoint$SocketProcessor.run(JIoEndpoint.java:318)</trace>
<trace>java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)</trace>
<trace>java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)</trace>
<trace>org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)</trace>
<trace>java.lang.Thread.run(Thread.java:748)</trace>
</stackTrace>
</cause>
</cause>
</cause>
</cause>
</exception>
<freeMemory>101193728</freeMemory>
<totalMemory>297762816</totalMemory>
<maxMemory>519438336</maxMemory>
<properties>
<property name="java.runtime.name" value="OpenJDK Runtime Environment"/>
<property name="sun.boot.library.path" value="/usr/lib/jvm/java-8-openjdk-amd64/jre/lib/amd64"/>
<property name="java.vm.version" value="25.242-b08"/>
<property name="shared.loader" value="${catalina.home}/shared/classes,${catalina.home}/shared/*.jar"/>
<property name="java.vm.vendor" value="Private Build"/>
<property name="java.vendor.url" value="http://java.oracle.com/"/>
<property name="path.separator" value=":"/>
<property name="java.vm.name" value="OpenJDK 64-Bit Server VM"/>
<property name="tomcat.util.buf.StringCache.byte.enabled" value="true"/>
<property name="file.encoding.pkg" value="sun.io"/>
<property name="java.util.logging.config.file" value="/var/lib/tomcat7/conf/logging.properties"/>
<property name="user.country" value="AU"/>
<property name="sun.java.launcher" value="SUN_STANDARD"/>
<property name="sun.os.patch.level" value="unknown"/>
<property name="java.vm.specification.name" value="Java Virtual Machine Specification"/>
<property name="user.dir" value="/var/lib/tomcat7"/>
<property name="java.runtime.version" value="1.8.0_242-8u242-b08-0ubuntu3~16.04-b08"/>
<property name="org.apache.catalina.startup.TldConfig.jarsToSkip" value="tomcat7-websocket.jar"/>
<property name="java.awt.graphicsenv" value="sun.awt.X11GraphicsEnvironment"/>
<property name="java.endorsed.dirs" value="/usr/share/tomcat7/endorsed"/>
<property name="os.arch" value="amd64"/>
<property name="java.io.tmpdir" value="/tmp/tomcat7-tomcat7-tmp"/>
<property name="line.separator" value="
"/>
<property name="java.vm.specification.vendor" value="Oracle Corporation"/>
<property name="java.util.logging.manager" value="org.apache.juli.ClassLoaderLogManager"/>
<property name="java.naming.factory.url.pkgs" value="org.apache.naming"/>
<property name="os.name" value="Linux"/>
<property name="sun.jnu.encoding" value="UTF-8"/>
<property name="org.apache.commons.jxpath.JXPathContextFactory" value="org.openvpms.component.system.common.jxpath.OpenVPMSContextFactoryReferenceImpl"/>
<property name="java.library.path" value="/usr/java/packages/lib/amd64:/usr/lib/x86_64-linux-gnu/jni:/lib/x86_64-linux-gnu:/usr/lib/x86_64-linux-gnu:/usr/lib/jni:/lib:/usr/lib"/>
<property name="tomcat.util.scan.DefaultJarScanner.jarsToSkip" value="bootstrap.jar,commons-daemon.jar,tomcat-juli.jar,annotations-api.jar,el-api.jar,jsp-api.jar,servlet-api.jar,websocket-api.jar,catalina.jar,catalina-ant.jar,catalina-ha.jar,catalina-tribes.jar,jasper.jar,jasper-el.jar,ecj-*.jar,tomcat-api.jar,tomcat-util.jar,tomcat-coyote.jar,tomcat-dbcp.jar,tomcat-jni.jar,tomcat-spdy.jar,tomcat-i18n-en.jar,tomcat-i18n-es.jar,tomcat-i18n-fr.jar,tomcat-i18n-ja.jar,tomcat-juli-adapters.jar,catalina-jmx-remote.jar,catalina-ws.jar,tomcat-jdbc.jar,tools.jar,commons-beanutils*.jar,commons-codec*.jar,commons-collections*.jar,commons-dbcp*.jar,commons-digester*.jar,commons-fileupload*.jar,commons-httpclient*.jar,commons-io*.jar,commons-lang*.jar,commons-logging*.jar,commons-math*.jar,commons-pool*.jar,jstl.jar,taglibs-standard-spec-*.jar,geronimo-spec-jaxrpc*.jar,wsdl4j*.jar,ant.jar,ant-junit*.jar,aspectj*.jar,jmx.jar,h2*.jar,hibernate*.jar,httpclient*.jar,jmx-tools.jar,jta*.jar,log4j.jar,log4j-1*.jar,mail*.jar,slf4j*.jar,xercesImpl.jar,xmlParserAPIs.jar,xml-apis.jar,junit.jar,junit-*.jar,hamcrest*.jar,org.hamcrest*.jar,ant-launcher.jar,cobertura-*.jar,asm-*.jar,dom4j-*.jar,icu4j-*.jar,jaxen-*.jar,jdom-*.jar,jetty-*.jar,oro-*.jar,servlet-api-*.jar,tagsoup-*.jar,xmlParserAPIs-*.jar,xom-*.jar"/>
<property name="java.specification.name" value="Java Platform API Specification"/>
<property name="java.class.version" value="52.0"/>
<property name="sun.management.compiler" value="HotSpot 64-Bit Tiered Compilers"/>
<property name="os.version" value="4.4.0-173-generic"/>
<property name="user.home" value="/usr/share/tomcat7"/>
<property name="org.apache.catalina.startup.ContextConfig.jarsToSkip" value=""/>
<property name="user.timezone" value="Australia/Melbourne"/>
<property name="catalina.useNaming" value="true"/>
<property name="java.awt.printerjob" value="sun.print.PSPrinterJob"/>
<property name="java.specification.version" value="1.8"/>
<property name="file.encoding" value="UTF-8"/>
<property name="catalina.home" value="/usr/share/tomcat7"/>
<property name="user.name" value="tomcat7"/>
<property name="java.class.path" value="/usr/share/tomcat7/bin/bootstrap.jar:/usr/share/tomcat7/bin/tomcat-juli.jar"/>
<property name="java.naming.factory.initial" value="org.apache.naming.java.javaURLContextFactory"/>
<property name="openvpms" value="/var/lib/tomcat7/webapps/openvpms/"/>
<property name="package.definition" value="sun.,java.,org.apache.catalina.,org.apache.coyote.,org.apache.jasper.,org.apache.naming.,org.apache.tomcat."/>
<property name="java.vm.specification.version" value="1.8"/>
<property name="sun.arch.data.model" value="64"/>
<property name="java.home" value="/usr/lib/jvm/java-8-openjdk-amd64/jre"/>
<property name="sun.java.command" value="org.apache.catalina.startup.Bootstrap start"/>
<property name="java.specification.vendor" value="Oracle Corporation"/>
<property name="user.language" value="en"/>
<property name="awt.toolkit" value="sun.awt.X11.XToolkit"/>
<property name="java.vm.info" value="mixed mode"/>
<property name="java.version" value="1.8.0_242"/>
<property name="java.ext.dirs" value="/usr/lib/jvm/java-8-openjdk-amd64/jre/lib/ext:/usr/java/packages/lib/ext"/>
<property name="sun.boot.class.path" value="/usr/lib/jvm/java-8-openjdk-amd64/jre/lib/resources.jar:/usr/lib/jvm/java-8-openjdk-amd64/jre/lib/rt.jar:/usr/lib/jvm/java-8-openjdk-amd64/jre/lib/sunrsasign.jar:/usr/lib/jvm/java-8-openjdk-amd64/jre/lib/jsse.jar:/usr/lib/jvm/java-8-openjdk-amd64/jre/lib/jce.jar:/usr/lib/jvm/java-8-openjdk-amd64/jre/lib/charsets.jar:/usr/lib/jvm/java-8-openjdk-amd64/jre/lib/jfr.jar:/usr/lib/jvm/java-8-openjdk-amd64/jre/classes"/>
<property name="java.vendor" value="Private Build"/>
<property name="java.awt.headless" value="true"/>
<property name="server.loader" value="${catalina.home}/server/classes,${catalina.home}/server/*.jar"/>
<property name="catalina.base" value="/var/lib/tomcat7"/>
<property name="file.separator" value="/"/>
<property name="java.vendor.url.bug" value="http://bugreport.sun.com/bugreport/"/>
<property name="common.loader" value="${catalina.base}/lib,${catalina.base}/lib/*.jar,${catalina.home}/lib,${catalina.home}/lib/*.jar,${catalina.home}/common/classes,${catalina.home}/common/*.jar"/>
<property name="sun.cpu.endian" value="little"/>
<property name="sun.io.unicode.encoding" value="UnicodeLittle"/>
<property name="sun.font.fontmanager" value="sun.awt.X11FontManager"/>
<property name="package.access" value="sun.,org.apache.catalina.,org.apache.coyote.,org.apache.jasper.,org.apache.naming.resources.,org.apache.tomcat."/>
<property name="sun.cpu.isalist" value=""/>
</properties>
</error-report>