java.lang.RuntimeException: 错误代码:1301 数据集配置错误Query:ORA-00942: 表或视图不存在 at com.fr.report.core.A.H.dealWithBEDSColumn(Unknown Source) at com.fr.report.core.A.m.cc_ce_array(Unknown Source) at com.fr.report.core.A.H.A(Unknown Source) at com.fr.report.core.A.H.A(Unknown Source) at com.fr.report.core.A.H.A(Unknown Source) at com.fr.report.core.A.H.A(Unknown Source) at com.fr.report.core.A.H.C(Unknown Source) at com.fr.report.core.A.H.execute4Expand(Unknown Source) at com.fr.report.core.A.H.execute(Unknown Source) at com.fr.report.worksheet.WorkSheet.execute(Unknown Source) at com.fr.report.core.sheet.AbstractWorkBookExecutor._execute(Unknown Source) at com.fr.report.core.sheet.AbstractWorkBookExecutor.execute(Unknown Source) at com.fr.main.impl.WorkBook.execute(Unknown Source) at com.fr.log.LogUtils.executeAndLogRecord(Unknown Source) at com.fr.log.LogUtils.executeAndLogRecord(Unknown Source) at com.fr.web.cache.ReportCache.getResultWorkBook(Unknown Source) at com.fr.stable.PageActor.getResultBookFromCacheIfNeed(Unknown Source) at com.fr.main.impl.WorkBookTemplateDelegate.execute(Unknown Source) at com.fr.web.core.ReportSessionIDInfor.calResultWorkBook(Unknown Source) at com.fr.web.core.ReportSessionIDInfor.initBook2Show(Unknown Source) at com.fr.web.core.ReportSessionIDInfor.getWorkBook2Show(Unknown Source) at com.fr.plugin.reportfit.ReportFitImpl.getResultWorkBook(Unknown Source) 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 com.fr.plugin.proxy.AbstractPluginInvocationHandler.invoke(Unknown Source) at com.fr.plugin.proxy.AbstractPluginInvocationHandler.defaultInvoke(Unknown Source) at com.fr.plugin.proxy.CloseableInvocationHandler.invoke(Unknown Source) at com.sun.proxy.$Proxy14.getResultWorkBook(Unknown Source) at com.fr.web.core.ReportSessionIDInfor.getResultWorkBook(Unknown Source) at com.fr.web.core.ReportSessionIDInfor.createPageSetChain(Unknown Source) at com.fr.web.core.ReportSessionIDInfor.getReportPage(Unknown Source) at com.fr.web.core.A.FC.A(Unknown Source) at com.fr.web.core.A.FC.A(Unknown Source) at com.fr.web.core.A.tB.A(Unknown Source) at com.fr.web.core.A.HB.actionCMD(Unknown Source) at com.fr.web.core.WebActionsDispatcher.dealForActionCMD(Unknown Source) at com.fr.web.core.WebActionsDispatcher.dealForActionDefaultCmd(Unknown Source) at com.fr.web.core.A.qB.process(Unknown Source) at com.fr.web.core.ReportDispatcher.dealWithOp(Unknown Source) at com.fr.web.core.ReportDispatcher.dealWeblet(Unknown Source) at com.fr.web.core.ReportDispatcher.dealWithRequest(Unknown Source) at com.fr.web.BaseServlet.doGet(Unknown Source) at javax.servlet.http.HttpServlet.service(HttpServlet.java:596) at javax.servlet.http.HttpServlet.service(HttpServlet.java:689) at org.mortbay.jetty.servlet.ServletHolder.handle(ServletHolder.java:428) at org.mortbay.jetty.servlet.WebApplicationHandler.dispatch(WebApplicationHandler.java:473) at org.mortbay.jetty.servlet.ServletHandler.handle(ServletHandler.java:568) at org.mortbay.http.HttpContext.handle(HttpContext.java:1530) at org.mortbay.jetty.servlet.WebApplicationContext.handle(WebApplicationContext.java:633) at org.mortbay.http.HttpContext.handle(HttpContext.java:1482) at org.mortbay.http.HttpServer.service(HttpServer.java:909) at org.mortbay.http.HttpConnection.service(HttpConnection.java:820) at org.mortbay.http.HttpConnection.handleNext(HttpConnection.java:986) at org.mortbay.http.HttpConnection.handle(HttpConnection.java:837) at org.mortbay.http.SocketListener.handleConnection(SocketListener.java:245) at org.mortbay.util.ThreadedServer.handle(ThreadedServer.java:357) at org.mortbay.util.ThreadPool$PoolThread.run(ThreadPool.java:534)Caused by: com.fr.general.data.TableDataException: 错误代码:1301 数据集配置错误Query:ORA-00942: 表或视图不存在 at com.fr.data.impl.AbstractDBDataModel.initConnectionAndResultAndCheckInColumns(Unknown Source) at com.fr.data.impl.AbstractDBDataModel.getColumnCount(Unknown Source) at com.fr.data.index.AbstractIndexDataModel.getColumnCount(Unknown Source) ... 59 moreCaused by: java.sql.SQLException: ORA-00942: 表或视图不存在 at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:111) at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:330) at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:287) at oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:744) at oracle.jdbc.driver.T4CStatement.doOall8(T4CStatement.java:206) at oracle.jdbc.driver.T4CStatement.executeForDescribe(T4CStatement.java:800) at oracle.jdbc.driver.OracleStatement.executeMaybeDescribe(OracleStatement.java:1038) at oracle.jdbc.driver.T4CStatement.executeMaybeDescribe(T4CStatement.java:840) at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1133) at oracle.jdbc.driver.OracleStatement.executeQuery(OracleStatement.java:1273) at com.fr.third.org.apache.commons.dbcp.DelegatingStatement.executeQuery(DelegatingStatement.java:208) at com.fr.third.org.apache.commons.dbcp.DelegatingStatement.executeQuery(DelegatingStatement.java:208) at com.fr.data.core.db.dialect.AbstractDialect.executeQuery(Unknown Source) ... 62 more
sql:
select * from (
select 结算ID,
患者ID,
患者姓名,
患者性别,
医保费别,
医保类型,
就诊科室名称,
就诊医生姓名,
总费用,
医保统筹支付,
个人账户支付,
个人自费,
结算时间,
结算退费,
结算操作员姓名,
发票号,
医保流水号,
现金,
银联卡,
银联转账,
中信银行聚合支付
from VIEW_CHG_PAYWAY_M m
where m.医院ID = '${hosnum}'
and m.院区编号 = '${nodecode}'
and m.结算退费='结算'
${if(len(ks)=0," ","and m.就诊科室名称 = '"+ks+"'")}
${if(len(ys)=0," ","and m.就诊医生姓名 = '"+ys+"'")}
${if(len(ptid)=0," ","and m.患者ID = '"+ptid+"'")}
${if(len(sfy)=0," ","and m.结算操作员姓名 = '"+sfy+"'")}
${IF(ptname!=""," AND m.患者姓名 like'%"+ptname+"%'","")}
${IF(fapiaohao!=""," AND m.发票号 like'%"+fapiaohao+"%'","")}
and m.门诊住院='门诊'
and m.结算时间 >=
to_date('${date1}', 'yyyy-mm-dd hh24:mi:ss')
and m.结算时间 <
to_date('${date2}', 'yyyy-mm-dd hh24:mi:ss')
and m.总费用 !=0
UNION ALL
select 结算ID,
患者ID,
患者姓名,
患者性别,
医保费别,
医保类型,
就诊科室名称,
就诊医生姓名,
总费用,
医保统筹支付,
个人账户支付,
个人自费,
结算时间,
结算退费,
结算操作员姓名,
发票号,
医保流水号,
现金,
银联卡,
银联转账,
中信银行聚合支付
from VIEW_CHG_PAYWAY_M m
where m.医院ID = '${hosnum}'
and m.院区编号 = '${nodecode}'
and m.结算退费='退费'
${if(len(ks)=0," ","and m.就诊科室名称 = '"+ks+"'")}
${if(len(ys)=0," ","and m.就诊医生姓名 = '"+ys+"'")}
${if(len(ptid)=0," ","and m.患者ID = '"+ptid+"'")}
${if(len(sfy)=0," ","and m.结算操作员姓名 = '"+sfy+"'")}
${IF(ptname!=""," AND m.患者姓名 like'%"+ptname+"%'","")}
${IF(fapiaohao!=""," AND m.发票号 like'%"+fapiaohao+"%'","")}
and m.门诊住院='门诊'
and m.结算时间 >=
to_date('${date1}', 'yyyy-mm-dd hh24:mi:ss')
and m.结算时间 <
to_date('${date2}', 'yyyy-mm-dd hh24:mi:ss')
and m.总费用 !=0 ) aaa
order by ${columns} ${sort}