Data Exports Bug in OpenMRS MDR-TB?

classic Classic list List threaded Threaded
4 messages Options
Owais Ahmed Owais Ahmed
Reply | Threaded
Open this post in threaded view
|

Data Exports Bug in OpenMRS MDR-TB?

Dear All,

I am using OpenMRS MDR-TB, and I have been getting an error when preparing data exports. Here are the steps I followed: Go to Administration -> Manage Data Exports -> Add New Data Export -> Define Cohort (I select the cohort to match) -> Define Columns -> Simple Column (I add basic demographic columns and the one that gives errors:"Current  TUBERCULOSIS  TREATMENT  DRUGS").  After naming, saving, generating, and downloading the export, below is what appears in the Excel sheet. I only get this error in data exports when the Current TUBERCULOSIS TREATMENT DRUGS column is included. Everything else I have tried works. I would really appreciate any feedback.

-Owais Ahmed
Systems Analyst
Interactive Research and Development
Suite 508, Ibrahim Trade Tower
Main Shahrah-e-Faisal
Karachi 75350 Pakistan
Tel: +92-21-432-7697
**********************************************************************************************************************************
MDR-TB Program Identifier  Current TUBERCULOSIS TREATMENT DRUGS
12345678  
       
Error:        
"org.apache.velocity.exception.MethodInvocationException: Invocation of method 'getCurrentDrugNames' in  class org.openmrs.reporting.export.DataExportFunctions threw exception java.lang.NullPointerException @ org.openmrs.reporting.export.DataExportUtil[3,168]"       
 Stacktrace:        
"org.apache.velocity.exception.MethodInvocationException: Invocation of method 'getCurrentDrugNames' in  class org.openmrs.reporting.export.DataExportFunctions threw exception java.lang.NullPointerException @ org.openmrs.reporting.export.DataExportUtil[3,168]"       
    at org.apache.velocity.runtime.parser.node.ASTMethod.execute(ASTMethod.java:285)   
    at org.apache.velocity.runtime.parser.node.ASTReference.execute(ASTReference.java:202)   
    at org.apache.velocity.runtime.parser.node.ASTReference.render(ASTReference.java:293)   
    at org.apache.velocity.runtime.parser.node.ASTBlock.render(ASTBlock.java:72)   
    at org.apache.velocity.runtime.directive.Foreach.render(Foreach.java:448)   
    at org.apache.velocity.runtime.parser.node.ASTDirective.render(ASTDirective.java:169)   
    at org.apache.velocity.runtime.parser.node.SimpleNode.render(SimpleNode.java:317)   
    at org.apache.velocity.app.VelocityEngine.evaluate(VelocityEngine.java:356)   
    at org.apache.velocity.app.VelocityEngine.evaluate(VelocityEngine.java:228)   
    at org.openmrs.reporting.export.DataExportUtil.generateExport(DataExportUtil.java:186)   
    at org.openmrs.reporting.export.DataExportUtil.generateExport(DataExportUtil.java:122)   
    at org.openmrs.web.controller.report.export.DataExportListController.onSubmit(DataExportListController.java:120)   
    at org.springframework.web.servlet.mvc.SimpleFormController.processFormSubmission(SimpleFormController.java:267)   
    at org.springframework.web.servlet.mvc.AbstractFormController.handleRequestInternal(AbstractFormController.java:265)   
    at org.springframework.web.servlet.mvc.AbstractController.handleRequest(AbstractController.java:153)   
    at org.springframework.web.servlet.mvc.SimpleControllerHandlerAdapter.handle(SimpleControllerHandlerAdapter.java:48)   
    at org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:875)   
    at org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:809)   
    at org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:476)   
    at org.springframework.web.servlet.FrameworkServlet.doPost(FrameworkServlet.java:441)   
    at javax.servlet.http.HttpServlet.service(HttpServlet.java:710)   
    at javax.servlet.http.HttpServlet.service(HttpServlet.java:803)   
    at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)   
    at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)   
    at org.openmrs.web.OpenmrsFilter.doFilter(OpenmrsFilter.java:124)   
    at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)   
    at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)   
    at org.springframework.orm.hibernate3.support.OpenSessionInViewFilter.doFilterInternal(OpenSessionInViewFilter.java:198)   
    at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:75)   
    at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)   
    at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)   
    at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233)   
    at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:175)   
    at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:128)   
    at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)   
    at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)   
    at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:286)   
    at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:844)   
    at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:583)   
    at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:447)   
    at java.lang.Thread.run(Unknown Source)   
Caused by: java.lang.NullPointerException       
    at org.openmrs.reporting.export.DataExportFunctions.getCurrentDrugNames(DataExportFunctions.java:563)   
    at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)   
    at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)   
    at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)   
    at java.lang.reflect.Method.invoke(Unknown Source)   
    at org.apache.velocity.util.introspection.UberspectImpl$VelMethodImpl.invoke(UberspectImpl.java:295)   
    at org.apache.velocity.runtime.parser.node.ASTMethod.execute(ASTMethod.java:244)   
    ... 40 more   




[hidden email] from OpenMRS Implementers' mailing list
David Thomas-2 David Thomas-2
Reply | Threaded
Open this post in threaded view
|

Re: Data Exports Bug in OpenMRS MDR-TB?

Hi.  I know what this is about, but I'm not sure what to do about it.  The problem is that the mdrtb module supports 'generic' drug orders, meaning that a drug order isn't necessarily attached to a specific drug formulation in the drug table.

The data export routines expect drug orders to be attached to specific drug formulations.

I'll think about this today, and try to get you a solution.

thanks,
d


-----Original Message-----
From: [hidden email] on behalf of Owais Ahmed
Sent: Thu 12/4/2008 1:39 AM
To: [hidden email]
Subject: [OPENMRS-IMPLEMENTERS] Data Exports Bug in OpenMRS MDR-TB?
 
Dear All,

I am using OpenMRS MDR-TB, and I have been getting an error when preparing
data exports. Here are the steps I followed: Go to Administration -> Manage
Data Exports -> Add New Data Export -> Define Cohort (I select the cohort to
match) -> Define Columns -> Simple Column (I add basic demographic columns
and the one that gives errors:"Current  TUBERCULOSIS  TREATMENT  DRUGS").
After naming, saving, generating, and downloading the export, below is what
appears in the Excel sheet. I only get this error in data exports when the
Current TUBERCULOSIS TREATMENT DRUGS column is included. Everything else I
have tried works. I would really appreciate any feedback.

-Owais Ahmed
Systems Analyst
Interactive Research and Development
Suite 508, Ibrahim Trade Tower
Main Shahrah-e-Faisal
Karachi 75350 Pakistan
Tel: +92-21-432-7697
**********************************************************************************************************************************
MDR-TB Program Identifier  Current TUBERCULOSIS TREATMENT DRUGS
12345678

Error:
"org.apache.velocity.exception.MethodInvocationException: Invocation of
method 'getCurrentDrugNames' in  class
org.openmrs.reporting.export.DataExportFunctions threw exception
java.lang.NullPointerException @
org.openmrs.reporting.export.DataExportUtil[3,168]"
 Stacktrace:
"org.apache.velocity.exception.MethodInvocationException: Invocation of
method 'getCurrentDrugNames' in  class
org.openmrs.reporting.export.DataExportFunctions threw exception
java.lang.NullPointerException @
org.openmrs.reporting.export.DataExportUtil[3,168]"
    at
org.apache.velocity.runtime.parser.node.ASTMethod.execute(ASTMethod.java:285)

    at
org.apache.velocity.runtime.parser.node.ASTReference.execute(ASTReference.java:202)

    at
org.apache.velocity.runtime.parser.node.ASTReference.render(ASTReference.java:293)

    at
org.apache.velocity.runtime.parser.node.ASTBlock.render(ASTBlock.java:72)

    at
org.apache.velocity.runtime.directive.Foreach.render(Foreach.java:448)
    at
org.apache.velocity.runtime.parser.node.ASTDirective.render(ASTDirective.java:169)

    at
org.apache.velocity.runtime.parser.node.SimpleNode.render(SimpleNode.java:317)

    at
org.apache.velocity.app.VelocityEngine.evaluate(VelocityEngine.java:356)
    at
org.apache.velocity.app.VelocityEngine.evaluate(VelocityEngine.java:228)
    at
org.openmrs.reporting.export.DataExportUtil.generateExport(DataExportUtil.java:186)

    at
org.openmrs.reporting.export.DataExportUtil.generateExport(DataExportUtil.java:122)

    at
org.openmrs.web.controller.report.export.DataExportListController.onSubmit(DataExportListController.java:120)

    at
org.springframework.web.servlet.mvc.SimpleFormController.processFormSubmission(SimpleFormController.java:267)

    at
org.springframework.web.servlet.mvc.AbstractFormController.handleRequestInternal(AbstractFormController.java:265)

    at
org.springframework.web.servlet.mvc.AbstractController.handleRequest(AbstractController.java:153)

    at
org.springframework.web.servlet.mvc.SimpleControllerHandlerAdapter.handle(SimpleControllerHandlerAdapter.java:48)

    at
org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:875)

    at
org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:809)

    at
org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:476)

    at
org.springframework.web.servlet.FrameworkServlet.doPost(FrameworkServlet.java:441)

    at javax.servlet.http.HttpServlet.service(HttpServlet.java:710)
    at javax.servlet.http.HttpServlet.service(HttpServlet.java:803)
    at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)

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

    at org.openmrs.web.OpenmrsFilter.doFilter(OpenmrsFilter.java:124)
    at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)

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

    at
org.springframework.orm.hibernate3.support.OpenSessionInViewFilter.doFilterInternal(OpenSessionInViewFilter.java:198)

    at
org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:75)

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

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

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

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

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

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

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

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

    at
org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:844)

    at
org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:583)

    at
org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:447)
    at java.lang.Thread.run(Unknown Source)
Caused by: java.lang.NullPointerException
    at
org.openmrs.reporting.export.DataExportFunctions.getCurrentDrugNames(DataExportFunctions.java:563)

    at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
    at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
    at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
    at java.lang.reflect.Method.invoke(Unknown Source)
    at
org.apache.velocity.util.introspection.UberspectImpl$VelMethodImpl.invoke(UberspectImpl.java:295)

    at
org.apache.velocity.runtime.parser.node.ASTMethod.execute(ASTMethod.java:244)

    ... 40 more

_________________________________________

To unsubscribe from OpenMRS Implementers' mailing list, send an e-mail to [hidden email] with "SIGNOFF openmrs-implement-l" in the  body (not the subject) of your e-mail.

[mailto:[hidden email]?body=SIGNOFF%20openmrs-implement-l]


_________________________________________

To unsubscribe from OpenMRS Implementers' mailing list, send an e-mail to [hidden email] with "SIGNOFF openmrs-implement-l" in the  body (not the subject) of your e-mail.

[mailto:[hidden email]?body=SIGNOFF%20openmrs-implement-l]
David Thomas-2 David Thomas-2
Reply | Threaded
Open this post in threaded view
|

Re: Data Exports Bug in OpenMRS MDR-TB?

In reply to this post by Owais Ahmed
This is now fixed in the mdrtb installer, available at

http://resources.openmrs.org/mdrtb/OpenMRS_install_mdrtb.zip

thanks,
d


-----Original Message-----
From: [hidden email] on behalf of Owais Ahmed
Sent: Thu 12/4/2008 1:39 AM
To: [hidden email]
Subject: [OPENMRS-IMPLEMENTERS] Data Exports Bug in OpenMRS MDR-TB?
 
Dear All,

I am using OpenMRS MDR-TB, and I have been getting an error when preparing
data exports. Here are the steps I followed: Go to Administration -> Manage
Data Exports -> Add New Data Export -> Define Cohort (I select the cohort to
match) -> Define Columns -> Simple Column (I add basic demographic columns
and the one that gives errors:"Current  TUBERCULOSIS  TREATMENT  DRUGS").
After naming, saving, generating, and downloading the export, below is what
appears in the Excel sheet. I only get this error in data exports when the
Current TUBERCULOSIS TREATMENT DRUGS column is included. Everything else I
have tried works. I would really appreciate any feedback.

-Owais Ahmed
Systems Analyst
Interactive Research and Development
Suite 508, Ibrahim Trade Tower
Main Shahrah-e-Faisal
Karachi 75350 Pakistan
Tel: +92-21-432-7697
**********************************************************************************************************************************
MDR-TB Program Identifier  Current TUBERCULOSIS TREATMENT DRUGS
12345678

Error:
"org.apache.velocity.exception.MethodInvocationException: Invocation of
method 'getCurrentDrugNames' in  class
org.openmrs.reporting.export.DataExportFunctions threw exception
java.lang.NullPointerException @
org.openmrs.reporting.export.DataExportUtil[3,168]"
 Stacktrace:
"org.apache.velocity.exception.MethodInvocationException: Invocation of
method 'getCurrentDrugNames' in  class
org.openmrs.reporting.export.DataExportFunctions threw exception
java.lang.NullPointerException @
org.openmrs.reporting.export.DataExportUtil[3,168]"
    at
org.apache.velocity.runtime.parser.node.ASTMethod.execute(ASTMethod.java:285)

    at
org.apache.velocity.runtime.parser.node.ASTReference.execute(ASTReference.java:202)

    at
org.apache.velocity.runtime.parser.node.ASTReference.render(ASTReference.java:293)

    at
org.apache.velocity.runtime.parser.node.ASTBlock.render(ASTBlock.java:72)

    at
org.apache.velocity.runtime.directive.Foreach.render(Foreach.java:448)
    at
org.apache.velocity.runtime.parser.node.ASTDirective.render(ASTDirective.java:169)

    at
org.apache.velocity.runtime.parser.node.SimpleNode.render(SimpleNode.java:317)

    at
org.apache.velocity.app.VelocityEngine.evaluate(VelocityEngine.java:356)
    at
org.apache.velocity.app.VelocityEngine.evaluate(VelocityEngine.java:228)
    at
org.openmrs.reporting.export.DataExportUtil.generateExport(DataExportUtil.java:186)

    at
org.openmrs.reporting.export.DataExportUtil.generateExport(DataExportUtil.java:122)

    at
org.openmrs.web.controller.report.export.DataExportListController.onSubmit(DataExportListController.java:120)

    at
org.springframework.web.servlet.mvc.SimpleFormController.processFormSubmission(SimpleFormController.java:267)

    at
org.springframework.web.servlet.mvc.AbstractFormController.handleRequestInternal(AbstractFormController.java:265)

    at
org.springframework.web.servlet.mvc.AbstractController.handleRequest(AbstractController.java:153)

    at
org.springframework.web.servlet.mvc.SimpleControllerHandlerAdapter.handle(SimpleControllerHandlerAdapter.java:48)

    at
org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:875)

    at
org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:809)

    at
org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:476)

    at
org.springframework.web.servlet.FrameworkServlet.doPost(FrameworkServlet.java:441)

    at javax.servlet.http.HttpServlet.service(HttpServlet.java:710)
    at javax.servlet.http.HttpServlet.service(HttpServlet.java:803)
    at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)

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

    at org.openmrs.web.OpenmrsFilter.doFilter(OpenmrsFilter.java:124)
    at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)

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

    at
org.springframework.orm.hibernate3.support.OpenSessionInViewFilter.doFilterInternal(OpenSessionInViewFilter.java:198)

    at
org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:75)

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

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

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

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

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

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

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

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

    at
org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:844)

    at
org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:583)

    at
org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:447)
    at java.lang.Thread.run(Unknown Source)
Caused by: java.lang.NullPointerException
    at
org.openmrs.reporting.export.DataExportFunctions.getCurrentDrugNames(DataExportFunctions.java:563)

    at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
    at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
    at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
    at java.lang.reflect.Method.invoke(Unknown Source)
    at
org.apache.velocity.util.introspection.UberspectImpl$VelMethodImpl.invoke(UberspectImpl.java:295)

    at
org.apache.velocity.runtime.parser.node.ASTMethod.execute(ASTMethod.java:244)

    ... 40 more

_________________________________________

To unsubscribe from OpenMRS Implementers' mailing list, send an e-mail to [hidden email] with "SIGNOFF openmrs-implement-l" in the  body (not the subject) of your e-mail.

[mailto:[hidden email]?body=SIGNOFF%20openmrs-implement-l]


_________________________________________

To unsubscribe from OpenMRS Implementers' mailing list, send an e-mail to [hidden email] with "SIGNOFF openmrs-implement-l" in the  body (not the subject) of your e-mail.

[mailto:[hidden email]?body=SIGNOFF%20openmrs-implement-l]
Owais Ahmed Owais Ahmed
Reply | Threaded
Open this post in threaded view
|

Re: Data Exports Bug in OpenMRS MDR-TB?

Dear David,

First of all, thank you for addressing this issue so quickly. For some reason, I am still getting an error (pasted below). I am running the MDR-TB installer version, which does not install Tomcat and MySQL as services. What I did was use stop_openmrs.cmd , then replaced the WAR file in  C:\OpenMRS\apache-tomcat-6.0.16\webapps , and then used start_openmrs.cmd , then stop_openmrs.cmd and then start_openmrs.cmd again.

OpenMRS was inaccessible at first (Tomcat said could not open /openmrs/) but it worked after restarting the server. I went in and made a new Data Export and then generated and downloaded it. As before, only a few rows appear, and that also with the Current TUBERCULOSIS TREATMENT DRUGS column blank, followed by:

Error:                                                
"org.apache.velocity.exception.MethodInvocationException: Invocation of method 'getCurrentDrugNames' in  class org.openmrs.reporting.export.DataExportFunctions threw exception java.lang.NullPointerException @ org.openmrs.reporting.export.DataExportUtil[3,1137]"                                               
 Stacktrace:                                                
"org.apache.velocity.exception.MethodInvocationException: Invocation of method 'getCurrentDrugNames' in  class org.openmrs.reporting.export.DataExportFunctions threw exception java.lang.NullPointerException @ org.openmrs.reporting.export.DataExportUtil[3,1137]"                                               
    at org.apache.velocity.runtime.parser.node.ASTMethod.execute(ASTMethod.java:285)                                           
    at org.apache.velocity.runtime.parser.node.ASTReference.execute(ASTReference.java:202)                                           
    at org.apache.velocity.runtime.parser.node.ASTReference.render(ASTReference.java:293)                                           
    at org.apache.velocity.runtime.parser.node.ASTBlock.render(ASTBlock.java:72)                                           
    at org.apache.velocity.runtime.directive.Foreach.render(Foreach.java:448)                                           
    at org.apache.velocity.runtime.parser.node.ASTDirective.render(ASTDirective.java:169)                                           
    at org.apache.velocity.runtime.parser.node.SimpleNode.render(SimpleNode.java:317)                                           
    at org.apache.velocity.app.VelocityEngine.evaluate(VelocityEngine.java:356)                                           
    at org.apache.velocity.app.VelocityEngine.evaluate(VelocityEngine.java:228)                                           
    at org.openmrs.reporting.export.DataExportUtil.generateExport(DataExportUtil.java:186)                                           
    at org.openmrs.reporting.export.DataExportUtil.generateExport(DataExportUtil.java:122)                                           
    at org.openmrs.web.controller.report.export.DataExportListController.onSubmit(DataExportListController.java:120)                                           
    at org.springframework.web.servlet.mvc.SimpleFormController.processFormSubmission(SimpleFormController.java:267)                                           
    at org.springframework.web.servlet.mvc.AbstractFormController.handleRequestInternal(AbstractFormController.java:265)                                           
    at org.springframework.web.servlet.mvc.AbstractController.handleRequest(AbstractController.java:153)                                           
    at org.springframework.web.servlet.mvc.SimpleControllerHandlerAdapter.handle(SimpleControllerHandlerAdapter.java:48)                                           
    at org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:875)                                           
    at org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:809)                                           
    at org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:476)                                           
    at org.springframework.web.servlet.FrameworkServlet.doPost(FrameworkServlet.java:441)                                           
    at javax.servlet.http.HttpServlet.service(HttpServlet.java:710)                                           
    at javax.servlet.http.HttpServlet.service(HttpServlet.java:803)                                           
    at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)                                           
    at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)                                           
    at org.openmrs.web.OpenmrsFilter.doFilter(OpenmrsFilter.java:124)                                           
    at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)                                           
    at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)                                           
    at org.springframework.orm.hibernate3.support.OpenSessionInViewFilter.doFilterInternal(OpenSessionInViewFilter.java:198)                                           
    at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:75)                                           
    at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)                                           
    at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)                                           
    at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233)                                           
    at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:175)                                           
    at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:128)                                           
    at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)                                           
    at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)                                           
    at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:286)                                           
    at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:844)                                           
    at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:583)                                           
    at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:447)                                           
    at java.lang.Thread.run(Unknown Source)                                           
Caused by: java.lang.NullPointerException                                               
    at org.openmrs.reporting.export.DataExportFunctions.getCurrentDrugNames(DataExportFunctions.java:563)                                           
    at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)                                           
    at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)                                           
    at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)                                           
    at java.lang.reflect.Method.invoke(Unknown Source)                                           
    at org.apache.velocity.util.introspection.UberspectImpl$VelMethodImpl.invoke(UberspectImpl.java:295)                                           
    at org.apache.velocity.runtime.parser.node.ASTMethod.execute(ASTMethod.java:244)                                           
    ... 40 more                                           

-Owais
Systems Analyst
Interactive Research and Development
Suite 508, Ibrahim Trade Tower
Main Shahrah-e-Faisal
Karachi 75350 Pakistan
Tel: +92-21-432-7697



On Fri, Dec 5, 2008 at 1:13 AM, David Thomas <[hidden email]> wrote:
This is now fixed in the mdrtb installer, available at

http://resources.openmrs.org/mdrtb/OpenMRS_install_mdrtb.zip

thanks,
d


-----Original Message-----
From: [hidden email] on behalf of Owais Ahmed
Sent: Thu 12/4/2008 1:39 AM
To: [hidden email]
Subject: [OPENMRS-IMPLEMENTERS] Data Exports Bug in OpenMRS MDR-TB?

Dear All,

I am using OpenMRS MDR-TB, and I have been getting an error when preparing
data exports. Here are the steps I followed: Go to Administration -> Manage
Data Exports -> Add New Data Export -> Define Cohort (I select the cohort to
match) -> Define Columns -> Simple Column (I add basic demographic columns
and the one that gives errors:"Current  TUBERCULOSIS  TREATMENT  DRUGS").
After naming, saving, generating, and downloading the export, below is what
appears in the Excel sheet. I only get this error in data exports when the
Current TUBERCULOSIS TREATMENT DRUGS column is included. Everything else I
have tried works. I would really appreciate any feedback.

-Owais Ahmed
Systems Analyst
Interactive Research and Development
Suite 508, Ibrahim Trade Tower
Main Shahrah-e-Faisal
Karachi 75350 Pakistan
Tel: +92-21-432-7697
**********************************************************************************************************************************
MDR-TB Program Identifier  Current TUBERCULOSIS TREATMENT DRUGS
12345678

Error:
"org.apache.velocity.exception.MethodInvocationException: Invocation of
method 'getCurrentDrugNames' in  class
org.openmrs.reporting.export.DataExportFunctions threw exception
java.lang.NullPointerException @
org.openmrs.reporting.export.DataExportUtil[3,168]"
 Stacktrace:
"org.apache.velocity.exception.MethodInvocationException: Invocation of
method 'getCurrentDrugNames' in  class
org.openmrs.reporting.export.DataExportFunctions threw exception
java.lang.NullPointerException @
org.openmrs.reporting.export.DataExportUtil[3,168]"
   at
org.apache.velocity.runtime.parser.node.ASTMethod.execute(ASTMethod.java:285)

   at
org.apache.velocity.runtime.parser.node.ASTReference.execute(ASTReference.java:202)

   at
org.apache.velocity.runtime.parser.node.ASTReference.render(ASTReference.java:293)

   at
org.apache.velocity.runtime.parser.node.ASTBlock.render(ASTBlock.java:72)

   at
org.apache.velocity.runtime.directive.Foreach.render(Foreach.java:448)
   at
org.apache.velocity.runtime.parser.node.ASTDirective.render(ASTDirective.java:169)

   at
org.apache.velocity.runtime.parser.node.SimpleNode.render(SimpleNode.java:317)

   at
org.apache.velocity.app.VelocityEngine.evaluate(VelocityEngine.java:356)
   at
org.apache.velocity.app.VelocityEngine.evaluate(VelocityEngine.java:228)
   at
org.openmrs.reporting.export.DataExportUtil.generateExport(DataExportUtil.java:186)

   at
org.openmrs.reporting.export.DataExportUtil.generateExport(DataExportUtil.java:122)

   at
org.openmrs.web.controller.report.export.DataExportListController.onSubmit(DataExportListController.java:120)

   at
org.springframework.web.servlet.mvc.SimpleFormController.processFormSubmission(SimpleFormController.java:267)

   at
org.springframework.web.servlet.mvc.AbstractFormController.handleRequestInternal(AbstractFormController.java:265)

   at
org.springframework.web.servlet.mvc.AbstractController.handleRequest(AbstractController.java:153)

   at
org.springframework.web.servlet.mvc.SimpleControllerHandlerAdapter.handle(SimpleControllerHandlerAdapter.java:48)

   at
org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:875)

   at
org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:809)

   at
org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:476)

   at
org.springframework.web.servlet.FrameworkServlet.doPost(FrameworkServlet.java:441)

   at javax.servlet.http.HttpServlet.service(HttpServlet.java:710)
   at javax.servlet.http.HttpServlet.service(HttpServlet.java:803)
   at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)

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

   at org.openmrs.web.OpenmrsFilter.doFilter(OpenmrsFilter.java:124)
   at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)

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

   at
org.springframework.orm.hibernate3.support.OpenSessionInViewFilter.doFilterInternal(OpenSessionInViewFilter.java:198)

   at
org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:75)

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

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

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

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

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

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

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

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

   at
org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:844)

   at
org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:583)

   at
org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:447)
   at java.lang.Thread.run(Unknown Source)
Caused by: java.lang.NullPointerException
   at
org.openmrs.reporting.export.DataExportFunctions.getCurrentDrugNames(DataExportFunctions.java:563)

   at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
   at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
   at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
   at java.lang.reflect.Method.invoke(Unknown Source)
   at
org.apache.velocity.util.introspection.UberspectImpl$VelMethodImpl.invoke(UberspectImpl.java:295)

   at
org.apache.velocity.runtime.parser.node.ASTMethod.execute(ASTMethod.java:244)

   ... 40 more

_________________________________________

To unsubscribe from OpenMRS Implementers' mailing list, send an e-mail to [hidden email] with "SIGNOFF openmrs-implement-l" in the  body (not the subject) of your e-mail.

[mailto:[hidden email]?body=SIGNOFF%20openmrs-implement-l]


_________________________________________

To unsubscribe from OpenMRS Implementers' mailing list, send an e-mail to [hidden email] with "SIGNOFF openmrs-implement-l" in the  body (not the subject) of your e-mail.

[mailto:[hidden email]?body=SIGNOFF%20openmrs-implement-l]


[hidden email] from OpenMRS Implementers' mailing list