| select a.*, (case when a.age_code='A_age' then a.AMT else 0 end) "1-30天", (case when a.age_code='B_age' then a.AMT else 0 end) "30-60天", (case when a.age_code='C_age' then a.AMT else 0 end) "61-90天", (case when a.age_code='D_age' then a.AMT else 0 end) "90-180天", (case when a.age_code='E_age' then a.AMT else 0 end) "180-360", (case when a.age_code='F_age' then a.AMT else 0 end) "360天以上", (case when a.age_code='Now_age' then a.AMT else 0 end) "当前", (case when a.age_code=' ' then a.AMT else 0 end) " ", (case when a.age_code='PMT' then a.AMT else 0 end) "PMT", (case when a.age_code='CM' then a.AMT else 0 end) "CM" from (SELECT decode(pou.name, 'TC_OU', '永祺（台中）', 'YONGQI_BVI', '永祺_BVI', 'YONGSHENG_BVI', '永圣_BVI', 'YSH_OU', '永圣', 'YSN_OU', '永顺', 'CZ_OU', '永祺（常州）', pou.name) name, t.*, (SELECT ra.site_number FROM apps.ra_site_uses_ALL rsu, apps.ra_addresses_ALL ra WHERE ra.address_id = rsu.address_id and rsu.site_use_id = t.customer_site_use_id) customer_code FROM apps.YQ_ar_payment_schedules9_v t, HR_ALL_ORGANIZATION_UNITS POU where org_id = pou.ORGANIZATION_ID) a where 1=1 ${if (len(地区)==0,"","and name in ('"+地区+"')")} -------------------------------------------------------------------------------------------------这是sql语句 2017-09-22 08:35:12 警告:Death cycle exists at calculating widgets:地区->地区 at com.fr.form.main.FormConfig.setWidgetValue(Unknown Source) at com.fr.form.main.FormConfig.setWidgetValue(Unknown Source) at com.fr.form.main.FormConfig.dealWithWidgetData(Unknown Source) at com.fr.form.main.FormConfig.dealWithWidgetData(Unknown Source) at com.fr.form.main.Form.initWidgetData(Unknown Source) at com.fr.form.main.Form.createParaJSONConfig(Unknown Source) at com.fr.form.stable.DefaultFormActor.initMap4Form(Unknown Source) at com.fr.form.stable.DefaultFormActor.writeHtml(Unknown Source) at com.fr.form.stable.DefaultFormActor.dealWithFormData(Unknown Source) at com.fr.web.core.reserve.FormletDealWith.dealWithFormlet(Unknown Source) at com.fr.web.weblet.Formlet.dealWeblet(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) 2017-09-22 08:35:14 正常:关闭Session:67842 2017-09-22 08:35:18 正常:开始计算报表 2017-09-22 08:35:18 正常:SQL TIME:208ms! 2017-09-22 08:35:18 警告:报表计算中[Name : customer.frm] [Parameter : {_ : 1506040518195[java.lang.String], __LOCALE__ : zh_TW[java.util.Locale], __STREAMCLOSED__ : [java.lang.String], CMD : load_content[java.lang.String], FORMLET : customer.frm[java.lang.String], FORMLETNAME : customer.frm[java.lang.String], Label地区 : 地区:[java.lang.String], LABEL地区 : 地区:[java.lang.String], OP : fr_form[java.lang.String], SESSIONID : 69514[java.lang.String], 地区 : 永顺,永圣[com.fr.general.FArray]}][Type : form] : 错误代码:1301 数据集配置错误 Query: ORA-00933: SQL 命令未正确结束 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) at com.fr.report.core.A.J.dealWithBEDSColumn(Unknown Source) at com.fr.report.core.A.n.cc_ce_array(Unknown Source) at com.fr.report.core.A.J.A(Unknown Source) at com.fr.report.core.A.J.A(Unknown Source) at com.fr.report.core.A.J.A(Unknown Source) at com.fr.report.core.A.J.A(Unknown Source) at com.fr.report.core.A.J.A(Unknown Source) at com.fr.report.core.A.J.C(Unknown Source) at com.fr.report.core.A.J.execute4Expand(Unknown Source) at com.fr.report.core.A.B.A.execute4Expand(Unknown Source) at com.fr.report.core.sheet.SequenceExecutor.execute(Unknown Source) at com.fr.report.core.A.B.A.A(Unknown Source) at com.fr.report.core.A.B.A.B(Unknown Source) at com.fr.report.worksheet.FormElementCase.getResultBook(Unknown Source) at com.fr.report.worksheet.FormElementCase.executeAll(Unknown Source) at com.fr.form.main.Form.executeElementCases(Unknown Source) at com.fr.web.core.A.KC.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.WebActionsDispatcher.dealForActionCMD(Unknown Source) at com.fr.web.core.A.FA.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) 2017-09-22 08:35:18 严重:报表计算中[Name : customer.frm] [Parameter : {_ : 1506040518195[java.lang.String], __LOCALE__ : zh_TW[java.util.Locale], __STREAMCLOSED__ : [java.lang.String], CMD : load_content[java.lang.String], FORMLET : customer.frm[java.lang.String], FORMLETNAME : customer.frm[java.lang.String], Label地区 : 地区:[java.lang.String], LABEL地区 : 地区:[java.lang.String], OP : fr_form[java.lang.String], SESSIONID : 69514[java.lang.String], 地区 : 永顺,永圣[com.fr.general.FArray]}][Type : form] : 错误代码:1301 数据集配置错误 Query: ORA-00933: SQL 命令未正确结束 at com.fr.report.core.A.J.dealWithBEDSColumn(Unknown Source) at com.fr.report.core.A.n.cc_ce_array(Unknown Source) at com.fr.report.core.A.J.A(Unknown Source) at com.fr.report.core.A.J.A(Unknown Source) at com.fr.report.core.A.J.A(Unknown Source) at com.fr.report.core.A.J.A(Unknown Source) at com.fr.report.core.A.J.A(Unknown Source) at com.fr.report.core.A.J.C(Unknown Source) at com.fr.report.core.A.J.execute4Expand(Unknown Source) at com.fr.report.core.A.B.A.execute4Expand(Unknown Source) at com.fr.report.core.sheet.SequenceExecutor.execute(Unknown Source) at com.fr.report.core.A.B.A.A(Unknown Source) at com.fr.report.core.A.B.A.B(Unknown Source) at com.fr.report.worksheet.FormElementCase.getResultBook(Unknown Source) at com.fr.report.worksheet.FormElementCase.executeAll(Unknown Source) at com.fr.form.main.Form.executeElementCases(Unknown Source) at com.fr.web.core.A.KC.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.WebActionsDispatcher.dealForActionCMD(Unknown Source) at com.fr.web.core.A.FA.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) ============================================报错日志 |
