Ubuntu 12.04, OSCAR 12_1 deb 120, go to Report>17. Form Report>1 Pending List>Report in HTML button.
gives a null pointer exception in the browser and the below in catalina.out. When I look up the error the most common problem is a missing "FROM" clause in the SQL.
Where can I find this query to test it?
Thanks in advance.
2013-06-02 16:13:16,314 ERROR [DBHelp:65] Error
java.sql.SQLException: null, message from server: "Unknown column 'demographic.last_name' in 'field list'"
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:1905)
at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1109)
at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1203)
at com.mysql.jdbc.MysqlIO.sqlQuery(MysqlIO.java:1164)
at com.mysql.jdbc.Connection.execSQL(Connection.java:2087)
at com.mysql.jdbc.Connection.execSQL(Connection.java:2037)
at com.mysql.jdbc.Statement.executeQuery(Statement.java:1156)
at org.apache.commons.dbcp.DelegatingStatement.executeQuery(DelegatingStatement.java:208)
at oscar.oscarDB.DBHandler.GetSQL(DBHandler.java:57)
at oscar.oscarDB.DBHandler.GetSQL(DBHandler.java:45)
at oscar.login.DBHelp.searchDBRecord(DBHelp.java:63)
at oscar.oscarReport.data.RptReportCreator.query(RptReportCreator.java:179)
at oscar.oscarReport.pageUtil.RptDownloadCSVServlet.formReport(RptDownloadCSVServlet.java:120)
at oscar.oscarReport.pageUtil.RptDownloadCSVServlet.service(RptDownloadCSVServlet.java:60)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at org.apache.catalina.core.ApplicationDispatcher.invoke(ApplicationDispatcher.java:646)
at org.apache.catalina.core.ApplicationDispatcher.processRequest(ApplicationDispatcher.java:436)
at org.apache.catalina.core.ApplicationDispatcher.doForward(ApplicationDispatcher.java:374)
at org.apache.catalina.core.ApplicationDispatcher.forward(ApplicationDispatcher.java:302)
at org.apache.jasper.runtime.PageContextImpl.doForward(PageContextImpl.java:709)
at org.apache.jasper.runtime.PageContextImpl.forward(PageContextImpl.java:680)
at org.apache.jsp.report.reportResult_jsp._jspService(reportResult_jsp.java:72)
at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:70)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
at org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:388)
at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:313)
at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:260)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at oscar.oscarSecurity.LoginFilter.doFilter(LoginFilter.java:127)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at net.sf.cookierevolver.servlet.CRFilterImpl.doFilter(CRFilterImpl.java:60)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at org.displaytag.filter.ResponseOverrideFilter.doFilter(ResponseOverrideFilter.java:125)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at org.oscarehr.util.LoggedInUserFilter.doFilter(LoggedInUserFilter.java:60)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at org.oscarehr.util.DbConnectionFilter.doFilter(DbConnectionFilter.java:65)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at org.oscarehr.util.ResponseDefaultsFilter.doFilter(ResponseDefaultsFilter.java:69)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at org.oscarehr.util.ProblemCheckFilter.doFilter(ProblemCheckFilter.java:188)
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:191)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)
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:293)
at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:859)
at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:602)
at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:489)
at java.lang.Thread.run(Thread.java:679)
2013-06-02 16:13:16,316 ERROR [RptDownloadCSVServlet:142] service() - form report
Hello Michael.
Just looking into this issue, and I'm able to recreate it as well,
Do you have any info on how this should actually work. Did it used to work and is now broken, or has it ever worked. Any info appreciated.
Thanks,
Vic
Hi Vic,
I'm sorry, I've never used the feature before. One of my users tried it as they need a pending list. my assumption is that if you choose report in HTML you see the report on the screen, and if you choose CSV it exports a file with the report contents (in fact it exports an empty file today).
Hello Michael.
Would it be possible to work with your user to find out how it should work, and possibly provide data, or steps to create data that would produce a valid report. I can see that it fails, but it is not clear what should occur as I have not data or examples.
Thanks,
Vic
Hi Victor,
I notice the status on this bug is "Pending" but the resolution is "Accepted" Is there a way to know when this will be pushed to Trunk?
Hello Michael.
Status pending is due to waiting on information.
If you will read comment I left on 2012-06-11, you will see that I need further information to proceed. I need a valid scenario and data set to have this work correctly so that I know how to fix it.
Victor, thanks to Peter HC we have an old manual at least with instructions on how this function should work. Please let me know if this is enough to go on to apply this fix:
FORM REPORT
The Form Report's features will give you the ability to create study reports on any of the
forms from the Encounter screen. Each form report needs to have captions added to the
database field names, as well as the fields of the database you would like in the report
selected. The current configured form reports at present are for the BC Antenatal Record, Labour and Birth Record and the Newborn Record.
1. Click on Form Report
2. Click on the desired report
3. Click on the filter limitations you would like
4. Select the desired date range with the little calendar buttons
5. Click on either the [Report in HTML] or [Report in CSV]
•
Report in HTML for a report that will display in OSCAR
•
Report in CSV for a report that will display in Excel
•1 in the report means = yes; 0 in the report means = no
THE CSV REPORT
1. If the CSV report does not automatically open in Excel, save the file to your hard
drive
2. Open the Excel program
3. Click DATA & then GET EXTERNAL DATA
4. Click IMPORT TEXT FILE
5. On the FILE of TYPE dropdown and select ALL FILES
6. Find the file you saved to the hard drive & double click on it
7. Under [Original File Type] it should be clicked on [Delimited]
8. Click the NEXT button & TAB should be clicked off under [Delimiters]
9. Click the NEXT button & under [Comma Data Format] GENERAL should be
checked
10. Click FINISH
•In the next box you want it to IMPORT DATA into EXISTING WORKSHEET
•
Your report will flow into Excel in columns and rows
•
You can now manipulate your data as desired
TO EDIT FIELDS IN THE REPORT
1. After selecting a report, click on CONFIGURATION on the upper right screen
2. The column to the right are the fields of the form that are currently selected for the
report
3. The column to the left are fields in the selected form database that have NOT been
used in the report currently
•
NOTE: if you want to use any of the database fields on the left you MUST add captions to the fields or you will get an error when running the report.
ADD/EDIT CAPTION
1. To edit any of the field captions, click on the ADD CAPTION text link at the bottom
of the left column
Fields that already have captions are yellow
2. Type the desired heading for the field in the left hand box and click on the ADD/
UPDATE button opposite the database field name
3. When finished click on the BACK to the CONFIGURATION link on the upper right
on the screen
SELECTING THE FIELDS FOR THE REPORT
1. Select a field in the left hand column and click on the ADD button to move the database field into the right column which will be in the report
2. To take field names out of the report click on the field in the right column and click
on the DELETE button to move it back to the right column
CHANGE THE ORDER OF THE FIELDS IN THE REPORT
In the same window as above:
1. Click on the CHANGE ORDER word link at the bottom of the right column
2. Click on the tick box to the left of the field you want to move and click on the MOVE
HERE button opposite where you want the field to move to
3. When finished click on the BACK to the CONFIGURATION word link
ADD FIELDS FROM THE MASTER DEMOGRAPHIC AREA TO THE REPORT
1. Click on the PATIENT PROFILE word link above the left column
a. These are the field from the Master Demographic screen
2. The captions can also be changed in these by clicking on the CAPTION word link
3. To go back to the form database fields, click on the FORM word link at the top of the
column