I have an installation of OpenMRS 1.9.7. I am trying to create a new SQL Data Set Definition. At the point of defining Parameters, clicking on the [+] Add link opens an empty window and does not display the controls for defining the parameters. I ave tried to look at logs but OpenMRS does not seem to be logging what is happening at this point.
Any pointers?
Which version of the reporting module are you using?
Version 0.8.2.
Here is a log from catalina that might be useful:
SEVERE: IOException while loading persisted sessions: java.io.WriteAbortedException: writing aborted; java.io.NotSerializableException: org.openmrs.module.reporting.report.definition.ReportDefinition java.io.WriteAbortedException: writing aborted; java.io.NotSerializableException: org.openmrs.module.reporting.report.definition.ReportDefinition at java.io.ObjectInputStream.readObject0(Unknown Source) at java.io.ObjectInputStream.skipCustomData(Unknown Source) at java.io.ObjectInputStream.readSerialData(Unknown Source) at java.io.ObjectInputStream.readOrdinaryObject(Unknown Source) at java.io.ObjectInputStream.readObject0(Unknown Source) at java.io.ObjectInputStream.readObject(Unknown Source) at org.apache.catalina.session.StandardSession.readObject(StandardSession.java:1506) at org.apache.catalina.session.StandardSession.readObjectData(StandardSession.java:999) at org.apache.catalina.session.StandardManager.doLoad(StandardManager.java:397) at org.apache.catalina.session.StandardManager.load(StandardManager.java:315) at org.apache.catalina.session.StandardManager.start(StandardManager.java:640) at org.apache.catalina.core.ContainerBase.setManager(ContainerBase.java:448) at org.apache.catalina.core.StandardContext.start(StandardContext.java:4705) at org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:803) at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:780) at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:583) at org.apache.catalina.startup.HostConfig.deployDescriptor(HostConfig.java:676) at org.apache.catalina.startup.HostConfig.deployDescriptors(HostConfig.java:602) at org.apache.catalina.startup.HostConfig.deployApps(HostConfig.java:503) at org.apache.catalina.startup.HostConfig.start(HostConfig.java:1322) at org.apache.catalina.startup.HostConfig.lifecycleEvent(HostConfig.java:325) at org.apache.catalina.util.LifecycleSupport.fireLifecycleEvent(LifecycleSupport.java:142) at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1069) at org.apache.catalina.core.StandardHost.start(StandardHost.java:822) at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1061) at org.apache.catalina.core.StandardEngine.start(StandardEngine.java:463) at org.apache.catalina.core.StandardService.start(StandardService.java:525) at org.apache.catalina.core.StandardServer.start(StandardServer.java:761) at org.apache.catalina.startup.Catalina.start(Catalina.java:595) 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.catalina.startup.Bootstrap.start(Bootstrap.java:289) at org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:414) Caused by: java.io.NotSerializableException: org.openmrs.module.reporting.report.definition.ReportDefinition at java.io.ObjectOutputStream.writeObject0(Unknown Source) at java.io.ObjectOutputStream.writeObject(Unknown Source) at java.util.HashMap.writeObject(Unknown Source) at sun.reflect.GeneratedMethodAccessor1054.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source) at java.lang.reflect.Method.invoke(Unknown Source) at java.io.ObjectStreamClass.invokeWriteObject(Unknown Source) at java.io.ObjectOutputStream.writeSerialData(Unknown Source) at java.io.ObjectOutputStream.writeOrdinaryObject(Unknown Source) at java.io.ObjectOutputStream.writeObject0(Unknown Source) at java.io.ObjectOutputStream.writeObject(Unknown Source) at org.apache.catalina.session.StandardSession.writeObject(StandardSession.java:1586) at org.apache.catalina.session.StandardSession.writeObjectData(StandardSession.java:1016) at org.apache.catalina.session.StandardManager.doUnload(StandardManager.java:527) at org.apache.catalina.session.StandardManager.unload(StandardManager.java:467) at org.apache.catalina.session.StandardManager.stop(StandardManager.java:671) at org.apache.catalina.core.StandardContext.stop(StandardContext.java:4956) at org.apache.catalina.core.ContainerBase.removeChild(ContainerBase.java:934) at org.apache.catalina.startup.HostConfig.undeployApps(HostConfig.java:1363) at org.apache.catalina.startup.HostConfig.stop(HostConfig.java:1335) at org.apache.catalina.startup.HostConfig.lifecycleEvent(HostConfig.java:327) at org.apache.catalina.util.LifecycleSupport.fireLifecycleEvent(LifecycleSupport.java:142) at org.apache.catalina.core.ContainerBase.stop(ContainerBase.java:1102) at org.apache.catalina.core.ContainerBase.stop(ContainerBase.java:1114) at org.apache.catalina.core.StandardEngine.stop(StandardEngine.java:468) at org.apache.catalina.core.StandardService.stop(StandardService.java:604) at org.apache.catalina.core.StandardServer.stop(StandardServer.java:795) at org.apache.catalina.startup.Catalina.stopServer(Catalina.java:408) 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.catalina.startup.Bootstrap.stopServer(Bootstrap.java:338) at org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:416)
For stack traces, use services like pastebin.com Can you use the latest released version of the reporting module?
The interesting thing is that we have other implementations of OpenMRS 1.9.7 that are using this version of Reporting Module and they are working fine. I am just wondering if it could be something either within or outside of OpenMRS that is causing this to happen?
@eddiemu, that stack trace is a red herring - it is not anything you need to worry about (it has to do with session persistence across system restarts, and the fact that report data is in your web session).
If you are not seeing anything in the server log, and especially if you are experiencing strange behavior in the UI, I would check the browser error console. Go to the page that is causing you problems, and (in Chrome) in the browser window Right Click -> Inspect, click on the “Console” tab, and see if there are any errors reported there.
Mike
Hi Mike,
Thanks for that pointer. I have attached the error message we get when we try to add the Parameters as shown by Chrome.
Installing a lower version of Tomcat solved the problem (from version 6.0.53 down to 6.0.29).
