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
警告:报表计算中 , __LOCALE__ : zh_TW, __STREAMCLOSED__ : , CMD : load_content, FORMLET : customer.frm, FORMLETNAME : customer.frm, Label地区 : 地区:, LABEL地区 : 地区:, OP : fr_form, SESSIONID : 69514, 地区 : 永顺,永圣}] :
错误代码: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
严重:报表计算中 , __LOCALE__ : zh_TW, __STREAMCLOSED__ : , CMD : load_content, FORMLET : customer.frm, FORMLETNAME : customer.frm, Label地区 : 地区:, LABEL地区 : 地区:, OP : fr_form, SESSIONID : 69514, 地区 : 永顺,永圣}] :
错误代码: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)
============================================报错日志
