Home › Forums › Developers › General developer's discussion ›

1.7 5709 Error on ESCI order submission.

Submitted by Ben_Charlton on Tue, 21/01/2014 - 09:56
in

Submitted an order to our supplier this AM...Order generated fine, when we sent the order it appeared to work and then we recieved

null: HTTP/1.1 200 OK
Content-type: text/xml; charset=utf-8
Content-length: 248
Server: Microsoft-IIS/7.0
X-powered-by: ASP.NET
X-frame-options: SAMEORIGIN
Date: Mon, 20 Jan 2014 23:48:35 GMT
<s:Envelope xmlns:s="http://schemas.xmlsoap.org/soap/envelope/"><s:Body xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema"><submitOrderResponse xmlns="http://openvpms.org/esci"/></s:Body></s:Envelope>--------------------
[ERROR,ErrorHelper,http-bio-8080-exec-17] Failed to execute query: {0}.
[ERROR,DialogErrorHandler,http-bio-8080-exec-17] Failed to execute query: {0}.
 
We confirmed our order was reciever by the supplier.
 
I have the order and previous http requests available in logs.
 
Sincerely 
Ben
‹ 1.7 5708 Check-in is not one transaction 1.7 5717 Product Maintenance Access ›

Comment viewing options

Select your preferred way to display the comments and click "Save settings" to activate your changes.

Re: 1.7 5709 Error on ESCI order submission.

Submitted by tanderson on Tue, 21/01/2014 - 15:11.

Whats the stack trace for those errors in openvpms-full.log?

Re: 1.7 5709 Error on ESCI order submission.

Submitted by Ben_Charlton on Wed, 22/01/2014 - 10:38.

Logs to follow for those errors

Looks like a missing archetype



	21 Jan 2014 09:48:44,265 ERROR ErrorHelper,http-bio-8080-exec-17:147 - Failed to execute query: {0}.


org.openvpms.component.business.service.archetype.ArchetypeServiceException: Failed to execute query: {0}.

at org.openvpms.component.business.service.archetype.ArchetypeService.getObjects(ArchetypeService.java:394)

at sun.reflect.GeneratedMethodAccessor184.invoke(Unknown Source)

at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)

at java.lang.reflect.Method.invoke(Unknown Source)

at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:309)

at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:196)

at com.sun.proxy.$Proxy4.getObjects(Unknown Source)

at sun.reflect.GeneratedMethodAccessor184.invoke(Unknown Source)

at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)

at java.lang.reflect.Method.invoke(Unknown Source)

at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:309)

at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:183)

at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:150)

at org.springframework.security.access.intercept.aopalliance.MethodSecurityInterceptor.invoke(MethodSecurityInterceptor.java:67)

at org.openvpms.component.business.service.security.OpenVPMSMethodSecurityInterceptor.invoke(OpenVPMSMethodSecurityInterceptor.java:50)

at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)

at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:202)

at com.sun.proxy.$Proxy5.getObjects(Unknown Source)

at org.openvpms.component.business.service.archetype.rule.ArchetypeRuleService.getObjects(ArchetypeRuleService.java:397)

at org.openvpms.component.system.common.query.ObjectSetQueryIterator.getPage(ObjectSetQueryIterator.java:64)

at org.openvpms.component.system.common.query.QueryIterator.hasNext(QueryIterator.java:81)

at org.openvpms.web.workspace.supplier.order.ESCISupplierCRUDWindow.getESCIJobName(ESCISupplierCRUDWindow.java:130)

at org.openvpms.web.workspace.supplier.order.ESCISupplierCRUDWindow.scheduleCheckInbox(ESCISupplierCRUDWindow.java:101)

at org.openvpms.web.workspace.supplier.order.OrderCRUDWindow.onPosted(OrderCRUDWindow.java:191)

at org.openvpms.web.workspace.supplier.order.OrderCRUDWindow.onPosted(OrderCRUDWindow.java:58)

at org.openvpms.web.component.workspace.ActCRUDWindow$1.onOK(ActCRUDWindow.java:153)

at org.openvpms.web.echo.dialog.PopupDialogListener.onAction(PopupDialogListener.java:108)

at org.openvpms.web.echo.dialog.PopupDialogListener.onClose(PopupDialogListener.java:40)

at org.openvpms.web.echo.event.WindowPaneListener.windowPaneClosing(WindowPaneListener.java:37)

at nextapp.echo2.app.WindowPane.fireWindowClosing(WindowPane.java:154)

at org.openvpms.web.echo.dialog.PopupWindow.fireWindowClosing(PopupWindow.java:215)

at nextapp.echo2.app.WindowPane.userClose(WindowPane.java:795)

at org.openvpms.web.echo.dialog.PopupDialog.userClose(PopupDialog.java:262)

at org.openvpms.web.echo.dialog.MessageDialog.userClose(MessageDialog.java:109)

at org.openvpms.web.echo.dialog.PopupWindow.close(PopupWindow.java:142)

at org.openvpms.web.echo.dialog.PopupDialog.close(PopupDialog.java:417)

at org.openvpms.web.echo.dialog.PopupDialog.onOK(PopupDialog.java:323)

at org.openvpms.web.echo.dialog.PopupDialog.onButton(PopupDialog.java:294)

at org.openvpms.web.echo.dialog.PopupDialog$3.onAction(PopupDialog.java:448)

at org.openvpms.web.echo.event.ActionListener.actionPerformed(ActionListener.java:40)

at nextapp.echo2.app.button.AbstractButton.fireActionPerformed(AbstractButton.java:135)

at echopointng.ButtonEx$1.actionPerformed(ButtonEx.java:120)

at nextapp.echo2.app.button.DefaultButtonModel.fireActionPerformed(DefaultButtonModel.java:70)

at echopointng.model.DefaultButtonModelEx.doAction(DefaultButtonModelEx.java:51)

at echopointng.ButtonEx.processInput(ButtonEx.java:202)

at nextapp.echo2.app.update.ClientUpdateManager.process(ClientUpdateManager.java:116)

at nextapp.echo2.app.update.UpdateManager.processClientUpdates(UpdateManager.java:89)

at nextapp.echo2.webcontainer.ContainerSynchronizeService.renderUpdate(ContainerSynchronizeService.java:471)

at nextapp.echo2.webrender.service.SynchronizeService.service(SynchronizeService.java:279)

at nextapp.echo2.webrender.WebRenderServlet.process(WebRenderServlet.java:273)

at org.openvpms.web.echo.servlet.SpringWebContainerServlet.process(SpringWebContainerServlet.java:174)

at nextapp.echo2.webrender.WebRenderServlet.doPost(WebRenderServlet.java:189)

at javax.servlet.http.HttpServlet.service(HttpServlet.java:641)

at javax.servlet.http.HttpServlet.service(HttpServlet.java:722)

at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:305)

at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210)

at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:343)

at org.springframework.security.web.access.intercept.FilterSecurityInterceptor.invoke(FilterSecurityInterceptor.java:109)

at org.springframework.security.web.access.intercept.FilterSecurityInterceptor.doFilter(FilterSecurityInterceptor.java:83)

at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:355)

at org.springframework.security.web.authentication.AnonymousAuthenticationFilter.doFilter(AnonymousAuthenticationFilter.java:78)

at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:355)

at org.springframework.security.web.authentication.AbstractAuthenticationProcessingFilter.doFilter(AbstractAuthenticationProcessingFilter.java:187)

at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:355)

at org.springframework.security.web.access.ExceptionTranslationFilter.doFilter(ExceptionTranslationFilter.java:97)

at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:355)

at org.springframework.security.web.context.SecurityContextPersistenceFilter.doFilter(SecurityContextPersistenceFilter.java:79)

at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:355)

at org.springframework.security.web.FilterChainProxy.doFilter(FilterChainProxy.java:149)

at org.springframework.web.filter.DelegatingFilterProxy.invokeDelegate(DelegatingFilterProxy.java:237)

at org.springframework.web.filter.DelegatingFilterProxy.doFilter(DelegatingFilterProxy.java:167)

at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:243)

at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210)

at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:224)

at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:169)

at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:472)

at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:168)

at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:98)

at org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:927)

at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:118)

at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:407)

at org.apache.coyote.http11.AbstractHttp11Processor.process(AbstractHttp11Processor.java:987)

at org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:579)

at org.apache.tomcat.util.net.JIoEndpoint$SocketProcessor.run(JIoEndpoint.java:309)

at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source)

at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)

at java.lang.Thread.run(Unknown Source)

Caused by: org.openvpms.component.business.dao.hibernate.im.query.QueryBuilderException: Could not find any matching archetypes for short names {entity.jobESCI}

at org.openvpms.component.business.dao.hibernate.im.query.TypeSet.create(TypeSet.java:218)

at org.openvpms.component.business.dao.hibernate.im.query.QueryBuilder.getTypeSet(QueryBuilder.java:682)

at org.openvpms.component.business.dao.hibernate.im.query.QueryBuilder.process(QueryBuilder.java:215)

at org.openvpms.component.business.dao.hibernate.im.query.QueryBuilder.processConstraint(QueryBuilder.java:751)

at org.openvpms.component.business.dao.hibernate.im.query.QueryBuilder.process(QueryBuilder.java:119)

at org.openvpms.component.business.dao.hibernate.im.query.QueryBuilder.build(QueryBuilder.java:103)

at org.openvpms.component.business.dao.hibernate.im.IMObjectDAOHibernate$DefaultQueryDelegator.getObjects(IMObjectDAOHibernate.java:1172)

at org.openvpms.component.business.dao.hibernate.im.IMObjectDAOHibernate.getObjects(IMObjectDAOHibernate.java:262)

at org.openvpms.component.business.service.archetype.ArchetypeService.getObjects(ArchetypeService.java:392)

... 86 more

21 Jan 2014 09:48:44,265 ERROR DialogErrorHandler,http-bio-8080-exec-17:68 - Failed to execute query: {0}.

org.openvpms.component.business.service.archetype.ArchetypeServiceException: Failed to execute query: {0}.

at org.openvpms.component.business.service.archetype.ArchetypeService.getObjects(ArchetypeService.java:394)

at sun.reflect.GeneratedMethodAccessor184.invoke(Unknown Source)

at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)

at java.lang.reflect.Method.invoke(Unknown Source)

at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:309)

at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:196)

at com.sun.proxy.$Proxy4.getObjects(Unknown Source)

at sun.reflect.GeneratedMethodAccessor184.invoke(Unknown Source)

at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)

at java.lang.reflect.Method.invoke(Unknown Source)

at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:309)

at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:183)

at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:150)

at org.springframework.security.access.intercept.aopalliance.MethodSecurityInterceptor.invoke(MethodSecurityInterceptor.java:67)

at org.openvpms.component.business.service.security.OpenVPMSMethodSecurityInterceptor.invoke(OpenVPMSMethodSecurityInterceptor.java:50)

at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)

at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:202)

at com.sun.proxy.$Proxy5.getObjects(Unknown Source)

at org.openvpms.component.business.service.archetype.rule.ArchetypeRuleService.getObjects(ArchetypeRuleService.java:397)

at org.openvpms.component.system.common.query.ObjectSetQueryIterator.getPage(ObjectSetQueryIterator.java:64)

at org.openvpms.component.system.common.query.QueryIterator.hasNext(QueryIterator.java:81)

at org.openvpms.web.workspace.supplier.order.ESCISupplierCRUDWindow.getESCIJobName(ESCISupplierCRUDWindow.java:130)

at org.openvpms.web.workspace.supplier.order.ESCISupplierCRUDWindow.scheduleCheckInbox(ESCISupplierCRUDWindow.java:101)

at org.openvpms.web.workspace.supplier.order.OrderCRUDWindow.onPosted(OrderCRUDWindow.java:191)

at org.openvpms.web.workspace.supplier.order.OrderCRUDWindow.onPosted(OrderCRUDWindow.java:58)

at org.openvpms.web.component.workspace.ActCRUDWindow$1.onOK(ActCRUDWindow.java:153)

at org.openvpms.web.echo.dialog.PopupDialogListener.onAction(PopupDialogListener.java:108)

at org.openvpms.web.echo.dialog.PopupDialogListener.onClose(PopupDialogListener.java:40)

at org.openvpms.web.echo.event.WindowPaneListener.windowPaneClosing(WindowPaneListener.java:37)

at nextapp.echo2.app.WindowPane.fireWindowClosing(WindowPane.java:154)

at org.openvpms.web.echo.dialog.PopupWindow.fireWindowClosing(PopupWindow.java:215)

at nextapp.echo2.app.WindowPane.userClose(WindowPane.java:795)

at org.openvpms.web.echo.dialog.PopupDialog.userClose(PopupDialog.java:262)

at org.openvpms.web.echo.dialog.MessageDialog.userClose(MessageDialog.java:109)

at org.openvpms.web.echo.dialog.PopupWindow.close(PopupWindow.java:142)

at org.openvpms.web.echo.dialog.PopupDialog.close(PopupDialog.java:417)

at org.openvpms.web.echo.dialog.PopupDialog.onOK(PopupDialog.java:323)

at org.openvpms.web.echo.dialog.PopupDialog.onButton(PopupDialog.java:294)

at org.openvpms.web.echo.dialog.PopupDialog$3.onAction(PopupDialog.java:448)

at org.openvpms.web.echo.event.ActionListener.actionPerformed(ActionListener.java:40)

at nextapp.echo2.app.button.AbstractButton.fireActionPerformed(AbstractButton.java:135)

at echopointng.ButtonEx$1.actionPerformed(ButtonEx.java:120)

at nextapp.echo2.app.button.DefaultButtonModel.fireActionPerformed(DefaultButtonModel.java:70)

at echopointng.model.DefaultButtonModelEx.doAction(DefaultButtonModelEx.java:51)

at echopointng.ButtonEx.processInput(ButtonEx.java:202)

at nextapp.echo2.app.update.ClientUpdateManager.process(ClientUpdateManager.java:116)

at nextapp.echo2.app.update.UpdateManager.processClientUpdates(UpdateManager.java:89)

at nextapp.echo2.webcontainer.ContainerSynchronizeService.renderUpdate(ContainerSynchronizeService.java:471)

at nextapp.echo2.webrender.service.SynchronizeService.service(SynchronizeService.java:279)

at nextapp.echo2.webrender.WebRenderServlet.process(WebRenderServlet.java:273)

at org.openvpms.web.echo.servlet.SpringWebContainerServlet.process(SpringWebContainerServlet.java:174)

at nextapp.echo2.webrender.WebRenderServlet.doPost(WebRenderServlet.java:189)

at javax.servlet.http.HttpServlet.service(HttpServlet.java:641)

at javax.servlet.http.HttpServlet.service(HttpServlet.java:722)

at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:305)

at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210)

at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:343)

at org.springframework.security.web.access.intercept.FilterSecurityInterceptor.invoke(FilterSecurityInterceptor.java:109)

at org.springframework.security.web.access.intercept.FilterSecurityInterceptor.doFilter(FilterSecurityInterceptor.java:83)

at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:355)

at org.springframework.security.web.authentication.AnonymousAuthenticationFilter.doFilter(AnonymousAuthenticationFilter.java:78)

at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:355)

at org.springframework.security.web.authentication.AbstractAuthenticationProcessingFilter.doFilter(AbstractAuthenticationProcessingFilter.java:187)

at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:355)

at org.springframework.security.web.access.ExceptionTranslationFilter.doFilter(ExceptionTranslationFilter.java:97)

at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:355)

at org.springframework.security.web.context.SecurityContextPersistenceFilter.doFilter(SecurityContextPersistenceFilter.java:79)

at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:355)

at org.springframework.security.web.FilterChainProxy.doFilter(FilterChainProxy.java:149)

at org.springframework.web.filter.DelegatingFilterProxy.invokeDelegate(DelegatingFilterProxy.java:237)

at org.springframework.web.filter.DelegatingFilterProxy.doFilter(DelegatingFilterProxy.java:167)

at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:243)

at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210)

at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:224)

at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:169)

at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:472)

at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:168)

at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:98)

at org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:927)

at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:118)

at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:407)

at org.apache.coyote.http11.AbstractHttp11Processor.process(AbstractHttp11Processor.java:987)

at org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:579)

at org.apache.tomcat.util.net.JIoEndpoint$SocketProcessor.run(JIoEndpoint.java:309)

at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source)

at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)

at java.lang.Thread.run(Unknown Source)

Caused by: org.openvpms.component.business.dao.hibernate.im.query.QueryBuilderException: Could not find any matching archetypes for short names {entity.jobESCI}

at org.openvpms.component.business.dao.hibernate.im.query.TypeSet.create(TypeSet.java:218)

at org.openvpms.component.business.dao.hibernate.im.query.QueryBuilder.getTypeSet(QueryBuilder.java:682)

at org.openvpms.component.business.dao.hibernate.im.query.QueryBuilder.process(QueryBuilder.java:215)

at org.openvpms.component.business.dao.hibernate.im.query.QueryBuilder.processConstraint(QueryBuilder.java:751)

at org.openvpms.component.business.dao.hibernate.im.query.QueryBuilder.process(QueryBuilder.java:119)

at org.openvpms.component.business.dao.hibernate.im.query.QueryBuilder.build(QueryBuilder.java:103)

at org.openvpms.component.business.dao.hibernate.im.IMObjectDAOHibernate$DefaultQueryDelegator.getObjects(IMObjectDAOHibernate.java:1172)

at org.openvpms.component.business.dao.hibernate.im.IMObjectDAOHibernate.getObjects(IMObjectDAOHibernate.java:262)

at org.openvpms.component.business.service.archetype.ArchetypeService.getObjects(ArchetypeService.java:392)

... 86 more 
        

      
Regards


 


Ben 


OpenVPMS Installer and Helper 


Ph: +61423044823 


Email: info[at]charltonit.com[dot]au

    

      


      

          

  

 





      

      Re: 1.7 5709 Error on ESCI order submission.          

  
  
  
  

    Submitted by Ben_Charlton on Wed, 22/01/2014 - 10:41.  


  

    
Acutally it looks as if its trying to ref 


entity.jobESCI which I assume should be entity.jobESCIInboxReader

        

      
Regards


 


Ben 


OpenVPMS Installer and Helper 


Ph: +61423044823 


Email: info[at]charltonit.com[dot]au

    

      


      

          

  

 





      

      Re: 1.7 5709 Error on ESCI order submission.          

  
  
  
  

    Submitted by tanderson on Wed, 22/01/2014 - 20:27.  


  

    
Raised as https://openvpms.atlassian.net/browse/OVPMS-1425


BTW - if you get an error like this in future, submit an error report as well. All of the necessary information is conveyed in the report.


Thanks,


-Tim

      


      

          

  

 





      

      Re: 1.7 5709 Error on ESCI order submission.          

  
  
  
  

    Submitted by Ben_Charlton on Thu, 23/01/2014 - 09:10.  


  

    
I would except it wasn't me who recieved the error - staff member clicked ok etc..told me about it later.


 


In any event no probs.  I need to educate my beta testers better I think


 


Ben

        

      
Regards


 


Ben 


OpenVPMS Installer and Helper 


Ph: +61423044823 


Email: info[at]charltonit.com[dot]au

    

      


      

          

  

 

  

        


                  
Syndicate content