请不要忽略下面的这些异常，往往在最下面能够发现对你有用的信息，或将它发给能够帮助你的人。
[SOFA-052009U]：报表[NG_JJ_YZ_MRJZB]运行时错误，在当前的上下文环境中无法执行此报表。
处理方法：
一般是由于模板配置错误，或者数据库连接问题，或者参数不合法，查看异常详细信息，修正错误。
at com.yss.sofa.report.api.renderer.RendererBO.renderReport(RendererBO.java:161)
at com.yss.sofa.report.api.renderer.RendererBO$$FastClassByCGLIB$$93028062_4.invoke(<generated>)
at net.sf.cglib.proxy.MethodProxy.invoke(MethodProxy.java:191)
at org.springframework.aop.framework.Cglib2AopProxy$DynamicAdvisedInterceptor.intercept(Cglib2AopProxy.java:617)
at com.yss.sofa.report.api.renderer.RendererBO$$EnhancerByCGLIB$$489f7b4d.renderReport(<generated>)
at com.yss.sofa.report.api.renderer.RendererController.renderReport(RendererController.java:68)
at sun.reflect.GeneratedMethodAccessor1177.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:498)
at org.springframework.web.bind.annotation.support.HandlerMethodInvoker.invokeHandlerMethod(HandlerMethodInvoker.java:176)
at org.springframework.web.servlet.mvc.annotation.AnnotationMethodHandlerAdapter.invokeHandlerMethod(AnnotationMethodHandlerAdapter.java:426)
at org.springframework.web.servlet.mvc.annotation.AnnotationMethodHandlerAdapter.handle(AnnotationMethodHandlerAdapter.java:414)
at org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:790)
at org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:719)
at org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:644)
at org.springframework.web.servlet.FrameworkServlet.doPost(FrameworkServlet.java:560)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:681)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:764)
at com.yss.sofa.container.web.dm.servlet.BundleDispatcherServlet.service(BundleDispatcherServlet.java:203)
at org.eclipse.equinox.http.servlet.internal.ServletRegistration.service(ServletRegistration.java:79)
at org.eclipse.equinox.http.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:57)
at com.yss.sofa.container.web.model.internal.WelcomePageFilter.doFilter(WelcomePageFilter.java:100)
at org.eclipse.equinox.http.servlet.internal.FilterRegistration.doFilter(FilterRegistration.java:119)
at org.eclipse.equinox.http.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:54)
at com.yss.sofa.report.api.web.HttpApiFilter.doFilterInternal(HttpApiFilter.java:36)
at com.yss.sofa.report.api.web.HttpApiFilter.doFilter(HttpApiFilter.java:43)
at org.eclipse.equinox.http.servlet.internal.FilterRegistration.doFilter(FilterRegistration.java:119)
at org.eclipse.equinox.http.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:54)
at org.springframework.web.filter.CharacterEncodingFilter.doFilterInternal(CharacterEncodingFilter.java:88)
at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:76)
at org.eclipse.equinox.http.servlet.internal.FilterRegistration.doFilter(FilterRegistration.java:119)
at org.eclipse.equinox.http.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:54)
at org.eclipse.equinox.http.servlet.internal.ProxyServlet.processAlias(ProxyServlet.java:166)
at org.eclipse.equinox.http.servlet.internal.ProxyServlet.service(ProxyServlet.java:106)
at org.eclipse.equinox.http.servlet.HttpServiceServlet.service(HttpServiceServlet.java:35)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:764)
at com.yss.sofa.container.launcher.servlet.HttpDispatcherServlet.service(HttpDispatcherServlet.java:111)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:764)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:227)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162)
at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:53)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:189)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:197)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:97)
at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:541)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:92)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:135)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:92)
at org.apache.catalina.valves.AbstractAccessLogValve.invoke(AbstractAccessLogValve.java:687)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:78)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:360)
at org.apache.coyote.http11.Http11Processor.service(Http11Processor.java:399)
at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:65)
at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:890)
at org.apache.tomcat.util.net.Nio2Endpoint$SocketProcessor.doRun(Nio2Endpoint.java:1701)
at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:49)
at org.apache.tomcat.util.net.AbstractEndpoint.processSocket(AbstractEndpoint.java:1190)
at org.apache.tomcat.util.net.Nio2Endpoint$Nio2SocketWrapper$2.completed(Nio2Endpoint.java:633)
at org.apache.tomcat.util.net.Nio2Endpoint$Nio2SocketWrapper$2.completed(Nio2Endpoint.java:611)
at sun.nio.ch.Invoker.invokeUnchecked(Invoker.java:126)
at sun.nio.ch.Invoker$2.run(Invoker.java:218)
at sun.nio.ch.AsynchronousChannelGroupImpl$1.run(AsynchronousChannelGroupImpl.java:112)
at org.apache.tomcat.util.threads.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1191)
at org.apache.tomcat.util.threads.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:659)
at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)
at java.lang.Thread.run(Thread.java:750)
Caused by: java.lang.Exception: sheet[__main__].dataset[ds]执行错误
at com.yss.sofa.report.engine.core.Piston.executeMetaDatas(Piston.java:812)
at com.yss.sofa.report.engine.Engine.executeMain(Engine.java:409)
at com.yss.sofa.report.api.renderer.RendererBO.renderReport(RendererBO.java:125)
... 66 more
Caused by: java.lang.Exception: Script数据集[ds]执行失败
at com.yss.sofa.report.engine.cell.invisible.dataset.ScriptDataSetCell.execute(ScriptDataSetCell.java:103)
at com.yss.sofa.report.engine.core.Piston.executeMetaDatas(Piston.java:793)
... 68 more
Caused by: java.lang.Exception: Groovy脚本运行时错误
at com.yss.sofa.report.engine.util.ScriptUtil.execute(ScriptUtil.java:294)
at com.yss.sofa.report.engine.cell.invisible.dataset.ScriptDataSetCell.execute(ScriptDataSetCell.java:72)
... 69 more
Caused by: java.lang.Exception: 无法在数据库[ams]上执行SQL：
select a.c_port_code,
a.c_port_name,
to_char(A1.D_ASTSTAT,'yyyy-mm-dd') D_ASTSTAT,
CASE WHEN A.C_DAT_CODE in ('ASS_FOF','ASS_QDII') THEN NVL(A11.DWJZ,A111.DWJZ) ELSE A1.DWJZ END DWJZ,
CASE WHEN A.C_DAT_CODE in ('ASS_FOF','ASS_QDII') THEN NVL(A22.LJDWJZ,A222.LJDWJZ) ELSE A2.LJDWJZ END LJDWJZ,
CASE
WHEN A.C_DAT_CLS = 'CLS_HB' THEN
CASE WHEN A.C_DAT_CODE in ('ASS_FOF','ASS_QDII') THEN NVL(A33.ZCJZ2,A333.ZCJZ2) ELSE A3.ZCJZ2 END
ELSE
CASE WHEN A.C_DAT_CODE in ('ASS_FOF','ASS_QDII') THEN NVL(A33.ZCJZ1,A333.ZCJZ1) ELSE A3.ZCJZ1 END
END AS ZCJZ,
case when nvl(a4.dwjz,0)=0 then 0 else nvl(CASE WHEN A.C_DAT_CODE in ('ASS_FOF','ASS_QDII') THEN NVL(A11.DWJZ,A111.DWJZ) ELSE A1.DWJZ END,0)/nvl(a4.dwjz,0) - 1 end DWJZ1,
case when nvl(a5.dwjz,0)=0 then 0 else nvl(CASE WHEN A.C_DAT_CODE in ('ASS_FOF','ASS_QDII') THEN NVL(A11.DWJZ,A111.DWJZ) ELSE A1.DWJZ END,0)/ nvl(a5.dwjz,0) - 1 end DWJZ2,
CASE WHEN A.C_DAT_CODE in ('ASS_FOF','ASS_QDII') THEN NVL(a66.LJJZZZL,a666.LJJZZZL) ELSE a6.LJJZZZL END LJJZZZL,
to_char(b.D_RECORD_REVIEW_DATE,'yyyy-mm-dd')D_RECORD_REVIEW_DATE,
a7.n_sell_money1,
a8.n_sell_money2
from T_P_AB_PORT a
left join T_P_AB_PORT_PD b
on a.c_port_code = b.c_port_code
left join (SELECT a.c_port_code, a.d_aststat, a.C_KM_NAME DWJZ
FROM t_r_fr_aststat a
where (( a.c_port_code='SCV923' or a.c_port_code='SEN276' or a.c_port_code='SGT579' or a.c_port_code='SJF165' or a.c_port_code='SJF167' or a.c_port_code='SJF173' or a.c_port_code='SJP873' or a.c_port_code='SJU990' or a.c_port_code='SJV284' or a.c_port_code='SNH141' or a.c_port_code='SY3798' or a.c_port_code='SGU520' or a.c_port_code='SQP322' or a.c_port_code='SSD770' ))
and a.d_aststat = date
'2023-01-01'
and a.c_key_code = 'DWJZ'
and instr(a.c_km_code, '_') = 0) A1
ON A.C_PORT_CODE = A1.C_PORT_CODE
left join (SELECT a.c_port_code, a.d_aststat, a.C_KM_NAME DWJZ
FROM t_r_fr_aststat a
where (( a.c_port_code='SCV923' or a.c_port_code='SEN276' or a.c_port_code='SGT579' or a.c_port_code='SJF165' or a.c_port_code='SJF167' or a.c_port_code='SJF173' or a.c_port_code='SJP873' or a.c_port_code='SJU990' or a.c_port_code='SJV284' or a.c_port_code='SNH141' or a.c_port_code='SY3798' or a.c_port_code='SGU520' or a.c_port_code='SQP322' or a.c_port_code='SSD770' ))
and a.d_aststat = GETDAY_HDAY('CN',LAST_DAY(date'2023-01-01')+1,-1,'W')
and a.c_key_code = 'DWJZ'
and instr(a.c_km_code, '_') = 0) A11
ON A.C_PORT_CODE = A11.C_PORT_CODE
left join (SELECT a.c_port_code, a.d_aststat, a.C_KM_NAME DWJZ
FROM t_r_fr_aststat a
where (( a.c_port_code='SCV923' or a.c_port_code='SEN276' or a.c_port_code='SGT579' or a.c_port_code='SJF165' or a.c_port_code='SJF167' or a.c_port_code='SJF173' or a.c_port_code='SJP873' or a.c_port_code='SJU990' or a.c_port_code='SJV284' or a.c_port_code='SNH141' or a.c_port_code='SY3798' or a.c_port_code='SGU520' or a.c_port_code='SQP322' or a.c_port_code='SSD770' ))
and a.d_aststat = GETDAY_HDAY('CN',TRUNC(date'2023-01-01','MM'),-1,'W')
and a.c_key_code = 'DWJZ'
and instr(a.c_km_code, '_') = 0) A111
ON A.C_PORT_CODE = A11.C_PORT_CODE
left join (SELECT a.c_port_code, a.d_aststat, a.C_KM_NAME LJDWJZ
FROM t_r_fr_aststat a
where (( a.c_port_code='SCV923' or a.c_port_code='SEN276' or a.c_port_code='SGT579' or a.c_port_code='SJF165' or a.c_port_code='SJF167' or a.c_port_code='SJF173' or a.c_port_code='SJP873' or a.c_port_code='SJU990' or a.c_port_code='SJV284' or a.c_port_code='SNH141' or a.c_port_code='SY3798' or a.c_port_code='SGU520' or a.c_port_code='SQP322' or a.c_port_code='SSD770' ))
and a.d_aststat = date
'2023-01-01'
and a.c_key_code = 'LJDWJZ'
and instr(a.c_km_code, '_') = 0) A2
ON A.C_PORT_CODE = A2.C_PORT_CODE
left join (SELECT a.c_port_code, a.d_aststat, a.C_KM_NAME LJDWJZ
FROM t_r_fr_aststat a
where (( a.c_port_code='SCV923' or a.c_port_code='SEN276' or a.c_port_code='SGT579' or a.c_port_code='SJF165' or a.c_port_code='SJF167' or a.c_port_code='SJF173' or a.c_port_code='SJP873' or a.c_port_code='SJU990' or a.c_port_code='SJV284' or a.c_port_code='SNH141' or a.c_port_code='SY3798' or a.c_port_code='SGU520' or a.c_port_code='SQP322' or a.c_port_code='SSD770' ))
and a.d_aststat = GETDAY_HDAY('CN',LAST_DAY(date'2023-01-01')+1,-1,'W')
and a.c_key_code = 'LJDWJZ'
and instr(a.c_km_code, '_') = 0) A22
ON A.C_PORT_CODE = A22.C_PORT_CODE
left join (SELECT a.c_port_code, a.d_aststat, a.C_KM_NAME LJDWJZ
FROM t_r_fr_aststat a
where (( a.c_port_code='SCV923' or a.c_port_code='SEN276' or a.c_port_code='SGT579' or a.c_port_code='SJF165' or a.c_port_code='SJF167' or a.c_port_code='SJF173' or a.c_port_code='SJP873' or a.c_port_code='SJU990' or a.c_port_code='SJV284' or a.c_port_code='SNH141' or a.c_port_code='SY3798' or a.c_port_code='SGU520' or a.c_port_code='SQP322' or a.c_port_code='SSD770' ))
and a.d_aststat = GETDAY_HDAY('CN',TRUNC(date'2023-01-01','MM'),-1,'W')
and a.c_key_code = 'LJDWJZ'
and instr(a.c_km_code, '_') = 0) A222
ON A.C_PORT_CODE = A222.C_PORT_CODE
left join (SELECT a.c_port_code,
a.d_aststat,
A.N_PORT_MV ZCJZ1,
a.N_PORT_COST ZCJZ2
FROM t_r_fr_aststat a
where (( a.c_port_code='SCV923' or a.c_port_code='SEN276' or a.c_port_code='SGT579' or a.c_port_code='SJF165' or a.c_port_code='SJF167' or a.c_port_code='SJF173' or a.c_port_code='SJP873' or a.c_port_code='SJU990' or a.c_port_code='SJV284' or a.c_port_code='SNH141' or a.c_port_code='SY3798' or a.c_port_code='SGU520' or a.c_port_code='SQP322' or a.c_port_code='SSD770' ))
and a.d_aststat = date
'2023-01-01'
and a.c_key_code = 'ZCJZ'
and instr(a.c_km_code, '_') = 0) A3
ON A.C_PORT_CODE = A3.C_PORT_CODE
left join (SELECT a.c_port_code,
a.d_aststat,
A.N_PORT_MV ZCJZ1,
a.N_PORT_COST ZCJZ2
FROM t_r_fr_aststat a
where (( a.c_port_code='SCV923' or a.c_port_code='SEN276' or a.c_port_code='SGT579' or a.c_port_code='SJF165' or a.c_port_code='SJF167' or a.c_port_code='SJF173' or a.c_port_code='SJP873' or a.c_port_code='SJU990' or a.c_port_code='SJV284' or a.c_port_code='SNH141' or a.c_port_code='SY3798' or a.c_port_code='SGU520' or a.c_port_code='SQP322' or a.c_port_code='SSD770' ))
and a.d_aststat = GETDAY_HDAY('CN',LAST_DAY(date'2023-01-01')+1,-1,'W')
and a.c_key_code = 'ZCJZ'
and instr(a.c_km_code, '_') = 0) A33
ON A.C_PORT_CODE = A33.C_PORT_CODE
left join (SELECT a.c_port_code,
a.d_aststat,
A.N_PORT_MV ZCJZ1,
a.N_PORT_COST ZCJZ2
FROM t_r_fr_aststat a
where (( a.c_port_code='SCV923' or a.c_port_code='SEN276' or a.c_port_code='SGT579' or a.c_port_code='SJF165' or a.c_port_code='SJF167' or a.c_port_code='SJF173' or a.c_port_code='SJP873' or a.c_port_code='SJU990' or a.c_port_code='SJV284' or a.c_port_code='SNH141' or a.c_port_code='SY3798' or a.c_port_code='SGU520' or a.c_port_code='SQP322' or a.c_port_code='SSD770' ))
and a.d_aststat = GETDAY_HDAY('CN',TRUNC(date'2023-01-01','MM'),-1,'W')
and a.c_key_code = 'ZCJZ'
and instr(a.c_km_code, '_') = 0) A333
ON A.C_PORT_CODE = A333.C_PORT_CODE
left join (SELECT a.c_port_code, a.d_aststat, a.C_KM_NAME DWJZ
FROM t_r_fr_aststat a
where (( a.c_port_code='SCV923' or a.c_port_code='SEN276' or a.c_port_code='SGT579' or a.c_port_code='SJF165' or a.c_port_code='SJF167' or a.c_port_code='SJF173' or a.c_port_code='SJP873' or a.c_port_code='SJU990' or a.c_port_code='SJV284' or a.c_port_code='SNH141' or a.c_port_code='SY3798' or a.c_port_code='SGU520' or a.c_port_code='SQP322' or a.c_port_code='SSD770' ))
and a.d_aststat = trunc(date'2023-01-01','mm')-1
and a.c_key_code = 'DWJZ'
and instr(a.c_km_code, '_') = 0) A4
ON A.C_PORT_CODE = A4.C_PORT_CODE
left join (SELECT a.c_port_code, a.d_aststat, a.C_KM_NAME DWJZ
FROM t_r_fr_aststat a
where (( a.c_port_code='SCV923' or a.c_port_code='SEN276' or a.c_port_code='SGT579' or a.c_port_code='SJF165' or a.c_port_code='SJF167' or a.c_port_code='SJF173' or a.c_port_code='SJP873' or a.c_port_code='SJU990' or a.c_port_code='SJV284' or a.c_port_code='SNH141' or a.c_port_code='SY3798' or a.c_port_code='SGU520' or a.c_port_code='SQP322' or a.c_port_code='SSD770' ))
and a.d_aststat = trunc(date'2023-01-01','yyyy')-1
and a.c_key_code = 'DWJZ'
and instr(a.c_km_code, '_') = 0) A5
ON A.C_PORT_CODE = A5.C_PORT_CODE
left join (SELECT a.c_port_code, a.d_aststat, a.C_KM_NAME LJJZZZL
FROM t_r_fr_aststat a
where (( a.c_port_code='SCV923' or a.c_port_code='SEN276' or a.c_port_code='SGT579' or a.c_port_code='SJF165' or a.c_port_code='SJF167' or a.c_port_code='SJF173' or a.c_port_code='SJP873' or a.c_port_code='SJU990' or a.c_port_code='SJV284' or a.c_port_code='SNH141' or a.c_port_code='SY3798' or a.c_port_code='SGU520' or a.c_port_code='SQP322' or a.c_port_code='SSD770' ))
and a.d_aststat = date
'2023-01-01'
and a.c_key_code = 'LJJZZZL'
and instr(a.c_km_code, '_') = 0) A6
ON A.C_PORT_CODE = A6.C_PORT_CODE
left join (SELECT a.c_port_code, a.d_aststat, a.C_KM_NAME LJJZZZL
FROM t_r_fr_aststat a
where (( a.c_port_code='SCV923' or a.c_port_code='SEN276' or a.c_port_code='SGT579' or a.c_port_code='SJF165' or a.c_port_code='SJF167' or a.c_port_code='SJF173' or a.c_port_code='SJP873' or a.c_port_code='SJU990' or a.c_port_code='SJV284' or a.c_port_code='SNH141' or a.c_port_code='SY3798' or a.c_port_code='SGU520' or a.c_port_code='SQP322' or a.c_port_code='SSD770' ))
and a.d_aststat = GETDAY_HDAY('CN',LAST_DAY(date'2023-01-01')+1,-1,'W')
and a.c_key_code = 'LJJZZZL'
and instr(a.c_km_code, '_') = 0) A66
ON A.C_PORT_CODE = A66.C_PORT_CODE
left join (SELECT a.c_port_code, a.d_aststat, a.C_KM_NAME LJJZZZL
FROM t_r_fr_aststat a
where (( a.c_port_code='SCV923' or a.c_port_code='SEN276' or a.c_port_code='SGT579' or a.c_port_code='SJF165' or a.c_port_code='SJF167' or a.c_port_code='SJF173' or a.c_port_code='SJP873' or a.c_port_code='SJU990' or a.c_port_code='SJV284' or a.c_port_code='SNH141' or a.c_port_code='SY3798' or a.c_port_code='SGU520' or a.c_port_code='SQP322' or a.c_port_code='SSD770' ))
and a.d_aststat = GETDAY_HDAY('CN',TRUNC(date'2023-01-01','MM'),-1,'W')
and a.c_key_code = 'LJJZZZL'
and instr(a.c_km_code, '_') = 0) A666
ON A.C_PORT_CODE = A666.C_PORT_CODE
left join (
select a.c_port_code, sum(a.N_SELL_MONEY) N_SELL_MONEY1 from T_D_AC_SELL_TA a
where ( a.c_port_code='SCV923' or a.c_port_code='SEN276' or a.c_port_code='SGT579' or a.c_port_code='SJF165' or a.c_port_code='SJF167' or a.c_port_code='SJF173' or a.c_port_code='SJP873' or a.c_port_code='SJU990' or a.c_port_code='SJV284' or a.c_port_code='SNH141' or a.c_port_code='SY3798' or a.c_port_code='SGU520' or a.c_port_code='SQP322' or a.c_port_code='SSD770' )
and a.D_SELL = date
'2023-01-01'
and a.C_DS_CODE = 'TAXS_SG'
and a.N_CHECK_STATE = 1
group by a.c_port_code
) a7
ON A.C_PORT_CODE = A7.C_PORT_CODE
left join (
select a.c_port_code, sum(a.N_SELL_MONEY) N_SELL_MONEY2 from T_D_AC_SELL_TA a
where ( a.c_port_code='SCV923' or a.c_port_code='SEN276' or a.c_port_code='SGT579' or a.c_port_code='SJF165' or a.c_port_code='SJF167' or a.c_port_code='SJF173' or a.c_port_code='SJP873' or a.c_port_code='SJU990' or a.c_port_code='SJV284' or a.c_port_code='SNH141' or a.c_port_code='SY3798' or a.c_port_code='SGU520' or a.c_port_code='SQP322' or a.c_port_code='SSD770' )
and a.D_SELL = date
'2023-01-01'
and a.C_DS_CODE = 'TAXS_SH'
and a.N_CHECK_STATE = 1
group by a.c_port_code
) a8
ON A.C_PORT_CODE = A8.C_PORT_CODE
where ( a.c_port_code='SCV923' or a.c_port_code='SEN276' or a.c_port_code='SGT579' or a.c_port_code='SJF165' or a.c_port_code='SJF167' or a.c_port_code='SJF173' or a.c_port_code='SJP873' or a.c_port_code='SJU990' or a.c_port_code='SJV284' or a.c_port_code='SNH141' or a.c_port_code='SY3798' or a.c_port_code='SGU520' or a.c_port_code='SQP322' or a.c_port_code='SSD770' )
and a.N_CHECK_STATE = 1
at com.yss.sofa.report.engine.util.ScriptUtil$Db.data(ScriptUtil.java:120)
at com.yss.sofa.report.engine.util.ScriptUtil$Db$data.call(Unknown Source)
at NG_JJ_YZ_MRJZB__main__ds.run(NG_JJ_YZ_MRJZB__main__ds:196)
at com.yss.sofa.report.engine.util.ScriptUtil.execute(ScriptUtil.java:290)
... 70 more
Caused by: java.sql.SQLSyntaxErrorException: ORA-00904: "GETDAY_HDAY": invalid identifier
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:445)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:396)
at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:879)
at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:450)
at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:192)
at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:531)
at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:207)
at oracle.jdbc.driver.T4CPreparedStatement.executeForDescribe(T4CPreparedStatement.java:884)
at oracle.jdbc.driver.OracleStatement.executeMaybeDescribe(OracleStatement.java:1167)
at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1289)
at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3584)
at oracle.jdbc.driver.OraclePreparedStatement.executeQuery(OraclePreparedStatement.java:3628)
at oracle.jdbc.driver.OraclePreparedStatementWrapper.executeQuery(OraclePreparedStatementWrapper.java:1493)
at com.zaxxer.hikari.proxy.PreparedStatementProxy.executeQuery(PreparedStatementProxy.java:52)
at com.zaxxer.hikari.proxy.PreparedStatementJavassistProxy.executeQuery(PreparedStatementJavassistProxy.java)
at com.yss.sofa.report.engine.util.ScriptUtil$Db.data(ScriptUtil.java:100)
... 73 more