OSCARMcMaster / Bugs / #2141 Invoice Reports Not Working

#2141 Invoice Reports Not Working

Milestone: jan-2013-trunk

Status: closed-fixed

Owner: Marc Dumontier

Labels: None

Priority: 5

Updated: 2015-08-31

Created: 2013-01-21

Creator: Krzysztof Adamczyk

Private: No

OSCAR build #1362

HTTP Status 500 -
type Exception report
message
description The server encountered an internal error () that prevented it from fulfilling this request.
exception
javax.servlet.ServletException: org.apache.jasper.JasperException: An exception occurred processing JSP page /billing/CA/ON/billStatus.jsp at line 46

43: OscarProperties props = OscarProperties.getInstance();
44: if(props.getProperty("isNewONbilling", "").equals("true")) {
45: %>
46: <jsp:forward page="billingONStatus.jsp" />
47: <% } %>
48: <%
49: ProviderData pd = new ProviderData();

Stacktrace:
org.oscarehr.util.DbConnectionFilter.doFilter(DbConnectionFilter.java:69)
org.oscarehr.common.printing.PrivacyStatementAppendingFilter.doFilter(PrivacyStatementAppendingFilter.java:107)
org.oscarehr.util.ProblemCheckFilter.doFilter(ProblemCheckFilter.java:194)
org.oscarehr.util.ResponseDefaultsFilter.doFilter(ResponseDefaultsFilter.java:109)
root cause
org.apache.jasper.JasperException: An exception occurred processing JSP page /billing/CA/ON/billStatus.jsp at line 46

114:
115: List pList = isTeamBillingOnly
116: ? (Vector)(new JdbcBillingPageUtil()).getCurTeamProviderStr((String) session.getAttribute("user"))
117: : (Vector)(new JdbcBillingPageUtil()).getCurProviderStr();
118:
119: BillingStatusPrep sObj = new BillingStatusPrep();
120: List bList = null;

Stacktrace:
org.apache.jasper.servlet.JspServletWrapper.handleJspException(JspServletWrapper.java:521)
org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:430)
org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:313)
org.apache.jasper.servlet.JspServlet.service(JspServlet.java:260)
javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
org.apache.jasper.runtime.PageContextImpl.doForward(PageContextImpl.java:709)
org.apache.jasper.runtime.PageContextImpl.forward(PageContextImpl.java:680)
org.apache.jsp.billing.CA.ON.billStatus_jsp._jspService(billStatus_jsp.java:90)
org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:70)
javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:388)
org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:313)
org.apache.jasper.servlet.JspServlet.service(JspServlet.java:260)
javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
oscar.oscarSecurity.LoginFilter.doFilter(LoginFilter.java:189)
net.sf.cookierevolver.servlet.CRFilterImpl.doFilter(CRFilterImpl.java:60)
org.displaytag.filter.ResponseOverrideFilter.doFilter(ResponseOverrideFilter.java:125)
org.oscarehr.util.LoggedInUserFilter.doFilter(LoggedInUserFilter.java:60)
org.oscarehr.util.DbConnectionFilter.doFilter(DbConnectionFilter.java:66)
org.oscarehr.common.printing.PrivacyStatementAppendingFilter.doFilter(PrivacyStatementAppendingFilter.java:107)
org.oscarehr.util.ProblemCheckFilter.doFilter(ProblemCheckFilter.java:194)
org.oscarehr.util.ResponseDefaultsFilter.doFilter(ResponseDefaultsFilter.java:109)
root cause
java.lang.ClassCastException: java.util.ArrayList cannot be cast to java.util.Vector
org.apache.jsp.billing.CA.ON.billingONStatus_jsp._jspService(billingONStatus_jsp.java:271)
org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:70)
javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:388)
org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:313)
org.apache.jasper.servlet.JspServlet.service(JspServlet.java:260)
javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
org.apache.jasper.runtime.PageContextImpl.doForward(PageContextImpl.java:709)
org.apache.jasper.runtime.PageContextImpl.forward(PageContextImpl.java:680)
org.apache.jsp.billing.CA.ON.billStatus_jsp._jspService(billStatus_jsp.java:90)
org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:70)
javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:388)
org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:313)
org.apache.jasper.servlet.JspServlet.service(JspServlet.java:260)
javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
oscar.oscarSecurity.LoginFilter.doFilter(LoginFilter.java:189)
net.sf.cookierevolver.servlet.CRFilterImpl.doFilter(CRFilterImpl.java:60)
org.displaytag.filter.ResponseOverrideFilter.doFilter(ResponseOverrideFilter.java:125)
org.oscarehr.util.LoggedInUserFilter.doFilter(LoggedInUserFilter.java:60)
org.oscarehr.util.DbConnectionFilter.doFilter(DbConnectionFilter.java:66)
org.oscarehr.common.printing.PrivacyStatementAppendingFilter.doFilter(PrivacyStatementAppendingFilter.java:107)
org.oscarehr.util.ProblemCheckFilter.doFilter(ProblemCheckFilter.java:194)
org.oscarehr.util.ResponseDefaultsFilter.doFilter(ResponseDefaultsFilter.java:109)
note The full stack trace of the root cause is available in the Apache Tomcat/6.0.35 logs.
Apache Tomcat/6.0.35

1 Attachments

Master_Invoice Report.png

Discussion

Sarah Allen - 2013-01-21

milestone: --> jan-2013-trunk
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:

Marc Dumontier - 2013-01-21

assigned_to: nobody --> ngoupinets

status: open --> open-accepted
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:

Nick - 2013-01-21

status: open-accepted --> open-fixed
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:

Nick - 2013-01-21

Fixed

https://source.oscartools.org:8080/#change,5019

If you would like to refer to this comment somewhere else in this project, copy and paste the following link:

Sarah Allen - 2013-01-31

Even though there aren't any errors, performing a search on the Invoice Reports page doesn't ever seem to come up with any results.

If you would like to refer to this comment somewhere else in this project, copy and paste the following link:

Nick - 2013-01-31

status: open-fixed --> open-accepted
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:

Marc Dumontier - 2013-01-31

assigned_to: ngoupinets --> hexbinary
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:

Marc Dumontier - 2013-01-31

already started on this one nick..
i'll assign you a couple.

If you would like to refer to this comment somewhere else in this project, copy and paste the following link:

Marc Dumontier - 2013-01-31

https://source.oscartools.org:8080/5156

this should fix the stack traces anyway.i'm not sure if it's pulling data the way it should

If you would like to refer to this comment somewhere else in this project, copy and paste the following link:

Marc Dumontier - 2013-01-31

status: open-accepted --> open-fixed
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:

Darryl Hui - 2013-02-01

Just tried to produce an invoice report using Build #1419 and it now throws the following error:

Hibernate: select provider0_.provider_no as provider1_875_, provider0_.comments as comments875_, provider0_.phone as phone875_, provider0_.billing_no as billing4_875_, provider0_.work_phone as work5_875_, provider0_.address as address875_, provider0_.team as team875_, provider0_.status as status875_, provider0_.last_name as last9_875_, provider0_.provider_type as provider10_875_, provider0_.sex as sex875_, provider0_.ohip_no as ohip12_875_, provider0_.specialty as specialty875_, provider0_.dob as dob875_, provider0_.hso_no as hso15_875_, provider0_.provider_activity as provider16_875_, provider0_.first_name as first17_875_, provider0_.rma_no as rma18_875_, provider0_.signed_confidentiality as signed19_875_, provider0_.email as email875_, provider0_.practitionerNo as practit21_875_, provider0_.title as title875_, provider0_.lastUpdateUser as lastUpd23_875_, provider0_.lastUpdateDate as lastUpd24_875_ from provider provider0_ where provider0_.ohip_no<>'' and provider0_.status='1' order by provider0_.last_name
2013-02-01 12:09:08,817 ERROR [PARSER:56] <AST>: unexpected end of subtree
2013-02-01 12:09:08,818 ERROR [JdbcBillingReviewImpl:173] error
java.lang.IllegalArgumentException: org.hibernate.hql.ast.QuerySyntaxException: unexpected end of subtree [FROM org.oscarehr.common.model.BillingONCHeader1 ch1, org.oscarehr.common.model.BillingONItem bi WHERE ch1.id = bi.ch1Id AND bi.status != 'D' AND ch1.payProgram in (:payPrograms0_, :payPrograms1_, :payPrograms2_, :payPrograms3_, :payPrograms4_, :payPrograms5_, :payPrograms6_, :payPrograms7_, :payPrograms8_, :payPrograms9_) AND ch1.billingDate >= :startDate AND ch1.billingDate <= :endDate AND ch1.demographicNo = :demographicNo AND bi.serviceCode in () ORDER BY ch1.billingDate, ch1.billingTime]
at org.hibernate.ejb.AbstractEntityManagerImpl.throwPersistenceException(AbstractEntityManagerImpl.java:601)
at org.hibernate.ejb.QueryImpl.getResultList(QueryImpl.java:76)
at org.oscarehr.common.dao.BillingONCHeader1Dao.findByMagic2(BillingONCHeader1Dao.java:630)
at org.oscarehr.common.dao.BillingONCHeader1Dao$$FastClassByCGLIB$$9c9858b1.invoke(<generated>)
at net.sf.cglib.proxy.MethodProxy.invoke(MethodProxy.java:191)
at org.springframework.aop.framework.Cglib2AopProxy$CglibMethodInvocation.invokeJoinpoint(Cglib2AopProxy.java:689)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:150)
at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:110)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)
at org.springframework.aop.framework.Cglib2AopProxy$DynamicAdvisedInterceptor.intercept(Cglib2AopProxy.java:622)
at org.oscarehr.common.dao.BillingONCHeader1Dao$$EnhancerByCGLIB$$a35e6bb9.findByMagic2(<generated>)
at oscar.oscarBilling.ca.on.data.JdbcBillingReviewImpl.getBill(JdbcBillingReviewImpl.java:141)
at oscar.oscarBilling.ca.on.pageUtil.BillingStatusPrep.getBills(BillingStatusPrep.java:69)
at org.apache.jsp.billing.CA.ON.billingONStatus_jsp._jspService(billingONStatus_jsp.java:255)
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:377)
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:189)
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:66)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at org.oscarehr.common.printing.PrivacyStatementAppendingFilter.doFilter(PrivacyStatementAppendingFilter.java:118)
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:194)
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:109)
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.valves.AccessLogValve.invoke(AccessLogValve.java:555)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:298)
at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:852)
at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:588)
at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:489)
at java.lang.Thread.run(Thread.java:662)
Caused by: org.hibernate.hql.ast.QuerySyntaxException: unexpected end of subtree [FROM org.oscarehr.common.model.BillingONCHeader1 ch1, org.oscarehr.common.model.BillingONItem bi WHERE ch1.id = bi.ch1Id AND bi.status != 'D' AND ch1.payProgram in (:payPrograms0_, :payPrograms1_, :payPrograms2_, :payPrograms3_, :payPrograms4_, :payPrograms5_, :payPrograms6_, :payPrograms7_, :payPrograms8_, :payPrograms9_) AND ch1.billingDate >= :startDate AND ch1.billingDate <= :endDate AND ch1.demographicNo = :demographicNo AND bi.serviceCode in () ORDER BY ch1.billingDate, ch1.billingTime]
at org.hibernate.hql.ast.QuerySyntaxException.convert(QuerySyntaxException.java:54)
at org.hibernate.hql.ast.QuerySyntaxException.convert(QuerySyntaxException.java:47)
at org.hibernate.hql.ast.ErrorCounter.throwQueryException(ErrorCounter.java:82)
at org.hibernate.hql.ast.QueryTranslatorImpl.analyze(QueryTranslatorImpl.java:258)
at org.hibernate.hql.ast.QueryTranslatorImpl.doCompile(QueryTranslatorImpl.java:183)
at org.hibernate.hql.ast.QueryTranslatorImpl.compile(QueryTranslatorImpl.java:134)
at org.hibernate.engine.query.HQLQueryPlan.<init>(HQLQueryPlan.java:101)
at org.hibernate.engine.query.HQLQueryPlan.<init>(HQLQueryPlan.java:80)
at org.hibernate.engine.query.QueryPlanCache.getHQLQueryPlan(QueryPlanCache.java:94)
at org.hibernate.impl.AbstractSessionImpl.getHQLQueryPlan(AbstractSessionImpl.java:156)
at org.hibernate.impl.SessionImpl.list(SessionImpl.java:1140)
at org.hibernate.impl.QueryImpl.list(QueryImpl.java:102)
at org.hibernate.ejb.QueryImpl.getResultList(QueryImpl.java:67)
... 55 more

If you would like to refer to this comment somewhere else in this project, copy and paste the following link:

SBek - 2015-08-31

status: open-fixed --> closed-fixed

Attachments has changed:

Diff:

--- old +++ new @@ -0,0 +1 @@ +Master_Invoice Report.png (198.8 kB; image/png)
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:

SBek - 2015-08-31

Re-tested Master build # 2585 -> invoice report is generated. Attached a screen shot.

If you would like to refer to this comment somewhere else in this project, copy and paste the following link:

Invoice Reports Not Working

open source web-based Electronic Medical Record (EMR) system

Group

Searches

Help

#2141 Invoice Reports Not Working

Discussion