Hi Dave and Ben, Thanks very much for the candid advice. I've managed to fix this are you had earlier directed. I did delete quite number of items and also added the encounter date for the forms that were missing this details.
Thanks Erick On Fri, Sep 2, 2011 at 11:15 AM, Dave Thomas <[email protected]> wrote: > Erick, it looks like the forms aren't processing because the encounter > datetime is missing. either the field was left blank on the form or somehow > it is missing altogether from the form schema. if encounter datetime is in > the schema, you could manually add a datetime to the xml in the files in the > queue to have the forms process so that you don't lose the rest of the form > submissions. If this is the case, you'll want to add validation to the > form to ensure that this is never blank in the future. > > If the encounter datetime element is missing from the form schema , you'll > need to add it and then rebuild your forms to include it. you can see the > form schema under administration/manage forms. > > D > On Sep 2, 2011 10:03 AM, "Erick Mugoma" <[email protected]> wrote: > > Hi Ben > > I've deleted the first two items on the queue but the error still > persists. > > Should I continue deleting until it starts processing. > > > > Thanks > > > > On Fri, Sep 2, 2011 at 9:55 AM, Ben Wolfe <[email protected]> wrote: > > > >> The immediate solution is to remove that hl7 item from the top of the > >> queue and put it in the error queue. For some reason that is not > >> happening automatically. > >> > >> The long term solution is to make sure that every field in your form > >> that should have a date has a date. > >> > >> Ben > >> > >> On Fri, Sep 2, 2011 at 9:50 AM, Erick Mugoma <[email protected]> > >> wrote: > >> > Hi Ben, > >> > We are running openmrs 1.6.2 and since Tuesday this week, HL7 In Queue > is > >> > unable to process the forms. > >> > > >> > The following is the error as captured from Catalina.out > >> > > >> > INFO - LoggingAdvice.invoke(127) |2011-09-02 09:18:00,019| Exiting > method > >> > processHL7Message > >> > INFO - LoggingAdvice.invoke(102) |2011-09-02 09:18:00,021| In method > >> > HL7Service.saveHL7InError. Arguments: > >> > HL7InError=org.openmrs.hl7.HL7InError@d42f232, > >> > INFO - LoggingAdvice.invoke(127) |2011-09-02 09:18:00,022| Exiting > method > >> > saveHL7InError > >> > INFO - LoggingAdvice.invoke(102) |2011-09-02 09:18:00,023| In method > >> > HL7Service.purgeHL7InQueue. Arguments: > >> > HL7InQueue=org.openmrs.hl7.HL7InQueue@107c, > >> > INFO - LoggingAdvice.invoke(127) |2011-09-02 09:18:00,023| Exiting > method > >> > purgeHL7InQueue > >> > ERROR - HL7ServiceImpl.setFatalError(712) |2011-09-02 09:18:00,024| > >> > Exception while attempting to process HL7 In Queue > (6YLimJMGwX2GuGHHfvKM) > >> > java.lang.NullPointerException > >> > at > >> > org.openmrs.hl7.handler.ORUR01Handler.tsToDate(ORUR01Handler.java:842) > >> > at > >> > > >> > org.openmrs.hl7.handler.ORUR01Handler.getEncounterDate(ORUR01Handler.java:772) > >> > at > >> > > >> > org.openmrs.hl7.handler.ORUR01Handler.createEncounter(ORUR01Handler.java:404) > >> > at > >> > > >> > org.openmrs.hl7.handler.ORUR01Handler.processORU_R01(ORUR01Handler.java:173) > >> > at > >> > > >> > org.openmrs.hl7.handler.ORUR01Handler.processMessage(ORUR01Handler.java:121) > >> > at > >> > > >> > ca.uhn.hl7v2.app.MessageTypeRouter.processMessage(MessageTypeRouter.java:52) > >> > at > >> > > >> > org.openmrs.hl7.impl.HL7ServiceImpl.processHL7Message(HL7ServiceImpl.java:749) > >> > at sun.reflect.GeneratedMethodAccessor662.invoke(Unknown Source) > >> > at > >> > > >> > sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) > >> > at java.lang.reflect.Method.invoke(Method.java:597) > >> > at > >> > > >> > org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:307) > >> > at > >> > > >> > org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:182) > >> > at > >> > > >> > org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:149) > >> > at > >> > > >> > org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:106) > >> > at > >> > > >> > org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171) > >> > at > >> > > >> > org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:204) > >> > at $Proxy105.processHL7Message(Unknown Source) > >> > at sun.reflect.GeneratedMethodAccessor662.invoke(Unknown Source) > >> > at > >> > > >> > sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) > >> > at java.lang.reflect.Method.invoke(Method.java:597) > >> > at > >> > > >> > org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:307) > >> > at > >> > > >> > org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:182) > >> > at > >> > > >> > org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:149) > >> > at > >> > > >> > org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:106) > >> > at > >> > > >> > org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171) > >> > at org.openmrs.aop.LoggingAdvice.invoke(LoggingAdvice.java:107) > >> > at > >> > > >> > org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171) > >> > at > >> > > >> > org.springframework.aop.framework.adapter.MethodBeforeAdviceInterceptor.invoke(MethodBeforeAdviceInterceptor.java:50) > >> > at > >> > > >> > org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171) > >> > at > >> > > >> > org.springframework.aop.framework.adapter.MethodBeforeAdviceInterceptor.invoke(MethodBeforeAdviceInterceptor.java:50) > >> > at > >> > > >> > org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171) > >> > at > >> > > >> > org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:204) > >> > at $Proxy106.processHL7Message(Unknown Source) > >> > at sun.reflect.GeneratedMethodAccessor662.invoke(Unknown Source) > >> > at > >> > > >> > sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) > >> > at java.lang.reflect.Method.invoke(Method.java:597) > >> > at > >> > > >> > org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:307) > >> > at > >> > > >> > org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:182) > >> > at > >> > > >> > org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:149) > >> > at > >> > > >> > org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:106) > >> > at > >> > > >> > org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171) > >> > at > >> > > >> > org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:204) > >> > at $Proxy106.processHL7Message(Unknown Source) > >> > at sun.reflect.GeneratedMethodAccessor662.invoke(Unknown Source) > >> > at > >> > > >> > sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) > >> > at java.lang.reflect.Method.invoke(Method.java:597) > >> > at > >> > > >> > org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:307) > >> > at > >> > > >> > org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:198) > >> > at $Proxy148.processHL7Message(Unknown Source) > >> > at > >> > > >> > org.openmrs.hl7.impl.HL7ServiceImpl.processHL7InQueue(HL7ServiceImpl.java:657) > >> > at sun.reflect.GeneratedMethodAccessor660.invoke(Unknown Source) > >> > at > >> > > >> > sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) > >> > at java.lang.reflect.Method.invoke(Method.java:597) > >> > at > >> > > >> > org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:307) > >> > at > >> > > >> > org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:182) > >> > at > >> > > >> > org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:149) > >> > at > >> > > >> > org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:106) > >> > at > >> > > >> > org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171) > >> > at > >> > > >> > org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:204) > >> > at $Proxy105.processHL7InQueue(Unknown Source) > >> > at sun.reflect.GeneratedMethodAccessor660.invoke(Unknown Source) > >> > at > >> > > >> > sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) > >> > at java.lang.reflect.Method.invoke(Method.java:597) > >> > at > >> > > >> > org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:307) > >> > at > >> > > >> > org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:182) > >> > at > >> > > >> > org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:149) > >> > at > >> > > >> > org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:106) > >> > at > >> > > >> > org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171) > >> > at org.openmrs.aop.LoggingAdvice.invoke(LoggingAdvice.java:107) > >> > at > >> > > >> > org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171) > >> > at > >> > > >> > org.springframework.aop.framework.adapter.MethodBeforeAdviceInterceptor.invoke(MethodBeforeAdviceInterceptor.java:50) > >> > at > >> > > >> > org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171) > >> > at > >> > > >> > org.springframework.aop.framework.adapter.MethodBeforeAdviceInterceptor.invoke(MethodBeforeAdviceInterceptor.java:50) > >> > at > >> > > >> > org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171) > >> > at > >> > > >> > org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:204) > >> > at $Proxy106.processHL7InQueue(Unknown Source) > >> > at sun.reflect.GeneratedMethodAccessor660.invoke(Unknown Source) > >> > at > >> > > >> > sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) > >> > at java.lang.reflect.Method.invoke(Method.java:597) > >> > at > >> > > >> > org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:307) > >> > at > >> > > >> > org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:182) > >> > at > >> > > >> > org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:149) > >> > at > >> > > >> > org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:106) > >> > at > >> > > >> > org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171) > >> > at > >> > > >> > org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:204) > >> > at $Proxy106.processHL7InQueue(Unknown Source) > >> > at sun.reflect.GeneratedMethodAccessor660.invoke(Unknown Source) > >> > at > >> > > >> > sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) > >> > at java.lang.reflect.Method.invoke(Method.java:597) > >> > at > >> > > >> > org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:307) > >> > at > >> > > >> > org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:198) > >> > at $Proxy148.processHL7InQueue(Unknown Source) > >> > at > >> > > >> > org.openmrs.hl7.HL7InQueueProcessor.processHL7InQueue(HL7InQueueProcessor.java:61) > >> > at > >> > > >> > org.openmrs.hl7.HL7InQueueProcessor.processNextHL7InQueue(HL7InQueueProcessor.java:91) > >> > at > >> > > >> > org.openmrs.hl7.HL7InQueueProcessor.processHL7InQueue(HL7InQueueProcessor.java:110) > >> > at > >> > > >> > org.openmrs.scheduler.tasks.ProcessHL7InQueueTask.execute(ProcessHL7InQueueTask.java:57) > >> > at > >> > > >> > org.openmrs.scheduler.tasks.TaskThreadedInitializationWrapper.execute(TaskThreadedInitializationWrapper.java:72) > >> > at > >> > > >> > org.openmrs.scheduler.timer.TimerSchedulerTask.run(TimerSchedulerTask.java:48) > >> > at java.util.TimerThread.mainLoop(Timer.java:512) > >> > at java.util.TimerThread.run(Timer.java:462) > >> > INFO - LoggingAdvice.invoke(127) |2011-09-02 09:18:00,024| Exiting > method > >> > processHL7InQueue > >> > ERROR - TimerSchedulerTask.run(57) |2011-09-02 09:18:00,045| FATAL > ERROR: > >> > Task [class > >> org.openmrs.scheduler.tasks.TaskThreadedInitializationWrapper] > >> > failed due to exception > >> > [org.springframework.transaction.UnexpectedRollbackException] > >> > org.springframework.transaction.UnexpectedRollbackException: > Transaction > >> > rolled back because it has been marked as rollback-only > >> > at > >> > > >> > org.springframework.transaction.support.AbstractPlatformTransactionManager.commit(AbstractPlatformTransactionManager.java:695) > >> > at > >> > > >> > org.springframework.transaction.interceptor.TransactionAspectSupport.commitTransactionAfterReturning(TransactionAspectSupport.java:321) > >> > at > >> > > >> > org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:116) > >> > at > >> > > >> > org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171) > >> > at > >> > > >> > org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:204) > >> > at $Proxy106.processHL7InQueue(Unknown Source) > >> > at sun.reflect.GeneratedMethodAccessor660.invoke(Unknown Source) > >> > at > >> > > >> > sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) > >> > at java.lang.reflect.Method.invoke(Method.java:597) > >> > at > >> > > >> > org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:307) > >> > at > >> > > >> > org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:198) > >> > at $Proxy148.processHL7InQueue(Unknown Source) > >> > at > >> > > >> > org.openmrs.hl7.HL7InQueueProcessor.processHL7InQueue(HL7InQueueProcessor.java:61) > >> > at > >> > > >> > org.openmrs.hl7.HL7InQueueProcessor.processNextHL7InQueue(HL7InQueueProcessor.java:91) > >> > at > >> > > >> > org.openmrs.hl7.HL7InQueueProcessor.processHL7InQueue(HL7InQueueProcessor.java:110) > >> > at > >> > > >> > org.openmrs.scheduler.tasks.ProcessHL7InQueueTask.execute(ProcessHL7InQueueTask.java:57) > >> > at > >> > > >> > org.openmrs.scheduler.tasks.TaskThreadedInitializationWrapper.execute(TaskThreadedInitializationWrapper.java:72) > >> > at > >> > > >> > org.openmrs.scheduler.timer.TimerSchedulerTask.run(TimerSchedulerTask.java:48) > >> > at java.util.TimerThread.mainLoop(Timer.java:512) > >> > at java.util.TimerThread.run(Timer.java:462) > >> > Sep 2, 2011 9:18:26 AM org.apache.tomcat.util.http.Parameters > >> > processParameters > >> > WARNING: Parameters: Invalid chunk ignored. > >> > INFO - LoggingAdvice.invoke(102) |2011-09-02 09:18:30,011| In method > >> > SchedulerService.saveTask. Arguments: TaskDefinition=[TaskDefinition > >> id=1 > >> > name=Process Form Entry Queue > >> > class=org.openmrs.module.formentry.ProcessFormEntryQueueTask > >> > startTime=2006-04-24 00:00:00.0 repeatInterval=30 > secondsUntilNext=29], > >> > INFO - LoggingAdvice.invoke(127) |2011-09-02 09:18:30,012| Exiting > method > >> > saveTask > >> > INFO - LoggingAdvice.invoke(102) |2011-09-02 09:18:30,240| In method > >> > FormEntryService.createFormEntryQueue. Arguments: > >> > FormEntryQueue=org.openmrs.module.formentry.FormEntryQueue@33d4596c, > >> > INFO - LoggingAdvice.invoke(127) |2011-09-02 09:18:30,240| Exiting > method > >> > createFormEntryQueue > >> > > >> > > >> > > > > _________________________________________ > > > > To unsubscribe from OpenMRS Implementers' mailing list, send an e-mail to > [email protected] with "SIGNOFF openmrs-implement-l" in the body > (not the subject) of your e-mail. > > > > [mailto:[email protected]?body=SIGNOFF%20openmrs-implement-l] > ------------------------------ > Click here to > unsubscribe<[email protected]?body=SIGNOFF%20openmrs-implement-l>from > OpenMRS Implementers' mailing list _________________________________________ To unsubscribe from OpenMRS Implementers' mailing list, send an e-mail to [email protected] with "SIGNOFF openmrs-implement-l" in the body (not the subject) of your e-mail. [mailto:[email protected]?body=SIGNOFF%20openmrs-implement-l]
