起步软件技术论坛
搜索
 找回密码
 注册

QQ登录

只需一步,快速开始

查看: 6846|回复: 3

[结贴] 报表查询报错

[复制链接]

9

主题

31

帖子

268

积分

中级会员

Rank: 3Rank: 3

积分
268
QQ
发表于 2022-1-12 16:34:14 | 显示全部楼层 |阅读模式
版本: 其它(帖子中说明) 小版本号: 3.8
数据库: MySQL 服务器操作系统: Windows 应用服务器: Tomcat
客户端操作系统: Windows 其它 浏览器: 其它(帖子中说明)
版本:Bex5V3.8  客户端操作系统:win10  浏览器:edge;下面是报错信息:
2022-01-12 14:03:05 [http-10001-7] [com.justep.business.server.BusinessServer] ERROR: action:<?xml version="1.0" encoding="UTF-8"?>
<action process="/tzxt/bb_tzxt/process/bb_ndtzwcqkhz/bb_ndtzwcqkhzProcess" activity="mainActivity" action-flag="__action_0__" executor="" execute-context="" name="ndtzwcqkhz_action"><parameters xmlns:xbiz="http://www.justep.com/xbiz#"><parameter name="zz"><xbiz:simple type="http://www.w3.org/2001/XMLSchema#String"/></parameter><parameter name="nd"><xbiz:simple type="http://www.w3.org/2001/XMLSchema#String">'2020'</xbiz:simple></parameter><parameter name="rzms"><xbiz:simple type="http://www.w3.org/2001/XMLSchema#String"/></parameter><parameter name="tzfx"><xbiz:simple type="http://www.w3.org/2001/XMLSchema#String"/></parameter><parameter name="dwfl"><xbiz:simple type="http://www.w3.org/2001/XMLSchema#String"/></parameter><parameter name="xmlx"><xbiz:simple type="http://www.w3.org/2001/XMLSchema#String"/></parameter><parameter name="cybk"><xbiz:simple type="http://www.w3.org/2001/XMLSchema#String"/></parameter><parameter name="myhz"><xbiz:simple type="http://www.w3.org/2001/XMLSchema#String"/></parameter><parameter name="ndgs"><xbiz:simple type="http://www.w3.org/2001/XMLSchema#String"/></parameter><parameter name="xmszd"><xbiz:simple type="http://www.w3.org/2001/XMLSchema#String"/></parameter><parameter name="gjdq"><xbiz:simple type="http://www.w3.org/2001/XMLSchema#String"/></parameter><parameter name="tzjeMin"><xbiz:simple type="http://www.w3.org/2001/XMLSchema#String"/></parameter><parameter name="tzjeMax"><xbiz:simple type="http://www.w3.org/2001/XMLSchema#String"/></parameter><parameter name="qyhf"><xbiz:simple type="http://www.w3.org/2001/XMLSchema#String"/></parameter><parameter name="cybkxf"><xbiz:simple type="http://www.w3.org/2001/XMLSchema#String"/></parameter><parameter name="tzlxxf"><xbiz:simple type="http://www.w3.org/2001/XMLSchema#String"/></parameter></parameters></action>
java.lang.reflect.InvocationTargetException
        at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
        at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
        at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
        at java.lang.reflect.Method.invoke(Method.java:497)
        at com.justep.system.action.Engine.invokeActions(Native Method)
        at com.justep.system.action.Engine.invokeActions(Unknown Source)
        at com.justep.business.server.BusinessServer.doAction(Unknown Source)
        at com.justep.business.server.BusinessServer.doExcute(Unknown Source)
        at com.justep.business.server.BusinessServer.excute(Unknown Source)
        at com.justep.business.server.BusinessServer.excute(Unknown Source)
        at com.justep.business.server.BusinessServerServlet.execService(Unknown Source)
        at com.justep.business.server.BusinessServerServlet.service(Unknown Source)
        at javax.servlet.http.HttpServlet.service(HttpServlet.java:723)
        at com.justep.x.bs.BusinessServerServlet.service(Unknown Source)
        at javax.servlet.http.HttpServlet.service(HttpServlet.java:723)
        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
        at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
        at com.jfkj.IgnoreError.ErrorFilter.doFilter(ErrorFilter.java:42)
        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
        at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
        at com.thetransactioncompany.cors.CORSFilter.doFilter(CORSFilter.java:168)
        at com.thetransactioncompany.cors.CORSFilter.doFilter(CORSFilter.java:233)
        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
        at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
        at com.justep.micro.service.MicroServiceFilter.doFilter(Unknown Source)
        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
        at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
        at com.thetransactioncompany.cors.CORSFilter.doFilter(CORSFilter.java:168)
        at com.thetransactioncompany.cors.CORSFilter.doFilter(CORSFilter.java:233)
        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.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:470)
        at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)
        at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:103)
        at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
        at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:293)
        at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:861)
        at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:606)
        at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:489)
        at java.lang.Thread.run(Thread.java:745)
Caused by: com.justep.exception.BusinessException: 编码: JUSTEP150039; 提示: 执行sql:         SELECT C.FZZTXMX_BJDW,A.FNDTZWCZB_TZND,A.FSSZZ,A.WCZSL,A.WCZJE,B.JHZJE,        A.WCZY_SL,A.WCZY_JE,B.JHZY_JE,        A.WCFZY_SL,A.WCFZY_JE,B.JHFZY_JE,        A.WCDWTZ_SL,A.WCDWTZ_JE,B.JHDWTZ_JE,        A.WCWJSFQ_SL,A.WCWJSFQ_JE,B.JHWJSFQ_JE,        A.WCWBSSJX_SL,A.WCWBSSJX_JE,B.JHWBSSJX_JE,        (CASE WHEN B.JHZY_JE=0 THEN NULL ELSE ROUND(A.WCZY_JE/B.JHZY_JE,2) END ) AS ZYBFB,        (CASE WHEN B.JHFZY_JE=0 THEN NULL ELSE ROUND(A.WCFZY_JE/B.JHFZY_JE,2) END) AS FZYBFB,        (CASE WHEN B.JHDWTZ_JE=0 THEN NULL ELSE ROUND(A.WCDWTZ_JE/B.JHDWTZ_JE,2) END)AS DWTZBFB,        (CASE WHEN B.JHWJSFQ_JE=0 THEN NULL ELSE ROUND(A.WCWJSFQ_JE/B.JHWJSFQ_JE,2) END)AS WJSFQYBFB,        (CASE WHEN B.JHWBSSJX_JE=0 THEN NULL ELSE ROUND(A.WCWBSSJX_JE/B.JHWBSSJX_JE,2)END) AS WBSSJXBFB,        (CASE WHEN B.JHZJE=0 THEN NULL ELSE ROUND(A.WCZJE/B.JHZJE,2)END) AS ZJEBFB        FROM (SELECT B.FSSZZ,B.FNDTZWCZB_TZND,         COUNT(C.FNDTZWCMX_XMID) AS WCZSL ,SUM(C.FNDTZWCMX_BNTZJE ) AS WCZJE ,         SUM(CASE A.FXMXX_TZFX WHEN '主业' THEN 1 ELSE 0 END) AS WCZY_SL ,        SUM(CASE  WHEN A.FXMXX_TZFX='主业'  THEN C.FNDTZWCMX_BNTZJE ELSE 0 END) AS WCZY_JE,        SUM(CASE A.FXMXX_TZFX WHEN '非主业' THEN 1 ELSE 0 END) AS WCFZY_SL,         SUM(CASE  WHEN A.FXMXX_TZFX='非主业' THEN C.FNDTZWCMX_BNTZJE ELSE 0 END) AS WCFZY_JE,        SUM(CASE  WHEN A.FXMXX_DQFL IN('省外','境外') THEN 1 ELSE 0 END) AS WCDWTZ_SL,         SUM(CASE  WHEN A.FXMXX_DQFL IN('省外','境外') THEN C.FNDTZWCMX_BNTZJE ELSE 0 END) AS WCDWTZ_JE,        SUM(CASE A.FXMXX_DQFL WHEN '皖江示范区' THEN 1 ELSE 0 END) AS WCWJSFQ_SL,         SUM(CASE  WHEN A.FXMXX_DQFL='皖江示范区' THEN C.FNDTZWCMX_BNTZJE ELSE 0 END) AS WCWJSFQ_JE,        SUM(CASE A.FXMXX_DQFL WHEN '皖北三市九县' THEN 1 ELSE 0 END)AS WCWBSSJX_SL,        SUM(CASE  WHEN A.FXMXX_DQFL='皖北三市九县' THEN C.FNDTZWCMX_BNTZJE ELSE 0 END) AS WCWBSSJX_JE        FROM TZ_XMXX A, TZ_NDTZWCZB B,TZ_NDTZWCMX C         WHERE  A.FXMXX_XMBM=C.FNDTZWCMX_XMBM AND B.FID=C.FNDTZWCMX_ZBID   AND A.FXMXX_ZXBB='是'AND B.FNDTZWCZB_DJZT IN ('通过','已提交')and substr(b.fsszzfid,-23,19) like  '%ORG01%'        AND A.FDATASTATE=0 AND B.FDATASTATE=0 AND C.FDATASTATE=0  AND A.FXMXX_ZXBB='是' GROUP BY A.FSSZZ,B.FNDTZWCZB_TZND ) A        LEFT JOIN         (SELECT E.FSSZZ,E.FNDTZJHZB_TZND,        SUM(F.FNDTZJHMX_NDTZJE ) AS JHZJE  ,        SUM(CASE  WHEN A.FXMXX_TZFX='主业' THEN F.FNDTZJHMX_NDTZJE ELSE 0 END) AS JHZY_JE,        SUM(CASE  WHEN A.FXMXX_TZFX='非主业' THEN F.FNDTZJHMX_NDTZJE ELSE 0 END) AS JHFZY_JE,        SUM(CASE  WHEN A.FXMXX_DQFL IN('省外','境外') THEN F.FNDTZJHMX_NDTZJE  ELSE 0 END) AS JHDWTZ_JE,         SUM(CASE  WHEN A.FXMXX_DQFL='皖江示范区' THEN F.FNDTZJHMX_NDTZJE  ELSE 0 END) AS JHWJSFQ_JE,         SUM(CASE  WHEN A.FXMXX_DQFL='皖北三市九县' THEN F.FNDTZJHMX_NDTZJE  ELSE 0 END) AS JHWBSSJX_JE        FROM TZ_XMXX A          INNER JOIN TZ_NDTZJHMX F ON F.FNDTZJHMX_XMBM=A.FXMXX_XMBM        INNER JOIN TZ_NDTZJHZB E ON E.FID=F.FNDTZJHMX_ZBID  WHERE 1=1 AND A.FXMXX_ZXBB='是' AND A.FDATASTATE=0 AND F.FDATASTATE=0 AND E.FDATASTATE=0 AND E.FNDTZJHZB_DJZT IN ('通过','已提交') and e.fNDTZJHZB_TZND in ('2020')         AND A.FDATASTATE=0 AND E.FDATASTATE=0 AND F.FDATASTATE=0        GROUP BY E.FSSZZ,E.FNDTZJHZB_TZND )B        ON A.FSSZZ=B.FSSZZ  RIGHT JOIN ( SELECT A.FZZTXMX_DWPX,A.FZZTXMX_BJDW,A.FZZTXMX_BJDWJC,B.FZZTXZB_ZZTXND FROM TZ_ZZTXMX A,TZ_ZZTXZB B WHERE A.FZZTXMX_ZBID=B.FID   AND b.FZZTXZB_ZZTXND in ('2020') )C ON A.FSSZZ = C.FZZTXMX_BJDW ORDER BY C.FZZTXMX_DWPX ASC,A.FNDTZWCZB_TZND DESC , binds: []出错
        at com.justep.exception.BusinessException.create(Unknown Source)
        at com.justep.system.data.SQL.select(Unknown Source)
        at com.justep.system.data.SQL.select(Unknown Source)
        at Bb_tzxt.ndtzwcqkhz_action(Bb_tzxt.java:4670)
        ... 42 more
Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: #42000
        at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
        at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62)
        at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
        at java.lang.reflect.Constructor.newInstance(Constructor.java:422)
        at com.mysql.jdbc.Util.handleNewInstance(Util.java:400)
        at com.mysql.jdbc.Util.getInstance(Util.java:383)
        at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:980)
        at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3847)
        at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3783)
        at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2447)
        at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2594)
        at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2545)
        at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:1901)
        at com.mysql.jdbc.PreparedStatement.executeQuery(PreparedStatement.java:2002)
        at org.apache.tomcat.dbcp.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:96)
        at org.apache.tomcat.dbcp.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:96)
        ... 45 more

SQL语句我查了没有问题。


91

主题

13万

帖子

3万

积分

管理员

Rank: 9Rank: 9Rank: 9

积分
35878
发表于 2022-1-12 19:29:17 | 显示全部楼层
   at com.justep.exception.BusinessException.create(Unknown Source)
        at com.justep.system.data.SQL.select(Unknown Source)
        at com.justep.system.data.SQL.select(Unknown Source)
        at Bb_tzxt.ndtzwcqkhz_action(Bb_tzxt.java:4670)
        ... 42 more
Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: #42000
        at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
        at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructor

报错是mysql报错,可以到网上查找这个错误信息的原因
远程的联系方法QQ1392416607,添加好友时,需在备注里注明其论坛名字及ID,公司等信息
发远程时同时也发一下帖子地址,方便了解要解决的问题  WeX5教程  WeX5下载



如按照该方法解决,请及时跟帖,便于版主结贴
回复 支持 反对

使用道具 举报

9

主题

31

帖子

268

积分

中级会员

Rank: 3Rank: 3

积分
268
QQ
 楼主| 发表于 2022-1-13 09:22:19 | 显示全部楼层
原因是MySQL的配置文件的问题,已解决,请结帖。
回复 支持 反对

使用道具 举报

9

主题

31

帖子

268

积分

中级会员

Rank: 3Rank: 3

积分
268
QQ
 楼主| 发表于 2022-1-13 09:22:57 | 显示全部楼层
头发日渐稀疏 发表于 2022-1-13 09:22
原因是MySQL的配置文件的问题,已解决,请结帖。

my.ini文件
回复 支持 反对

使用道具 举报

您需要登录后才可以回帖 登录 | 注册

本版积分规则

小黑屋|手机版|X3技术论坛|Justep Inc.    

GMT+8, 2024-3-29 01:40 , Processed in 0.055468 second(s), 25 queries .

Powered by Discuz! X3.4

© 2001-2013 Comsenz Inc.

快速回复 返回顶部 返回列表